crash_reports
3 rows where "datetime" is on date 2022-02-13 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-13
Time:
17:46
Address:
COMMONWEALTH AVE & HOMER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Sunday 2/13/22 at approximately 1746 hours while assigned to marked unit n501 patrolling division n495, I was dispatched to the intersection of Commonwealth Ave and Homer St. for a report of a single car MVA into a traffic signal. Upon arrival I observed Ma Reg 9LL519 on the island facing eastbound in the intersection of Commonwealth Ave and Homer St. The vehicle hit and knocked the traffic signal off its base and landed in the eastbound lane of Homer Street. Operator, O'CONNOR James, states he was travelling Eastbound on Commonwealth Ave and attempted to turn right onto Homer Street. He was unable to pull out of the turn due to the snowy and icy conditions and slid into and knocked over the traffic signal. I was able to move the signal out of the lane of traffic and onto the center island and Dagle Electric was notified. Two pictures were taken and attached to this report. O'CONNOR's vehicle was inoperable and was towed by Tody's. At the time of the accident it was difficult to determine what the damage was. Most serious damage appears to be to the under carriage, rendering the vehicle inoperable.
Keywords:
Crash, Ice, Pictures, Severe, Snow, Solar
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3380258
Longitude:
-71.2115805
Location:
Case
number:
Date:
2022-02-13
Time:
18:32
Address:
49 BALDPATE HILL RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated they were coming down their very steep driveway at 40 Baldpate Hill Rd. when their vehicle slid across the street, and into the front exterior of 49 Baldpate Hill Rd. It should be noted it was snowing and there was snow on the driveway and roadway. There was front end damage to MV1 and damage to the exterior and garden of 49 Baldpate Hill Rd. Tody's responded to dislodge the vehicle from the home. MV1 was parked legally out front of 49 Baldpate Hill Rd. for the night. Both the operator and passenger of MV1 signed patient refusals. The homeowner of 49 Baldpate Hill Rd. was inside at the time of the crash but was unharmed. The homeowner took pictures of the damage, was made aware of the situation and advised to contact their insurance company regarding the damage to the home.
Keywords:
Crash, Night, Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3062052
Longitude:
-71.1776676
Location:
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
PROSPECT AVE & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday February 13, 2022 at approx. 1856 hours I was traveling north on Walnut Street approaching the intersection of Prospect Ave when I observed a two motor vehicle crash with City property damage. Upon arrival on scene I activated my emergency lights and exited my cruiser to check on all parties and notified dispatch of the crash. I observed both vehicles had airbag deployment and notified for medics to respond. The operator of vehicle one stated he was traveling north on Walnut Street when vehicle two traveled through Prospect Ave onto Walnut Street into his path of travel causing impact. The operator of vehicle two stated he was traveling east, down hill on Prospect Ave, he applied his brakes and his vehicle slide uncontrollable downhill through the intersection onto Walnut Street where vehicle one had impact with his vehicle, which caused him to spin around onto the curb striking a City tree and sidewalk. The vehicle was close to a retaining wall belonging to 580 Walnut Street but did not appear to have had contact. Fire and medics arrive on scene, to check on both parties due to both vehicles having airbag deployment. Both parties declined medical treatment and stated they did not have any injuries. Prospect Ave and Walnut Street were both covered with ice/snow and untreated. I notified for a sander to treat the roadways which was a contributing factor of the crash. Todys towing arrived on scene and towed both vehicles to their tow lot. All parties advised of the process. I took pictures of the City property damage that I will download at the I.T. Bureau.
Keywords:
Airbag, Crash, Fire, Ice, Pictures, Solar, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3415191
Longitude:
-71.2066448
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);