mapping-stabs.r2rml.ttl

PREFIX rr: <http://www.w3.org/ns/r2rml#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rico: <https://www.ica.org/standards/RiC/ontology#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX stabs-d: <stabs:scope:data/>
PREFIX stabs-rico: <https://ld.staatsarchiv.bs.ch/ontologies/StABS-RiC/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

<#rr_stabs>
	rr:logicalTable [ rr:sqlQuery """SELECT ANMERKUNGEN, TITEL, SIGNATUR, STUFE, ENTSTEHUNGSZEITRAUM, PHYSISCHE_BESCHAFFENHEIT, DARIN, ARCHIVALIENART, ENTHAELT, RECHTSSTATUS, ZUGANGSBESTIMMUNGEN, SPRACHE, FORM_UND_INHALT, ID_NR, PARENT_ID_NR, HIERARCHIE_PFAD, SCHUTZFRISTENDE, ZUGAENGLICHKEIT_NM FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordResource ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:title ;
		rr:objectMap [
			rr:column "TITEL" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:identifier ;
		rr:objectMap [
			rr:column "SIGNATUR" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:scopeAndContent ;
		rr:objectMap [
			rr:column "DARIN" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:scopeAndContent ;
		rr:objectMap [
			rr:column "ENTHAELT" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:type ;
		rr:objectMap [
			rr:column "ARCHIVALIENART" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:conditionsOfAccess ;
		rr:objectMap [
			rr:column "ZUGANGSBESTIMMUNGEN" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:conditionsOfUse ;
		rr:objectMap [
			rr:column "ZUGAENGLICHKEIT_NM" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:isAssociatedWithDate ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Date" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:column "ANMERKUNGEN" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:isReferencedBy ;
		rr:objectMap [
			rr:template "https://dls.staatsarchiv.bs.ch/records/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate stabs-d:ID_NR ;
		rr:objectMap [
			rr:column "ID_NR" ;
			rr:datatype xsd:string ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate stabs-d:PHYSISCHE_BESCHAFFENHEIT ;
		rr:objectMap [
			rr:column "PHYSISCHE_BESCHAFFENHEIT" ;
			rr:datatype xsd:string ;
		];
	]
.
<#level_archive>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, ARCHIVGESCHICHTE FROM MVK_OGD_VRZNG_ENHT_1 WHERE ID_NR = 548575""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:history ;
		rr:objectMap [
			rr:column "ARCHIVGESCHICHTE" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Archiv> ;
		];
	]
.
<#level_abt>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE like 'Abteilung'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Abteilung> ;
		];
	]
.
<#level_fonds>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR, AKTENBILDNER_PROVENIENZ_TEXT FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE LIKE 'Fonds'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasProvenance ;
		rr:objectMap [
			rr:column "AKTENBILDNER_PROVENIENZ_TEXT" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Fonds> ;
		];
	]
.
<#level_best>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR, AKTENBILDNER_PROVENIENZ_TEXT FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE LIKE 'Bestand'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasProvenance ;
		rr:objectMap [
			rr:column "AKTENBILDNER_PROVENIENZ_TEXT" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Bestand> ;
		];
	]
.
<#level_series>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE LIKE 'Serie'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Serie> ;
		];
	]
.
<#level_dossier>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE LIKE 'Dossier'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordSet ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasRecordSetType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/recordSetTypes/Dossier> ;
		];
	]
.
<#level_dokument>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, PARENT_ID_NR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' and STUFE LIKE 'Dokument'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:Record ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIncludedIn ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{PARENT_ID_NR}" ;
		];
	]
.
<#date_01>
	rr:logicalTable [ rr:sqlQuery """SELECT ANMERKUNGEN, TITEL, SIGNATUR, STUFE, ENTSTEHUNGSZEITRAUM, PHYSISCHE_BESCHAFFENHEIT, DARIN, ARCHIVALIENART, ENTHAELT, RECHTSSTATUS, ZUGANGSBESTIMMUNGEN, SPRACHE, FORM_UND_INHALT, ID_NR, PARENT_ID_NR, HIERARCHIE_PFAD, SCHUTZFRISTENDE, ZUGAENGLICHKEIT_NM FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Date" ;
		rr:class rico:Date ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:expressedDate ;
		rr:objectMap [
			rr:column "ENTSTEHUNGSZEITRAUM" ;
		];
	]
