RVAS-UC1-a

lock_open

By prodatamarket_publisher
Copied from RVAS-UC1-a

Last modification over 3 years ago -  2017-03-06 09:31:34 UTC
Description

Flood risk value for the state-owned buildings. Colour the buildings' points with different colours if the building has floodrisk. Two colors for 1 and 0.


Query text


PREFIX prodm-cad: <http://vocabs.datagraft.net/proDataMarket/0.1/Cadastre#>
PREFIX prodm-com: <http://vocabs.datagraft.net/proDataMarket/0.1/Common#>
PREFIX prodm-soe: <http://vocabs.datagraft.net/proDataMarket/0.1/SoE#>
PREFIX schema: <http://schema.org/>
PREFIX gsp: <http://www.opengis.net/ont/geosparql#>
PREFIX sf: <http://www.opengis.net/ont/sf#>
PREFIX cp: <http://www.w3.org/2015/03/inspire/cp#>
PREFIX dul: <http://www.ontologydesignpatterns.org/ont/dul/DUL.owl#>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX au: <http://www.w3.org/2015/03/inspire/au#>

SELECT DISTINCT ?coords ?floodRisk
WHERE {

?bygg a prodm-cad:Building ;
gsp:hasGeometry [gsp:asWKT ?coords ;].

OPTIONAL {?bygg prodm-com:hasIndicator [a prodm-com:Indicator ;
dbo:type "FloodRisk" ;
rdf:value ?flood ;]; }

bind(if(bound(?flood), "1", "0") as ?floodRisk)

}