Guides
Guides

Streets daily profiles table (Streets_DailyProfiles)

The Streets_DailyProfiles table assigns traffic patterns to navigable road segments. Each road segment that forms part of the network dataset has a traffic pattern identifier assigned for each day of the week in each direction.


For a description of the attributes OBJECTID and GlobalID, see Esri® system fields .

Field nameData typeDescription
LINK_IDInteger (4)Unique ID of the link to which the traffic profiles apply. References the LINK_ID field in the Streets layer.
TRAVEL_DIRECTIONString (2)Direction of travel identifies legal travel directions for a navigable street segment (link).
  • B - Both Directions
  • F - From Reference Node only
  • T - To Reference Node only

REF_NODE_ID identifies the reference node and NON_REF_NODE_ID identifies the non reference node.
UInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Sundays.
MInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Mondays.
TInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Tuesdays.
WInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Wednesdays.
RInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Thursdays.
FInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Fridays.
SInteger (4)ObjectID of the relevant speed profile record in the DailyProfiles table for Saturdays.
EDGEFRMPOSDouble (8)Works in conjunction with EdgeToPos to identify a direction of travel or side of the street. 0 indicates the beginning of the line feature as defined by its digitized direction, while 1 indicates the opposite end.
EDGETOPOSDouble (8)Works in conjunction with EdgeFrmPos to identify a direction of travel, or side of the street.
EDGEFIDInteger (4)The OBJECTID for this segment in the Streets feature class.
EDGEFCIDInteger (4)The feature class ID for the Streets feature class.
FREEFLOWSPEEDInteger (4)The free flow speed is the maximum speed in kph recorded in the traffic profile data for this link in this direction.
LENGTH_MDouble (8)The length of the segment in metres.
FREEFLOWMINUTESDouble (8)The time in minutes to traverse the segment when travelling at the freeflowspeed in this direction.
LEFT_REGION_LATINString (100)Name of the region on the left hand side of the street segment.
LEFT_REGION_ABBREV_LATINString (50)Abbreviated name of the region on the left hand side of the street segment using Latin character set.
RIGHT_REGION_LATINString (100)Name of the region on the right hand side of the street segment.
RIGHT_REGION_ABBREV_LATINString (50)Abbreviated name of the region on the right hand side of the street segment using Latin character set.
ISO_COUNTRY_CODEString (3)ISO 3 character country code