Layers:

Layer: sbgis.DBO.ProcureDashboard_Poly (0)

Name: sbgis.DBO.ProcureDashboard_Poly

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Extents show projects throughout San Bernardino County currently under contract with SBCTA. Extents and attributes are as of December 2019. Attributes include:</SPAN></P><UL><LI><P><SPAN>IDs from FTIP database and SBCTA contract numbers</SPAN></P></LI><LI><P><SPAN>Contractor name and short description of project</SPAN></P></LI><LI><P><SPAN>Contract total, contingency, and settlement costs</SPAN></P></LI><LI><P><SPAN>SBCTA department managing contract and actual project start date</SPAN></P></LI></UL></DIV></DIV>

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• TO_ ( type: esriFieldTypeString, alias: To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TO_ )
• FROM_ ( type: esriFieldTypeString, alias: From, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FROM_ )
• SBCTA_ID ( type: esriFieldTypeString, alias: SBCTA_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SBCTA_ID )
• FTIP_ID ( type: esriFieldTypeString, alias: FTIP_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FTIP_ID )
• Contract_number ( type: esriFieldTypeString, alias: Contract number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Contract_number )
• Contractor_name ( type: esriFieldTypeString, alias: Contractor name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Contractor_name )
• Short_description ( type: esriFieldTypeString, alias: Short description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Short_description )
• Contract_total ( type: esriFieldTypeDouble, alias: Contract total, editable: true, nullable: true, defaultValue: null, modelName: Contract_total )
• Expenditures ( type: esriFieldTypeDouble, alias: Expenditures, editable: true, nullable: true, defaultValue: null, modelName: Expenditures )
• Contingency ( type: esriFieldTypeDouble, alias: Contingency, editable: true, nullable: true, defaultValue: null, modelName: Contingency )
• Contingency_Increase ( type: esriFieldTypeDouble, alias: Contingency Increase, editable: true, nullable: true, defaultValue: null, modelName: Contingency_Increase )
• Settlements ( type: esriFieldTypeDouble, alias: Settlements, editable: true, nullable: true, defaultValue: null, modelName: Settlements )
• Under_budget ( type: esriFieldTypeDouble, alias: Under budget, editable: true, nullable: true, defaultValue: null, modelName: Under_budget )
• Managing_Dept ( type: esriFieldTypeString, alias: Managing Dept, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Managing_Dept )
• Actual_start ( type: esriFieldTypeDate, alias: Actual start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Actual_start )
• Original_Int ( type: esriFieldTypeDouble, alias: Original_Int, editable: true, nullable: true, defaultValue: null, modelName: Original_Int )
• FTIP_ID_1 ( type: esriFieldTypeString, alias: FTIP_ID_1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FTIP_ID )
• SBCTA_ID_1 ( type: esriFieldTypeString, alias: SBCTA_ID_1, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SBCTA_ID )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.area, editable: false, nullable: false, defaultValue: null, modelName: Shape.area )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.len, editable: false, nullable: false, defaultValue: null, modelName: Shape.len )
Templates:
• Name: sbgis.DBO.ProcureDashboard_Poly
  Description:
  Prototype:
  SBCTA_ID_1: null
  FTIP_ID_1: null
  NAME: null
  TO_: null
  FROM_: null
  SBCTA_ID: null
  FTIP_ID: null
  Contract_number: null
  Contractor_name: null
  Short_description: null
  Contract_total: null
  Expenditures: null
  Contingency: null
  Contingency_Increase: null
  Settlements: null
  Under_budget: null
  Managing_Dept: null
  Actual_start: null
  Original_Int: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Tables:

Table: sbgis.DBO.ProcureDashboard (1)

Name: sbgis.DBO.ProcureDashboard

Display Field: Contractor_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_1 )
• Contract_number ( type: esriFieldTypeString, alias: Contract_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contract_number )
• Contractor_name ( type: esriFieldTypeString, alias: Contractor_name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor_name )
• Short_description ( type: esriFieldTypeString, alias: Short_description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Short_description )
• Contract_total ( type: esriFieldTypeDouble, alias: Contract_total, editable: true, nullable: true, defaultValue: null, modelName: Contract_total )
• Expenditures ( type: esriFieldTypeString, alias: Expenditures, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Expenditures )
• Contingency ( type: esriFieldTypeDouble, alias: Contingency, editable: true, nullable: true, defaultValue: null, modelName: Contingency )
• Contingency_Increase ( type: esriFieldTypeDouble, alias: Contingency_Increase, editable: true, nullable: true, defaultValue: null, modelName: Contingency_Increase )
• Settlements ( type: esriFieldTypeInteger, alias: Settlements, editable: true, nullable: true, defaultValue: null, modelName: Settlements )
• Under_budget ( type: esriFieldTypeString, alias: Under_budget, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Under_budget )
• Managing_Dept ( type: esriFieldTypeString, alias: Managing_Dept, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Managing_Dept )
• Actual_start ( type: esriFieldTypeDate, alias: Actual_start, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Actual_start )
• Original_Int ( type: esriFieldTypeDouble, alias: Original_Int, editable: true, nullable: true, defaultValue: null, modelName: Original_Int )
• FTIP_ID ( type: esriFieldTypeString, alias: FTIP_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FTIP_ID )
• SBCTA_ID ( type: esriFieldTypeString, alias: SBCTA_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SBCTA_ID )
Templates:
• Name: sbgis.DBO.ProcureDashboard
  Description:
  Prototype:
  FTIP_ID: null
  SBCTA_ID: null
  OBJECTID_1: null
  Contract_number: null
  Contractor_name: null
  Short_description: null
  Contract_total: null
  Expenditures: null
  Contingency: null
  Contingency_Increase: null
  Settlements: null
  Under_budget: null
  Managing_Dept: null
  Actual_start: null
  Original_Int: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: sbgis.DBO.ProcureDashboard_v2 (2)

