Crash Report Questions

[tnjtr2]

• [x] in _SOP folder, it looks like "Crash data SOP" is the newer version. Is that what we should be referencing?
• [x] Is "WGS_1984" the coordinate system we want to use? The Crash Pins 2022 layer is "NAD_1983_HARN_WISCRS_Dane_County_Feet"
• [x] Where's January and February in "Crash Pins 2022"

[tnjtr2]

What were Mark and Cory doing with the Crash Report?

M:\TedDB\Crash_Program\Crash_Reports\Archive

[tnjtr2]

"M:\TedDB\Crash_Program_SOP\3-Crash Report\01_Data Compile for Annual Report.docx"

• [ ] Step 1 - Are we able to confirm when their data is finalized? I'm sure it is now, but in the future.
• [ ] Step 3 - What is he talking about here? Don't we already have all the data we need?
• [ ] Step 4 - It sounds like this is referring to the same process as generating the pins, but then this needs to have the pins verified for the correct location?
• [ ] Step 5 - Is this polygon information referring to the Crash Polygon? Why is the polygon centroid appropriate? Wouldn't that link some crashes to an intersections to an intersection when it occurred midblock?
• [ ] Step 5a - Do I need to manually review these areas?
• [ ] Step 9 - Is this referring to a download of the entire year's worth of data to compare against our compiled monthly downloads?

[tnjtr2]

"M:\TedDB\Crash_Program_SOP\3-Crash Report\02_Crash Report Creation.docx"

• [ ] How do I inspect the queries?
• [ ] Step 6 - Requires that I, "Enter Parameter Value" and asks for 00_GetCurrentPoly.Location Code. It looks like it runs if I don't input anything. And if I do specify a Location Code from the CrashPins or CrashPolys tables, it doesn't seem to accomplish anything.
• [ ] Step 6 through 9 - Do I run all the queries in the AnnualMaster, then go to the "00_InjSeverity" database, link to the new master, and run all those queries, and so on?
• [ ] Step 10 - What "reports" are run to create the pages for the report? I found Create > Report, but that doesn't seem to do what exists in the Crash Report.

[tnjtr2]

Locations where Crash Polygons were funny

• Other jurisdictions?
  • [ ] Siggelkow Rd & Black Walnut Dr
  • [ ] N Sherman Ave & Roxbury Rd
  • [ ] Monona Dr & Lofty Ave
• Outdated polygons
  • [ ] Schewe Rd neighborhood

[tnjtr2]

• 2023 National Safety Council estimates factored up by the CPI for 2024.
• At what cadence will we be sharing the asset data?