Published at LXer:

Geoscience Australia has a freely downloadable gazetteer of Australian placenames with more than 370 000 entries. The download is a .zip file (83 mb) containing a user guide together with placenames data in GML, KML and Microsoft Access (.mdb) formats.What I wanted from all that data was a simple table. Each row would have one placename, its latitude, its longitude, and maybe some other useful items, like the State or Territory in which the place was located. After inspecting the downloaded .zip file, I built the table in a few minutes using GNU/Linux shell commands.

Read More...