{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 5,
 "name": "DSW_FishAdvisory",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SPECIES_CODE",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SPECIES_CODE",
   "type": "esriFieldTypeString",
   "alias": "Species Code",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_SPECIES_CODE",
    "description": "Shorten EA3 Fish Species",
    "codedValues": [
     {
      "name": "All Species",
      "code": "99-999"
     },
     {
      "name": "All Suckers",
      "code": "99-001"
     },
     {
      "name": "Bighead Carp",
      "code": "43-081"
     },
     {
      "name": "Bigmouth Buffalo",
      "code": "40-002"
     },
     {
      "name": "Black Bullhead",
      "code": "47-006"
     },
     {
      "name": "Black Crappie",
      "code": "77-002"
     },
     {
      "name": "Black Redhorse",
      "code": "40-009"
     },
     {
      "name": "Blue Catfish",
      "code": "47-001"
     },
     {
      "name": "Blue Sucker",
      "code": "40-001"
     },
     {
      "name": "Bluegill Sunfish",
      "code": "77-009"
     },
     {
      "name": "Bowfin",
      "code": "15-001"
     },
     {
      "name": "Brindled Madtom",
      "code": "47-012"
     },
     {
      "name": "Brook Silverside",
      "code": "70-001"
     },
     {
      "name": "Brook Stickleback",
      "code": "95-001"
     },
     {
      "name": "Brook Trout",
      "code": "25-003"
     },
     {
      "name": "Brown Bullhead",
      "code": "47-005"
     },
     {
      "name": "Brown Bullhead x Black Bullhead",
      "code": "47-015"
     },
     {
      "name": "Brown Trout",
      "code": "25-001"
     },
     {
      "name": "Burbot",
      "code": "60-001"
     },
     {
      "name": "Central Mudminnow",
      "code": "34-001"
     },
     {
      "name": "Chain Pickerel",
      "code": "37-002"
     },
     {
      "name": "Channel Catfish",
      "code": "47-002"
     },
     {
      "name": "Chinook Salmon",
      "code": "25-006"
     },
     {
      "name": "Cisco",
      "code": "25-007"
     },
     {
      "name": "Coho Salmon",
      "code": "25-005"
     },
     {
      "name": "Common Carp",
      "code": "43-001"
     },
     {
      "name": "Common Carp x Goldfish",
      "code": "43-045"
     },
     {
      "name": "Flathead Catfish",
      "code": "47-007"
     },
     {
      "name": "Freckled Madtom",
      "code": "47-016"
     },
     {
      "name": "Freshwater Drum",
      "code": "85-001"
     },
     {
      "name": "Gizzard Shad",
      "code": "20-003"
     },
     {
      "name": "Golden Redhorse",
      "code": "40-010"
     },
     {
      "name": "Goldeye",
      "code": "18-001"
     },
     {
      "name": "Goldfish",
      "code": "43-002"
     },
     {
      "name": "Grass Carp",
      "code": "43-047"
     },
     {
      "name": "Grass Pickerel x Chain Pickerel",
      "code": "37-006"
     },
     {
      "name": "Greater Redhorse",
      "code": "40-012"
     },
     {
      "name": "Green Sunfish",
      "code": "77-008"
     },
     {
      "name": "Lake Sturgeon",
      "code": "08-001"
     },
     {
      "name": "Lake Trout",
      "code": "25-004"
     },
     {
      "name": "Lake Whitefish",
      "code": "25-008"
     },
     {
      "name": "Largemouth Bass",
      "code": "77-006"
     },
     {
      "name": "Longear Sunfish",
      "code": "77-011"
     },
     {
      "name": "Longnose Sucker",
      "code": "40-017"
     },
     {
      "name": "Mooneye",
      "code": "18-002"
     },
     {
      "name": "Mountain Madtom",
      "code": "47-009"
     },
     {
      "name": "Muskellunge",
      "code": "37-004"
     },
     {
      "name": "Northern Hog Sucker",
      "code": "40-015"
     },
     {
      "name": "Northern Madtom",
      "code": "47-010"
     },
     {
      "name": "Northern Pike",
      "code": "37-003"
     },
     {
      "name": "Orangespotted Sunfish",
      "code": "77-010"
     },
     {
      "name": "Paddlefish",
      "code": "04-001"
     },
     {
      "name": "Pike Muskellunge Hybrid",
      "code": "37-005"
     },
     {
      "name": "Pink Salmon",
      "code": "25-009"
     },
     {
      "name": "Pirate Perch",
      "code": "68-001"
     },
     {
      "name": "Pumpkinseed Sunfish",
      "code": "77-013"
     },
     {
      "name": "Quillback",
      "code": "40-005"
     },
     {
      "name": "Rainbow Smelt",
      "code": "30-001"
     },
     {
      "name": "Rainbow Trout",
      "code": "25-002"
     },
     {
      "name": "Redear Sunfish",
      "code": "77-012"
     },
     {
      "name": "Redfin Pickerel",
      "code": "37-001"
     },
     {
      "name": "River Carpsucker",
      "code": "40-006"
     },
     {
      "name": "River Redhorse",
      "code": "40-013"
     },
     {
      "name": "Rock Bass",
      "code": "77-003"
     },
     {
      "name": "Round Goby",
      "code": "87-001"
     },
     {
      "name": "Sauger",
      "code": "80-001"
     },
     {
      "name": "Saugeye",
      "code": "80-026"
     },
     {
      "name": "Scioto Madtom",
      "code": "47-011"
     },
     {
      "name": "Shorthead Redhorse",
      "code": "40-011"
     },
     {
      "name": "Shovelnose Sturgeon",
      "code": "08-002"
     },
     {
      "name": "Silver Carp",
      "code": "43-079"
     },
     {
      "name": "Silver Redhorse",
      "code": "40-008"
     },
     {
      "name": "Skipjack Herring",
      "code": "20-001"
     },
     {
      "name": "Smallmouth Bass",
      "code": "77-004"
     },
     {
      "name": "Smallmouth Buffalo",
      "code": "40-004"
     },
     {
      "name": "Smallmouth Redhorse",
      "code": "40-023"
     },
     {
      "name": "Spotted Bass",
      "code": "77-005"
     },
     {
      "name": "Spotted Sucker",
      "code": "40-018"
     },
     {
      "name": "Spotted Sunfish",
      "code": "77-027"
     },
     {
      "name": "Steelhead Trout",
      "code": "99-002"
     },
     {
      "name": "Stonecat Madtom",
      "code": "47-008"
     },
     {
      "name": "Striped Bass",
      "code": "74-002"
     },
     {
      "name": "Striped Hybrid Bass/Wiper",
      "code": "74-005"
     },
     {
      "name": "Tadpole Madtom",
      "code": "47-013"
     },
     {
      "name": "Threadfin Shad",
      "code": "20-004"
     },
     {
      "name": "Three-Spine Stickleback",
      "code": "95-002"
     },
     {
      "name": "Trout-Perch",
      "code": "63-001"
     },
     {
      "name": "Tubenose Goby",
      "code": "87-002"
     },
     {
      "name": "Walleye",
      "code": "80-002"
     },
     {
      "name": "Warmouth Sunfish",
      "code": "77-007"
     },
     {
      "name": "White Bass",
      "code": "74-001"
     },
     {
      "name": "White Bass x White Perch",
      "code": "74-004"
     },
     {
      "name": "White Catfish",
      "code": "47-003"
     },
     {
      "name": "White Crappie",
      "code": "77-001"
     },
     {
      "name": "White Perch",
      "code": "74-003"
     },
     {
      "name": "White Sucker",
      "code": "40-016"
     },
     {
      "name": "Yellow Bass",
      "code": "74-006"
     },
     {
      "name": "Yellow Bullhead",
      "code": "47-004"
     },
     {
      "name": "Yellow Bullhead x Brown Bullhead",
      "code": "47-014"
     },
     {
      "name": "Yellow Perch",
      "code": "80-003"
     },
     {
      "name": "All Fish Not Specified in this Table",
      "code": "99-998"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ADVIS_FREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ADVIS_FREQ",
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_ADVIS_FREQ",
    "description": "Advisory Consumption Frequency",
    "codedValues": [
     {
      "name": "Unrestricted Consumption",
      "code": 1
     },
     {
      "name": "Two meals per week",
      "code": 2
     },
     {
      "name": "One meal per week",
      "code": 3
     },
     {
      "name": "One meal per month",
      "code": 4
     },
     {
      "name": "Six meals per year",
      "code": 5
     },
     {
      "name": "Do Not Eat",
      "code": 6
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SIZE_CODE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "SIZE_CODE",
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_SIZE_CODE",
    "description": "Fish Size",
    "codedValues": [
     {
      "name": "8\" and over",
      "code": 2
     },
     {
      "name": "Under 8\"",
      "code": 3
     },
     {
      "name": "9\" and over",
      "code": 4
     },
     {
      "name": "Under 9\"",
      "code": 5
     },
     {
      "name": "10\" and over",
      "code": 6
     },
     {
      "name": "Under 10\"",
      "code": 7
     },
     {
      "name": "11\" and over",
      "code": 8
     },
     {
      "name": "Under 11\"",
      "code": 9
     },
     {
      "name": "12\" and over",
      "code": 10
     },
     {
      "name": "Under 12\"",
      "code": 11
     },
     {
      "name": "13\" and over",
      "code": 12
     },
     {
      "name": "Under 13\"",
      "code": 13
     },
     {
      "name": "14\" and over",
      "code": 14
     },
     {
      "name": "Under 14\"",
      "code": 15
     },
     {
      "name": "15\" and over",
      "code": 16
     },
     {
      "name": "Under 15\"",
      "code": 17
     },
     {
      "name": "16\" and over",
      "code": 18
     },
     {
      "name": "Under 16\"",
      "code": 19
     },
     {
      "name": "17\" and over",
      "code": 20
     },
     {
      "name": "Under 17\"",
      "code": 21
     },
     {
      "name": "18\" and over",
      "code": 22
     },
     {
      "name": "Under 18\"",
      "code": 23
     },
     {
      "name": "19\" and over",
      "code": 24
     },
     {
      "name": "Under 19\"",
      "code": 25
     },
     {
      "name": "20\" and over",
      "code": 26
     },
     {
      "name": "Under 20\"",
      "code": 27
     },
     {
      "name": "21\" and over",
      "code": 28
     },
     {
      "name": "Under 21\"",
      "code": 29
     },
     {
      "name": "22\" and over",
      "code": 30
     },
     {
      "name": "Under 22\"",
      "code": 31
     },
     {
      "name": "23\" and over",
      "code": 32
     },
     {
      "name": "Under 23\"",
      "code": 33
     },
     {
      "name": "24\" and over",
      "code": 34
     },
     {
      "name": "Under 24\"",
      "code": 35
     },
     {
      "name": "25\" and over",
      "code": 36
     },
     {
      "name": "Under 25\"",
      "code": 37
     },
     {
      "name": "26\" and over",
      "code": 38
     },
     {
      "name": "Under 26\"",
      "code": 39
     },
     {
      "name": "27\" and over",
      "code": 40
     },
     {
      "name": "Under 27\"",
      "code": 41
     },
     {
      "name": "All Sizes",
      "code": 1
     },
     {
      "name": "Between 20\" and 27\"",
      "code": 42
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "START_DATE",
   "type": "esriFieldTypeDate",
   "alias": "START_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "END_DATE",
   "type": "esriFieldTypeDate",
   "alias": "END_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "Advisory Status",
   "length": 2,
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_STATUS",
    "description": "Advisory Status",
    "codedValues": [
     {
      "name": "Inactive",
      "code": "N"
     },
     {
      "name": "Active",
      "code": "Y"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "ADVIS_CHEM_2",
   "type": "esriFieldTypeInteger",
   "alias": "Chemical Advisory 2",
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_CHEM_ADVIS",
    "description": "Fish Tissue Chemical Advisory",
    "codedValues": [
     {
      "name": "Hexachlorobenzene",
      "code": 1
     },
     {
      "name": "Mirex",
      "code": 2
     },
     {
      "name": "Mercury",
      "code": 3
     },
     {
      "name": "Lead",
      "code": 4
     },
     {
      "name": "Cadmium",
      "code": 5
     },
     {
      "name": "Arsenic",
      "code": 6
     },
     {
      "name": "Selenium",
      "code": 7
     },
     {
      "name": "Aldrin",
      "code": 8
     },
     {
      "name": "Heptachlor",
      "code": 9
     },
     {
      "name": "HCH isomers",
      "code": 10
     },
     {
      "name": "Total DDT",
      "code": 11
     },
     {
      "name": "Dieldrin",
      "code": 12
     },
     {
      "name": "Total Endosulfan",
      "code": 13
     },
     {
      "name": "Endrin",
      "code": 14
     },
     {
      "name": "Lindane",
      "code": 15
     },
     {
      "name": "Heptachlor epoxide",
      "code": 16
     },
     {
      "name": "Methoxychlor",
      "code": 17
     },
     {
      "name": "Total PCBs",
      "code": 18
     },
     {
      "name": "None",
      "code": 19
     },
     {
      "name": "Total PAHs",
      "code": 20
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ADVIS_CHEM_3",
   "type": "esriFieldTypeInteger",
   "alias": "Chemical Advisory 3",
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_CHEM_ADVIS",
    "description": "Fish Tissue Chemical Advisory",
    "codedValues": [
     {
      "name": "Hexachlorobenzene",
      "code": 1
     },
     {
      "name": "Mirex",
      "code": 2
     },
     {
      "name": "Mercury",
      "code": 3
     },
     {
      "name": "Lead",
      "code": 4
     },
     {
      "name": "Cadmium",
      "code": 5
     },
     {
      "name": "Arsenic",
      "code": 6
     },
     {
      "name": "Selenium",
      "code": 7
     },
     {
      "name": "Aldrin",
      "code": 8
     },
     {
      "name": "Heptachlor",
      "code": 9
     },
     {
      "name": "HCH isomers",
      "code": 10
     },
     {
      "name": "Total DDT",
      "code": 11
     },
     {
      "name": "Dieldrin",
      "code": 12
     },
     {
      "name": "Total Endosulfan",
      "code": 13
     },
     {
      "name": "Endrin",
      "code": 14
     },
     {
      "name": "Lindane",
      "code": 15
     },
     {
      "name": "Heptachlor epoxide",
      "code": 16
     },
     {
      "name": "Methoxychlor",
      "code": 17
     },
     {
      "name": "Total PCBs",
      "code": 18
     },
     {
      "name": "None",
      "code": 19
     },
     {
      "name": "Total PAHs",
      "code": 20
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GUID",
   "type": "esriFieldTypeGUID",
   "alias": "GUID",
   "length": 38,
   "domain": null
  },
  {
   "name": "CHEM_1",
   "type": "esriFieldTypeInteger",
   "alias": "CHEM_1",
   "domain": {
    "type": "codedValue",
    "name": "DSW_FA_CHEM_ADVIS",
    "description": "Fish Tissue Chemical Advisory",
    "codedValues": [
     {
      "name": "Hexachlorobenzene",
      "code": 1
     },
     {
      "name": "Mirex",
      "code": 2
     },
     {
      "name": "Mercury",
      "code": 3
     },
     {
      "name": "Lead",
      "code": 4
     },
     {
      "name": "Cadmium",
      "code": 5
     },
     {
      "name": "Arsenic",
      "code": 6
     },
     {
      "name": "Selenium",
      "code": 7
     },
     {
      "name": "Aldrin",
      "code": 8
     },
     {
      "name": "Heptachlor",
      "code": 9
     },
     {
      "name": "HCH isomers",
      "code": 10
     },
     {
      "name": "Total DDT",
      "code": 11
     },
     {
      "name": "Dieldrin",
      "code": 12
     },
     {
      "name": "Total Endosulfan",
      "code": 13
     },
     {
      "name": "Endrin",
      "code": 14
     },
     {
      "name": "Lindane",
      "code": 15
     },
     {
      "name": "Heptachlor epoxide",
      "code": 16
     },
     {
      "name": "Methoxychlor",
      "code": 17
     },
     {
      "name": "Total PCBs",
      "code": 18
     },
     {
      "name": "None",
      "code": 19
     },
     {
      "name": "Total PAHs",
      "code": 20
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "G2271GUID",
   "fields": "GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R146_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_146",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "DSW_FA_Lakes_Polygon",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{09D730D5-F51F-46AF-9FF9-8CCF89EDF535}"
  },
  {
   "id": 2,
   "name": "DSW_FA_Lakes_Polygon",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{09D730D5-F51F-46AF-9FF9-8CCF89EDF535}"
  },
  {
   "id": 1,
   "name": "DSW_FA_Streams_Line",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{F0420048-0C35-4532-9832-401446523260}"
  }
 ],
 "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": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "7d8b7ad25e23445b9069b37b7e12bb3c"
}