next
previous
items

Most populated cities

Data table via SPARQL Published 31 Mar 2013 Last modified 12 Feb 2019
DBpedia example of cities with population within certain values

Download this dataset

Dataset preview

(Live Query)

subject city label latitude longitude maxPopulation rainyDays
<http://dbpedia.org/resource/Karachi> <http://dbpedia.org/resource/Karachi> "Karachi"@en "24.86"^^<http://www.w3.org/2001/XMLSchema#float> "67.01"^^<http://www.w3.org/2001/XMLSchema#float> "24300000"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Delhi> <http://dbpedia.org/resource/Delhi> "Delhi"@en "28.61"^^<http://www.w3.org/2001/XMLSchema#float> "77.23"^^<http://www.w3.org/2001/XMLSchema#float> "16314838"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Chengdu> <http://dbpedia.org/resource/Chengdu> "Chengdu"@en "30.6586"^^<http://www.w3.org/2001/XMLSchema#float> "104.065"^^<http://www.w3.org/2001/XMLSchema#float> "14297600"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Tokyo> <http://dbpedia.org/resource/Tokyo> "Tokyo"@en "35.6833"^^<http://www.w3.org/2001/XMLSchema#float> "139.683"^^<http://www.w3.org/2001/XMLSchema#float> "13506607"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Guangzhou> <http://dbpedia.org/resource/Guangzhou> "Guangzhou"@en "23.1333"^^<http://www.w3.org/2001/XMLSchema#float> "113.267"^^<http://www.w3.org/2001/XMLSchema#float> "13080500"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Shijiazhuang> <http://dbpedia.org/resource/Shijiazhuang> "Shijiazhuang"@en "38.0436"^^<http://www.w3.org/2001/XMLSchema#float> "114.483"^^<http://www.w3.org/2001/XMLSchema#float> "12763700"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Mumbai> <http://dbpedia.org/resource/Mumbai> "Mumbai"@en "18.975"^^<http://www.w3.org/2001/XMLSchema#float> "72.8258"^^<http://www.w3.org/2001/XMLSchema#float> "12442373"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Baoding> <http://dbpedia.org/resource/Baoding> "Baoding"@en "38.8667"^^<http://www.w3.org/2001/XMLSchema#float> "115.467"^^<http://www.w3.org/2001/XMLSchema#float> "11194379"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Harbin> <http://dbpedia.org/resource/Harbin> "Harbin"@en "45.75"^^<http://www.w3.org/2001/XMLSchema#float> "126.633"^^<http://www.w3.org/2001/XMLSchema#float> "10635971"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Shenzhen> <http://dbpedia.org/resource/Shenzhen> "Shenzhen"@en "22.55"^^<http://www.w3.org/2001/XMLSchema#float> "114.1"^^<http://www.w3.org/2001/XMLSchema#float> "10628900"^^<http://www.w3.org/2001/XMLSchema#integer> ""

Received 99 rows in 0.050 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/most-populated-cities/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://dbpedia.org/sparql

PREFIX o: <http://dbpedia.org/ontology/>
PREFIX p: <http://dbpedia.org/property/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>

SELECT ?subject (sql:SAMPLE(?subject) as ?city)
(sql:SAMPLE(?label) as ?label) 
(sql:SAMPLE(?latitude) as ?latitude) 
(sql:SAMPLE(?longitude) as ?longitude) 
 max(?populationTotal) as ?maxPopulation
 max(?rainyDays) as ?rainyDays
WHERE {
?subject a o:City.
?subject rdfs:label ?label.
OPTIONAL {?subject rdfs:comment ?abstract.}
?subject p:populationTotal ?populationTotal.
OPTIONAL {?subject geo:lat ?latitude.}
OPTIONAL {?subject geo:long ?longitude.}
OPTIONAL {?subject p:yearPrecipitationDays ?rainyDays.}
FILTER (lang(?label) = "en" && lang(?abstract) = "en" && (?populationTotal >= "5000000"^^xsd:integer && ?populationTotal < "60000000"^^xsd:integer))
}
GROUP BY ?subject
ORDER BY DESC(?maxPopulation)

Error when running query:

Query timeout. unknown url type: 


Permalinks

Document Actions