.
<#ident_01>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, ALTE_SIGNATUREN FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND ALTE_SIGNATUREN IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Old-Reference/{ALTE_SIGNATUREN}" ;
		rr:class rico:Identifier ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIdentifierOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasIdentifierType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/identifierTypes/Alte-Signatur> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:textualValue ;
		rr:objectMap [
			rr:column "ALTE_SIGNATUREN" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Wird verwendet zur Angabe allfällig vorhandener alter Signaturen." ;
		];
	]
.
<#ident_02>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, FRUEHERE_SIGNATUR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND FRUEHERE_SIGNATUR IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Former-Reference/{FRUEHERE_SIGNATUR}" ;
		rr:class rico:Identifier ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIdentifierOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasIdentifierType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/identifierTypes/Fruehere-Signatur> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:textualValue ;
		rr:objectMap [
			rr:column "FRUEHERE_SIGNATUR" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Angabe der von der Provenienzstelle verwendeten Signatur oder identifizierenden Bezeichnung" ;
		];
	]
.
<#ident_03>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, FRUEHERE_STABS_SIGNATUR FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND FRUEHERE_STABS_SIGNATUR IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Former-StABS-Reference/{FRUEHERE_STABS_SIGNATUR}" ;
		rr:class rico:Identifier ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasIdentifierOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasIdentifierType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/identifierTypes/Fruehere-StABS-Signatur> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:textualValue ;
		rr:objectMap [
			rr:column "FRUEHERE_STABS_SIGNATUR" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Signaturen, die früher in Gebrauch waren. Signaturen können bei einer Mutation automatisch in dieses Feld übertragen werden." ;
		];
	]
.
<#extent_lm>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, LAUFMETER FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND LAUFMETER IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Extent/linear-meters" ;
		rr:class rico:RecordResourceExtent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isExtentOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasExtentType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/extentTypes/Laufmeter> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:quantity ;
		rr:objectMap [
			rr:column "LAUFMETER" ;
			rr:datatype xsd:decimal ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasUnitOfMeasurement ;
		rr:objectMap [
			rr:constant <http://qudt.org/vocab/unit/M> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Laufmeter" ;
		];
	]
.
<#extent_num>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, ANZAHL FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND ANZAHL IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Extent/number-of-units" ;
		rr:class rico:RecordResourceExtent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isExtentOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasExtentType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/extentTypes/Anzahl> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:quantity ;
		rr:objectMap [
			rr:column "ANZAHL" ;
			rr:datatype xsd:integer ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Anzahl Einheiten oder Behältnisse" ;
		];
	]
.
<#extent_num_files>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, ANZAHL_DATEIEN FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND ANZAHL_DATEIEN IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Extent/number-of-files" ;
		rr:class rico:RecordResourceExtent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isExtentOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasExtentType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/extentTypes/Anzahl-Dateien> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:quantity ;
		rr:objectMap [
			rr:column "ANZAHL_DATEIEN" ;
			rr:datatype xsd:integer ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Umfangangabe für Archivgut in digitaler Form, das aus Dateien besteht." ;
		];
	]
.
<#extent_data_vol>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, DATENVOLUMEN_MB FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND DATENVOLUMEN_MB IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Extent/volume-of-data" ;
		rr:class rico:RecordResourceExtent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isExtentOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasExtentType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/extentTypes/Datenvolumen-MB> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:quantity ;
		rr:objectMap [
			rr:column "DATENVOLUMEN_MB" ;
			rr:datatype xsd:decimal ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Angabe des enthaltenen Datenvolumens in Megabyte (MB)" ;
		];
	]
