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/THANADOS/ordered_sparql_insert_THANA...

374 lines
15 KiB
SPARQL

DELETE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
<https://ariadne-infrastructure.eu/aocat/Collection/THANADOS/64905CC0-95E1-3F3B-B797-62FE0C434DF3> ?p ?o .
?s ?x <https://ariadne-infrastructure.eu/aocat/Collection/THANADOS/64905CC0-95E1-3F3B-B797-62FE0C434DF3> .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
<https://ariadne-infrastructure.eu/aocat/Collection/THANADOS/64905CC0-95E1-3F3B-B797-62FE0C434DF3> ?p ?o .
?s ?x <https://ariadne-infrastructure.eu/aocat/Collection/THANADOS/64905CC0-95E1-3F3B-B797-62FE0C434DF3> .
}
};
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 skos: <http://www.w3.org/2004/02/skos/core#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_type <https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/collection> .
<https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/collection> rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Concept> .
<https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/collection> skos:prefLabel "collection"
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
MINUS {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
?s aocat:has_type ?t .
}
}
};
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::thanados::api> {
?s aocat:has_temporal_coverage ?tcov .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
?s aocat:is_part_of ?coll .
?coll aocat:has_temporal_coverage ?tcov .
MINUS {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
?s aocat:has_temporal_coverage ?tc .
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_title "Title not provided" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type aocat:AO_Individual_Data_Resource .
MINUS {
?s rdf:type aocat:AO_Individual_Data_Resource .
?s aocat:has_title ?title .
}
}
};
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#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
<https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Agent> .
<https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> rdfs:label "THANADOS" .
<https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> aocat:has_name "THANADOS" .
?s aocat:has_creator <https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> .
?s aocat:has_contributor <https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> .
?s aocat:has_responsible <https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> .
?s aocat:has_owner <https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> .
?s aocat:has_publisher <https://ariadne-infrastructure.eu/aocat/Agent/THANADOS> .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
}
};
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#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:was_issued "2022"
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
?s aocat:was_issued ?smt .
}
}
};
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#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_access_rights "Not provided"
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Collection> .
?s aocat:has_access_rights ?smt .
}
}
};
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#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_type <https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/provided%20record> .
<https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/provided%20record> rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Concept> .
<https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/provided%20record> skos:prefLabel "provided record"
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type aocat:AO_Individual_Data_Resource .
MINUS {
?s rdf:type aocat:AO_Individual_Data_Resource .
?s aocat:has_type ?t .
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_creator ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_creator ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_creator ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_contributor ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_contributor ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_contributor ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_responsible ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_responsible ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_responsible ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_owner ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_owner ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_owner ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_publisher ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_publisher ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_publisher ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:was_issued ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:was_issued ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:was_issued ?x
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s aocat:has_access_rights ?cr .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:is_part_of ?coll .
?coll aocat:has_access_rights ?cr .
MINUS{
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
?s aocat:has_access_rights ?x
}
}
};
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::thanados::aatplus> {
?s aocat:has_derived_subject ?aat .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::aat>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api>
WHERE {
{
?s aocat:has_native_subject ?native_subject .
?aatmatch owl:sameAs ?vocuri .
?aatmatch skos:exactMatch ?aat .
bind (IRI(concat( "https://thanados.net/vocabulary/", ucase(strafter(str(?native_subject),"THANADOS/")))) as ?vocuribuilt)
filter(?vocuri=?vocuribuilt)
}
union
{
?s aocat:has_native_subject ?native_subject .
?aatmatch owl:sameAs ?vocuri .
?aatmatch skos:broadMatch ?aat .
bind (IRI(concat( "https://thanados.net/vocabulary/", ucase(strafter(str(?native_subject),"THANADOS/")))) as ?vocuribuilt)
filter(?vocuri=?vocuribuilt)
}
union
{
?s aocat:has_native_subject ?native_subject .
?aatmatch owl:sameAs ?vocuri .
?aatmatch skos:closeMatch ?aat .
bind (IRI(concat( "https://thanados.net/vocabulary/", ucase(strafter(str(?native_subject),"THANADOS/")))) as ?vocuribuilt)
filter(?vocuri=?vocuribuilt)
}
union
{
?s aocat:has_native_subject ?native_subject .
?aatmatch owl:sameAs ?vocuri .
?aatmatch skos:narrowMatch ?aat .
bind (IRI(concat( "https://thanados.net/vocabulary/", ucase(strafter(str(?native_subject),"THANADOS/")))) as ?vocuribuilt)
filter(?vocuri=?vocuribuilt)
}
};
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/>
PREFIX ariadneplus: <https://ariadne-infrastructure.eu/aocat/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::thanados::periodoplus> {
?temporal aocat:has_period ?periodO_URI .
?temporal aocat:from ?temporalFrom .
?temporal aocat:until ?temporalUntil .
}
}
USING <https://ariadne-infrastructure.eu/ariadneplus::thanados::periodo>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::thanados::api>
WHERE {
?temporal aocat:has_period ?periodO_URI .
?periodO_URI time:intervalStartedBy / time:hasDateTimeDescription / time:year ?temporalFrom .
?periodO_URI time:intervalFinishedBy / time:hasDateTimeDescription / time:year ?temporalUntil .
};