{
 "layers": [
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 0,
   "name": "sbgis.DBO.ProcureDashboard_Poly",
   "type": "Feature Layer",
   "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>",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102100,
    "latestWkid": 3857,
    "xyTolerance": 0.001,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -20037700,
    "falseY": -30241100,
    "xyUnits": 10000,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "CC0",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       0,
       100,
       255,
       93
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        110,
        110,
        110,
        255
       ],
       "width": 1
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -1.31035937599E7,
    "ymin": 4030852.7764,
    "xmax": -1.30348938004E7,
    "ymax": 4146979.3554000035,
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857,
     "xyTolerance": 0.001,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -20037700,
     "falseY": -30241100,
     "xyUnits": 10000,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "NAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "NAME",
     "type": "esriFieldTypeString",
     "alias": "NAME",
     "length": 50,
     "domain": null
    },
    {
     "name": "TO_",
     "type": "esriFieldTypeString",
     "alias": "To",
     "length": 50,
     "domain": null
    },
    {
     "name": "FROM_",
     "type": "esriFieldTypeString",
     "alias": "From",
     "length": 50,
     "domain": null
    },
    {
     "name": "SBCTA_ID",
     "type": "esriFieldTypeString",
     "alias": "SBCTA_ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "FTIP_ID",
     "type": "esriFieldTypeString",
     "alias": "FTIP_ID",
     "length": 50,
     "domain": null
    },
    {
     "name": "Contract_number",
     "type": "esriFieldTypeString",
     "alias": "Contract number",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Contractor_name",
     "type": "esriFieldTypeString",
     "alias": "Contractor name",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Short_description",
     "type": "esriFieldTypeString",
     "alias": "Short description",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Contract_total",
     "type": "esriFieldTypeDouble",
     "alias": "Contract total",
     "domain": null
    },
    {
     "name": "Expenditures",
     "type": "esriFieldTypeDouble",
     "alias": "Expenditures",
     "domain": null
    },
    {
     "name": "Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency",
     "domain": null
    },
    {
     "name": "Contingency_Increase",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency Increase",
     "domain": null
    },
    {
     "name": "Settlements",
     "type": "esriFieldTypeDouble",
     "alias": "Settlements",
     "domain": null
    },
    {
     "name": "Under_budget",
     "type": "esriFieldTypeDouble",
     "alias": "Under budget",
     "domain": null
    },
    {
     "name": "Managing_Dept",
     "type": "esriFieldTypeString",
     "alias": "Managing Dept",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Actual_start",
     "type": "esriFieldTypeDate",
     "alias": "Actual start",
     "length": 8,
     "domain": null
    },
    {
     "name": "Original_Int",
     "type": "esriFieldTypeDouble",
     "alias": "Original_Int",
     "domain": null
    },
    {
     "name": "FTIP_ID_1",
     "type": "esriFieldTypeString",
     "alias": "FTIP_ID_1",
     "length": 30,
     "domain": null
    },
    {
     "name": "SBCTA_ID_1",
     "type": "esriFieldTypeString",
     "alias": "SBCTA_ID_1",
     "length": 30,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "Shape.area",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.area",
     "domain": null
    },
    {
     "name": "Shape.len",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.len",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R1190_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "a1168_ix1",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": true,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "supportsDatumTransformation": true,
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true
  }
 ],
 "tables": [
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 1,
   "name": "sbgis.DBO.ProcureDashboard",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Contractor_name",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "OBJECTID_1",
     "type": "esriFieldTypeInteger",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Contract_number",
     "type": "esriFieldTypeString",
     "alias": "Contract_number",
     "length": 255,
     "domain": null
    },
    {
     "name": "Contractor_name",
     "type": "esriFieldTypeString",
     "alias": "Contractor_name",
     "length": 255,
     "domain": null
    },
    {
     "name": "Short_description",
     "type": "esriFieldTypeString",
     "alias": "Short_description",
     "length": 255,
     "domain": null
    },
    {
     "name": "Contract_total",
     "type": "esriFieldTypeDouble",
     "alias": "Contract_total",
     "domain": null
    },
    {
     "name": "Expenditures",
     "type": "esriFieldTypeString",
     "alias": "Expenditures",
     "length": 255,
     "domain": null
    },
    {
     "name": "Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency",
     "domain": null
    },
    {
     "name": "Contingency_Increase",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency_Increase",
     "domain": null
    },
    {
     "name": "Settlements",
     "type": "esriFieldTypeInteger",
     "alias": "Settlements",
     "domain": null
    },
    {
     "name": "Under_budget",
     "type": "esriFieldTypeString",
     "alias": "Under_budget",
     "length": 255,
     "domain": null
    },
    {
     "name": "Managing_Dept",
     "type": "esriFieldTypeString",
     "alias": "Managing_Dept",
     "length": 255,
     "domain": null
    },
    {
     "name": "Actual_start",
     "type": "esriFieldTypeDate",
     "alias": "Actual_start",
     "length": 8,
     "domain": null
    },
    {
     "name": "Original_Int",
     "type": "esriFieldTypeDouble",
     "alias": "Original_Int",
     "domain": null
    },
    {
     "name": "FTIP_ID",
     "type": "esriFieldTypeString",
     "alias": "FTIP_ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "SBCTA_ID",
     "type": "esriFieldTypeString",
     "alias": "SBCTA_ID",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R1265_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 2,
   "name": "sbgis.DBO.ProcureDashboard_v2",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Breakdown",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Breakdown",
     "type": "esriFieldTypeString",
     "alias": "Breakdown",
     "length": 12,
     "domain": null
    },
    {
     "name": "Brkdwn_Cat",
     "type": "esriFieldTypeString",
     "alias": "Brkdwn_Cat",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "Contract_total",
     "type": "esriFieldTypeDouble",
     "alias": "Contract total",
     "domain": null
    },
    {
     "name": "Expenditures",
     "type": "esriFieldTypeDouble",
     "alias": "Expenditures",
     "domain": null
    },
    {
     "name": "Original",
     "type": "esriFieldTypeDouble",
     "alias": "Original",
     "domain": null
    },
    {
     "name": "Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency",
     "domain": null
    },
    {
     "name": "Contingency_Increase",
     "type": "esriFieldTypeDouble",
     "alias": "Contingency Increase",
     "domain": null
    },
    {
     "name": "Settlements",
     "type": "esriFieldTypeDouble",
     "alias": "Settlements",
     "domain": null
    },
    {
     "name": "Under_budget",
     "type": "esriFieldTypeDouble",
     "alias": "Under budget",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R1186_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.81,
   "cimVersion": "2.6.0",
   "id": 6,
   "name": "sbgis.DBO.ProcureDashboard_v3",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "Project_Name",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Project_Name",
     "type": "esriFieldTypeString",
     "alias": "Project Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "Board_Approved_Budget",
     "type": "esriFieldTypeDouble",
     "alias": "Board Approved Budget",
     "domain": null
    },
    {
     "name": "Current_Estimated_Budget",
     "type": "esriFieldTypeDouble",
     "alias": "Current Estimated Budget",
     "domain": null
    },
    {
     "name": "Total_Expenditure_to_Date",
     "type": "esriFieldTypeDouble",
     "alias": "Total Expenditure to Date",
     "domain": null
    },
    {
     "name": "Construction_Expenditure",
     "type": "esriFieldTypeDouble",
     "alias": "Construction Expenditure",
     "domain": null
    },
    {
     "name": "CM_Contract_",
     "type": "esriFieldTypeString",
     "alias": "CM Contract#",
     "length": 255,
     "domain": null
    },
    {
     "name": "CM_Vendor",
     "type": "esriFieldTypeString",
     "alias": "CM Vendor",
     "length": 255,
     "domain": null
    },
    {
     "name": "CM_Contract_Original",
     "type": "esriFieldTypeDouble",
     "alias": "CM Contract Original",
     "domain": null
    },
    {
     "name": "CM_Change_order",
     "type": "esriFieldTypeString",
     "alias": "CM Change order",
     "length": 255,
     "domain": null
    },
    {
     "name": "CM_Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "CM Contingency",
     "domain": null
    },
    {
     "name": "CM_Contingency_Change",
     "type": "esriFieldTypeString",
     "alias": "CM Contingency Change",
     "length": 255,
     "domain": null
    },
    {
     "name": "CM_Contingency__Release_Typical",
     "type": "esriFieldTypeDouble",
     "alias": "CM Contingency  Release Typical",
     "domain": null
    },
    {
     "name": "CM_Contingency__Release_Non_Typ",
     "type": "esriFieldTypeDouble",
     "alias": "CM Contingency  Release Non Typical",
     "domain": null
    },
    {
     "name": "CM_Remaining_Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "CM Remaining Contingency",
     "domain": null
    },
    {
     "name": "CM_Current_Contract",
     "type": "esriFieldTypeDouble",
     "alias": "CM Current Contract",
     "domain": null
    },
    {
     "name": "CM_Expenditure",
     "type": "esriFieldTypeDouble",
     "alias": "CM Expenditure",
     "domain": null
    },
    {
     "name": "CM__Remaining",
     "type": "esriFieldTypeDouble",
     "alias": "CM  Remaining",
     "domain": null
    },
    {
     "name": "CM____Expenditure",
     "type": "esriFieldTypeDouble",
     "alias": "CM % _Expenditure",
     "domain": null
    },
    {
     "name": "CC_Contract_",
     "type": "esriFieldTypeString",
     "alias": "CC Contract#",
     "length": 255,
     "domain": null
    },
    {
     "name": "CC_Vendor",
     "type": "esriFieldTypeString",
     "alias": "CC Vendor",
     "length": 255,
     "domain": null
    },
    {
     "name": "CC_Original",
     "type": "esriFieldTypeDouble",
     "alias": "CC Original",
     "domain": null
    },
    {
     "name": "CC_Change_Order_Typical",
     "type": "esriFieldTypeDouble",
     "alias": "CC Change Order Typical",
     "domain": null
    },
    {
     "name": "CC_Change_Order_Non_Typical",
     "type": "esriFieldTypeDouble",
     "alias": "CC Change Order Non Typical",
     "domain": null
    },
    {
     "name": "CC_Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "CC Contingency",
     "domain": null
    },
    {
     "name": "CC_Contingency_Change",
     "type": "esriFieldTypeDouble",
     "alias": "CC Contingency Change",
     "domain": null
    },
    {
     "name": "CC_Remaining_Contingency",
     "type": "esriFieldTypeDouble",
     "alias": "CC Remaining Contingency",
     "domain": null
    },
    {
     "name": "CC_Current_Contract",
     "type": "esriFieldTypeDouble",
     "alias": "CC Current Contract",
     "domain": null
    },
    {
     "name": "CC_Expenditure",
     "type": "esriFieldTypeDouble",
     "alias": "CC Expenditure",
     "domain": null
    },
    {
     "name": "CC_Remaining",
     "type": "esriFieldTypeDouble",
     "alias": "CC Remaining",
     "domain": null
    },
    {
     "name": "CC____Expenditure",
     "type": "esriFieldTypeString",
     "alias": "CC % _Expenditure",
     "length": 255,
     "domain": null
    },
    {
     "name": "Other_Const_Expenditure",
     "type": "esriFieldTypeDouble",
     "alias": "Other Const Expenditure",
     "domain": null
    },
    {
     "name": "CM_Contingency_Line",
     "type": "esriFieldTypeDouble",
     "alias": "CM Contingency Line",
     "domain": null
    },
    {
     "name": "CC_Contingency_Line",
     "type": "esriFieldTypeDouble",
     "alias": "CC Contingency Line",
     "domain": null
    },
    {
     "name": "CM_Original_Contingency_Change",
     "type": "esriFieldTypeDouble",
     "alias": "CM Original_Contingency_Change",
     "domain": null
    },
    {
     "name": "CC_Original_Contingency__Change",
     "type": "esriFieldTypeDouble",
     "alias": "CC Original_Contingency _Change",
     "domain": null
    },
    {
     "name": "Department",
     "type": "esriFieldTypeString",
     "alias": "Department",
     "length": 255,
     "domain": null
    },
    {
     "name": "CMChangeOrder_Num",
     "type": "esriFieldTypeInteger",
     "alias": "CM Change Order",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R1503_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true
   },
   "dateFieldsTimeReference": null,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}