crash_reports
3 rows where "datetime" is on date 2019-11-27, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-11-27
Time:
12:43
Address:
215 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 11/27/19 at 12:43 hours, I responded to the Petsmart located at 215 Needham Street for a motor vehicle bicyclist accident. The weather at the time was approximately 50 degrees, cloudy and the road conditions were dry. No injuries reported. Operator of MV # 1 (Barbara Cooper) states she was facing eastbound on Needham Street waiting in the center turn lanes to take a left turn in to the garage of 215 Needham Street. Next, she states that a large truck going westbound stopped for her and waved her on to turn. She then proceeded in to the garage and parked and that is when she was confronted by the bicyclist saying that she was struck with her vehicle. The operator was unaware of an accident occurring and was not able to visibly see past the truck while turning. I observed a minor scratch to the passenger rear quarter panel area of the vehicle. Operator of the bicyclist (Merissa Brousseau) states she traveling westbound in the bicycle lane on the right side near 215 Needham Street when she observed the large truck mentioned above suddenly stop. She states that she was also visibly blocked from seeing ahead due to the truck. She then kept peddling straight through and struck MV # 1 in the passenger side rear end as it was making its left turn. The operator was evaluated by Cataldo Ambulance but refused medical attention. I observed no apparent damage to the bicycle. Ms. Brousseau was wearing a bicycle helmet, black and red Boston University bicycle suit, and red BU sock covers over her shoes. Digital photos taken by Ofc. Ferguson.
Keywords:
Bike, Crash, Ems, Helmet, Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3105687
Longitude:
-71.2149469
Location:
Case
number:
Date:
2019-11-27
Time:
14:11
Address:
1 BOYLSTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV#1 was parked next to handicapped stalls by the front doors of 1 Boyston Street when it was struck by MV#2. -OpMV1 stated he left his vehicle next to the handicapped stalls by the front doors of 1 Boylston Street approximately 1630hrs. He stated he returned to the stall, approximately 1730, where he discovered his vehicle had been struck in the rear right panel. OpMv#1 showed me the pictures of the damage to the vehicle on his phone. He stated he wanted to get the video surveillance of the parking lot before reporting the incident. His vehicle was not towed from the scene and no other incidents matching his collision were reported to the police.
Keywords:
Phone, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3237109
Longitude:
-71.166296
Location:
Case
number:
Date:
2019-11-27
Time:
18:06
Address:
35 WASHBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling south on Washburn St. He attempted to park the vehicle in the area of 35 Washburn St. While parking the right rear of the vehicle struck a construction barrel causing minor scratches by the right rear wheel. There were no injuries and no tows needed. Photos were taken of the scene and forwarded to IT.
Keywords:
Pictures
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3605231
Longitude:
-71.1950956
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);