{
 "isCoGoEnabled": false,
 "isDataBranchVersioned": false,
 "supportsApplyEditsWithGlobalIds": true,
 "maxRecordCount": 2000,
 "infoInEstimates": [
  "extent",
  "count"
 ],
 "datesInUnknownTimezone": false,
 "type": "Table",
 "supportsAttachmentsByUploadId": true,
 "relationships": [],
 "supportsAttachmentsResizing": true,
 "cimVersion": "2.9.0",
 "isDataArchived": false,
 "id": 1,
 "supportsStatistics": true,
 "supportedExportFormats": "sqlite,filegdb",
 "standardMaxRecordCount": 16000,
 "isDataVersioned": false,
 "templates": [
  {
   "name": "sde.DBO.SystemValveActivity_tbl",
   "description": "",
   "drawingTool": "esriFeatureEditToolNone",
   "prototype": {
    "attributes": {
     "lastactivity": null,
     "operable": 1,
     "facilityid": null,
     "installdate": null,
     "facility_id_label": null,
     "computername": null,
     "torquedata": null,
     "operatedby": null,
     "valvepurpose": null,
     "enabled": 1,
     "normallyopen": 1,
     "datestamp": null,
     "diameter": null,
     "valvetype": null,
     "depthtonut": null,
     "ownedby": 1,
     "hightorque": null,
     "comments": null,
     "optime": null,
     "rotation": null,
     "hydrflag": 0,
     "curropen": 1,
     "lasteditor": null,
     "turnstoclose": 1,
     "activeflag": 1,
     "closedirection": null,
     "clocktoclose": 1,
     "bypassvalve": 0,
     "gps_verified": null,
     "legacyid": null,
     "maintby": 1,
     "lastupdate": null,
     "operationalstatus": null,
     "locdesc": null,
     "gpsx": null,
     "gpsy": null
    }
   }
  }
 ],
 "supportsAdvancedQueries": true,
 "currentVersion": 10.91,
 "advancedEditingCapabilities": {
  "supportsAsyncApplyEdits": false,
  "supportedSqlFormatsInCalculate": [
   "standard"
  ]
 },
 "objectIdField": "objectid",
 "supportsQuantizationEditMode": true,
 "name": "sde.DBO.SystemValveActivity_tbl",
 "displayField": "computername",
 "supportsCalculate": true,
 "fields": [
  {
   "nullable": false,
   "defaultValue": null,
   "editable": false,
   "length": 4,
   "type": "esriFieldTypeOID",
   "modelName": "OBJECTID",
   "domain": null,
   "name": "objectid",
   "alias": "OBJECTID"
  },
  {
   "modelName": "FACILITYID",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "facilityid",
   "length": 20,
   "alias": "Facility Identifier",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "INSTALLDATE",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "installdate",
   "length": 29,
   "alias": "Install Date",
   "type": "esriFieldTypeDate"
  },
  {
   "modelName": "LOCDESC",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "locdesc",
   "length": 200,
   "alias": "Location Description",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "ROTATION",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "rotation",
   "alias": "Rotation",
   "type": "esriFieldTypeDouble"
  },
  {
   "modelName": "DIAMETER",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainMainDistributionDiameter_1",
    "description": "",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0.75,
      "name": "3/4\""
     },
     {
      "code": 1,
      "name": "1\""
     },
     {
      "code": 1.25,
      "name": "1 1/4\""
     },
     {
      "code": 1.5,
      "name": "1 1/2\""
     },
     {
      "code": 2,
      "name": "2\""
     },
     {
      "code": 2.5,
      "name": "2 1/2\""
     },
     {
      "code": 3,
      "name": "3\""
     },
     {
      "code": 4,
      "name": "4\""
     },
     {
      "code": 6,
      "name": "6\""
     },
     {
      "code": 8,
      "name": "8\""
     },
     {
      "code": 10,
      "name": "10\""
     },
     {
      "code": 12,
      "name": "12\""
     },
     {
      "code": 14,
      "name": "14\""
     },
     {
      "code": 16,
      "name": "16\""
     },
     {
      "code": 18,
      "name": "18\""
     },
     {
      "code": 20,
      "name": "20\""
     },
     {
      "code": 24,
      "name": "24\""
     },
     {
      "code": 30,
      "name": "30\""
     },
     {
      "code": 36,
      "name": "36\""
     },
     {
      "code": 42,
      "name": "42\""
     },
     {
      "code": 0,
      "name": "Unknown"
     },
     {
      "code": -1,
      "name": "Other"
     },
     {
      "code": 48,
      "name": "48\""
     },
     {
      "code": 60,
      "name": "60\""
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "diameter",
   "alias": "Diameter",
   "type": "esriFieldTypeDouble"
  },
  {
   "modelName": "VALVETYPE",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wSystemValveType",
    "description": "System Valve Types",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "Ball",
      "name": "Ball"
     },
     {
      "code": "Butterfly",
      "name": "Butterfly"
     },
     {
      "code": "Cone",
      "name": "Cone"
     },
     {
      "code": "Gate",
      "name": "Gate"
     },
     {
      "code": "Plug",
      "name": "Plug"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "valvetype",
   "length": 30,
   "alias": "Valve Type",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "BYPASSVALVE",
   "nullable": true,
   "editable": true,
   "defaultValue": 0,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "bypassvalve",
   "alias": "Bypass Valve",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "CLOCKTOCLOSE",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "clocktoclose",
   "alias": "Clockwise To Close",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "NORMALLYOPEN",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "normallyopen",
   "alias": "Normally Open",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "TURNSTOCLOSE",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": null,
   "name": "turnstoclose",
   "alias": "Turns To Close",
   "type": "esriFieldTypeInteger"
  },
  {
   "modelName": "OPERABLE",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "operable",
   "alias": "Operable",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "HYDRFLAG",
   "nullable": true,
   "editable": true,
   "defaultValue": 0,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "hydrflag",
   "alias": "Hydrant Valve",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "CURROPEN",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "wSystemValveOpen",
    "description": "System Valve Open Close",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 1,
      "name": "Open"
     },
     {
      "code": 2,
      "name": "Closed"
     },
     {
      "code": 3,
      "name": "Unkn"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "curropen",
   "alias": "Currently Open",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "ENABLED",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "EnabledDomain",
    "description": "Geometric Network Enabled domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "enabled",
   "alias": "Enabled",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "ACTIVEFLAG",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainBoolean",
    "description": "Boolean domain",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 0,
      "name": "False"
     },
     {
      "code": 1,
      "name": "True"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "activeflag",
   "alias": "Active Flag",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "OWNEDBY",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainOwner_1",
    "description": "Indicates the category/name of organization that owns the asset. Change \"Our Utility\" to the name of your utility if you want",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 1,
      "name": "Our Utility"
     },
     {
      "code": -1,
      "name": "UTWD"
     },
     {
      "code": -2,
      "name": "Copper Canyon"
     },
     {
      "code": -3,
      "name": "Bartonville Water Disrict"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "ownedby",
   "alias": "Owned By",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "MAINTBY",
   "nullable": true,
   "editable": true,
   "defaultValue": 1,
   "domain": {
    "splitPolicy": "esriSPTDuplicate",
    "name": "wDomainManager_1",
    "description": "Indicates the category/name of organization that manages the asset. Change \"Our Utility\" to the name of your utility if you want",
    "type": "codedValue",
    "codedValues": [
     {
      "code": 1,
      "name": "Our Utility"
     },
     {
      "code": -1,
      "name": "UTWD"
     },
     {
      "code": -2,
      "name": "Copper Canyon"
     },
     {
      "code": -3,
      "name": "Bartonville Water District"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "maintby",
   "alias": "Managed By",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "LASTUPDATE",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "lastupdate",
   "length": 29,
   "alias": "Last Update Date",
   "type": "esriFieldTypeDate"
  },
  {
   "modelName": "LASTEDITOR",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "lasteditor",
   "length": 50,
   "alias": "Last Editor",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "LegacyID",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "legacyid",
   "length": 30,
   "alias": "LegacyID",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "GPS_Verified",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "gps_verified",
   "length": 5,
   "alias": "GPS_Verified",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "Facility_ID_Label",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "facility_id_label",
   "length": 20,
   "alias": "Facility_ID_Label",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "Comments",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "comments",
   "length": 50,
   "alias": "Comments",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "LastActivity",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "wValveActivity",
    "description": "Valve Activity status",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "INST",
      "name": "Installation"
     },
     {
      "code": "UPDT",
      "name": "Update Info"
     },
     {
      "code": "EXE",
      "name": "Exercise Valve"
     },
     {
      "code": "CLS",
      "name": "line Shutdown"
     },
     {
      "code": "OPN",
      "name": "Line Reoopen"
     },
     {
      "code": "ABAN",
      "name": "Remove/Abandon"
     },
     {
      "code": "RPR",
      "name": "Repair/Replace"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "lastactivity",
   "length": 4,
   "alias": "LastActivity",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "DateStamp",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "datestamp",
   "length": 29,
   "alias": "DateStamp",
   "type": "esriFieldTypeDate"
  },
  {
   "modelName": "OpTime",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "optime",
   "length": 5,
   "alias": "OpTime",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "ComputerName",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "computername",
   "length": 30,
   "alias": "ComputerName",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "OperatedBy",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "operatedby",
   "length": 30,
   "alias": "OperatedBy",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "OperationalStatus",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "wOperationalStatus",
    "description": "Operational Status of the Asset",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "OK",
      "name": "OK"
     },
     {
      "code": "NRPR",
      "name": "Needs Repair"
     },
     {
      "code": "INOP",
      "name": "Inoperable"
     },
     {
      "code": "SIZE",
      "name": "Size/Turns Conflict"
     },
     {
      "code": "UTL",
      "name": "Unable to Locate"
     },
     {
      "code": "NOAC",
      "name": "No Access"
     },
     {
      "code": "RGPS",
      "name": "Resurvey"
     },
     {
      "code": "RTRN",
      "name": "Incomplete/Return"
     },
     {
      "code": "ABAN",
      "name": "Abandoned"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "operationalstatus",
   "length": 10,
   "alias": "OperationalStatus",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "DepthtoNut",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "depthtonut",
   "alias": "DepthtoNut",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "ValvePurpose",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "wValvePurpose",
    "description": "Vavle type for the valve exer machine",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "ZONE",
      "name": "Zone Valve"
     },
     {
      "code": "RSRV",
      "name": "Resevoir Valve"
     },
     {
      "code": "HYD",
      "name": "Hydrant Valve"
     },
     {
      "code": "MAIN",
      "name": "Main Line Valve"
     },
     {
      "code": "AIR",
      "name": "Air Release Valve"
     },
     {
      "code": "BLOW",
      "name": "Blow Off Valve"
     },
     {
      "code": "MTR",
      "name": "Meter Valve"
     },
     {
      "code": "CLSD",
      "name": "Normally Closed Valve"
     },
     {
      "code": "DIV",
      "name": "Division Valve"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "valvepurpose",
   "length": 10,
   "alias": "ValvePurpose",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "GPSX",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "gpsx",
   "alias": "GPSX",
   "type": "esriFieldTypeDouble"
  },
  {
   "modelName": "GPSY",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "gpsy",
   "alias": "GPSY",
   "type": "esriFieldTypeDouble"
  },
  {
   "modelName": "HighTorque",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "hightorque",
   "alias": "HighTorque",
   "type": "esriFieldTypeSmallInteger"
  },
  {
   "modelName": "CloseDirection",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": {
    "splitPolicy": "esriSPTDefaultValue",
    "name": "wCloseDirection",
    "description": "Valve close direction",
    "type": "codedValue",
    "codedValues": [
     {
      "code": "R",
      "name": "Right"
     },
     {
      "code": "L",
      "name": "Left"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue"
   },
   "name": "closedirection",
   "length": 5,
   "alias": "CloseDirection",
   "type": "esriFieldTypeString"
  },
  {
   "modelName": "TorqueData",
   "nullable": true,
   "editable": true,
   "defaultValue": null,
   "domain": null,
   "name": "torquedata",
   "length": 2147483647,
   "alias": "TorqueData",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": false,
   "editable": false,
   "defaultValue": null,
   "length": 38,
   "type": "esriFieldTypeGlobalID",
   "modelName": "globalid",
   "domain": null,
   "name": "globalid",
   "alias": "GlobalID"
  }
 ],
 "maxRecordCountFactor": 1,
 "dateFieldsTimeReference": {
  "respectsDaylightSaving": false,
  "timeZone": "UTC"
 },
 "supportsFieldDescriptionProperty": true,
 "allowGeometryUpdates": true,
 "useStandardizedQueries": true,
 "globalIdField": "globalid",
 "description": "",
 "syncCanReturnChanges": true,
 "supportsAsyncDelete": true,
 "supportedSpatialRelationships": [
  "esriSpatialRelIntersects",
  "esriSpatialRelContains",
  "esriSpatialRelCrosses",
  "esriSpatialRelEnvelopeIntersects",
  "esriSpatialRelOverlaps",
  "esriSpatialRelTouches",
  "esriSpatialRelWithin",
  "esriSpatialRelRelation"
 ],
 "supportsRollbackOnFailureParameter": true,
 "isDataReplicaTracked": false,
 "indexes": [
  {
   "name": "r25_sde_rowid_uk",
   "isUnique": true,
   "description": "",
   "fields": "objectid",
   "isAscending": true
  },
  {
   "name": "uuid_25",
   "isUnique": true,
   "description": "",
   "fields": "globalid",
   "isAscending": true
  }
 ],
 "editFieldsInfo": null,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "hasAttachments": false,
 "advancedQueryCapabilities": {
  "supportsSqlExpression": true,
  "supportsStatistics": true,
  "supportsQueryWithResultType": true,
  "supportsOrderBy": true,
  "supportsLod": false,
  "supportsQueryWithCacheHint": false,
  "supportsQueryWithDatumTransformation": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsQueryAttachments": true,
  "supportsQueryDateBins": false,
  "supportsQueryAttachmentsCountOnly": true,
  "supportsOrderByOnlyOnLayerFields": false,
  "supportsOutFieldSqlExpression": true,
  "supportsQueryWithLodSR": false,
  "supportsTopFeaturesQuery": true,
  "supportsPaginationOnAggregatedQueries": true,
  "supportsMaxRecordCountFactor": true,
  "supportsPagination": true,
  "supportsDistinct": true,
  "supportsQueryAnalytic": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true
 },
 "supportsValidateSQL": true,
 "enableZDefaults": true,
 "serviceItemId": "d67429b1456a4002b8433aed65c220c7",
 "allowUpdateWithoutMValues": true,
 "supportsCoordinatesQuantization": true,
 "types": [],
 "capabilities": "Query",
 "supportsAppend": true,
 "supportsExceedsLimitStatistics": true,
 "advancedQueryAnalyticCapabilities": {
  "supportsAsync": false,
  "supportsLinearRegression": true,
  "supportsPercentileAnalytic": false
 },
 "hasMetadata": true,
 "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel",
 "tileMaxRecordCount": 4000,
 "typeIdField": "",
 "supportsASyncCalculate": true,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "sqlParserVersion": "PG_10.9.1",
 "copyrightText": "",
 "zDefault": 0
}