Skip to content

Instantly share code, notes, and snippets.

@bertbalcaen

bertbalcaen/Convert geometry from an OpenStreetMap Postgress database into GeoJSON

Created January 15, 2015 10:08
Show Gist options
  • Save bertbalcaen/f634e9841f6ea668e640 to your computer and use it in GitHub Desktop.
Save bertbalcaen/f634e9841f6ea668e640 to your computer and use it in GitHub Desktop.
Download ZIP
Convert geometry from an OpenStreetMap Postgress database into GeoJSON
Raw
Convert geometry from an OpenStreetMap Postgress database into GeoJSON
SELECT ST_AsGeoJSON(ST_Transform(geometry, 4326)), area FROM osm_buildings WHERE id = 1374;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment