{
 "currentVersion": 11.4,
 "cimVersion": "3.4.0",
 "id": 23,
 "name": "D4_POD_Wellhead_Casing",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "applicantname",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "inspector1",
   "type": "esriFieldTypeString",
   "alias": "Inspector 1",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_INSPECTOR",
    "description": "",
    "codedValues": [
     {
      "name": "Alfred Perrault",
      "code": "AP"
     },
     {
      "name": "Amanda Kelly",
      "code": "AK"
     },
     {
      "name": "Caitlyn Owens",
      "code": "CO"
     },
     {
      "name": "Carlos Benavides",
      "code": "CB"
     },
     {
      "name": "Christina Hernandez",
      "code": "CH"
     },
     {
      "name": "Craig Cathey",
      "code": "CC"
     },
     {
      "name": "Darien Pruitt",
      "code": "DP"
     },
     {
      "name": "Dayna Campbell",
      "code": "DC"
     },
     {
      "name": "Dustyn Hennesay",
      "code": "DH"
     },
     {
      "name": "Glen Montoya",
      "code": "GM"
     },
     {
      "name": "Jamie Pirtle",
      "code": "JP"
     },
     {
      "name": "JR Hennessey",
      "code": "JH"
     },
     {
      "name": "Kate Fauske Maynard",
      "code": "KFM"
     },
     {
      "name": "Liliana Gallegos",
      "code": "LG"
     },
     {
      "name": "Lilyan Sensiba",
      "code": "LS"
     },
     {
      "name": "Marlyann Lozano-Enriquez",
      "code": "MLE"
     },
     {
      "name": "Oscar Esparza Jr.",
      "code": "OE"
     },
     {
      "name": "Ramona Cuaron",
      "code": "RC"
     },
     {
      "name": "Ryan Serrano",
      "code": "RS"
     },
     {
      "name": "Sarah Rodriguez",
      "code": "SR"
     },
     {
      "name": "Sylvana Garay",
      "code": "SG"
     },
     {
      "name": "Yvette Lopez",
      "code": "YL"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Donna Martinez",
      "code": "DM"
     },
     {
      "name": "Jennifer Yebra",
      "code": "JY"
     },
     {
      "name": "Edward Misquez",
      "code": "EM"
     },
     {
      "name": "Anita Tafoya",
      "code": "AT"
     },
     {
      "name": "Shannon Rees",
      "code": "SKR"
     },
     {
      "name": "Konnor Riddle",
      "code": "KR"
     },
     {
      "name": "Cody Craig",
      "code": "C2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "inspector2",
   "type": "esriFieldTypeString",
   "alias": "Inspector 2",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_INSPECTOR",
    "description": "",
    "codedValues": [
     {
      "name": "Alfred Perrault",
      "code": "AP"
     },
     {
      "name": "Amanda Kelly",
      "code": "AK"
     },
     {
      "name": "Caitlyn Owens",
      "code": "CO"
     },
     {
      "name": "Carlos Benavides",
      "code": "CB"
     },
     {
      "name": "Christina Hernandez",
      "code": "CH"
     },
     {
      "name": "Craig Cathey",
      "code": "CC"
     },
     {
      "name": "Darien Pruitt",
      "code": "DP"
     },
     {
      "name": "Dayna Campbell",
      "code": "DC"
     },
     {
      "name": "Dustyn Hennesay",
      "code": "DH"
     },
     {
      "name": "Glen Montoya",
      "code": "GM"
     },
     {
      "name": "Jamie Pirtle",
      "code": "JP"
     },
     {
      "name": "JR Hennessey",
      "code": "JH"
     },
     {
      "name": "Kate Fauske Maynard",
      "code": "KFM"
     },
     {
      "name": "Liliana Gallegos",
      "code": "LG"
     },
     {
      "name": "Lilyan Sensiba",
      "code": "LS"
     },
     {
      "name": "Marlyann Lozano-Enriquez",
      "code": "MLE"
     },
     {
      "name": "Oscar Esparza Jr.",
      "code": "OE"
     },
     {
      "name": "Ramona Cuaron",
      "code": "RC"
     },
     {
      "name": "Ryan Serrano",
      "code": "RS"
     },
     {
      "name": "Sarah Rodriguez",
      "code": "SR"
     },
     {
      "name": "Sylvana Garay",
      "code": "SG"
     },
     {
      "name": "Yvette Lopez",
      "code": "YL"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Donna Martinez",
      "code": "DM"
     },
     {
      "name": "Jennifer Yebra",
      "code": "JY"
     },
     {
      "name": "Edward Misquez",
      "code": "EM"
     },
     {
      "name": "Anita Tafoya",
      "code": "AT"
     },
     {
      "name": "Shannon Rees",
      "code": "SKR"
     },
     {
      "name": "Konnor Riddle",
      "code": "KR"
     },
     {
      "name": "Cody Craig",
      "code": "C2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "inspdate",
   "type": "esriFieldTypeDate",
   "alias": "Inspection Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "applicantpresent",
   "type": "esriFieldTypeString",
   "alias": "Applicant Present",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "applicantname",
   "type": "esriFieldTypeString",
   "alias": "Applicant Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "drillerpresent",
   "type": "esriFieldTypeString",
   "alias": "Driller Present",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "contactinfo",
   "type": "esriFieldTypeString",
   "alias": "Contact Information",
   "length": 256,
   "domain": null
  },
  {
   "name": "licensenbr",
   "type": "esriFieldTypeInteger",
   "alias": "License Number",
   "domain": null
  },
  {
   "name": "permitonsite",
   "type": "esriFieldTypeString",
   "alias": "Permits On-Site",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "pumpinstalled",
   "type": "esriFieldTypeString",
   "alias": "Pump Installed",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "pumptype",
   "type": "esriFieldTypeString",
   "alias": "Pump Type",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_PUMP_TYPE",
    "description": "pump type",
    "codedValues": [
     {
      "name": "Sump",
      "code": "SUMP"
     },
     {
      "name": "Submersible",
      "code": "SUBMER"
     },
     {
      "name": "Pumpjack",
      "code": "JACK"
     },
     {
      "name": "Suction",
      "code": "SUCTN"
     },
     {
      "name": "Solar",
      "code": "SOLAR"
     },
     {
      "name": "Centrifugal",
      "code": "CENTRI"
     },
     {
      "name": "Vertical Turbine",
      "code": "TURBIN"
     },
     {
      "name": "Lift",
      "code": "LIFT"
     },
     {
      "name": "None",
      "code": "NONE"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "powersupply",
   "type": "esriFieldTypeString",
   "alias": "Power Supply",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_POWER_SUPPLY",
    "description": "power supply",
    "codedValues": [
     {
      "name": "Electric Grid",
      "code": "ELE"
     },
     {
      "name": "Generator",
      "code": "GEN"
     },
     {
      "name": "Solar",
      "code": "SOLAR"
     },
     {
      "name": "Batteries",
      "code": "BATT"
     },
     {
      "name": "Wind",
      "code": "WIND"
     },
     {
      "name": "Gasoline",
      "code": "GAS"
     },
     {
      "name": "Natural Gas",
      "code": "NATGAS"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "welldesign",
   "type": "esriFieldTypeString",
   "alias": "Well Design",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_WELL_DESIGN",
    "description": "Well Design",
    "codedValues": [
     {
      "name": "Pitless Adapter",
      "code": "PA"
     },
     {
      "name": "Subsurface Vault",
      "code": "SSV"
     },
     {
      "name": "Surface Mount",
      "code": "SM"
     },
     {
      "name": "Flush Mount",
      "code": "FM"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "surfcasing",
   "type": "esriFieldTypeString",
   "alias": "Surface Casing",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "scasingmat",
   "type": "esriFieldTypeString",
   "alias": "Surface Casing Material",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_PIPE_MATERIAL",
    "description": "Pipe Material",
    "codedValues": [
     {
      "name": "PVC",
      "code": "PVC"
     },
     {
      "name": "Stainless Steel",
      "code": "SSTL"
     },
     {
      "name": "Carbon Steel",
      "code": "CSTL"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "scasing_depthobs_in",
   "type": "esriFieldTypeDouble",
   "alias": "Above Ground Casing",
   "domain": null
  },
  {
   "name": "scasing_depthactual_ft",
   "type": "esriFieldTypeDouble",
   "alias": "Surface Casing Depth",
   "domain": null
  },
  {
   "name": "scasing_outdia_in",
   "type": "esriFieldTypeDouble",
   "alias": "Surface Casing Outside Diameter",
   "domain": null
  },
  {
   "name": "scasing_thickness_in",
   "type": "esriFieldTypeDouble",
   "alias": "Surface Casing Thickness",
   "domain": null
  },
  {
   "name": "sealant",
   "type": "esriFieldTypeString",
   "alias": "Sealant",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_SEALANT",
    "description": "sealant",
    "codedValues": [
     {
      "name": "Bentonite",
      "code": "BEN"
     },
     {
      "name": "Cement Grout",
      "code": "CG"
     },
     {
      "name": "Well Pad",
      "code": "WP"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Cannot Discern",
      "code": "CD"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "annularseal",
   "type": "esriFieldTypeString",
   "alias": "Annular Seal",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_QUESTION",
    "description": "Direct Answer Short Question",
    "codedValues": [
     {
      "name": "N/A",
      "code": "N/A"
     },
     {
      "name": "Yes",
      "code": "YES"
     },
     {
      "name": "No",
      "code": "NO"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "annularseal_info",
   "type": "esriFieldTypeString",
   "alias": "Annular Seal Comments",
   "length": 500,
   "domain": null
  },
  {
   "name": "boreholedia_in",
   "type": "esriFieldTypeDouble",
   "alias": "Borehole Diameter",
   "domain": null
  },
  {
   "name": "pcasingmat",
   "type": "esriFieldTypeString",
   "alias": "Production Casing Material",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_PIPE_MATERIAL",
    "description": "Pipe Material",
    "codedValues": [
     {
      "name": "PVC",
      "code": "PVC"
     },
     {
      "name": "Stainless Steel",
      "code": "SSTL"
     },
     {
      "name": "Carbon Steel",
      "code": "CSTL"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "pcasing_depth_ft",
   "type": "esriFieldTypeDouble",
   "alias": "Production Casing Depth",
   "domain": null
  },
  {
   "name": "perflocation_ft",
   "type": "esriFieldTypeString",
   "alias": "Perforation Locations",
   "length": 255,
   "domain": null
  },
  {
   "name": "remarks",
   "type": "esriFieldTypeString",
   "alias": "Remarks",
   "length": 500,
   "domain": null
  },
  {
   "name": "parentguid",
   "type": "esriFieldTypeGUID",
   "alias": "Parent GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "g58parentguid",
   "fields": "parentguid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "uuid_32",
   "fields": "globalid,objectid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 6,
   "name": "D4_POD",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "parentguid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{0D3EC71E-4AD0-480A-98E8-F9B929B35DB9}"
  }
 ],
 "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,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": false,
  "supportsCurrentUserQueries": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Mountain Standard Time",
  "timeZoneIANA": "America/Denver",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": {
  "timeZone": "Mountain Standard Time",
  "timeZoneIANA": "America/Denver",
  "respectsDaylightSaving": true
 },
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1780927460000
 },
 "serviceItemId": "aa080c2888664fb38e795b8f0f1ff4bf"
}