http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net http://forum.geonames.org/gforum/posts/list/1337.page#5602 http://forum.geonames.org/gforum/posts/list/1337.page#5602 GMT http://forum.geonames.org/gforum/posts/list/1337.page#5604 http://forum.geonames.org/gforum/posts/list/1337.page#5604 GMT lat & long (if found) I thought it might not be as simple as one select statement. How many would you say? Can you give me an idea of what the process is like? Any chance I can have some code/sql examples? I am not even daunted by thousands of lines of code... I'm adventurous and properly motivated. :)]]> http://forum.geonames.org/gforum/posts/list/1337.page#5608 http://forum.geonames.org/gforum/posts/list/1337.page#5608 GMT http://forum.geonames.org/gforum/posts/list/1337.page#5618 http://forum.geonames.org/gforum/posts/list/1337.page#5618 GMT http://forum.geonames.org/gforum/posts/list/1337.page#5655 http://forum.geonames.org/gforum/posts/list/1337.page#5655 GMT http://forum.geonames.org/gforum/posts/list/1337.page#5662 http://forum.geonames.org/gforum/posts/list/1337.page#5662 GMT http://forum.geonames.org/gforum/posts/list/1337.page#5663 http://forum.geonames.org/gforum/posts/list/1337.page#5663 GMT