{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "DSW_FishAdvisory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "DSW_FA_Lakes_Polygon", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{09D730D5-F51F-46AF-9FF9-8CCF89EDF535}" }, { "id": 2, "name": "DSW_FA_Lakes_Polygon", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{09D730D5-F51F-46AF-9FF9-8CCF89EDF535}" }, { "id": 1, "name": "DSW_FA_Streams_Line", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GUID", "composite": false, "catalogID": "{F0420048-0C35-4532-9832-401446523260}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "SPECIES_CODE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SPECIES_CODE", "type": "esriFieldTypeString", "alias": "Species Code", "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" }, "editable": true, "nullable": false, "length": 6, "defaultValue": null, "modelName": "SPECIES_CODE" }, { "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" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ADVIS_FREQ" }, { "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" }, "editable": true, "nullable": false, "defaultValue": null, "modelName": "SIZE_CODE" }, { "name": "START_DATE", "type": "esriFieldTypeDate", "alias": "START_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "START_DATE" }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "END_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "END_DATE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Advisory Status", "domain": { "type": "codedValue", "name": "DSW_FA_STATUS", "description": "Advisory Status", "codedValues": [ { "name": "Inactive", "code": "N" }, { "name": "Active", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 2, "defaultValue": null, "modelName": "STATUS" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADVIS_CHEM_2" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADVIS_CHEM_3" }, { "name": "GUID", "type": "esriFieldTypeGUID", "alias": "GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GUID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CHEM_1" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "DSW_FishAdvisory", "description": "", "prototype": { "attributes": { "GUID": null, "ADVIS_CHEM_3": null, "SPECIES_CODE": " ", "ADVIS_FREQ": 0, "SIZE_CODE": 0, "START_DATE": null, "END_DATE": null, "STATUS": " ", "CHEM_1": null, "ADVIS_CHEM_2": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "bd0a33331bcd420583fd3a791ac0c36f" }