From a 500-row sample across 35 columns.
| row_id | gispropnum | propid | obj_gisobjid | route_id | off_route | signname | district | sector | sector_name | sector_desc | vehicle_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1580771 | X302 | X302 | 100005027 | 2756 | Yes | X302 | Thorpe Family Playground | X-06 | X-S3.6 | Bronx Sector 3.6 | Districts 3, 6 | 0 |
| 1580771 | X302 |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
row_id | integer | — | — | 234 |
gispropnum | text | 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. | — | Q099B073M071 |
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. | — | M089R031-ZN02Q099-ZN11 |
obj_gisobjid | integer | Unique identifier that links the property being serviced to an asset in AMPS. |
GET /api/datasets/kwte-dppd GET /api/datasets/kwte-dppd/quality GET /api/datasets/kwte-dppd/related GET /api/columns?dataset=kwte-dppd
| X302 |
| 100005027 |
| 2756 |
| Yes |
| X302 | Thorpe Family Playground |
| X-06 |
| X-S3.6 |
| Bronx Sector 3.6 |
| Districts 3, 6 |
| 0 |
| 1581969 | M037 | M037-ZN06 | 100005591 | 1869 | Yes | M037-ZN06 | Highbridge Park Zone 6 | M-12A | M-S12.12A | Manhattan Sector 12.12A | Districts 12, 12A | 5051 |
| 1580427 | B140 | B140 | 100004721 | 2814 | No | B140 | Banneker Playground | B-03 | B-S3.4 | Brooklyn Sector 3.4 | Districts 3, 4 | 8325 |
| 1579795 | — | — | — | 2867 | — | — | — | X-S4.5 | Bronx Sector 4.5 | Districts 4, 5 | 5034 |
| 1580884 | — | — | — | 1838 | — | — | — | M-S7.9 | Manhattan Sector 7.9 | Districts 7, 9 | 5875 |
| 1581650 | R127 | R127 | 100004225 | 2051 | No | R127 | Joseph Manna Park | R-01 | R-S1 | Staten Island Sector 1 | District 1 | 5575 |
| 1580455 | B361 | B361 | 100004456 | 2840 | Yes | B361 | Boerum Park | B-06 | B-S6.7 | Brooklyn Sector 6.7 | Districts 6, 7 | 8602 |
| 1582264 | M005 | M005 | 100003738 | 2215 | Yes | M005 | The Battery | M-01 | M-S1.2 | Manhattan Sector 1.2 | Districts 1, 2 | 8616 |
| 1690158 | B036 | B036 | 100004439 | 1746 | No | B036 | Fort Stirling Park | B-02 | B-S2 | Brooklyn Sector 2 | District 2 | 8331 |
Showing 12 of 35 columns. All of them are listed below.
| — |
100003802100005546100000578 |
route_id | integer | Unique identification number for the route as part of which the indicated activity was performed | — | 113942251 |
off_route | categorical | An indicator as to whether or not a property is included on the selected route. | — | NoYesof 2 |
signname | text | The name of the entire site as it appears on the signs located on the exterior of the park. | — | M089 | Union Square ParkR031-ZN02 | Wolfe's Pond…Q099-ZN11 | Flushing Mea… |
district | text | The name of the Park Maintenance District in which the property is located. | — | R-01M-03B-01 |
sector | text | Unique identification string of the Park Maintenance Sector in which the property is located. | — | X-SAX-S4.5X-S3.6 |
sector_name | text | The name of the sector in which the property is located. | — | Bronx Sector 4.5Bronx Sector 11.12.14Bronx Sector 3.6 |
sector_desc | text | The numbers of the Park Maintenance Districts that comprise the associated Sector | — | Districts 1, 2District 1District 3 |
vehicle_number | integer | The vehicle number used for the given date and route. | — | 052395137 |
date_worked | datetime | The date on which the indicated activity was performed. | — | 2020-01-28T00:00:00.0002019-12-17T00:00:00.0002019-07-04T00:00:00.000 |
start_time | datetime | The date and time at which the indicated activity started. | — | 2020-03-25T07:00:00.0002019-11-26T07:00:00.0002020-01-14T07:00:00.000 |
end_time | datetime | The date and time at indicated which the activity ended. | — | 2020-03-25T15:30:00.0002019-12-17T15:30:00.0002020-02-05T15:30:00.000 |
activity | categorical | The type of activity captured for a record. Cleaning is indicated by the "Work" activity, while other activity codes are used for other actions. | — | WorkOtherMobilizationof 6 |
animal_waste | categorical | An indicator as to whether or not animal waste was cleaned during a visit. | — | NoYesof 2 |
broken_glass | categorical | An indicator as to whether or not broken glass was cleaned during a visit. | — | NoYesof 2 |
dumping | categorical | An indicator as to whether or not dumping was cleaned during a visit. | — | NoYesof 2 |
graffiti | categorical | An indicator as to whether or not graffiti was cleaned during a visit. | — | NoYesof 2 |
medical_waste | categorical | An indicator as to whether or not medical waste was cleaned during a visit. | — | NoYesof 2 |
napsw | categorical | A count of the number of staff in the Associate Park Service Worker title on the cleaning crew during the indicated activity. | — | 012of 11 |
ncpw | categorical | A count of the number of staff in the City Park Worker title on the cleaning crew during the indicated activity. | — | 012of 16 |
ncsa | categorical | A count of the number of staff in the City Seasonal Aide title on the cleaning crew during the indicated activity. | — | 012of 16 |
njtp | categorical | A count of the number of staff in the Job Training Participant title on the cleaning crew during the indicated activity. | — | 012of 16 |
nnpw | categorical | A count of the number of non-Parks employees on the cleaning crew during the indicated activity. | — | 012of 16 |
ncrew | text | A count of the total number of workers on the cleaning crew during the indicated activity. | — | 213 |
fixed_post | categorical | An indicator as to whether or not an entry was made using the "Fixed Post" module of the application. | — | NoYesof 2 |
nhours | coordinate | A count of the adjusted number of hours a given task was performed. | — | 0.500.250.17 |
daily_task_id | text | A unique ID assigned to each Daily Task entry. | — | 30083765403203183 |
daily_task_activity_id | text | A unique ID assigned to each Daily Task activity entry. | — | 346958133138362815791 |
overlap_flag | categorical | An indicator as to whether or not the number of hours (nhours) were adjusted for overlapping times and tasks. | — | 01of 2 |
fiscal_day | text | The relative day of the fiscal year. | — | 247248221 |
fiscal_week | text | The relative week of the fiscal year. | — | 363531 |
fiscal_qtr | text | The fiscal year followed by the fiscal quarter for a given record. | — | 2020Q12020Q32020Q2 |