As I promised earlier, I’ve downloaded earthquakes from NCEDC’s web site (1898 to date), reverse-geocoded them via GeoNames and K-D Trees (thereby obtaining their country, state, county, and city/village values), archived the resulting files via 7-ZIP and uploaded both the CSV and SQLite datasets to:
- pipe-separated values, approximately 67 MB in size
- SQLite 3 database, approximately 208 MB in size
I have authored a program in Python 3 that reverse-geocodes (via GeoNames and K-D Trees) the lat/longs into their respective countries, states, counties, and cities/villages. I will post a link to the open-source project shortly once I’ve vetted its license and repository. The program processes nearly 3 million rows in approximately 240 seconds.