Attribute format comparison

he 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)

CSVGMLGPKG

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

CSVGMLGKPG

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

CSVGMLGPKG

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)

CSVGMLGPKG

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

CSVGMLGPKG

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

CSVGMLGPKG

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

CSVGMLGeoPackage

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

CSVGMLGeoPackage

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

CSVGMLGeoPackage

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

CSVGMLGKPG

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

CSVGMLGKPG

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