GeoNames Forum

I tried to implement the flat file of all countries to a DB with the specifications givet in readme txt, but some longditutes and laditutes are not numeric, do we know why?

Hi Everybody,
I have a question regarding the binding box web services provided by geonames.
Does geonames provide any web service which accept binding box co-ordinates (north,south,east,west) to get postal codes or wiki entries within the box similar to cities web service

For example, geonames provide following web service for cities
http://ws.geonames.org/cities?north=44.1&south=-9.9&east=-22.4&west=55.2

Marc,

Thanks for your reply. Being somewhat new at geocoding I have been unclear in my question. Besides geocoding I am looking for a way to put geocoded namepalces and point of interest in relation to each other.

To make it clearer; I am for example at a tube station in London looking for hotels within walking distance of the tube station. I want to be able to query a database (or download references to add to a table in a MySQL DB) containing longitude and latitudes of places and points of interest and be able to build relationships between the points. Another problem is how to define areas like “Bayswater” and what is contained within.

Would appreciate any help or tips on how to solve this.

Per

Thanks, it is enough as it is now. I first tried rssToGeoRSS but it didn't work.

Is the source code for the RSS to GeoRSS process available?

Jim Bellenger
bellengj@nga.mil

I find strange that your recent changes don't have GeoRSS tags so that they can be represented in ACME GeoRSS.

found it thanks

style=LONG

I see that in your postal code section you can put in a code and hit submit and it will return the correct county associated with that postal code, which webservice does that? I looked at the examples of the once you have in your Download / Webservice section but I didnt see one that returned countys.

Thanks

What about places with coofficial languages?
Say, Donostia / San Sebastián.

There was also a piece in Slashdot that mentioned New Mexico but was coded as Mexico.

When checking the new feature of automatic GeoRSS, I see that in El País , news from Washington DC are assignated to the state of Washington.

Hello,

I would like to specify the request more precise, I get too many results at the moment:

If I ask for
http://ws.geonames.org/search?q=berlin&country=DE&maxRows=100&fclass=P

I also get all the PPLX entries, which I don't need and make firefox alert, that a javascript runs slowely.

Is there a way? Somethiung like fcode=PPL&fcode=PPLL or so?

best reagrds
joerg

well, for some reason the names returned by the SQL don't match the names in the admin1Codes.txt . For example, in Spain, the SQL returns what seem to be like longer versions of the region names

Comunidad Autonoma de Cataluna

while the corresponding entry in admin1Codes.txt is

Cataluña

The same happens in Philippines for example. While SQL returns

Province of Zambales

the entry in admin1Codes.txt is

Zambales

(I prefer the shorter names).

Anyway, thank you.

xavi

marc wrote:

The file I was referrering to is now available in the download section : http://download.geonames.org/export/dump/admin1Codes.txt
It contains the admin1codes and the name for each code.

Could you provide the ANSI name of the regions like you do for the cities?

xavi

hello marc

i'm vote for the iso code

i have think FL is the ISO Code of Fürstentum Liechtenstein.

best regards,
nenad

hi Marc,

after reading Thomas messages, now I realize that I can get all the regions by using something like...

SELECT * FROM geonames_places WHERE feature_code='ADM1'

Would this be the content of the file with all the regions that you said you would prepare? (by the way, I sent you a private message through this forum with my email address, not sure if you received it).

On the other hand, I think that now I understand better what you said the lack of 1-to-1 mapping between FIPS codes and ISO codes. For example, in Spain the FIPS codes correspond to the 17 regions of the country

select * from geonames_places where feature_code = 'ADM1' and country_code = 'ES';

But the ISO codes correspond to the 50 provinces of the country

http://www.geonames.org/ES/administrative-division-spain.html

Is this correct?
Thanks.

xavi

Hello

I think FL is more common then LI for Fürstentum Liechtenstein.
The ISO cod FL is used by Post and everywhere other. As i know LI is only used by TLD's.

Greets,
Nenad

Actually, I was asking for a file with all the region names, so that I could easily upload it to my database and then display the corresponding region name for a given city. As the cities file uses FIPS codes, the regions file should also use FIPS codes, so that I could match the cities info with the regions info.

In fact, I already have a file with all the regions, but I wondered if you had one that would probably match better with the geonames cities info.

Right now I don't have time for trying to come up with a solution to the FIPS - ISO migration, so I can't promise anything. Sorry about that.

Sorry, I didn't know they were both valid. I don't know which is more common, but in the the link I sent you in my previous message the code is GB, and in the the list reproduced in the Wikipedia entry for ISO 3166 is also GB, and there's a mention to the TLD, which is an exception because doesn't follow ISO
http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

Actually, I didn't know, but it seems that there was a .gb domain at some time

http://en.wikipedia.org/wiki/.gb

Also, the ISO 4217 code for the currency in the United Kingdom is GBP, and these codes are built using the ISO 3166 country codes, followed usually by the initial of the currency itself (in this case, the Pound).

Hi again,

just in case you're not aware of this... in the database dump (allCountries.zip), the admin1_code for the cities in the US is the ISO code (I think), but it's the FIPS code for the cities in all other countries.

On the other hand, I've seen in another message in this forum that you have the names of the administrative divisions of the countries (you gave the link to a page with the admin divisions of Norway). I was wondering if you also have a file (similar to allCountries.zip) with the administrative divisions of all countries. Is there such a file? May I download it?

Thanks again,

xavi