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 -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
