bertbalcaen/gist:9f2731f61f9680e3cc67

Created January 14, 2015 18:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/bertbalcaen/9f2731f61f9680e3cc67.js"></script>
Save bertbalcaen/9f2731f61f9680e3cc67 to your computer and use it in GitHub Desktop.

Download ZIP

Convert geometry from an OpenStreetMap Postgress database into latitude/longitude

Raw

gistfile1.sql

	SELECT name, ST_Y(ST_Transform(geometry, 4326)) AS lat, ST_X(ST_Transform(geometry, 4326)) AS long
	FROM osm_places;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment