crash_reports
28 rows where dcc = "[]", intersection = 0 and keywords contains "Tree"
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-02-12
Time:
14:32
Address:
2345 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she had just made a U-Turn from the east bound side of Commonwealth Ave (#2345) to the west bound side when her MV started to slide in the fresh snow. MV then slid across Commonwealth Ave and hit the curb and then head on into a large tree. Operator arranged for their own tow.
Keywords:
Snow, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.346364
Longitude:
-71.2584662
Location:
Case
number:
Date:
2019-04-26
Time:
17:33
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Vehicle 1 was parked unoccupied in the employee parking lot of Newton Wellesley Hospital when it was hit by Vehicle 2. The operator of vehicle 2 stated she was correcting her parking job and tried to back up, but the car was actually in drive and not reverse. the car drove forward hitting vehicle 1 going over a curb and hit a tree a few feet past the curb. This caused minor damage to Vehicle 1 and major front end damage to Vehicle 2 as well as front air bag deployment. Since this occurred on hospital grounds the operator of vehicle 2 walked herself to the ER for precautionary reasons and was cleared. Vehicle 2 remained in the parking area for a private tow company.
Keywords:
Hospital, Tree, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2019-05-31
Time:
15:19
Address:
317 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The Operator of vehicle 1 stated that she had just made a right turn onto Parker Street from Hagen Road, she then over turned and lost control of the vehicle and hit the curb and then a tree on the sidewalk. This caused major damage to the entire front passenger side quarter panel and wheel. The vehicle was immobile and had to be towed away.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3164878
Longitude:
-71.1952349
Location:
Case
number:
Date:
2019-07-30
Time:
12:28
Address:
100 PEREGRINE RD
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR WAS OPERATING PENSKE RENTAL TRUCK BEARING INDIANA APPORTIONED REGISTRATION, 2181389. HE STATES THAT HE WAS ABOUT TO PULL INTO THE DRIVEWAY OF 100 PERREGRINE RD, WHEN HE STRUCK A CITY TREE, KNOCKING SUCH TREE OVER. HIS TRUCK SUSTAINED DAMAGE TO THE DRIVERS SIDE BED. NO INJURIES REPORTED. CITY OF NEWTON FORESTRY WAS NOTIFIED TO REMOVE THE TREE. I TOOK PICTURES OF THE DOWNED TREE AND DAMAGE TO THE VEHICLE. THE MEMORY CARD WILL BE TURNED INTO I.T.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2961439
Longitude:
-71.1774123
Location:
Case
number:
Date:
2019-10-16
Time:
22:48
Address:
1201 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of vehicle number 1 stated she was traveling westbound on Washington Street in the area of 1201 Washington Street when a tree limb fell from a city tree striking her patrol car. Several pictures where taken of both the city tree and the damage to patrol unit 504. The operator of vehicle number 1 was not injured. Vehicle number 1 sustained moderate damage to the passengers side mirror as well as a cracked windshield.
Keywords:
Moderate, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3494627
Longitude:
-71.2228721
Location:
Case
number:
Date:
2019-12-02
Time:
10:23
Address:
100 HAMMOND STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
Op MV#1 was traveling north on Hammond Street when MV#1 slid in the slush and collided with a tree on the side of the road. -I observed the damage to the tree at the intersection of Hammond and Hammondswood. I observed the damage to the middle center of MV#1. I saw small wood fragments and sap in the hood, bumper and license plate of MV#1. I observed the slush on the road and on the surrounding ground. -OpMV#1 did not report injuries at the scene and declined further medical care. MV#1 was towed from the scene by Toddy's Towing . 1 photo of the damaged tree was taken by Ofc. Crowe and sent to the IT Bureau for upload.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3353334
Longitude:
-71.1772035
Location:
Case
number:
Date:
2019-12-14
Time:
18:40
Address:
139 MELROSE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
At approximately 1840HRs on Saturday, December 14, 2019, I was dispatched to 139 Melrose St. for a report of a single car vs tree MVA. Upon arrival, I observed MV1 (MA Pass:13LM32) to be at rest on the side of the road with it's front end contacting a tree, aproximaytely 150 feet south of the above address at a bend in the road. It should be noted that it had been raining for hours prior to this accident and that the road surface was wet; additionally the tree did not appear to be damaged. Upon speaking to the operator of MV1, he stated that he was traveling Southbound on Melrose St. when he navigated around a parked car in front of the above address and as he did so, may have overcorrected or due to the current road surface condition, accidently struck the tree. The front seat passenger of MV1 concurred with the operator's statement. Both parties stated they were not injured. MV1 sustained damage to its front end. As MV1 was not impeding traffic, AAA contacted and towed MV1 at the behest of the operator. I cleared without incident.
Keywords:
Crash, Rain, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3517403
Longitude:
-71.2496257
Location:
Case
number:
Date:
2020-06-11
Time:
09:36
Address:
1765 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated that he was traveling south on Washington St when a large tree limb broke from the tree in the front yard of #1765 Washington St striking the front of his MV. I then informed the residents at #1765 Washington St what occurred and gave them a copy of the Crash Data Exchange Form. The City of Newton Forestry responded and removed the large limb from the roadway. There were no injuries and no tows.
Keywords:
Crash, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3390281
Longitude:
-71.2405766
Location:
Case
number:
Date:
2020-08-09
Time:
15:00
Address:
458 CHESTNUT ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On 08/09/2020 at 1500 hrs, I was dispatched to the area of Chestnut St. and Gordon Rd. for a Motor Vehicle Accident. Dispatch stated a UHaul truck had collided into a city tree. Upon arrival, I observed a Uhaul truck, on the sidewalk in front of 458 Chestnut St. The truck was facing northbound on Chestnut St. and had heavy front end damage as it was driven into tree #2.The operator stated that tree #1 had fallen onto the road, causing her to swerve, hit the curb and then collide into tree #2.. There were tire marks leading from the curb tree #2. The Newton Forestry Department was contacted to remove the tree #2 from the roadway, and to evaluate tree #1. (Both city tree's). Tody's Tow service arrived on scene and removed the Uhaul truck from the sidewalk. The operator stated she was not injured and declined medical attention. The homeowner at 458 Chestnut St. was give instructions on how to obtain a copy of this report, as potential damage was done to her property. Pictures of the damaged Uhaul truck, and both tree's were taken on the (N493) camera and submitted to the Newton Police It Bureau.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3338564
Longitude:
-71.2241716
Location:
Case
number:
Date:
2020-08-18
Time:
15:48
Address:
20 SUTCLIFFE PK
Speed
limit:
20
Violation
cited:
no
Narrative:
On 8/18/20 at 1548 hrs I responded to Sutcliffe Pk for a Waste Management truck that had taken down a telephone pole. The truck was turning around at the top of Sutcliffe Pk and got caught in the wires and an overhanging tree. As the truck continued to progress it dragged more of the wires and snapped a telephone pole causing it to fall on the street. The operator states that the truck is 13' 6" high. 5 pictures were taken of the scene and were turned over to IT. No injuries reported on scene. Eversource responded and restored power. Eversource, Verizon, and Comcast all had wires damaged due to the accident.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3086263
Longitude:
-71.2059791
Location:
Case
number:
Date:
2020-08-28
Time:
13:10
Address:
119 WASHINGTON STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 stated he was in his truck traveling Westbound on Washington Street and struck a large City of Newton tree branch that was hanging over the road. The city tree which was directly across the street from 119 Washington Street was ripped out of the ground next to the sidewalk and split into two large pieces causing Waverly Avenue to be blocked. City of Newton forestry came out and assessed the scene and Northern Tree arrived to clear out the branches in the middle of the road. Motor Vehicle #1 sustained minor front upper damage. Several photographs were taken and the SD Card was placed in the I.T. Bureau to attach photos to this report.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3557253
Longitude:
-71.1788512
Location:
Case
number:
Date:
2020-10-05
Time:
12:53
Address:
1763 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/05/20 Sgt Giardina notified me that he was flagged down by a person who wished to remain anonymous that stated they had seen a niisan maxima strike a tree and two trash barrels in front of 1763 Commonwealth Ave. On arrival I saw two City of Newton trash barrels destroyed and a city tree down on its side on the sidewalk. There were skid marks going back out onto the road westbound on Commonwealth Ave. I was able to notify the homeowner, Melissa Woythaoer who stated she was upstairs and never heard anything. Units canvassed the area with negative results. Officer Gaudet took pictures of the damage.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.341503
Longitude:
-71.2385206
Location:
Case
number:
Date:
2020-10-07
Time:
17:53
Address:
11 MOSSFIELD RD
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated she was traveling Westbound of Mossfield Rd when a large tree fell on top of her car. The tree which belongs to 11 Mossfield Rd landed on the hood, windshield and front half of the roof. The impact caused major damage to the vehicle. The occupants were able to exit the vehicle and reported no injuries. Pictures of the incident were taken by me and submitted to IT.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3257898
Longitude:
-71.2411798
Location:
Case
number:
Date:
2020-10-09
Time:
15:13
Address:
2044 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Beacon St when the vehicle in front of her vehicle struck a low hanging tree branch that landed on top of her vehicle. Branch caused minor damage to the windshield. OPMV#1 Stated she was driving behind a truck on Beacon St and when the truck was entering the turn lane to turn right on Washington St a branch from a tree broke off and landed on her car.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3297408
Longitude:
-71.2478316
Location:
Case
number:
Date:
2020-10-22
Time:
13:50
Address:
48 SARGENT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of vehicle 1 stated he was alerted by one of his workers that one of their work vehicles were just struck by another vehicle that took off and fled the area. The truck was parked in front of #48 Sargent St eastbound. The worker stated the other vehicle looked like a gray Honda civic. The truck did not require a tow and was unoccupied at the time. #48 Sargent does have cameras out front but look to be obstructed by trees and is unknown if they are operational. I canvassed the area with negative results.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3466386
Longitude:
-71.1831908
Location:
Case
number:
Date:
2020-11-16
Time:
12:47
Address:
866 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On November 16, 2020 at approx 1247 hours I responded to the area of 866 Beacon Street for a report of motor vehicle crash with City property damage. Upon arrival I spoke with the oper of vehicle 1 Mr. Quinn, he stated while traveling east bound on Beacon Street, he pulled over to park properly the right top corner of the dump body had contact with a City tree in the area of 866 Beacon Street. I observed the dump truck in the eastbound lane of Beacon Street with damage to the right side dump body, right side of truck cab, passenger side door, mirror and passenger side fender, there may have been more internal damage, but I could not asses due to the tree leaning against the truck. I looked around the crash site area, I observed the City tree was not trimmed properly and was too far into the roadway in the normal path of travel for all vehicles. Forestry arrived on scene cut up and disposed of the tree. I took pictures of the crash site area that I will download at the I.T. Bureau I advised Mr. Quinn of the process.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.329946
Longitude:
-71.1966968
Location:
Case
number:
Date:
2020-12-05
Time:
08:51
Address:
200 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
VEHICLE OPERATOR WAS TRAVELING STRAIGHT AHEAD ON NAHANTON ST, HEADING WESTBOUND. HE STATES THAT HE WAS GOING THE LEGAL SPEED LIMIT. HE VEHICLE SKIDDED OUT OF HIS LANE, SIDESWIPED A TREE ON THE OPPOSITE SIDE OF THE ROAD. AND TOOK OUT A COUPLE SECTIONS OF FENCE AT THE CHARLES RIVER COUNTRY CLUB. NO INJURIES REPORTED, VEHICLE TOWED BY TODYS TOWING OF NEWTON CHARLES RIVER COUNTRY CLUB WAS NOTIFIED BY MYSELF VIA VOICEMAIL OF THE DAMAGE TO THEIR PROPERTY.
Keywords:
Speed, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2986412
Longitude:
-71.1985702
Location:
Case
number:
Date:
2020-11-30
Time:
15:17
Address:
276 WOODWARD ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was driving Northbound on Woodward St. when a branch from a city tree fell onto the top of the vehicle. This occurred in front of 276 Woodward St. It should be noted that it was raining heavily during this time. Refer to incident #20053845 for further details.
Keywords:
Rain, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3236844
Longitude:
-71.2228025
Location:
Case
number:
Date:
2021-01-14
Time:
08:24
Address:
200 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 (13'6'' box truck) was travelling on Commonwealth Ave W/B in the area of #200. The passenger side roof struck an overhanging limb from a city tree on the median. The limb ripped off most of the roof in this area leaving shards of unsecured roof and debris sticking upward. The truck was unsafe to operate in this condition. Traffic Ofc Gaudet took photos of the area. Tody's Towing was notified to respond. Tody's was required to cut sections of the protruding roof on scene before being able to safely tow it away.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3369839
Longitude:
-71.174233
Location:
Case
number:
Date:
2021-05-27
Time:
13:29
Address:
21 OAKWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that he was following his GPS to Charlestown, MA when it took him into Newton. MV#1, a large tractor trailer ended up on Oakwood Rd. a small residential neighborhood, when the top of his trailer struck a tree limb causing significant damage to the trailer. The tractor trailer then traveled to Hancock St and notified the NPD. Because I was on Hancock St with the damaged tractor trailer, Officer Nardelli responded to Oakwood Rd and viewed the damage. Officer Nardelli reports minor damage to a city owned tree in front of #21 Oakwood Rd, minor damage to a curb in that area and minor damage to the lawn at #55 Williston Rd. Residents/owners of #55 Williston Rd are aware of the damage. No injuries and no tows.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3412008
Longitude:
-71.2534309
Location:
Case
number:
Date:
2021-06-23
Time:
08:47
Address:
12 MYRTLE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was traveling northbound on Myrtle Street when it crashed into a low hanging City of Newton tree in front of 12 Myrtle Street. As a result of the crash the tree completely uprooted and ripped out the telephone/internet services to 10 and 12 Myrtle Street, as well as 1560 and 1554 Washington Street. MV1 sustained moderate front/top passengers side damage. The City of Newton Forestry division was able to respond and remove the downed tree. I took five pictures of the damage to City property and submitted them to the IT bureau.
Keywords:
Crash, Moderate, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.344429
Longitude:
-71.2341087
Location:
Case
number:
Date:
2021-08-02
Time:
16:02
Address:
215 VALENTINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling northbound on Chestnut St when the operator noticed that a box truck in front of him nicked a branch off a tree belonging to 224 Valentine St in front of him. The tree branch didn't fall right away but broke off the moment MV1 was underneath it. MV1 operator did not receive any information on the box truck. There was damage to MV1 passenger mirror and passenger door's A frame. No injuries reported and vehicle was still operable.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3385302
Longitude:
-71.2152378
Location:
Case
number:
Date:
2021-08-16
Time:
09:16
Address:
267 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday August 16, 2021 at approx. 0916 hours I responded to the area of 267 Watertown Street for a report of a motor vehicle crash with a City tree and property damage. Upon arrival I met with the operator of the truck, Lucky Thipharacksa d.o.b. 10-8-84 of 25 Bradley Avenue Hamdon CT., who works for MKN UNITED INC. 1039 STATE STREET SUITE 203 BETTENDORF, I.A. 52722. He stated he was traveling west on Watertown Street when the top right portion of the truck had impact with a City tree. As a result of the impact, the tree took down Verizon cable wires, causing damage to the right side of the house number 279/281 Watertown Street ( gutters, masonry-brick, landscape, and possible other house damage. The resident at 267 Watertown Street was notified of the tree down near and partially against the property fence. I advised her if there is damage to contact me after tree removal and I will add information to the report. Forestry was notified to remove the tree, the owner of 279/281 Watertown Street was notified of process and report. Verizon was notified of wires. I conducted a post crash level one inspection on the truck which I placed Out Of Service due to the damage. The driver was arrangements for the tow. Below is inspection findings. VIOLATIONS 393.201A POST CRASH (4) UPPER FRAME RAILS DAMAGED - SEPARATED (OOS) 393.201A POST CRASH (3) SIDE FRAME RAILS DAMAGED - SEPARATED (OOS) 393.201A POST CRASH (5) FRONT FRAME RAILS DAMAGED - SEPARATED FROM FRAME (OOS) All parties advised of the process and there were no reported injuries.
Keywords:
Crash, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3615207
Longitude:
-71.1976947
Location:
Case
number:
Date:
2021-08-16
Time:
12:20
Address:
74 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV 1 was traveling westbound on Grove St when a tree's branch located on 73 Grove St broke off and fell on MV1. As result of the crash MV1 sustained significant front end and head damage. A private tow company came and took the motor vehicle, and Newton Forestry was noticed. Officer Ferguson took pictures of the accident.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3438088
Longitude:
-71.2475375
Location:
Case
number:
Date:
2022-01-03
Time:
08:54
Address:
241 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday 1/3/22 at approximately 0854 hours while assigned to marked unit n498 I was dispatched to the area of 241 Nahanton Street for a report of a single car crash, motor vehicle into a tree with unknown injuries. Upon arrival I spoke with the operator, TEIXEIRA Kevin, who was standing outside of his vehicle and uninjured. TEIXEIRA states he was driving eastbound on Nahanton street and coming around the bend when he observed a motor vehicle in the westbound lane swerve to avoid something. When the other motor vehicle swerved it crossed the double yellow line and entered the eastbound lane coming at TEIXEIRA head on. TEIXEIRA states to avoid contact with the oncoming vehicle he swerved into the Westbound lane of Nahanton Street going off the road and striking several trees. TEIXEIRA states he was unable to observe a license plate number or what type of car crossed the double yellow line. TEIXEIRA states everything happened very quickly which prevented him from getting any other information. He states one motor vehicle pulled over and inquired if he was injured, but did not see what happened. TEIXEIRA further states the motor vehicle that swerved into his lane never stopped.
Keywords:
Crash, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2991887
Longitude:
-71.1984373
Location:
Case
number:
Date:
2022-04-08
Time:
15:31
Address:
10 CHAMPA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV2 operator states he was backing his Amazon work truck back to Cottage St and was watching for the low hanging tree branches when he did not see and struck MV1. Minor damage was observed on both vehicles. Both vehicles were damaged on their rear left bumpers. MV1 was parked at the time and unoccupied. The registered owner was notified and given all appropriate information. No injuries on scene and no tows needed.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3130025
Longitude:
-71.218309
Location:
Case
number:
Date:
2022-04-22
Time:
11:10
Address:
191 AUBURNDALE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that as he was travelling Westbound on Auburndale Ave he struck a low-hanging branch from a City of Newton owned tree. As a result the roof and walls of the box-truck's bed was ripped off. The vehicle was towed by Tody's Towing Co. Pictures were taken and given to IT for entry into this report.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3507458
Longitude:
-71.2397877
Location:
Case
number:
Date:
2022-06-16
Time:
09:09
Address:
97 ELIOT AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV 1 STATED HE WAS TRAVELING SOUTH ON ELIOT AVE AND AS HE WAS DRIVING DOWN THE ROAD THERE WAS A LOW HANGING TREE BRANCH WHICH STRUCK THE TOP OF HIS DELIVERY TRUCK CAUSING DAMAGE TO THE ROOF. NO INJURIES WERE REPORTED AND FORESTRY WAS ADVISED TO CLEAN UP THE BRANCHES.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3544204
Longitude:
-71.2215495
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);