Previous Chapter: Appendix B: Interview Protocol
Suggested Citation: "Appendix C: Desktop Data Collection Fields." National Academies of Sciences, Engineering, and Medicine. 2024. Design Options to Reduce Conflicts Between Turning Motor Vehicles and Bicycles: Conduct of Research Report. Washington, DC: The National Academies Press. doi: 10.17226/28289.

Appendix C
Desktop Data Collection Fields

Table 1. Desktop data collection fields

Field Description Data Coding Options
City The city in which the intersection is located
Number of legs Number of segments converging on intersection
Angle/skew Is the intersection exclusively right angles or is there a skew? 90-degree angle; near 90-degree angle; skew
Intersection Treatment for Bicycles Selecting from list of treatment types BL w/pocket to left of RTL; BL to right of shared thru/RTL; SBL to right of shared thru/RTL; BL/SBL with mixing zone; SBL w/offset/protected; BL to left of shared thru/LTL; SBL to left of shared thru/LTL; BL w/pocket to right of LTL (left side BL); BL crosses channelized turn lane
Bike Lane Marking through Intersection Is there pavement marking / paint showing the bike lane path through the intersection? None; Half-White Stripe; Half-Green (i.e., bike lane is green but ends within intersection); Full-White Stripe; Full-Green; Full-Hybrid (i.e., bike lane through intersection, but green paint ends halfway)
Lane type for bicycle traffic Upstream of the intersection, what was the bike lane / facility? Right-Side Bike Lane; Right-Side Separated Bike Lane; Shared Lane; Left-Side Bike Lane; Left-Side Separated Bike Lane
Direction of bicycle traffic Is bike traffic one-way one side, one-way two sides, or two-way (e.g., a two-way cycle track)? One-way one side; One-way two sides; Two-way
Approach leg direction Direction of subject approach N; S; E; W; NE; NW; SE; SW
Presence of Bicycle signal Is there a bicycle signal for approaching bicycles (subject approach only) Y/N
Presence of a bus stop Is there a bus stop (bike lane side of street)? If so, is it on the near-side or far-side of the intersection? None; Near-side; Far-side
Direction of motor vehicle traffic Is motor vehicle traffic one-way or two-way One-way; Two-way; NA
# of lanes in same direction How many travel lanes, including bike lanes, on the approach at the intersection?
Suggested Citation: "Appendix C: Desktop Data Collection Fields." National Academies of Sciences, Engineering, and Medicine. 2024. Design Options to Reduce Conflicts Between Turning Motor Vehicles and Bicycles: Conduct of Research Report. Washington, DC: The National Academies Press. doi: 10.17226/28289.
Field Description Data Coding Options
Lane utilization for traffic in the same direction From left to right, lane #, direction type (T=Through; R=Right; L=Left; BL=Bike Lane; SBL= Separated Bike Lane)
Opposing left turn lane Is there an oncoming left turn lane (i.e. wherein traffic would turn across a bike path through intersection)? Y/N
If opposing left turn lane - Type of Left-Turn Signal Head If there is an opposing left turn lane, is it signalized, and if so, what type of signal? N/A (no opposing left turn lane); Exclusive Left-3-head Turn Arrow; Excl Left-4-head Turn Arrow; Exclusive Left 5-head turn arrow
Cross-street direction Is the cross street two-way, One-way heading right, or One-way heading left? Two-way; One-way heading right; One-way heading left
Cross-street # lanes (on approach) How many approach lanes are there on the cross street (sum of both directions).
Street View: Earliest date with CURRENT layout/space allocation In the Google Street View time capsule, when is the earliest date with the current road space allocation (focusing on the approach bicycle facility)? month year
Street View: Latest date prior to Current layout/space allocation When was the prior time capsule? month year
Offset descriptor SBL w/offset/protected locations only – description of offset 6’+; Less than 6’; No physical barrier N/A
Mixing zone marking descriptor For mixing zone locations only – description of mixing zone marking Has mixing zone marking; Minimal / borderline mixing zone marking; Lacks mixing zone marking; N/A
Pocket lane marking descriptor For pocket lane locations only, are the turn lane and pocket lane marked and wide enough? Turn lane has turn markings and adequate turn width; Has markings but is not wide enough; Wide enough but no marking; No marking and too narrow; Pocket not fully established; N/A
Curb tight For bike lane locations only, is the bike lane along the curb tight? BL is curb tight; BL not curb tight; N/A
Comment Space to add comment if any fields require some clarification
Suggested Citation: "Appendix C: Desktop Data Collection Fields." National Academies of Sciences, Engineering, and Medicine. 2024. Design Options to Reduce Conflicts Between Turning Motor Vehicles and Bicycles: Conduct of Research Report. Washington, DC: The National Academies Press. doi: 10.17226/28289.
Page 243
Suggested Citation: "Appendix C: Desktop Data Collection Fields." National Academies of Sciences, Engineering, and Medicine. 2024. Design Options to Reduce Conflicts Between Turning Motor Vehicles and Bicycles: Conduct of Research Report. Washington, DC: The National Academies Press. doi: 10.17226/28289.
Page 244
Next Chapter: Appendix D: Macro Crash Analysis
Subscribe to Email from the National Academies
Keep up with all of the activities, publications, and events by subscribing to free updates by email.