search

simplegeo / geocoder

Modular Street Address Geocoder
http:///www.geocommons.com
45 stars 6 forks source link

tiger_import issues #6

Open gpearson opened 13 years ago

gpearson commented 13 years ago

When running the tiger_import for the TigerLine 2010 data, no information is stored in the place table. I have the entire Tiger2010 files/directories on this server and have created the database 6 times without any errors.

If I perform select * from place on the 4Gig database file, it would result in 0 records. I am trying to modify the script to import this information but not sure at this time.

gpearson commented 13 years ago

In working with this manually via command line, I have extraced one of the tl_2010_78_places10.zip archive into a directory. I then ran shp2sqlite tl_2010_78_places10.shp which spews sql statements on the screen. Just needing to figure out how to write it to a file or import it into the places table of the database.