Street – (Type 11 Record)
A way or thoroughfare providing a right of way on foot, by cycle or by motor vehicle, or access to more than one property. This record assigns a Unique Street Reference Number (USRN) to each street and holds the start and end coordinates of the street feature with information about surface type and classification.
Feature type attributes
The following page provides details about the attributes included with this feature, their data types in the different output formats, and other important metadata about them.
fid
A non-persistent integer which is autogenerated and is required within the OGC GPKG format.
Attribute Name: Not provided (GML), Not provided (CSV), fid (GKPG)
Data Type: Integer
Multiplicity: [1]
Record identifier
Identifies this record as a Street Record (type 11).
Attribute Name: Not provided (GML), RECORD_IDENTIFIER (CSV), Not provided (GKPG)
Data Type: Integer (CSV)
Size: 2
Multiplicity: [1]
Change type
Size: 1
Multiplicity: [1]
Pro order
The order in which the records were processed in to create the data supply.
Attribute Name: Not provided (GML), PRO_ORDER (CSV), Not provided (GKPG)
Data Type: Integer
Size: 16
Multiplicity: [1]
USRN
Unique Street Reference Number (USRN) - the unique key for the record and primary key for the Street table.
Attribute Name: usrn (GML), USRN (CSV), usrn (GKPG)
Data Type: Integer
Size: 8
Multiplicity: [1]
Record type
Description of the street record type, for example whether it is a named or numbered street.
Attribute Name: recordType (GML), RECORD_TYPE (CSV), record_type (GKPG)
Size: 1
Multiplicity: [1]
SWA org ref
The code which identifies the Street Naming and Numbering Authority or the Local Highway Authority.
Attribute Name: swaOrgRefNaming (GML), SWA_ORG_REF_NAMING (CSV), swa_org_ref_naming (GKPG)
Data Type: Integer
Size: 4
Multiplicity: [1]
State
A code identifying the current state of the Street, ‘Open’ for example.
Attribute Name: state (GML), STATE (CSV), state (GKPG)
Size: 1
Multiplicity: [0..1]
State date
Date at which the street achieved its current state as referenced in the ‘State’ column.
Attribute Name: stateDate (GML), STATE_DATE (CSV), state_date (GKPG)
Condition: If State Date is present, State must also be present.
Data Type: Date
Multiplicity: [0..1]
Street surface
A code to indicate the surface finish of the street.
Attribute Name: streetSurface (GML), STREET_SURFACE (CSV), street_surface (GKPG)
Size: 1
Multiplicity: [0..1]
Street classification
A code for the primary street classification, for example denoting it to be ‘open to all vehicles’.
Attribute Name: streetClassification (GML), STREET_CLASSIFICATION (CSV), street_classification (GKPG)
Size: 2
Multiplicity: [0..1]
Version
Version number of the street record.
Attribute Name: version (GML), VERSION (CSV), version (GKPG)
Data Type: Integer
Size: 3
Multiplicity: [1]
Street start date
Date this record or version was inserted into the database.
Data Type: Date
Multiplicity: [1]
Street end date
Date on which the street was closed in the product database. This can occur due to the street being permanently closed in the real world.
Condition: If State is equal to 4, Street End Date must be populated.
Data Type: Date
Multiplicity: [0..1]
Last update date
The date on which any attribute of the Record was last changed.
Data Type: Date
Multiplicity: [1]
Record entry date
The date that the record was entered into the Local Authority database.
Data Type: Date
Multiplicity: [1]
Street start
A value in metres defining the x and y location in accordance with the British National Grid for the start point of the street.
Attribute Name: streetStart (GML), STREET_START_X, STREET_START_Y (CSV), street_start_x, street_start_y (GKPG)
Data Type: GM_POINT (GML), Float (CSV), Double (GPKG)
Size: STREET_START_X (precision, scale) – (8, 2), STREET_START_Y (precision, scale) – (9, 2)
Multiplicity: [1]
Street start lat long
A value defining the Latitude and Longitude start point of the street in accordance with the ETRS89 coordinate reference system.
Attribute Name: streetStartLatLong (GML), STREET_START_LAT, STREET_START_LONG (CSV), street_start_lat, street_start_long (GKPG)
Data Type: GM_POINT (GML), Float (CSV), Double (GPKG)
Size: LATITUDE (precision, scale) – (9, 7), LONGITUDE (precision, scale) – (8, 7)
Multiplicity: [1]
Street end
A value in metres defining the x and y location in accordance with the British National Grid for the end point of the street.
Attribute Name: streetEnd (GML), STREET_END_X, STREET_END_Y (CSV), street_start_lat, street_end_x, street_end_y (GKPG)
Data Type: GM_POINT (GML), Float (CSV), Double (GPKG)
Size: STREET_END_X (precision, scale) – (8, 2), STREET_END_Y (precision, scale) – (9, 2)
Multiplicity: [1]
Street end lat long
A value defining the Latitude and Longitude end point of the street in accordance with the ETRS89 coordinate reference system.
Attribute Name: streetEndLatLong (GML), STREET_END_LAT, STREET_END_LONG (CSV), street_end_lat, street_end_long (GKPG)
Data Type: GM_POINT (GML), Float (CSV), Double (GPKG)
Size: LATITUDE (precision, scale) – (9, 7), LONGITUDE (precision, scale) – (8, 7)
Multiplicity: [1]
Street tolerance
The accuracy of data capture (in metres) to which the Street Start and End coordinates have been captured.
Attribute Name: streetTolerance (GML), STREET_TOLERANCE (CSV), street_tolerance (GKPG)
Data Type: Integer
Size: 3
Multiplicity: [1]
Last updated
Was this helpful?