Ok…it looks like I requested one year of data and they sent two years of data. I had to “hide” most of the columns in excel in order to make extracting the data easier so I must not have realized that I was in fact compiling 2 years of data and not one year.
In my defense, the MassDot data spreadsheets are a mess. In any case, these intersections are still definitely problematic. On Sun, Jun 1, 2025 at 10:40 AM Joanna Schmergel < [email protected]> wrote: > Ah! Menopause Brain strikes again! > > It was supposed to say January 2023 to December 2023 > > So the data is definitely for ONE year > > You can confirm with the raw data I used attached > > >  > > > > On Sun, Jun 1, 2025 at 10:34 AM Jeffrey C. Mizrahi < > [email protected]> wrote: > >> Hi Joanna, >> >> Many thanks for compiling this data. Just an observation for clarity >> where you wrote "There were 212 accidents recorded* for the year January >> 2023 to December 2024*." That's actually a two year period, not one >> year. Which means the frequency of traffic incidents is far less, >> irrespective of where they occurred. >> >> Thanks for providing the spreadsheet from MassDot.gov. >> >> Best, >> Jeff >> >> On 5/31/2025 3:02 PM, Joanna Schmergel wrote: >> >> Hi Folks, >> >> Every so often I download a recent year of crash data for Lincoln from >> the MassDot.gov website and put together the top locations for crashes in >> Lincoln for a given year. >> >> The data is often entered using different nomenclature and in different >> columns making it a tedious “hunt & peck” effort to extract the data. >> >> Here is what I have for 2023 to 2024. I believe my numbers for the 5 >> corners intersection at the library are lower than reality. >> >> I do this because I truly believe putting myself through this exercise >> burns the trouble spots in town into my brain and keeps my family safer on >> the road. >> >> MassDot.gov crash data for Lincoln, MA 2023-2024 - extracted by Joanna >> Schmergel probably somewhat imperfectly >> >> Number of Crashes at the following intersections January 2023 to December >> 2024: >> >> 1) Route 2 >> <https://www.google.com/maps/search/1)+Route+2?entry=gmail&source=g>/ >> Bedford Rd (Crosby’s Corner) : 37 >> >> 2) South Great Rd/ Lincoln >> <https://www.google.com/maps/search/2)+South+Great+Rd%2F+Lincoln?entry=gmail&source=g> >> Road: 16 >> >> 3) Entered in just as Route 2 in the spreadsheet: 15 >> >> 4) Old County Road / Trapelo Road >> <https://www.google.com/maps/search/4)+Old+County+Road+%2F+Trapelo+Road?entry=gmail&source=g>: >> 12 >> >> 5) Codman Road / Lincoln >> <https://www.google.com/maps/search/5)+Codman+Road+%2F+Lincoln?entry=gmail&source=g> >> Road: 11 >> >> 6) Route 2A >> <https://www.google.com/maps/search/6)+Route+2A?entry=gmail&source=g> >> (North Great Rd) / Hanscom Drive: 9 >> >> 7) South Great Road (Rte 117 >> <https://www.google.com/maps/search/7)+South+Great+Road+(Rte+117?entry=gmail&source=g>) >> / Tower Road: 7 >> >> 8) South Great Road (Rte 117)/ Concord Road: 5 >> >> 9) South Great Road (Rte 117 >> <https://www.google.com/maps/search/9)%0D%0A++++++++++++South+Great+Road+(Rte+117?entry=gmail&source=g>)/ >> Bowles Terrace: 5 >> >> 10) Lewis Street/ Lincoln Road: 4 >> >> 11) 5 Corners Intersection at Library: 3 (seems low!) >> >> 12) Old Sudbury Rd/ Boyce Farm Road >> <https://www.google.com/maps/search/12)%0D%0A++++++++++++Old+Sudbury+Rd%2F+Boyce+Farm+Road?entry=gmail&source=g>: >> 3 >> >> 13) South Great Road (Rte >> <https://www.google.com/maps/search/13)%0D%0A++++++++++++South+Great+Road+(Rte?entry=gmail&source=g> >> 117)/ Old Sudbury Road: 3 >> >> 14) Old Bedford Road/ Hanscom Drive: 3 >> >> 15) South Great Road (Rte 117 >> <https://www.google.com/maps/search/15)%0D%0A++++++++++++South+Great+Road+(Rte+117?entry=gmail&source=g>)/ >> Sweet Bay Lane: 3 >> >> 16) Winter Street/ Old County Road: 3 >> >> 17) Route 2/ Lexington Road: 3 >> >> There were 212 accidents recorded for the year January 2023 to December >> 2024. These top 17 locations accounted for 142 of the accidents or 67% >> >> Attached is the raw data from MassDot.gov >> >> >>
-- The LincolnTalk mailing list. To post, send mail to [email protected]. Browse the archives at https://pairlist9.pair.net/mailman/private/lincoln/. Change your subscription settings at https://pairlist9.pair.net/mailman/listinfo/lincoln.
