{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 11,
"name": "Project Initiation Polygon WorkType",
"type": "Table",
"description": "Additional - Secondary Work Types for Project Initiation Polygons",
"copyrightText": "",
"editFieldsInfo": null,
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 9,
"name": "PIPolygonWorkType to PIPolygon",
"relatedTableId": 4,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "RelationID",
"composite": true,
"catalogID": "{BE4D3A19-4CDB-402D-A680-C0C8BF5D2455}"
}
],
"isDataVersioned": false,
"isDataArchived": false,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "WorkType",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "PIID",
"type": "esriFieldTypeInteger",
"alias": "PIID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "PIID"
},
{
"name": "WorkTypeID",
"type": "esriFieldTypeInteger",
"alias": "WorkTypeID",
"domain": null,
"editable": true,
"nullable": false,
"defaultValue": null,
"modelName": "WorkTypeID"
},
{
"name": "WorkType",
"type": "esriFieldTypeString",
"alias": "WorkType",
"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"
},
"editable": true,
"nullable": true,
"length": 15,
"defaultValue": null,
"modelName": "WorkType"
},
{
"name": "IsDeleted",
"type": "esriFieldTypeSmallInteger",
"alias": "IsDeleted",
"domain": {
"type": "codedValue",
"name": "PTPBoolean",
"description": "True or False",
"codedValues": [
{
"name": "False",
"code": 0
},
{
"name": "True",
"code": 1
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"defaultValue": 0,
"modelName": "IsDeleted"
},
{
"name": "RelationID",
"type": "esriFieldTypeGUID",
"alias": "RelationID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "RelationID"
}
],
"indexes": [
{
"name": "R26_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_26",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G40WorkTypeID",
"fields": "WorkTypeID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "pipolwtRelationI",
"fields": "RelationID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Project Initiation Polygon WorkType",
"description": "",
"prototype": {
"attributes": {
"IsDeleted": 0,
"WorkType": null,
"RelationID": null,
"PIID": null,
"WorkTypeID": 0
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,Extract",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1
}