Skip to content

Instantly share code, notes, and snippets.

@mhkeller
Last active December 15, 2015 08:29
Lat and Lng from geom
SELECT ST_X(ST_Centroid(the_geom)) as longitude, ST_Y(ST_Centroid(the_geom)) as latitude FROM table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment