Attribute format comparison
The naming of attributes between CSV, GML and GPKG will be different due to the requirements of the file formats. The following tables map the CSV attribute name to the GML and GPKG attribute names.
Basic Land and Property Unit (BLPU)
CSV | GML | GPKG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GeoPackage |
CHANGE_TYPE | changeType (Provided in FeatureWithLifecycle) | change_type |
PRO_ORDER | Not required in GML | Not provided in GeoPackage |
UPRN | uprn | uprn |
LOGICAL_STATUS | logicalStatus | logical_status |
BLPU_STATE | blpuState | blpu_state |
BLPU_STATE_DATE | blpuStateDate | blpu_state_date |
PARENT_UPRN | parentUPRN | parent_uprn |
X_COORDINATE | position | x_coordinate |
Y_COORDINATE | position | y_coordinate |
LATITUDE | positionLatLong | latitude |
LONGITUDE | positionLatLong | longitude |
RPC | rpc | rpc |
LOCAL_CUSTODIAN_CODE | localCustodianCode | local_custodian_code |
COUNTRY | country | country |
START_DATE | startDate (Provided in FeatureWithLifecycle) | start_date |
END_DATE | endDate (Provided in FeatureWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in FeatureWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in FeatureWithLifecycle) | entry_date |
ADDRESSBASE_POSTAL | addressbasePostal | addressbase_postal |
POSTCODE_LOCATOR | postcodeLocator | postcode_locator |
MULTI_OCC_COUNT | multiOccCount | multi_occ_count |
Classification
CSV | GML | GKPG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GeoPackage |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GeoPackage |
URPN | uprn (obtained from the feature) | uprn |
CLASS_KEY | classKey | class_key |
CLASSIFICATION_CODE | classificationCode | classification_code |
CLASS_SCHEME | classScheme | class_scheme |
SCHEME_VERSION | schemeVersion | scheme_version |
START_DATE | START_DATE (Provided in EntityWithLifecycle) | start_date |
END_DATE | Provided in EntityWithLifecycle | end_date |
LAST_UPDATE_DATE | Provided in EntityWithLifecycle | last_update_date |
ENTRY_DATE | Provided in EntityWithLifecycle | entry_date |
Delivery Point Address
CSV | GML | GPKG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GKPG |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GKPG |
UPRN | uprn (obtained from the feature) | uprn |
UDPRN | udprn | udprn |
ORGANISATION_NAME | organisationName | organisation_name |
DEPARTMENT_NAME | departmentName | department_name |
SUB_BUILDING_NAME | subBuildingName | sub_building_name |
BUILDING_NAME | buildingName | building_name |
BUILDING_NUMBER | buildingNumber | building_number |
DEPENDENT_THOROUGHFARE | dependentThoroughfare | dependent_thoroughfare |
THOROUGHFARE | thoroughfare | thoroughfare |
DOUBLE_DEPENDENT_LOCA LITY | doubleDependentLocality | double_dependent_locality |
DEPENDENT_LOCALITY | dependentLocality | dependent_locality |
POST_TOWN | postTown | post_town |
POSTCODE | postcode | postcode |
POSTCODE_TYPE | postcodeType | postcode_type |
DELIVERY_POINT_SUFFIX | deliveryPointSuffix | delivery_point_suffix |
WELSH_DEPENDENT_THOR OUGHFARE | welshDependentThoroughfare | welsh_dependent_thoroughfare |
WELSH_THOROUGHFARE | welshThoroughfare | welsh_thoroughfare |
WELSH_DOUBLE_DEPENDEN T_LOCALITY | welshDoubleDependentLocality | welsh_double_dependent_locality |
WELSH_DEPENDENT_LOCALI TY | welshDependentLocality | welsh_dependent_locality |
WELSH_POST_TOWN | welshPostTown | welsh_post_town |
PO_BOX_NUMBER | poBoxNumber | po_box_number |
PROCESS_DATE | processDate | process_date |
START_DATE | START_DATE (Provided in EntityWithLifecycle) | start_date |
END_DATE | Provided in EntityWithLifecycle | end_date |
LAST_UPDATE_DATE | Provided in EntityWithLifecycle | last_update_date |
ENTRY_DATE | Provided in EntityWithLifecycle | entry_date |
Land Property Identifier (LPI)
CSV | GML | GPKG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GPKG |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GPKG |
UPRN | uprn (obtained from the feature) | uprn |
LPI_KEY | lpiKey | lpi_key |
LANGUAGE | Provided within an ‘xml:lang’ tag | language |
LOGICAL_STATUS | logicalStatus | logical_status |
START_DATE | startDate (Provided in EntityWithLifecycle) | start_date |
END_DATE | endDate (Provided in EntityWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in EntityWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in EntityWithLifecycle) | entry_date |
SAO_START_NUMBER | saoStartNumber | sao_start_number |
SAO_START_SUFFIX | saoStartSuffix | sao_start_suffix |
SAO_END_NUMBER | saoEndNumber | sao_end_number |
SAO_END_SUFFIX | saoEndSuffix | sao_end_suffix |
SAO_TEXT | saoText | sao_text |
PAO_START_NUMBER | paoStartNumber | pao_start_number |
PAO_START_SUFFIX | paoStartSuffix | pao_start_suffix |
PAO_END_NUMBER | paoEndNumber | pao_end_number |
PAO_END_SUFFIX | paoEndSuffix | pao_end_suffix |
PAO_TEXT | paoText | pao_text |
USRN | usrn | usrn |
USRN_MATCH_INDICATOR | usrnMatchIndicator | usrn_match_indicator |
AREA_NAME | areaName | area_name |
LEVEL | level | level |
OFFICIAL_FLAG | officialFlag | official_flag |
Organisation
CSV | GML | GPKG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GPKG |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GPKG |
UPRN | uprn (obtained from the feature) | uprn |
ORG_KEY | orgKey | org_key |
ORGANISATION | organisation | organisation |
LEGAL_NAME | legalName | legal_name |
START_DATE | startDate (Provided in EntityWithLifecycle) | start_date |
END_DATE | endDate (Provided in EntityWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in EntityWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in EntityWithLifecycle) | entry_date |
Application Cross Reference
CSV | GML | GPKG |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GPKG |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GPKG |
UPRN | uprn (obtained from the feature) | uprn |
XREF_KEY | xrefKey | xref_key |
CROSS_REFERENCE | crossReference | cross_reference |
VERSION | version | version |
SOURCE | source | source |
START_DATE | startDate (Provided in EntityWithLifecycle) | start_date |
END_DATE | endDate (Provided in EntityWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in EntityWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in EntityWithLifecycle) | entry_date |
Street
CSV | GML | GeoPackage |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GeoPackage |
CHANGE_TYPE | changeType (Provided in FeatureWithLifecycle) | change_type |
PRO_ORDER | Not required in GML | Not provided in GeoPackage |
USRN | usrn | usrn |
RECORD_TYPE | recordType | record_type |
SWA_ORG_REF_NAMING | swaOrgRefNaming | swa_org_ref_naming |
STATE | state | state |
STATE_DATE | stateDate | state_date |
STREET_SURFACE | streetSurface | street_surface |
STREET_CLASSIFICATION | streetClassification | street_classification |
VERSION | version | version |
STREET_START_DATE | startDate (Provided in FeatureWithLifecycle) | street_start_date |
STREET_END_DATE | endDate (Provided in FeatureWithLifecycle) | street_end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in FeatureWithLifecycle) | last_update_date |
RECORD_ENTRY_DATE | entryDate (Provided in FeatureWithLifecycle) | record_entry_date |
STREET_START_X | streetStart | street_start_x |
STREET_START_Y | streetStart | street_start_y |
STREET_START_LAT | streetStartLatLong | street_start_lat |
STREET_START_LONG | streetStartLatLong | street_start_long |
STREET_END_X | streetEnd | street_end_x |
STREET_END_Y | streetEnd | street_end_y |
STREET_END_LAT | steetEndLatLong | street_end_lat |
STREET_END_LONG | steetEndLatLong | street_end_long |
STREET_TOLERANCE | streetTolerance | street_tolerance |
Street Description
CSV | GML | GeoPackage |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GeoPackage |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GeoPackage |
USRN | usrn (obtained from the feature) | usrn |
STREET_DESCRIPTION | streetDescription | street_description |
LOCALITY | locality | locality |
TOWN_NAME | townName | town_name |
ADMINSTRATIVE_AREA | administrativeArea | administrative_area |
LANGUAGE | Provided within an ‘xml:lang’ tag | language |
START_DATE | startDate (Provided in EntityWithLifecycle) | start_date |
END_DATE | endDate (Provided in EntityWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in EntityWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in EntityWithLifecycle) | entry_date |
Successor
CSV | GML | GeoPackage |
---|---|---|
RECORD_IDENTIFIER | Not required in GML | Not provided in GeoPackage |
CHANGE_TYPE | Not required in GML | change_type |
PRO_ORDER | Not required in GML | Not provided in GeoPackage |
UPRN | uprn | uprn |
SUCC_KEY | succKey | succ_key |
START_DATE | startDate (Provided in EntityWithLifecycle) | start_date |
END_DATE | endDate (Provided in EntityWithLifecycle) | end_date |
LAST_UPDATE_DATE | lastUpdateDate (Provided in EntityWithLifecycle) | last_update_date |
ENTRY_DATE | entryDate (Provided in EntityWithLifecycle) | entry_date |
SUCCESSOR | successor | successor |
Entity with Life Cycle
CSV | GML | GKPG |
---|---|---|
Provided within the datatypes | startDate | Provided within the datatypes |
Provided within the datatypes | endDate | Provided within the datatypes |
Provided within the datatypes | lastUpdateDate | Provided within the datatypes |
Provided within the datatypes | entryDate | Provided within the datatypes |
Feature with Life Cycle
CSV | GML | GKPG |
---|---|---|
Provided within the feature type | changeType | Provided within the feature type |
Provided within the feature type | startDate | Provided within the feature type |
Provided within the feature type | endDate | Provided within the feature type |
Provided within the feature type | lastUpdateDate | Provided within the feature type |
Provided within the feature type | entryDate | Provided within the feature type |
Last updated