# ==================================================================
#  LingoMap v2.0 - AI Generated Semantic Blueprint
#  Generated on: 2025-07-01 08:58:35
# ==================================================================

@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix mymap: <http://example.com/mapping-schema#> .
@prefix vocab: <http://example.com/vocab/> .
@prefix dcat: <http://www.w3.org/ns/dcat#> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

# --- Standard Vocabularies ---
@prefix fibo-be-le-fbo: <https://spec.edmcouncil.org/fibo/ontology/BE/LegalEntities/FormalBusinessOrganizations/> .
@prefix fibo-fbc-fct-fse: <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/FinancialServicesEntities/> .
@prefix fibo-fnd-plc-adr: <https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/> .
@prefix fibo-fnd-rel-rel: <https://spec.edmcouncil.org/fibo/ontology/FND/Relations/Relations/> .
@prefix fibo-fnd-dt-fd: <https://spec.edmcouncil.org/fibo/ontology/FND/DatesAndTimes/FinancialDates/> .
@prefix fibo-ind-ei-ei: <https://spec.edmcouncil.org/fibo/ontology/IND/EconomicIndicators/EconomicIndicators/> .
@prefix fibo-fbc-pas-caa: <https://spec.edmcouncil.org/fibo/ontology/FBC/ProductsAndServices/ClientsAndAccounts/> .
@prefix fibo-fnd-org-org: <https://spec.edmcouncil.org/fibo/ontology/FND/Organizations/Organizations/> .
@prefix fibo-be-oac-cctl: <https://spec.edmcouncil.org/fibo/ontology/BE/OwnershipAndControl/CorporateControl/> .
@prefix fibo-fnd-utl-alx: <https://spec.edmcouncil.org/fibo/ontology/FND/Utilities/Analytics/> .
@prefix cmns-cls: <https://www.omg.org/spec/Commons/Classifiers/> .
@prefix cmns-col: <https://www.omg.org/spec/Commons/Collections/> .
@prefix cmns-loc: <https://www.omg.org/spec/Commons/Locations/> .
@prefix cmns-dt: <https://www.omg.org/spec/Commons/DatesAndTimes/> .
@prefix cmns-id: <https://www.omg.org/spec/Commons/Identifiers/> .
@prefix cmns-org: <https://www.omg.org/spec/Commons/Organizations/> .
@prefix cmns-txt: <https://www.omg.org/spec/Commons/TextDatatype/> .
@prefix lcc-lr: <https://www.omg.org/spec/LCC/Languages/LanguageRepresentation/> .
@prefix geo: <http://www.opengis.net/ont/geosparql#> .
@prefix geor: <http://www.opengis.net/def/rule/geosparql/> .
@prefix geof: <http://www.opengis.net/def/function/geosparql/> .
@prefix sf: <http://www.opengis.net/ont/sf#> .
@prefix schema: <https://schema.org/> .


# --- 1. Entity & Association Definitions ---

<#FinancialInstitutionEntity>
    a mymap:EntityMapping ;
    rdfs:label "Financial Institution"@en ;
    rdfs:comment "Represents a financial institution, identified by a certificate, name, and a unique institution number. This entity is a core business concept for identifying and tracking financial entities."@en ;
    mymap:mapsToClass fibo-fbc-fct-fse:FinancialInstitution .


<#BranchOfficeEntity>
    a mymap:EntityMapping ;
    rdfs:label "Branch Office"@en ;
    rdfs:comment "Represents a physical branch office of a financial institution or other organization, identified by its unique number, name, service type, and other descriptive attributes."@en ;
    mymap:mapsToClass fibo-be-le-fbo:Branch .


<#BranchLocationEntity>
    a mymap:EntityMapping ;
    rdfs:label "Branch Location"@en ;
    rdfs:comment "Represents the physical location of a branch, including its address, city, state, and postal code."@en ;
    mymap:mapsToClass fibo-be-le-fbo:Branch .


