RoadLink
Linear Network
RoadLink
Y
TOID
N/A
N/A
RoadLinkAlternativeIdentifier
Linear Network
RoadLink
N
TOID (id in GML/technical spec)
RoadLink
TOID
RoadLinkFormsPartOf
Linear Network
RoadLink
N
TOID
Road or Street
formsPartOf - Will be either Road TOID or Street USRN
RoadLink_TopoTOIDRef
Linear Network
RoadLink
N
TOID
Topo Area
RelatedRoadAreaTOID - Will be the TOID of the Topo area(s) that represent the RoadLink
AccessRestriction_NetworkRef
Routing and Asset Management Information
AccessRestriction
N
TOID
RoadLink
RoadLink_TOID - The TOID in the RoadLink table
AccessRestriction
Routing and Asset Management Information
AccessRestriction
N
TOID
AccessRestriction_NetworkRef, AccessRestriction_Inclusion, AccessRestriction_Exemption
TOID
AccessRestriction_Inclusion
Routing and Asset Management Information
AccessRestriction
N
TOID
AccessRestriction
TOID
AccessRestriction_Exemption
Routing and Asset Management Information
AccessRestriction
N
TOID
AccessRestriction
TOID
Hazard_NetworkRef
Routing and Asset Management Information
Hazard
Y
TOID
RoadLink and RoadNode
RoadLink_TOID and RoadNode _TOID - The TOID in the respective tables
Hazard
Routing and Asset Management Information
Hazard
Y
TOID
Hazard_NetworkRef
TOID
Hazard_NodeReference_LinkReference
Routing and Asset Management Information
Hazard
N
TOID
RoadLink
RoadLink_TOID
RestrictionForVehicles_NetworkRef
Routing and Asset Management Information
VehicleRestriction, RestrictionForVehicles
N
TOID
RoadLink and RoadNode
RoadLink_TOID and RoadNode _TOID - The TOID in the respective tables
RestrictionForVehicles
Routing and Asset Management Information
VehicleRestriction, RestrictionForVehicles
Y
TOID
RestrictionForVehicles_NetworkRef
TOID
RestrictionForVehicles_NodeReference_LinkReference
Routing and Asset Management Information
VehicleRestriction, RestrictionForVehicles
N
TOID
RoadLink
RoadLinkTOID
Road
Linear Network
Road
N
TOID
Road_NetworkRef
TOID
Road_NetworkRef
Linear Network
Road
N
TOID
RoadLink
RoadLink_TOID - Is the TOID of the RoadLink table
RoadNode
Linear Network
RoadNode
Y
TOID
N/A
N/A
RoadNode_RelatedRoadArea
Linear Network
RoadNode
N
TOID
Topo Area
RelatedRoadAreaTOID - Will be the TOID of the Topo area(s) that represent the RoadNode
Street_NetworkRef
Linear Network
Street
N
USRN
RoadLink
RoadLink_TOID - Will be the TOID of the RoadLink table
Street
Linear Network
Street
N
USRN
Street_NetworkRef
USRN
Structure_NetworkRef
Routing and Asset Management Information
Structure
N
TOID
RoadLink and RoadNode
RoadLink_TOID and RoadNode _TOID - The TOID in the respective tables
Structure
Routing and Asset Management Information
Structure
Y
TOID
Structure_NetworkRef
TOID
Structure_NodeReference_LinkReference
Routing and Asset Management Information
Structure
N
TOID
RoadLink
RoadLink_TOID
TurnRestriction_NetworkRef
Routing and Asset Management Information
TurnRestriction
N
TOID
RoadLink
RoadLink_TOID - The TOID in the RoadLink table
TurnRestriction
Routing and Asset Management Information
TurnRestriction
N
TOID
TurnRestriction_NetworkRef, TurnRestriction_Exemption, TurnRestriction_Inclusion
TOID
TurnRestriction_Exemption
Routing and Asset Management Information
TurnRestriction
N
TOID
TurnRestriction
TOID
TurnRestriction_Inclusion
Routing and Asset Management Information
TurnRestriction
N
TOID
TurnRestriction
TOID
Maintenance Point
Routing and Asset Management Information
Maintenance
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Maintenance Line
Routing and Asset Management Information
Maintenance
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Maintenance Area
Routing and Asset Management Information
Maintenance
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Maintenance No Geometry
Routing and Asset Management Information
Maintenance
N
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Reinstatement Point
Routing and Asset Management Information
Reinstatement
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Reinstatement Line
Routing and Asset Management Information
Reinstatement
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Reinstatement Area
Routing and Asset Management Information
Reinstatement
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Reinstatement No Geometry
Routing and Asset Management Information
Reinstatement
Y
ID
Street
Reference_To_StreetUSRN - The USRN in the Street table
Junction
Linear Network
RoadJunction
N
TOID
RoadNode
TOID, RoadNode_TOIDs (the junction can reference back to multiple road nodes)
Highways Dedication
Routing and Asset Management Information
Dedication
Y
ID
Road, Street or Path
NetworkRef - TOID in RoadLink and PathLink table and USRN in the Street table
Special Designation Point
Routing and Asset Management Information
SpecialDesignation
Y
networkRef
Street
NetworkRef - USRN in the Street table
Special Designation Line
Routing and Asset Management Information
SpecialDesignation
Y
networkRef
Street
NetworkRef - USRN in the Street table
Special Designation Area
Routing and Asset Management Information
SpecialDesignation
Y
networkRef
Street
NetworkRef - USRN in the Street table
Special Designation No Geometry
Routing and Asset Management Information
SpecialDesignation
N
networkRef
Street
NetworkRef - USRN in the Street table
Ferrylink
Linear Network
FerryLink
Y
TOID
N/A
N/A
Ferrylink
Linear Network
FerryLink
N
TOID
FerryNode
FerryNode_TOID (one for startNode and one for endNode)
FerryNode
Linear Network
FerryNode
Y
TOID
N/A
N/A
FerryTerminal
Linear Network
FerryTerminal
N
refToFuncationalSite,roadNodeRef, pathNodeRef
Road Node, Path Node and Functional Site
TOID
PathLink
Paths
PathLink
Y
TOID
N/A
N/A
PathLinkAlternativeIdentifier
Paths
PathLink
N
TOID
PathLink
TOID
PathLinkFormsPartOf
Paths
PathLink
N
TOID
Path or Street
formsPartOf - Will be either Path TOID or Street USRN
PathLink_TopoTOIDRef
Paths
PathLink
N
TOID
Topo Area
RelatedPathAreaTOID - Will be the TOID of the Topo area(s) that represent the PathLink
PathLink
Paths
PathLink
N
TOID
PathNode
PathNode_TOID (one for startNode and one for endNode)
Path
Paths
Path
N
TOID
Path_NetworkRef
TOID
Path_Ref_PathLink
Paths
Path
N
TOID
PathLink
PathLink_TOID - Is the TOID of the PathLink table
PathNode
Paths
PathNode
Y
TOID
N/A
N/A
PathNode_RelatedRoadArea
Paths
PathNode
N
TOID
Topo Area
RelatedPathAreaTOID - Will be the TOID of the Topo area(s) that represent the PathNode
ConnectingLink
Paths
ConnectingLink
Y
TOID
PathNode and ConnectingNode
TOID
ConnectingNode
Paths
ConnectingNode
Y
TOID
RoadLink
TOID