PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?country
WHERE
{
?city gn:inCountry ?country .
?city gn:name ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city gn:featureCode geo:P.PPLC .
}
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?country
WHERE
{
?city gn:inCountry ?country .
?city gn:asciiname ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city gn:featureCode geo:P.PPLC .
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long
WHERE
{
?city gn:inCountry ?country .
?city gn:name ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city gn:featureCode geo:P.PPLC .
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?pname
WHERE
{
?city gn:inCountry ?country .
?city gn:name ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city geo:parentFeature ?parent .
?country gn:name ?cname
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?state
WHERE
{
?city gn:inCountry co:US .
?city gn:name ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city geo:parentFeature ?county .
?county geo:parentFeature ?state
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?state
WHERE
{
?city gn:inCountry co:US ;
gn:name ?name ;
wgs:lat ?lat ;
wgs:long ?long ;
gn:featureCode geo:P.PPL ;
geo:parentFeature ?county .
?county geo:parentFeature ?state
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?parent
WHERE
{
?city gn:inCountry co:US ;
gn:name ?name ;
wgs:lat ?lat ;
wgs:long ?long ;
gn:featureCode geo:P.PPL ;
geo:parentFeature ?parent .
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?parent
WHERE
{
?city gn:inCountry co:US .
?city gn:name ?name .
?city wgs:lat ?lat .
?city wgs:long ?long .
?city gn:featureCode geo:P.PPL .
?city geo:parentFeature ?parent .
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?parent2
WHERE
{
?city gn:inCountry co:US .
?city gn:name ?name .
?city gn:featureCode geo:P.PPL .
?city geo:parentFeature ?parent .
?parent geo:parentFeature ?parent2 .
}
PREFIX co: <http://www.geonames.org/countries/#>
PREFIX geo: <http://www.geonames.org/ontology#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?city ?name ?lat ?long ?parent2
WHERE
{
?city gn:inCountry co:US .
?city gn:name ?name .
?city gn:featureCode geo:P.PPL .
?city geo:parentFeature ?parent .
?parent geo:parentFeature ?parent2 .
}