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