<#GeospatialCoordinatesEntity>
    a mymap:EntityMapping ;
    rdfs:label "Geospatial Coordinates"@en ;
    rdfs:comment "Represents a set of latitude and longitude coordinates defining a location on Earth."@en ;
    mymap:mapsToClass schema:GeoCoordinates .


<#CoreBasedStatisticalAreaEntity>
    a mymap:EntityMapping ;
    rdfs:label "Core Based Statistical Area"@en ;
    rdfs:comment "Represents a statistical geographic entity defined by the US Office of Management and Budget (OMB) and used for statistical reporting. Encompasses metropolitan and micropolitan statistical areas."@en ;
    mymap:mapsToClass fibo-ind-ei-ei:CombinedStatisticalArea .


<#CombinedStatisticalAreaEntity>
    a mymap:EntityMapping ;
    rdfs:label "Combined Statistical Area"@en ;
    rdfs:comment "Represents a Combined Statistical Area (CSA) as defined by the US Office of Management and Budget for statistical reporting purposes. A CSA consists of two or more adjacent Metropolitan Statistical Areas and/or Micropolitan Statistical Areas."@en ;
    mymap:mapsToClass fibo-ind-ei-ei:CombinedStatisticalArea .


<#ReportingEventEntity>
    a mymap:EntityMapping ;
    rdfs:label "Reporting Event"@en ;
    rdfs:comment "Represents a specific event associated with the act of reporting, capturing key dates such as acquisition, estimation, and run dates."@en ;
    mymap:mapsToClass <https://spec.edmcouncil.org/fibo/ontology/FND/Arrangements/Reporting/hasReportDate> .


<#MinorityDepositoryInstitutionEntity>
    a mymap:EntityMapping ;
    rdfs:label "Minority Depository Institution"@en ;
    rdfs:comment "A financial institution that is recognized by a regulatory agency as serving predominantly minority populations or communities."@en ;
    mymap:mapsToClass fibo-fbc-fct-fse:FinancialInstitution .

# --- 2. Association Mappings ---

<#linkBranchOfficeToFinancialInstitution>
    a mymap:AssociationMapping ;
    rdfs:comment "A branch office is a subunit of a financial institution."@en ;
    mymap:linksEntity <#BranchOfficeEntity> ;
    mymap:toEntity <#FinancialInstitutionEntity> ;
    mymap:usingProperty fibo-fnd-org-org:isSubUnitOf .


<#linkBranchOfficeToBranchLocation>
    a mymap:AssociationMapping ;
    rdfs:comment "A branch office has a location, which is represented by a BranchLocationEntity."@en ;
    mymap:linksEntity <#BranchOfficeEntity> ;
    mymap:toEntity <#BranchLocationEntity> ;
    mymap:usingProperty schema:location .


<#linkBranchLocationToGeospatialCoordinates>
    a mymap:AssociationMapping ;
    rdfs:comment "A branch location has a geometry defined by geospatial coordinates."@en ;
    mymap:linksEntity <#BranchLocationEntity> ;
    mymap:toEntity <#GeospatialCoordinatesEntity> ;
    mymap:usingProperty geo:hasGeometry .


<#linkBranchLocationToCoreBasedStatisticalArea>
    a mymap:AssociationMapping ;
    rdfs:comment "A branch location is spatially within a Core Based Statistical Area."@en ;
    mymap:linksEntity <#BranchLocationEntity> ;
    mymap:toEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:usingProperty geor:sfWithin .


<#linkBranchLocationToCombinedStatisticalArea>
    a mymap:AssociationMapping ;
    rdfs:comment "A branch location is spatially within a Combined Statistical Area."@en ;
    mymap:linksEntity <#BranchLocationEntity> ;
    mymap:toEntity <#CombinedStatisticalAreaEntity> ;
    mymap:usingProperty geor:sfWithin .


<#linkFinancialInstitutionToReportingEvent>
    a mymap:AssociationMapping ;
    rdfs:comment "A Financial Institution has a reporting event, capturing the date of the report."@en ;
    mymap:linksEntity <#FinancialInstitutionEntity> ;
    mymap:toEntity <#ReportingEventEntity> ;
    mymap:usingProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Arrangements/Reporting/hasReportDate> .


