From a 500-row sample across 24 columns.
namesystemgispropnum+13namesystemgispropnum+13namesystemgispropnum+8Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | cemspermittable | closuretype | dimensions | editdate | fieldnumber | gispropnum | name | omppropid | parkdistrict | primarysport | propertyname |
|---|---|---|---|---|---|---|---|---|---|---|---|
| M | true | Fully Locked | Bocce | 2020-08-12T15:05:30.000 | 01 | M038 | Bocce-01 | M038 | M-02 | Bocce | James J Walker Park |
| X | false |
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 athletic facility is located. | 0% | QBMof 5 |
cemspermittable | boolean | Indicates whether the Athoetic Facility is available for permitting through the Citywide Event Management System (CEMS) | 0% | TrueFalseof 2 |
closuretype | categorical | Indicates the type of closure | 20% | Fully LockedTemporary FencingBlocked with Barricadeof 5 |
dimensions | categorical | The dimensions of the Athletic Facility | 0% |
GET /api/datasets/g3xg-qtbc GET /api/datasets/g3xg-qtbc/quality GET /api/datasets/g3xg-qtbc/related GET /api/columns?dataset=g3xg-qtbc
statuseditdateclosuretype+3systemgispropnumstatus+8borough| — |
| Full Court |
| 2020-08-12T15:05:30.000 |
| 01 |
| X088 |
| Basketball-01 |
| X088-ZN02 |
| X-09 |
| Basketball |
| Pugsley Creek Park |
| Q | — | — | Half Court | 2020-08-12T15:05:30.000 | — | Q467 | Basketball-04 | Q467 | Q-14 | Basketball | Broad Channel American Park |
| X | true | Fully Locked | Handball | 2020-08-12T15:05:30.000 | 04 | X030 | Handball-04 | X030-ZN01 | X-04 | Handball | Macombs Dam Park |
| Q | true | Blocked with Barricade | Handball | 2020-08-12T15:05:30.000 | 03 | Q007 | Bayswater Playground-Handball-03 | Q007-01 | Q-14 | Handball | Bayswater Park |
| Q | true | Blocked with Barricade | Handball | 2020-08-12T15:05:30.000 | 04 | Q007 | Bayswater Playground-Handball-04 | Q007-01 | Q-14 | Handball | Bayswater Park |
| M | true | Fully Locked | Handball | 2020-08-12T15:05:30.000 | 01 | M037 | Sunken Plgd-Handball-01 | M037-01 | M-12A | Handball | Highbridge Park |
| M | true | Fully Locked | Handball | 2020-08-12T15:05:30.000 | 03 | M037 | Sunken Plgd-Handball-03 | M037-01 | M-12A | Handball | Highbridge Park |
| M | true | Fully Locked | Handball | 2020-08-12T15:05:30.000 | 03 | M105 | Grand St-Handball-03 | M105-08 | M-03 | Handball | Sara D. Roosevelt Park |
| M | true | Fully Locked | Handball | 2020-08-12T15:05:30.000 | 04 | M105 | Grand St-Handball-04 | M105-08 | M-03 | Handball | Sara D. Roosevelt Park |
Showing 12 of 24 columns. All of them are listed below.
HandballFull CourtTenniseditdate | datetime | Last edited date | 0% | 2020-08-12T15:05:30.0002020-08-13T12:02:54.0002020-08-13T11:54:22.000of 8 |
fieldnumber | text | The number of the athletic facility, if a field has a physical sign with a number on it, this is that number, but not all fields have physical signs | 0% | 010203 |
gispropnum | text | Unique identification number for the property the Athletic Facility is within | 0% | B057M104M010 |
name | text | The name of the Athletic Facility | 0% | Basketball-01Handball-01Handball-02 |
nets_rims_goals_removed | boolean | Indicates whether the nets, rims, or goals were removed from the facility | 51% | TrueFalseof 2 |
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% | X039-ZN17M104-ZN02Q020-ZN04 |
parkdistrict | text | Name of the Parks maintenance district that contains the Athletic Facility. | 0% | Q-12B-18M-11 |
primarysport | categorical | The main usage sport for the athletic facility, the sport it was designed or is maintained for | 0% | HandballBasketballTennisof 15 |
propertyname | text | The name of the property the Athletic Facility is within | 0% | Marine ParkRandall's Island ParkCentral Park |
red_sign_installed | boolean | Indicates whether a red closed sign was installed | 29% | TrueFalseof 2 |
status | categorical | Indicates whether the athletic facility 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 4 |
subpropertyname | text | The Name of the subproperty (Zone or Playground) that the feature falls within | 66% | Twenty-Six Courts & Bath…Sunken MeadowDyker Beach Park Zone 1 |
surfacetype | categorical | The playing surface of the Athletic Facility | 0% | AsphaltNaturalSyntheticof 9 |
system | text | Internal unique identifier for the Athletic Facility | 0% | B313-BASKETBALL-1X030-01-TRACK-1Q014-HANDBALL-5 |
yellow_sign_removed | boolean | Indicates whether a yellow sign dictating no group play was removed | 32% | TrueFalseof 2 |
polygon | unknown | Location (POLYGON) of athletic facility | — | — |
approx_date_closed | datetime | Approximate date Athletic Facility closed because of Covid | 16% | 2020-04-02T04:00:00.0002020-04-01T04:00:00.0002020-04-04T04:00:00.000 |
approx_date_reopened | datetime | Date Athletic Facility reopened from Covid closure | 22% | 2020-07-06T04:00:00.0002020-07-07T04:00:00.0002020-07-05T04:00:00.000 |
approx_date_nets_rims_goals_added | datetime | Indicates date of reinstallation of net, rim, or goal to an athletic facility | 63% | 2020-07-06T04:00:00.0002020-07-07T04:00:00.0002020-07-08T04:00:00.000 |
nets_rims_goals_added | boolean | Indicates whether nets, rims, or goals were added back to an athletic facility | 60% | TrueFalseof 2 |