{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "Inspections",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "creator",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "objectid",
   "domain": null
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "globalid",
   "length": 38,
   "domain": null
  },
  {
   "name": "creator",
   "type": "esriFieldTypeString",
   "alias": "creator",
   "length": 255,
   "domain": null
  },
  {
   "name": "created",
   "type": "esriFieldTypeDate",
   "alias": "created",
   "length": 8,
   "domain": null
  },
  {
   "name": "editor",
   "type": "esriFieldTypeString",
   "alias": "editor",
   "length": 255,
   "domain": null
  },
  {
   "name": "edited",
   "type": "esriFieldTypeDate",
   "alias": "edited",
   "length": 8,
   "domain": null
  },
  {
   "name": "mn_nid_guid",
   "type": "esriFieldTypeGUID",
   "alias": "mn_nid_guid",
   "length": 38,
   "domain": null
  },
  {
   "name": "inspecting_group",
   "type": "esriFieldTypeString",
   "alias": "inspecting_group",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "code_inspecting_group",
    "description": "Inspecting_GroupR",
    "codedValues": [
     {
      "name": "BIA",
      "code": "BIA"
     },
     {
      "name": "Check",
      "code": "Check"
     },
     {
      "name": "DamSafety",
      "code": "DamSafety"
     },
     {
      "name": "DamSafety, Area II",
      "code": "DamSafety, Area II"
     },
     {
      "name": "DamSafety, Barr Eng",
      "code": "DamSafety, Barr Eng"
     },
     {
      "name": "DamSafety, Houston Eng",
      "code": "DamSafety, Houston Eng"
     },
     {
      "name": "DamSafety, NDSWC",
      "code": "DamSafety, NDSWC"
     },
     {
      "name": "DamSafety, NRCS",
      "code": "DamSafety, NRCS"
     },
     {
      "name": "DamSafety, WD",
      "code": "DamSafety, WD"
     },
     {
      "name": "Exempt",
      "code": "Exempt"
     },
     {
      "name": "Federal",
      "code": "Federal"
     },
     {
      "name": "FERC",
      "code": "FERC"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "next_insp_year",
   "type": "esriFieldTypeInteger",
   "alias": "next_insp_year",
   "domain": {
    "type": "codedValue",
    "name": "code_next_inspection_year",
    "description": "Next_Inspec_YearR",
    "codedValues": [
     {
      "name": "1111",
      "code": 1111
     },
     {
      "name": "2020",
      "code": 2020
     },
     {
      "name": "2021",
      "code": 2021
     },
     {
      "name": "2022",
      "code": 2022
     },
     {
      "name": "2023",
      "code": 2023
     },
     {
      "name": "2024",
      "code": 2024
     },
     {
      "name": "2025",
      "code": 2025
     },
     {
      "name": "2026",
      "code": 2026
     },
     {
      "name": "2027",
      "code": 2027
     },
     {
      "name": "2028",
      "code": 2028
     },
     {
      "name": "2029",
      "code": 2029
     },
     {
      "name": "2030",
      "code": 2030
     },
     {
      "name": "2031",
      "code": 2031
     },
     {
      "name": "2032",
      "code": 2032
     },
     {
      "name": "2033",
      "code": 2033
     },
     {
      "name": "2034",
      "code": 2034
     },
     {
      "name": "2035",
      "code": 2035
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "insp_date",
   "type": "esriFieldTypeDate",
   "alias": "insp_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "rpt_writer_assi",
   "type": "esriFieldTypeString",
   "alias": "rpt_writer_assi",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "code_report_writer",
    "description": "RptWriterAssigned",
    "codedValues": [
     {
      "name": "Consultant",
      "code": "Consultant"
     },
     {
      "name": "Dan Zwilling",
      "code": "Dan Zwilling"
     },
     {
      "name": "Dana Dostert",
      "code": "Dana Dostert"
     },
     {
      "name": "Jason Boyle",
      "code": "Jason Boyle"
     },
     {
      "name": "NRCS",
      "code": "NRCS"
     },
     {
      "name": "Rachel Lindgren",
      "code": "Rachel Lindgren"
     },
     {
      "name": "Steve Gerber",
      "code": "Steve Gerber"
     },
     {
      "name": "Bogale Abebe",
      "code": "Bogale Abebe"
     },
     {
      "name": "Michael Crellin",
      "code": "Michael Crellin"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "insp_rpt_comp_date",
   "type": "esriFieldTypeDate",
   "alias": "insp_rpt_comp_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "condition_date",
   "type": "esriFieldTypeDate",
   "alias": "condition_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "condition_assessment",
   "type": "esriFieldTypeString",
   "alias": "condition_assessment",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "code_condition",
    "description": "ConditionAssessment",
    "codedValues": [
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Not Rated",
      "code": "Not Rated"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Satisfactory",
      "code": "Satisfactory"
     },
     {
      "name": "Unsatisfactory",
      "code": "Unsatisfactory"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "operationalstatus",
   "type": "esriFieldTypeString",
   "alias": "operationalstatus",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "code_operationalstatus",
    "description": "ConditionAssessmentDetail",
    "codedValues": [
     {
      "name": "Enforcement Pending/Ongoing",
      "code": "Enforcement Pending/Ongoing"
     },
     {
      "name": "Normal Operations",
      "code": "Normal Operations"
     },
     {
      "name": "Not Applicable",
      "code": "Not Applicable"
     },
     {
      "name": "Under Investigation",
      "code": "Under Investigation"
     },
     {
      "name": "Under Remediation",
      "code": "Under Remediation"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "insp_freq",
   "type": "esriFieldTypeSmallInteger",
   "alias": "insp_freq",
   "domain": {
    "type": "codedValue",
    "name": "code_inspection_frequency",
    "description": "Insp_freq",
    "codedValues": [
     {
      "name": "1",
      "code": 1
     },
     {
      "name": "10",
      "code": 10
     },
     {
      "name": "4",
      "code": 4
     },
     {
      "name": "8",
      "code": 8
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "initial_inspection_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "initial_inspection_year",
   "domain": null
  },
  {
   "name": "pre_inspection_comments",
   "type": "esriFieldTypeString",
   "alias": "pre_inspection_comments",
   "length": 300,
   "domain": null
  },
  {
   "name": "inspection_notice_date_sent",
   "type": "esriFieldTypeDate",
   "alias": "inspection_notice_date_sent",
   "length": 8,
   "domain": null
  },
  {
   "name": "inspection_notice_action",
   "type": "esriFieldTypeString",
   "alias": "inspection_notice_action",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "code_inspection_notice_action",
    "description": "InspecNoticeAction",
    "codedValues": [
     {
      "name": "Call",
      "code": "Call"
     },
     {
      "name": "Inspection by Others",
      "code": "Inspection by Others"
     },
     {
      "name": "Mining",
      "code": "Mining"
     },
     {
      "name": "Not needed",
      "code": "Not needed"
     },
     {
      "name": "Notice was sent",
      "code": "Notice was sent"
     },
     {
      "name": "See Pre-Inspec-note",
      "code": "See Pre-Inspec-note"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "dam_name",
   "type": "esriFieldTypeString",
   "alias": "dam_name",
   "length": 100,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "gdb_997_mn_nid_g",
   "fields": "mn_nid_guid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "r94_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "uuid_94",
   "fields": "globalid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "mn_nid",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "mn_nid_guid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{84986C43-B224-4AAA-9645-458EE385AC51}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": false
 },
 "dateFieldsTimeReference": {
  "timeZone": "Central Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1614201314000
 },
 "serviceItemId": "65f8cd541a2942b1822c0403a0ac187e"
}