{ "currentVersion": 10.81, "cimVersion": "2.6.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": "R27_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_27", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G43RelationID", "fields": "RelationID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "PTPLine", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RelationID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }