From a 500-row sample across 16 columns.
point:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+3longitudelatitudeobjectid+7objectidpoint:@computed_region_f5dn_yrer+4Mappable — Socrata point column `point`.
Open on the map →| basketid | baskettype | objectid | latitude | longitude | point | :@computed_region_92fq_4b7q | :@computed_region_sbqj_enih | :@computed_region_efsh_h5xi | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q |
|---|---|---|---|---|---|---|---|---|---|---|
| 21110129 | DSNY Wire | 31755 | 40.85617872 | -73.87001015 | 40.85618, -73.87001 | 22 | 32 | 11271 | 28 | 5 |
| 20810051 | Parks Basket |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
basketid | text | Unique ID given to each basket location | 0% | 107501663033004331440059 |
baskettype | text | Owner and physical type of basket. Adopted Better Bin, Adopted Compactor, Adopted High-end, Adopted PSR, Adopted Wire, BID-owned Compactor, BID-owned High-end, BID-owned PSR, Citi Bin, CM Better Bin, CM High-end, CM PSR, DSNY Better Bin, DSNY Compactor, DSNY High-end, DSNY PSR, DSNY Seasonal, DSNY Wire, Parks Basket, Private Compactor, Private High-end | 0% | DSNY Better BinDSNY WireDSNY PSR |
direction | categorical | Cardinal or ordinal direction from center of intersection when location is on a street corner; of side of street when location is mid-block. Because of a new survey instrument, new baskets surveyed are not being populated with this information. This issue will be addressed in a later update. | 4% | NWSENEof 8 |
GET /api/datasets/8znf-7b2c GET /api/datasets/8znf-7b2c/quality GET /api/datasets/8znf-7b2c/related GET /api/columns?dataset=8znf-7b2c
longitudelatitudepointlongitudelatitude:@computed_region_f5dn_yrer+5objectid:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+3longitudelatitudeobjectid+6:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_sbqj_enih+2| 31020 |
| 40.88031268 |
| -73.89643433 |
| 40.88031, -73.89643 |
| 40 |
| 33 |
| 11272 |
| 48 |
| 5 |
| 20720149 | Parks Basket | 30893 | 40.86217911 | -73.89044688 | 40.86218, -73.89045 | 22 | 31 | 10936 | 24 | 5 |
| 20430137 | Parks Basket | 30198 | 40.84065214 | -73.90540299 | 40.84065, -73.90540 | 42 | 27 | 10935 | 50 | 5 |
| 20430054 | DSNY Better Bin | 30121 | 40.83907658 | -73.92121577 | 40.83908, -73.92122 | 42 | 27 | 10930 | 50 | 5 |
| 20310223 | Parks Basket | 29876 | 40.8350807 | -73.89597553 | 40.83508, -73.89598 | 43 | 25 | — | 34 | 5 |
| 11220032 | DSNY Wire | 28712 | 40.85220872 | -73.94007847 | 40.85221, -73.94008 | 39 | 22 | 13091 | 47 | 4 |
| 11110228 | Parks Basket | 28193 | 40.78925957 | -73.93870162 | 40.78926, -73.93870 | 35 | 14 | 12426 | 7 | 4 |
| 10910162 | Parks Basket | 27049 | 40.81013189 | -73.95694763 | 40.81013, -73.95695 | 23 | 17 | 12424 | 37 | 4 |
| 10750259 | Parks Basket | 25786 | 40.8008092 | -73.96409102 | 40.80081, -73.96409 | 23 | 15 | 12422 | 20 | 4 |
streetname1 |
| text |
| Street name of widest street at intersection when location is on a street corner; street name of on-street when location is mid-block |
| 5% |
BROADWAY3 AVENUE5 AVENUE |
streetname2 | text | Street name of cross street at intersection when location is on a street corner; null when location is mid-block | 20% | 5 AVENUEBROADWAY3 AVENUE |
objectid | text | Feature Identifier | 0% | 325142936540986 |
latitude | float | Y-coordinate of litter basket location | 0% | 40.8363004440.6885873340.65702297 |
longitude | float | X-coordinate of litter basket location. | 0% | -73.92467305-73.83831696-73.91858591 |
borough | categorical | Borough name of litter basket location. | 4% | MANHATTANBROOKLYNQUEENSof 5 |
district | text | DSNY District location of litter basket. DSNY districts are coterminous with NYC Community Districts. | 4% | MN08MN05MN02 |
point | coordinate | Each point is defined by a single x, y coordinate. | 0% | {'coordinates': [-73.940…{'coordinates': [-73.813…{'coordinates': [-73.940… |