city_country_populatio_coordinates.sparql

PREFIX fb: <http://rdf.freebase.com/ns/>
SELECT DISTINCT ?cityname ?countryname ?popcount ?latitude ?longitude WHERE {
  ?citytype fb:type.object.name "City/Town/Village"@en .
  ?city fb:type.object.type ?citytype .
  ?city fb:type.object.name ?cityname .

  ?city fb:location.location.containedby ?country .

  ?city fb:location.statistical_region.population ?population .
  ?population fb:measurement_unit.dated_integer.number ?popcount .

  ?city fb:location.location.geolocation ?geolocation .
  ?geolocation fb:location.geocode.latitude ?latitude .
  ?geolocation fb:location.geocode.longitude ?longitude .

  ?country fb:type.object.name ?countryname .
  ?country fb:type.object.type ?countrytype .
  ?countrytype fb:type.object.name "Country"@en .
}
LIMIT 100