CSV2POSTGRES

Intelligently creates schemas for and imports the contents of CSV files.

# createdb mydb
# wget https://github.com/wnyc/csv2postgres/blob/master/examples/tbl_crashes_1995_2009_20111020_sample.csv.gz?raw=true | gzip -dc | http://csv2postgres --connection="db=mydb" --table='tbl_crashes'

Known good datasets

• Transportation Alternative's geocoded and cleaned crash data
• NYC Opendata's
  • Parking regulation street segment
  • Parking regulation sign locations