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/IAA/ordered_sparql_insert_IAA_s...

255 lines
9.4 KiB
SPARQL

ADD SILENT <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::maps> TO <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>;
DROP SILENT GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::maps>;
ADD SILENT <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::periods> TO <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>;
DROP SILENT GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::periods>;
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/api_________::ariadne_plus::iaa_survey::sites> {
?s aocat:has_type <https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/provided%20record> .
<https://ariadne-infrastructure.eu/aocat/Concept/AO_Type/provided%20record> skos:prefLabel "provided record" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?s rdf:type aocat:AO_Individual_Data_Resource .
}
};
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::iaa_survey::sites> {
?s aocat:has_native_subject <https://ariadne-infrastructure.eu/aocat/Concept/IAA/NOT_PROVIDED> .
<https://ariadne-infrastructure.eu/aocat/Concept/IAA/NOT_PROVIDED> skos:prefLabel "Not provided" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?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 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::iaa_survey::sites> {
?s aocat:has_title "Title not provided" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?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#>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:was_issued ?date .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:was_issued ?date .
MINUS {
?record aocat:was_issued ?recorddate .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:was_modified ?date .
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:was_modified ?date .
MINUS {
?record aocat:was_modified ?recorddate .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:has_creator ?agent .
?agent ?p ?o
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_creator ?agent .
?agent ?p ?o .
MINUS {
?record aocat:has_creator ?recordagent .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:has_contributor ?agent .
?agent ?p ?o
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_contributor ?agent .
?agent ?p ?o .
MINUS {
?record aocat:has_contributor ?recordagent .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:has_responsible ?agent .
?agent ?p ?o
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_responsible ?agent .
?agent ?p ?o .
MINUS {
?record aocat:has_responsible ?recordagent .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:has_owner ?agent .
?agent ?p ?o
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_owner ?agent .
?agent ?p ?o .
MINUS {
?record aocat:has_owner ?recordagent .
}
};
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/api_________::ariadne_plus::iaa_survey::sites> {
?record aocat:has_publisher ?agent .
?agent ?p ?o
}
}
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites>
USING <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::coll>
WHERE {
?record aocat:is_part_of ?collection .
?collection aocat:has_publisher ?agent .
?agent ?p ?o .
MINUS {
?record aocat:has_publisher ?recordagent .
}
};
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::iaa_survey::sites> {
?s aocat:has_language <http://lexvo.org/id/iso639-3/und> .
<http://lexvo.org/id/iso639-3/und> skos:prefLabel "und" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?s rdf:type aocat:AO_Individual_Data_Resource .
MINUS {
?s rdf:type aocat:AO_Individual_Data_Resource .
?s aocat:has_language ?ns .
}
}
};
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::iaa_survey::sites> {
?s aocat:has_access_rights "Not provided" .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?s rdf:type <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/AO_Individual_Data_Resource> .
MINUS {
?s aocat:has_access_rights ?ar .
}
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
INSERT {
GRAPH <https://ariadne-infrastructure.eu/ariadneplus::iaa_survey::periodoplus> {
?temporal aocat:has_period ?nativePeriod .
?temporal aocat:from ?temporalFrom .
?temporal aocat:until ?temporalUntil .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?temporal aocat:has_native_period ?nativePeriod .
?temporal aocat:from ?temporalFrom .
?temporal aocat:until ?temporalUntil .
}
};
PREFIX aocat: <https://www.ariadne-infrastructure.eu/resource/ao/cat/1.1/>
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/ariadneplus::iaa_survey::periodo> {
?nativePeriod skos:prefLabel ?periodLabel .
}
}
WHERE {
GRAPH <https://ariadne-infrastructure.eu/api_________::ariadne_plus::iaa_survey::sites> {
?temporal aocat:has_native_period ?nativePeriod .
?nativePeriod rdfs:label ?periodLabel .
}
};