2b:null 2c:["$","title",null,{"children":"SPARQL endpoint Nieuwe Instituut | TU Delft Library | Observable"}] 31:Taa4,## Leon's tips Recursief zoeken met *: ```sparql PREFIX rico: SELECT ?obj WHERE { rico:includesOrIncluded* ?obj . } ``` Optional weghalen om enkel de bovengelegen mappen op te vragen: ```sparql PREFIX rico: prefix rdf: SELECT * WHERE { ?record a rico:RecordSet ; rico:hasOrHadIdentifier/rico:textualValue "TUDE17" ; rico:title ?title ; rico:includesOrIncluded* ?subRecord . OPTIONAL { ?subRecord a rico:RecordSet ; rico:hasOrHadIdentifier/rico:textualValue ?subRecordValue ; rico:title ?subRecordTitle . } } LIMIT 1000 ``` Documentatie: https://www.w3.org/TR/sparql11-query/#propertypaths Alle records in TUDE: ```sparql PREFIX rico: prefix rdf: SELECT * WHERE { ?record a rico:RecordSet ; rico:hasOrHadIdentifier ?identifier ; rico:title ?title ; rico:includesOrIncluded* ?subRecord . ?identifier rico:textualValue ?identifierValue . FILTER(CONTAINS(?identifierValue, "TUDE")) ?subRecord a rico:RecordSet ; rico:hasOrHadIdentifier ?subRecordIdentifier ; rico:title ?subRecordTitle . ?subRecordIdentifier rico:textualValue ?subRecordIdentifierValue . } LIMIT 10000 ``` CONSTRUCT voorbeeld: ```sparql PREFIX rico: prefix rdf: CONSTRUCT { ?record a rico:RecordSet ; rico:hasOrHadIdentifier ?identifier ; rico:title ?title ; rico:includesOrIncluded ?subRecord . ?identifier rico:textualValue "TUDE17" . ?subRecord a rico:RecordSet ; rico:hasOrHadIdentifier ?subRecordIdentifier ; rico:title ?subRecordTitle . ?subRecordIdentifier rico:textualValue ?subRecordValue . } WHERE { ?record a rico:RecordSet ; rico:hasOrHadIdentifier ?identifier ; rico:title ?title ; rico:includesOrIncluded* ?subRecord . ?identifier rico:textualValue "TUDE17" . ?subRecord a rico:RecordSet ; rico:hasOrHadIdentifier ?subRecordIdentifier ; rico:title ?subRecordTitle . ?subRecordIdentifier rico:textualValue ?subRecordValue . } LIMIT 1000 ``` > rico:includesOrIncluded > > Connects a Record Set to a Record or Record Set it aggregates, or aggregated in the past. Is verkeerd toegepast in de data. Moet van groot naar klein. Andersom is: https://www.ica.org/standards/RiC/ontology#isOrWasIncludedIn32:[{"id":"a1a15f3450d1ecc55cf809827e742ba7a132478c95d5648d4f07f3f42387e161d9da5ab9cf9bcec2fac7621bf289a2ccc7d3bf3217b6ad8a0ae520be9d3f323c","href":"https://static.observableusercontent.com/files/a1a15f3450d1ecc55cf809827e742ba7a132478c95d5648d4f07f3f42387e161d9da5ab9cf9bcec2fac7621bf289a2ccc7d3bf3217b6ad8a0ae520be9d3f323c","name":"RiC-O_1-0_list-of-classes.csv","type":"text/csv","lastModified":1711469919530.399,"size":102192},{"id":"3b6247a7283a8825170ac52598996118180f9548e66f54e740b5c4f093487a859a59c1cef70fa4d2bdc835ed3cfd1816e63c98c79068b032d78875332e3254bb","href":"https://static.observableusercontent.com/files/3b6247a7283a8825170ac52598996118180f9548e66f54e740b5c4f093487a859a59c1cef70fa4d2bdc835ed3cfd1816e63c98c79068b032d78875332e3254bb","name":"RiC-O_1-0_list-of-object-properties.csv","type":"text/csv","lastModified":1711469971072.31,"size":239546}] 2f:{"id":"b97ef4cd4ab8c9c6","slug":null,"title":"SPARQL endpoint Nieuwe Instituut","thumbnail":"a25d8efb0160cae3d11cb8bc403a89b63230f55fb803d731e84c5c353a63facb","access_level":"public","create_time":"$D2024-03-26T10:21:20.450Z","update_time":"$D2024-04-24T14:55:05.782Z","view_time":null,"first_public_time":"$D2024-03-29T10:03:08.258Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ab036510f7d8e0c1","login":"tudelft","name":"TU Delft Library","avatar_url":"https://avatars-next.observableusercontent.com/1518fc717636b8b67a285d240e13db0d86f758541cb7cbe64b759dfb901b40c6","tier":"pro_2024"},"version":196,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"f444e659497ac4e5","login":"sammeltassen","name":"Jules Schoonman","avatar_url":"https://avatars-next.observableusercontent.com/d8e1e715f8e8560d0970b3d60336fe11ce634dd18ec4107ab6e99022494e616c","tier":null}],"members":[{"type":"individual","id":"f444e659497ac4e5","login":"sammeltassen","name":"Jules Schoonman","avatar_url":"https://avatars-next.observableusercontent.com/d8e1e715f8e8560d0970b3d60336fe11ce634dd18ec4107ab6e99022494e616c","tier":null,"role":"editor"},{"type":"team","id":"ab036510f7d8e0c1","login":"tudelft","name":"TU Delft Library","avatar_url":"https://avatars-next.observableusercontent.com/1518fc717636b8b67a285d240e13db0d86f758541cb7cbe64b759dfb901b40c6","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"SPARQL endpoint Nieuwe Instituut","cells":[{"id":0,"value":"# SPARQL endpoint Nieuwe Instituut","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"Information about SPARQL endpoint:\n- https://collectiedata.hetnieuweinstituut.nl\n\nArchief TUDE:\n- Archief: https://collectiedata.hetnieuweinstituut.nl/id/archives/110000470\n- Folder: https://collectiedata.hetnieuweinstituut.nl/id/archives/110654653\n\nOntology:\n- https://github.com/ICA-EGAD/RiC-O/blob/master/ontology/current-version/CSV_lists_of_components/RiC-O_1-0_list-of-classes.csv","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":29,"value":"tudeUri = \"https://collectiedata.hetnieuweinstituut.nl/id/archives/110000470\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"tudeFolders = [\n \"TUDE17\",\n \"TUDE19\",\n \"TUDE20\",\n \"TUDE21\",\n \"TUDE36\",\n \"TUDE61\",\n \"TUDE64\",\n \"TUDE65\",\n \"TUDE66\",\n \"TUDE67\",\n \"TUDE68\",\n \"TUDE69\",\n \"TUDE70\",\n \"TUDE71\",\n \"TUDE72\",\n \"TUDE73\",\n \"TUDEt40\",\n \"TUDEt51\",\n \"TUDEt111\",\n \"TUDEt112\",\n \"TUDEt113\",\n \"TUDEt114\",\n \"TUDEt115\",\n \"TUDEt116\",\n \"TUDEt117\",\n \"TUDEt118\",\n \"TUDEt119\",\n \"TUDEt120\",\n \"TUDEt136\",\n \"TUDEt138\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"createConstructQuery = (folder) => {\n return `PREFIX rico: \nCONSTRUCT { ?record ?pred ?obj } WHERE {\n ?record a rico:RecordSet ;\n rico:hasOrHadIdentifier/rico:textualValue \"${folder}\" .\n ?record ?pred ?obj;\n}`;\n}\n// PREFIX rico: \n// CONSTRUCT { ?sub ?pred ?obj } WHERE {\n// ?id rico:textualValue \"${folder}\" .\n// ?sub rico:hasOrHadIdentifier ?id .\n// ?sub ?pred ?obj;\n// }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"createSelectQuery = (folder) => {\n return `PREFIX rico: \nSELECT * WHERE {\n ?id rico:textualValue \"${folder}\" .\n ?sub rico:hasOrHadIdentifier ?id .\n ?sub ?pred ?obj;\n}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"Current responses per folder:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":33,"value":"{\n const map = new Map();\n for (const folder of tudeFolders) {\n const resp = await fetchJsonWithOptions(createConstructQuery(folder));\n map.set(folder, resp[0]);\n }\n return map;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"Single select query response:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":156,"value":"fetchJsonWithQueryParam(createSelectQuery(\"TUDE17\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"query = `PREFIX rico: \nCONSTRUCT WHERE {\n ?sub rico:includesOrIncluded ;\n} LIMIT 100`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"insightQuery = `PREFIX rico: \nPREFIX rdf: \nPREFIX rdfs: \nSELECT DISTINCT ?pred WHERE {\n ?map a rico:RecordSet ;\n ?pred ?obj .\n \n FILTER(?pred != rdf:type)\n \n} LIMIT 100`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"predicatesUsed = fetchJsonWithQueryParam(insightQuery)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"predicatesUsed\n .filter((i) => i.pred.includes(\"https://www.ica.org\"))\n .map((i) =>\n i.pred.replace(\"https://www.ica.org/standards/RiC/ontology#\", \"rico:\")\n )\n .map((i) => {\n const label = ricoProps.filter(\n (label) => label[\"Object property name (compact URI)\"] === i\n )[0];\n return label ? label[\"Label in English (rdfs:label [en])\"] : i;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"ricoProps.filter(\n (label) =>\n label[\"Object property name (compact URI)\"] === \"rico:includesOrIncluded\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"sparqlApiBase = \"https://api.collectiedata.hetnieuweinstituut.nl/datasets/the-other-interface/knowledge-graph/services/default/sparql\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"searchApiBase = \"https://api.collectiedata.hetnieuweinstituut.nl/datasets/the-other-interface/knowledge-graph/services/knowledge-graph-ES/_search\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"fetchJsonWithOptions = (query) =>\n fetch(sparqlApiBase, {\n method: \"POST\",\n headers: {\n Accept: \"application/ld+json\", // application/sparql-results+json\n \"Content-Type\": \"application/x-www-form-urlencoded\"\n },\n body: `query=${encodeURIComponent(query)}`\n }).then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"fetchJsonWithQueryParam = (query) =>\n fetch(sparqlApiBase + \"?query=\" + encodeURIComponent(query)).then(\n (response) => response.json()\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"ricoLabels = FileAttachment(\"RiC-O_1-0_list-of-classes.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"ricoProps = FileAttachment(\"RiC-O_1-0_list-of-object-properties.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"ricoDataType = FileAttachment(\"RiC-O_1-0_list-of-datatype-properties.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"