Would you please direct me a bit as to how? I often find the website overwhelming and it seems like you can extract everything EXCEPT what you need.
On Sun, Jun 1, 2025 at 4:27 PM Margaret Olson <[email protected]> wrote: > 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.
