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