# 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) <a href="#bookmark45" id="bookmark45"></a>

| 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 <a href="#bookmark46" id="bookmark46"></a>

| CSV                  | GML                                           | GPKG                       |
| -------------------- | --------------------------------------------- | -------------------------- |
| 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 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                               |
| 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) <a href="#bookmark48" id="bookmark48"></a>

| 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 <a href="#bookmark50" id="bookmark50"></a>

| 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 <a href="#bookmark50" id="bookmark50"></a>

| 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 <a href="#bookmark51" id="bookmark51"></a>

| 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 <a href="#bookmark52" id="bookmark52"></a>

| 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 <a href="#bookmark53" id="bookmark53"></a>

| 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 <a href="#bookmark54" id="bookmark54"></a>

| CSV                           | GML            | GPKG                          |
| ----------------------------- | -------------- | ----------------------------- |
| 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            | GPKG                             |
| -------------------------------- | -------------- | -------------------------------- |
| 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 |
