Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Asset Management Parks System (AMPS) - Work Orders

8sdw-8vjaEnvironment55 columns
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 this link For the Data Dictionary, please follow this link
View on NYC Open Data↗

Quality

A94.5 / 100

From a 500-row sample across 29 columns.

completeness97/ 25% weight
consistency81/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Forestry Work Orders0.38
  • Watershed Water Quality Data0.32
  • Urban Park Ranger Animal Condition Response0.31
  • Food Scrap Drop-Off Locations in NYC0.31
  • Asbestos Control Program (ACP7)0.30
  • Forestry Tree Points0.30
  • 2005 Street Tree Census0.30
  • Energy Usage From DOE Buildings0.29

Sample rows

evt_codeevt_descevt_typeevt_dateevt_mrcevt_printedevt_obtypeevt_objectevt_isstypeevt_durationevt_reportedevt_completed
10000I PROPRTY -VIN2009-02-20T00:00:00.000*-IPROPRTYF12009-02-20T09:36:00.0002009-02-20T09:36:00.000
10001I BASKETBALL -V

Columns

55 queryable · 55 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
evt_codeintegerUnique ID for each work order0%1885241857477616133
evt_desctextWork Order Description0%Adhoc InspectionBait for ratsBlewdown boiler sight gl…
evt_typecategoricalWork Order Type0%JOBINPPMof 7
evt_datedatetimeDate the work order was created0%2017-12-15T00:00:00.0002015-03-04T00:00:00.0002017-10-06T00:00:00.000

Query this from your own app

GET /api/datasets/8sdw-8vja
GET /api/datasets/8sdw-8vja/quality
GET /api/datasets/8sdw-8vja/related
GET /api/columns?dataset=8sdw-8vja
IN
2009-02-20T00:00:00.000
*
-
I
BASKETBALL
F
1
2009-02-20T09:41:00.000
2009-02-20T09:41:00.000
10002I HOOP -VIN2009-02-20T00:00:00.000*-IHOOPF12009-02-20T09:42:00.0002009-02-20T09:42:00.000
10003I BASEBALL -VIN2009-02-20T00:00:00.000*-IBASEBALLF12009-02-20T09:43:00.0002009-02-20T09:43:00.000
10004I BEACH -VIN2009-02-20T00:00:00.000*-IBEACHF12009-02-20T09:43:00.0002009-02-20T09:43:00.000
10005I BUILDING -VIN2009-02-20T00:00:00.000*-IBUILDINGF12009-02-20T09:44:00.0002009-02-20T09:44:00.000
10006I HANDBALL -VIN2009-02-20T00:00:00.000*-IHANDBALLF12009-02-20T09:45:00.0002009-02-20T09:45:00.000
10007I HOCKEY -VIN2009-02-20T00:00:00.000*-IHOCKEYF12009-02-20T09:45:00.0002009-02-20T09:45:00.000
10008I MULTIPURPOSE -VIN2009-02-20T00:00:00.000*-IMULTIPURPOSEF12009-02-20T09:46:00.0002009-02-20T09:46:00.000
10009I POOL -VIN2009-02-20T00:00:00.000*-IPOOLF12009-02-20T09:46:00.0002009-02-20T09:46:00.000

Showing 12 of 27 columns. All of them are listed below.

