query-492b36d11f475f8e7be588b9a031058f

rq turtle/ttl

Farois analisar tudo

SELECT ?itemLabel ?item ?wikiLabel ?sipa ?dgpc ?heritageLabel ?cultLabel

?marine ?partof ?data ?arlhs ?official ?cultLabel ?focal ?alt ?pornum ?admiral ?nga ?retir ?charact ?range

WHERE { ?item wdt:P31/wdt:P279* wd:Q39715. # Must be of a lighthouse ?item wdt:P17 wd:Q45. # Must be of a heritage

OPTIONAL {    ?item wdt:P2186  ?wiki . }

    OPTIONAL {    ?item wdt:P730  ?retir . }

OPTIONAL { ?item wdt:P706 ?official . } OPTIONAL{ ?item wdt:P1030 ?charact . } OPTIONAL{ ?item wdt:P2923 ?focal . } OPTIONAL{ ?item wdt:P31 ?cult . } OPTIONAL { ?item wdt:P2048 ?alt . } OPTIONAL { ?item wdt:P1702 ?dgpc . } OPTIONAL { ?item wdt:P2929 ?range . } OPTIONAL { ?item wdt:P1435 ?heritage . } OPTIONAL { ?item wdt:P361 ?partof . } OPTIONAL { ?item wdt:P2980 ?arlhs . } OPTIONAL { ?item wdt:P571 ?data . } OPTIONAL { ?item wdt:P1700 ?sipa . } OPTIONAL { ?item wdt:P3563 ?nga . } OPTIONAL { ?item wdt:P3601 ?marine . }
OPTIONAL { ?item wdt:P4423 ?pornum . } OPTIONAL { ?item wdt:P3562 ?admiral . }

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language } ORDER BY DESC(?elev) LIMIT 20000

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Farois analisar tudo

SELECT ?itemLabel ?item ?wikiLabel ?sipa ?dgpc  ?heritageLabel  ?cultLabel
#  ?marine  ?partof  ?data   ?arlhs   ?official ?cultLabel ?focal ?alt ?pornum ?admiral  ?nga  ?retir ?charact ?range 
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q39715. # Must be of a lighthouse
  ?item wdt:P17 wd:Q45.  # Must be of a heritage

    OPTIONAL {    ?item wdt:P2186  ?wiki . }

        OPTIONAL {    ?item wdt:P730  ?retir . }
   OPTIONAL {    ?item wdt:P706  ?official . } 
  OPTIONAL{    ?item wdt:P1030  ?charact . }
  OPTIONAL{   ?item wdt:P2923  ?focal  . }
  OPTIONAL{ ?item wdt:P31   ?cult . } 
  OPTIONAL {   ?item wdt:P2048 ?alt . }
   OPTIONAL {   ?item wdt:P1702   ?dgpc . } 
       OPTIONAL {   ?item wdt:P2929   ?range . } 
        OPTIONAL {   ?item wdt:P1435  ?heritage . } 
     OPTIONAL {   ?item wdt:P361   ?partof . }
        OPTIONAL {   ?item wdt:P2980  ?arlhs . }
        OPTIONAL {   ?item wdt:P571   ?data . }
      OPTIONAL {   ?item wdt:P1700  ?sipa . }
      OPTIONAL {   ?item wdt:P3563  ?nga . }
        OPTIONAL {   ?item wdt:P3601  ?marine . }  
       OPTIONAL {   ?item wdt:P4423  ?pornum . } 
          OPTIONAL {   ?item wdt:P3562  ?admiral . } 

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
ORDER BY DESC(?elev)
LIMIT 20000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v20("?admiral") v9("?alt") v14("?arlhs") v6("?charact") v8("?cult") v15("?data") v10("?dgpc"):::projected v1("?elev") v7("?focal") v12("?heritage") v2("?item"):::projected v18("?marine") v17("?nga") v5("?official") v13("?partof") v19("?pornum") v11("?range") v4("?retir") v16("?sipa"):::projected v3("?wiki") a1((" ")) c24(["bd:serviceParam"]):::iri c3(["wd:Q39715"]):::iri c5(["wd:Q45"]):::iri c26(["#91;AUTO_LANGUAGE#93;,en"]):::literal v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P17"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2186".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P730".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P706".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1030".-> v6 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2923".-> v7 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P31".-> v8 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2048".-> v9 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1702".-> v10 end subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2929".-> v11 end subgraph optional9["(optional)"] style optional9 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1435".-> v12 end subgraph optional10["(optional)"] style optional10 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P361".-> v13 end subgraph optional11["(optional)"] style optional11 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P2980".-> v14 end subgraph optional12["(optional)"] style optional12 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P571".-> v15 end subgraph optional13["(optional)"] style optional13 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1700".-> v16 end subgraph optional14["(optional)"] style optional14 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P3563".-> v17 end subgraph optional15["(optional)"] style optional15 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P3601".-> v18 end subgraph optional16["(optional)"] style optional16 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P4423".-> v19 end subgraph optional17["(optional)"] style optional17 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P3562".-> v20 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c24 --"wikibase:language"--> c26 end