{ "currentVersion": 10.91, "id": 2, "name": "FishDetail", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SampleYear", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StationID", "type": "esriFieldTypeDouble", "alias": "Station ID", "domain": null }, { "name": "SampleYear", "type": "esriFieldTypeDouble", "alias": "Sample Year", "domain": null }, { "name": "SampleID", "type": "esriFieldTypeDouble", "alias": "Sample ID", "domain": null }, { "name": "AE", "type": "esriFieldTypeDouble", "alias": "American Eel", "domain": null }, { "name": "AL", "type": "esriFieldTypeDouble", "alias": "Alewife", "domain": null }, { "name": "AS", "type": "esriFieldTypeDouble", "alias": "American Shad", "domain": null }, { "name": "BB", "type": "esriFieldTypeDouble", "alias": "Brown Bullhead", "domain": null }, { "name": "BC", "type": "esriFieldTypeDouble", "alias": "Black Crappie", "domain": null }, { "name": "BD", "type": "esriFieldTypeDouble", "alias": "Bridled Shiner", "domain": null }, { "name": "BG", "type": "esriFieldTypeDouble", "alias": "Bluegill Sunfish", "domain": null }, { "name": "BH", "type": "esriFieldTypeDouble", "alias": "Blueback Herring", "domain": null }, { "name": "BK", "type": "esriFieldTypeDouble", "alias": "Brook Trout - Stocked", "domain": null }, { "name": "BL", "type": "esriFieldTypeDouble", "alias": "Blacknose Dace", "domain": null }, { "name": "BM", "type": "esriFieldTypeDouble", "alias": "Bluntnose Minnow", "domain": null }, { "name": "BN", "type": "esriFieldTypeDouble", "alias": "Brown Trout - Stocked", "domain": null }, { "name": "BP", "type": "esriFieldTypeDouble", "alias": "Bluegill x Pumpkinseed Hybrid", "domain": null }, { "name": "BS", "type": "esriFieldTypeDouble", "alias": "Banded Sunfish", "domain": null }, { "name": "BF", "type": "esriFieldTypeDouble", "alias": "Bowfin", "domain": null }, { "name": "CA", "type": "esriFieldTypeDouble", "alias": "Common Carp", "domain": null }, { "name": "CC", "type": "esriFieldTypeDouble", "alias": "Channel Catfish", "domain": null }, { "name": "CH", "type": "esriFieldTypeDouble", "alias": "Creek Chubsucker", "domain": null }, { "name": "CM", "type": "esriFieldTypeDouble", "alias": "Cutlips Minnow", "domain": null }, { "name": "CP", "type": "esriFieldTypeDouble", "alias": "Chain Pickerel", "domain": null }, { "name": "CR", "type": "esriFieldTypeDouble", "alias": "Creek Chub", "domain": null }, { "name": "CS", "type": "esriFieldTypeDouble", "alias": "Common Shiner", "domain": null }, { "name": "FF", "type": "esriFieldTypeDouble", "alias": "Fallfish", "domain": null }, { "name": "FM", "type": "esriFieldTypeDouble", "alias": "Fathead Minnow", "domain": null }, { "name": "FS", "type": "esriFieldTypeDouble", "alias": "Fourspine Stickleback", "domain": null }, { "name": "GF", "type": "esriFieldTypeDouble", "alias": "Goldfish", "domain": null }, { "name": "GR", "type": "esriFieldTypeDouble", "alias": "Green Sunfish", "domain": null }, { "name": "GS", "type": "esriFieldTypeDouble", "alias": "Golden Shiner", "domain": null }, { "name": "GI", "type": "esriFieldTypeDouble", "alias": "Gizard Shad", "domain": null }, { "name": "HO", "type": "esriFieldTypeDouble", "alias": "Hogchoker", "domain": null }, { "name": "KI", "type": "esriFieldTypeDouble", "alias": "Banded Killifish", "domain": null }, { "name": "LA", "type": "esriFieldTypeDouble", "alias": "Brook Lamprey", "domain": null }, { "name": "LD", "type": "esriFieldTypeDouble", "alias": "Longnose Dace", "domain": null }, { "name": "LL", "type": "esriFieldTypeDouble", "alias": "Burbot", "domain": null }, { "name": "LM", "type": "esriFieldTypeDouble", "alias": "Largemouth Bass", "domain": null }, { "name": "MM", "type": "esriFieldTypeDouble", "alias": "Central Mudminnow", "domain": null }, { "name": "MU", "type": "esriFieldTypeDouble", "alias": "Mummichog", "domain": null }, { "name": "NP", "type": "esriFieldTypeDouble", "alias": "Northern Pike", "domain": null }, { "name": "NS", "type": "esriFieldTypeDouble", "alias": "Ninespine Stickleback", "domain": null }, { "name": "PR", "type": "esriFieldTypeDouble", "alias": "Pumpkinseed x Redbreast Hybrid", "domain": null }, { "name": "PS", "type": "esriFieldTypeDouble", "alias": "Pumpkinseed", "domain": null }, { "name": "RB", "type": "esriFieldTypeDouble", "alias": "Rock Bass", "domain": null }, { "name": "RP", "type": "esriFieldTypeDouble", "alias": "Redfin Pickerel", "domain": null }, { "name": "RS", "type": "esriFieldTypeDouble", "alias": "Redbreast Sunfish", "domain": null }, { "name": "RW", "type": "esriFieldTypeDouble", "alias": "Rainbow Trout - Stocked", "domain": null }, { "name": "SA", "type": "esriFieldTypeDouble", "alias": "Atlantic Salmon - Stocked", "domain": null }, { "name": "SC", "type": "esriFieldTypeDouble", "alias": "Slimy Sculpin", "domain": null }, { "name": "SD", "type": "esriFieldTypeDouble", "alias": "Swamp Darter", "domain": null }, { "name": "SK", "type": "esriFieldTypeDouble", "alias": "Striped Killifish", "domain": null }, { "name": "SL", "type": "esriFieldTypeDouble", "alias": "Sea Lamprey", "domain": null }, { "name": "SM", "type": "esriFieldTypeDouble", "alias": "Smallmouth Bass", "domain": null }, { "name": "SS", "type": "esriFieldTypeDouble", "alias": "Spottail Shiner", "domain": null }, { "name": "TD", "type": "esriFieldTypeDouble", "alias": "Tessellated Darter", "domain": null }, { "name": "TI", "type": "esriFieldTypeDouble", "alias": "Tidewater Silverside", "domain": null }, { "name": "TO", "type": "esriFieldTypeDouble", "alias": "Tomcod", "domain": null }, { "name": "TS", "type": "esriFieldTypeDouble", "alias": "Three Spine Stickleback", "domain": null }, { "name": "TT", "type": "esriFieldTypeDouble", "alias": "Tiger Trout - Stocked", "domain": null }, { "name": "WA", "type": "esriFieldTypeDouble", "alias": "Walleye", "domain": null }, { "name": "WBK", "type": "esriFieldTypeDouble", "alias": "Brook Trout - Wild", "domain": null }, { "name": "WBN", "type": "esriFieldTypeDouble", "alias": "Brown Trout - Wild", "domain": null }, { "name": "WC", "type": "esriFieldTypeDouble", "alias": "White Catfish", "domain": null }, { "name": "WP", "type": "esriFieldTypeDouble", "alias": "White Perch", "domain": null }, { "name": "WRW", "type": "esriFieldTypeDouble", "alias": "Rainbow Trout - Wild", "domain": null }, { "name": "WS", "type": "esriFieldTypeDouble", "alias": "White Sucker", "domain": null }, { "name": "YB", "type": "esriFieldTypeDouble", "alias": "Yellow Bullhead", "domain": null }, { "name": "YP", "type": "esriFieldTypeDouble", "alias": "Yellow Perch", "domain": null }, { "name": "ZZZ", "type": "esriFieldTypeDouble", "alias": "No fish in sample", "domain": null }, { "name": "BR", "type": "esriFieldTypeDouble", "alias": "Brook Silverside", "domain": null }, { "name": "BU", "type": "esriFieldTypeDouble", "alias": "Black Bullhead", "domain": null }, { "name": "GC", "type": "esriFieldTypeDouble", "alias": "Grass Carp", "domain": null }, { "name": "HS", "type": "esriFieldTypeDouble", "alias": "Hickory Shad", "domain": null }, { "name": "IS_", "type": "esriFieldTypeDouble", "alias": "Inland Silverside", "domain": null }, { "name": "KC", "type": "esriFieldTypeDouble", "alias": "Koi", "domain": null }, { "name": "KO", "type": "esriFieldTypeDouble", "alias": "Kokanee Salmon", "domain": null }, { "name": "ME", "type": "esriFieldTypeDouble", "alias": "Menhaden", "domain": null }, { "name": "ML", "type": "esriFieldTypeDouble", "alias": "Striped Mullet", "domain": null }, { "name": "MS", "type": "esriFieldTypeDouble", "alias": "Mimic Shiner", "domain": null }, { "name": "RA", "type": "esriFieldTypeDouble", "alias": "Rainbow Smelt", "domain": null }, { "name": "SG", "type": "esriFieldTypeDouble", "alias": "Fat Sleeper Goby", "domain": null }, { "name": "TE", "type": "esriFieldTypeDouble", "alias": "Tench", "domain": null }, { "name": "WH", "type": "esriFieldTypeDouble", "alias": "White Crappie", "domain": null }, { "name": "SB", "type": "esriFieldTypeDouble", "alias": "Striped Bass", "domain": null }, { "name": "GA", "type": "esriFieldTypeDouble", "alias": "Mosquito Fish", "domain": null }, { "name": "TM", "type": "esriFieldTypeDouble", "alias": "Tiger Musky", "domain": null }, { "name": "WM", "type": "esriFieldTypeDouble", "alias": "Warmouth", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_47_StationID", "fields": "StationID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SiteDetail_Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "StationID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }