POSTGIS

edit

Basics

edit

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

edit
\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/