next
previous
items

Data table via SPARQL

Most populated cities

Data table via SPARQL Published 31 Mar 2013 Last modified 13 Jan 2021
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/Greater_Tokyo_Area> <http://dbpedia.org/resource/Greater_Tokyo_Area> "Greater Tokyo Area"@en "35.6897"^^<http://www.w3.org/2001/XMLSchema#float> "139.692"^^<http://www.w3.org/2001/XMLSchema#float> "38140000"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Shanghai> <http://dbpedia.org/resource/Shanghai> "Shanghai"@en "31.2286"^^<http://www.w3.org/2001/XMLSchema#float> "121.475"^^<http://www.w3.org/2001/XMLSchema#float> "24281400"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Beijing> <http://dbpedia.org/resource/Beijing> "Beijing"@en "39.9067"^^<http://www.w3.org/2001/XMLSchema#float> "116.397"^^<http://www.w3.org/2001/XMLSchema#float> "21542000"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Greater_Los_Angeles> <http://dbpedia.org/resource/Greater_Los_Angeles> "Greater Los Angeles"@en "34.0"^^<http://www.w3.org/2001/XMLSchema#float> "-117.9"^^<http://www.w3.org/2001/XMLSchema#float> "18788800"^^<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> "16787941"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Chengdu> <http://dbpedia.org/resource/Chengdu> "Chengdu"@en "30.657"^^<http://www.w3.org/2001/XMLSchema#float> "104.066"^^<http://www.w3.org/2001/XMLSchema#float> "16330000"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Istanbul> <http://dbpedia.org/resource/Istanbul> "Istanbul"@en "41.0136"^^<http://www.w3.org/2001/XMLSchema#float> "28.955"^^<http://www.w3.org/2001/XMLSchema#float> "15519267"^^<http://www.w3.org/2001/XMLSchema#integer> "129"^^<http://www.w3.org/2001/XMLSchema#integer>
<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> "14910352"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Guangzhou> <http://dbpedia.org/resource/Guangzhou> "Guangzhou"@en "23.132"^^<http://www.w3.org/2001/XMLSchema#float> "113.266"^^<http://www.w3.org/2001/XMLSchema#float> "14904400"^^<http://www.w3.org/2001/XMLSchema#integer> ""
<http://dbpedia.org/resource/Kinshasa> <http://dbpedia.org/resource/Kinshasa> "Kinshasa"@en "-4.325"^^<http://www.w3.org/2001/XMLSchema#float> "15.3222"^^<http://www.w3.org/2001/XMLSchema#float> "14566000"^^<http://www.w3.org/2001/XMLSchema#integer> ""

Received 122 rows in 0.103 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)


Permalinks

Document Actions