London Stations from http://www.doogal.co.uk/london_stations.php ogr2ogr -f "ESRI Shapefile" london_tube_lines "London tube Lines.kml" -nln london_tube_lines -- to go straight ogr2ogr -f "PostgreSQL" PG:"host=localhost user=postgres port=5439 dbname=workshop_1 password=whatever" "London tube Lines.kml" -nln data.london_tube_lines -lco GEOMETRY_NAME=geom World data world_cities - http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip SET PATH=%PATH%;C:/Program Files/PostgreSQL/9.4/bin SET PGUSER=postgres SET PGPASSWORD=whatever SET PGHOST=localhost SET PGPORT=5432 SET PGDATABASE=workshop_1 # load into geography shp2pgsql -D -I -t 2D -s 4326 -G ne_10m_populated_places data.world_cities | psql -d workshop_1 US States - ftp://ftp2.census.gov/geo/tiger/TIGER2014/STATE/tl_2014_us_state.zip shp2pgsql -D -I -t 2D -s 4269 tl_2014_us_state data.us | psql -d workshop_1 # http://www.dot.ca.gov/hq/tsip/gis/datalibrary/Metadata/BART_13.html (routes and stations) shp2pgsql -D -I -t 2D -s 4269 BART_13 data.bart | psql -d workshop_1 shp2pgsql -D -I -t 2D -s 4269 BART_Sta_13 data.bart_stations | psql -d workshop_1 #building footprints https://data.sfgov.org/Geographic-Locations-and-Boundaries/Building-Footprints-Zipped-Shapefile-Format-/jezr-5bxm CA SP Ft - NAD_1983_StatePlane_California_III_FIPS_0403_Feet shp2pgsql -D -I -s 2227 building_footprint data.sfo_buildings | psql -d workshop_1 Latitude: 37.775 Longitude: -122.4183333 shp2pgsql -I -S -s 4326:2227 NHS_Map21 data.highways | psql #load chicago tiger geocoder data (do not do this until after you have installed postgis_tiger_geocode extension) #if you want to play with another state refer to ( http://postgis.net/docs/manual-dev/postgis_installation.html#install_tiger_geocoder_extension ) #extract tiger_data_chic.sql.bz2 (to .sql) psql -c "CREATE EXTENSION fuzzystrmatch SCHEMA contrib; CREATE EXTENSION postgis_tiger_geocoder;" workshop_1 psql -f tiger_data_chic.sql workshop_1 #for 3d queries - make sure already created data schema #we'll be using https://github.com/robe2/node_postgis_express to view these in 3D psql -f data_sfo_3dbuildings.sql workshop_1