<#linkMinorityDepositoryInstitutionToFinancialInstitution>
    a mymap:AssociationMapping ;
    rdfs:comment "A Minority Depository Institution is a financial institution classified by minority status."@en ;
    mymap:linksEntity <#MinorityDepositoryInstitutionEntity> ;
    mymap:toEntity <#FinancialInstitutionEntity> ;
    mymap:usingProperty cmns-cls:isClassifiedBy .

# --- 3. Column to Property Mappings ---

<#map_ADDRESS>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "ADDRESS" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasStreetAddress> ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'ADDRESS' column contains street address information for branch locations, aligning with the fibo:hasStreetAddress property, which is more specific than schema:address."@en .


<#map_ADDRESS2>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "ADDRESS2" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasAddressLine2> ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The `ADDRESS2` column, containing values like 'Ste 104', strongly suggests it represents the second line of an address, aligning perfectly with fibo's `hasAddressLine2` property."@en .


<#map_CITY>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CITY" ;
    mymap:mapsToProperty schema:addressLocality ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'CITY' contains city names, which aligns with the schema:addressLocality property for specifying the city in an address."@en .


<#map_STALP>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "STALP" ;
    mymap:mapsToProperty schema:addressRegion ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'STALP' column contains state abbreviations, which aligns with the semantic meaning of schema:addressRegion representing the region or state within an address."@en .


<#map_STNAME>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "STNAME" ;
    mymap:mapsToProperty schema:addressRegion ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'STNAME' column represents the name of the state, which aligns with schema:addressRegion, indicating the region or state within an address."@en .


<#map_ZIP>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "ZIP" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Places/Addresses/hasIndividualPostcode> ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'ZIP' contains postal codes for branch locations, and fibo:hasIndividualPostcode is the most semantically appropriate property for representing a postal code in the context of addresses and locations."@en .


<#map_COUNTY>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "COUNTY" ;
    mymap:mapsToProperty fibo-fnd-plc-adr:hasCounty ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'COUNTY' column represents the county in which the branch location is situated, aligning with the semantic meaning of fibo-fnd-plc-adr:hasCounty."@en .


<#map_STCNTY>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "STCNTY" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#BranchLocationEntity> ;
    mymap:confidenceScore "0.75"^^xsd:decimal ;
    rdfs:comment "STCNTY, a numeric code identifying state and county, serves as a location identifier."@en .


<#map_CERT>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CERT" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#FinancialInstitutionEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The CERT column represents a numeric identifier for a financial institution, making schema:identifier the most appropriate property."@en .


<#map_NAME>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "NAME" ;
    mymap:mapsToProperty schema:name ;
    mymap:partOfEntity <#FinancialInstitutionEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'NAME' contains the names of financial institutions, which aligns perfectly with the schema:name property designed for identifying the name of a thing."@en .


<#map_FI_UNINUM>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "FI_UNINUM" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#FinancialInstitutionEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "FI_UNINUM appears to be a numeric identifier for the financial institution, and schema:identifier is a standard property for identifying entities."@en .


<#map_UNINUM>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "UNINUM" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The UNINUM column contains unique numeric identifiers for branch offices, aligning with the definition of schema:identifier for identifying entities."@en .


<#map_OFFNAME>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "OFFNAME" ;
    mymap:mapsToProperty schema:name ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'OFFNAME' column contains the names of branch offices, and schema:name is the best property for representing the name of an entity."@en .


<#map_OFFNUM>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "OFFNUM" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "Given that OFFNUM is a numeric identifier for branch offices and schema:identifier is a commonly used property for identifying entities, schema:identifier is a suitable choice, and the data should be treated as a string to preserve any leading zeros or specific formatting."@en .


<#map_MAINOFF>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "MAINOFF" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "The column 'MAINOFF' likely indicates whether the branch is the main office (1.0) or not (0.0), which functions as an identifier or flag."@en .


<#map_ID>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "ID" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'ID' column contains unique numerical identifiers for branch offices, aligning with the semantic meaning of schema:identifier."@en .


