GeoNames Forum

We are interested in using the service findNearestAddress.

We do about 20,000 lookups a day so we want to integrate our own LINUX server for this purpose. I have read and seen the guides in the forums on how to dump the raw data into mysql, but how do you replicate the functionally of the findNearestAddress function? Is there a perl or php script? Or is it a simple query like:

SELECT address, city, state, zip, country FROM gis_data WHERE lat = 22.22 AND long = 33.33

Which does not require any processing.

Thanks.

Also, which dump file(s) do I need from:

http://download.geonames.org/export/dump/

Do I just need the US.zip file?

Hi Justin

The data for the address reverse geocoding is not included in the dump. It would bee too large (several GB) and addresses are not the main topic of this project. What is included in the dump are the editable places.

The data for the address reverse geocoding is from the US Census and it needs a spatially enabled database to achieve acceptable performance. We are using postgres/postgis.

Cheers

Marc

Marc,

Are you able to provide the data needed to preform findNearestAddress? We would probably want to use MySQL, I was under the impression the MySQL 5 support spatial tables.

Hi Justin

Sure, I can help you with the data and the code for address reverse geocoding in the form of a consulting service. My email is marc@geonames.org
Postgres has much more sophisticated spatial support then MySQL, though it is possible to run it with MySQL.

Cheers

Marc