er zit al data in van <a href="http://geonames.org">geonames.org</a>, zie de nodes uit <a href="http://www.informationfreeway.org/api/0.5/node[source=geonames.org]">http://www.informationfreeway.org/api/0.5/node[source=geonames.org]</a><br>
<br>zie ook de info op: <a href="http://wiki.openstreetmap.org/wiki/Geonames">http://wiki.openstreetmap.org/wiki/Geonames</a><br><b>Note: <a href="http://www.geonames.org">www.geonames.org</a> data is probably a derived work of Google Maps and is therefore not suitable for import in OSM</b><br>
<br><br><div class="gmail_quote">2009/1/11 robin ketelaars <span dir="ltr"><<a href="mailto:robin@ketelaars.com">robin@ketelaars.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
ik stuitte op de volgende site (via linkedin postcode selectie bij zoeken)<br>
<br>
<a href="http://www.geonames.org/export/" target="_blank">http://www.geonames.org/export/</a><br>
<br>
met veel zaken te downloaden:<br>
<br>
<a href="http://www.geonames.org/export/" target="_blank">http://www.geonames.org/export/</a><br>
<br>
miscchien zit daar nog leuke info bij voor OSM:<br>
<br>
<a href="http://download.geonames.org/export/dump/" target="_blank">http://download.geonames.org/export/dump/</a><br>
<br>
<br>
Readme for Geonames.org :<br>
=========================<br>
<br>
This work is licensed under a Creative Commons Attribution 3.0 License,<br>
see <a href="http://creativecommons.org/licenses/by/3.0/" target="_blank">http://creativecommons.org/licenses/by/3.0/</a><br>
The Data is provided "as is" without warranty or any representation of<br>
accuracy, timeliness or completeness.<br>
<br>
The data format is tab-delimited text in utf8 encoding.<br>
<br>
<br>
Files :<br>
-------<br>
XX.zip : features for country with iso code XX<br>
allCountries.zip : all countries combined in one file.<br>
cities1000.zip : all cities with a population > 1000 (ca 80.000)<br>
cities5000.zip : all cities with a population > 5000 (ca 40.000)<br>
cities15000.zip : all cities with a population > 15000 (ca 20.000)<br>
alternateNames.zip : two files, alternate names with language<br>
codes and geonameId, file with iso language codes<br>
admin1Codes.txt : names for administrative subdivision 'admin1<br>
code' (UTF8), the code '00' stands for 'unkown code', includes obsolete<br>
codes<br>
admin1CodesASCII.txt : ascii names of admin divisions. (beta ><br>
<a href="http://forum.geonames.org/gforum/posts/list/208.page#1143" target="_blank">http://forum.geonames.org/gforum/posts/list/208.page#1143</a>)<br>
admin2Codes.txt : names for administrative subdivision 'admin2<br>
code' (UTF8), Format : concatenated codes <tab>name <tab> asciiname<br>
<tab> geonameId<br>
iso-languagecodes.txt : iso 639 language codes, as used for alternate<br>
names in file alternateNames.zip<br>
featureCodes.txt : name and description for feature classes and<br>
feature codes<br>
timeZones.txt : timezoneId, gmt offset on 1st of January, dst<br>
offset to gmt on 1st of July (of the current year)<br>
countryInfo.txt : country information : iso codes, fips codes,<br>
languages, capital ,...<br>
see the geonames webservices for additional<br>
country information,<br>
bounding box :<br>
<a href="http://ws.geonames.org/countryInfo" target="_blank">http://ws.geonames.org/countryInfo</a>?<br>
country names in different languages :<br>
<a href="http://ws.geonames.org/countryInfoCSV?lang=itmodifications-" target="_blank">http://ws.geonames.org/countryInfoCSV?lang=it<br>
modifications-</a><date>.txt : all records modified on the previous day, the<br>
date is in yyyy-MM-dd format. You can use this file to daily synchronize<br>
your own geonames database.<br>
deletes-<date>.txt : all records deleted on the previous day,<br>
format : geonameId <tab> name <tab> comment.<br>
<br>
alternateNamesModifications-<date>.txt : all alternate names modified on<br>
the previous day,<br>
alternateNamesDeletes-<date>.txt : all alternate names deleted on<br>
the previous day, format : alternateNameId <tab> geonameId <tab> name<br>
<tab> comment.<br>
userTags.zip : user tags , format : geonameId <tab> tag.<br>
<br>
<br>
The main 'geoname' table has the following fields :<br>
---------------------------------------------------<br>
geonameid : integer id of record in geonames database<br>
name : name of geographical point (utf8) varchar(200)<br>
asciiname : name of geographical point in plain ascii<br>
characters, varchar(200)<br>
alternatenames : alternatenames, comma separated varchar(4000)<br>
(varchar(5000) for SQL Server)<br>
latitude : latitude in decimal degrees (wgs84)<br>
longitude : longitude in decimal degrees (wgs84)<br>
feature class : see <a href="http://www.geonames.org/export/codes.html" target="_blank">http://www.geonames.org/export/codes.html</a>, char(1)<br>
feature code : see <a href="http://www.geonames.org/export/codes.html" target="_blank">http://www.geonames.org/export/codes.html</a>,<br>
varchar(10)<br>
country code : ISO-3166 2-letter country code, 2 characters<br>
cc2 : alternate country codes, comma separated, ISO-3166<br>
2-letter country code, 60 characters<br>
admin1 code : fipscode (subject to change to iso code), isocode<br>
for the us and ch, see file admin1Codes.txt for display names of this<br>
code; varchar(20)<br>
admin2 code : code for the second administrative division, a<br>
county in the US, see file admin2Codes.txt; varchar(80)<br>
admin3 code : code for third level administrative division,<br>
varchar(20)<br>
admin4 code : code for fourth level administrative division,<br>
varchar(20)<br>
population : integer<br>
elevation : in meters, integer<br>
gtopo30 : average elevation of 30'x30' (ca 900mx900m) area in<br>
meters, integer<br>
timezone : the timezone id (see file timeZone.txt)<br>
modification date : date of last modification in yyyy-MM-dd format<br>
<br>
<br>
<br>
The table 'alternate names' :<br>
-----------------------------<br>
alternateNameId : the id of this alternate name, int<br>
geonameid : geonameId referring to id in table 'geoname', int<br>
isolanguage : iso 639 language code 2- or 3-characters;<br>
4-characters 'post' for postal codes and 'iata' or 'icao' for airport<br>
codes, fr-1793 for French Revolution names, varchar(7)<br>
alternate name : alternate name or name variant, varchar(200)<br>
isPreferredName : '1', if this alternate name is an official/preferred<br>
name<br>
isShortName : '1', if this is a short name like 'California' for<br>
'State of California'<br>
<br>
<br>
Remark : the field 'alternatenames' in the table 'geoname' is a short<br>
version of the 'alternatenames' table. You probably don't need both.<br>
If you don't need to know the language of a name variant, the field<br>
'alternatenames' will be sufficient. If you need to know the language<br>
of a name variant, then you will need to load the table 'alternatenames'<br>
and you can drop the column in the geoname table.<br>
<br>
<br>
<br>
Statistics on the number of features per country and the feature class<br>
and code distributions : <a href="http://www.geonames.org/statistics/" target="_blank">http://www.geonames.org/statistics/</a><br>
<br>
<br>
Continent codes :<br>
AF : Africa geonameId=6255146<br>
AS : Asia geonameId=6255147<br>
EU : Europe geonameId=6255148<br>
NA : North America geonameId=6255149<br>
OC : Oceania geonameId=6255151<br>
SA : South America geonameId=6255150<br>
AN : Antarctica geonameId=6255152<br>
<br>
<br>
If you find errors or miss important places, please do use the<br>
wiki-style edit interface on our website<br>
<a href="http://www.geonames.org" target="_blank">http://www.geonames.org</a> to correct inaccuacies and to add new records.<br>
Thanks in the name of the geonames community for your valuable contribution.<br>
<br>
<br>
More Information is also available in the geonames faq :<br>
<br>
<a href="http://forum.geonames.org/gforum/forums/show/6.page" target="_blank">http://forum.geonames.org/gforum/forums/show/6.page</a><br>
<br>
The forum : <a href="http://forum.geonames.org" target="_blank">http://forum.geonames.org</a><br>
<br>
or the google group : <a href="http://groups.google.com/group/geonames" target="_blank">http://groups.google.com/group/geonames</a><br>
<br>
<br>
_______________________________________________<br>
Talk-nl mailing list<br>
<a href="mailto:Talk-nl@openstreetmap.org">Talk-nl@openstreetmap.org</a><br>
<a href="http://lists.openstreetmap.org/listinfo/talk-nl" target="_blank">http://lists.openstreetmap.org/listinfo/talk-nl</a><br>
</blockquote></div><br>