From a 189-row sample across 7 columns.
yearyearboroughyearboroughyearHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| year | event_type | event | date | borough | spray_area_neighborhood | zip_codes |
|---|---|---|---|---|---|---|
| 2020 | Adulticiding | 1 | August 12th | SI | Parts of Bull’s Head, Graniteville, Heartland Village, Westerleigh, and Willowbrook | Parts of 10302, 10303, 10310, and 10314 |
| 2020 | Adulticiding | 2 | August 18th | QN | Parts of Forest Hills, Forest Hills Gardens, Forest Park, Glendale, Kew Gardens, Maspeth, Middle Village, Rego Park, Richmond Hill, and Woodhaven | Parts of 11373, 11374, 11375, 11378, 11379, 11385, 11415, 11418, and 11421 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | categorical | Spray event year | 5% | 202120182022of 6 |
event_type | categorical | The type of treatment | 5% | AdulticidingAerial EventsLarvicidingof 3 |
event | integer | Number of the event in the spraying season | 5% | 123 |
date | text | Date(s) when the event occurred | 5% | July 18th & 19thSeptember 5thJuly 26th |
GET /api/datasets/msid-end4 GET /api/datasets/msid-end4/quality GET /api/datasets/msid-end4/related GET /api/columns?dataset=msid-end4
yearyearyearboroughyear| 2020 | Adulticiding | 3 | August 20th | QN | Parts of Fresh Meadows, Glen Oaks, Hollis, Hollis Hill, Holliswood, Jamaica Hills, Little Neck, and Oakland Gardens | Parts of 11004, 11005, 11040, 11362, 11364, 11365, 11366, 11423, 11426, 11427, and 11432 |
| 2020 | Adulticiding | 4 | August 25th | BK | Parts of Bath Beach, Bensonhurst, Dyker Heights, Fort Hamilton, Gravesend, Homecrest, Mapleton, New Utrecht, and Sheepshead Bay | Parts of 11204, 11209, 11214, 11219, 11223, 11228, 11229, and 11235 |
| 2020 | Adulticiding | 5 | August 25th | SI | Parts of Annadale, Eltingville, and Great Kills | Parts of 10308 and 10312 |
| 2020 | Adulticiding | 6 | August 27th | QN | Parts of Auburndale, Bayside, Bay Terrace, Beechhurst, College Point, Douglas Manor, Douglaston, Little Neck, Malba, and White Stone | Parts of 11356, 11357, 11358, 11359, 11360, 11361, 11362, 11363, and 11364 |
| 2020 | Adulticiding | 7 | September 1st | SI | Parts of Arrochar, Dongan Hills, Grant City, Grasmere, Midland Beach, New Dorp, New Dorp Beach, Oakwood, Oakwood Beach, Old Town, and South Beach | Parts of 10304, 10305, and 10306 |
| 2020 | Adulticiding | 8 | September 1st | SI | Parts of Castleton Corners Grymes Hill, Livingston, New Brighton, Port Richmond, Randall Manor, Silver Lake, Stapleton Heights, Tompkinsville, Ward Hill, and West Brighton | Parts of 10301, 10304, 10310, and 10314 |
| 2020 | Adulticiding | 9 | September 3rd | BK | Parts of Borough Park, Greenwood Heights, Gowanus, Kensington, Park Slope, Prospect Heights, Prospect Lefferts Gardens, and Windsor Terrace | Parts of 11204, 11215, 11217, 11218, 11219, 11225, 11232, and 11238 |
| 2020 | Adulticiding | 10 | September 3rd | QN | Parts of Corona, Flushing, Forest Hills, Kew Gardens Hills, Pomonok, QueensBoro Hill, and Rego Park | Parts of 11355, 11367, 11368, 11374, and 11375 |
borough |
| categorical |
| Borough where the treatment event occurs |
| 0% |
QNSIBKof 10 |
spray_area_neighborhood | text | Neighborhoods in the treatment event | 0% | Parts of Abandoned Flush…Parts of Fresh Creek Par…Parts of Pelham Bay Park… |
zip_codes | text | Zip codes included in the treatment event | 0% | Parts of 10464, 10465, a…Parts of 11207, 11229, 1…Parts of 11354, 11355, 1… |