<#map_SERVTYPE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "SERVTYPE" ;
    mymap:mapsToProperty schema:additionalType ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "SERVTYPE appears to be a code denoting the service type offered at the branch, aligning with the general concept of 'additionalType' from schema.org representing a more specific type."@en .


<#map_SERVTYPE_DESC>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "SERVTYPE_DESC" ;
    mymap:mapsToProperty schema:description ;
    mymap:partOfEntity <#BranchOfficeEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "The 'SERVTYPE_DESC' column provides a textual description of the service type offered by the branch office, aligning well with schema:description and it appears in the HIGHLY-RECOMMENDED PROPERTIES list."@en .


<#map_LATITUDE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "LATITUDE" ;
    mymap:mapsToProperty <https://schema.org/latitude> ;
    mymap:partOfEntity <#GeospatialCoordinatesEntity> ;
    mymap:confidenceScore "0.98"^^xsd:decimal ;
    rdfs:comment "The column 'LATITUDE' contains numeric values representing latitude coordinates, aligning perfectly with the schema.org/latitude property which is also in the high-quality properties list."@en .


<#map_LONGITUDE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "LONGITUDE" ;
    mymap:mapsToProperty schema:longitude ;
    mymap:partOfEntity <#GeospatialCoordinatesEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'LONGITUDE' contains numeric data representing longitude values, which aligns perfectly with the schema:longitude property."@en .


<#map_X>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "X" ;
    mymap:mapsToProperty schema:longitude ;
    mymap:partOfEntity <#GeospatialCoordinatesEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "Given the entity type is Geospatial Coordinates, the 'X' column representing numeric values between -166 and 163, is best mapped to schema:longitude."@en .


<#map_Y>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "Y" ;
    mymap:mapsToProperty schema:latitude ;
    mymap:partOfEntity <#GeospatialCoordinatesEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "Given the entity represents Geospatial Coordinates and the column 'Y' contains numeric values within a valid range for latitude, schema:latitude is the most appropriate property."@en .


<#map_CBSA>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CBSA" ;
    mymap:mapsToProperty schema:name ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.9"^^xsd:decimal ;
    rdfs:comment "The 'CBSA' column contains names of Core Based Statistical Areas, aligning with the schema:name property and the column data profile."@en .


<#map_CBSA_NO>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CBSA_NO" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'CBSA_NO' contains numeric identifiers for Core Based Statistical Areas, aligning with the semantic meaning of schema:identifier."@en .


<#map_CBSA_METRO>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CBSA_METRO" ;
    mymap:mapsToProperty <https://schema.org/identifier> ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.9"^^xsd:decimal ;
    rdfs:comment "The column 'CBSA_METRO' contains numeric identifiers for Core Based Statistical Areas, aligning with schema:identifier and having a numeric data type."@en .


<#map_CBSA_METRO_NAME>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CBSA_METRO_NAME" ;
    mymap:mapsToProperty schema:name ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'CBSA_METRO_NAME' contains the name of the Core Based Statistical Area, which aligns with the semantic meaning of schema:name."@en .


<#map_CBSA_METRO_FLG>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CBSA_METRO_FLG" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/Markets/hasMarketIdentifierCodeStatus> ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.75"^^xsd:decimal ;
    rdfs:comment "CBSA_METRO_FLG indicates whether the CBSA is a metropolitan area, thus representing the status of the CBSA's market identifier code."@en .


<#map_CBSA_MICRO_FLG>
    a mymap:ClassificationMapping ;
    mymap:sourceColumn "CBSA_MICRO_FLG" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/Markets/hasMarketIdentifierCodeStatus> ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.75"^^xsd:decimal ;
    rdfs:comment "The column indicates a binary status (flag) related to CBSA classification, aligning with the concept of a market identifier code status."@en .


<#map_CBSA_DIV>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CBSA_DIV" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.9"^^xsd:decimal ;
    rdfs:comment "The column 'CBSA_DIV' contains names that serve as identifiers for divisions within Core Based Statistical Areas, aligning with the purpose of schema:identifier."@en .


