{
 "currentVersion": 11.2,
 "cimVersion": "3.2.0",
 "id": 16,
 "name": "Project Line WorkType",
 "type": "Table",
 "description": "Additional - Secondary Work Types for Project Lines",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SolicitationNumber",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "RelationID",
   "type": "esriFieldTypeGUID",
   "alias": "RelationID",
   "length": 38,
   "domain": null
  },
  {
   "name": "PIID",
   "type": "esriFieldTypeInteger",
   "alias": "PIID",
   "domain": null
  },
  {
   "name": "WorkTypeID",
   "type": "esriFieldTypeInteger",
   "alias": "WorkTypeID",
   "domain": null
  },
  {
   "name": "WorkType",
   "type": "esriFieldTypeString",
   "alias": "WorkType",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "PTPWorkTypes",
    "description": "ProTrack+ Project work types",
    "codedValues": [
     {
      "name": "ADA High Impact",
      "code": "COO-MA-ADAHIGH"
     },
     {
      "name": "ADA Low Impact",
      "code": "COO-MA-ADALOW"
     },
     {
      "name": "ADA Medium Impact",
      "code": "COO-MA-ADAMED"
     },
     {
      "name": "Alley Restoration",
      "code": "COO-MA-ALYRES"
     },
     {
      "name": "Automated Bike Counter",
      "code": "CPDO-IPMA-BIKAC"
     },
     {
      "name": "Bike Lane",
      "code": "CPDO-IPMA-BIKLN"
     },
     {
      "name": "Bike Parking Rack",
      "code": "CPDO-IPMA-BIKPR"
     },
     {
      "name": "Bike Share Station",
      "code": "CPDO-IPMA-BIKSR"
     },
     {
      "name": "Bike Trail",
      "code": "CPDO-IPMA-BIKTR"
     },
     {
      "name": "Bioretention Curb Extension",
      "code": "CPDO-IPMA-BCE"
     },
     {
      "name": "Bioretention Planter",
      "code": "CPDO-IPMA-BP"
     },
     {
      "name": "Bridge Reconstruction",
      "code": "COO-MA-BRC"
     },
     {
      "name": "Bridge Rehabilitation",
      "code": "CPDO-IPMA-BRR"
     },
     {
      "name": "Bus Priority Project",
      "code": "COO-MA-BUSPRJ"
     },
     {
      "name": "Bus Shelter Construction",
      "code": "COO-MA-BUSSHLTR"
     },
     {
      "name": "Chip Seal",
      "code": "COO-MA-CHIPSEAL"
     },
     {
      "name": "Corridor Plan/Study",
      "code": "CPDO-IPMA-CPS"
     },
     {
      "name": "Corridor Study",
      "code": "CPDO-PSA-CSTUDY"
     },
     {
      "name": "Crack Seal",
      "code": "COO-MA-CRAKSEAL"
     },
     {
      "name": "Culvert Rehabilitation",
      "code": "COO-MA-CULVREH"
     },
     {
      "name": "Culvert Replacement",
      "code": "COO-MA-CULVREP"
     },
     {
      "name": "Curb and Gutter",
      "code": "COO-MA-CURBGUT"
     },
     {
      "name": "Environmental Assessment",
      "code": "CPDO-PSA-ENA"
     },
     {
      "name": "Environmental Impact Statement",
      "code": "CPDO-PSA-EIS"
     },
     {
      "name": "Environmental Process",
      "code": "CPDO-PSA-EP"
     },
     {
      "name": "Fabricate Signs",
      "code": "COO-MA-FABRSIGN"
     },
     {
      "name": "Federal Aid Resurfacing",
      "code": "COO-MA-FAR"
     },
     {
      "name": "Flexi Paving",
      "code": "COO-MA-FP"
     },
     {
      "name": "Full Traffic Signal Modification",
      "code": "COO-MA-SIGNALMO"
     },
     {
      "name": "Green Infrastructure",
      "code": "CPDO-IPMA-GI"
     },
     {
      "name": "Green Infrastructure Permeable Alley",
      "code": "CPDO-IPMA-GIPA"
     },
     {
      "name": "Hardening of Bike Lane",
      "code": "COO-MA-HBL"
     },
     {
      "name": "High Injury Network",
      "code": "COO-HI-INJ-NETW"
     },
     {
      "name": "Highway Safety Improvement Program (HSIP) Improvements",
      "code": "COO-HSIP-IMP"
     },
     {
      "name": "Horizontal Sidewalk Saw Cutting",
      "code": "COO-MA-HSS-CUT"
     },
     {
      "name": "Implement Speed Limit Reduction from 25 mph to 20 mph",
      "code": "COO-MA-SP-RED20"
     },
     {
      "name": "Implement Speed Limit Reduction from 30 mph to 25 mph",
      "code": "COO-MA-SP-RED25"
     },
     {
      "name": "Install APS Push Button",
      "code": "COO-MA-APS-PB"
     },
     {
      "name": "Install Bike Lanes",
      "code": "CPDO-PSA-IBL"
     },
     {
      "name": "Install Bike Signal",
      "code": "COO-MA-INS-BSIG"
     },
     {
      "name": "Install Bus Queue Jump Signal",
      "code": "COO-MA-BQJS"
     },
     {
      "name": "Install Concrete Curb Extensions",
      "code": "CPDO-INS-C-CURB"
     },
     {
      "name": "Install Crosswalk",
      "code": "CPDO-IPMA-INCW"
     },
     {
      "name": "Install Driver Feedback Sign",
      "code": "COO-DRV-FEEDSGN"
     },
     {
      "name": "Install Dynamic Messaging Sign",
      "code": "COO-TOSA-DMS"
     },
     {
      "name": "Install Flexposts",
      "code": "COO-MA-FLX-PO"
     },
     {
      "name": "Install HAWK Signal",
      "code": "COO-MA-HAWK"
     },
     {
      "name": "Install High Visibility Crosswalk",
      "code": "COO-MA-HVC"
     },
     {
      "name": "Install Infrastructure Survaillance Camera",
      "code": "COO-TOSA-CAMERA"
     },
     {
      "name": "Install LED Embedded Pedestrian Crossing Sign",
      "code": "COO-LED-PEDCSGN"
     },
     {
      "name": "Install Left-Turn Lane",
      "code": "COO-MA-INSTALTL"
     },
     {
      "name": "Install New Sidewalk",
      "code": "CPDO-IPMA-NSW"
     },
     {
      "name": "Install New Signs",
      "code": "COO-MA-INSTSIGN"
     },
     {
      "name": "Install New Signs - No Parking/Bus Only",
      "code": "CPDO-IPMA-NS-BO"
     },
     {
      "name": "Install New Traffic Signal",
      "code": "COO-MA-SIGNALIN"
     },
     {
      "name": "Install No Turn On Red Sign",
      "code": "COO-MA-INS-NTOR"
     },
     {
      "name": "Install Pedestrian Refuge Island",
      "code": "COO-MA-IPRI"
     },
     {
      "name": "Install Raised Crosswalk",
      "code": "COO-MA-ICRSWK"
     },
     {
      "name": "Install Retroreflective Backplate",
      "code": "COO-MA-INS-RFBP"
     },
     {
      "name": "Install RRFB for Pedestrians",
      "code": "COO-MA-RRFB"
     },
     {
      "name": "Install Rumble Strips",
      "code": "COO-MA-INS-RUS"
     },
     {
      "name": "Install School Zone Flashing Beacon",
      "code": "COO-MA-INS-SZFB"
     },
     {
      "name": "Install Speed Hump",
      "code": "COO-MA-ISPDH"
     },
     {
      "name": "Install Streetlight",
      "code": "COO-MA-INSSTLT"
     },
     {
      "name": "Install Thermoplastic Pavement Markings",
      "code": "COO-MA-INSTTPM"
     },
     {
      "name": "Install Traffic Calming Device",
      "code": "COO-MA-INSTTCD"
     },
     {
      "name": "Install/Upgrade Curb Ramps",
      "code": "COO-MA-INU-CR"
     },
     {
      "name": "Livability Study - Neighborhood Plan",
      "code": "CPDO-PSA-LSP"
     },
     {
      "name": "Livability Study Improvements",
      "code": "COO-LIVSTDY-IMP"
     },
     {
      "name": "Major Project Study",
      "code": "CPDO-PSA-MPS"
     },
     {
      "name": "Microsurfacing",
      "code": "COO-MA-MICROSRF"
     },
     {
      "name": "Mid-block Vehicle Detector Sensor",
      "code": "COO-TOSA-VDS"
     },
     {
      "name": "Midsize Traffic Signal Modification",
      "code": "COO-MA-MSTSM"
     },
     {
      "name": "Multi-Use Trail",
      "code": "CPDO-IPMA-MUT"
     },
     {
      "name": "Multimodal Safety",
      "code": "CPDO-MM-SAFETY"
     },
     {
      "name": "Pavement Resurface/Restoration",
      "code": "COO-MA-PRR"
     },
     {
      "name": "Pedestrian Trail",
      "code": "CPDO-IPMA-PEDTR"
     },
     {
      "name": "Permeable Alley",
      "code": "CPDO-IPMA-PA"
     },
     {
      "name": "Permeable Parking Lane",
      "code": "CPDO-IPMA-PPL"
     },
     {
      "name": "Permeable Paving",
      "code": "CPDO-IPMA-PP"
     },
     {
      "name": "Post-Fatal Crash Site Improvement",
      "code": "COO-PFCS-IMP"
     },
     {
      "name": "Preliminary Design",
      "code": "CPDO-PSA-PREDES"
     },
     {
      "name": "Pro-Active Safety Improvement",
      "code": "COO-PAS_IMP"
     },
     {
      "name": "Program Development",
      "code": "CPDO-PSA-PD"
     },
     {
      "name": "Quality Assurance/Quality Control",
      "code": "CPDO-IPMA-QAQC"
     },
     {
      "name": "Reconfigure Intersection",
      "code": "COO-MA-RIS"
     },
     {
      "name": "Relocate Streetlight",
      "code": "COO-MA-RELSLITE"
     },
     {
      "name": "Remove Streetlight",
      "code": "COO-MA-REMSLITE"
     },
     {
      "name": "Repair Signs",
      "code": "COO-MA-REPASIGN"
     },
     {
      "name": "Repair Streetlight",
      "code": "COO-MA-REPSLITE"
     },
     {
      "name": "Replace Signs",
      "code": "COO-MA-REPLSIGN"
     },
     {
      "name": "Replace Streetlight",
      "code": "COO-MA-REPLSLTE"
     },
     {
      "name": "Retaining Wall Restoration",
      "code": "COO-MA-RWR"
     },
     {
      "name": "Right of Way",
      "code": "CPDO-IPMA-ROW"
     },
     {
      "name": "Roadway Reconstruction",
      "code": "COO-MA-REC"
     },
     {
      "name": "Roadway Rehabilitation",
      "code": "COO-MA-RDREHAB"
     },
     {
      "name": "Safety Improvement",
      "code": "CPDO-IPMA-SAFE"
     },
     {
      "name": "Safety Study",
      "code": "CPDO-IPMA-SS"
     },
     {
      "name": "Sidewalk Construction",
      "code": "COO-MA-SDWKCON"
     },
     {
      "name": "Slurry Seal",
      "code": "COO-MA-SLRYSEAL"
     },
     {
      "name": "Speed Management",
      "code": "CPDO-HS-SPMGT"
     },
     {
      "name": "Stormwater Green Infrastructure",
      "code": "CPDO-IPMA-SGI"
     },
     {
      "name": "Stormwater Hydraulics",
      "code": "CPDO-IPMA-SWH"
     },
     {
      "name": "Stormwater Improvements",
      "code": "COO-MA-STWAIM"
     },
     {
      "name": "Streetcar Extension",
      "code": "CPDO-TDD-STCARE"
     },
     {
      "name": "Streetscape",
      "code": "CPDO-IPMA-STSC"
     },
     {
      "name": "Streetscape Study",
      "code": "CPDO-PSA-SSS"
     },
     {
      "name": "Thermoplastic Pavement Marking- Bike Lane",
      "code": "COO-MA-TPMBIKE"
     },
     {
      "name": "Thermoplastic Pavement Marking- High Crash Location",
      "code": "COO-MA-TPMHSC"
     },
     {
      "name": "Thermoplastic Pavement Marking- High Traffic Volume (AADT)",
      "code": "COO-MA-TPMHTV"
     },
     {
      "name": "Thermoplastic Pavement Marking- Marking Retroreflectivity",
      "code": "COO-MA-TPMMR"
     },
     {
      "name": "Thermoplastic Pavement Marking- Misc (Service Request Locations)",
      "code": "COO-MA-TPMMISC"
     },
     {
      "name": "Thermoplastic Pavement Marking- School",
      "code": "COO-MA-TPMSCH"
     },
     {
      "name": "Trail Extension",
      "code": "CPDO-IPMA-TREXT"
     },
     {
      "name": "Tree Planting",
      "code": "COO-UFA-TRPLANT"
     },
     {
      "name": "Tree Pruning",
      "code": "COO-UFA-TRPRUNE"
     },
     {
      "name": "Tree Removal",
      "code": "COO-UFA-TRREMOV"
     },
     {
      "name": "Tree Space With Structural Soil",
      "code": "CPDO-IPMA-TSWSS"
     },
     {
      "name": "Tunnel Camera Installation",
      "code": "COO-MA-TUN-CAMI"
     },
     {
      "name": "Tunnel Camera Repair",
      "code": "COO-MA-TUN-CAMR"
     },
     {
      "name": "Tunnel Ceiling Panel Repair",
      "code": "COO-MA-TUN-CPR"
     },
     {
      "name": "Tunnel Conduit Installation",
      "code": "COO-MA-TUN-CINS"
     },
     {
      "name": "Tunnel Conduit Repair",
      "code": "COO-MA-TUN-CREP"
     },
     {
      "name": "Tunnel Design Services",
      "code": "COO-MA-TUN-DS"
     },
     {
      "name": "Tunnel Fan Repair",
      "code": "COO-MA-TUN-FREP"
     },
     {
      "name": "Tunnel Fan Upgrade",
      "code": "COO-MA-TUN-FUPG"
     },
     {
      "name": "Tunnel Graffiti Removal",
      "code": "COO-MA-TUN-GR"
     },
     {
      "name": "Tunnel Inspection",
      "code": "COO-MA-TUN-INSP"
     },
     {
      "name": "Tunnel Lighting Repair",
      "code": "COO-MA-TUN-LREP"
     },
     {
      "name": "Tunnel Lighting Upgrade",
      "code": "COO-MA-TUN-LUPG"
     },
     {
      "name": "Tunnel Planning Study",
      "code": "COO-MA-TUN-PS"
     },
     {
      "name": "Tunnel Re-lamping",
      "code": "COO-MA-TUN-RL"
     },
     {
      "name": "Tunnel Security Audit",
      "code": "COO-MA-TUN-SECA"
     },
     {
      "name": "Tunnel Structural Repair",
      "code": "COO-MA-TUN-SREP"
     },
     {
      "name": "Tunnel Switchgear Repair",
      "code": "COO-MA-TUN-SGR"
     },
     {
      "name": "Tunnel Switchgear Upgrade",
      "code": "COO-MA-TUN-SGU"
     },
     {
      "name": "Tunnel Tile Repair",
      "code": "COO-MA-TUN-TREP"
     },
     {
      "name": "Tunnel Washing",
      "code": "COO-MA-TUN-WASH"
     },
     {
      "name": "Tunnel Work",
      "code": "COO-MA-TUNNEL"
     },
     {
      "name": "Utility Projects",
      "code": "CPDO-IPMA-UP"
     },
     {
      "name": "Vision Zero Hardening",
      "code": "CPDO-HS-VZH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SolicitationNumber",
   "type": "esriFieldTypeString",
   "alias": "SolicitationNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "TaskOrderNumber",
   "type": "esriFieldTypeString",
   "alias": "TaskOrderNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "TaskOrderRequestNumber",
   "type": "esriFieldTypeString",
   "alias": "TaskOrderRequestNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "ContractNumber",
   "type": "esriFieldTypeString",
   "alias": "ContractNumber",
   "length": 30,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R33_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_33",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G47WorkTypeID",
   "fields": "WorkTypeID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "plwt",
   "fields": "RelationID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 7,
   "name": "PTPLineWorkType to PTPLine",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "RelationID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{07E999A0-1DA9-4715-A581-40271369571F}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}