Name: Transportation Projects1

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 6e035e21715b4f58b4ec31ff2a489272

Copyright Text:

Default Visibility: true

MaxRecordCount: 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: -1.06710942788E7
YMin: 4291780.034500003
XMax: -1.06096691705E7
YMax: 4333646.2663
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: TR - Bridge
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [190, 232, 255, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 4
  Label: TR - Pedestrian
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [255, 255, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 3
  Label: TR - Retaining Wall
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [178, 178, 178, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 2
  Label: TR - Roadway
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [245, 202, 122, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 6
  Label: TR - Stormwater
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [0, 132, 168, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
• Value: 5
  Label: TR - Traffic
  Description: N/A
  Symbol:
  Style: esriSMSSquare
  Color: [255, 85, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 255, 255] Width: 0
Transparency: 0
Labeling Info:

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: ProjectID )
• ProjectNumber ( type: esriFieldTypeString, alias: Project Number, length: 200 )
• Name ( type: esriFieldTypeString, alias: Name, length: 255 )
• Program ( type: esriFieldTypeString, alias: Program, length: 100 , Coded Values: [1: Transportation] , [2: Environmental] , [3: Special Projects] , ...3 more... )
• Type ( type: esriFieldTypeString, alias: Type, length: 100 , Coded Values: [1: TR - Bridge] , [10: SP - Facilities] , [11: SP - Parks & Recreation] , ...21 more... )
• Discipline ( type: esriFieldTypeString, alias: Discipline, length: 500 , Coded Values: [100: Storm Sewer Systems] , [101: Open Channel] , [102: Box Culvert] , ...232 more... )
• Category ( type: esriFieldTypeString, alias: Category, length: 100 , Coded Values: [1: New Construction] , [2: Rehabilitation] , [3: Modification-Repairs] , ...2 more... )
• WorkflowState ( type: esriFieldTypeString, alias: State, length: 100 , Coded Values: [1: Draft] , [2: Submitted] , [3: Returned] , ...4 more... )
• InternalState ( type: esriFieldTypeString, alias: Project Status, length: 100 , Coded Values: [10: 04 - Construction] , [11: 05 - Maintenance] , [12: 06 - Closed] , ...3 more... )
• ExternalStatus ( type: esriFieldTypeString, alias: Status, length: 100 )
• Active ( type: esriFieldTypeSmallInteger, alias: Active , Coded Values: [0: False] , [1: True] )
• Scope ( type: esriFieldTypeString, alias: Scope, length: 1073741822 )
• ProjectEngineer ( type: esriFieldTypeString, alias: Project Engineer, length: 100 )
• DisciplineManager ( type: esriFieldTypeString, alias: Discipline Manage, length: 100 )
• ContractAdministrator ( type: esriFieldTypeString, alias: Contract Administrator, length: 100 )
• AEConsultant ( type: esriFieldTypeString, alias: AE Consultant, length: 100 )
• GC ( type: esriFieldTypeString, alias: General Contractor, length: 100 )
• ProjectTimeComplete ( type: esriFieldTypeSmallInteger, alias: Project Time %Complete )
• ProjectCostComplete ( type: esriFieldTypeInteger, alias: Project Cost %Complete )
• ProjectEffortScore ( type: esriFieldTypeInteger, alias: Project Effort Score )
• ProjectImpactScore ( type: esriFieldTypeInteger, alias: Project Impact Score )
• TotalProjectFunding ( type: esriFieldTypeInteger, alias: Total Project Funding )
• TotalProjectBudget ( type: esriFieldTypeInteger, alias: Total Project Budget )
• TotalCosts ( type: esriFieldTypeInteger, alias: Total Costs )
• PreDesignStageStart ( type: esriFieldTypeDate, alias: Pre-Design Stage Start, length: 8 )
• PreDesignWorkStart ( type: esriFieldTypeDate, alias: Pre-Design Work Start, length: 8 )
• PreDesignBufferStartBL ( type: esriFieldTypeDate, alias: Pre-Design Buffer Start BL, length: 8 )
• PreDesignStageFinish ( type: esriFieldTypeDate, alias: Pre-Design Stage Finish, length: 8 )
• PreDesignWorkFinish ( type: esriFieldTypeDate, alias: Pre-Design Work Finish, length: 8 )
• PreDesignBufferFinishBL ( type: esriFieldTypeDate, alias: Pre-Design Buffer FinishBL, length: 8 )
• PreDesignBudgets ( type: esriFieldTypeInteger, alias: Pre-Design Budgets )
• PreDesignCosts ( type: esriFieldTypeInteger, alias: Pre-Design Costs )
• PreDesignActualCosts ( type: esriFieldTypeInteger, alias: Pre-Design Actual Costs )
• PreDesignContractCosts ( type: esriFieldTypeInteger, alias: Pre-Design Contract Costs )
• PreDesignForecastCosts ( type: esriFieldTypeInteger, alias: Pre-Design Forecast Costs )
• PreDesignTimeComplete ( type: esriFieldTypeInteger, alias: Pre-Design Time %Complete )
• PreDesignCostComplete ( type: esriFieldTypeInteger, alias: Pre-Design Cost %Complete )
• DesignStageStart ( type: esriFieldTypeDate, alias: Design Stage Start, length: 8 )
• DesignWorkStart ( type: esriFieldTypeDate, alias: Design Work Start, length: 8 )
• DesignBufferStartBL ( type: esriFieldTypeDate, alias: Design Buffer Start BL, length: 8 )
• DesignStageFinish ( type: esriFieldTypeDate, alias: Design Stage Finish, length: 8 )
• DesignWorkFinish ( type: esriFieldTypeDate, alias: Design Work Finish, length: 8 )
• DesignBufferFinishBL ( type: esriFieldTypeDate, alias: Design Buffer FinishBL, length: 8 )
• DesignBudgets ( type: esriFieldTypeInteger, alias: Design Budgets )
• DesignCosts ( type: esriFieldTypeInteger, alias: Design Costs )
• DesignActualCosts ( type: esriFieldTypeInteger, alias: Design Actual Costs )
• DesignContractCosts ( type: esriFieldTypeInteger, alias: Design Contract Costs )
• DesignForecastCosts ( type: esriFieldTypeInteger, alias: Design Forecast Costs )
• DesignTimeComplete ( type: esriFieldTypeInteger, alias: Design Time %Complete )
• DesignCostComplete ( type: esriFieldTypeInteger, alias: Design Cost %Complete )
• SiteControlStageStart ( type: esriFieldTypeDate, alias: Site Control Stage Start, length: 8 )
• SiteControlWorkStart ( type: esriFieldTypeDate, alias: Site Control Work Start, length: 8 )
• SiteControlBufferStartBL ( type: esriFieldTypeDate, alias: Site Control Buffer Start BL, length: 8 )
• SiteControlStageFinish ( type: esriFieldTypeDate, alias: Site Control Stage Finish, length: 8 )
• SiteControlWorkFinish ( type: esriFieldTypeDate, alias: Site Control Work Finish, length: 8 )
• SiteControlBufferFinishBL ( type: esriFieldTypeDate, alias: Site Control Buffer Finish BL, length: 8 )
• SiteControlBudgets ( type: esriFieldTypeInteger, alias: Site Control Budgets )
• SiteControlCosts ( type: esriFieldTypeInteger, alias: Site Control Costs )
• SiteControlActualCosts ( type: esriFieldTypeInteger, alias: Site Control Actual Costs )
• SiteControlContractCosts ( type: esriFieldTypeInteger, alias: Site Control Contract Costs )
• SiteControlForecastCosts ( type: esriFieldTypeInteger, alias: Site Control Forecast Costs )
• SiteControlTimeCosts ( type: esriFieldTypeInteger, alias: Site Control Time %Complete )
• SiteControlCostComplete ( type: esriFieldTypeInteger, alias: Site Control Cost %Complete )
• ConstructionStageStart ( type: esriFieldTypeDate, alias: Construction Stage Start, length: 8 )
• ConstructionWorkStart ( type: esriFieldTypeDate, alias: Construction Work Start, length: 8 )
• ConstructionBufferStartBL ( type: esriFieldTypeDate, alias: Construction Buffer Start BL, length: 8 )
• ConstructionStageFinish ( type: esriFieldTypeDate, alias: Construction Stage Finish, length: 8 )
• ConstructionWorkFinish ( type: esriFieldTypeDate, alias: Construction Work Finish, length: 8 )
• ConstructionBufferFinishBL ( type: esriFieldTypeDate, alias: Construction Buffer Finish BL, length: 8 )
• FinalAcceptance ( type: esriFieldTypeDate, alias: Final Acceptance, length: 8 )
• ConstructionBudgets ( type: esriFieldTypeInteger, alias: Construction Budgets )
• ConstructionCosts ( type: esriFieldTypeInteger, alias: Construction Costs )
• ConstructionActualCosts ( type: esriFieldTypeInteger, alias: Construction Actual Costs )
• ConstructionContractCosts ( type: esriFieldTypeInteger, alias: Construction Contract Costs )
• ConstructionForecastCosts ( type: esriFieldTypeInteger, alias: Construction Forecast Costs )
• ConstructionTimeComplete ( type: esriFieldTypeInteger, alias: Construction Time %Complete )
• ConstructionCostComplete ( type: esriFieldTypeInteger, alias: Construction Cost %Complete )
• SiteParcelsCleared ( type: esriFieldTypeInteger, alias: Site Parcels Cleared )
• SiteUtilitiesCleared ( type: esriFieldTypeInteger, alias: Site Utilities Cleared )
• SitePermitsCleared ( type: esriFieldTypeInteger, alias: Site Permits Cleared )
• MinusYear1TotalCosts ( type: esriFieldTypeInteger, alias: Year-1 TotalCosts )
• Year0TotalCosts ( type: esriFieldTypeInteger, alias: Year0 TotalCosts )
• Year1TotalCosts ( type: esriFieldTypeInteger, alias: Year1 TotalCosts )
• Year2TotalCosts ( type: esriFieldTypeInteger, alias: Year2 TotalCosts )
• Year3TotalCosts ( type: esriFieldTypeInteger, alias: Year3 TotalCosts )
• Year4TotalCosts ( type: esriFieldTypeInteger, alias: Year4 TotalCosts )
• MinusYear1PreDesignCosts ( type: esriFieldTypeInteger, alias: Year-1 Pre-DesignCosts )
• Year0PreDesignCosts ( type: esriFieldTypeInteger, alias: Year0 Pre-DesignCosts )
• Year1PreDesignCosts ( type: esriFieldTypeInteger, alias: Year1 Pre-DesignCosts )
• Year2PreDesignCosts ( type: esriFieldTypeInteger, alias: Year2 Pre-DesignCosts )
• Year3PreDesignCosts ( type: esriFieldTypeInteger, alias: Year3 Pre-DesignCosts )
• MinusYear1DesignCosts ( type: esriFieldTypeInteger, alias: Year-1 Design Costs )
• Year0DesignCosts ( type: esriFieldTypeInteger, alias: Year0 Design Costs )
• Year1DesignCosts ( type: esriFieldTypeInteger, alias: Year1 Design Costs )
• Year2DesignCosts ( type: esriFieldTypeInteger, alias: Year2 Design Costs )
• Year3DesignCosts ( type: esriFieldTypeInteger, alias: Year3 Design Costs )
• Year4DesignCosts ( type: esriFieldTypeInteger, alias: Year4 Design Costs )
• MinusYear1SiteControlCosts ( type: esriFieldTypeInteger, alias: Year-1 SiteControlCosts )
• Year0SiteControlCosts ( type: esriFieldTypeInteger, alias: Year0 SiteControlCosts )
• Year1SiteControlCosts ( type: esriFieldTypeInteger, alias: Year1 SiteControlCosts )
• Year2SiteControlCosts ( type: esriFieldTypeInteger, alias: Year2 SiteControlCosts )
• Year3SiteControlCosts ( type: esriFieldTypeInteger, alias: Year3 SiteControlCosts )
• Year4SiteControlCosts ( type: esriFieldTypeInteger, alias: Year4 SiteControlCosts )
• MinusYear1ConstructionCosts ( type: esriFieldTypeInteger, alias: Year-1 ConstructionCosts )
• Year0ConstructionCosts ( type: esriFieldTypeInteger, alias: Year0 ConstructionCosts )
• Year1ConstructionCosts ( type: esriFieldTypeInteger, alias: Year1 ConstructionCosts )
• Year2ConstructionCosts ( type: esriFieldTypeInteger, alias: Year2 ConstructionCosts )
• Year3ConstructionCosts ( type: esriFieldTypeInteger, alias: Year3 ConstructionCosts )
• Year4ConstructionCosts ( type: esriFieldTypeInteger, alias: Year4 Construction Costs )
• MaintenanceContractCosts ( type: esriFieldTypeInteger, alias: Maintenance Contract Costs )
• Year0MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year0 Maintenance Costs )
• Year1MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year1 Maintenance Costs )
• Year2MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year2 Maintenance Costs )
• Year3MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year3 Maintenance Costs )
• Year4MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year4 Maintenance Costs )
• MinusYear1PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year-1 Pre-Design Budgets )
• Year0PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year0 Pre-Design Budgets )
• Year1PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year1 Pre-Design Budgets )
• Year2PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year2 Pre-Design Budgets )
• Year3PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year3 Pre-Design Budgets )
• Year4PreDesignBudgets ( type: esriFieldTypeInteger, alias: Year4 Pre-Design Budgets )
• MinusYear1DesignBudgets ( type: esriFieldTypeInteger, alias: Year-1 Design Budgets )
• Year0DesignBudgets ( type: esriFieldTypeInteger, alias: Year0 Design Budgets )
• Year1DesignBudgets ( type: esriFieldTypeInteger, alias: Year1 Design Budgets )
• Year2DesignBudgets ( type: esriFieldTypeInteger, alias: Year2 Design Budgets )
• Year3DesignBudgets ( type: esriFieldTypeInteger, alias: Year3 Design Budgets )
• Year4DesignBudgets ( type: esriFieldTypeInteger, alias: Year4 Design Budgets )
• MinusYear1SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year-1 Site Control Budgets )
• Year0SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year0 Site Control Budgets )
• Year1SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year1 Site Control Budgets )
• Year2SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year2 Site Control Budgets )
• Year3SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year3 Site Control Budgets )
• Year4SiteControlBudgets ( type: esriFieldTypeInteger, alias: Year4 Site Control Budgets )
• MinusYear1ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year-1 Construction Budgets )
• Year0ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year0 ConstructionBudgets )
• Year1ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year1 Construction Budgets )
• Year2ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year2 Construction Budgets )
• Year3ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year3 Construction Budgets )
• Year4ConstructionBudgets ( type: esriFieldTypeInteger, alias: Year4 Construction Budgets )
• MinusYear1Budget ( type: esriFieldTypeInteger, alias: Year-1 Budget )
• Year0Budget ( type: esriFieldTypeInteger, alias: Year0 Budget )
• Year1Budget ( type: esriFieldTypeInteger, alias: Year1 Budget )
• Year2Budget ( type: esriFieldTypeInteger, alias: Year2 Budget )
• Year3Budget ( type: esriFieldTypeInteger, alias: Year3 Budget )
• Year4Budget ( type: esriFieldTypeInteger, alias: Year4 Budget )
• MinusYear1Funding ( type: esriFieldTypeInteger, alias: Year-1 Funding )
• Year0Funding ( type: esriFieldTypeInteger, alias: Year0 Funding )
• Year1Funding ( type: esriFieldTypeInteger, alias: Year1 Funding )
• Year2Funding ( type: esriFieldTypeInteger, alias: Year2 Funding )
• Year3Funding ( type: esriFieldTypeInteger, alias: Year3 Funding )
• Year4Funding ( type: esriFieldTypeInteger, alias: Year4 Funding )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• UID ( type: esriFieldTypeInteger, alias: UID )
• 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.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• MaintenanceForecastCosts ( type: esriFieldTypeInteger, alias: Maintenance Forecast Costs )
• MinusYear1MaintenanceCosts ( type: esriFieldTypeInteger, alias: Year-1 Maintainance Costs )
• Year4PreDesignCosts ( type: esriFieldTypeInteger, alias: Year4PreDesignCosts )
• IsPublic ( type: esriFieldTypeSmallInteger, alias: IsPublic , Coded Values: [0: False] , [1: True] )
• DocLink ( type: esriFieldTypeString, alias: DocLink, length: 1073741822 )
• ScheduleStatus ( type: esriFieldTypeSmallInteger, alias: ScheduleStatus , Coded Values: [1: Draft] , [2: Submitted] , [3: Returned] , ...4 more... )

Relationships:

• DBO.Funding_Source (12) -- Related To: Funding Sources (17)

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

  Iteminfo   Thumbnail   Metadata