Name: sbgis.DBO.ProcureDashboard_v2

Display Field: Breakdown

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Breakdown ( type: esriFieldTypeString, alias: Breakdown, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Breakdown )
• Brkdwn_Cat ( type: esriFieldTypeString, alias: Brkdwn_Cat, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Brkdwn_Cat )
• Contract_total ( type: esriFieldTypeDouble, alias: Contract total, editable: true, nullable: true, defaultValue: null, modelName: Contract_total )
• Expenditures ( type: esriFieldTypeDouble, alias: Expenditures, editable: true, nullable: true, defaultValue: null, modelName: Expenditures )
• Original ( type: esriFieldTypeDouble, alias: Original, editable: true, nullable: true, defaultValue: null, modelName: Original )
• Contingency ( type: esriFieldTypeDouble, alias: Contingency, editable: true, nullable: true, defaultValue: null, modelName: Contingency )
• Contingency_Increase ( type: esriFieldTypeDouble, alias: Contingency Increase, editable: true, nullable: true, defaultValue: null, modelName: Contingency_Increase )
• Settlements ( type: esriFieldTypeDouble, alias: Settlements, editable: true, nullable: true, defaultValue: null, modelName: Settlements )
• Under_budget ( type: esriFieldTypeDouble, alias: Under budget, editable: true, nullable: true, defaultValue: null, modelName: Under_budget )
Templates:
• Name: sbgis.DBO.ProcureDashboard_v2
  Description:
  Prototype:
  Settlements: null
  Under_budget: null
  Breakdown: null
  Brkdwn_Cat: null
  Contract_total: null
  Expenditures: null
  Original: null
  Contingency: null
  Contingency_Increase: null
  
  Drawing Tool: esriFeatureEditToolNone

Table: sbgis.DBO.ProcureDashboard_v3 (6)

