Created
October 24, 2012 18:23
-
-
Save patdevinwilson/3947862 to your computer and use it in GitHub Desktop.
Generating Centroids From planet_osm_polygon buildings
This file contains 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
## Creates osm-florida database and initializes postgis | |
osm2pgsql -c -d osm-florida florida.osm.bz2 -H localhost -P 5432 -U postgres | |
## Adds a new point geometry column in WGS_84 | |
SELECT AddGeometryColumn ('public','planet_osm_polygon', 'geom', '4326', 'POINT', 2) | |
## Populates the new 'geom' column with centroids of planet_osm_polygon in WGS84 | |
UPDATE planet_osm_polygon set geom = st_transform(st_centroid(way), 4326) | |
## Adds Lat and Long columns | |
ALTER table planet_osm_polygon add latitude float; | |
ALTER table planet_osm_polygon add latitude float | |
## Populates Lat and Long columns in decimal degress | |
UPDATE planet_osm_polygon set latitude=y(geom), longitude=x(geom); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment