On 4/9/09, P Kishor <punk.k...@gmail.com> wrote: > On Thu, Apr 9, 2009 at 6:23 PM, Kelly Jones <kelly.terry.jo...@gmail.com> > wrote: >> Given how cool SQLite is, has anyone created SQLite dbs of geonames, >> tycho2, or other large data sets that are available for download via >> FTP, HTTP, Torrent or similar mechanism? >> >> I realize I could dl the raw data, create tables, import the data, >> create indexes, etc, but it's much faster just to download a single >> platform-independant file that does all that for me already! > > http://www.geonames.org/export/ > > a simple text file. .import it into your sqlite3 db as you wish
I tried that, and wish it were that simple. Problems: % No indexes + indexes take a LONG time to create (it's a lot of data) % I know http://download.geonames.org/export/dump/allCountries.zip has data for all countries, but it doesn't have counties, states, alternate names, and other info. % I downloaded the other text files and created tables from them too, but that's more tables and more indexes I have to create. % I created a view that joins placename to its admin2code to its admin1code, etc, and indexes to do the joins efficiently, but, again more work. I was going to do even more w/ this: http://groups.google.com/group/geonames/browse_thread/thread/417555edd150f839/4\ 4ef4238d41b2cb1 but why re-invent the wheel. SQLite is the perfect tool to allow people to share true databases (indexes, view, etc), not just data. -- We're just a Bunch Of Regular Guys, a collective group that's trying to understand and assimilate technology. We feel that resistance to new ideas and technology is unwise and ultimately futile. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