evt_mrctextThe name of the Park maintenance district in which the property is located.0%B-01*Q-07
evt_printedcategoricalIndicates if the work order has been printed0%-+of 2
evt_obtypecategoricalObject type0%STWof 8
evt_objecttextID number for the park or asset the work order is written about0%ITT-M010-ZN01-BLG0707X002-BLG0001M010
evt_standworktextWork order standard type.41%Adhoc InspectionRepairCheck-Repair
evt_ppmtextProperty where planned preventative maintenance occurred.95%M-NRRX-NRRX-NON_NRR
evt_freqcategoricalFrequency of planned preventative maintenance95%176of 4
evt_isstypecategoricalRecurrence schedule for planned preventative maintenance0%FVDof 3
evt_classtextWork Order Class31%Repair WorkField InspectionRoutine Work
evt_routetextIndicates what should be inspected at a given site95%N-CONFSTA-PARKN-CONFSTA-GREENSTY-CONFSTA-PARK
evt_targetdatetimeScheduled completion date51%2017-12-15 00:00:002015-03-04 00:00:002017-12-18 00:00:00
evt_durationtextIndicates expected time to complete scheduled task (in days)0%17494
evt_parenttextWork order number (EVT_CODE) of this work order's "parent" work order, as applicable97%20215952654922746
evt_reqmtextProblem Code63%General MaintainenceStructural DamageTrip Hazard
evt_jobtypecategoricalType of work order job13%CMADHCISof 12
evt_prioritycategoricalAssigned priority of the work order45%02-MED03-HIGH01-LOWof 10
evt_reporteddatetimeEditable date reported, when date was entered into system15%2017-11-01T00:00:00.0002017-10-09T00:00:00.0002018-04-01T00:00:00.000
evt_startdatetimeDate work order status (EVT_UDFCHAR13) is first changed to "Open"52%2010-04-30 00:00:002010-07-12 00:00:002010-07-07 00:00:00
evt_duetextScheduled due date96%Mar 15 2019 12:00AMSep 15 2018 12:00AMSep 15 2019 12:00AM
evt_completeddatetimeDate and time this work order was completed.1%2009-04-23T14:45:00.0002009-04-23T14:46:00.0002009-04-23T14:47:00.000
evt_warrantycategoricalIndicates if equipment was repair was covered under warranty0%-+of 2
evt_safetycategoricalIndicates if the work order is safety related0%-+of 2
evt_reopenedcategoricalIndicates is work order was completed and reopened0%-+of 2
evt_schedenddatetimeScheduled end time for a scheduled work order51%2017-12-15T00:00:00.0002015-03-04T00:00:00.0002017-12-18T00:00:00.000
evt_createddatetimeDate and time this work order was created0%2009-04-23T14:45:00.0002009-04-23T14:46:00.0002009-04-23T14:47:00.000
evt_updateddatetimeDate and time this work order was last updated33%2010-06-20 07:17:002010-07-14 09:14:002010-07-08 13:45:00
evt_updatecountintegerNumber of times the work order record has been updated0%031
evt_perioduomcategoricalPeriod of scheduled task95%YMDof 3
evt_sqlidentitytextUnique identifier0%231082011016162586308
evt_multiequipcategoricalIndicates if work order is for multiple pieces of equipment0%-+of 2
evt_completed_truncdatetimeDate for when work order was closed1%2017-12-15T00:00:00.0002015-03-04T00:00:00.0002017-12-18T00:00:00.000
evt_udfchar01categoricalRequested priority of the work order69%03-HIGH02-MED04-IAIIof 9
evt_udfchar02categoricalSubclass of work order for data modification requests100%Prop/Fac/Feat Modificati…New Prop/Fac/FeatProp/Fac/Feat Retirementof 3
evt_udfchar03categoricalIndicates group this work order is submitted to35%SHOPSDISTRICTCREWSof 15
evt_udfchar04categoricalIndicate asset type100%FeatureParkGreenstreetof 3
evt_udfchar05textReason for rejection, for rejected WO95%duplicateerrorCREATED IN ERROR
evt_udfchar06textTrade of person assigned to the work order41%MWPSIPLUMBER
evt_udfchar08textStreet location of park/asset, if available39%1 Bronx River ParkwayMeridian RoadWalnut Ave. bet. E. 138 …
evt_udfchar10textParks Inspection feature that work order pertains to54%BUILDING/STRUCTUREMECHANICAL SYSTEMPLAY EQUIPMENT
evt_udfchar11categoricalIndicates if out of service or salvaged94%NYSof 3
evt_udfchar12categoricalIndicates if work request was generated on a phone or desktop48%PASSEDSAMSUNGNEWof 6
evt_udfchar13textCurrent status of work order3%CompletedCancelledRejected
evt_udfchar14textDate inspection was uploaded91%MW2/25/20209/21/2020
evt_udfchar15textDaily Immediate Attention (DIA) number99%00000999992
evt_udfchar16text311 service request number100%000000017979034N/A
evt_udfnum01coordinateScheduling sequence98%1.0000005.0000004.000000
evt_udfchkbox01categoricalIndicates if work order is generated from a Daily Immediate Attention (DIA)0%-+of 2
evt_udfchkbox02categoricalIndicates if new part0%-+of 2
evt_udfchkbox03categoricalReviewed for backlog cleanup0%-+of 2
evt_udfchkbox04categoricalIndicates if a comment is attached to work order0%-+of 2
evt_udfchkbox05categoricalIndicates if a document is attached to work order0%-+of 2