@prefix fdicib: <https://somanyaircraft.com/data/experimental/fdicib/schema/core#> .
@prefix tmp: <https://somanyaircraft.com/data/experimental/fdicib/schema/tmp#> .
@prefix rr: <http://www.w3.org/ns/r2rml#>.
@prefix rre: <https://somanyaircraft.com/data/schemata/tinyrml/1/core#> .  # wrong
@prefix xsd: <http://www.w3.org/2001/XMLSchema#>.
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix fibo-be-le-fbo: <https://spec.edmcouncil.org/fibo/ontology/BE/LegalEntities/FormalBusinessOrganizations/> .
@prefix fibo-fnd-dt-fd: <https://spec.edmcouncil.org/fibo/ontology/FND/DatesAndTimes/FinancialDates/> .
@prefix fibo-fnd-plc-adr: <https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/> .
@prefix cmns-dt: <https://www.omg.org/spec/Commons/DatesAndTimes/> .
@prefix lcc-cr: <https://www.omg.org/spec/LCC/Countries/CountryRepresentation/> .

fdicib:FDIC-Insured-Bank-mapping a rr:TriplesMap ;
	rr:subjectMap [
		rr:template "https://somanyaircraft.com/data/experimental/fdicib/data/branch#{UNINUM}" ;
		rr:class fibo-be-le-fbo:Branch
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:institutionName ;
		rr:objectMap [ rr:column "NAME" ]
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:officeName ;
		rr:objectMap [ rr:column "OFFNAME" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:id ;
		rr:objectMap [ rr:column "ID" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:ownerInstution ;
		rr:objectMap [ rr:template "https://somanyaircraft.com/data/experimental/fdicib/data/branch#{FI_UNINUM}" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate lcc-cr:hasLatitude ;
		rr:objectMap [ rr:column "LATITUDE" ; rr:datatype xsd:float ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate lcc-cr:hasLongitude ;
		rr:objectMap [ rr:column "LONGITUDE" ; rr:datatype xsd:float ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate tmp:address ;
		rr:objectMap [ rre:expression "ADDRESS + (', ' + ADDRESS2 if ADDRESS2 else '')" ;
					   rr:termType rr:Literal ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate tmp:zip ;
		rr:objectMap [ rr:column "ZIP" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate tmp:state ;
		rr:objectMap [ rr:column "STALP" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:coreBasedStatisticalAreaName ;
		rr:objectMap [ rr:column "CBSA" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:combinedStatisticalAreaName ;
		rr:objectMap [ rr:column "CSA" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate tmp:city ;
		rr:objectMap [ rr:column "CITY" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:county ;
		rr:objectMap [ rr:column "COUNTY" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:serviceTypeDescription ;
		rr:objectMap [ rr:column "SERVTYPE_DESC" ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fibo-fnd-dt-fd:hasAcquisitionDate ;
		rr:objectMap [ rre:expression "convert_excel_date(ACQDATE)" ;
					   rr:termType rr:Literal ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:hasRunDate ;
		rr:objectMap [ rre:expression "convert_excel_date(RUNDATE)" ;
					   rr:termType rr:Literal ] ;
	] ;
	rr:predicateObjectMap [
		rr:predicate fdicib:bankClass ;
		rr:objectMap [ rr:template "https://somanyaircraft.com/data/experimental/fdicib/schema/core#{BKCLASS}" ] ;
	] ;
.