Waze Data Dictionary - Louisville Metro Internal
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TableFieldKey Statusformatnull statusDefinition
2
MigrationHistoryMigrationIdPrimary Key
nvarchar(150)
not nullEntity Framework version control data
3
MigrationHistoryContextKeyPrimary Key
nvarchar(300)
not null
4
MigrationHistoryModel
varbinary(max)
not null
5
MigrationHistoryProductVersion
nvarchar(32)
not null
6
AlertidPrimary Keybigintnot null
7
Alertuuid
uniqueidentifier
not nullUnique System ID
8
AlertpubMillisbigintnot nullPublication date (Unix time - milliseconds since epoch)
9
AlertroadTypeintnot null
Differentiates different types of roads (highway v. local road); Reference Waze Road Types in data specification
10
Alertstreet
nvarchar(max)
nullStreet name
11
Alertcity
nvarchar(max)
nullCity and State name
12
Alertcountry
nvarchar(max)
nullCountry; uses international standard for two-letter codes
13
Alertjam
uniqueidentifier
nullIf the alert is connected to a jam - jam ID
14
Alertmagvarintnot nullDirection of travel given in magnetic degrees; Event direction
15
Alertreliabilityintnot nullHow reliable the report is based on Waze's proprietary rating system
16
AlertreportDescription
nvarchar(max)
nullreport description (optional)
17
AlertreportRatingintnot nullUser rank between 1-6 (6 = high ranked user)
18
Alerttype
nvarchar(max)
nullEvent type (e.g. Accident, Pothole, Jam…)
19
Alertsubtype
nvarchar(max)
nullEvent sub-type (e.g. Accident - Major, Accident-Minor)
20
AlertLocation_idForeign Keybigintnull
21
AlertReading_idForeign Keybigintnull
22
CoordinateidPrimary Keybigintnot null
23
Coordinatexrealnot nullx-coordinate Latitude
24
Coordinateyrealnot nully-coordinate
25
Coordinateorderintnot nullthe order of the coordinates as they appear in the lines associated with jams and corridors
26
CoordinateJam_idForeign KeybigintnullLinks to Jam table
27
CoordinateCorridor_idForeign KeyintnullLinks to Corridor table
28
CooridoridPrimary Keyintnot null
29
Cooridorname
nvarchar(100)
not nullthe street in which the corridor runs
30
CooridorfromName
nvarchar(100)
not nullthe street intersecting with the corridor street at the start of the corridor
31
CooridortoName
nvarchar(100)
not nullthe street intersecting with the corridor street at the end of the corridor
32
Cooridorlengthintnot nulllength in feet of the corridors
33
DataFileIdPrimary Keybigintnot null
34
DataFileSourceURI
nvarchar(1000)
nullwhere the file came from
35
DataFileOnPremURI
nvarchar(1000)
nullwhere the file resides
36
DataFileFileName
nvarchar(50)
nullname of the file
37
DataFileCreateddatetimenot nulldate created
38
DataFileMoveddatetimenot nulldate moved from source to on premises
39
DataFileProcesseddatetimenulldate file was processed
40
DataFileStateintnot nullState (20 = staged, 30 = complete, 40 = ignored)
41
DataFileRowVersiontimestampnot nullused to track concurrecy
42
JamidPrimary Keybigintnot null
43
Jamuuid
uniqueidentifier
nullUnique System ID for Jam (old)
44
JamnewuuidbigintnullUnique System ID for Jam (new)
45
JampubMillisbigintnot nullPublication date (Unix time - milliseconds since epoch)
46
JamstartNode
nvarchar(max)
nullStarting node of the jam
47
JamendNode
nvarchar(max)
nullEnd node of the jam
48
Jamroadtypeintnot null
Differentiates different types of roads (highway v. local road); Reference Waze Road Types in data specification
49
Jamstreet
nvarchar(max)
nullStreet name
50
Jamcity
nvarchar(max)
nullCity and State name
51
Jamcountry
nvarchar(max)
nullCountry; uses international standard for two-letter codes
52
JamblockingAlert
uniqueidentifier
nullIf the jam is connected to a block (see alerts)
53
Jamdelayintnot nulldelay of jam compared to free flow speed, in seconds (in case of block, -1)
54
Jamspeedrealnot nullCurrent average speed on jammed segments in meter/second
55
Jamlengthintnot nullJam length in meters
56
JamturnType
nvarchar(max)
nullWhat kind of turn is it - left, right, exit R or L, continue straight or NONE (no info) (optional)
57
Jamlevelintnot nullTraffic congestion level (0 = free flow 5 = blocked)
58
JamReading_IdForeign Keybigintnull
59
ReadingIdPrimary Keybigintnot null
60
ReadingFileName
nvarchar(max)
nullname of the file
61
ReadingStartdatetimenot nullstart time of file
62
ReadingEnddatetimenot nullend time of file
63
TravelReadingIdPrimary Keybigintnot null
64
TravelReadingFileName
nvarchar(500)
nullname of the file
65
TravelReadingFileTimedatetimenot nulltimestamp on file
66
TravelReadingUpdateTimeMillisbigintnot nulltime of snapshot in milliseconds
67
TravelReadingUpdateTimedatetimenot nulltime of snapshot
68
TravelReadingUpdateDayintnot nullday of snapshot
69
TravelReadingTimeintnot nullTravel time in seconds for the specified corridor
70
TravelReadingJamLevelintnot nullJam level for specified corridor
71
TravelReadingHistoricTimeintnot nullHistoric travel time in seconds for the specified corridor
72
TravelReadingDelayintnot nullDelay in seconds (Travel time - Historic time)
73
TravelReadingMPHintnot nullTravel speed in miles per hour
74
TravelReadingHistoricMPHintnot nullhistoric travel speed in miles per hour
75
TravelReadingCorridor_idForeign Keyintnull
76
77
VIEWS
78
79
All_TravelDataFileNamevarchar
80
FileTimedatetime
81
UpdateTimeMillisint
82
UpdateTimetime
83
DayOfWeekvarchar
84
idint
85
namevarchar
86
fromnamevarchar
87
tonamevarchar
88
lengthint
89
Timeint
90
JamLevelint
91
HistoricTimeint
92
Delayint
93
MPHint
94
HistoricMPHint
95
All_Corridorscorridor_idint
96
namevarchar
97
fromNamevarchar
98
toNamevarchar
99
lengthint
100
orderint
Loading...
 
 
 
Field Definitions
Table ID Links
Example Table Data