View In:   ArcGIS Online Map Viewer

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: 38cfa08163f54d259857962a0bd50436

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

Default Visibility: true

MaxRecordCount: 2500

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
Supports Returning Geometry Centroid: true
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: false
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:

Fields:

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

Templates:

• Name: Project Work Areas
  Description:
  Prototype:
  DocumentLink: null
  DistrictID: null
  ProjectID: null
  ProjectNumber: null
  ProposedProjectNumber: null
  ContractNumber: null
  InheritedProjects: null
  ProgramNumber: null
  Title: null
  ProjectDescription: null
  ScopeCode: null
  ProjectScopeCodeDescription: null
  CTDOTImprovementType: null
  FinancialPhases: null
  CurrentSchedulePhase: null
  FHWAoversight: null
  STIPStatus: null
  STIPstatusDescription: null
  Towns: null
  StateRoutes: null
  Bridges: null
  PavementTreatment: null
  RetainingWalls: null
  TrafficSignals: null
  SignSupports: null
  RPMdate: null
  ProjectInitiationDate: null
  DesignApprovalDate: null
  ROWInitiationDate: null
  FDPatRPMdate: null
  FDPatDesignApprovalDate: null
  CurrentADVdate: null
  CurrentDCDdate: null
  CurrentFDPdate: null
  ConstructionIntitiationDate: null
  AwardDate: null
  EstConstrCompletionAtAward: null
  NoticeToProceedDate: null
  EstConstrCompletionDate: null
  ConstructionCompletionDate: null
  ProjectEndDate: null
  ProjectEndDateReason: null
  PEestimateAtDesignApproval: null
  PEexpenditures: null
  ROWExpenditures: null
  ROWEstimate: null
  ConstructionEstimateAtRPM: null
  ConstructionEstimateAtDesAppr: null
  ConstructionEstimateAtDCD: null
  CurrentConstructionEstimate: null
  OriginalContractValue: null
  RevisedContractValue: null
  ConstructionExpenditures: null
  TotalProjectEstimate: null
  DesignPercentComplete: null
  PrimaryDesigner: null
  ProjectLeadEngineer: null
  BridgeEngineer: null
  TrafficEngineer: null
  ProjectManagerEmail: null
  ConsultantEngineer: null
  ConstructionPercentComplete: null
  PrimaryInspector: null
  Contractor: null
  Inspector: null
  ProjectManager: null
  ConsultantInspector: null
  SupervisingEngineer: null
  SupervisingEngineerEmail: null
  AsBuiltCompleted: null
  ConstructionDistrict: null
  CapitalPlanPriority: null
  CapitalPlanPriorityDescription: null
  Remarks: null
  LastModifiedDate: null
  LastModifiedBy: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata