chalobest / ChaloBEST

Social Transport and Sustainable Mobility in Greater Mumbai
http://dev.chalobest.in
10 stars 15 forks source link

code changes for Nov 2012 import #165

Closed johnsonc closed 11 years ago

johnsonc commented 11 years ago

Well, the

Primary cleaned csv files are in /home/johnson/shared/chalobest/db_csv_files/

Kindly use this for immediate testing: Create a database with existing chalobest template, all the postgis stuff should be also imported..

then fire up the django shell and: from imports import data_mapper as dm dm.CsvLoader('Road') dm.CsvLoader('Area') dm.CsvLoader('Route') dm.CsvLoader('Stop')

There were some schema differences with the earlier data, the Nov2012 dataset did not have the StopMaster did not have (chowki, depot). both are null as of now and the code was tweaked to allow that(no db schema changes).. The functions incrementally update.. so :+1:

Atlas and the fix_missing values code, and some misc functions are what remain.