crash_reports
2 rows where intersection = 0, keywords contains "Tree" and "retrieved" is on date 2021-04-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-09
Time:
12:48
Address:
1298 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was attempting to parallel park her MV in front of #1298 Washington St when somehow her MV accelerated while backing up. MV#1 then struck the curb, the MV parked and unoccupied behind her and then ran over a small newly planted tree. No injuries and MV#1 was towed from the scene by Tody's.
Keywords:
Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3491551
Longitude:
-71.2265964
Location:
Case
number:
Date:
2021-04-17
Time:
09:05
Address:
1178 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 4/17/21 at 0905hrs I was dispatched to 1178 Walnut St for a report of a past hit & run MVA. On arrival, I met Ms Debra Kim who had just pulled over at that address after noticing a city parking meter (zone#2461 ) was run over which was pushed onto a city tree (minor tree damage) and then the front of the building including a front door support post was struck by an unknown MV. Building damage appears minor. Building is vacant, no tenants. Ms Kim stated her father Dae Kim is the owner of the building. Crash debris left behind (no plates found) indicated the unknown MV drove off Walnut St N/B, crashed into the meters, over the sidewalk and into the building. Photos of the area were taken and will be submitted to the IT bureau. City notified. Prior to completing this report, Ms Kim called NPD to report the neighbor from 1176 Walnut has video surveillance from the crash. Ms Kim stated according to the video time, the crash occurred yesterday 4/16 at 0715hrs. She described watching on the video a black sedan possibly a Buick crash into the building back up and continue on Walnut St N/B. She stated no plates, operators or passengers could be seen on the video. Ms Kim will email me the video.
Keywords:
Crash, Pictures, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3215965
Longitude:
-71.205863
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);