Created
January 9, 2012 21:21
-
-
Save kevinmcmahon/1584998 to your computer and use it in GitHub Desktop.
Updating the landmarks table to set the_geom column with POINT data.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE landmarks | |
SET the_geom = ST_GeomFromText('POINT(' || longitude || ' ' || latitude || ')',4326); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment