Skip to content

Instantly share code, notes, and snippets.

@corbanb

corbanb/postgis.md

Last active August 29, 2015 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save corbanb/c34908b41dcb74d46085 to your computer and use it in GitHub Desktop.
Save corbanb/c34908b41dcb74d46085 to your computer and use it in GitHub Desktop.
Download ZIP
Heroku Postgres Helpers
Raw
postgis.md

Reverse geometry cords

Sets points lat,lng to lng,lat which is the prefferred format for postgis

UPDATE "Locations" SET geo = point(geo[1], geo[0]);

Export single table data

$ pg_dump -t '"Locations"' luncher-server > locations.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment