Layers:

Layer: sbgis.DBO.ProcureDashboard_Poly (0)

Name: sbgis.DBO.ProcureDashboard_Poly

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Extents show projects throughout San Bernardino County currently under contract with SBCTA. Extents and attributes are as of December 2019. Attributes include:IDs from FTIP database and SBCTA contract numbersContractor name and short description of projectContract total, contingency, and settlement costsSBCTA department managing contract and actual project start date

Copyright Text: CC0

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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.31035937599E7
YMin: 4030852.7764
XMax: -1.30348938004E7
YMax: 4146979.3554000035
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 100, 255, 93]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 1
Label: N/A
Description: N/A
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 50 )
• TO_ ( type: esriFieldTypeString, alias: To, length: 50 )
• FROM_ ( type: esriFieldTypeString, alias: From, length: 50 )
• SBCTA_ID ( type: esriFieldTypeString, alias: SBCTA_ID, length: 50 )
• FTIP_ID ( type: esriFieldTypeString, alias: FTIP_ID, length: 50 )
• Contract_number ( type: esriFieldTypeString, alias: Contract number, length: 1073741822 )
• Contractor_name ( type: esriFieldTypeString, alias: Contractor name, length: 1073741822 )
• Short_description ( type: esriFieldTypeString, alias: Short description, length: 1073741822 )
• Contract_total ( type: esriFieldTypeDouble, alias: Contract total )
• Expenditures ( type: esriFieldTypeDouble, alias: Expenditures )
• Contingency ( type: esriFieldTypeDouble, alias: Contingency )
• Contingency_Increase ( type: esriFieldTypeDouble, alias: Contingency Increase )
• Settlements ( type: esriFieldTypeDouble, alias: Settlements )
• Under_budget ( type: esriFieldTypeDouble, alias: Under budget )
• Managing_Dept ( type: esriFieldTypeString, alias: Managing Dept, length: 1073741822 )
• Actual_start ( type: esriFieldTypeDate, alias: Actual start, length: 8 )
• Original_Int ( type: esriFieldTypeDouble, alias: Original_Int )
• FTIP_ID_1 ( type: esriFieldTypeString, alias: FTIP_ID_1, length: 30 )
• SBCTA_ID_1 ( type: esriFieldTypeString, alias: SBCTA_ID_1, length: 30 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.area ( type: esriFieldTypeDouble, alias: Shape.area )
• Shape.len ( type: esriFieldTypeDouble, alias: Shape.len )

Tables:

Table: sbgis.DBO.ProcureDashboard (1)

Name: sbgis.DBO.ProcureDashboard

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: null

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Project_Name ( type: esriFieldTypeString, alias: Project_Name, length: 1073741822 )
• Board_Approved_Budget ( type: esriFieldTypeInteger, alias: Board_Approved_Budget )
• Current_Estimated_Budget ( type: esriFieldTypeDouble, alias: Current_Estimated_Budget )
• Total_Expenditure_to_Date ( type: esriFieldTypeDouble, alias: Total_Expenditure_to_Date )
• Construction_Expenditure ( type: esriFieldTypeDouble, alias: Construction_Expenditure )
• CM_Contract_ ( type: esriFieldTypeString, alias: CM_Contract_, length: 1073741822 )
• CM_Vendor ( type: esriFieldTypeString, alias: CM_Vendor, length: 1073741822 )
• CM_Contract_Original ( type: esriFieldTypeDouble, alias: CM_Contract_Original )
• CM_Change_order ( type: esriFieldTypeDouble, alias: CM_Change_order )
• CM_Contingency ( type: esriFieldTypeDouble, alias: CM_Contingency )
• CM_Contingency_Change ( type: esriFieldTypeInteger, alias: CM_Contingency_Change )
• CM_Contingency__Release_Typical ( type: esriFieldTypeDouble, alias: CM_Contingency__Release_Typical )
• CM_Contingency__Release_Non_Typ ( type: esriFieldTypeInteger, alias: CM_Contingency__Release_Non_Typ )
• CM_Remaining_Contingency ( type: esriFieldTypeDouble, alias: CM_Remaining_Contingency )
• CM_Current_Contract ( type: esriFieldTypeDouble, alias: CM_Current_Contract )
• CM_Expenditure ( type: esriFieldTypeDouble, alias: CM_Expenditure )
• CM__Remaining ( type: esriFieldTypeDouble, alias: CM__Remaining )
• CM____Expenditure ( type: esriFieldTypeString, alias: CM____Expenditure, length: 1073741822 )
• CC_Contract_ ( type: esriFieldTypeString, alias: CC_Contract_, length: 1073741822 )
• CC_Vendor ( type: esriFieldTypeString, alias: CC_Vendor, length: 1073741822 )
• CC_Original ( type: esriFieldTypeDouble, alias: CC_Original )
• CC_Change_Order_Typical ( type: esriFieldTypeDouble, alias: CC_Change_Order_Typical )
• CC_Change_Order_Non_Typical ( type: esriFieldTypeDouble, alias: CC_Change_Order_Non_Typical )
• CC_Change_Order ( type: esriFieldTypeDouble, alias: CC_Change_Order )
• CC_Contingency ( type: esriFieldTypeDouble, alias: CC_Contingency )
• CC_Contingency_Change ( type: esriFieldTypeInteger, alias: CC_Contingency_Change )
• CC_Remaining_Contingency ( type: esriFieldTypeDouble, alias: CC_Remaining_Contingency )
• CC_Current_Contract ( type: esriFieldTypeDouble, alias: CC_Current_Contract )
• CC_Expenditure ( type: esriFieldTypeDouble, alias: CC_Expenditure )
• CC_Remaining ( type: esriFieldTypeDouble, alias: CC_Remaining )
• CC____Expenditure ( type: esriFieldTypeString, alias: CC____Expenditure, length: 1073741822 )
• Other_Const_Expenditure ( type: esriFieldTypeDouble, alias: Other_Const_Expenditure )
• CM_Contingency_Line ( type: esriFieldTypeDouble, alias: CM_Contingency_Line )
• CC_Contingency_Line ( type: esriFieldTypeDouble, alias: CC_Contingency_Line )
• CM_Original_Contingency_Change ( type: esriFieldTypeDouble, alias: CM_Original_Contingency_Change )
• CC_Original_Contingency__Change ( type: esriFieldTypeDouble, alias: CC_Original_Contingency__Change )
• Department ( type: esriFieldTypeString, alias: Department, length: 1073741822 )
• CMChangeOrder_Num ( type: esriFieldTypeDouble, alias: CMChangeOrder_Num )