From a 337-row sample across 20 columns.
boroughshapeboroughboroughboroughsystemboroughfeaturestatus+2Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| system | parentid | department | description | synturf_location | system_type | turf_type | infill_material | jop | maint_by | maint_by_spec | construction_entity |
|---|---|---|---|---|---|---|---|---|---|---|---|
| M042-SYNTURF-0137 | M042 | M-12 | Inwood Hill Park | Inwood Hill Park Zone 4 | Field Group | Infill | Coated Sand | false | DPR | NULL | DPR |
| M-14-SYNTURF-0136 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
system | text | Unique ID for the synthetic turf system | 0% | X136-SYNTURF-0101B141-SYNTURF-0034M286-SYNTURF-0045 |
parentid | text | The ID of the park property where the synthetic turf system is located | 0% | Q099M107B068 |
department | text | The Parks maintenance district where the synthetic turf system is located | 0% | M-03B-10M-11R |
description | text | Description of the synthetic turf system | 0% | Flushing Meadows Corona …McNair Playground |
GET /api/datasets/weh8-3ujf GET /api/datasets/weh8-3ujf/quality GET /api/datasets/weh8-3ujf/related GET /api/columns?dataset=weh8-3ujf
boroughsystemboroughshapesystemborough| M-14 |
| M-14 |
| 142nd Street Dog Run |
| 142nd street & Riverside Dr |
| Dog Run |
| Non-Infill |
| Non-Infill |
| false |
| DPR |
| NULL |
| DPR |
| M369-SYNTURF-0135 | M369 | M-03 | Pier 42 Playground | Pier 42 / East River Park | Play Area | Non-Infill | Non-Infill | false | DPR | NULL | DPR |
| M369-SYNTURF-0134 | M369 | M-03 | Pier 42 Soccer 1 | South St / Pier 42 | Play Area | Infill | Coated Sand | false | DPR | NULL | DPR |
| M144-SYNTURF-0133 | M144 | M-03 | Grand Street Soccer 1 | East River Park Zone 2 | Field Group | Infill | Coated Sand | false | DPR | NULL | DPR |
| B082-SYNTURF-0136 | B082 | B-10 | Shore Road Dog Run | Shore Road and 99th Street | Dog Run | Infill | Coated Sand | false | DPR | NULL | DPR |
| X202-SYNTURF-0132 | X202 | X-08 | Marble Hill Playground | Marble Hill Avenue and West 228th Street | Field Group | Infill | Coated Sand | false | DPR | NULL | DPR |
| M186-SYNTURF-0131 | M186 | M-10 | Brigadier General Charles Young Plgd | Lenox Ave & W 143rd St | Play Area | Infill | Coated Sand | false | DPR | NULL | DPR |
| Q127-SYNTURF-0121 | Q127 | Q-12 | Marconi Park | 109th Avenue and 157th Street | Field Group | Infill | Coated Sand | false | DPR | NULL | DPR |
| X196-SYNTURF-0105 | X196 | X-12 | Haffen Park | Hammersley Avenue and Gunther Avenue | Field Group | Infill | Coated Sand | false | DPR | NULL | DPR |
Showing 12 of 20 columns. All of them are listed below.
Crotona Parksynturf_location | text | Closest cross streets to the synthetic turf system. | 0% | Wards Meadow Loop14th Avenue and Benson A…Southwest at East River … |
system_type | categorical | The type of synthetic turf system. | 0% | Field GroupPlay AreaDog Runof 4 |
turf_type | categorical | The type of synthetic turf construction. | 0% | InfillNon-InfillUnknownof 3 |
infill_material | categorical | The type of fill used for systems of Turf_Type Infill. | 0% | Coated SandRubber CrumbNot Applicableof 11 |
jop | boolean | Indicates if the synthetic turf system is within a Jointly Operated Playground. | 7% | FalseTrueof 2 |
maint_by | categorical | The party responsible for the general maintenance of the synthetic turf system. | 6% | DPROtherUnknownof 4 |
maint_by_spec | categorical | The specific party responsible for general maintenance of the synthetic turf system. | 0% | NULLRandall's Island Park Al…Central Park Conservancyof 9 |
construction_entity | categorical | The entity responsible for the construction or replacement of the synthetic turf system. | 14% | DPRUnknownOtherof 5 |
construction_entity_spec | categorical | The specific entity responsible for the construction or reconstruction of the synthetic turf system. | 1% | NULLApplied Landscape Techno…Take The Fieldof 7 |
contract_type | categorical | The type of funding contract utilized for the construction or replacement of the synthetic turf system. | 7% | CapitalUnknownInHouseof 6 |
contract_number | text | The contract number under which the sythetic turf system was installed. | 0% | NULLMG-718MCNYG-808M PLANYC |
commission_date | datetime | Approximate date synthetic turf system was opened to the public. | 4% | 2009-05-31T00:00:00.0002019-07-01T00:00:00.0002022-06-01T00:00:00.000 |
retired | text | Indicates if the synthetic turf system is active or inactive | 0% | Falseof 1 |
borough | categorical | The borough where the synthetic turf system is located. | 0% | BMQof 5 |
shape | unknown | Geometry of the synthetic turf system | — | — |
featurestatus | categorical | Status of synthetic turf system | 0% | ActiveRemovedArchivedof 5 |