CREATE TABLE incidents(
   animal                      VARCHAR(31) NOT NULL
  ,quantity                    INTEGER  NOT NULL
  ,body_part_found             VARCHAR(58) NOT NULL
  ,date_started                DATETIME  NOT NULL
  ,date_closed                 DATETIME 
  ,source                      VARCHAR(34)
  ,division                    VARCHAR(53) NOT NULL
  ,form                        VARCHAR(18) NOT NULL
  ,status                      VARCHAR(8) NOT NULL
  ,priority                    VARCHAR(6) NOT NULL
  ,complaint_type              VARCHAR(16) NOT NULL
  ,descriptor_1                VARCHAR(11) NOT NULL
  ,descriptor_2                VARCHAR(3) NOT NULL
  ,complaint_details           TEXT NOT NULL
  ,location_type               VARCHAR(4) NOT NULL
  ,park_or_facility            VARCHAR(40) NOT NULL
  ,property_number             VARCHAR(8)
  ,park_district               VARCHAR(4)
  ,additional_location_details VARCHAR(225) NOT NULL
  ,council_district_number     INTEGER  NOT NULL
  ,site_street_address         VARCHAR(43)
  ,site_borough                VARCHAR(13) NOT NULL
  ,site_city_zip               VARCHAR(16)  NOT NULL
  ,zip_code                    INTEGER NOT NULL
  ,site_city                   VARCHAR(16) NOT NULL
  ,lat                         NUMERIC(10,7) NOT NULL
  ,lng                         NUMERIC(11,7) NOT NULL
  ,complaint_type_confirmed    VARCHAR(16) NOT NULL
  ,descriptor_confirmed        VARCHAR(11) NOT NULL
  ,resolution_action_updated   DATETIME
  ,resolution_description      VARCHAR(170)
  ,time_to_action              VARCHAR(26) NOT NULL
);
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2006-04-01 00:00:00','2006-04-01 00:00:00','40.7927426','Dead Animal','W 91 ST AND RIVERSIDE DR','Closed: No Further Updates','6','-73.9770935','NEW YORK 10023','Normal','3-1-1 Call Center','Birds','N/A','2006-04-01 00:00:00','ON THE 90 STREET ENTRANCE TAKE THE RIGHT HAND PATH WALK 100 YARD WITH THE PATH SPLIT THERE IS A BIG TREE WITH THE BAGS NEXT TO IT.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','THE CALLER IS REPORTING THAT THERE ARE 5 BLACK BAG FILLED WITGH DEAD BIRDS CHICKEN LEGS OR ROOSTER LEGS AND THE BIRDS HAVE NAILS IN THEIR HEAD LIKE SOMEONE WAS DOING VOODOO. THIS IS NOT THE FIRST TIME THECALLER HAS REPORTED THIS. THE BAG IS INSIDE THE PARK ON THE 90 STREET ENTRANCE WITH THE WALKWAY SPLITS BY A TREE THE BAGS ARE NEXT TO IT.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK - HIPPO PLAYGROUND','14','Park','Head, Legs, Body parts separated','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2006-04-19 00:00:00','2006-04-19 10:16:54','40.6080438','Dead Animal','RICHMOND AVE TO VICTORY BLVD','Closed: No Further Updates','50','-74.1572251','STATEN ISLAND 10314','Normal','3-1-1 Call Center','Rooster','N/A','2006-04-14 00:00:00','CLOSER TO ASHWORTH AVE','Closed','Borough Maintenance Operations Office - Staten Island','DPR General Intake','THE CALLER STATES THAT THERE IS A DEAD ROOSTER WITH IT''S HEAD CUT OFF IN THE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','WILLOWBROOK PARK','2','Park','Head and Body','Animal in a Park','R030','Animal in a Park','STATEN ISLAND','Dead Animal','STATEN ISLAND','10314','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2006-04-16 00:00:00','2006-04-16 12:52:40','40.864318','Dead Animal','','Closed: No Further Updates','13','-73.7977928','BRONX 10464','Normal','3-1-1 Call Center','Birds','N/A','2006-04-16 00:00:00','OPEN THE GATE LOOK DOWN AT THE BEACH AND THEY ARE ALL IN THERE. AT THE END OF EAST BOWNE STREET.','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATES THAT HE SAW NINE BIRDS WITH NO HEADS LAYING OUT IN THE BEACH, HE ALSO TWO BAGS WITH WHAT HE BELIEVES ARE FULL OF IT.','No action was taken because the Department of Parks and Recreation determined that the issue reported was out of its jurisdiction.','NOT SPECIFIED','','Park','Body Without Head','Animal in a Park','','Animal in a Park','BRONX','Dead Animal','BRONX','10464','9');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2006-07-02 00:00:00','2006-07-02 13:03:12','40.6184839','Dead Animal','SLOSSON AVE, VICTORY BLVD, CLOVE RD','Closed: No Further Updates','49','-74.1054656','STATEN ISLAND 10301','Normal','Department of Parks and Recreation','Lamb','N/A','2006-07-02 00:00:00','martlings & brooks pond pl','Closed','Department of Parks and Recreation','DPR General Intake','clove lakes (martlings & brooks pond pl): sgt a.reid rpts that a decapitated lamb was found at site (head was not at location). carcass will be removed my m&o.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','CLOVE LAKES PARK','1','Park','Body Without Head','Animal in a Park','R005','Animal in a Park','STATEN ISLAND','Dead Animal','STATEN ISLAND','10301','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('0000-00-00 00:00:00','0000-00-00 00:00:00','40.8476284','Dead Animal','(S) MIDDLETOWN RD. TO (W) BRUCKNER','Closed: No Further Updates','13','-73.8360251','BRONX 10461','Normal','3-1-1 Call Center','Dove & Chicken','N/A','2006-11-11 00:00:00','THE BIRDS IN THE WOODED AREA NEAR THE WOODS ENTRANCE AT STADIUM AVENUE AND MIDDLETOWN ROAD.','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATES THAT HE WAS WALKING IN PELHAM BAY PARK IN THE BRONX, AND SAW A DEAD DOVE AND CHICKEN. THEY WERE SURROUNDED BY CANDLES AND COINS. THE ANIMALS WERE BEHEADED.','The Department of Parks and Recreation usually requires 7 days to respond to this type of complaint. Please note your Service Request number for future reference.','PELHAM BAY PARK - AILEEN RYAN RECREATION','15','Park','Head and Body','Animal in a Park','X039','Animal in a Park','BRONX','Dead Animal','BRONX','10461','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2006-12-11 00:00:00','2006-12-11 12:43:44','40.6730447','Dead Animal','','Closed: No Further Updates','35','-73.9850231','BROOKLYN 11215','Normal','3-1-1 Call Center','Pigeon','N/A','2006-12-10 00:00:00','ENTRANCE ON WASHINGTON PARK','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STATES THAT THERE IS A TWO PIGEONS THAT ARE BEHEADED AND GUTTED','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','WASHINGTON PARK','','Park','Head and Body','Animal in a Park','','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11215','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-01-09 00:00:00','2007-01-09 15:11:15','40.8022594','Dead Animal','ST MARYS ST, ST ANNS AVE, E 149 ST, JACKSON','Closed: No Further Updates','17','-73.9154069','BRONX 10454','Normal','3-1-1 Call Center','Pigeon & Pig','N/A','2006-12-30 00:00:00','NEXT TO THE PARK NEAR THE PICKNICK TABLE AREA ON THE GRASS','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATES THAT THERE ARE 3 DEAD PIGEONS IN THE PARK. THESE PIGEONS HAS BODY BUT NOT THEIR HEADS. CALLER ALSO STATED THAT THERE THERE IS A PIG''S HEAD WITHOUT BODY IN THE PARK. CALLER STATED THEY ARE NEXT TO EACH OTHER.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','ST MARY''S PARK','1','Park','Head','Animal in a Park','X045','Animal in a Park','BRONX','Dead Animal','BRONX','10454','4');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-01-06 00:00:00','2007-01-06 18:09:43','40.7245678','Dead Animal','GRAND CENTRAL PKWY, VAN WYCK EXWY','Closed: No Further Updates','21','-73.8457658','FOREST HILLS 11375','Normal','Department of Parks and Recreation','Goat','N/A','2007-01-06 00:00:00','Meadow Lake','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','Ofc. Jajac of Qns PEP notified central of a goat head in the Meadow Lake. M&O removed the head and disposed of it.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FLUSHING MEADOWS AND CORONA PARK','15','Park','Head','Animal in a Park','Q099','Animal in a Park','QUEENS','Dead Animal','FOREST HILLS','11375','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-02-28 00:00:00','2007-02-28 11:01:46','40.5860069','Dead Animal','','Closed: No Further Updates','48','-73.9418603','BROOKLYN 11235','Normal','3-1-1 Call Center','Not specified','N/A','2007-02-21 00:00:00','GREEN STREET AT LOCATION','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STS THAT THERE ARE TWO HEADS FROM UNKNOWN ANIMAL(S) AT THE GREEN STREET AT SITE LOCATION','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','NOT SPECIFIED','','Park','Head','Animal in a Park','','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11235','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-04-23 00:00:00','2007-04-23 14:36:01','40.8524136','Dead Animal','BRUCKNER BLVD, EASTCHESTER, HUTCHINSON','Closed: No Further Updates','13','-73.8263227','BRONX 10461','Normal','3-1-1 Call Center','Roosters','N/A','2007-04-22 00:00:00','NEAR THE DUMP, ONE PATH IN FROM THE WATER, NEAR DIAMOND 7','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATED THAT THERE ARE TWO DEAD DECAPITATED WHITE ROOSTER''S IN A PARK CALLED PELHAM BAY PARK. CALLER STATES THAT THERE ARE HUMAN CLOTHES NEXT TO IT, CALLER STATES THAT SHE ONLY SEES ONE HEAD. THE ANIMALS ARE BY THE DUMP RIGHT NEXT TO THE WATER AND CALLER WOULD LIKE SOME ASSISTANCE IN HAVING IT REMOVED.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PELHAM BAY PARK','15','Park','Head and Body','Animal in a Park','X039','Animal in a Park','BRONX','Dead Animal','BRONX','10461','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-10-09 00:00:00','2007-10-09 12:06:30','40.7700703','Dead Animal','5 AVENUE TO CENTRAL PARK WEST, 59 TO 110','Closed: No Further Updates','8','-73.9580246','NEW YORK 10021','Normal','3-1-1 Call Center','Bird','N/A','2007-09-04 00:00:00','NEAR 86TH ENTRANCE WEST SIDE','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','DEAD ANIMAL. A BIRD. HEAD WAS CUT OFF','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','CENTRAL PARK','13','Park','Head and Body','Animal in a Park','M010','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10021','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-10-24 00:00:00','2007-10-24 11:08:57','40.7769059','Dead Animal','RIVERSIDE DR TO HUDSON RIVER, W 59 ST TO','Closed: No Further Updates','6','-73.9800645','NEW YORK 10023','Normal','3-1-1 Call Center','Cat','N/A','2007-09-17 00:00:00','LOCATED AT THE 99 ST ENTRACE ON THE PATH ON THE UPPER LEVEL','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATES HE FOUND A CAT HEAD PLACED ON FENCE INSIDE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK','14','Park','Head','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-10-24 00:00:00','2007-10-24 10:59:32','40.7965253','Dead Animal','W 97 ST AND RIVERSIDE DR','Closed: No Further Updates','6','-73.9741203','NEW YORK 10023','Normal','3-1-1 Call Center','Cat','N/A','2007-09-17 00:00:00','SOUTH OF FIREMANS MENORIAL BETWEEN 99 STREET AND 100 STREET.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATES HE FOUND A CATS HEAD PLACED ON FENCE IN RIVERSIDE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK - DINASOUR PLAYGROUND','14','Park','Head','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-11-09 00:00:00','2007-11-09 11:23:27','40.7965253','Dead Animal','W 97 ST AND RIVERSIDE DR','Closed: No Further Updates','6','-73.9741203','NEW YORK 10023','Normal','3-1-1 Call Center','Cat','N/A','2007-09-17 00:00:00','ON W 99 STREET AND RIVERSIDE DRIVE.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATED THAT THERE IS A CAT IN THE CITY PARK WHICH IS DECAPITATED BY SOMEONE, CALLER STATED THIS ANIMAL NEED TO CLEAN UP AND NEED SOME ASSISTANCE. CLR STATED THE ANIMAL IS NEAR THE FIREMAN MEMORIAL.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK - DINASOUR PLAYGROUND','14','Park','Head','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-11-13 00:00:00','2007-11-13 16:26:26','40.8012339','Dead Animal','','Closed: No Further Updates','9','-73.9723096','NEW YORK 10025','Normal','3-1-1 Call Center','Cat','N/A','2007-09-17 00:00:00','FIREMEN MEMORIAL AREA. WALK ON THE PATH','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATED THAT THERE IS A CAT HEAD THAT IS ATTACHED TO STAKE THAT IS FENCED AROUND THE FIREMEN MEMORIAL.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK','','Park','Head','Animal in a Park','','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10025','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-10-25 00:00:00','2007-10-25 14:23:59','40.8621507','Dead Animal','','Closed: No Further Updates','11','-73.8807418','BRONX 10458','Normal','3-1-1 Call Center','Not specified','N/A','2007-10-24 00:00:00','OPPOSITE 306 E MOSHOLU PKWY SOUTH, NEXT TO TREE IN PARK','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','DEAD ANIMAL HEAD IN A BLUE PLASTIC BAG','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','BRONX PARK','','Park','Not specified','Animal in a Park','','Animal in a Park','BRONX','Dead Animal','BRONX','10458','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-11-20 00:00:00','2007-11-20 14:39:17','40.8187386','Dead Animal','NYCRR, WALTON AVE, E 158 ST, GRAND','Closed: No Further Updates','17','-73.9271644','BRONX 10451','Normal','3-1-1 Call Center','Chicken','N/A','2007-11-19 00:00:00','THE DEAD BIRDS ARE NEAR THE EAST 158TH STREET ENTRANCE','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','THE CALLER STATES THAT THERE TWO DECAPITATED CHICKENS INSIDE OF THE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FRANZ SIGEL PARK','4','Park','Head and Body','Animal in a Park','X047','Animal in a Park','BRONX','Dead Animal','BRONX','10451','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-12-11 00:00:00','2007-12-11 09:46:09','40.8032131','Dead Animal','W 110 TO W 123 ST, MANHATTAN AVE TO','Closed: No Further Updates','9','-73.9525825','NEW YORK 10026','Normal','3-1-1 Call Center','Chicken','N/A','2007-12-08 00:00:00','MORNINGSIDE DRIVE AND WEST 120 STREET ON THE STAIRS','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','CALLER STATE THERE ARE ABOUT 2 DEAD CHICKENS WITHOUT HEADS IN THE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','MORNINGSIDE PARK','9','Park','Body Without Head','Animal in a Park','M056','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10026','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2007-12-26 00:00:00','2007-12-26 08:42:05','40.8765981','Dead Animal','RESERVOIR OVAL EAST, HOLT PL','Closed: No Further Updates','11','-73.8765489','BRONX 10467','Normal','3-1-1 Call Center','Chicken','N/A','2007-12-15 00:00:00','IN THE PARK','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATES THAT THERE IS A DEAD ANIMAL IN THE ENTRANCE OFF THE PARK. ITS A DEAD CHICKEN WITH HIS HEAD CUT OFF.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','WILLIAMSBRIDGE OVAL -P G MINI POOL AND','7','Park','Head and Body','Animal in a Park','X104','Animal in a Park','BRONX','Dead Animal','BRONX','10467','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2008-03-27 00:00:00','2008-03-27 14:37:19','40.8262186','Dead Animal','WESTCHESTER CR, SCHLEY, EMERSON AVES.','Closed: No Further Updates','18','-73.8242621','BRONX 10465','Normal','3-1-1 Call Center','Chicken','N/A','2008-03-25 00:00:00','NORTH WEST BARBEQUE AREA BY THE WATER FRONT.','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER IS REPORTING THAT THERE ARE TWO DEAD CHICKENS IN THE PARK WITH THEIR HEADS CUT OFF. IT IS BY THE WATER FRONT NEAR NORTH WEST BARBEQUE AREA.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FERRY POINT PARK','10','Park','Head and Body','Animal in a Park','X126','Animal in a Park','BRONX','Dead Animal','BRONX','10465','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2008-04-09 00:00:00','2008-04-09 14:17:26','40.8262186','Dead Animal','WESTCHESTER CR, SCHLEY, EMERSON AVES.','Closed: No Further Updates','18','-73.8242621','BRONX 10465','Normal','3-1-1 Call Center','Goat','N/A','2008-04-08 00:00:00','BY WATER OF THE BEACH.','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER SAID THAT THERE IS A DEAD GOAT WITH NOT HEAD, LOCATED BY THE WATER AT THE BEGINNING OF THE BEACK IN THE PARK.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FERRY POINT PARK','10','Park','Body Without Head','Animal in a Park','X126','Animal in a Park','BRONX','Dead Animal','BRONX','10465','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2008-04-24 00:00:00','2008-04-24 15:59:09','40.7138051','Dead Animal','HIGHLAND AVE, UPLAND PKWY, GOTHIC PKWY','Closed: No Further Updates','24','-73.7956131','JAMAICA 11436','Normal','Department of Parks and Recreation','Turtle','N/A','2008-04-24 00:00:00','HIGHLAND AVE OFF 164 STREET','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','PS2 J BROPHY RPTS THAT THERE ARE SOME TURTLES WITH MISSING HEAD.','Upon inspection the reported condition was not found, and, therefore, no action was taken.','CAPT TILLY PARK','8','Park','Body Without Head','Animal in a Park','Q052','Animal in a Park','QUEENS','Dead Animal','JAMAICA','11436','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-04-30 00:00:00','2008-04-30 15:33:44','40.7797981','Dead Animal','','Closed: No Further Updates','6','-73.9893241','NEW YORK 10069','Normal','3-1-1 Call Center','Goat (Unsure)','N/A','2008-04-26 00:00:00','down on the ramp on righthand side. there a box next to the goat','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','a caller stated that in riverside park there is a dead animal. the caller thinks that its a goat with its head cut off.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK','','Park','Head and Body','Animal in a Park','','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10069','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-05-08 00:00:00','2008-05-08 16:55:32','40.6898249','Dead Animal','MYRTLE AVENUE, CUMBERLAND ST, DEKALB AVE ','Closed: No Further Updates','35','-73.9812036','BROOKLYN 11201','Normal','3-1-1 Call Center','Hens & Pigeons','N/A','2008-05-05 00:00:00','the entrance of myrtle ave and st edwards','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STATES THERE IS 2 Large HENS THAT ARE HEADLESS AND 3 Pigeons HEADLESS.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FORT GREENE PARK','2','Park','Body Without Head','Animal in a Park','B032','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11201','5');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2008-11-14 00:00:00','2008-11-14 16:50:35','40.8042197','Dead Animal','WEST 109TH STREET AND RIVERSIDE DRIVE','Closed: No Further Updates','6','-73.9686798','NEW YORK 10023','Normal','3-1-1 Call Center','Bird','N/A','2008-11-14 00:00:00','CALLER STATES BY 106 ST AND RIVERSIDE DRIVE, LOCATED IN THE WALKING PROMONADE BY A TREE BY THE WALL.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATES THAT THERE ARE 2 WHITE BIRDS IN A BAG WITH THEIR HEADS CUT OFF','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK - SKATE PARK','14','Park','Head and Body','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-03-25 00:00:00','2009-03-25 20:18:02','40.6184839','Dead Animal','VICTORY BOULEVARD, WEST OF CLOVE ROAD','Closed: No Further Updates','49','-74.1054656','STATEN ISLAND 10301','Normal','3-1-1 Call Center','Turkey or Chicken','N/A','2009-03-25 00:00:00','INSIDE THE PARK BY PINE TREES','Closed','Borough Maintenance Operations Office - Staten Island','DPR General Intake','CALLER STATES THAT WHILE WALKING HIS DOG IN THE PARK THEY CAME ACROSS EITHER A DEAD TURKEY OR CHICKEN WITH THE HEAD OFF. THE HEAD IS NOWHERE TO BE FOUND.','The condition was determined to be an issue appropriate for handling by an alternate entity. The Department of Parks and Recreation has notified the appropriate resource.','CLOVE LAKES PARK - WAR MEMORIAL ICE','1','Park','Body Without Head','Animal in a Park','R005','Animal in a Park','STATEN ISLAND','Dead Animal','STATEN ISLAND','10301','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-04-21 00:00:00','2009-04-21 09:34:18','40.6998251','Dead Animal','','Closed: No Further Updates','30','-73.8312457','RICHMOND HILL 11418','Normal','3-1-1 Call Center','Goat, Rooster and Other animals','N/A','2009-04-18 00:00:00','ENTER PARK LANE SOUTH AND MYRTLE. ITS ON THE ORANGE TRAIL AND CALLER DOESN''T MIND TO COME OUT AND SHOW THE EVIDENCE.','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','CALLER STATES: FOUND A GOATS HEAD, A BLACK ROOSTER AND SOME OTHER BODY PARTS OF ANIMALS. THERE IS ALSO A BIG RIB CAGE OF THE GOATS WITHOUT ANY MEAT ON IT.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FOREST PARK','','Park','Goat''s Head & Rib Cage, Other body parts of other animals.','Animal in a Park','','Animal in a Park','QUEENS','Dead Animal','RICHMOND HILL','11418','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-04-28 00:00:00','2009-04-28 12:20:48','40.6718171','Dead Animal','VAN WYCK EXPRESSWAY, 116TH AVENUE, 140TH','Closed: No Further Updates','28','-73.7977928','JAMAICA 11436','Normal','3-1-1 Call Center','Roosters','N/A','2009-04-27 00:00:00','ON THE BEACH AREA BY 95 STREET. CALLER STATES DPR COULD TAKE WALK ON BEACH BEAR SAND TO LOCATE DEAD ANIMAL','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','CALLER''S REQUESTING DEAD ROOSTERS BE REMOVED ON THE PUBLIC BEACH WITH THEIR HEAD CUT OFF. CALLER STATES ITS ABOUT TWO OR THREE ROSTERS DEAD.','No action was taken because the Department of Parks and Recreation determined that the issue reported was out of its jurisdiction.','DR. CHARLES R. DREW MEMORIAL PARK','12','Park','Head and Body','Animal in a Park','Q220C','Animal in a Park','QUEENS','Dead Animal','JAMAICA','11436','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-06-10 00:00:00','2009-06-10 20:57:28','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HARLEM','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','3-1-1 Call Center','Chicken','N/A','2009-06-10 00:00:00','ENTRANCE OF THE PARK ACROSS FROM 115 PAYSON AVE WALK UP THE PATH TO THE FIRST STAIRCASE ON THE LEFT, CHICKENS IS ON THE BOTTOM OF THE STAIRS.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATES THAT THERE IS A DEAD, HEADLESS CHICKEN INSIDE THE PARK. THERE IS A HEINEKEN BOX THERE THAT WAS PROBABLY USED TO TRANSPORT THE CHICKEN.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','INWOOD HILL PARK','12','Park','Body Without Head','Animal in a Park','M042','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-09-29 00:00:00','2009-09-29 15:25:13','40.8615','Dead Animal','','Closed: No Further Updates','13','-73.7972','BRONX 10464','Normal','3-1-1 Call Center','Goat','N/A','2009-09-28 00:00:00','CITY ISLAND BRIDGE ON PELHAM BAY SIDE OF BRIDGE, SOUTH SIDE','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','DEAD GOAT ON A BEACH, HEADLESS','Upon inspection the reported condition was not found, and, therefore, no action was taken.','PELHAM BAY PARK','','Park','Body Without Head','Animal in a Park','','Animal in a Park','BRONX','Dead Animal','BRONX','10464','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-10-26 00:00:00','2009-10-26 16:04:17','40.862009','Dead Animal','','Closed: No Further Updates','7','-73.9323081','NEW YORK 10040','Normal','3-1-1 Call Center','Chicken','N/A','2009-10-22 00:00:00','ON THE CABRINI BLVD SIDE OF PARK','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER IS REPORTING 2-3 DECAPITATED CHICKEN IN A PARK NEXT TO THE SIDEWALK BUT ON THE PROPERTY LINE OF THE PARK.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FORT TYRON PARK','','Park','Not specified','Animal in a Park','','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10040','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-11-05 00:00:00','2009-11-05 16:09:36','40.7877029','Dead Animal','WEST 83RD STREET AND RIVERSIDE DRIVE','Closed: No Further Updates','6','-73.9811609','NEW YORK 10023','Normal','3-1-1 Call Center','Bird','N/A','2009-10-30 00:00:00','CALLER STATES THAT THE LOCATION IS DIAGONALLY ACROSS FROM 86 RIVERSIDE DRIVE. IN THE MIDDLE OF THE SIDEWALK THAT GOES DOWN THE STAIRS TO THE PARK AREA','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','CALLER STATES THAT THERE IS A BEHEADED BIRD INSIDE THE PARK. CALLER SAYS THAT IT IS BIG BIRD','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK - RIVER RUN PLAYGROUND','114','Park','Body Without Head','Animal in a Park','M071-08','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2009-11-18 00:00:00','2009-11-18 18:35:15','40.5862137','Dead Animal','AVENUE Z AND WEST 1ST STREET','Closed: No Further Updates','47','-73.970355','BROOKLYN 11223','Normal','3-1-1 Call Center','Pigeon & Rooster','N/A','2009-11-18 00:00:00','IN THE PLAYGROUND','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STATES THAT THERE ARE 5 PIGEON AND ROOSTER IN THE PARK WITH NO HEAD. CALLER WOULD LIKE IT TO BE REMOVED INSIDE THE PLAYGROUND TOWARD WHERE THE SWINGS ARE LOCATED AT THE LEFT SIDE.','The condition was determined to be an issue appropriate for handling by an alternate entity. The Department of Parks and Recreation has notified the appropriate resource.','WEST PLAYGROUND','13','Park','Body Without Head','Animal in a Park','B252','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11223','5');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-02-09 00:00:00','2010-02-09 15:14:54','40.8681918','Dead Animal','WEST 155TH AND DYCKMAN STREETS','Closed: No Further Updates','7','-73.9310449','NEW YORK 10039','Normal','Department of Parks and Recreation','Goat & Chicken','N/A','2010-02-08 00:00:00','190th street & Amsterdam','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','PRM D. Mercado rpts there is a goat''s head and a dead chicken found at this location. NYPD is en route. Pics have been taken. M&O will remove it.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','HIGHBRIDGE PARK','12','Park','Goat''s Head, Whole Chicken','Animal in a Park','M037','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10039','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-02-18 00:00:00','2010-02-18 11:16:07','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HARLEM','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','Department of Parks and Recreation','Pigeon','N/A','2010-02-18 00:00:00','Payson Ave & 207 St','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','INWOOD HILL PK (PAYSON AVE & 207 ST)-2/18/2010-1029. As per Sgt. K. Clifford, a decapitated pigeon was found nailed to a tree, located on the right hand side of the staircase. NYPD has been notified. Pics taken.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','INWOOD HILL PARK','12','Park','Head and Body','Animal in a Park','M042','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-03-30 00:00:00','2010-03-30 11:56:10','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HARLEM','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','Department of Parks and Recreation','Cat','N/A','2010-03-28 00:00:00','204 Street & Payson Street','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','Sgt. Clifford rpts decapitated cat found in Inwood Hill Park','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','INWOOD HILL PARK','12','Park','Head and Body','Animal in a Park','M042','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-03-30 00:00:00','2010-03-30 15:51:18','40.6536364','Dead Animal','PERGOLA, LINCOLN ROAD, EAST LAKE DRIVE','Closed: No Further Updates','39','-73.9976433','BROOKLYN 11215','Normal','3-1-1 Call Center','Not specified','N/A','2010-03-28 00:00:00','THE ANIMAL IS COUPLE BLOCKS SOUTH FROM LINCOLN ROAD. IT IS RIGHT UNDER A HUGE TREE THAT FELL AND WAS CHOPPED UP BY PARKS WORKERS. IT ALSO CLOSE TO WOLLMAN''S RINK AND A KID''S PLAYGROUND (IMAGINATION PLAYGROUND) ABOUT 100 FEET.','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STATES THAT THERE IS A DEAD ANIMAL IN THE PARK. IT IS A LARGE ANIMAL. THE ANIMAL IS MISSING A HEAD. IT HAS WHITISH FUR. IT IS COVERED PARTIALLY BY TREE BRANCHES.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PROSPECT PARK - OCEAN AVENUE','19','Park','Body Without Head','Animal in a Park','B073','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11215','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-04-08 00:00:00','2010-04-07 23:59:37','40.7473524','Dead Animal','','Closed: No Further Updates','20','-73.820586','FLUSHING 11355','Normal','3-1-1 Call Center','Not specified','N/A','2010-04-07 00:00:00','WALK FROM COLDEN ST LEADING TOWARDS MAINT ST NEXT TO DEPRESSION WATER. THERE IS A BASEBALL COURT IN RIGHT SIDE, BASKETBALL FIELD IN THE LEFT SIDE.','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','CLR STATES THAT THERE ARE THREE (3) DISCARDED ANIMAL HEADS IN THE PARK','The Service Request submitted did not have sufficient location or complaint information for the agency to respond.','KISSENA CORRIDOR PARK','','Park','Not specified','Animal in a Park','','Animal in a Park','QUEENS','Dead Animal','FLUSHING','11355','3');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-04-16 00:00:00','2010-04-16 17:01:27','40.7769059','Dead Animal','RIVERSIDE DRIVE TO HUDSON RIVER, WEST','Closed: No Further Updates','6','-73.9800645','NEW YORK 10023','Normal','3-1-1 Call Center','Bird','N/A','2010-04-11 00:00:00','ON STONE WALL BTWN 72ND ST & 73RD ST','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','TWO LARGE WHITE BIRDS W/ HEADS CHOPPED OFF','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','RIVERSIDE PARK','14','Park','Head and Body','Animal in a Park','M071','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10023','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-06-24 00:00:00','2010-06-24 16:57:56','40.6962594','Dead Animal','MYRTLE AVENUE, CUMBERLAND STREET','Closed: No Further Updates','35','-73.9744475','BROOKLYN 11201','Normal','Department of Parks and Recreation','Chicken','N/A','2010-06-24 00:00:00','20 FROM VISITOR CENTER','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','BK-FORT GREENE PK (20 FT FROM VISITORS CENTER)-6/24/2010-1612: UPR A. Marsala rpts the carcass of four decapitated chickens were found at this location. The rangers disposed of the remains.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FORT GREENE PARK','2','Park','Head and Body','Animal in a Park','B032','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11201','4');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2010-06-30 00:00:00','2010-06-30 12:52:05','40.6974069','Dead Animal','MYRTLE AVENUE, UNION TURNPIKE, PARK LANE','Closed: No Further Updates','30','-73.8538296','RIDGEWOOD 11385','Normal','Department of Parks and Recreation','Pigeon','N/A','2010-06-30 00:00:00','FOREST PK DRIVE & OAK RIDGE','Closed','Department of Parks and Recreation','DPR General Intake','CSA Ranger Sarah Hackney rpts that two decapitated pigeons were discovered at the above site Pigeons were disposed by M&O Pictures were taken. Rpt bled. RIZ','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FOREST PARK','16','Park','Head and Body','Animal in a Park','Q015','Animal in a Park','QUEENS','Dead Animal','RIDGEWOOD','11385','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2011-02-09 00:00:00','2011-02-09 11:20:01','40.6962594','Dead Animal','MYRTLE AVENUE, CUMBERLAND STREET','Closed: No Further Updates','35','-73.9744475','BROOKLYN 11201','Normal','3-1-1 Call Center','Chicken','N/A','2011-02-07 00:00:00','INSIDE THE FENCED AREA, IN FRONT OF THE TENIS COURT ACROSS FROM THE SOUTH PORTLAND AND DEKALB ENTRANCE.','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','DEAD HEADLESS CHICKEN INSIDE A BROWN GROCERY STORE PLASTIC BAG.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FORT GREENE PARK','2','Park','Body Without Head','Animal in a Park','B032','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11201','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2011-03-15 00:00:00','2011-03-15 09:16:28','40.8262186','Dead Animal','WESTCHESTER COURT, SCHLEY AND EMERSON','Closed: No Further Updates','18','-73.8242621','BRONX 10465','Normal','3-1-1 Call Center','Chicken','N/A','2011-03-10 00:00:00','on the north section of the park along the water front','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER STATES THAT THERE IS A HINDU POPULATION WHERE THE SET UP BLACK AND WHITE FLAGS LEAVING A YELLOW CLOTH THEIR SCARIFIED ANIMAL SUCH AS GOAT LEAVING JUST THE HEADS AND THROWING THE BODIES INTO TO WATER FRONT. FOUR BODIES DEAD CHICKENS, HEAD MISSING, THIS CEREMONY IS HELD ON FEBRUARY 25. AFTER THE CEREMONY EVERYTHING IS LEFT AT THE LOCATION.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FERRY POINT PARK','10','Park','Body Without Head','Animal in a Park','X126','Animal in a Park','BRONX','Dead Animal','BRONX','10465','4');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2011-04-26 00:00:00','2011-04-26 13:50:55','40.825069','Dead Animal','','Closed: No Further Updates','13','-73.815498','BRONX 10465','Normal','3-1-1 Call Center','Birds (Eagle, Hawk, Pigeon)','N/A','2011-04-25 00:00:00','VETERANS MEMORIAL PARK THE BIRDS ARE RIGHT BEFORE THE BASEBALL DIAMOND','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','CALLER SAYS THAT THERE WAS SOME RITUAL IN A PARK WHERE A LOT OF BIRDS WAS DECAPITATED. THERE ARE AT LEAST 10 BIRDS SOME OF THE BIRDS LOOKED LIKE AN EAGLE, AN HAWK AND PIGEONS','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','VETERAN''S MEMORIAL PARK','','Park','Not specified','Animal in a Park','','Animal in a Park','BRONX','Dead Animal','BRONX','10465','10');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2011-10-04 00:00:00','2011-10-04 13:06:35','40.6751451','Dead Animal','PLAZA STREET EAST, PLAZA STREET WEST','Closed: No Further Updates','39','-73.9693182','BROOKLYN 11215','Normal','3-1-1 Call Center','Goat','N/A','2011-10-04 00:00:00','ANIMAL IS LOCATED NORTHEND OF THE PARK AT GRAND ARMY PLAZA ON THE EAST PATHWAY','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','DEAD GOAT IN THE PATH OF PROSPECT PARK, RESIDENT CLAIMS THERE IS A DECAPITATED HEAD OF THE ANIMAL LYING IN THE PATHWAY OF THE PARK.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PROSPECT PARK - GRAND ARMY PLAZA','19','Park','Head','Animal in a Park','B073','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11215','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2012-02-21 00:00:00','2012-02-21 11:35:50','40.6560436','Dead Animal','41ST TO 44TH STREETS, 5TH TO 7TH AVENUES','Closed: No Further Updates','38','-74.0079781','BROOKLYN 11232','Normal','3-1-1 Call Center','Dog','N/A','2012-02-20 00:00:00','BY GREENERY/TREES NEXT TO NEW CONSTRUCTION SITE - BUILDING','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','CALLER STATES THAT SHE IS BROOKLYN RESIDENT WHO OFTEN WALKS HER DOG AROUND NEARBY PARK VICINITY APPROX 10:30 AM AND DISCOVERED A SEVERED DOGS HEAD ON SW CORNER-44 ST BET 5-6 AVE BY A ROW OF TREES BY THE CONSTRUCTION SITE. THE HEAD WAS SMALL DOG HAD GOLDEN BROWN FUR AND WAS RELATIVELY SMALL IN SIZE. THERE WAS DRIED UP BLOOD AT AREA. (THERE WAS BLUNT SEPARATION AT BASE OF JAW). CALLER FOUND DEPT OF PARKS EMPLOYEES AND NOTIFIED OF DISCOVERY THERE WERE NO OTHER PEDESTRIANS AROUND AND PARK HAD PEOPLE ENJOYING THE WEATHER.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','SUNSET PARK','7','Park','Head','Animal in a Park','B087','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11232','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2012-04-28 00:00:00','2012-04-28 14:45:11','40.7349144','Dead Animal','LITTLE NECK BAY TO SPRING BOULEVARD','Closed: No Further Updates','23','-73.7213063','BELLEROSE 11426','Normal','3-1-1 Call Center','Chicken','N/A','2012-04-28 00:00:00','THE TRAIL IS PAST THE WEATHER STATION ON THE LEFT SIDE BEFORE THE ADVENTURE COURSE','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','ABOUT 10 HEADLESS CHICKENS LEFT ON THE TRAIL','','ALLEY POND PARK','13','Park','Body Without Head','Animal in a Park','Q001','Animal in a Park','QUEENS','Dead Animal','BELLEROSE','11426','10');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2012-04-30 00:00:00','2012-04-30 09:17:24','40.7349144','Dead Animal','LITTLE NECK BAY TO SPRING BOULEVARD','Closed: No Further Updates','23','-73.7213063','BELLEROSE 11426','Normal','3-1-1 Call Center','Chicken','N/A','2012-04-29 00:00:00','ABOUT 100-150 FT INTO THE PARK. AT 69-82 230TH STREET QUEENS, OAKLAND GARDEN 11364','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','12 BEHEADED CHICKENS IN THE PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','ALLEY POND PARK','13','Park','Body Without Head','Animal in a Park','Q001','Animal in a Park','QUEENS','Dead Animal','BELLEROSE','11426','12');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2013-01-31 00:00:00','2013-01-31 15:11:26','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HARLEM','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','','Roosters','N/A','2013-01-30 00:00:00','Dead animals are just off the embankment of the path leading into the park from Payson Avenue, the entrance closes to Dyckman. Animals are located where the rock wall is missing as the path curves up the hill into the woods.','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','2 headless roosters','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','INWOOD HILL PARK','12','Park','Body Without Head','Animal in a Park','MO42','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','2');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2015-02-16 00:00:00','2013-12-16 11:57:18','40.8655743','Dead Animal','BROADWAY AND DYCKMAN STREET','Closed: No Further Updates','7','-73.9272707','NEW YORK 10033','Normal','3-1-1 Call Center','Goat','N/A','2013-02-07 00:00:00','BROADWAY AND DYCKMAN STREET. If you are on the path heading around the (museum) cloistures, heading North on the left side of the museum at the point where the path forks, (left or right) it is located in the V of the fork. ','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','Caller states that as she was walking her dog in the park, she spotted what appears to be a goat head.  If you are on the path heading around the (museum) cloistures, heading North on the left side of the museum at the point where the path forks, (left or right) it is located in the V of the fork.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','FORT TRYON PARK-ANNE LOFTUS','112','Park','Head','Animal in a Park','M029-02','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10033','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2013-03-25 00:00:00','2013-03-05 16:28:37','40.8567322','Dead Animal','FORT GEORGE AND SAINT NICHOLAS AVENUES','Closed: No Further Updates','7','-73.9283922','NEW YORK 10039','Normal','3-1-1 Call Center','Goat','N/A','2013-03-20 00:00:00','BEHIND THE FENCE BY CHILDREN''S SWING, NEAR THE TRAIL','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','THERE IS A DEAD GOAT IN PARK. THE HEAD IS HANGING FROM A TREE AND THE BODY IS ON THE GROUND IN THE SNOW.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','HIGHBRIDGE PARK - FORT GEORGE','112A','Park','Head and Body','Animal in a Park','M037-09','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10039','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2013-09-30 00:00:00','2013-09-30 16:24:26','40.6734667','Dead Animal','WEST DRIVE OPPOSITE GARFIELD PLACE','Closed: No Further Updates','39','-73.9794251','BROOKLYN 11215','Normal','3-1-1 Call Center','Goat','N/A','2013-09-28 00:00:00','AT THE GARFIELD STREET AND PROSPECT PARK WEST ENTRANCE','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','ITS A GOAT HEAD IN A BOWL WITH FEATHERS AROUND AT THE ENTRANCE OF THIS PARK','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PROSPECT PARK - GARFIELD TOT LOT','319','Park','Head','Animal in a Park','B073-02D','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11215','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-01-10 00:00:00','2014-01-10 10:17:03','40.8567322','Dead Animal','FORT GEORGE AND SAINT NICHOLAS AVENUES','Closed: No Further Updates','7','-73.9283922','NEW YORK 10039','Normal','3-1-1 Call Center','Goat (Unsure)','N/A','2014-01-02 00:00:00','ABOUT 100 FEET WITHIN THE ENTRANCE','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','THERE IS A DEAD ANIMAL (MAYBE A GOAT) THAT WAS BEHEADED AND THE HEAD OF THE ANIMAL IS PINNED UP ON ONE OF THE TREES ABOUT 100 FEET INSIDE OF THE CHILDREN''S PLAYGROUND. THE BODY OF THE ANIMAL IS WRAPPED IN A RED SHEET AND ON THE GROUND.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','HIGHBRIDGE PARK - FORT GEORGE','112A','Park','Head and Body','Animal in a Park','M037-09','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10039','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-01-13 00:00:00','2014-01-13 14:33:03','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HARLEM','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','Department of Parks and Recreation','Chicken','N/A','2014-01-13 00:00:00','Isham and Seaman Aves','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','MN-INWOOD HILL PK (ISHAM & SEAMAN AVES)-1/13/2014-1311 UPR J. Siegler rpts three decapitated chickens were found inside of a box adjacent to the flagpole inside of the park. Parks report filed. MDR.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','INWOOD HILL PARK','12','Park','Head and Body','Animal in a Park','M042','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','3');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-04-25 00:00:00','2014-04-25 17:50:56','40.6066332','Dead Animal','FLATBUSH, GERRITSE AND FILLMORE','Closed: No Further Updates','46','-73.9404963','BROOKLYN 11235','Normal','Department of Parks and Recreation','Goose','N/A','2014-04-25 00:00:00','off the main path','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','decapitated goose','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','MARINE PARK','18','Park','Head and Body','Animal in a Park','B057','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11235','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-06-09 00:00:00','2014-06-09 12:02:15','40.6653604','Dead Animal','','Closed: No Further Updates','35','-73.9653575','BROOKLYN 11238','Normal','3-1-1 Call Center','Duck','N/A','2014-06-06 00:00:00','TO ENTER THE PARK, GO TO CLASSON AVENUE ENTRANCE, WHICH IS APPROX. 50 FT SOUTH OF EASTERN PARKWAY AND THE INTERSECTION.','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','PERSONS HAVE FOUND 1 DUCK, AND 2 DOVES, DEAD IN THE PARK, DECAPITATED, IN POSSIBLY SOME SORT OF RITUAL, DUE TO PLACING OF THE DUCK/DOVES IN A CERTAIN WAY. THE BODIES ARE FORMING A RING, AND THE HEADS ARE VERY CLOSE TO THIS RING. THE ITEMS ARE BEHIND A BENCH, RIGHT BEHIND A WALK PATH, APPROX. 10-15 FT FROM A STATUE FOR DR. RONALD MCNAIR. PARK MAY BE CALLED "DR. RONALD MCNAIR PARK"','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PROSPECT PARK','','Park','Head and Body','Animal in a Park','','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11238','3');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-06-27 00:00:00','2014-06-27 14:42:44','40.8138912','Dead Animal','SAINT NICHOLAS AVENUE TO SAINT NICHOLAS','Closed: No Further Updates','7','-73.9624327','NEW YORK 10027','Normal','3-1-1 Call Center','Not specified','N/A','2014-06-27 00:00:00','ON THE UPPER PATHWAY GOING UP NORTH ON THE RIGHT HAND SIDE SITTING BETWEEN 136 AND 138 STREETS','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','THERE IS A DEAD ANIMAL''S HEAD ON A STICK ON THE GROUND','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','ST NICHOLAS PARK','9','Park','Head','Animal in a Park','M077','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10027','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-07-10 00:00:00','2014-07-10 08:20:09','40.8615','Dead Animal','','Closed: No Further Updates','13','-73.7972','BRONX 10464','Normal','3-1-1 Call Center','Pig','N/A','2014-07-08 00:00:00','BEHIND THE BASKET BALL COURT','Closed','Borough Maintenance Operations Office - Bronx','DPR General Intake','THERE IS A PIG''S HEAD AT THIS LOCATION. THE HEAD IS IN BETWEEN THE ROCKS, ON THE BEACH KILROE BEACH.','The Department of Parks and Recreation has inspected the situation in question and determined that the issue is out of its jurisdiction.','PELHAM BAY PARK','','Park','Head','Animal in a Park','','Animal in a Park','BRONX','Dead Animal','BRONX','10464','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-07-10 00:00:00','2014-07-10 14:06:06','40.8721452','Dead Animal','DYCKMAN STREET, HUDSON RIVER, HUDSON','Closed: No Further Updates','7','-73.9212858','NEW YORK 10034','Normal','Department of Parks and Recreation','Goat','N/A','2014-07-10 00:00:00','DYKMAN FIELDS','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','MN GAP-INWOOD HILL PK (DYKMAN FIELDS)-7/10/14-1330, PS Dennis Shea reports that a headless goat was found at the location. Pictures were taken, and a report will be lifted with 34 pct. RS','The condition was determined to be an emergency issue and NYPD was notified.','INWOOD HILL PARK - DYCKMAN FIELDS','12','Park','Body Without Head','Animal in a Park','M042','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10034','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-08-19 00:00:00','2014-08-19 11:02:20','40.7336111','Dead Animal','','Closed: No Further Updates','2','-73.984','NEW YORK 10003','Normal','3-1-1 Call Center','Bird','N/A','2014-08-16 00:00:00','IT''S ON THE EAST SIDE OF 2ND AVENUE BETWEEN 15TH AND 16TH STREET','Closed','Borough Maintenance Operations Office - Manhattan','DPR General Intake','THERE''S A SMALL DEAD BIRD UNDER THE BENCH. ITS IN THE PUBLIC DOG RUN.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','STUYVESANT SQUARE','','Park','Whole body','Animal in a Park','','Animal in a Park','MANHATTAN','Dead Animal','NEW YORK','10003','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-10-02 00:00:00','2014-10-02 13:06:07','40.5753217','Dead Animal','BRIGHTON 2ND STREET AND BOARDWALK','Closed: No Further Updates','47','-73.9566791','BROOKLYN 11235','Normal','3-1-1 Call Center','Cow','N/A','2014-09-28 00:00:00','ON CONEY ISLAND AVENUE BY THE ROCKS','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','THERE IS A DEAD BABY COW''S HEAD ON THE ROCKS OF THE BEACH AS WELL AS INTESTINES A FEW FEET AWAY.','Upon inspection the reported condition was not found, and, therefore, no action was taken.','BRIGHTON BEACH','13','Park','Head & Intestines','Animal in a Park','B169A','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11235','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-10-15 00:00:00','2014-10-15 12:00:22','40.7939354','Dead Animal','','Closed: No Further Updates','19','-73.842644','COLLEGE POINT 11356','Normal','3-1-1 Call Center','Goat','N/A','2014-10-12 00:00:00','NEAR THE WEEDS IN THE PARK','Closed','Borough Maintenance Operations Office - Queens','DPR General Intake','DEAD GOAT IN THE PARK WITH ITS HEAD CUT OFF. I WAS WALKING MY DOG AND NOTICE IT THIS MORNING.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','POWELL PARK','','Park','Head and Body','Animal in a Park','','Animal in a Park','QUEENS','Dead Animal','COLLEGE POINT','11356','1');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('0000-00-00 00:00:00','0000-00-00 00:00:00','40.7787902','Dead Animal','ASTORIA PARK SOUTH, 21ST STREET, HOYT','Past Due','22','-73.9065883','ASTORIA 11105','Normal','3-1-1 Call Center','Squirrels','N/A','2014-12-07 00:00:00','ON THE BASE OF 23 AVENUE BUT ITS ALL OVER THE PARK.','Assigned','Borough Maintenance Operations Office - Queens','DPR General Intake','I''VE SEEN AS MUCH AS SEVEN DEAD SQUIRRELS DEAD IN THE PARK. I''VE SEEN ONE THAT WAS DECAPITATED.','','ASTORIA PARK','1','Park','6 Whole body & 1 Decapitated','Animal in a Park','Q004','Animal in a Park','QUEENS','Dead Animal','ASTORIA','11105','7');
INSERT INTO incidents(date_closed,resolution_action_updated,lat,descriptor_confirmed,site_street_address,time_to_action,council_district_number,lng,site_city_zip,priority,source,animal,descriptor_2,date_started,additional_location_details,status,division,form,complaint_details,resolution_description,park_or_facility,park_district,location_type,body_part_found,complaint_type_confirmed,property_number,complaint_type,site_borough,descriptor_1,site_city,zip_code,quantity) VALUES ('2014-12-08 00:00:00','2014-12-08 16:43:50','40.6508437','Dead Animal','PROSPECT PARK WEST, FLATBUSH, PARKSIDE','Closed: No Further Updates','39','-73.9686143','BROOKLYN 11215','Normal','3-1-1 Call Center','Goat','N/A','2014-12-07 00:00:00','NEAR THE ENTRANCE OF GRAND ARMY AND KEEP LEFT, PASS THE ARCH AND GO UP THE HILL, RIGHT BEFORE THE RIDGE PATH CONNECTS WITH THE PAVED PATH.','Closed','Borough Maintenance Operations Office - Brooklyn','DPR General Intake','HEAD OF A GOAT. I HAVE A PHOTO OF THE DEAD ANIMAL.','The Department of Parks and Recreation has completed the requested work order and corrected the problem.','PROSPECT PARK','19','Park','Head','Animal in a Park','B073','Animal in a Park','BROOKLYN','Dead Animal','BROOKLYN','11215','1');
