Wikipedia

Bruger:Steenth/sparql: Forskelle mellem versioner

Gennemse historikken interaktivt
← Gå til forrige forskelGå til næste forskel →
Content deleted Content added
VisueltWikitekst
m →‎SMK: vis også kid
lidt reorg og tilføj lidt omkring Kategori:Geomærkning savnes
Linje 234:
}}
 
== Geografi ==
=== til p131 mangler p17 ===
 
{{SPARQL|query=
Line 249 ⟶ 250:
}}
 
=== Landsby uden bykode ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?kmdLabel WHERE {
Line 260 ⟶ 261:
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
=== Analyse af [[:Kategori:Geomærkning savnes - hovedkvarter i Danmark]] ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?itemDescription ?byLabel {
OPTIONAL {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "da.wikipedia.org" .
bd:serviceParam mwapi:gcmtitle "Kategori:Geomærkning savnes - hovedkvarter i Danmark" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "page" .
bd:serviceParam mwapi:gcmlimit "max" .
bd:serviceParam mwapi:gcmsort "timestamp" .
?item wikibase:apiOutputItem mwapi:item.
}
}
FILTER BOUND (?item)
?item wdt:P159 ?by .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
} limit 1000
}}
 
=== Analyse af [[:Kategori:Geomærkning savnes - Danmark - anden kommune]] ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?itemDescription ?byLabel {
OPTIONAL {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam wikibase:endpoint "da.wikipedia.org" .
bd:serviceParam mwapi:gcmtitle "Kategori:Geomærkning savnes - Danmark - anden kommune" .
bd:serviceParam mwapi:generator "categorymembers" .
bd:serviceParam mwapi:gcmtype "page" .
bd:serviceParam mwapi:gcmlimit "max" .
bd:serviceParam mwapi:gcmsort "timestamp" .
?item wikibase:apiOutputItem mwapi:item.
}
}
FILTER BOUND (?item)
?item wdt:P159 ?by .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
} limit 1000
}}
 
== tjek impot af geografiske koordinater ==
=== tjek af p31 - wikimedia-kategorier ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 [] .
VALUES ?value { wd:Q4167836 wd:Q11266439 wd:Q13406463 wd:Q4167410 wd:Q14204246 } .
?item wdt:P31 ?value .
BIND( wd:P31 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
=== tjek af p31 - selskaber, virksomheder, mennesker ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 [] .
VALUES ?value { wd:Q5 wd:Q783794 wd:Q4830453 } .
?item wdt:P31 ?value .
BIND( wd:P31 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
=== undergrupper ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 []; wdt:P279 ?value .
BIND( wd:P279 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
Line 702 ⟶ 801:
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
== tjek impot af geografiske koordinater ==
=== tjek af p31 - wikimedia-kategorier ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 [] .
VALUES ?value { wd:Q4167836 wd:Q11266439 wd:Q13406463 wd:Q4167410 wd:Q14204246 } .
?item wdt:P31 ?value .
BIND( wd:P31 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
=== tjek af p31 - selskaber, virksomheder, mennesker ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 [] .
VALUES ?value { wd:Q5 wd:Q783794 wd:Q4830453 } .
?item wdt:P31 ?value .
BIND( wd:P31 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
 
=== undergrupper ===
{{SPARQL|query=
SELECT ?item ?itemLabel ?property ?propertyLabel ?value ?valueLabel
WHERE
{
{
SELECT DISTINCT ?item ?property ?value {
?item wdt:P625 []; wdt:P279 ?value .
BIND( wd:P279 AS ?property ) .
?wiki0 <http://schema.org/about> ?item .
?wiki0 <http://schema.org/isPartOf> <https://da.wikipedia.org/> .
} LIMIT 100
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" } .
}
}}
Hentet fra "https://da.wikipedia.org/wiki/Bruger:Steenth/sparql"