query-88228548741ec62b747f7670bb0b0962

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Espacios naturales protegidos
#Identificador OSM, WPES, LL
#Usuario:Galopax/Pintando_mapas_2
#User:Galopax/Painting maps (WD)
#added 2022-02-15
#defaultView:Map
SELECT ?item ?itemLabel ?WDPA ?CDDA ?Natura_2000 ?osm ?eswiki ?coord ?image ?commons ?lat ?lon
(CONCAT("[https://protectedplanet.net/",?WDPA,"]") as ?url1)
(CONCAT("[http://eunis.eea.europa.eu/sites/",?CDDA,"]") as ?url2)
(CONCAT("[http://natura2000.eea.europa.eu/Natura2000/SDF.aspx?site=",?Natura_2000,"]") as ?url3)
WHERE {
  ?item wdt:P17 wd:Q29.
  ?item wdt:P809 ?WDPA.#identificador WDPA
  MINUS {?item wdt:P276 wd:Q5813.}
  MINUS {?item wdt:P276 wd:Q107356467.}
  OPTIONAL {?item wdt:P4762 ?CDDA.}#identificador en CDDA
  OPTIONAL {?item wdt:P3425 ?Natura_2000.}#identificador Natura 2000
  OPTIONAL {?item  wdt:P625 ?coord. }
  OPTIONAL {?item wdt:P18 ?image.}
  OPTIONAL {?item wdt:P402 ?osm.}
  OPTIONAL {
   ?eswiki schema:about ?item;
   schema:isPartOf <https://es.wikipedia.org/>. }
  OPTIONAL {
   ?commons schema:about ?item;
   schema:isPartOf <https://commons.wikimedia.org/>. }
  BIND(IF(BOUND(?cat),ENCODE_FOR_URI(?cat),"" ) as ?catstring)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "es". }
  ?item p:P625 ?statement . # coordinate-location statement
      ?statement psv:P625 ?coordinate_node .
      ?coordinate_node wikibase:geoLatitude ?lat .
      ?coordinate_node wikibase:geoLongitude ?lon .
}

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?CDDA"):::projected v4("?Natura_2000"):::projected v2("?WDPA"):::projected v10("?catstring") v9("?commons"):::projected v5("?coord"):::projected v12("?coordinate_node") v8("?eswiki"):::projected v6("?image"):::projected v1("?item"):::projected v13("?lat"):::projected v14("?lon"):::projected v7("?osm"):::projected v11("?statement") v15("?url1") v16("?url2") v17("?url3") c5(["wd:Q5813"]):::iri c15([https://commons.wikimedia.org/]):::iri c19(["es"]):::literal c2(["wd:Q29"]):::iri c17(["bd:serviceParam"]):::iri c14([https://es.wikipedia.org/]):::iri c6(["wd:Q107356467"]):::iri v1 --"p:direct/P17"--> c2 v1 --"p:direct/P809"--> v2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"p:direct/P276"--> c5 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v1 --"p:direct/P276"--> c6 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P4762".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P3425".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P625".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P18".-> v6 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v1 -."p:direct/P402".-> v7 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v8 -."schema:about".-> v1 v8 --"schema:isPartOf"--> c14 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v9 -."schema:about".-> v1 v9 --"schema:isPartOf"--> c15 end bind2[/"if(bound(?cat),encode-for-uri(?cat),'')"/] null --o bind2 bind2 --as--o v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c19 end v1 --"p:P625"--> v11 v11 --"p:statement/value/P625"--> v12 v12 --"wikibase:geoLatitude"--> v13 v12 --"wikibase:geoLongitude"--> v14 bind3[/"concat('#91;https://protectedplanet.net/',?WDPA,'#93;')"/] v2 --o bind3 bind3 --as--o v15 bind4[/"concat('#91;http://eunis.eea.europa.eu/sites/',?CDDA,'#93;')"/] v3 --o bind4 bind4 --as--o v16 bind5[/"concat('#91;http://natura2000.eea.europa.eu/Natura2000/SDF.aspx?site=',?Natura_2000,'#93;')"/] v4 --o bind5 bind5 --as--o v17