{
 "currentVersion": 10.9,
 "cimVersion": "2.7.0",
 "id": 7,
 "name": "wTankHistoryBasinLevel",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "facname",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "assetkey",
   "type": "esriFieldTypeString",
   "alias": "Asset Key",
   "length": 20,
   "domain": null
  },
  {
   "name": "workorderid",
   "type": "esriFieldTypeString",
   "alias": "Workorder Key",
   "length": 50,
   "domain": null
  },
  {
   "name": "attachmentid1",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID1",
   "domain": null
  },
  {
   "name": "attachmentid2",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID2",
   "domain": null
  },
  {
   "name": "workby",
   "type": "esriFieldTypeString",
   "alias": "WorkBy",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wStaffOperations",
    "description": "Water Reporting Staff Names",
    "codedValues": [
     {
      "name": "Carlos Solis",
      "code": "Carlos Solis"
     },
     {
      "name": "Ed Cazares",
      "code": "Ed Cazares"
     },
     {
      "name": "Emanuel Cardoso",
      "code": "Emanuel Cardoso"
     },
     {
      "name": "Paul Branconier",
      "code": "Paul Branconier"
     },
     {
      "name": "Scott Hallimore",
      "code": "Scott Hallimore"
     },
     {
      "name": "Melissa Barbosa",
      "code": "Melissa Barbosa"
     },
     {
      "name": "Adrian Martinez",
      "code": "Adrian Martinez"
     },
     {
      "name": "Gerard Palacios",
      "code": "Gerard Palacios"
     },
     {
      "name": "Jason Kromer",
      "code": "Jason Kromer"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "worktype",
   "type": "esriFieldTypeString",
   "alias": "worktype",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wTanksWorktype",
    "description": "Water Report Tanks Worktype",
    "codedValues": [
     {
      "name": "Well Production",
      "code": "Well Production"
     },
     {
      "name": "Well Inspection",
      "code": "Well Inspection"
     },
     {
      "name": "Well Sounding",
      "code": "Well Sounding"
     },
     {
      "name": "Vulcan Production",
      "code": "Vulcan Production"
     },
     {
      "name": "C9 Diversion",
      "code": "C9 Diversion"
     },
     {
      "name": "Basin Level",
      "code": "Basin Level"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "comments",
   "type": "esriFieldTypeString",
   "alias": "comments",
   "length": 1000,
   "domain": null
  },
  {
   "name": "facname",
   "type": "esriFieldTypeString",
   "alias": "facname",
   "length": 50,
   "domain": null
  },
  {
   "name": "storagetype",
   "type": "esriFieldTypeString",
   "alias": "storagetype",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wStorageType",
    "description": "The type of water structures",
    "codedValues": [
     {
      "name": "Hydropillar",
      "code": "Hydropillar"
     },
     {
      "name": "Standpipe",
      "code": "Standpipe"
     },
     {
      "name": "Reservoir",
      "code": "Reservoir"
     },
     {
      "name": "Tank",
      "code": "Tank"
     },
     {
      "name": "Well",
      "code": "Well"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "pressurezone",
   "type": "esriFieldTypeString",
   "alias": "pressurezone",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wPressureZone",
    "description": "PressureZone",
    "codedValues": [
     {
      "name": "1023 Zone",
      "code": "1023 Zone"
     },
     {
      "name": "590 Zone",
      "code": "590 Zone"
     },
     {
      "name": "715 Zone",
      "code": "715 Zone"
     },
     {
      "name": "720 Zone",
      "code": "720 Zone"
     },
     {
      "name": "820 Zone",
      "code": "820 Zone"
     },
     {
      "name": "830 Zone",
      "code": "830 Zone"
     },
     {
      "name": "890 Zone",
      "code": "890 Zone"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "material",
   "type": "esriFieldTypeString",
   "alias": "material",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wTankMaterial_1",
    "description": "Tank Material",
    "codedValues": [
     {
      "name": "Concrete",
      "code": "Concrete"
     },
     {
      "name": "Steel",
      "code": "Steel"
     },
     {
      "name": "Glass Infused Steel",
      "code": "Glass Infused Steel"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "capacity",
   "type": "esriFieldTypeDouble",
   "alias": "capacity",
   "domain": null
  },
  {
   "name": "topelevtrigger",
   "type": "esriFieldTypeDouble",
   "alias": "topelevtrigger",
   "domain": null
  },
  {
   "name": "lowelevtrigger",
   "type": "esriFieldTypeDouble",
   "alias": "lowelevtrigger",
   "domain": null
  },
  {
   "name": "waterlevel",
   "type": "esriFieldTypeDouble",
   "alias": "waterlevel",
   "domain": null
  },
  {
   "name": "gpm",
   "type": "esriFieldTypeDouble",
   "alias": "gpm",
   "domain": null
  },
  {
   "name": "flowccf",
   "type": "esriFieldTypeDouble",
   "alias": "flowccf",
   "domain": null
  },
  {
   "name": "flowccf_last",
   "type": "esriFieldTypeDouble",
   "alias": "flowccf_last",
   "domain": null
  },
  {
   "name": "flow",
   "type": "esriFieldTypeDouble",
   "alias": "flow",
   "domain": null
  },
  {
   "name": "hourmeter",
   "type": "esriFieldTypeDouble",
   "alias": "hourmeter",
   "domain": null
  },
  {
   "name": "hourmeter_last",
   "type": "esriFieldTypeDouble",
   "alias": "hourmeter_last",
   "domain": null
  },
  {
   "name": "runtime",
   "type": "esriFieldTypeDouble",
   "alias": "runtime",
   "domain": null
  },
  {
   "name": "kwhmeter",
   "type": "esriFieldTypeDouble",
   "alias": "kwhmeter",
   "domain": null
  },
  {
   "name": "kwhmeter_last",
   "type": "esriFieldTypeDouble",
   "alias": "kwhmeter_last",
   "domain": null
  },
  {
   "name": "kwhmeter_diff",
   "type": "esriFieldTypeDouble",
   "alias": "kwhmeter_diff",
   "domain": null
  },
  {
   "name": "kwhused",
   "type": "esriFieldTypeDouble",
   "alias": "kwhused",
   "domain": null
  },
  {
   "name": "kwhperccf",
   "type": "esriFieldTypeDouble",
   "alias": "kwhperccf",
   "domain": null
  },
  {
   "name": "kwhperhr",
   "type": "esriFieldTypeDouble",
   "alias": "kwhperhr",
   "domain": null
  },
  {
   "name": "demand_last",
   "type": "esriFieldTypeDouble",
   "alias": "demand_last",
   "domain": null
  },
  {
   "name": "flowaf",
   "type": "esriFieldTypeDouble",
   "alias": "flowaf",
   "domain": null
  },
  {
   "name": "flowaf_last",
   "type": "esriFieldTypeDouble",
   "alias": "flowaf_last",
   "domain": null
  },
  {
   "name": "sewermeter_diff",
   "type": "esriFieldTypeDouble",
   "alias": "sewermeter_diff",
   "domain": null
  },
  {
   "name": "swl",
   "type": "esriFieldTypeDouble",
   "alias": "swl",
   "domain": null
  },
  {
   "name": "pwl",
   "type": "esriFieldTypeDouble",
   "alias": "pwl",
   "domain": null
  },
  {
   "name": "wellstatus",
   "type": "esriFieldTypeString",
   "alias": "wellstatus",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wWellStatus",
    "description": "Water Report Well Status",
    "codedValues": [
     {
      "name": "On",
      "code": "On"
     },
     {
      "name": "Off",
      "code": "Off"
     },
     {
      "name": "Out of Service",
      "code": "Out of Service"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "wellfield",
   "type": "esriFieldTypeString",
   "alias": "wellfield",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wWellField",
    "description": "Water Report Well Field",
    "codedValues": [
     {
      "name": "Hand",
      "code": "Hand"
     },
     {
      "name": "Off",
      "code": "Off"
     },
     {
      "name": "Auto",
      "code": "Auto"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "dischargepsi",
   "type": "esriFieldTypeDouble",
   "alias": "dischargepsi",
   "domain": null
  },
  {
   "name": "localcntrlswtch",
   "type": "esriFieldTypeString",
   "alias": "localcntrlswtch",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wLocalControlSwitch",
    "description": "Water Report LocalControlSwitch",
    "codedValues": [
     {
      "name": "Hand",
      "code": "Hand"
     },
     {
      "name": "Off",
      "code": "Off"
     },
     {
      "name": "Time Clock",
      "code": "Time Clock"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "timeclockon",
   "type": "esriFieldTypeDouble",
   "alias": "timeclockon",
   "domain": null
  },
  {
   "name": "timeclockoff",
   "type": "esriFieldTypeDouble",
   "alias": "timeclockoff",
   "domain": null
  },
  {
   "name": "demandkw",
   "type": "esriFieldTypeDouble",
   "alias": "demandkw",
   "domain": null
  },
  {
   "name": "sightoiler",
   "type": "esriFieldTypeDouble",
   "alias": "sightoiler",
   "domain": null
  },
  {
   "name": "operationalcntrl",
   "type": "esriFieldTypeString",
   "alias": "operationalcntrl",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wOperationalControl",
    "description": "Water Report OperationalControl",
    "codedValues": [
     {
      "name": "Local / Manual",
      "code": "Local / Manual"
     },
     {
      "name": "Remote / Auto",
      "code": "Remote / Auto"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "waterlevelrunning",
   "type": "esriFieldTypeDouble",
   "alias": "waterlevelrunning",
   "domain": null
  },
  {
   "name": "cl2pump",
   "type": "esriFieldTypeSmallInteger",
   "alias": "cl2pump",
   "domain": null
  },
  {
   "name": "cl2pumpspeed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "cl2pumpspeed",
   "domain": null
  },
  {
   "name": "cl2residual",
   "type": "esriFieldTypeDouble",
   "alias": "cl2residual",
   "domain": null
  },
  {
   "name": "starttime",
   "type": "esriFieldTypeDate",
   "alias": "starttime",
   "length": 8,
   "domain": null
  },
  {
   "name": "initials",
   "type": "esriFieldTypeString",
   "alias": "initials",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "wWorkBy",
    "description": "Water Reporting Staff usernames",
    "codedValues": [
     {
      "name": "amartinez",
      "code": "amartinez"
     },
     {
      "name": "csolis",
      "code": "csolis"
     },
     {
      "name": "ecazares",
      "code": "ecazares"
     },
     {
      "name": "ecardoso",
      "code": "ecardoso"
     },
     {
      "name": "pbranconier",
      "code": "pbranconier"
     },
     {
      "name": "shallimore",
      "code": "shallimore"
     },
     {
      "name": "mbarbosa",
      "code": "mbarbosa"
     },
     {
      "name": "gpalacios",
      "code": "gpalacios"
     },
     {
      "name": "jkroner",
      "code": "jkroner"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "productiontotal_ccf",
   "type": "esriFieldTypeDouble",
   "alias": "productiontotal_ccf",
   "domain": null
  },
  {
   "name": "productiontotal_mg",
   "type": "esriFieldTypeDouble",
   "alias": "productiontotal_mg",
   "domain": null
  },
  {
   "name": "productiontotal_af",
   "type": "esriFieldTypeDouble",
   "alias": "productiontotal_af",
   "domain": null
  },
  {
   "name": "motorheat",
   "type": "esriFieldTypeString",
   "alias": "motorheat",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wEquipCheckStatus",
    "description": "Water Report Equipment Status",
    "codedValues": [
     {
      "name": "Okay",
      "code": "Okay"
     },
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Issue",
      "code": "Issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "pumpvibration",
   "type": "esriFieldTypeString",
   "alias": "pumpvibration",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wEquipCheckStatus",
    "description": "Water Report Equipment Status",
    "codedValues": [
     {
      "name": "Okay",
      "code": "Okay"
     },
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Issue",
      "code": "Issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "bearinghouse",
   "type": "esriFieldTypeString",
   "alias": "bearinghouse",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wEquipCheckStatus",
    "description": "Water Report Equipment Status",
    "codedValues": [
     {
      "name": "Okay",
      "code": "Okay"
     },
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Issue",
      "code": "Issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "oillevel",
   "type": "esriFieldTypeString",
   "alias": "oillevel",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wEquipCheckStatus",
    "description": "Water Report Equipment Status",
    "codedValues": [
     {
      "name": "Okay",
      "code": "Okay"
     },
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Issue",
      "code": "Issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "totalkwh",
   "type": "esriFieldTypeDouble",
   "alias": "totalkwh",
   "domain": null
  },
  {
   "name": "diversionaf",
   "type": "esriFieldTypeDouble",
   "alias": "diversionaf",
   "domain": null
  },
  {
   "name": "diversionaf_last",
   "type": "esriFieldTypeDouble",
   "alias": "diversionaf_last",
   "domain": null
  },
  {
   "name": "diversionaf_diff",
   "type": "esriFieldTypeDouble",
   "alias": "diversionaf_diff",
   "domain": null
  },
  {
   "name": "c9flow",
   "type": "esriFieldTypeDouble",
   "alias": "c9flow",
   "domain": null
  },
  {
   "name": "c9flow_last",
   "type": "esriFieldTypeDouble",
   "alias": "c9flow_last",
   "domain": null
  },
  {
   "name": "c9flow_diff",
   "type": "esriFieldTypeDouble",
   "alias": "c9flow_diff",
   "domain": null
  },
  {
   "name": "watersource",
   "type": "esriFieldTypeString",
   "alias": "watersource",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "wWaterSource",
    "description": "Water Report Watersource",
    "codedValues": [
     {
      "name": "Conduit",
      "code": "Conduit"
     },
     {
      "name": "River",
      "code": "River"
     },
     {
      "name": "Off",
      "code": "Off"
     },
     {
      "name": "USG3",
      "code": "USG3"
     },
     {
      "name": "Four Cities",
      "code": "Four Cities"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "wtpinfluentaf",
   "type": "esriFieldTypeDouble",
   "alias": "wtpinfluentaf",
   "domain": null
  },
  {
   "name": "wtpinfluentaf_last",
   "type": "esriFieldTypeDouble",
   "alias": "wtpinfluentaf_last",
   "domain": null
  },
  {
   "name": "wtpinfluentaf_diff",
   "type": "esriFieldTypeDouble",
   "alias": "wtpinfluentaf_diff",
   "domain": null
  },
  {
   "name": "allocationaf",
   "type": "esriFieldTypeDouble",
   "alias": "allocationaf",
   "domain": null
  },
  {
   "name": "spreadwateraf",
   "type": "esriFieldTypeDouble",
   "alias": "spreadwateraf",
   "domain": null
  },
  {
   "name": "multiplier",
   "type": "esriFieldTypeDouble",
   "alias": "multiplier",
   "domain": null
  },
  {
   "name": "sounding_date_time",
   "type": "esriFieldTypeDate",
   "alias": "soundingdatetime",
   "length": 8,
   "domain": null
  },
  {
   "name": "well_running_static",
   "type": "esriFieldTypeString",
   "alias": "well_running_static",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wWellSoundingStatus",
    "description": "Water Report Well Sounding Status",
    "codedValues": [
     {
      "name": "Running",
      "code": "Running"
     },
     {
      "name": "Static",
      "code": "Static"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "sounding_method",
   "type": "esriFieldTypeString",
   "alias": "sounding_method",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "wSoundingMethod",
    "description": "Water Report Sounding Method",
    "codedValues": [
     {
      "name": "Tape",
      "code": "Tape"
     },
     {
      "name": "Automated Pressure Transducer",
      "code": "Automated Pressure Transducer"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "productiontotal_gal",
   "type": "esriFieldTypeDouble",
   "alias": "productiontotal_gal",
   "domain": null
  },
  {
   "name": "wocreatedby",
   "type": "esriFieldTypeString",
   "alias": "wocreatedby",
   "length": 50,
   "domain": null
  },
  {
   "name": "wocreateddate",
   "type": "esriFieldTypeDate",
   "alias": "wocreateddate",
   "length": 8,
   "domain": null
  },
  {
   "name": "wodescription",
   "type": "esriFieldTypeString",
   "alias": "wodescription",
   "length": 1000,
   "domain": null
  },
  {
   "name": "wonotes",
   "type": "esriFieldTypeString",
   "alias": "wonotes",
   "length": 1000,
   "domain": null
  },
  {
   "name": "woaddress",
   "type": "esriFieldTypeString",
   "alias": "woaddress",
   "length": 100,
   "domain": null
  },
  {
   "name": "wocustomer",
   "type": "esriFieldTypeString",
   "alias": "wocustomer",
   "length": 50,
   "domain": null
  },
  {
   "name": "WorkDate2",
   "type": "esriFieldTypeDate",
   "alias": "WorkDate2",
   "length": 8,
   "domain": null
  },
  {
   "name": "workdate",
   "type": "esriFieldTypeDate",
   "alias": "workdate",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R373_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_1839_assetke",
   "fields": "assetkey",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "GISPROD.DBO.wWaterSources",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "assetkey",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Query,Map,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,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "2ebffe02d8af46e7a2c434817f1de6d5"
}