|
Hello! We have saved the geonames in AllegroGraph as N-triple format. I would like to build SPARQL 1. to get the all the countries 2. to get all cities from a country I look forward for your answers. Thanks. Regards, Florin |
|
On one my colleague developed this query for getting the countries from geonames. Hope that will help others. Regards, Florin
|


Welcome
Could you be more specific? What queries have you tried? What results are you getting? Where exactly are you having difficulties?
1.In geonames is difficult to identify which predicate and which object identifies a country (see my answer) 2. I don't know if there is any documenation on geonames that explains the meaning of the given featureCodes. For example A.PCLI denotes country. What code (if any denotes a city?)
@SemanticWeb They appear to have a fairly comprehensive documentation on what feature codes mean - http://www.geonames.org/export/codes.html - They do not appear to have a specific code for city,
PPLis the general code for any populated place.