{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 15,
 "name": "Water CIP Table",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 1,
   "name": "CIPProjectsLocations",
   "relatedTableId": 1,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "CIPComponent",
   "composite": false,
   "catalogID": "{20A69A1B-CBFC-4602-AAFB-8114B8AE8275}"
  },
  {
   "id": 5,
   "name": "CIPProjects",
   "relatedTableId": 10,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "CIPComponent",
   "composite": false,
   "catalogID": "{A6C2B198-A733-4007-BCD8-AB7CFB1CBDD4}"
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "Project_Name",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "CIPID",
   "type": "esriFieldTypeString",
   "alias": "CIPID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CIPID"
  },
  {
   "name": "Project_Name",
   "type": "esriFieldTypeString",
   "alias": "Project_Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Project_Name"
  },
  {
   "name": "Segment_ID",
   "type": "esriFieldTypeInteger",
   "alias": "Segment_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Segment_ID"
  },
  {
   "name": "GIS_FacilityIDs",
   "type": "esriFieldTypeString",
   "alias": "GIS_FacilityIDs",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "GIS_FacilityIDs"
  },
  {
   "name": "CIPID_Priority",
   "type": "esriFieldTypeString",
   "alias": "CIPID_Priority",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CIPID_Priority"
  },
  {
   "name": "Year_Priority",
   "type": "esriFieldTypeString",
   "alias": "Year_Priority",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Year_Priority"
  },
  {
   "name": "Proposed_Fyear",
   "type": "esriFieldTypeInteger",
   "alias": "Proposed_Fyear",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Proposed_Fyear"
  },
  {
   "name": "Completion_Date",
   "type": "esriFieldTypeString",
   "alias": "Completion_Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Completion_Date"
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Status"
  },
  {
   "name": "Priority_In_Year",
   "type": "esriFieldTypeString",
   "alias": "Priority_In_Year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Priority_In_Year"
  },
  {
   "name": "Priority_In_Project",
   "type": "esriFieldTypeString",
   "alias": "Priority_In_Project",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Priority_In_Project"
  },
  {
   "name": "Road_Name",
   "type": "esriFieldTypeString",
   "alias": "Road_Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Road_Name"
  },
  {
   "name": "Project_Limits_1",
   "type": "esriFieldTypeString",
   "alias": "Project_Limits_1",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Project_Limits_1"
  },
  {
   "name": "Project_Limits_2",
   "type": "esriFieldTypeString",
   "alias": "Project_Limits_2",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Project_Limits_2"
  },
  {
   "name": "Pipe_Age",
   "type": "esriFieldTypeString",
   "alias": "Pipe_Age",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Pipe_Age"
  },
  {
   "name": "Pipe_Material",
   "type": "esriFieldTypeString",
   "alias": "Pipe_Material",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Pipe_Material"
  },
  {
   "name": "Project_Length_ft",
   "type": "esriFieldTypeInteger",
   "alias": "Project_Length_ft",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Project_Length_ft"
  },
  {
   "name": "Improvement_Type",
   "type": "esriFieldTypeString",
   "alias": "Improvement_Type",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Improvement_Type"
  },
  {
   "name": "Major_Minor",
   "type": "esriFieldTypeString",
   "alias": "Major_Minor",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Major_Minor"
  },
  {
   "name": "Construction__Crew",
   "type": "esriFieldTypeString",
   "alias": "Construction__Crew",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Construction__Crew"
  },
  {
   "name": "Existing",
   "type": "esriFieldTypeInteger",
   "alias": "Existing",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Existing"
  },
  {
   "name": "Future",
   "type": "esriFieldTypeInteger",
   "alias": "Future",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Future"
  },
  {
   "name": "No_of_Hydrants",
   "type": "esriFieldTypeInteger",
   "alias": "No_of_Hydrants",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "No_of_Hydrants"
  },
  {
   "name": "No_of_ResidentServices",
   "type": "esriFieldTypeInteger",
   "alias": "No_of_ResidentServices",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "No_of_ResidentServices"
  },
  {
   "name": "No_of_Large_Services",
   "type": "esriFieldTypeInteger",
   "alias": "No_of_Large_Services",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "No_of_Large_Services"
  },
  {
   "name": "No_of_Tie_ins",
   "type": "esriFieldTypeInteger",
   "alias": "No_of_Tie_ins",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "No_of_Tie_ins"
  },
  {
   "name": "Work_Description",
   "type": "esriFieldTypeString",
   "alias": "Work_Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Work_Description"
  },
  {
   "name": "Project_Costs_Hydrants_Services",
   "type": "esriFieldTypeInteger",
   "alias": "Project_Costs_Hydrants_Services_TieIns",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Project_Costs_Hydrants_Services_TieIns"
  },
  {
   "name": "Project_Costs_Water_Main",
   "type": "esriFieldTypeInteger",
   "alias": "Project_Costs_Water_Main",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Project_Costs_Water_Main"
  },
  {
   "name": "Project_Costs_True_Water_Main_l",
   "type": "esriFieldTypeDouble",
   "alias": "Project_Costs_True_Water_Main_length_modifier",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Project_Costs_True_Water_Main_length_modifier"
  },
  {
   "name": "Project_Extras_Permits_Traffic_",
   "type": "esriFieldTypeInteger",
   "alias": "Project_Extras_Permits_Traffic_Control_Other_Work",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Project_Extras_Permits_Traffic_Control_Other_Work"
  },
  {
   "name": "Total_Project_Cost",
   "type": "esriFieldTypeInteger",
   "alias": "Total_Project_Cost",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Total_Project_Cost"
  },
  {
   "name": "Map_primary",
   "type": "esriFieldTypeString",
   "alias": "Map_primary",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Map_primary"
  },
  {
   "name": "Map_secondary",
   "type": "esriFieldTypeString",
   "alias": "Map_secondary",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Map_secondary"
  },
  {
   "name": "Map_tertiary",
   "type": "esriFieldTypeString",
   "alias": "Map_tertiary",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Map_tertiary"
  },
  {
   "name": "Driving_Work1",
   "type": "esriFieldTypeString",
   "alias": "Driving_Work1",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Driving_Work1"
  },
  {
   "name": "Driving_Work2",
   "type": "esriFieldTypeString",
   "alias": "Driving_Work2",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Driving_Work2"
  },
  {
   "name": "Driving_Work3",
   "type": "esriFieldTypeString",
   "alias": "Driving_Work3",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Driving_Work3"
  },
  {
   "name": "Funding_Source",
   "type": "esriFieldTypeString",
   "alias": "Funding_Source",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Funding_Source"
  },
  {
   "name": "Leak_Count",
   "type": "esriFieldTypeInteger",
   "alias": "Leak_Count",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Leak_Count"
  },
  {
   "name": "Year_Done",
   "type": "esriFieldTypeString",
   "alias": "Year_Done",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Year_Done"
  },
  {
   "name": "Scheduled_Paving_Year",
   "type": "esriFieldTypeString",
   "alias": "Scheduled_Paving_Year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Scheduled_Paving_Year"
  },
  {
   "name": "Paving_Area",
   "type": "esriFieldTypeString",
   "alias": "Paving_Area",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Paving_Area"
  },
  {
   "name": "Report",
   "type": "esriFieldTypeString",
   "alias": "Report",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Report"
  },
  {
   "name": "GIS",
   "type": "esriFieldTypeString",
   "alias": "GIS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "GIS"
  },
  {
   "name": "Water_Priority",
   "type": "esriFieldTypeInteger",
   "alias": "Water_Priority",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Water_Priority"
  },
  {
   "name": "MainCostAlt",
   "type": "esriFieldTypeInteger",
   "alias": "MainCostAlt",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "MainCostAlt"
  },
  {
   "name": "TotalCostAlt",
   "type": "esriFieldTypeInteger",
   "alias": "TotalCostAlt",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "TotalCostAlt"
  },
  {
   "name": "countCIPID",
   "type": "esriFieldTypeInteger",
   "alias": "countCIPID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "countCIPID"
  },
  {
   "name": "COUNT_CIPIDSegment",
   "type": "esriFieldTypeInteger",
   "alias": "COUNT_CIPIDSegment",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "COUNT_CIPIDSegment"
  },
  {
   "name": "CIPID_Year_Priority",
   "type": "esriFieldTypeString",
   "alias": "CIPID_Year_Priority",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CIPID_Year_Priority"
  },
  {
   "name": "Project_Description",
   "type": "esriFieldTypeString",
   "alias": "Project_Description",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Project_Description"
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 261,
   "defaultValue": null,
   "modelName": "Notes"
  },
  {
   "name": "WTR_Project",
   "type": "esriFieldTypeString",
   "alias": "WTR_Project",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "WTR_Project"
  },
  {
   "name": "Interagency_Map",
   "type": "esriFieldTypeString",
   "alias": "Interagency_Map",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Interagency_Map"
  },
  {
   "name": "Water_CIP_Map",
   "type": "esriFieldTypeString",
   "alias": "Water_CIP_Map",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Water_CIP_Map"
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  },
  {
   "name": "CIPComponent",
   "type": "esriFieldTypeString",
   "alias": "CIPComponent",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CIPID_Segment_formula"
  }
 ],
 "indexes": [
  {
   "name": "R1242_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_12115_CIPID_",
   "fields": "CIPComponent",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Water CIP Table",
   "description": "",
   "prototype": {
    "attributes": {
     "Water_CIP_Map": null,
     "CIPComponent": null,
     "CIPID": null,
     "Project_Name": null,
     "Segment_ID": null,
     "GIS_FacilityIDs": null,
     "CIPID_Priority": null,
     "Year_Priority": null,
     "Proposed_Fyear": null,
     "Completion_Date": null,
     "Status": null,
     "Priority_In_Year": null,
     "Priority_In_Project": null,
     "Road_Name": null,
     "Project_Limits_1": null,
     "Project_Limits_2": null,
     "Pipe_Age": null,
     "Pipe_Material": null,
     "Project_Length_ft": null,
     "Improvement_Type": null,
     "Major_Minor": null,
     "Construction__Crew": null,
     "Existing": null,
     "Future": null,
     "No_of_Hydrants": null,
     "No_of_ResidentServices": null,
     "No_of_Large_Services": null,
     "No_of_Tie_ins": null,
     "Work_Description": null,
     "Project_Costs_Hydrants_Services": null,
     "Project_Costs_Water_Main": null,
     "Project_Costs_True_Water_Main_l": null,
     "Project_Extras_Permits_Traffic_": null,
     "Total_Project_Cost": null,
     "Map_primary": null,
     "Map_secondary": null,
     "Map_tertiary": null,
     "Driving_Work1": null,
     "Driving_Work2": null,
     "Driving_Work3": null,
     "Funding_Source": null,
     "Leak_Count": null,
     "Year_Done": null,
     "Scheduled_Paving_Year": null,
     "Paving_Area": null,
     "Report": null,
     "GIS": null,
     "Water_Priority": null,
     "MainCostAlt": null,
     "TotalCostAlt": null,
     "countCIPID": null,
     "COUNT_CIPIDSegment": null,
     "CIPID_Year_Priority": null,
     "Project_Description": null,
     "Notes": null,
     "WTR_Project": null,
     "Interagency_Map": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf"
}