Network Links
Overview
The network links table contains the network links (roads and highways) used as the base-layer for modeling transportation patterns within a given Replica region. This table can be joined to the seasonal trip table using the unique stableEdgeId field. For instance, street names associated with trips can be obtained by joining the seasonal trips table’s network_link_id to the network link table on this common field.
Network links are the streets or pathways upon which vehicles or people can travel. A single street is typically split into multiple links, with the split points set at street intersections. Two-way streets are modeled with separate network links, one for each direction of travel.
Arterial network links include freeways, highways, primary, secondary, and tertiary segments. The functional classifications defined for the links (freeways, highways, primary, secondary, and tertiary) are derived from OpenStreetMap street data. Most residential streets and service lanes are excluded from this dataset.
Schema
Field Name | Content Type | Sample Value | Description |
---|---|---|---|
stableEdgeId | String | 1.63807E+19 | A unique identifier for the network link. |
startLat | Float | 34.36907793 | The latitude of the starting point of the network link, stored in decimal degrees. |
startLon | Float | -101.762211 | The longitude of the starting point of the network link, stored in decimal degrees. |
endLat | Float | 34.36866032 | The latitude of the end point of the network link, stored in decimal degrees. |
endLon | Float | -101.7656375 | The longitude of the end point of the network link, stored in decimal degrees. |
streetName | String | Sunrise Passage | The common name of the network link if available. Matches the name assigned by OpenStreetMap. |
distance | Integer | 318000 | The distance (length) of the network link in millimeters. |
osmid | String | 21250769 | The OpenStreetMap ID assigned to the network link. |
speed | Integer | 20.69196279 | The speed limit on the link in miles per hour. |
flags | String | [ALLOWS_CAR, ALLOWS_BIKE, ALLOWS_PEDESTRIAN] | A flag denoting what type of vehicles and pedestrian traffic are permitted on the network edge. |
lanes | Integer | 2 | The number of travel lanes on the network link. A "-1" value means we could not parse a lane count from OpenStreetMap (OSM). A "0" value means that the road isn't passable by cars (i.e., it doesn't have the allows_car flag that appears in the "flags" column in the table). |
highway | String | secondary_link | The classification of the link based on OpenStreetMap data. |
geometry | String | LINESTRING(-93.254892 43.986738, -93.254799 43.993382) | The geometry type for each network link including the start and end latitude and longitude points of the link segment. |
Updated 4 months ago