GeoNames Forum

Is there a dump available from Geonames where I can calculate the country code of a lon/lat?

I want it to work exactly the same as the geonames method, but dont want to waste time by calling out to Geonames.

I would like to be able to calculate it in SQL using a lookup table.

Can someone offer any advice on this?

Thanks

Stu

I think this would be a great way of saving calls (and time) to the FindNearestAddress web service, such that if Lat+Long is outside the US, for example, where FindNearestAddress is not available (yet ?), then don't do the call to the WS because no data will be returned.

Hi ealessio,

My actual issue is where I have a large number of places geoencoded - some may be geoencoded badly and a UK place appear in the US for instance, so when searching in the US, I may also see a place in the results from the UK.

Next to each of my "places" in the database I do have a country code field.

I wanted to find the country code of the lon/lat values I am searching for to filter out any erroneous data from my results set. Of course one resolution is to fix all the bad data, but in the short term this isnt feasible.

Any further advice would be greatful!

Thanks
Stu