{
 "currentVersion": 11.4,
 "cimVersion": "3.4.0",
 "id": 19,
 "name": "D4_POD_Well_Driller",
 "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": 255,
   "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": "rigplacard",
   "type": "esriFieldTypeString",
   "alias": "Rig Placard",
   "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": "drilling_method",
   "type": "esriFieldTypeString",
   "alias": "Drilling Method",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "D4_DRILLING_METHOD",
    "description": "Drilling Method",
    "codedValues": [
     {
      "name": "Mud Rotary",
      "code": "MUD"
     },
     {
      "name": "Air Rotary",
      "code": "AIR"
     },
     {
      "name": "Sonic",
      "code": "SON"
     },
     {
      "name": "Casing Advance",
      "code": "CADAD"
     },
     {
      "name": "Auger",
      "code": "AUG"
     },
     {
      "name": "Core",
      "code": "CORE"
     },
     {
      "name": "Cable Tool",
      "code": "CABLE"
     },
     {
      "name": "Other",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "rigoperating",
   "type": "esriFieldTypeString",
   "alias": "Rig Operating",
   "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": "certifiedmat_onsite",
   "type": "esriFieldTypeString",
   "alias": "Certified Materials 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": "materialsobserved",
   "type": "esriFieldTypeString",
   "alias": "Materials Observed",
   "length": 500,
   "domain": null
  },
  {
   "name": "fluids_onsite",
   "type": "esriFieldTypeString",
   "alias": "Fluids Stored 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": "fluid_discharge",
   "type": "esriFieldTypeString",
   "alias": "Fluids Discharged Off-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": "drillcutt_onsite",
   "type": "esriFieldTypeString",
   "alias": "Drill Cuttings 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": "cutt_discharge",
   "type": "esriFieldTypeString",
   "alias": "Cuttings Discharged Off-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": "rigleak_borehole",
   "type": "esriFieldTypeString",
   "alias": "Rig Fluids Leak in Borehole",
   "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": "borehole_depth",
   "type": "esriFieldTypeDouble",
   "alias": "Borehole Depth",
   "domain": null
  },
  {
   "name": "activitiesperformed",
   "type": "esriFieldTypeString",
   "alias": "Activities Being Performed",
   "length": 500,
   "domain": null
  },
  {
   "name": "other_obs",
   "type": "esriFieldTypeString",
   "alias": "Other Observations",
   "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": "g54parentguid",
   "fields": "parentguid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "uuid_28",
   "fields": "globalid,objectid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 5,
   "name": "D4_POD",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "parentguid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{2B3A47B9-56A9-4012-BB0D-05D721E9B80B}"
  }
 ],
 "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": 1780927456000
 },
 "serviceItemId": "aa080c2888664fb38e795b8f0f1ff4bf"
}