Name: sbgis.DBO.ProcureDashboard_v3

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Project_Name ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project_Name )
• Board_Approved_Budget ( type: esriFieldTypeDouble, alias: Board Approved Budget, editable: true, nullable: true, defaultValue: null, modelName: Board_Approved_Budget )
• Current_Estimated_Budget ( type: esriFieldTypeDouble, alias: Current Estimated Budget, editable: true, nullable: true, defaultValue: null, modelName: Current_Estimated_Budget )
• Total_Expenditure_to_Date ( type: esriFieldTypeDouble, alias: Total Expenditure to Date, editable: true, nullable: true, defaultValue: null, modelName: Total_Expenditure_to_Date )
• Construction_Expenditure ( type: esriFieldTypeDouble, alias: Construction Expenditure, editable: true, nullable: true, defaultValue: null, modelName: Construction_Expenditure )
• CM_Contract_ ( type: esriFieldTypeString, alias: CM Contract#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CM_Contract_ )
• CM_Vendor ( type: esriFieldTypeString, alias: CM Vendor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CM_Vendor )
• CM_Contract_Original ( type: esriFieldTypeDouble, alias: CM Contract Original, editable: true, nullable: true, defaultValue: null, modelName: CM_Contract_Original )
• CM_Change_order ( type: esriFieldTypeString, alias: CM Change order, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CM_Change_order )
• CM_Contingency ( type: esriFieldTypeDouble, alias: CM Contingency, editable: true, nullable: true, defaultValue: null, modelName: CM_Contingency )
• CM_Contingency_Change ( type: esriFieldTypeString, alias: CM Contingency Change, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CM_Contingency_Change )
• CM_Contingency__Release_Typical ( type: esriFieldTypeDouble, alias: CM Contingency Release Typical, editable: true, nullable: true, defaultValue: null, modelName: CM_Contingency__Release_Typical )
• CM_Contingency__Release_Non_Typ ( type: esriFieldTypeDouble, alias: CM Contingency Release Non Typical, editable: true, nullable: true, defaultValue: null, modelName: CM_Contingency__Release_Non_Typ )
• CM_Remaining_Contingency ( type: esriFieldTypeDouble, alias: CM Remaining Contingency, editable: true, nullable: true, defaultValue: null, modelName: CM_Remaining_Contingency )
• CM_Current_Contract ( type: esriFieldTypeDouble, alias: CM Current Contract, editable: true, nullable: true, defaultValue: null, modelName: CM_Current_Contract )
• CM_Expenditure ( type: esriFieldTypeDouble, alias: CM Expenditure, editable: true, nullable: true, defaultValue: null, modelName: CM_Expenditure )
• CM__Remaining ( type: esriFieldTypeDouble, alias: CM Remaining, editable: true, nullable: true, defaultValue: null, modelName: CM__Remaining )
• CM____Expenditure ( type: esriFieldTypeDouble, alias: CM % _Expenditure, editable: true, nullable: true, defaultValue: null, modelName: CM____Expenditure )
• CC_Contract_ ( type: esriFieldTypeString, alias: CC Contract#, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CC_Contract_ )
• CC_Vendor ( type: esriFieldTypeString, alias: CC Vendor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CC_Vendor )
• CC_Original ( type: esriFieldTypeDouble, alias: CC Original, editable: true, nullable: true, defaultValue: null, modelName: CC_Original )
• CC_Change_Order_Typical ( type: esriFieldTypeDouble, alias: CC Change Order Typical, editable: true, nullable: true, defaultValue: null, modelName: CC_Change_Order_Typical )
• CC_Change_Order_Non_Typical ( type: esriFieldTypeDouble, alias: CC Change Order Non Typical, editable: true, nullable: true, defaultValue: null, modelName: CC_Change_Order_Non_Typical )
• CC_Contingency ( type: esriFieldTypeDouble, alias: CC Contingency, editable: true, nullable: true, defaultValue: null, modelName: CC_Contingency )
• CC_Contingency_Change ( type: esriFieldTypeDouble, alias: CC Contingency Change, editable: true, nullable: true, defaultValue: null, modelName: CC_Contingency_Change )
• CC_Remaining_Contingency ( type: esriFieldTypeDouble, alias: CC Remaining Contingency, editable: true, nullable: true, defaultValue: null, modelName: CC_Remaining_Contingency )
• CC_Current_Contract ( type: esriFieldTypeDouble, alias: CC Current Contract, editable: true, nullable: true, defaultValue: null, modelName: CC_Current_Contract )
• CC_Expenditure ( type: esriFieldTypeDouble, alias: CC Expenditure, editable: true, nullable: true, defaultValue: null, modelName: CC_Expenditure )
• CC_Remaining ( type: esriFieldTypeDouble, alias: CC Remaining, editable: true, nullable: true, defaultValue: null, modelName: CC_Remaining )
• CC____Expenditure ( type: esriFieldTypeString, alias: CC % _Expenditure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CC____Expenditure )
• Other_Const_Expenditure ( type: esriFieldTypeDouble, alias: Other Const Expenditure, editable: true, nullable: true, defaultValue: null, modelName: Other_Const_Expenditure )
• CM_Contingency_Line ( type: esriFieldTypeDouble, alias: CM Contingency Line, editable: true, nullable: true, defaultValue: null, modelName: CM_Contingency_Line )
• CC_Contingency_Line ( type: esriFieldTypeDouble, alias: CC Contingency Line, editable: true, nullable: true, defaultValue: null, modelName: CC_Contingency_Line )
• CM_Original_Contingency_Change ( type: esriFieldTypeDouble, alias: CM Original_Contingency_Change, editable: true, nullable: true, defaultValue: null, modelName: CM_Original_Contingency_Change )
• CC_Original_Contingency__Change ( type: esriFieldTypeDouble, alias: CC Original_Contingency _Change, editable: true, nullable: true, defaultValue: null, modelName: CC_Original_Contingency__Change )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Department )
• CMChangeOrder_Num ( type: esriFieldTypeInteger, alias: CM Change Order, editable: true, nullable: true, defaultValue: null, modelName: CMChangeOrder_Num )
Templates:
• Name: sbgis.DBO.ProcureDashboard_v3
  Description:
  Prototype:
  Department: null
  CMChangeOrder_Num: null
  Project_Name: null
  Board_Approved_Budget: null
  Current_Estimated_Budget: null
  Total_Expenditure_to_Date: null
  Construction_Expenditure: null
  CM_Contract_: null
  CM_Vendor: null
  CM_Contract_Original: null
  CM_Change_order: null
  CM_Contingency: null
  CM_Contingency_Change: null
  CM_Contingency__Release_Typical: null
  CM_Contingency__Release_Non_Typ: null
  CM_Remaining_Contingency: null
  CM_Current_Contract: null
  CM_Expenditure: null
  CM__Remaining: null
  CM____Expenditure: null
  CC_Contract_: null
  CC_Vendor: null
  CC_Original: null
  CC_Change_Order_Typical: null
  CC_Change_Order_Non_Typical: null
  CC_Contingency: null
  CC_Contingency_Change: null
  CC_Remaining_Contingency: null
  CC_Current_Contract: null
  CC_Expenditure: null
  CC_Remaining: null
  CC____Expenditure: null
  Other_Const_Expenditure: null
  CM_Contingency_Line: null
  CC_Contingency_Line: null
  CM_Original_Contingency_Change: null
  CC_Original_Contingency__Change: null
  
  Drawing Tool: esriFeatureEditToolNone