User:Planemad/sandbox/GIS

POSTGIS

• Manual: http://postgis.net/docs/manual-1.5/index.html
• http://www.postgresql.org/docs/current/interactive/index.html

Basics

Username = postgres;

createuser -U postgres -P -s Me
psql -U postgres
osm2pgsql -c -G -U postgres -d osm -S ~/Documents/GIS/Tools/Scripts/osm2pgsql/default.style ~/Downloads/india.osm.pbf

Export

\copy (select admin_level,place,name from planet_osm_point where name is not null and place = 'city' or place ='town') to '/Users/Me/Documents/osm-places.csv' csv

geojson http://www.smartjava.org/content/using-d3js-visualize-gis

d3/topojson http://bost.ocks.org/mike/map/

d3 http://alignedleft.com/tutorials/d3/