Name: Project Work Areas

Display Field: ProjectID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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".

Service Item Id: 3b610e155d71476d96ea849ad7e618e0

Copyright Text: Offices with DOT: AEC Applications, eGIS and OIS

Default Visibility: true

MaxRecordCount: 2500

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 726043.389490053
YMin: 543930.4291794002
XMax: 1263220.709162131
YMax: 947929.1323352307
Spatial Reference: 103016  (6434)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [245, 237, 171, 255]
Outline:
Style: esriSLSSolid
Color: [224, 210, 184, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ProjectID ( type: esriFieldTypeInteger, alias: Project ID )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• ProposedProjectNumber ( type: esriFieldTypeString, alias: Proposed Project Number, length: 50 )
• ContractNumber ( type: esriFieldTypeString, alias: Contract Number, length: 25 )
• InheritedProjects ( type: esriFieldTypeString, alias: Inherited Projects, length: 40 )
• ProgramNumber ( type: esriFieldTypeString, alias: Program Number, length: 25 )
• Title ( type: esriFieldTypeString, alias: Title, length: 200 )
• ProjectDescription ( type: esriFieldTypeString, alias: Project Description, length: 255 )
• ScopeCode ( type: esriFieldTypeString, alias: Scope Code, length: 25 )
• ProjectScopeCodeDescription ( type: esriFieldTypeString, alias: Project Scope Code Description, length: 50 )
• CTDOTImprovementType ( type: esriFieldTypeString, alias: CTDOT Improvement Type, length: 100 )
• FinancialPhases ( type: esriFieldTypeString, alias: Financial Phases, length: 20 )
• CurrentSchedulePhase ( type: esriFieldTypeString, alias: Current Schedule Phase, length: 35 )
• FHWAoversight ( type: esriFieldTypeString, alias: FHWA Oversight, length: 200 )
• STIPStatus ( type: esriFieldTypeString, alias: STIP Status, length: 20 )
• STIPstatusDescription ( type: esriFieldTypeString, alias: STIP Status Description, length: 50 )
• Towns ( type: esriFieldTypeString, alias: Towns, length: 500 )
• StateRoutes ( type: esriFieldTypeString, alias: State Routes, length: 500 )
• Bridges ( type: esriFieldTypeString, alias: Bridges, length: 1500 )
• PavementTreatment ( type: esriFieldTypeString, alias: Pavement Treatment, length: 75 )
• RetainingWalls ( type: esriFieldTypeString, alias: Retaining Walls, length: 500 )
• TrafficSignals ( type: esriFieldTypeString, alias: Traffic Signals, length: 1500 )
• SignSupports ( type: esriFieldTypeString, alias: Sign Supports, length: 500 )
• RPMdate ( type: esriFieldTypeDate, alias: RPM, length: 8 )
• ProjectInitiationDate ( type: esriFieldTypeDate, alias: Project Initiation, length: 8 )
• DesignApprovalDate ( type: esriFieldTypeDate, alias: Design Approval, length: 8 )
• ROWInitiationDate ( type: esriFieldTypeDate, alias: ROW Initiation, length: 8 )
• FDPatRPMdate ( type: esriFieldTypeDate, alias: FDP @ RPM, length: 8 )
• FDPatDesignApprovalDate ( type: esriFieldTypeDate, alias: FDP @ Design Approval, length: 8 )
• CurrentADVdate ( type: esriFieldTypeDate, alias: Current ADV, length: 8 )
• CurrentDCDdate ( type: esriFieldTypeDate, alias: Current DCD, length: 8 )
• CurrentFDPdate ( type: esriFieldTypeDate, alias: Current FDP, length: 8 )
• ConstructionIntitiationDate ( type: esriFieldTypeDate, alias: Construction Intitiation, length: 8 )
• AwardDate ( type: esriFieldTypeDate, alias: Award Date, length: 8 )
• EstConstrCompletionAtAward ( type: esriFieldTypeDate, alias: Estimated Construction Completion @ Award, length: 8 )
• NoticeToProceedDate ( type: esriFieldTypeDate, alias: Notice To Proceed , length: 8 )
• EstConstrCompletionDate ( type: esriFieldTypeDate, alias: Estimated Construction Completion, length: 8 )
• ConstructionCompletionDate ( type: esriFieldTypeDate, alias: Construction Completion, length: 8 )
• ProjectEndDate ( type: esriFieldTypeDate, alias: Project End Date, length: 8 )
• ProjectEndDateReason ( type: esriFieldTypeString, alias: Project End Date Reason, length: 25 )
• PEestimateAtDesignApproval ( type: esriFieldTypeDouble, alias: PE Estimate @ Design Approval )
• PEexpenditures ( type: esriFieldTypeDouble, alias: PE Expenditures )
• ROWExpenditures ( type: esriFieldTypeDouble, alias: ROW Expenditures )
• ROWEstimate ( type: esriFieldTypeDouble, alias: ROW Estimate )
• ConstructionEstimateAtRPM ( type: esriFieldTypeDouble, alias: Construction Estimate @ RPM )
• ConstructionEstimateAtDesAppr ( type: esriFieldTypeDouble, alias: Construction Estimate @ Design Approval )
• ConstructionEstimateAtDCD ( type: esriFieldTypeDouble, alias: Construction Estimate @ DCD )
• CurrentConstructionEstimate ( type: esriFieldTypeDouble, alias: Current Construction Estimate )
• OriginalContractValue ( type: esriFieldTypeDouble, alias: Original Contract Value )
• RevisedContractValue ( type: esriFieldTypeDouble, alias: Revised Contract Value )
• ConstructionExpenditures ( type: esriFieldTypeDouble, alias: Construction Expenditures )
• TotalProjectEstimate ( type: esriFieldTypeDouble, alias: Total Project Estimate )
• DesignPercentComplete ( type: esriFieldTypeDouble, alias: Design Percent Complete )
• PrimaryDesigner ( type: esriFieldTypeString, alias: Primary Designer, length: 200 )
• ProjectLeadEngineer ( type: esriFieldTypeString, alias: Project Lead Engineer, length: 50 )
• BridgeEngineer ( type: esriFieldTypeString, alias: Bridge Engineer, length: 50 )
• TrafficEngineer ( type: esriFieldTypeString, alias: Traffic Engineer, length: 50 )
• ProjectManagerEmail ( type: esriFieldTypeString, alias: Project Manager Email, length: 50 )
• ConsultantEngineer ( type: esriFieldTypeString, alias: Consultant Engineer, length: 200 )
• ConstructionPercentComplete ( type: esriFieldTypeDouble, alias: Construction Percent Complete )
• PrimaryInspector ( type: esriFieldTypeString, alias: Primary Inspector, length: 75 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 200 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 500 )
• ProjectManager ( type: esriFieldTypeString, alias: Project Manager, length: 200 )
• ConsultantInspector ( type: esriFieldTypeString, alias: Consultant Inspector, length: 75 )
• SupervisingEngineer ( type: esriFieldTypeString, alias: Supervising Engineer, length: 75 )
• SupervisingEngineerEmail ( type: esriFieldTypeString, alias: Supervising Engineer Email, length: 500 )
• AsBuiltCompleted ( type: esriFieldTypeString, alias: AsBuilt Completed, length: 10 )
• ConstructionDistrict ( type: esriFieldTypeString, alias: Construction District, length: 10 )
• CapitalPlanPriority ( type: esriFieldTypeString, alias: Capital Plan Priority, length: 10 )
• CapitalPlanPriorityDescription ( type: esriFieldTypeString, alias: Capital Plan Priority Description, length: 30 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 200 )
• LastModifiedDate ( type: esriFieldTypeDate, alias: LastModifiedDate, length: 8 )
• LastModifiedBy ( type: esriFieldTypeString, alias: LastModifiedBy, length: 50 )
• DistrictID ( type: esriFieldTypeString, alias: DistrictID, length: 10 )
• DocumentLink ( type: esriFieldTypeString, alias: DocumentLink, length: 150 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata