{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Project Work Areas", "type": "Feature Layer", "description": "The Project Work Areas are a join of business data with a geospatial polygon that represents a project work area or multiple work areas. CTDOT business data sources are federated to the CPD (Composite Project Database) along with COMPASS (O365 SharePoint Project Management) information. The Project Work Area polygon(s) are representing the project limits. There are large administrative areas that are Statewide or Districtwide projects in which no LRS (Linear Reference System) project road sections or assets are identified. The local work areas are smaller areas where project road sections and major assets are collected with proposed work identified. Assets within work areas are tracked with proposed work identified. Filtered versions such as Active Projects and Completed Projects are filtered by the \"Current Schedule Phase\".", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 103016, "latestWkid": 6434, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119756300, "falseY": -96342500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 103016, "latestWkid": 6434, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119756300, "falseY": -96342500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "Offices with DOT: AEC Applications, eGIS and OIS", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 245, 237, 171, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 224, 210, 184, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 726043.389490053, "ymin": 543930.4291794002, "xmax": 1263220.709162131, "ymax": 947929.1323352307, "spatialReference": { "wkid": 103016, "latestWkid": 6434, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119756300, "falseY": -96342500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ProjectID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "Project ID", "domain": null }, { "name": "ProjectNumber", "type": "esriFieldTypeString", "alias": "Project Number", "length": 50, "domain": null }, { "name": "ProposedProjectNumber", "type": "esriFieldTypeString", "alias": "Proposed Project Number", "length": 50, "domain": null }, { "name": "ContractNumber", "type": "esriFieldTypeString", "alias": "Contract Number", "length": 25, "domain": null }, { "name": "InheritedProjects", "type": "esriFieldTypeString", "alias": "Inherited Projects", "length": 40, "domain": null }, { "name": "ProgramNumber", "type": "esriFieldTypeString", "alias": "Program Number", "length": 25, "domain": null }, { "name": "Title", "type": "esriFieldTypeString", "alias": "Title", "length": 200, "domain": null }, { "name": "ProjectDescription", "type": "esriFieldTypeString", "alias": "Project Description", "length": 255, "domain": null }, { "name": "ScopeCode", "type": "esriFieldTypeString", "alias": "Scope Code", "length": 25, "domain": null }, { "name": "ProjectScopeCodeDescription", "type": "esriFieldTypeString", "alias": "Project Scope Code Description", "length": 50, "domain": null }, { "name": "CTDOTImprovementType", "type": "esriFieldTypeString", "alias": "CTDOT Improvement Type", "length": 100, "domain": null }, { "name": "FinancialPhases", "type": "esriFieldTypeString", "alias": "Financial Phases", "length": 20, "domain": null }, { "name": "CurrentSchedulePhase", "type": "esriFieldTypeString", "alias": "Current Schedule Phase", "length": 35, "domain": null }, { "name": "FHWAoversight", "type": "esriFieldTypeString", "alias": "FHWA Oversight", "length": 200, "domain": null }, { "name": "STIPStatus", "type": "esriFieldTypeString", "alias": "STIP Status", "length": 20, "domain": null }, { "name": "STIPstatusDescription", "type": "esriFieldTypeString", "alias": "STIP Status Description", "length": 50, "domain": null }, { "name": "Towns", "type": "esriFieldTypeString", "alias": "Towns", "length": 500, "domain": null }, { "name": "StateRoutes", "type": "esriFieldTypeString", "alias": "State Routes", "length": 500, "domain": null }, { "name": "Bridges", "type": "esriFieldTypeString", "alias": "Bridges", "length": 1500, "domain": null }, { "name": "PavementTreatment", "type": "esriFieldTypeString", "alias": "Pavement Treatment", "length": 75, "domain": null }, { "name": "RetainingWalls", "type": "esriFieldTypeString", "alias": "Retaining Walls", "length": 500, "domain": null }, { "name": "TrafficSignals", "type": "esriFieldTypeString", "alias": "Traffic Signals", "length": 1500, "domain": null }, { "name": "SignSupports", "type": "esriFieldTypeString", "alias": "Sign Supports", "length": 500, "domain": null }, { "name": "RPMdate", "type": "esriFieldTypeDate", "alias": "RPM", "length": 8, "domain": null }, { "name": "ProjectInitiationDate", "type": "esriFieldTypeDate", "alias": "Project Initiation", "length": 8, "domain": null }, { "name": "DesignApprovalDate", "type": "esriFieldTypeDate", "alias": "Design Approval", "length": 8, "domain": null }, { "name": "ROWInitiationDate", "type": "esriFieldTypeDate", "alias": "ROW Initiation", "length": 8, "domain": null }, { "name": "FDPatRPMdate", "type": "esriFieldTypeDate", "alias": "FDP @ RPM", "length": 8, "domain": null }, { "name": "FDPatDesignApprovalDate", "type": "esriFieldTypeDate", "alias": "FDP @ Design Approval", "length": 8, "domain": null }, { "name": "CurrentADVdate", "type": "esriFieldTypeDate", "alias": "Current ADV", "length": 8, "domain": null }, { "name": "CurrentDCDdate", "type": "esriFieldTypeDate", "alias": "Current DCD", "length": 8, "domain": null }, { "name": "CurrentFDPdate", "type": "esriFieldTypeDate", "alias": "Current FDP", "length": 8, "domain": null }, { "name": "ConstructionIntitiationDate", "type": "esriFieldTypeDate", "alias": "Construction Intitiation", "length": 8, "domain": null }, { "name": "AwardDate", "type": "esriFieldTypeDate", "alias": "Award Date", "length": 8, "domain": null }, { "name": "EstConstrCompletionAtAward", "type": "esriFieldTypeDate", "alias": "Estimated Construction Completion @ Award", "length": 8, "domain": null }, { "name": "NoticeToProceedDate", "type": "esriFieldTypeDate", "alias": "Notice To Proceed ", "length": 8, "domain": null }, { "name": "EstConstrCompletionDate", "type": "esriFieldTypeDate", "alias": "Estimated Construction Completion", "length": 8, "domain": null }, { "name": "ConstructionCompletionDate", "type": "esriFieldTypeDate", "alias": "Construction Completion", "length": 8, "domain": null }, { "name": "ProjectEndDate", "type": "esriFieldTypeDate", "alias": "Project End Date", "length": 8, "domain": null }, { "name": "ProjectEndDateReason", "type": "esriFieldTypeString", "alias": "Project End Date Reason", "length": 25, "domain": null }, { "name": "PEestimateAtDesignApproval", "type": "esriFieldTypeDouble", "alias": "PE Estimate @ Design Approval", "domain": null }, { "name": "PEexpenditures", "type": "esriFieldTypeDouble", "alias": "PE Expenditures", "domain": null }, { "name": "ROWExpenditures", "type": "esriFieldTypeDouble", "alias": "ROW Expenditures", "domain": null }, { "name": "ROWEstimate", "type": "esriFieldTypeDouble", "alias": "ROW Estimate", "domain": null }, { "name": "ConstructionEstimateAtRPM", "type": "esriFieldTypeDouble", "alias": "Construction Estimate @ RPM", "domain": null }, { "name": "ConstructionEstimateAtDesAppr", "type": "esriFieldTypeDouble", "alias": "Construction Estimate @ Design Approval", "domain": null }, { "name": "ConstructionEstimateAtDCD", "type": "esriFieldTypeDouble", "alias": "Construction Estimate @ DCD", "domain": null }, { "name": "CurrentConstructionEstimate", "type": "esriFieldTypeDouble", "alias": "Current Construction Estimate", "domain": null }, { "name": "OriginalContractValue", "type": "esriFieldTypeDouble", "alias": "Original Contract Value", "domain": null }, { "name": "RevisedContractValue", "type": "esriFieldTypeDouble", "alias": "Revised Contract Value", "domain": null }, { "name": "ConstructionExpenditures", "type": "esriFieldTypeDouble", "alias": "Construction Expenditures", "domain": null }, { "name": "TotalProjectEstimate", "type": "esriFieldTypeDouble", "alias": "Total Project Estimate", "domain": null }, { "name": "DesignPercentComplete", "type": "esriFieldTypeDouble", "alias": "Design Percent Complete", "domain": null }, { "name": "PrimaryDesigner", "type": "esriFieldTypeString", "alias": "Primary Designer", "length": 200, "domain": null }, { "name": "ProjectLeadEngineer", "type": "esriFieldTypeString", "alias": "Project Lead Engineer", "length": 50, "domain": null }, { "name": "BridgeEngineer", "type": "esriFieldTypeString", "alias": "Bridge Engineer", "length": 50, "domain": null }, { "name": "TrafficEngineer", "type": "esriFieldTypeString", "alias": "Traffic Engineer", "length": 50, "domain": null }, { "name": "ProjectManagerEmail", "type": "esriFieldTypeString", "alias": "Project Manager Email", "length": 50, "domain": null }, { "name": "ConsultantEngineer", "type": "esriFieldTypeString", "alias": "Consultant Engineer", "length": 200, "domain": null }, { "name": "ConstructionPercentComplete", "type": "esriFieldTypeDouble", "alias": "Construction Percent Complete", "domain": null }, { "name": "PrimaryInspector", "type": "esriFieldTypeString", "alias": "Primary Inspector", "length": 75, "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 200, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 500, "domain": null }, { "name": "ProjectManager", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 200, "domain": null }, { "name": "ConsultantInspector", "type": "esriFieldTypeString", "alias": "Consultant Inspector", "length": 75, "domain": null }, { "name": "SupervisingEngineer", "type": "esriFieldTypeString", "alias": "Supervising Engineer", "length": 75, "domain": null }, { "name": "SupervisingEngineerEmail", "type": "esriFieldTypeString", "alias": "Supervising Engineer Email", "length": 500, "domain": null }, { "name": "AsBuiltCompleted", "type": "esriFieldTypeString", "alias": "AsBuilt Completed", "length": 10, "domain": null }, { "name": "ConstructionDistrict", "type": "esriFieldTypeString", "alias": "Construction District", "length": 10, "domain": null }, { "name": "CapitalPlanPriority", "type": "esriFieldTypeString", "alias": "Capital Plan Priority", "length": 10, "domain": null }, { "name": "CapitalPlanPriorityDescription", "type": "esriFieldTypeString", "alias": "Capital Plan Priority Description", "length": 30, "domain": null }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 200, "domain": null }, { "name": "LastModifiedDate", "type": "esriFieldTypeDate", "alias": "LastModifiedDate", "length": 8, "domain": null }, { "name": "LastModifiedBy", "type": "esriFieldTypeString", "alias": "LastModifiedBy", "length": 50, "domain": null }, { "name": "DistrictID", "type": "esriFieldTypeString", "alias": "DistrictID", "length": 10, "domain": null }, { "name": "DocumentLink", "type": "esriFieldTypeString", "alias": "DocumentLink", "length": 150, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1262_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1262", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1262", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S943_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2500, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "3b610e155d71476d96ea849ad7e618e0" }