{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "Waterbodies Detections", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "lake_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "lake_name", "type": "esriFieldTypeString", "alias": "Lake name", "length": 255, "domain": { "type": "codedValue", "name": "DAGW_Hab_Waterbodies", "description": "name", "codedValues": [ { "name": "Alum Creek Lake", "code": "Alum Creek Lake" }, { "name": "Apple Valley Lake", "code": "Apple Valley Lake" }, { "name": "Atwood Lake", "code": "Atwood Lake" }, { "name": "Aurora Pond", "code": "Aurora Pond" }, { "name": "Berlin Lake", "code": "Berlin Lake" }, { "name": "Bresler Upground Reservoir", "code": "Bresler Upground Reservoir" }, { "name": "Buckeye Lake", "code": "Buckeye Lake" }, { "name": "Burr Oak Reservoir", "code": "Burr Oak Reservoir" }, { "name": "Caesar Creek Lake", "code": "Caesar Creek Lake" }, { "name": "Charles Mill Lake", "code": "Charles Mill Lake" }, { "name": "Chippewa Lake", "code": "Chippewa Lake" }, { "name": "Clarence J Brown Reservoir", "code": "Clarence J Brown Reservoir" }, { "name": "Clear Fork Reservoir", "code": "Clear Fork Reservoir" }, { "name": "Clendening Lake", "code": "Clendening Lake" }, { "name": "Cowan Lake", "code": "Cowan Lake" }, { "name": "Deer Creek Lake", "code": "Deer Creek Lake" }, { "name": "Defiance Reservoir", "code": "Defiance Reservoir" }, { "name": "Delaware Lake", "code": "Delaware Lake" }, { "name": "Dillon Lake", "code": "Dillon Lake" }, { "name": "Doutt Reservoir", "code": "Doutt Reservoir" }, { "name": "East Branch Reservoir", "code": "East Branch Reservoir" }, { "name": "Erie County Wetlands", "code": "Erie County Wetlands" }, { "name": "Evans Lake", "code": "Evans Lake" }, { "name": "Ferguson Reservoir", "code": "Ferguson Reservoir" }, { "name": "Findlay Upground Reservoir 1", "code": "Findlay Upground Reservoir 1" }, { "name": "Findlay Upground Reservoir 2", "code": "Findlay Upground Reservoir 2" }, { "name": "Grand Lake - St. Marys", "code": "Grand Lake - St. Marys" }, { "name": "Guilford Lake", "code": "Guilford Lake" }, { "name": "Hoover Reservoir", "code": "Hoover Reservoir" }, { "name": "Indian Lake", "code": "Indian Lake" }, { "name": "Killbuck State Wildlife Area", "code": "Killbuck State Wildlife Area" }, { "name": "Killdeer Wildlife Pond #9", "code": "Killdeer Wildlife Pond #9" }, { "name": "Kiser Lake", "code": "Kiser Lake" }, { "name": "Knox Lake", "code": "Knox Lake" }, { "name": "La Due Reservoir", "code": "La Due Reservoir" }, { "name": "Lake Logan", "code": "Lake Logan" }, { "name": "Lake Loramie", "code": "Lake Loramie" }, { "name": "Lake Milton", "code": "Lake Milton" }, { "name": "Lake Mohawk", "code": "Lake Mohawk" }, { "name": "Lake Roaming Rock", "code": "Lake Roaming Rock" }, { "name": "Lake Rockwell", "code": "Lake Rockwell" }, { "name": "Lake Rupert", "code": "Lake Rupert" }, { "name": "Lake Seneca", "code": "Lake Seneca" }, { "name": "Lake White", "code": "Lake White" }, { "name": "Leesville Lake", "code": "Leesville Lake" }, { "name": "Meander Creek Reservoir", "code": "Meander Creek Reservoir" }, { "name": "Metzger Reservoir", "code": "Metzger Reservoir" }, { "name": "Michael J Kirwan Reservoir (West Branch Reservoir)", "code": "Michael J Kirwan Reservoir (West Branch Reservoir)" }, { "name": "Mogadore Reservoir", "code": "Mogadore Reservoir" }, { "name": "Mosquito Creek Lake", "code": "Mosquito Creek Lake" }, { "name": "Mud Lake", "code": "Mud Lake" }, { "name": "Nimisila Reservoir", "code": "Nimisila Reservoir" }, { "name": "O'Shaughnessy Reservoir", "code": "O'Shaughnessy Reservoir" }, { "name": "Paint Creek Lake", "code": "Paint Creek Lake" }, { "name": "Piedmont Lake", "code": "Piedmont Lake" }, { "name": "Pine Lake", "code": "Pine Lake" }, { "name": "Pleasant Hill Lake", "code": "Pleasant Hill Lake" }, { "name": "Pymatuning Reservoir", "code": "Pymatuning Reservoir" }, { "name": "Rocky Fork Lake", "code": "Rocky Fork Lake" }, { "name": "Rush Creek Structure 6A", "code": "Rush Creek Structure 6A" }, { "name": "Salt Fork Lake", "code": "Salt Fork Lake" }, { "name": "Senecaville Lake", "code": "Senecaville Lake" }, { "name": "Sixmile Creek", "code": "Sixmile Creek" }, { "name": "Springfield Lake", "code": "Springfield Lake" }, { "name": "Tappan Lake", "code": "Tappan Lake" }, { "name": "Turkeyfoot Lake", "code": "Turkeyfoot Lake" }, { "name": "Walborn Reservoir", "code": "Walborn Reservoir" }, { "name": "William H. Harsha Lake", "code": "William H. Harsha Lake" }, { "name": "Williams Reservoir", "code": "Williams Reservoir" }, { "name": "Wingfoot Lake", "code": "Wingfoot Lake" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "satellite_detection", "type": "esriFieldTypeString", "alias": "Satellite Detection", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Ukn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "satellite_detect_yr", "type": "esriFieldTypeInteger", "alias": "Satellite Detection Year", "domain": null }, { "name": "initial_satellite_detection_date", "type": "esriFieldTypeDate", "alias": "Initial Satellite Detection Date", "length": 8, "domain": null }, { "name": "current_satellite_date", "type": "esriFieldTypeDate", "alias": "Current Satellite Date", "length": 8, "domain": null }, { "name": "current_cyanobacteria_area_coverage", "type": "esriFieldTypeString", "alias": "Current Cyanobacteria Area Coverage", "length": 25, "domain": { "type": "codedValue", "name": "DAGW_Hab_Waterbodies_Coverage", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Trace", "code": "Trace" }, { "name": "10-50%", "code": "10-50%" }, { "name": ">50%", "code": ">50%" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "current_status", "type": "esriFieldTypeSmallInteger", "alias": "Current Status", "domain": { "type": "codedValue", "name": "DAGW_Hab_Waterbodies_Status", "description": "", "codedValues": [ { "name": "Absent", "code": 0 }, { "name": "Unknown", "code": 99 }, { "name": "Low (Trace)", "code": 1 }, { "name": "Medium (10-50%)", "code": 2 }, { "name": "High (>50%)", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "m_url", "type": "esriFieldTypeString", "alias": "URL", "length": 500, "domain": null } ], "indexes": [ { "name": "gdb_304_lake_nam", "fields": "lake_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r196_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "epaprodgis.gis.dagw_hab_lks_mon", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "lake_name", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6E00C40A-7473-4DA3-9A77-65D0B0E6EA5B}" }, { "id": 4, "name": "epaprodgis.gis.dagw_hab_lks_mon_pts", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "lake_name", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6E077C12-1FA0-4BE0-A61E-093D89519818}" } ], "capabilities": "Query,Map,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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "36d69f0d8f864cb1a710311560d9b0aa" }