| Author |
Message |
|
|
I think the tricky part is how to maintain your data (how to add or change addresses) and how to search. Do you have full text search on all locales?
Joining two tables over the primary key is usually fast and not problematic.
Best
Marc
|
 |
|
|
Thanks. I have fixed it and I will delete the duplicate entry 'Marche-en-Famenne Marche-en-Famenne'.
Best
Marc
|
 |
|
|
Justin
The relation is not yet included in the dump. The information in the webservice was generated with reverse geocoding every pplx and finding the most appropriate ppl nearby.
A dump is available here:
http://download.geonames.org/ppl_pplx.csv.gz
Best
Marc
|
 |
|
|
Jon
You are right. It should be PE. We have fixed it.
Best
Marc
|
 |
|
|
It is a geographical decision, not a political one. The geographical border between Europe and Asia is the Bosporus. According to this 97% of Turkey is in Asia and only 3% in Europe.
GeoNames lists two populated places with the name 'Dalyan', one in Çanakkale Procince and the other in Muğla:
http://www.geonames.org/317678/dalyan.html
http://www.geonames.org/317681/dalyan.html
Best
Marc
|
 |
|
|
It is here, isn't it?
http://www.geonames.org/postalcode-search.html?q=Montague+C0A
GeoNames only has the FSA for Canada, the first three letters.
Best
Marc
|
 |
|
|
There is a data dump and there are web services:
http://www.geonames.org/export/
it is your choice.
Marc
|
 |
|
|
The file admin1Codes.txt includes obsolete codes, they are no longer in the database but the codes are still listed in the file in case you find the code somewhere and want to know what it was.
Marc
|
 |
|
|
The difference is that VI is modeled as ADMD (administrative division) whereas VG is a PCLD (dependent political entity).
Maybe it would make sense to model the US dependencies as PCLD too. What do you think?
Best
Marc
|
 |
|
|
Manhattan is modeled as an alternate name to "New York County". It cannot be underneath it when it is the same entity.
Best
Marc
|
 |
|
|
Hi
AS depends on the US, but we have recently decided to use the admin1code and the countrycode to be the same for those countries (Puerto Rico, Guam, etc).
These countries will be fixed with the next dump.
For some other regions it is because we simply don't know or because a lower level division does not have a higher level division for historical reasons.
Best
Marc
|
 |
|
|
I have the impression a lot of work is waiting for you
|
 |
|
|
Thanks. You are right there is something amiss with the web service. We expect to fix it in about a week.
Best
Marc
|
 |
|
|
Mike
For countries it is available in the countryinfo file:
http://download.geonames.org/export/dump/countryInfo.txt
For admin divisions it is not yet available. It would be possible to add it to the admin info files or adding a new column to the main toponym record. The later has the advantage that it would be easy to make the field editable. The disadvantage would be that is requires a change in the table structure (new column) and thus break compatibility of existing load scripts.
Best
Marc
|
 |
|
|
Thanks. I have removed the wrong entries for Bangladesh they will disappear with the next dump tomorrow. They came from mixing up fips country codes with iso country codes. BG stands for Bangladesh in Fips but for Bulgaria in ISO.
Best
Marc
|
 |
|
|
I have removed the line feed, hope this solves your problem.
Best
Marc
|
 |
|
|
I fear it is not as simple as that. For the US for instance there are counties between cities and states, at the other hand zip codes may cross counties and cities.
For most countries the administrative divisions have grown over the centuries, the US is a rather young country and it is therefore more structured than in most other countries.
A nice source for this kind of information is http://statoids.com/
Best
Marc
|
 |
|
|
The find nearby street segment service returns a list of street segments.
For the address service it wouldn't make much sense as the actual house number is an interpolation from fromHouseNumber and toHouseNumber of the closest street segment.
Best
Marc
|
 |
|
|
Hi Kamm
'00' means more or less 'we don't now', the same as no code at all. Better would be to find a useful value for the code.
Ceuta and Melilla play a strange role in Spain, they are neither real provinces nor real municipios, they are something in between. Sometimes they are more like provinces sometimes they are more like municipios.
Best
Marc
|
 |
|
|
Kamm
The files are usually exported in the morning GMT. The exact time depends on the load on the server and may vary. If you schedule it after noon GMT then it will always have finished.
Best
Marc
|
 |
|
|