All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 0 rows in 0.035 seconds.
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.
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://eurostat.linked-statistics.org/property#>
PREFIX wgs84: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT sql:sample(?cityname) AS ?cityname
sql:sample(?countryname) AS ?countryname
concat(str(sql:sample(?lat)),',',str(sql:sample(?long))) AS ?latlong
sql:sample(?population) AS ?population
WHERE {
?cityurl skos:inScheme <http://eurostat.linked-statistics.org/dic/cities>;
a skos:Concept ;
p:inCountry ?country;
rdfs:label ?cityname.
?country rdfs:label ?countryname .
?cityurl skos:exactMatch ?dbpedia .
?dbpedia wgs84:lat ?lat;
wgs84:long ?long;
<http://dbpedia.org/ontology/populationTotal> ?population
} GROUP BY ?cityurl ?countryname
ORDER BY ?countryname
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/eionet/data/local-sparql-queries/urban-audit-cities-with-lat-long or scan the QR code.
PDF generated on 28 Mar 2024, 12:03 PM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others