You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
AriadnePlus/dnet-ariadneplus-graphdb-pu.../src/main/resources/eu/dnetlib/ariadneplus/sparql/enrich/NIAM/ordered_sparql_insert_niam....

189 lines
6.6 KiB
SPARQL

PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
DELETE DATA {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
<https://ariadne-infrastructure.eu/aocat/Resource/NIAM-BAS%2FAKB/6F5864D7-2371-30DD-8BB8-2304E33A3CA1> aocat:was_issued "9921-10-31"^^xsd:dateTime .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
INSERT DATA {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
<https://ariadne-infrastructure.eu/aocat/Resource/NIAM-BAS%2FAKB/6F5864D7-2371-30DD-8BB8-2304E33A3CA1> aocat:was_issued "1992-10-31"^^xsd:dateTime .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?s aocat:has_title "Title not provided".
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?s rdf:type aocat:AO_Individual_Data_Resource .
MINUS {
?s aocat:has_title ?t .
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?record aocat:has_creator ?creator .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_creator ?creator .
MINUS {
?record aocat:is_part_of ?collection .
?record aocat:has_creator ?x .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?record aocat:was_issued ?issued .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:was_issued ?issued .
MINUS {
?record aocat:is_part_of ?collection .
?record aocat:was_issued ?x .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?record aocat:has_ARIADNE_subject ?subj .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_ARIADNE_subject ?subj .
MINUS {
?record aocat:is_part_of ?collection .
?record aocat:has_ARIADNE_subject ?x .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?s aocat:has_native_subject <https://ariadne-infrastructure.eu/aocat/Concept/niam/NOT_PROVIDED> .
<https://ariadne-infrastructure.eu/aocat/Concept/niam/NOT_PROVIDED> skos:prefLabel "Not provided" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?s rdf:type aocat:AO_Individual_Data_Resource .
MINUS {
?s rdf:type aocat:AO_Individual_Data_Resource .
?s aocat:has_native_subject ?ns .
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::niam::aatplus> {
?record aocat:has_derived_subject ?aat .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::aat>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb>
WHERE {
{
?record aocat:has_native_subject ?native_subject .
?native_subject skos:exactMatch ?aat .
}
union
{
?record aocat:has_native_subject ?native_subject .
?native_subject skos:broadMatch ?aat .
}
union
{
?record aocat:has_native_subject ?native_subject .
?native_subject skos:closeMatch ?aat .
}
union
{
?record aocat:has_native_subject ?native_subject .
?native_subject skos:narrowMatch ?aat .
}
};
PREFIX dcterms: <http://purl.org/dc/terms/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::niam::periodo> {
?periodO ?pred ?o .
?o ?pred2 ?o2 .
?o2 ?pred3 ?o3 .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/ariadne/periodo> {
?periodO dcterms:spatial <http://www.wikidata.org/entity/Q219> .
?periodO ?pred ?o .
optional {
?o ?pred2 ?o2 .
optional {
?o2 ?pred3 ?o3 .
}
}
}
};
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX time: <http://www.w3.org/2006/time#>
PREFIX dcterms: <http://purl.org/dc/terms/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::niam::periodoplus> {
?temporal aocat:has_period ?periodO .
?temporal aocat:from ?temporalFrom .
?temporal aocat:until ?temporalUntil .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::niam::amb> {
?temporal aocat:has_native_period ?native_period .
?native_period skos:prefLabel ?t_label .
optional {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::niam::periodo> {
?periodO skos:altLabel ?p_label .
?periodO time:intervalStartedBy / time:hasDateTimeDescription / time:year ?temporalFrom .
?periodO time:intervalFinishedBy / time:hasDateTimeDescription / time:year ?temporalUntil .
}
}
bind(ucase(?t_label) as ?u_t_label)
bind(ucase(?p_label) as ?u_p_label)
filter(?u_t_label=?u_p_label)
}
};