.
<#extent_approx>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, UMFANG_GESCHAETZT FROM MVK_OGD_VRZNG_ENHT_1 WHERE HIERARCHIE_PFAD LIKE '00000796390000548575%' AND UMFANG_GESCHAETZT IS NOT NULL""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}/Extent/extent-approximative" ;
		rr:class rico:RecordResourceExtent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:isExtentOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasExtentType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/extentTypes/Umfang-approximativ> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:textualValue ;
		rr:objectMap [
			rr:column "UMFANG_GESCHAETZT" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:constant "Wert für den Umfang, wenn keine präzisen Zahlen vorliegen." ;
		];
	]
.
<#prov_1>
	rr:logicalTable [ rr:sqlQuery """SELECT MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_VRZNG_ENHT AS VE_ID, MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_PRTNR AS PR_ID, MVK_OGD_PRTNR_1.ID_NAME AS PR_NAME FROM MVK_OGD_VE_PRTNR_BZHNG_1 JOIN MVK_OGD_PRTNR_1 ON MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_PRTNR = MVK_OGD_PRTNR_1.ID_NR""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Agent/{PR_ID}" ;
		rr:class rico:Agent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:name ;
		rr:objectMap [
			rr:column "PR_NAME" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:isProvenanceOf ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Record/{VE_ID}" ;
		];
	]
.
<#bioghist_1>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, VERWALTUNGSGESCHICHTE_BIOGRAFI FROM MVK_OGD_VRZNG_ENHT_1 WHERE VERWALTUNGSGESCHICHTE_BIOGRAFI IS NOT NULL AND (STUFE LIKE 'Fonds' OR STUFE LIKE 'Bestand')""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class rico:RecordResource ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:history ;
		rr:objectMap [
			rr:column "VERWALTUNGSGESCHICHTE_BIOGRAFI" ;
			rr:language "ger" ;
		];
	]
.
<#bioghist_2>
	rr:logicalTable [ rr:sqlQuery """SELECT MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_PRTNR AS PR_ID, MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_VRZNG_ENHT AS VE_ID, MVK_OGD_VRZNG_ENHT_1.ORGANISATIONSZUGEHOERIGKEIT, MVK_OGD_VRZNG_ENHT_1.GESCHICHTE, MVK_OGD_VRZNG_ENHT_1.ORT, MVK_OGD_VRZNG_ENHT_1.FUNKTION_UND_AKTIVITAET, MVK_OGD_VRZNG_ENHT_1.ALLGEMEINER_KONTEXT FROM MVK_OGD_VE_PRTNR_BZHNG_1 JOIN MVK_OGD_VRZNG_ENHT_1 ON MVK_OGD_VRZNG_ENHT_1.ID_NR = MVK_OGD_VE_PRTNR_BZHNG_1.ID_NR_VRZNG_ENHT AND  MVK_OGD_VRZNG_ENHT_1.ANZEIGEFORMULAR_ID = 10146""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Agent/{PR_ID}" ;
		rr:class rico:Agent ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:history ;
		rr:objectMap [
			rr:column "GESCHICHTE" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasOrHadLocation ;
		rr:objectMap [
			rr:column "ORT" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:isOrWasPartOf ;
		rr:objectMap [
			rr:column "ORGANISATIONSZUGEHOERIGKEIT" ;
		];
	]
.
<#hbg_records>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, ALTE_HAUSNUMMER, EIGENTUEMER_1862, HAUSNAME FROM MVK_OGD_VRZNG_ENHT_1 WHERE ANZEIGEFORMULAR_ID = 10148""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR}" ;
		rr:class stabs-rico:RecordHBG ;
	];
	
	rr:predicateObjectMap [
		rr:predicate stabs-rico:houseNameBS ;
		rr:objectMap [
			rr:column "HAUSNAME" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate stabs-rico:oldHousenumber ;
		rr:objectMap [
			rr:column "ALTE_HAUSNUMMER" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate stabs-rico:owner1862 ;
		rr:objectMap [
			rr:column "EIGENTUEMER_1862" ;
			rr:language "ger" ;
		];
	]
.
<#thes_pers>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, BEZEICHNUNG, BESCHREIBUNG FROM MVK_OGD_DSKRP_1 WHERE THESAURUS LIKE 'Personenbegriffe'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Agent/{ID_NR}" ;
		rr:class rico:Agent ;
		rr:class skos:Concept ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:name ;
		rr:objectMap [
			rr:column "BEZEICHNUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:column "BESCHREIBUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:prefLabel ;
		rr:objectMap [
			rr:column "BEZEICHNUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:note ;
		rr:objectMap [
			rr:column "BESCHREIBUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:inScheme ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/thesaurusTypes/Personenbegriffe> ;
		];
	]
.
<#thes_ort>
	rr:logicalTable [ rr:sqlQuery """SELECT ID_NR, BEZEICHNUNG, BESCHREIBUNG FROM MVK_OGD_DSKRP_1 WHERE THESAURUS LIKE 'Ortsbegriffe'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Place/{ID_NR}" ;
		rr:class rico:Place ;
		rr:class skos:Concept ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:name ;
		rr:objectMap [
			rr:column "BEZEICHNUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:descriptiveNote ;
		rr:objectMap [
			rr:column "BESCHREIBUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:prefLabel ;
		rr:objectMap [
			rr:column "BEZEICHNUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:note ;
		rr:objectMap [
			rr:column "BESCHREIBUNG" ;
			rr:language "ger" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate skos:inScheme ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/thesaurusTypes/Ortsbegriffe> ;
		];
	]
.
<#rr2thes_pers>
	rr:logicalTable [ rr:sqlQuery """SELECT BZ.ID_NR_DSKRP AS ID_DS, BZ.ID_NR_VRZNG_ENHT AS ID_VE FROM MVK_OGD_VE_DSKRP_BZHNG_1 BZ INNER JOIN MVK_OGD_DSKRP_1 DS ON  BZ.ID_NR_DSKRP = DS.ID_NR WHERE DS.THESAURUS LIKE 'Personenbegriffe'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_VE}" ;
		rr:class rico:RecordResource ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:hasOrHadMainSubject ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Agent/{ID_DS}" ;
		];
	]
.
<#rr2thes_ort>
	rr:logicalTable [ rr:sqlQuery """SELECT BZ.ID_NR_DSKRP AS ID_DS, BZ.ID_NR_VRZNG_ENHT AS ID_VE FROM MVK_OGD_VE_DSKRP_BZHNG_1 BZ INNER JOIN MVK_OGD_DSKRP_1 DS ON  BZ.ID_NR_DSKRP = DS.ID_NR WHERE DS.THESAURUS LIKE 'Ortsbegriffe'""" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_VE}" ;
		rr:class rico:RecordResource ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:hasOrHadMainSubject ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Place/{ID_DS}" ;
		];
	]
