Asset Management Parks System (AMPS) - Work Orders
Use escrito dataset nyc.8sdw-8vja
This table is the primary table for information about work orders, and contains general information - including a description of the work, assigned title, request date and completion date - about each work order. Each row represents a single work order. The primary key field is EVT_CODE. The EVT_OBJECT field can be joined to the Assets table on OBJ_CODE to know which asset the work order was for. For the User Guide, please follow <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a> For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>
Cite as: Department of Parks and Recreation (DPR). Asset Management Parks System (AMPS) - Work Orders. https://data.cityofnewyork.us/d/8sdw-8vja
- Publisher
- City of New York
- Tier
- Official
- Covers
- not stated
- Places
- New York City
- Updated
- irregular
- Last modified
- 2026-11-02
- Units
- not stated
- License
- NYC Open Data Terms of Use
- Method
- https://data.cityofnewyork.us/d/8sdw-8vja
Columns
| Name | Type | Description |
|---|---|---|
| evt_udfchar14 | text | Date inspection was uploaded |
| evt_udfchar12 | text | Indicates if work request was generated on a phone or desktop |
| evt_target | text | Scheduled completion date |
| evt_udfchar11 | text | Indicates if out of service or salvaged |
| evt_object | text | ID number for the park or asset the work order is written about |
| evt_start | text | Date work order status (EVT_UDFCHAR13) is first changed to "Open" |
| evt_updated | text | Date and time this work order was last updated |
| evt_created | text | Date and time this work order was created |
| evt_type | text | Work Order Type |
| evt_reqm | text | Problem Code |
| evt_desc | text | Work Order Description |
| evt_schedend | text | Scheduled end time for a scheduled work order |
| evt_priority | text | Assigned priority of the work order |
| evt_udfchar10 | text | Parks Inspection feature that work order pertains to |
| evt_class | text | Work Order Class |
| evt_duration | text | Indicates expected time to complete scheduled task (in days) |
| evt_due | text | Scheduled due date |
| evt_completed | text | Date and time this work order was completed. |
| evt_udfchar08 | text | Street location of park/asset, if available |
| evt_printed | text | Indicates if the work order has been printed |
| evt_obtype | text | Object type |
| evt_freq | text | Frequency of planned preventative maintenance |
| evt_jobtype | text | Type of work order job |
| evt_isstype | text | Recurrence schedule for planned preventative maintenance |
| evt_safety | text | Indicates if the work order is safety related |
| evt_reopened | text | Indicates is work order was completed and reopened |
| evt_warranty | text | Indicates if equipment was repair was covered under warranty |
| evt_perioduom | text | Period of scheduled task |
| evt_multiequip | text | Indicates if work order is for multiple pieces of equipment |
| evt_udfchar02 | text | Subclass of work order for data modification requests |
| evt_udfchar04 | text | Indicate asset type |
| evt_udfchkbox03 | text | Reviewed for backlog cleanup |
| evt_udfchkbox04 | text | Indicates if a comment is attached to work order |
| evt_udfchkbox05 | text | Indicates if a document is attached to work order |
| evt_udfchkbox01 | text | Indicates if work order is generated from a Daily Immediate Attention (DIA) |
| evt_udfchkbox02 | text | Indicates if new part |
| evt_udfnum01 | text | Scheduling sequence |
| evt_udfchar16 | text | 311 service request number |
| evt_udfchar13 | text | Current status of work order |
| evt_udfchar06 | text | Trade of person assigned to the work order |
| evt_udfchar05 | text | Reason for rejection, for rejected WO |
| evt_udfchar03 | text | Indicates group this work order is submitted to |
| evt_standwork | text | Work order standard type. |
| evt_sqlidentity | text | Unique identifier |
| evt_reported | text | Editable date reported, when date was entered into system |
| evt_updatecount | number | Number of times the work order record has been updated |
| evt_ppm | text | Property where planned preventative maintenance occurred. |
| evt_date | calendar_date | Date the work order was created |
| evt_code | number | Unique ID for each work order |
| evt_mrc | text | The name of the Park maintenance district in which the property is located. |
| evt_route | text | Indicates what should be inspected at a given site |
| evt_completed_trunc | text | Date for when work order was closed |
| evt_parent | text | Work order number (EVT_CODE) of this work order's "parent" work order, as applicable |
| evt_udfchar01 | text | Requested priority of the work order |
| evt_udfchar15 | text | Daily Immediate Attention (DIA) number |