Yes - do a spatial search On Sun, Jun 1, 2025 at 4:23 PM Joanna Schmergel < [email protected]> wrote:
> Can you run a query on a specific intersection? > > On Sun, Jun 1, 2025 at 4:15 PM Margaret Olson <[email protected]> > wrote: > >> Attached is the MassDOT VRU (Vulnerable Road User) data for 2023-June 1, >> 2025. You can run all kinds of interesting queries on the MassDOT site. >> >> Notes: >> One of these accidents was at the Ballfield Road/Lincoln Road >> intersection. >> In one case the VRU was on a sidewalk. >> >> The five year plan for road and intersection improvements is managed by >> the Transportation Coalition (of which I am the chair). We will be holding >> public forums in the fall as we do our annual update to the plan. As some >> of you may know the public forums were originally planned for June, but the >> town staff is busy with the upcoming special town meeting and so we >> postponed. >> >> Margaret >> >> >> On Sun, Jun 1, 2025 at 1:20 PM Sara Mattes <[email protected]> wrote: >> >>> All, >>> This intersection has bedeviled the town for years/decades. >>> The topography makes sight lines compromised. >>> Curves and rises complicate things even further. >>> Efforts to reduce vegetation and improve sight lines on the SE corner >>> have failed. >>> >>> I suggest all interested might visit the RTC meetings and talk with the >>> Superintendent of DPW to learn more. >>> >>> >>> >>> >>> On Jun 1, 2025, at 7:17 AM, Joanna Schmergel < >>> [email protected]> wrote: >>> >>> Thank you Peter! >>> >>> This is great! >>> >>> On Sun, Jun 1, 2025 at 5:48 AM <[email protected]> wrote: >>> >>>> Great information, Joanna — thanks! I've marked the accident locations >>>> on a Google Map (link below) for those, like me, who find visual references >>>> helpful. The map clearly supports your observation that the 117/Tower Rd >>>> area is more active than other locations. >>>> >>>> The color coding should be visible on the map, but just in case: >>>> >>>> Red*:* 20+ >>>> >>>> Yellow: 10-19 >>>> Orange: 5-9 >>>> >>>> Blue: Less than 5 >>>> >>>> >>>> https://www.google.com/maps/d/edit?mid=13B_VCCLqxyPrZK5G9qocZVKp12FO5xw&usp=sharing >>>> >>>> Peter B. >>>> Conant Rd. >>>> >>>> >>>> On Sat, May 31, 2025 at 4:30 PM Joanna Schmergel < >>>> downsizefordiversity_at_gmail_com_tfzv6d21qzrx50_e0xx6...@icloud.com> >>>> wrote: >>>> >>>>> Note: >>>>> >>>>> If you add the 7 accidents at 117/Tower to the nearby 5 accidents at >>>>> 117/Bowles Terrace as well as the 3 accidents at 117/ Old Sudbury Road it >>>>> is a total of 15 accidents in the near vicinity which puts the 117/Tower >>>>> road general area in the top 3 locations for accidents. >>>>> >>>>> >>>>> >>>>>> On Sat, May 31, 2025 at 3:07 PM Joanna Schmergel < >>>>>> [email protected]> 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)+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)+Old+Sudbury+Rd%2F+Boyce+Farm+Road?entry=gmail&source=g>: >>>>>>> 3 >>>>>>> >>>>>>> 13) South Great Road (Rte >>>>>>> <https://www.google.com/maps/search/13)+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)+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. >>>>>>> >>>>>>> -- >>>>> 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. >>>>> >>>>> -- >>> 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. >>> >>> >>> -- >>> 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. >>> >>>
-- 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.
