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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.os.uk/os-downloads/products/addresses-and-names-portfolio/addressbase-premium-islands/addressbase-premium-islands-technical-specification/attribute-format-comparison.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.