From a 500-row sample across 25 columns.
boroughclosuretypegispropnum+8boroughclosuretypegispropnum+6boroughclosuretypegispropnum+8boroughMappable — Socrata point column `point`.
Open on the map →| borough | closuretype | editdate | gispropnum | omppropid | red_sign_installed | name | approx_date_closed | approx_date_reopened | community_board | district | latitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| B | Completely Locked | 2020-06-22T15:01:03.000 | B385 | B385 | Yes | Transmitter | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 301 | B-01 | 40.729862213134766 |
| M |
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 playground is located. | 0% | BQMof 5 |
closuretype | categorical | Indicates the type of closure | 0% | Completely LockedPartially LockedNot Lockableof 3 |
editdate | datetime | Date last edited | 0% | 2020-06-23T10:01:04.0002020-06-21T16:56:36.0002020-06-22T13:55:05.000 |
gispropnum | text | This is the identification number for the property that contains the playground. | 0% |
GET /api/datasets/a4qt-mpr5 GET /api/datasets/a4qt-mpr5/quality GET /api/datasets/a4qt-mpr5/related GET /api/columns?dataset=a4qt-mpr5
closuretypegispropnumaccessibilitydistrictlatitude+1| Completely Locked |
| 2020-06-23T09:14:23.000 |
| M283 |
| M283-01 |
| — |
| Nelson Rockefeller Park Playground North |
| 2020-03-31T00:00:00.000 |
| 2020-06-22T00:00:00.000 |
| 101 |
| M-01 |
| 40.71808624267578 |
| X | Completely Locked | 2020-06-22T10:26:30.000 | X291 | X291 | Yes | Walton Playground | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 205 | X-05 | 40.855308532714844 |
| X | Completely Locked | 2020-06-22T10:39:31.000 | X019 | X019-01 | — | Ewen Playground | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 208 | X-08 | 40.88312911987305 |
| B | Completely Locked | 2020-06-22T13:55:05.000 | B169 | B169 | Yes | Beach at B 6 St | 2020-03-31T00:00:00.000 | 2020-06-22T00:00:00.000 | 313 | B-13 | 40.57489776611328 |
| Q | Partially Locked | 2020-06-22T13:07:06.000 | Q336 | Q336 | — | Judge Moses Weinstein Playground | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 408 | Q-08 | 40.71866989135742 |
| X | Partially Locked | 2020-06-22T11:10:04.000 | X122 | X122 | — | Colucci Playground | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 210 | X-10 | 40.85223388671875 |
| B | Completely Locked | 2020-06-22T16:15:01.000 | B100 | B100 | — | Seth Low Playground/ Bealin Square | 2020-03-31T00:00:00.000 | 2020-06-20T00:00:00.000 | 311 | B-11 | 40.608543395996094 |
| X | Not Lockable | 2020-06-22T10:52:00.000 | X002 | X002-05A | — | Waring Plgd | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 227 | X-14 | 40.860652923583984 |
| Q | Completely Locked | 2020-06-21T16:56:36.000 | Q313 | Q313 | — | Arverne Playground | 2020-03-31T00:00:00.000 | 2020-06-21T00:00:00.000 | 414 | Q-14 | 40.59288787841797 |
Showing 12 of 25 columns. All of them are listed below.
M010M071X010omppropid | 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% | M056-02X197Q221 |
red_sign_installed | text | Indicates whether a red closed sign was installed | 98% | Yesof 1 |
status | categorical | Indicates whether the playground 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. | 8% | ActiveArchivedof 2 |
accessibility | categorical | If a Children's Play Area (CPA), whether the play units associated with CPA are modified for accessibility to children with special physical needs. | 8% | YesNoof 2 |
accessibilitylevel | categorical | If a Children's Play Area (CPA), level of accessibility, ranging from 1-4. | 8% | Level 4: Accessible Play…Not ApplicableLevel 2: Accessible Play…of 5 |
location | text | Indicates the cross streets of where the playground is located. | 5% | W 117 St & Morningside A…73 Ave. bet. 195 St. and…St. Raymond's Ave. bet. … |
name | text | Indicates Playground Name | 0% | Washington Square ParkPlaygroundFox Playground |
rules | categorical | Rules posted on playground sign | 8% | Adults AllowedAdults not allowed in so…Unknownof 3 |
system | text | Unique identifier for Childrens Play Areas (CPAs). If a System ID exists here, it can be used to join to the CPA dataset; if the field is NULL that row does not correspond to a CPA. Records with NULL System IDs are most likely coming from Parks Properties and can be joined on GISPropNum. | 8% | Q120-CPA-0001X008-CPA-0001X092-CPA-0003 |
approx_date_closed | datetime | Approximate date playground closed because of Covid | 0% | 2020-03-31T00:00:00.000of 1 |
approx_date_reopened | datetime | Date playground reopened from Covid closure | 4% | 2020-06-21T00:00:00.0002020-06-22T00:00:00.0002020-06-23T00:00:00.000of 9 |
community_board | integer | NYC Community Board | 0% | 301407103 |
district | text | Name of the Parks maintenance district that contains the Playground. | 0% | B-01M-03Q-07 |
latitude | float | — | 0% | 40.74118804931640640.77785491943359440.68927764892578 |
longitude | float | — | 0% | -73.95223999023438-73.98899841308594-73.92207336425781 |
point | coordinate | — | 0% | {'coordinates': [-73.988…{'coordinates': [-73.984…{'coordinates': [-73.978… |