GeoNames Forum

Hi everyone!

With the current outage of the free webservice, I was thinking about setting up some kind of GeoNames mirror for my own use. Thankfully, the database itself is available for download (as soon as the server's back up

), but what about some server scripts "around" the database? My favourite application queries the webservice, so the bare database wouldn't really help me as long as I wouldn't be able to emulate the HTTP service.
Are there any pre-made scripts available for this job? (PHP would be nice, but Perl or something similiar would be OK too.)

Regards,
Sebastian

I think you need to do a little research....

I'm importing part of the db into mysql (postGIS would be my first choice), and it's looking like it will be in the 2gig range.

Also search for 'Haversine Formula', once you understand that, then you can think about creating the webservice.

Bill

idbill wrote:

I think you need to do a little research....

Yeah, I've already stumbled accross some very promising older threads in the forum.

idbill wrote:

I'm importing part of the db into mysql (postGIS would be my first choice), and it's looking like it will be in the 2gig range.

Oops, that big? So much for my plan of developing and testing this on my home server.

idbill wrote:

Also search for 'Haversine Formula', once you understand that, then you can think about creating the webservice.

I'm currently a bit confused about this. From a logical point of view, this seems the only thing to do, but I'm very worried of the achievable performance of this, especially with the 2GB amount of data in mind. Maybe PG's functional indexes will help...
Anyhow, I'm currently waiting for the free webservice to come back up again, in order to get the db dump.

Regards,
Sebastian

I don't recall an actually 'db dump'.

look at

scroll to the bottom)
http://webcache.googleusercontent.com/search?q=cache:FQEdVKi5qBcJ:download.geonames.org/export/dump/countryInfo.txt+geonames+database+info&cd=4&hl=en&ct=clnk&gl=us&client=safari

I'm parsing the allCountries.txt file for my import, but it is missing all the wiki stuff (I'm assuming it is in the alternateNames.zip file).

If you know of an actually dump... that would be greatly appreciated.

Bill

I was refering to whatever can be found at http://download.geonames.org/export/dump/. If this isn't a "real" db dump, I'll try one of the import methods described in the forum.

Regards,
Sebastian