Data table via SPARQL

Most populated cities

Data table via SPARQL Published 31 Mar 2013 Last modified 12 Mar 2024

DBpedia example of cities with population within certain values

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

subject	city	label	latitude	longitude	maxPopulation	rainyDays
<http://dbpedia.org/resource/Chongqing>	<http://dbpedia.org/resource/Chongqing>	"Chongqing"@en	"29.56369972229004"^^<http://www.w3.org/2001/XMLSchema#float>	"106.5503997802734"^^<http://www.w3.org/2001/XMLSchema#float>	"32054159"^^<http://www.w3.org/2001/XMLSchema#integer>	"151.1"^^<http://www.w3.org/2001/XMLSchema#double>
<http://dbpedia.org/resource/Shanghai>	<http://dbpedia.org/resource/Shanghai>	"Shanghai"@en	"31.22861099243164"^^<http://www.w3.org/2001/XMLSchema#float>	"121.474723815918"^^<http://www.w3.org/2001/XMLSchema#float>	"24870895"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Beijing>	<http://dbpedia.org/resource/Beijing>	"Beijing"@en	"39.90666580200195"^^<http://www.w3.org/2001/XMLSchema#float>	"116.3974990844727"^^<http://www.w3.org/2001/XMLSchema#float>	"21893095"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Chengdu>	<http://dbpedia.org/resource/Chengdu>	"Chengdu"@en	"30.65999984741211"^^<http://www.w3.org/2001/XMLSchema#float>	"104.0633316040039"^^<http://www.w3.org/2001/XMLSchema#float>	"20937757"^^<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>	"-118.1999969482422"^^<http://www.w3.org/2001/XMLSchema#float>	"18710563"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Guangzhou>	<http://dbpedia.org/resource/Guangzhou>	"Guangzhou"@en	"23.1299991607666"^^<http://www.w3.org/2001/XMLSchema#float>	"113.2600021362305"^^<http://www.w3.org/2001/XMLSchema#float>	"18676605"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Shenzhen>	<http://dbpedia.org/resource/Shenzhen>	"Shenzhen"@en	"22.54150009155273"^^<http://www.w3.org/2001/XMLSchema#float>	"114.0596008300781"^^<http://www.w3.org/2001/XMLSchema#float>	"17560000"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Kinshasa>	<http://dbpedia.org/resource/Kinshasa>	"Kinshasa"@en	"-4.324999809265137"^^<http://www.w3.org/2001/XMLSchema#float>	"15.32222175598145"^^<http://www.w3.org/2001/XMLSchema#float>	"17071000"^^<http://www.w3.org/2001/XMLSchema#integer>	""
<http://dbpedia.org/resource/Istanbul>	<http://dbpedia.org/resource/Istanbul>	"Istanbul"@en	"41.01361083984375"^^<http://www.w3.org/2001/XMLSchema#float>	"28.95499992370605"^^<http://www.w3.org/2001/XMLSchema#float>	"15840900"^^<http://www.w3.org/2001/XMLSchema#integer>	"131.3"^^<http://www.w3.org/2001/XMLSchema#double>
<http://dbpedia.org/resource/Karachi>	<http://dbpedia.org/resource/Karachi>	"Karachi"@en	"24.86000061035156"^^<http://www.w3.org/2001/XMLSchema#float>	"67.01000213623047"^^<http://www.w3.org/2001/XMLSchema#float>	"14916456"^^<http://www.w3.org/2001/XMLSchema#integer>	""

Received 129 rows in 0.006 seconds.

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

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://dbpedia.org/sparql

SPARQL Query:


        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)