query-492b36d11f475f8e7be588b9a031058f
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
- https://query.wikidata.org/sparql
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