From a 227-row sample across 17 columns.
closuretype:@computed_region_92fq_4b7qborough+9closuretypeborougheditdate+3closuretypeborougheditdate+3Mappable — Socrata point column `point`.
Open on the map →| borough | closuretype | editdate | featuretype | propid | propname | propnum | sitename | status | point | approx_date_closed | approx_date_reopened |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Q | Temporary Fencing | 2020-06-21T11:39:52.000 | Exercise Equipment | Q134 | Breininger Park | Q134 | Breininger Park | Reopened | 40.72583, -73.72897 | 2020-04-11T19:06:52.000 | 2020-06-21T11:39:50.000 |
| B |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | Borough in which the equipment is located. | 0% | BQXof 5 |
closuretype | categorical | Indicates the type of closure | 28% | Completely LockedTemporary FencingBlocked with Barricadeof 5 |
editdate | datetime | Last edited date | 0% | 2020-04-09T15:15:34.0002020-04-09T15:24:38.0002020-04-09T15:20:54.000 |
featuretype | text | Type of feature. | 0% | Exercise Equipment |
GET /api/datasets/tkzt-zfpz GET /api/datasets/tkzt-zfpz/quality GET /api/datasets/tkzt-zfpz/related GET /api/columns?dataset=tkzt-zfpz
closuretypeborougheditdateclosuretypeborougheditdate+3:@computed_region_92fq_4b7qborough:@computed_region_f5dn_yrer+3borough| Completely Locked |
| 2020-06-22T14:12:49.000 |
| Exercise Equipment |
| B298 |
| Stockton Playground |
| B298 |
| Stockton Playground |
| Reopened |
| 40.69728, -73.94867 |
| 2020-04-10T12:27:53.000 |
| 2020-06-22T00:00:00.000 |
| Q | Completely Locked | 2020-06-23T11:10:39.000 | Exercise Equipment | Q001-ZN01 | Alley Pond Park | Q001 | Alley Pond Park Zone 1 | Reopened | 40.73949, -73.73627 | 2020-04-11T19:14:22.000 | 2020-06-23T11:10:37.000 |
| X | Temporary Fencing | 2020-06-22T10:33:37.000 | Exercise Equipment | X137 | Jerome Park | X137 | Jerome Park | Reopened | 40.87865, -73.89197 | 2020-04-13T12:01:05.000 | 2020-06-21T00:00:00.000 |
| Q | Partially Locked | 2020-06-23T09:25:50.000 | Exercise Equipment | Q026 | Park Of The Americas | Q026 | Park Of The Americas | Reopened | 40.74857, -73.86192 | 2020-04-13T09:15:26.000 | 2020-06-23T09:25:48.000 |
| B | Completely Locked | 2020-06-22T11:24:26.000 | Exercise Equipment | B141 | City Line Park | B141 | City Line Park | Reopened | 40.67948, -73.87492 | 2020-05-21T13:03:15.000 | 2020-06-20T00:00:00.000 |
| M | Completely Locked | 2020-06-22T17:21:11.000 | Exercise Equipment | M079 | St. Catherine's Park | M079 | St. Catherine's Park | Reopened | 40.76519, -73.95872 | 2020-04-10T11:53:33.000 | 2020-06-21T00:00:00.000 |
| X | Completely Locked | 2020-06-22T10:05:38.000 | Exercise Equipment | X206 | Morgan Playground | X206 | Morgan Playground | Reopened | 40.83227, -73.90744 | 2020-04-10T08:42:35.000 | 2020-06-21T00:00:00.000 |
| X | — | 2020-04-09T15:24:38.000 | Exercise Equipment | X118-ZN03 | Soundview Park | X118 | Soundview Park Zone 3 | Active | 40.81829, -73.87305 | — | — |
| M | — | 2020-04-13T13:10:34.000 | Exercise Equipment | M047 | Thomas Jefferson Park | M047 | Thomas Jefferson Park | Active | 40.79320, -73.93559 | — | — |
Showing 12 of 17 columns. All of them are listed below.
propid | 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% | M238Q134Q162J01 |
propname | text | The name of the property the equipment is within | 0% | Bronx ParkSt. Mary's ParkRiverside Park |
propnum | text | Unique identification number for the property the equipment is within | 0% | X002M071Q005 |
sitename | text | The name of the subproperty the equipment is within | 0% | Belmont PlaygroundAileen Ryan Rec. ComplexInwood Hill Park Zone 4 … |
status | categorical | Indicates whether the adult exercise equipment is still active and open to the public, has been closed to observe COVID-19 social distancing, has been reopened following COVID-19 closure, or is under construction. | 0% | ReopenedActiveUnderConstructionof 3 |
point | coordinate | Location (POINT) of adult equipment | 0% | {'coordinates': [-73.904…{'coordinates': [-74.164…{'coordinates': [-73.729… |
approx_date_closed | datetime | Approximate date Adult Exercise Equipment closed because of Covid | 28% | 2020-04-09T15:20:54.0002020-04-09T15:22:59.0002020-04-10T16:58:34.000 |
approx_date_reopened | datetime | Date Adult Exercise Equipment reopened from Covid closure | 31% | 2020-06-21T00:00:00.0002020-06-22T00:00:00.0002020-06-20T00:00:00.000 |