How the product fits together
Last updated
Last updated
OS MasterMap Highways Network – RAMI is a relational product. This results in there being relationships between different feature types. This section summarises how the different feature types relate to one another, and which attributes are the primary and foreign keys for the RAMI feature. For information on the Roads features, please see the Roads Technical Specification.
The following table identifies how the feature types relate to one another and which attributes are the primary and foreign keys. This is also represented diagrammatically in the figure below the table. The attribute at the arrowhead is the primary key, and the attribute at the base of the arrow is the foreign key.
| Source Feature Type | Foreign Key Attribute | Destination Feature Type | Primary Key Attribute |
|---|---|---|---|
Feature type | — | feature type | — |
AccessRestriction | element | RoadLink | id |
TurnRestriction | element | RoadLink | id |
RestrictionForVehicles | element | RoadLink | id |
RestrictionForVehicles | element | RoadNode | id |
RestrictionForVehicles | linkReference | RoadLink | id |
Hazard | element | RoadLink | id |
Hazard | element | RoadNode | id |
Hazard | linkReference | RoadLink | id |
Structure | element | RoadLink | id |
Structure | element | RoadNode | id |
Structure | linkReference | RoadLink | id |
Maintenance | element | Street | id |
Reinstatement | element | Street | id |
SpecialDesignation | element | Street | id |
HighwayDedication | element | Street | id |
HighwayDedication | element | RoadLink | id |
