Project:RedirectionScript: Difference between revisions
From MaRDI portal
Created page with "Test" |
No edit summary |
||
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
== SPARQL queries == | |||
=== Count number of items that redirect to another item === | |||
<syntaxhighlight lang="sparql"> | |||
SELECT (COUNT (DISTINCT ?o) AS ?count) | |||
WHERE | |||
{ | |||
?o owl:sameAs ?sa . | |||
} | |||
</syntaxhighlight> | |||
=== Get mapping of original items to the ones they were redirected to === | |||
<syntaxhighlight lang="sparql"> | |||
SELECT DISTINCT ?o ?sa | |||
WHERE | |||
{ | |||
?o owl:sameAs ?sa . | |||
} | |||
</syntaxhighlight> | |||
=== Get all items that redirect to somewhere else and are still referenced in another item === | |||
Exclude those without a label to exclude other reference pages<syntaxhighlight lang="sparql"> | |||
SELECT DISTINCT ?o | |||
WHERE | |||
{ | |||
?o owl:sameAs ?sa . | |||
?new ?p ?o . | |||
?o rdfs:label ?label . | |||
} | |||
</syntaxhighlight> | |||
== Script == | |||
https://github.com/MaRDI4NFDI/docker-importer/blob/main/bot_scripts/reroute.py | |||
The script takes as input a csv file with the output of the second sparql query that maps old ids to new ids. |
Latest revision as of 09:38, 14 March 2024
SPARQL queries
Count number of items that redirect to another item
SELECT (COUNT (DISTINCT ?o) AS ?count)
WHERE
{
?o owl:sameAs ?sa .
}
Get mapping of original items to the ones they were redirected to
SELECT DISTINCT ?o ?sa
WHERE
{
?o owl:sameAs ?sa .
}
Get all items that redirect to somewhere else and are still referenced in another item
Exclude those without a label to exclude other reference pages
SELECT DISTINCT ?o
WHERE
{
?o owl:sameAs ?sa .
?new ?p ?o .
?o rdfs:label ?label .
}
Script
https://github.com/MaRDI4NFDI/docker-importer/blob/main/bot_scripts/reroute.py
The script takes as input a csv file with the output of the second sparql query that maps old ids to new ids.