ArcGIS REST Services Directory
Login
Home
>
services
>
PM_Web
>
PMWeb_Projects (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (PM_Web/PMWeb_Projects)
Layers:
Layer:
Water Utility Projects1
(14)
Name:
Water Utility 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:
7
Label:
EN - Water
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 112, 255, 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 (0) --
Related To
:
Funding Sources
(17)
Layer:
Water Utility Projects
(0)
Name:
Water Utility Projects
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:
7
Label:
EN - Water
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[211, 255, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[0, 92, 230, 255]
Width:
3
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 (1) --
Related To
:
Funding Sources
(17)
Layer:
Sewer Utility Projects1
(13)
Name:
Sewer Utility 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:
9
Label:
EN - RMUA
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[171, 205, 102, 255]
Size:
8.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[255, 255, 255, 255]
Width:
0
Value:
8
Label:
EN - Waste Water
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 230, 169, 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 (2) --
Related To
:
Funding Sources
(17)
Layer:
Sewer Utility Projects
(1)
Name:
Sewer Utility Projects
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:
9
Label:
EN - RMUA
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[211, 255, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[171, 205, 102, 255]
Width:
3
Value:
8
Label:
EN - Waste Water
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[211, 255, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[0, 230, 169, 255]
Width:
3
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 (3) --
Related To
:
Funding Sources
(17)
Layer:
Stormwater/Drainage Projects1
(12)
Name:
Stormwater/Drainage 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:
15
Label:
SW - Collections
Description:
N/A
Symbol:
Style:
esriSMSSquare
Color:
[223, 115, 255, 255]
Size:
8.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[255, 255, 255, 255]
Width:
0
Value:
16
Label:
SW - Conveyance
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:
18
Label:
SW - Drainage Committee Project
Description:
N/A
Symbol:
Style:
esriSMSSquare
Color:
[205, 137, 102, 255]
Size:
8.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[255, 255, 255, 255]
Width:
0
Value:
17
Label:
SW - Stormwater Quality
Description:
N/A
Symbol:
Style:
esriSMSSquare
Color:
[209, 255, 115, 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 (4) --
Related To
:
Funding Sources
(17)
Layer:
Stormwater/Drainage Projects
(2)
Name:
Stormwater/Drainage Projects
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:
15
Label:
SW - Collections
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[190, 232, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[223, 115, 255, 255]
Width:
3
Value:
16
Label:
SW - Conveyance
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[190, 232, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[0, 132, 168, 255]
Width:
3
Value:
18
Label:
SW - Drainage Committee Project
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[190, 232, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[205, 137, 102, 255]
Width:
3
Value:
17
Label:
SW - Stormwater Quality
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[190, 232, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[209, 255, 115, 255]
Width:
3
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 (5) --
Related To
:
Funding Sources
(17)
Layer:
Quality of Life/Parks Projects1
(11)
Name:
Quality of Life/Parks 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:
11
Label:
SP - Parks & Recreation
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 0, 0, 0]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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 (6) --
Related To
:
Funding Sources
(17)
Layer:
Quality of Life/Parks Projects
(3)
Name:
Quality of Life/Parks Projects
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:
11
Label:
SP - Parks & Recreation
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 190, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[76, 230, 0, 255]
Width:
3
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 (7) --
Related To
:
Funding Sources
(17)
Layer:
City Facilities Projects1
(10)
Name:
City Facilities 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:
12
Label:
SP - Communications
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 0, 0, 0]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Value:
10
Label:
SP - Facilities
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 0, 0, 0]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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 (8) --
Related To
:
Funding Sources
(17)
Layer:
City Facilities Projects
(4)
Name:
City Facilities Projects
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:
12
Label:
SP - Communications
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 190, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[255, 0, 197, 255]
Width:
3
Value:
10
Label:
SP - Facilities
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 190, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[115, 76, 0, 255]
Width:
3
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 (9) --
Related To
:
Funding Sources
(17)
Layer:
Public Safety Projects1
(9)
Name:
Public Safety 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:
14
Label:
SP - Fire
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 0, 0, 0]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
Value:
13
Label:
SP - Police
Description:
N/A
Symbol:
Style:
esriSMSCircle
Color:
[0, 0, 0, 0]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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 (10) --
Related To
:
Funding Sources
(17)
Layer:
Public Safety Projects
(5)
Name:
Public Safety Projects
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:
14
Label:
SP - Fire
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 190, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[255, 0, 0, 255]
Width:
3
Value:
13
Label:
SP - Police
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 190, 190, 255]
Outline:
Style:
esriSLSSolid
Color:
[102, 119, 205, 255]
Width:
3
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 (11) --
Related To
:
Funding Sources
(17)
Layer:
Transportation Projects1
(8)
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)
Layer:
Transportation Projects
(6)
Name:
Transportation Projects
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:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[190, 232, 255, 255]
Width:
3
Value:
4
Label:
TR - Pedestrian
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[255, 255, 0, 255]
Width:
3
Value:
3
Label:
TR - Retaining Wall
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[178, 178, 178, 255]
Width:
3
Value:
2
Label:
TR - Roadway
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[245, 202, 122, 255]
Width:
3
Value:
6
Label:
TR - Stormwater
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[0, 132, 168, 255]
Width:
3
Value:
5
Label:
TR - Traffic
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 211, 127, 255]
Outline:
Style:
esriSLSSolid
Color:
[255, 85, 0, 255]
Width:
3
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 (13) --
Related To
:
Funding Sources
(17)
Tables:
Table:
Funding Sources
(17)
Name:
Funding Sources
Display Field:
ProjectName
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
6e035e21715b4f58b4ec31ff2a489272
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
ProjectId
( type: esriFieldTypeInteger, alias: ProjectId )
Active
( type: esriFieldTypeInteger, alias: Active ,
Coded Values:
[0: False] , [1: True] )
ProjectNumber
( type: esriFieldTypeString, alias: ProjectNumber, length: 1073741822 )
ProjectName
( type: esriFieldTypeString, alias: ProjectName, length: 1073741822 )
FundingSource
( type: esriFieldTypeString, alias: FundingSource, length: 1073741822 )
Amount
( type: esriFieldTypeString, alias: Amount, length: 1073741822 )
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 )
Relationships:
DBO.InfrastructureProjects (0) --
Related To
:
Water Utility Projects1
(14)
DBO.InfrastructureProjects (1) --
Related To
:
Water Utility Projects
(0)
DBO.InfrastructureProjects (2) --
Related To
:
Sewer Utility Projects1
(13)
DBO.InfrastructureProjects (3) --
Related To
:
Sewer Utility Projects
(1)
DBO.InfrastructureProjects (4) --
Related To
:
Stormwater/Drainage Projects1
(12)
DBO.InfrastructureProjects (5) --
Related To
:
Stormwater/Drainage Projects
(2)
DBO.InfrastructureProjects (6) --
Related To
:
Quality of Life/Parks Projects1
(11)
DBO.InfrastructureProjects (7) --
Related To
:
Quality of Life/Parks Projects
(3)
DBO.InfrastructureProjects (8) --
Related To
:
City Facilities Projects1
(10)
DBO.InfrastructureProjects (9) --
Related To
:
City Facilities Projects
(4)
DBO.InfrastructureProjects (10) --
Related To
:
Public Safety Projects1
(9)
DBO.InfrastructureProjects (11) --
Related To
:
Public Safety Projects
(5)
DBO.InfrastructureProjects (12) --
Related To
:
Transportation Projects1
(8)
DBO.InfrastructureProjects (13) --
Related To
:
Transportation Projects
(6)