<#map_CBSA_DIV_NO>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CBSA_DIV_NO" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Utilities/Analytics/StatisticalAreaIdentifier> ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "CBSA_DIV_NO represents a numeric identifier for a Core Based Statistical Area division, and StatisticalAreaIdentifier from FIBO is a fitting property for such an identifier."@en .


<#map_CBSA_DIV_FLG>
    a mymap:ClassificationMapping ;
    mymap:sourceColumn "CBSA_DIV_FLG" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/Markets/hasMarketIdentifierCodeStatus> ;
    mymap:partOfEntity <#CoreBasedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "The column indicates whether the CBSA is a CBSA division, which can be interpreted as a status related to its market identifier code."@en .


<#map_CSA>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CSA" ;
    mymap:mapsToProperty schema:name ;
    mymap:partOfEntity <#CombinedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'CSA' column contains names of Combined Statistical Areas, aligning with the semantic meaning of schema:name."@en .


<#map_CSA_NO>
    a mymap:IdentifierMapping ;
    mymap:sourceColumn "CSA_NO" ;
    mymap:mapsToProperty schema:identifier ;
    mymap:partOfEntity <#CombinedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'CSA_NO' contains numeric identifiers for Combined Statistical Areas, making schema:identifier the most appropriate property and xsd:string the correct data type."@en .


<#map_CSA_FLG>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "CSA_FLG" ;
    mymap:mapsToProperty schema:statType ;
    mymap:partOfEntity <#CombinedStatisticalAreaEntity> ;
    mymap:confidenceScore "0.75"^^xsd:decimal ;
    rdfs:comment "The `CSA_FLG` column contains categorical data representing a statistical type or status related to the combined statistical area."@en .


<#map_ACQDATE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "ACQDATE" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/DatesAndTimes/FinancialDates/hasAcquisitionDate> ;
    mymap:partOfEntity <#ReportingEventEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "Given the column name ACQDATE, the data profile indicating a date type, and the context of ReportingEventEntity, fibo:hasAcquisitionDate is the most semantically appropriate property, particularly because it appears in both the RAG results and the highly-recommended properties list."@en .


<#map_ESTYMD>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "ESTYMD" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/DatesAndTimes/Occurrences/hasEventDateValue> ;
    mymap:partOfEntity <#ReportingEventEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The column 'ESTYMD' contains date values related to the occurrence of a reporting event, aligning with the fibo:hasEventDateValue property."@en .


<#map_RUNDATE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "RUNDATE" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FND/Arrangements/Reporting/hasReportDate> ;
    mymap:partOfEntity <#ReportingEventEntity> ;
    mymap:confidenceScore "0.95"^^xsd:decimal ;
    rdfs:comment "The 'RUNDATE' column contains date values related to a Reporting Event, aligning with the fibo:hasReportDate property for specifying the date of a report."@en .


<#map_MDI_STATUS_CODE>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "MDI_STATUS_CODE" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/BusinessRegistries/hasEntityStatus> ;
    mymap:partOfEntity <#MinorityDepositoryInstitutionEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "Given the column name 'MDI_STATUS_CODE', the high percentage of missing values and the sample values being numeric codes, fibo:hasEntityStatus is the most appropriate property to represent the status of the Minority Depository Institution."@en .


<#map_MDI_STATUS_DESC>
    a mymap:ColumnMapping ;
    mymap:sourceColumn "MDI_STATUS_DESC" ;
    mymap:mapsToProperty <https://spec.edmcouncil.org/fibo/ontology/FBC/FunctionalEntities/BusinessRegistries/hasEntityStatus> ;
    mymap:partOfEntity <#MinorityDepositoryInstitutionEntity> ;
    mymap:confidenceScore "0.85"^^xsd:decimal ;
    rdfs:comment "The `MDI_STATUS_DESC` column describes the status of the Minority Depository Institution, and `fibo-fbc-fct-fse:FinancialInstitution` can have `fibo-fbc-fct-breg:hasEntityStatus`."@en .