{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "Inspections",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "Created",
  "creatorField": "Creator",
  "editDateField": "Edited",
  "editorField": "Editor"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 3,
   "name": "mn_nid",
   "relatedTableId": 0,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "mn_nid_guid",
   "composite": true,
   "catalogID": "{84986C43-B224-4AAA-9645-458EE385AC51}"
  }
 ],
 "isDataVersioned": false,
 "isDataArchived": true,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1614201314000
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": false
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "objectid",
 "globalIdField": "globalid",
 "displayField": "creator",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "objectid",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "objectid"
  },
  {
   "name": "globalid",
   "type": "esriFieldTypeGlobalID",
   "alias": "globalid",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "globalid"
  },
  {
   "name": "creator",
   "type": "esriFieldTypeString",
   "alias": "creator",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "creator"
  },
  {
   "name": "created",
   "type": "esriFieldTypeDate",
   "alias": "created",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created"
  },
  {
   "name": "editor",
   "type": "esriFieldTypeString",
   "alias": "editor",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "editor"
  },
  {
   "name": "edited",
   "type": "esriFieldTypeDate",
   "alias": "edited",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "edited"
  },
  {
   "name": "mn_nid_guid",
   "type": "esriFieldTypeGUID",
   "alias": "mn_nid_guid",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 38,
   "defaultValue": null,
   "modelName": "mn_nid_guid"
  },
  {
   "name": "inspecting_group",
   "type": "esriFieldTypeString",
   "alias": "inspecting_group",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "inspecting_group"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "next_insp_year"
  },
  {
   "name": "insp_date",
   "type": "esriFieldTypeDate",
   "alias": "insp_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "insp_date"
  },
  {
   "name": "rpt_writer_assi",
   "type": "esriFieldTypeString",
   "alias": "rpt_writer_assi",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "rpt_writer_assi"
  },
  {
   "name": "insp_rpt_comp_date",
   "type": "esriFieldTypeDate",
   "alias": "insp_rpt_comp_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "insp_rpt_comp_date"
  },
  {
   "name": "condition_date",
   "type": "esriFieldTypeDate",
   "alias": "condition_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "condition_date"
  },
  {
   "name": "condition_assessment",
   "type": "esriFieldTypeString",
   "alias": "condition_assessment",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "condition_assessment"
  },
  {
   "name": "operationalstatus",
   "type": "esriFieldTypeString",
   "alias": "operationalstatus",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "operationalstatus"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "insp_freq"
  },
  {
   "name": "initial_inspection_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "initial_inspection_year",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "initial_inspection_year"
  },
  {
   "name": "pre_inspection_comments",
   "type": "esriFieldTypeString",
   "alias": "pre_inspection_comments",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 300,
   "defaultValue": null,
   "modelName": "pre_inspection_comments"
  },
  {
   "name": "inspection_notice_date_sent",
   "type": "esriFieldTypeDate",
   "alias": "inspection_notice_date_sent",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "inspection_notice_date_sent"
  },
  {
   "name": "inspection_notice_action",
   "type": "esriFieldTypeString",
   "alias": "inspection_notice_action",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 30,
   "defaultValue": null,
   "modelName": "inspection_notice_action"
  },
  {
   "name": "dam_name",
   "type": "esriFieldTypeString",
   "alias": "dam_name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "dam_name"
  }
 ],
 "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": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Central Standard Time",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Inspections",
   "description": "",
   "prototype": {
    "attributes": {
     "inspection_notice_action": null,
     "dam_name": null,
     "inspection_notice_date_sent": null,
     "pre_inspection_comments": null,
     "initial_inspection_year": null,
     "insp_freq": null,
     "mn_nid_guid": null,
     "inspecting_group": null,
     "next_insp_year": null,
     "insp_date": null,
     "rpt_writer_assi": null,
     "insp_rpt_comp_date": null,
     "condition_date": null,
     "condition_assessment": null,
     "operationalstatus": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "df0452a7230b4f39bf7399f98a760df4"
}