PREFIX rr: <http://www.w3.org/ns/r2rml#>
PREFIX fdic: <http://example.com/fdic#>
PREFIX fdicfields: <http://example.com/fdicfields/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX schema: <http://schema.org/>

<#FDICBank>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{CERT}";
		rr:class schema:Organization
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:name;
		rr:objectMap [
			rr:column "NAME"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:address;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{CERT}/address"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:geo;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{CERT}/location"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate prov:generatedAtTime;
		rr:objectMap [
			rr:column "RUNDATE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate geo:lat;
		rr:objectMap [
			rr:column "LATITUDE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate geo:long;
		rr:objectMap [
			rr:column "LONGITUDE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:isMainLocation;
		rr:objectMap [
			rr:column "MAINOFF"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:identifier;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{CERT}/identifier/cert"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:identifier;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{FI_UNINUM}/identifier/fiuninum"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:identifier;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{UNINUM}/identifier/uninum"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:identifier;
		rr:objectMap [
			rr:template "http://example.com/fdicbanks/{ID}/identifier/id"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasBankClassification;
		rr:objectMap [
			rr:column "BKCLASS"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasCBSARegion;
		rr:objectMap [
			rr:column "CBSA"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasCSARegion;
		rr:objectMap [
			rr:column "CSA"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasMDIStatus;
		rr:objectMap [
			rr:column "MDI_STATUS_CODE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasServiceType;
		rr:objectMap [
			rr:column "SERVTYPE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:hasCountyFIPS;
		rr:objectMap [
			rr:column "STCNTY"
		]
	].
	
<#FDICBankIdentifierCERT>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{CERT}/identifier/cert";
		rr:class schema:PropertyValue
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:propertyID;
		rr:objectMap [
			rr:constant "FDIC Certificate Number"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:value;
		rr:objectMap [
			rr:column "CERT"
		]
	].
	
<#FDICBankIdentifierFIUNINUM>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{FI_UNINUM}/identifier/fiuninum";
		rr:class schema:PropertyValue
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:propertyID;
		rr:objectMap [
			rr:constant "FI_UNINUM"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:value;
		rr:objectMap [
			rr:column "FI_UNINUM"
		]
	].
	
<#FDICBankIdentifierUNINUM>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{UNINUM}/identifier/uninum";
		rr:class schema:PropertyValue
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:propertyID;
		rr:objectMap [
			rr:constant "UNINUM"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:value;
		rr:objectMap [
			rr:column "UNINUM"
		]
	].
	
<#FDICBankIdentifierID>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{ID}/identifier/id";
		rr:class schema:PropertyValue
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:propertyID;
		rr:objectMap [
			rr:constant "Record ID"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:value;
		rr:objectMap [
			rr:column "ID"
		]
	].
	
<#FDICBankAddress>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{CERT}/address";
		rr:class schema:PostalAddress
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:streetAddress;
		rr:objectMap [
			rr:column "ADDRESS"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:addressLocality;
		rr:objectMap [
			rr:column "CITY"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:addressRegion;
		rr:objectMap [
			rr:column "STNAME"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:postalCode;
		rr:objectMap [
			rr:column "ZIP"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:addressCountry;
		rr:objectMap [
			rr:constant "US"
		]
	].
	
<#FDICBankLocation>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{CERT}/location";
		rr:class geo:SpatialThing
	];
	
	rr:predicateObjectMap [
		rr:predicate geo:lat;
		rr:objectMap [
			rr:column "LATITUDE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate geo:long;
		rr:objectMap [
			rr:column "LONGITUDE"
		]
	].
	
<#FDICBankRecord>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:tableName "fdic_insured_banks" ];
	
	rr:subjectMap [
		rr:template "http://example.com/fdicbanks/{CERT}/record";
		rr:class fdicfields:fdic_insured_banks
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:coordinateX;
		rr:objectMap [
			rr:column "X"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:coordinateY;
		rr:objectMap [
			rr:column "Y"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:gisObjectID;
		rr:objectMap [
			rr:column "OBJECTID"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdicfields:acquisitionDate;
		rr:objectMap [
			rr:column "ACQDATE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:addressLine2;
		rr:objectMap [
			rr:column "ADDRESS2"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdicfields:bankClassCode;
		rr:objectMap [
			rr:column "BKCLASS"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaName;
		rr:objectMap [
			rr:column "CBSA"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaDivisionName;
		rr:objectMap [
			rr:column "CBSA_DIV"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaDivisionFlag;
		rr:objectMap [
			rr:column "CBSA_DIV_FLG"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaDivisionCode;
		rr:objectMap [
			rr:column "CBSA_DIV_NO"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaMetroCode;
		rr:objectMap [
			rr:column "CBSA_METRO"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaMetroFlag;
		rr:objectMap [
			rr:column "CBSA_METRO_FLG"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaMetroName;
		rr:objectMap [
			rr:column "CBSA_METRO_NAME"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaMicroFlag;
		rr:objectMap [
			rr:column "CBSA_MICRO_FLG"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:cbsaCode;
		rr:objectMap [
			rr:column "CBSA_NO"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:countyName;
		rr:objectMap [
			rr:column "COUNTY"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:csaName;
		rr:objectMap [
			rr:column "CSA"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:csaFlag;
		rr:objectMap [
			rr:column "CSA_FLG"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:csaCode;
		rr:objectMap [
			rr:column "CSA_NO"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:establishmentDate;
		rr:objectMap [
			rr:column "ESTYMD"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:mdiStatusCode;
		rr:objectMap [
			rr:column "MDI_STATUS_CODE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:mdiStatusDescription;
		rr:objectMap [
			rr:column "MDI_STATUS_DESC"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:branchName;
		rr:objectMap [
			rr:column "OFFNAME"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:branchNumber;
		rr:objectMap [
			rr:column "OFFNUM"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:serviceTypeCode;
		rr:objectMap [
			rr:column "SERVTYPE"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:serviceTypeDescription;
		rr:objectMap [
			rr:column "SERVTYPE_DESC"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:stateAbbreviation;
		rr:objectMap [
			rr:column "STALP"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:stateCountyFIPS;
		rr:objectMap [
			rr:column "STCNTY"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:stateName;
		rr:objectMap [
			rr:column "STNAME"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdic:uniqueBranchNumber;
		rr:objectMap [
			rr:column "UNINUM"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate fdicfields:postalCode;
		rr:objectMap [
			rr:column "ZIP"
		]
	].