Skip to content

Instantly share code, notes, and snippets.

@bertday

bertday/872041725db8_make_state_plane.py

Created March 24, 2016 15:19
Show Gist options
  • Save bertday/7f256bb6db8084058d13 to your computer and use it in GitHub Desktop.
Save bertday/7f256bb6db8084058d13 to your computer and use it in GitHub Desktop.
Download ZIP
Alembic migration to change PostGIS geometry SRID
Raw
872041725db8_make_state_plane.py
"""Make State Plane
Revision ID: 872041725db8
Revises: 685d969dbc0e
Create Date: 2016-03-23 15:46:13.297247
"""
# revision identifiers, used by Alembic.
revision = '872041725db8'
down_revision = '685d969dbc0e'
from alembic import op
import sqlalchemy as sa
import geoalchemy2
def upgrade():
op.execute("ALTER TABLE street_segment ALTER COLUMN geom TYPE geometry(LINESTRING,2272) USING ST_SetSrid(geom, 2272);")
def downgrade():
op.execute("ALTER TABLE street_segment ALTER COLUMN geom TYPE geometry(LINESTRING,4326) USING ST_SetSrid(geom, 4326);")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment