query-5d27bdff2d45b8edbcd791d43e7368fa

rq turtle/ttl

All HASC Data with seperate code for country, region and subregion

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#-----------------------------------------------------
# All HASC Data with seperate code for country, region and subregion
#-----------------------------------------------------
#defaultView:Map;Table
SELECT ?item ?itemLabel ?itemDescription ?hasc ?country_code ?region_code ?subregion_code
WHERE
{
    ?item wdt:P8119 ?hasc .                     # hasc
    #STRLEN("http://www.wikidata.org/entity/Q")+1)
    BIND(SUBSTR(?hasc,1,2) AS ?country_code).
    BIND(SUBSTR(?hasc,4,2) AS ?region_code).
    BIND(SUBSTR(?hasc,7,2) AS ?subregion_code).
    #OPTIONAL { ?item wdt:P625 ?coordinate. }    # coordinate
    #OPTIONAL { ?item wdt:P17  ?country. }       # country
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de". }
}
order by ?hasc

Query found at

• https://www.wikidata.org/wiki/User:Stefan_K%C3%BChn/HASC