From a 50-row sample across 23 columns.
boroughlocationomppropid+1borough:@computed_region_92fq_4b7q:@computed_region_efsh_h5xi+3:@computed_region_92fq_4b7q:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+2locationMappable — Socrata point column `point`.
Open on the map →| kioskid | system | borough | parkdistrict | gispropnum | omppropid | propertyname | subpropertyname | location | model | submodel | containersize |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | X047-NK-0009 | Bronx | X-04 | X047 | X047-ZN01 | Franz Sigel Park | Franz Sigel Park Zone 1 | Grand Concourse and E 158 St | Indoor Wall Mount | Bathroom | 1.5 gallon |
| 46 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
kioskid | integer | The identification number assigned to a kiosk | 0% | 861580 |
system | text | The identification number assigned to a kiosk in Parks GIS | 0% | M037-NK-0076X008-NK-0004X217-NK-0011 |
borough | categorical | Borough in which a kiosk is located | 0% | BronxManhattanof 2 |
parkdistrict | categorical | The name of the Park Maintenance District in which the property is located. | 0% | X-01X-05X-04of 9 |
GET /api/datasets/r465-fr2q GET /api/datasets/r465-fr2q/quality GET /api/datasets/r465-fr2q/related GET /api/columns?dataset=r465-fr2q
:@computed_region_92fq_4b7q:@computed_region_efsh_h5xipropertynameboroughomppropid+10:@computed_region_92fq_4b7q:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+2:@computed_region_92fq_4b7q:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+2:@computed_region_92fq_4b7q:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+2| X001A-NK-0046 |
| Bronx |
| X-05 |
| X001A |
| X001A |
| Aqueduct Walk |
| Aqueduct Walk |
| At E 184 St in gulch west of walkway |
| Outdoor Post Mount |
| Mailbox/post |
| 2 gallon |
| 80 | M058-NK-0080 | Manhattan | M-11 | M058 | M058-ZN01 | Marcus Garvey Park | Marcus Garvey Park Zone 1 | South side of amphitheater | Stainless Steel | Outdoor Wall Mount | 2 gallon |
| 49 | X045-NK-0049 | Bronx | X-01 | X045 | X045 | St. Mary's Park | St. Mary's Park | Parking lot of M&O building at E 149th St and St Ann's Ave | Outdoor Post Mount | Mailbox/post | 2 gallon |
| 75 | M037-NK-0075 | Manhattan | M-12A | M037 | M037-ZN07 | Highbridge Park | Highbridge Park Zone 7 | E 181 St and Amsterdam Ave | Stainless Steel | Post Mount | 2 gallon |
| 87 | X010A-NK-0087 | Bronx | X-06 | X010A | X010A | Walter Gladwin Park | Walter Gladwin Park | South of wall on hillside | Stainless steel | Post mount | 2 gallon |
| 78 | M037-NK-0078 | Manhattan | M-12A | M037 | M037-ZN07 | Highbridge Park | Highbridge Park Zone 7 | E 181 St and Amsterdam Ave | Stainless steel | Post mount | 2 gallon |
| 66 | M058-NK-0066 | Manhattan | M-11 | M058 | M058-ZN01 | Marcus Garvey Park | Marcus Garvey Park Zone 1 | North side of amphitheater on railing next to structure door | Stainless Steel | Wall mount | 2 gallon |
| 28 | X155-NK-0028 | Bronx | X-01 | X155 | X155 | Patterson Playground | Patterson Playground | Morris Ave and E 145 St | Outdoor Post Mount | Mailbox/post | 2 gallon |
| 23 | X010-NK-0023 | Bronx | X-03 | X010 | X010-12 | Crotona Park | Crotona Park-Bathgate Playground | Crotona Bathgate Plgd, Fulton Ave. & E 173 St. | Indoor Wall Mount | Bathroom | 1.5 gallon |
Showing 12 of 23 columns. All of them are listed below.
gispropnum | categorical | Unique identification number for each park property, identified by borough/county (B = Brooklyn; M = Manhattan; Q = Queens; R = Richmond (Staten Island); X = Bronx), and followed by a number | 0% | X045X010AX017of 16 |
omppropid | text | Unique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the GIS Property Number. In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added. | 0% | M037-ZN07X200X010A |
propertyname | categorical | The name of the larger Parks property in which the kiosk is located | 0% | St. Mary's ParkWalter Gladwin ParkHighbridge Parkof 17 |
subpropertyname | text | The name of the smaller zone or site within a larger Parks property in which the kiosk is located | 0% | Highbridge Park Zone 7St. Mary's ParkWalter Gladwin Park |
location | text | Describes the approximate location of the kiosk using cross streets and park features as landmarks | 0% | E 181 St and Amsterdam A…E Tremont Ave and E Burn…E Tremont Ave and Arthur… |
model | categorical | Describes the type of kiosk installation, whether the kiosk is indoors or outdoors, or mounted on a wall or mounted on a post. | 0% | Outdoor Post MountIndoor Wall MountStainless Steelof 6 |
submodel | categorical | Describes the type of kiosk installation as a general category, such as mailbox or a bathroom sharps container | 0% | Mailbox/postBathroomPost mountof 8 |
containersize | categorical | The size of the kiosk container in gallons | 0% | 2 gallon1.5 gallonof 2 |
status | categorical | Indicates the status of the kiosk as active, or in use, or removed, and not in use | 2% | RemovedActiveof 2 |
installationdate | datetime | The date the kisok was installed at its current location | 0% | 2018-06-02T04:00:00.0002018-08-19T04:00:00.0002018-09-01T04:00:00.000of 17 |
remove_date | datetime | The date the kiosk was removed from service | 50% | 2019-06-15T04:00:00.0002019-07-01T04:00:00.0002023-01-01T20:31:52.000 |
removal_reason | categorical | Describes the reason the kiosk was removed | 48% | ConstructionLow usageVandalismof 8 |
status_change_date | datetime | The date the status was changed | 52% | 2024-07-10T21:03:36.0002024-09-19T15:06:52.0002024-07-10T21:02:04.000 |
point | coordinate | — | 0% | {'coordinates': [-73.898…{'coordinates': [-73.944…{'coordinates': [-73.913… |