.
<#abl>
	rr:logicalTable [ rr:tableName "MVK_OGD_ABLFR_1" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Event/{ID_NR}" ;
		rr:class rico:Activity ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:name ;
		rr:objectMap [
			rr:template "Ablieferung Nr. {JAHR_LAUF_NR}" ;
			rr:termType rr:Literal ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:identifier ;
		rr:objectMap [
			rr:column "ID_NR" ;
			rr:datatype xsd:string ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:hasActivityType ;
		rr:objectMap [
			rr:constant <https://ld.staatsarchiv.bs.ch/vocabularies/activityTypes/Ablieferung> ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:type ;
		rr:objectMap [
			rr:template "Typ {TYP} / Subtyp {SUBTYP}" ;
			rr:termType rr:Literal ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:agentOrActivityIsTargetOfProvenanceRelation ;
		rr:objectMap [
			rr:column "AKTENBILDENDE_STELLE" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate rico:date ;
		rr:objectMap [
			rr:column "ZEITRAUM_PERIODE" ;
		];
	]
.
<#abl2ve>
	rr:logicalTable [ rr:tableName "MVK_OGD_VE_ABLFR_BZHNG_1" ];
	
	rr:subjectMap [
		rr:template "https://ld.staatsarchiv.bs.ch/Record/{ID_NR_VRZNG_ENHT}" ;
	];
	
	rr:predicateObjectMap [
		rr:predicate rico:resultsOrResultedFrom ;
		rr:objectMap [
			rr:template "https://ld.staatsarchiv.bs.ch/Event/{ID_NR_ABLFR}" ;
		];
	]
.