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.

Reply via email to