»
NID
National IDentifier - This unique identifier is the NID attribute from the SURN (Saskatchewan Updated Road Network) Road Segment shapefile. It is a 32-character string. Where a standalone NGD road segment exists that does not intersect with an SURN road segment, this field must be set to -1 (negative one). In all other cases, this field will be populated with the NID from the SURN shapefile. Some additional exceptions will occur during the course of the conflation process that will require the NID to be duplicated. This situation will be the result of the following conflation matching conditions: 1. In one to many relationship between the SURN and NGD data source. 2. In many to many relationships between the SURN and NGD data source.
| Field Type: |
String |
| Field Width: |
38 |
»
NGD_ID
National Geographic Database IDentifier - This unique identifier is attached to each road segment in the NGD (National Geographic Database) road network file. It is a character string that may be up to 15 characters long.
| Field Type: |
String |
| Field Width: |
16 |
»
IDOCC
Identifier used to link the geometry between the NRN file to the Street Name linkup table file.
| Field Type: |
Number |
| Field Width: |
7 |
»
ARS
Address Range Side - The side of the road element according to its digitizing direction. While the address range values, taken from the NGD file, are extracted from the ADDR_FM_LEFT and ADDR_TO_LEFT attributes, the addressRangeSide value is 1 (for left). Therefore, if the address range values are extracted from the ADDR_FM_RIGHT and ADDR_TO_RIGHT attributes, the addressRangeSide value is 2 (for right).
| Field Type: |
Number |
| Field Width: |
5 |
| Domain: |
Value |
Description |
|
|
1 |
The left side |
|
|
2 |
The right side |
»
ADDRGNNID
Address Range NID (Event NID) - This value is to be set to NULL for all road segments
| Field Type: |
String |
| Field Width: |
24 |
»
DDF
Digitizing Direction Flag - This value indicates if the digitizing direction of the NRN geometry and its corresponding NGD geometry are in the same direction. If they both have the same digitizing direction, the digitizingDirectionFlag value is 1. If they are not, the value is 2.
| Field Type: |
Number |
| Field Width: |
4 |
»
LHNS
Left House Number Structure - The type of house numbering (or address numbering) method applied to one side of a particular Road Element. The value for this attribute is taken from the NGD attribute PARITY. The following table indicates the correlation to apply :
| Field Type: |
Number |
| Field Width: |
6 |
| Domain: |
Value |
Description |
|
|
NGD PARITY |
House Number Structure |
|
|
U |
-1 |
|
|
M |
3 |
|
|
R |
When the NGD PARITY value is R, it was neccassary to determine if the houseNumberStructure is even or odd. To do so, for each side, the first and last house number (ADDR_FM_LEFT and ADDR_TO_LEFT for the left side, ADDR_FM_RIGHT and ADDR_TO_RIGHT for the right side) must be examined. If they are both even, the houseNumberStructure value is 1. If they are both odd, the houseNumberStructure value is 2. If one is odd and the other is even, the houseNumberStructure value is 3. If both are equal to zero, the houseNumberStructure value is 0. |
»
RHNS
Right House Number Structure - The type of house numbering (or address numbering) method applied to one side of a particular Road Element. The value for this attribute is taken from the NGD attribute PARITY. The following table indicates the correlation to apply :
| Field Type: |
Number |
| Field Width: |
6 |
| Domain: |
Value |
Description |
|
|
NGD PARITY |
House Number Structure |
|
|
U |
-1 |
|
|
M |
3 |
|
|
R |
When the NGD PARITY value is R, it was neccassary to determine if the houseNumberStructure is even or odd. To do so, for each side, the first and last house number (ADDR_FM_LEFT and ADDR_TO_LEFT for the left side, ADDR_FM_RIGHT and ADDR_TO_RIGHT for the right side) must be examined. If they are both even, the houseNumberStructure value is 1. If they are both odd, the houseNumberStructure value is 2. If one is odd and the other is even, the houseNumberStructure value is 3. If both are equal to zero, the houseNumberStructure value is 0. |
»
LRSI
Left Reference System Indicator - The value is 1 for all SURN sourced road segments.
| Field Type: |
Number |
| Field Width: |
5 |
»
RRSI
Right Reference System Indicator - The value is 1 for all SURN sourced road segments.
| Field Type: |
Number |
| Field Width: |
5 |
»
LFHHNT
Left First House House Numbering Type - The houseNumber is taken from the NGD attribute AFL_STAT_CDE (for the left side) or AFR_STAT_CDE (for the right side), the houseNumberingType value is determined according to the following table :
| Field Type: |
Number |
| Field Width: |
8 |
| Domain: |
Value |
Description |
|
|
NGD AFL/R STAT CDE |
House Numbering Type |
|
|
S |
2 |
|
|
O |
2 |
|
|
I |
4 |
|
|
T |
4 |
|
|
U |
-1 |
|
|
N |
0 |
|
|
M |
4 |
|
|
V |
4 |
|
|
W |
4 |
|
|
X |
4 |
|
|
Y |
4 |
|
|
D |
4 |
|
|
P |
4 |
»
RFHHT
Right First House House Numbering Type - The houseNumber is taken from the NGD attribute AFL_STAT_CDE (for the left side) or AFR_STAT_CDE (for the right side), the houseNumberingType value is determined according to the following table :
| Field Type: |
Number |
| Field Width: |
7 |
| Domain: |
Value |
Description |
|
|
NGD AFL/R STAT CDE |
House Numbering Type |
|
|
S |
2 |
|
|
O |
2 |
|
|
I |
4 |
|
|
T |
4 |
|
|
U |
-1 |
|
|
N |
0 |
|
|
M |
4 |
|
|
V |
4 |
|
|
W |
4 |
|
|
X |
4 |
|
|
Y |
4 |
|
|
D |
4 |
|
|
P |
4 |
»
LFHHN
Left First House House Number - This attribute defines the address of the first house of a road element. For the left side, the first houseNumber is taken from the attribute ADDR_FM_LEFT. For the right side, the first houseNumber is taken from the attribute ADDR_FM_RIGHT.
| Field Type: |
Number |
| Field Width: |
7 |
»
RFHHN
Right First House House Number - This attribute defines the address of the first house of a road element. For the left side, the first houseNumber is taken from the attribute ADDR_FM_LEFT. For the right side, the first houseNumber is taken from the attribute ADDR_FM_RIGHT.
| Field Type: |
Number |
| Field Width: |
7 |
»
LFHHNS
Left First House House Number Suffix - The value is always a - (dash character).
| Field Type: |
String |
| Field Width: |
8 |
»
RFHHNS
Right First House House Number Suffix - The value is always a - (dash character).
| Field Type: |
String |
| Field Width: |
8 |
»
LLHHNT
Left Last House House Numbering Type - The houseNumber is taken from the NGD attribute ATL_STAT_CDE (for the left side) or ATR_STAT_CDE (for the right side), the houseNumberingType value is determined according to the following table :
| Field Type: |
Number |
| Field Width: |
8 |
| Domain: |
Value |
Description |
|
|
NGD ATL/R STAT CDE |
House Numbering Type |
|
|
S |
2 |
|
|
O |
2 |
|
|
I |
4 |
|
|
T |
4 |
|
|
U |
-1 |
|
|
N |
0 |
|
|
M |
4 |
|
|
V |
4 |
|
|
W |
4 |
|
|
X |
4 |
|
|
Y |
4 |
|
|
D |
4 |
|
|
P |
4 |
»
RLHHNT
Right Last House House Numbering Type - The houseNumber is taken from the NGD attribute ATL_STAT_CDE (for the left side) or ATR_STAT_CDE (for the right side), the houseNumberingType value is determined according to the following table :
| Field Type: |
Number |
| Field Width: |
8 |
| Domain: |
Value |
Description |
|
|
NGD ATL/R STAT CD |
House Numbering Type |
|
|
S |
2 |
|
|
O |
2 |
|
|
I |
4 |
|
|
T |
4 |
|
|
U |
0 |
|
|
N |
4 |
|
|
M |
4 |
|
|
V |
4 |
|
|
W |
4 |
|
|
X |
4 |
|
|
Y |
4 |
|
|
D |
4 |
|
|
P |
4 |
»
LLHHN
Left Last House House Number - This attribute defines the address of the last house of a road element. For the left side, the last houseNumber is taken from the attribute ADDR_TO_LEFT. For the right side, the last houseNumber is taken from the attribute ADDR_TO_RIGHT.
| Field Type: |
Number |
| Field Width: |
7 |
»
RLHHN
Right Last House House Number - This attribute defines the address of the last house of a road element. For the left side, the last houseNumber is taken from the attribute ADDR_TO_LEFT. For the right side, the last houseNumber is taken from the attribute ADDR_TO_RIGHT.
| Field Type: |
Number |
| Field Width: |
7 |
»
LLHHNS
Left Last House House Number Suffix - The value is always a - (dash character).
| Field Type: |
String |
| Field Width: |
8 |
»
RLHHNS
Right Last House House Number Suffix - The value is always a - (dash character).
| Field Type: |
String |
| Field Width: |
8 |
»
MATCH_QUAL
MATCH_QUAL attribute qualifies the confidence level of the resulting conflation made between a NRN instance and an NGD instance. This conflation qualifier attribute is an integer value. There are four possible MATCH_QUAL attribute values which cannot be absent and must have a value of 0 - 4
| Field Type: |
Number |
| Field Width: |
13 |
| Domain: |
Value |
Description |
|
|
0 |
No conflation (standalone) |
|
|
1 |
unambiguous: The conflation result is obvious or certain when the following two conditions apply: The conflation can be made without any doubt although their geometry (shape, length and orientation) or their location may be different. |
|
|
2 |
ambiguous: All other conflations for which the conflation qualifier attribute value is not 0 or 1 with the exception of 3 & 4 below |
|
|
3 |
distortion: The NGD and NRN geometry is distorted but exists within the same spatial extent. |
|
|
4 |
model: The NRN geometry is retained (divided road for example) while the NGD geometry is discarded after attribute values have been transferred. |
»
STREET_ID_L
This is a UUID that links the AddressRange event (record) to its StreetName event (record) for the left side.
| Field Type: |
Number |
| Field Width: |
13 |
»
STREET_ID_R
This is a UUID that links the AddressRange event (record) to its StreetName event (record) for the right side.
| Field Type: |
Number |
| Field Width: |
13 |
»
PLACE_Name_L
This is a UUID that links the AddressRange event (record) to its placeName event (record) for the left side.
| Field Type: |
Number |
| Field Width: |
15 |
»
PLACE_Name_R
This is a UUID that links the AddressRange event (record) to its placeName event (record) for the right side.
| Field Type: |
Number |
| Field Width: |
16 |
»
MDNID
This is the UUID that links the AddressRange event (record) to its metaData event (record). For the purposes of this dataset, this value has been set to -1 (negative 1).
| Field Type: |
Number |
| Field Width: |
7 |
