Skip to content

Instantly share code, notes, and snippets.

@mhkeller

mhkeller/gist:5230844

Last active December 15, 2015 08:29
Download ZIP

Revisions

  1. mhkeller renamed this gist Mar 24, 2013. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → gistfile1.sql
    View file
    File renamed without changes.
  2. mhkeller created this gist Mar 24, 2013.
    1 change: 1 addition & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    SELECT ST_X(ST_Centroid(the_geom)) as longitude, ST_Y(ST_Centroid(the_geom)) as latitude FROM table