{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Stations", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26912, "latestWkid": 26912, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e86f15ac10b5c65712fc990ada290062", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABkElEQVRIiWNhoCFgGZ6GmyryNWvJcDhjk/v5i4HpwpNP0288/bGQZMMN5bg7moLlMjx0BflxqenZ/kRu9oHn/2+9+LGIaMMN5Lm72kMV0t11BflwGczAwMBQ4ikj+fff//Z5h14wYLMAw3BDee7ejlDFFDcCBsNAubes1L//DG3zDr74f+fVj8U4DTeQ457QEaaY5KYjyEuMwTBQ6SMr/e/f//b5h18y3n2F8AGK4daqfIGkGgwD1X5y0ucffknHaTg7GxM55sIBJxvzX2T+MM1Eo4YzMDAwMBy8/vHGnVc/pFXEOJhJNWj7pfcfLz36ehKn4WcffPGJnHpj0/IsDVcVceIt2HHp3afSFQ8WXH36tRSn4QwMDL/PPPjsFznjxoblGRruxFiw88r7zyUr7y+6+vRbAboctjD/febeZ//oGTfWL83Q8MRnwa4r7z8XL7+36OqTb7nY5HFF6J9T9z4HRM+4scZGnc8Im4Kfv/4xHLzxcdvVp99ycFmOL7X8PXXvc+Cpe5/xKMEPhm46BwBdBJ3/NdwLLwAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.2706028766621077E7, "ymin": 4454383.379857959, "xmax": -1.2000784077003144E7, "ymax": 5160559.155092346, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Station Name", "length": 50, "domain": null }, { "name": "STATION_ID", "type": "esriFieldTypeGUID", "alias": "Station ID", "length": 38, "domain": null }, { "name": "STREAM_TYPE", "type": "esriFieldTypeString", "alias": "Stream Type", "length": 50, "domain": { "type": "codedValue", "name": "stream_types", "description": "Stream Types", "codedValues": [ { "name": "Coldwater river", "code": "Coldwater river" }, { "name": "Large coldwater lentic", "code": "Large coldwater lentic" }, { "name": "Large two-story lentic", "code": "Large two-story lentic" }, { "name": "Large warmwater lentic", "code": "Large warmwater lentic" }, { "name": "Small coldwater lentic", "code": "Small coldwater lentic" }, { "name": "Small two-story lentic", "code": "Small two-story lentic" }, { "name": "Wadeable coldwater stream", "code": "Wadeable coldwater stream" }, { "name": "Wadeable warmwater stream", "code": "Wadeable warmwater stream" }, { "name": "Warmwater river", "code": "Warmwater river" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATER_ID", "type": "esriFieldTypeString", "alias": "Water-body ID", "length": 40, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R24_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G54WATER_ID", "fields": "WATER_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G54STATION_ID", "fields": "STATION_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S4_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "SamplingEvents", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "STATION_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "SamplingEvents", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 26912, "latestWkid": 26912, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 79, 167, 255, 255 ], "width": 4 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.2694894446640665E7, "ymin": 4459283.395313467, "xmax": -1.2162385541453276E7, "ymax": 5151163.447228919, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "GEO_DEF", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "GEO_DEF", "type": "esriFieldTypeString", "alias": "Geomtry Definition String", "length": 1000, "domain": null }, { "name": "LOCATION_NOTES", "type": "esriFieldTypeString", "alias": "Location Notes", "length": 1000, "domain": null }, { "name": "EVENT_DATE", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "STATION_ID", "type": "esriFieldTypeGUID", "alias": "Station ID", "length": 38, "domain": null }, { "name": "SEGMENT_LENGTH", "type": "esriFieldTypeInteger", "alias": "Stream Length", "domain": null }, { "name": "NUM_PASSES", "type": "esriFieldTypeSmallInteger", "alias": "Number of Passes", "domain": null }, { "name": "WEATHER", "type": "esriFieldTypeString", "alias": "Weather Condition", "length": 255, "domain": { "type": "codedValue", "name": "weather_condition", "description": "Weather Conditions", "codedValues": [ { "name": "sunny", "code": "sunny" }, { "name": "partly cloudy", "code": "partly cloudy" }, { "name": "partly sunny", "code": "partly sunny" }, { "name": "overcast", "code": "overcast" }, { "name": "rain", "code": "rain" }, { "name": "sleet", "code": "sleet" }, { "name": "snow", "code": "snow" }, { "name": "clear", "code": "clear" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBSERVERS", "type": "esriFieldTypeString", "alias": "Observers", "length": 255, "domain": null }, { "name": "SURVEY_PURPOSE", "type": "esriFieldTypeString", "alias": "Survey Purpose", "length": 255, "domain": { "type": "codedValue", "name": "survey_purpose", "description": "the purpose of the survey", "codedValues": [ { "name": "Depletion estimate", "code": "Depletion estimate" }, { "name": "Mark-Recapture", "code": "Mark-Recapture" }, { "name": "Disease certification", "code": "Disease certification" }, { "name": "Presence/absence", "code": "Presence/absence" }, { "name": "Fish community", "code": "Fish community" }, { "name": "Fish propagation", "code": "Fish propagation" }, { "name": "Catch and Effort", "code": "Catch and Effort" }, { "name": "Non-native fish removal", "code": "Non-native fish removal" }, { "name": "Genetics", "code": "Genetics" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SUBMITTER", "type": "esriFieldTypeString", "alias": "Submitter Email", "length": 255, "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R25_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G55EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G55STATION_ID", "fields": "STATION_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S5_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Fish", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 2, "name": "Equipment", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 3, "name": "Habitat", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true }, { "id": 4, "name": "Transect", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 0, "name": "Stations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STATION_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Fish", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CATCH_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FISH_ID", "type": "esriFieldTypeGUID", "alias": "Fish ID", "length": 38, "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "CATCH_ID", "type": "esriFieldTypeSmallInteger", "alias": "Catch ID", "domain": null }, { "name": "PASS_NUM", "type": "esriFieldTypeSmallInteger", "alias": "Pass Number", "domain": null }, { "name": "SPECIES_CODE", "type": "esriFieldTypeString", "alias": "Fish Species Code", "length": 4, "domain": { "type": "codedValue", "name": "species_codes", "description": "Fish Species Codes", "codedValues": [ { "name": "ALTR", "code": "ALTR" }, { "name": "ANY", "code": "ANY" }, { "name": "BG", "code": "BG" }, { "name": "BH", "code": "BH" }, { "name": "BHBK", "code": "BHBK" }, { "name": "BHCH", "code": "BHCH" }, { "name": "BHYL", "code": "BHYL" }, { "name": "BK", "code": "BK" }, { "name": "BKMX", "code": "BKMX" }, { "name": "BKOW", "code": "BKOW" }, { "name": "BN", "code": "BN" }, { "name": "BNMX", "code": "BNMX" }, { "name": "BNSC", "code": "BNSC" }, { "name": "BRJS", "code": "BRJS" }, { "name": "BRSJ", "code": "BRSJ" }, { "name": "BS", "code": "BS" }, { "name": "BSLM", "code": "BSLM" }, { "name": "BSSM", "code": "BSSM" }, { "name": "BSST", "code": "BSST" }, { "name": "BSWH", "code": "BSWH" }, { "name": "CB", "code": "CB" }, { "name": "CBBT", "code": "CBBT" }, { "name": "CBCK", "code": "CBCK" }, { "name": "CBHB", "code": "CBHB" }, { "name": "CBLS", "code": "CBLS" }, { "name": "CBLSNO", "code": "CBLSNO" }, { "name": "CBLSSO", "code": "CBLSSO" }, { "name": "CBLT", "code": "CBLT" }, { "name": "CBNL", "code": "CBNL" }, { "name": "CBRT", "code": "CBRT" }, { "name": "CBSL", "code": "CBSL" }, { "name": "CBUT", "code": "CBUT" }, { "name": "CBVR", "code": "CBVR" }, { "name": "CPCO", "code": "CPCO" }, { "name": "CPGS", "code": "CPGS" }, { "name": "CRBL", "code": "CRBL" }, { "name": "CRWH", "code": "CRWH" }, { "name": "CSVB", "code": "CSVB" }, { "name": "CT", "code": "CT" }, { "name": "CTBL", "code": "CTBL" }, { "name": "CTBV", "code": "CTBV" }, { "name": "CTCR", "code": "CTCR" }, { "name": "CTLH", "code": "CTLH" }, { "name": "CTSB", "code": "CTSB" }, { "name": "CTSN", "code": "CTSN" }, { "name": "CTYL", "code": "CTYL" }, { "name": "CY", "code": "CY" }, { "name": "DC", "code": "DC" }, { "name": "DCLN", "code": "DCLN" }, { "name": "DCSP", "code": "DCSP" }, { "name": "DI", "code": "DI" }, { "name": "DJ", "code": "DJ" }, { "name": "GF", "code": "GF" }, { "name": "GP", "code": "GP" }, { "name": "GRAC", "code": "GRAC" }, { "name": "GT", "code": "GT" }, { "name": "KIPL", "code": "KIPL" }, { "name": "KIRN", "code": "KIRN" }, { "name": "KS", "code": "KS" }, { "name": "KSFG", "code": "KSFG" }, { "name": "KSGL", "code": "KSGL" }, { "name": "KSMX", "code": "KSMX" }, { "name": "KSPP", "code": "KSPP" }, { "name": "KSRJ", "code": "KSRJ" }, { "name": "KSSC", "code": "KSSC" }, { "name": "LK", "code": "LK" }, { "name": "LKBL", "code": "LKBL" }, { "name": "LKJL", "code": "LKJL" }, { "name": "MKTG", "code": "MKTG" }, { "name": "MN", "code": "MN" }, { "name": "MNBR", "code": "MNBR" }, { "name": "MNFH", "code": "MNFH" }, { "name": "MNPL", "code": "MNPL" }, { "name": "MS", "code": "MS" }, { "name": "MSWS", "code": "MSWS" }, { "name": "NP", "code": "NP" }, { "name": "PCSM", "code": "PCSM" }, { "name": "PCYL", "code": "PCYL" }, { "name": "RT", "code": "RT" }, { "name": "RTAB", "code": "RTAB" }, { "name": "RTAL", "code": "RTAL" }, { "name": "RTCC", "code": "RTCC" }, { "name": "RTEL", "code": "RTEL" }, { "name": "RTER", "code": "RTER" }, { "name": "RTFD", "code": "RTFD" }, { "name": "RTGK", "code": "RTGK" }, { "name": "RTHY", "code": "RTHY" }, { "name": "RTMC", "code": "RTMC" }, { "name": "RTMX", "code": "RTMX" }, { "name": "RTRB", "code": "RTRB" }, { "name": "RTSC", "code": "RTSC" }, { "name": "RTSH", "code": "RTSH" }, { "name": "RTSK", "code": "RTSK" }, { "name": "RTSS", "code": "RTSS" }, { "name": "RTTS", "code": "RTTS" }, { "name": "SC", "code": "SC" }, { "name": "SCBL", "code": "SCBL" }, { "name": "SCMT", "code": "SCMT" }, { "name": "SCPU", "code": "SCPU" }, { "name": "SCUL", "code": "SCUL" }, { "name": "SDVR", "code": "SDVR" }, { "name": "SFBL", "code": "SFBL" }, { "name": "SFGR", "code": "SFGR" }, { "name": "SHGZ", "code": "SHGZ" }, { "name": "SHTF", "code": "SHTF" }, { "name": "SK", "code": "SK" }, { "name": "SKBL", "code": "SKBL" }, { "name": "SKDS", "code": "SKDS" }, { "name": "SKFM", "code": "SKFM" }, { "name": "SKGR", "code": "SKGR" }, { "name": "SKJN", "code": "SKJN" }, { "name": "SKLN", "code": "SKLN" }, { "name": "SKMT", "code": "SKMT" }, { "name": "SKRZ", "code": "SKRZ" }, { "name": "SKUT", "code": "SKUT" }, { "name": "SKWH", "code": "SKWH" }, { "name": "SMDT", "code": "SMDT" }, { "name": "SMRB", "code": "SMRB" }, { "name": "SN", "code": "SN" }, { "name": "SP", "code": "SP" }, { "name": "SPJO", "code": "SPJO" }, { "name": "SQCR", "code": "SQCR" }, { "name": "SRGD", "code": "SRGD" }, { "name": "SRRD", "code": "SRRD" }, { "name": "SRRS", "code": "SRRS" }, { "name": "SRSD", "code": "SRSD" }, { "name": "SRST", "code": "SRST" }, { "name": "TG", "code": "TG" }, { "name": "TMPL", "code": "TMPL" }, { "name": "TRTG", "code": "TRTG" }, { "name": "UK", "code": "UK" }, { "name": "WD", "code": "WD" }, { "name": "WE", "code": "WE" }, { "name": "WF", "code": "WF" }, { "name": "WFBL", "code": "WFBL" }, { "name": "WFBV", "code": "WFBV" }, { "name": "WFMT", "code": "WFMT" }, { "name": "WP", "code": "WP" }, { "name": "WPSW", "code": "WPSW" }, { "name": "WPWS", "code": "WPWS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LENGTH", "type": "esriFieldTypeSmallInteger", "alias": "Length", "domain": null }, { "name": "LENGTH_TYPE", "type": "esriFieldTypeString", "alias": "Length Type", "length": 3, "domain": { "type": "codedValue", "name": "length_types", "description": "Fish Length Types", "codedValues": [ { "name": "FRK", "code": "FRK" }, { "name": "STD", "code": "STD" }, { "name": "TOT", "code": "TOT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WEIGHT", "type": "esriFieldTypeSmallInteger", "alias": "Weight", "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "length": 250, "domain": null } ], "indexes": [ { "name": "R20_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G50FISH_ID", "fields": "FISH_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G50EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Health", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true }, { "id": 6, "name": "Tags", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 7, "name": "Diet", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "SamplingEvent", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "Diet", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FISH_SPECIES", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FISH_ID", "type": "esriFieldTypeGUID", "alias": "Fish ID", "length": 38, "domain": null }, { "name": "FISH_SPECIES", "type": "esriFieldTypeString", "alias": "Fish Species", "length": 50, "domain": { "type": "codedValue", "name": "species_codes", "description": "Fish Species Codes", "codedValues": [ { "name": "ALTR", "code": "ALTR" }, { "name": "ANY", "code": "ANY" }, { "name": "BG", "code": "BG" }, { "name": "BH", "code": "BH" }, { "name": "BHBK", "code": "BHBK" }, { "name": "BHCH", "code": "BHCH" }, { "name": "BHYL", "code": "BHYL" }, { "name": "BK", "code": "BK" }, { "name": "BKMX", "code": "BKMX" }, { "name": "BKOW", "code": "BKOW" }, { "name": "BN", "code": "BN" }, { "name": "BNMX", "code": "BNMX" }, { "name": "BNSC", "code": "BNSC" }, { "name": "BRJS", "code": "BRJS" }, { "name": "BRSJ", "code": "BRSJ" }, { "name": "BS", "code": "BS" }, { "name": "BSLM", "code": "BSLM" }, { "name": "BSSM", "code": "BSSM" }, { "name": "BSST", "code": "BSST" }, { "name": "BSWH", "code": "BSWH" }, { "name": "CB", "code": "CB" }, { "name": "CBBT", "code": "CBBT" }, { "name": "CBCK", "code": "CBCK" }, { "name": "CBHB", "code": "CBHB" }, { "name": "CBLS", "code": "CBLS" }, { "name": "CBLSNO", "code": "CBLSNO" }, { "name": "CBLSSO", "code": "CBLSSO" }, { "name": "CBLT", "code": "CBLT" }, { "name": "CBNL", "code": "CBNL" }, { "name": "CBRT", "code": "CBRT" }, { "name": "CBSL", "code": "CBSL" }, { "name": "CBUT", "code": "CBUT" }, { "name": "CBVR", "code": "CBVR" }, { "name": "CPCO", "code": "CPCO" }, { "name": "CPGS", "code": "CPGS" }, { "name": "CRBL", "code": "CRBL" }, { "name": "CRWH", "code": "CRWH" }, { "name": "CSVB", "code": "CSVB" }, { "name": "CT", "code": "CT" }, { "name": "CTBL", "code": "CTBL" }, { "name": "CTBV", "code": "CTBV" }, { "name": "CTCR", "code": "CTCR" }, { "name": "CTLH", "code": "CTLH" }, { "name": "CTSB", "code": "CTSB" }, { "name": "CTSN", "code": "CTSN" }, { "name": "CTYL", "code": "CTYL" }, { "name": "CY", "code": "CY" }, { "name": "DC", "code": "DC" }, { "name": "DCLN", "code": "DCLN" }, { "name": "DCSP", "code": "DCSP" }, { "name": "DI", "code": "DI" }, { "name": "DJ", "code": "DJ" }, { "name": "GF", "code": "GF" }, { "name": "GP", "code": "GP" }, { "name": "GRAC", "code": "GRAC" }, { "name": "GT", "code": "GT" }, { "name": "KIPL", "code": "KIPL" }, { "name": "KIRN", "code": "KIRN" }, { "name": "KS", "code": "KS" }, { "name": "KSFG", "code": "KSFG" }, { "name": "KSGL", "code": "KSGL" }, { "name": "KSMX", "code": "KSMX" }, { "name": "KSPP", "code": "KSPP" }, { "name": "KSRJ", "code": "KSRJ" }, { "name": "KSSC", "code": "KSSC" }, { "name": "LK", "code": "LK" }, { "name": "LKBL", "code": "LKBL" }, { "name": "LKJL", "code": "LKJL" }, { "name": "MKTG", "code": "MKTG" }, { "name": "MN", "code": "MN" }, { "name": "MNBR", "code": "MNBR" }, { "name": "MNFH", "code": "MNFH" }, { "name": "MNPL", "code": "MNPL" }, { "name": "MS", "code": "MS" }, { "name": "MSWS", "code": "MSWS" }, { "name": "NP", "code": "NP" }, { "name": "PCSM", "code": "PCSM" }, { "name": "PCYL", "code": "PCYL" }, { "name": "RT", "code": "RT" }, { "name": "RTAB", "code": "RTAB" }, { "name": "RTAL", "code": "RTAL" }, { "name": "RTCC", "code": "RTCC" }, { "name": "RTEL", "code": "RTEL" }, { "name": "RTER", "code": "RTER" }, { "name": "RTFD", "code": "RTFD" }, { "name": "RTGK", "code": "RTGK" }, { "name": "RTHY", "code": "RTHY" }, { "name": "RTMC", "code": "RTMC" }, { "name": "RTMX", "code": "RTMX" }, { "name": "RTRB", "code": "RTRB" }, { "name": "RTSC", "code": "RTSC" }, { "name": "RTSH", "code": "RTSH" }, { "name": "RTSK", "code": "RTSK" }, { "name": "RTSS", "code": "RTSS" }, { "name": "RTTS", "code": "RTTS" }, { "name": "SC", "code": "SC" }, { "name": "SCBL", "code": "SCBL" }, { "name": "SCMT", "code": "SCMT" }, { "name": "SCPU", "code": "SCPU" }, { "name": "SCUL", "code": "SCUL" }, { "name": "SDVR", "code": "SDVR" }, { "name": "SFBL", "code": "SFBL" }, { "name": "SFGR", "code": "SFGR" }, { "name": "SHGZ", "code": "SHGZ" }, { "name": "SHTF", "code": "SHTF" }, { "name": "SK", "code": "SK" }, { "name": "SKBL", "code": "SKBL" }, { "name": "SKDS", "code": "SKDS" }, { "name": "SKFM", "code": "SKFM" }, { "name": "SKGR", "code": "SKGR" }, { "name": "SKJN", "code": "SKJN" }, { "name": "SKLN", "code": "SKLN" }, { "name": "SKMT", "code": "SKMT" }, { "name": "SKRZ", "code": "SKRZ" }, { "name": "SKUT", "code": "SKUT" }, { "name": "SKWH", "code": "SKWH" }, { "name": "SMDT", "code": "SMDT" }, { "name": "SMRB", "code": "SMRB" }, { "name": "SN", "code": "SN" }, { "name": "SP", "code": "SP" }, { "name": "SPJO", "code": "SPJO" }, { "name": "SQCR", "code": "SQCR" }, { "name": "SRGD", "code": "SRGD" }, { "name": "SRRD", "code": "SRRD" }, { "name": "SRRS", "code": "SRRS" }, { "name": "SRSD", "code": "SRSD" }, { "name": "SRST", "code": "SRST" }, { "name": "TG", "code": "TG" }, { "name": "TMPL", "code": "TMPL" }, { "name": "TRTG", "code": "TRTG" }, { "name": "UK", "code": "UK" }, { "name": "WD", "code": "WD" }, { "name": "WE", "code": "WE" }, { "name": "WF", "code": "WF" }, { "name": "WFBL", "code": "WFBL" }, { "name": "WFBV", "code": "WFBV" }, { "name": "WFMT", "code": "WFMT" }, { "name": "WP", "code": "WP" }, { "name": "WPSW", "code": "WPSW" }, { "name": "WPWS", "code": "WPWS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLASS", "type": "esriFieldTypeString", "alias": "Class", "length": 50, "domain": { "type": "codedValue", "name": "diet_classes", "description": "Diet Classes", "codedValues": [ { "name": "Aquatic invertebrates", "code": "Aquatic invertebrates" }, { "name": "Crayfish", "code": "Crayfish" }, { "name": "Fish", "code": "Fish" }, { "name": "Terrestrial invertebrates", "code": "Terrestrial invertebrates" }, { "name": "Zooplankton", "code": "Zooplankton" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MEASUREMENT_TYPE", "type": "esriFieldTypeString", "alias": "Measurement Type", "length": 50, "domain": { "type": "codedValue", "name": "diet_measurement_type", "description": "Diet Measurement Type", "codedValues": [ { "name": "Count", "code": "Count" }, { "name": "Presence", "code": "Presence" }, { "name": "Volume (ml)", "code": "Volume (ml)" }, { "name": "Weight (g)", "code": "Weight (g)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MEASUREMENT", "type": "esriFieldTypeDouble", "alias": "MEASUREMENT", "domain": null } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G49FISH_ID", "fields": "FISH_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Fish", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Health", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EYE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FISH_ID", "type": "esriFieldTypeGUID", "alias": "Fish ID", "length": 38, "domain": null }, { "name": "EYE", "type": "esriFieldTypeString", "alias": "Eye Condition", "length": 50, "domain": { "type": "codedValue", "name": "eye_conditions", "description": "Eye Conditions", "codedValues": [ { "name": "Blind (1)", "code": "Blind (1)" }, { "name": "Blind (2)", "code": "Blind (2)" }, { "name": "Exopthalmia (1)", "code": "Exopthalmia (1)" }, { "name": "Exopthalmia (2)", "code": "Exopthalmia (2)" }, { "name": "Hermorrhagic (1)", "code": "Hermorrhagic (1)" }, { "name": "Hermorrhagic (2)", "code": "Hermorrhagic (2)" }, { "name": "Missing (1)", "code": "Missing (1)" }, { "name": "Missing (2)", "code": "Missing (2)" }, { "name": "Normal", "code": "Normal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GILL", "type": "esriFieldTypeString", "alias": "Gill Condition", "length": 50, "domain": { "type": "codedValue", "name": "gill_conditions", "description": "Gill Conditions", "codedValues": [ { "name": "Clubbed", "code": "Clubbed" }, { "name": "Frayed", "code": "Frayed" }, { "name": "Marginate", "code": "Marginate" }, { "name": "Normal", "code": "Normal" }, { "name": "Pale", "code": "Pale" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PSBR", "type": "esriFieldTypeString", "alias": "Pseudobranches Condition", "length": 50, "domain": { "type": "codedValue", "name": "pseudobranch_conditions", "description": "Pseudobranch Conditions", "codedValues": [ { "name": "Inflamed", "code": "Inflamed" }, { "name": "Lithic", "code": "Lithic" }, { "name": "Normal", "code": "Normal" }, { "name": "Swollen", "code": "Swollen" }, { "name": "Swollen & Lithic", "code": "Swollen & Lithic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "THYMUS", "type": "esriFieldTypeString", "alias": "Thymus Condition", "length": 50, "domain": { "type": "codedValue", "name": "thymus_conditions", "description": "Thymus Conditions", "codedValues": [ { "name": "Mild hemorrhage", "code": "Mild hemorrhage" }, { "name": "No hemorrhage", "code": "No hemorrhage" }, { "name": "Sever hemorrhage", "code": "Sever hemorrhage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FAT", "type": "esriFieldTypeString", "alias": "Fat Index", "length": 50, "domain": { "type": "codedValue", "name": "fat_indexes", "description": "Fat Indexes", "codedValues": [ { "name": "< 50%", "code": "< 50%" }, { "name": "> 50%", "code": "> 50%" }, { "name": "100%", "code": "100%" }, { "name": "50%", "code": "50%" }, { "name": "No fat deposited", "code": "No fat deposited" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SPLEEN", "type": "esriFieldTypeString", "alias": "Spleen Condition", "length": 50, "domain": { "type": "codedValue", "name": "speen_conditions", "description": "Spleen Conditions", "codedValues": [ { "name": "Black", "code": "Black" }, { "name": "Enlarged", "code": "Enlarged" }, { "name": "Granular", "code": "Granular" }, { "name": "Nodular", "code": "Nodular" }, { "name": "Red", "code": "Red" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HIND", "type": "esriFieldTypeString", "alias": "Hind Gut Condition", "length": 50, "domain": { "type": "codedValue", "name": "hind_gut_conditions", "description": "Hind Gut Conditions", "codedValues": [ { "name": "No inflammation", "code": "No inflammation" }, { "name": "Severe inflammation", "code": "Severe inflammation" }, { "name": "Slight inflammation", "code": "Slight inflammation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KIDNEY", "type": "esriFieldTypeString", "alias": "Kidney Condition", "length": 50, "domain": { "type": "codedValue", "name": "kidney_conditions", "description": "Kidney Conditions", "codedValues": [ { "name": "Granular", "code": "Granular" }, { "name": "Modeled", "code": "Modeled" }, { "name": "Normal", "code": "Normal" }, { "name": "Swollen", "code": "Swollen" }, { "name": "Urolithiasis", "code": "Urolithiasis" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LIVER", "type": "esriFieldTypeString", "alias": "Liver Condition", "length": 50, "domain": { "type": "codedValue", "name": "liver_conditions", "description": "Liver Conditions", "codedValues": [ { "name": "Fatty", "code": "Fatty" }, { "name": "Focal discoloration", "code": "Focal discoloration" }, { "name": "General discoloration", "code": "General discoloration" }, { "name": "Less vivid", "code": "Less vivid" }, { "name": "Nodules", "code": "Nodules" }, { "name": "Normal", "code": "Normal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BILE", "type": "esriFieldTypeString", "alias": "Bile Color", "length": 50, "domain": { "type": "codedValue", "name": "bile_colors", "description": "Bile Colors", "codedValues": [ { "name": "Dark green", "code": "Dark green" }, { "name": "Light green", "code": "Light green" }, { "name": "Yellow, full", "code": "Yellow, full" }, { "name": "Yellow, partial full", "code": "Yellow, partial full" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GENDER", "type": "esriFieldTypeString", "alias": "Gender", "length": 50, "domain": { "type": "codedValue", "name": "genders", "description": "Genders", "codedValues": [ { "name": "Female", "code": "Female" }, { "name": "Male", "code": "Male" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPRODUCTIVE", "type": "esriFieldTypeString", "alias": "Reproductive Condition", "length": 50, "domain": { "type": "codedValue", "name": "reproductive_conditions", "description": "Reproductive Conditions", "codedValues": [ { "name": "Green", "code": "Green" }, { "name": "Ripe", "code": "Ripe" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HEMATOCRIT", "type": "esriFieldTypeSmallInteger", "alias": "Hematocrit Count (%)", "domain": { "type": "range", "name": "0-100", "description": "0-100 Short Integer", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LEUKOCRIT", "type": "esriFieldTypeSmallInteger", "alias": "Leukocrit Count (%)", "domain": { "type": "range", "name": "0-100", "description": "0-100 Short Integer", "range": [ 0, 100 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FIN", "type": "esriFieldTypeString", "alias": "Fin Condition", "length": 50, "domain": { "type": "codedValue", "name": "fin_conditions", "description": "Fin Conditions", "codedValues": [ { "name": "Mild active erosion", "code": "Mild active erosion" }, { "name": "No active erosion", "code": "No active erosion" }, { "name": "Severe active erosion", "code": "Severe active erosion" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERCLE", "type": "esriFieldTypeString", "alias": "Opercle Condition", "length": 50, "domain": { "type": "codedValue", "name": "opercle_conditions", "description": "Opercle Conditions", "codedValues": [ { "name": "Normal", "code": "Normal" }, { "name": "Severe shortening", "code": "Severe shortening" }, { "name": "Slight shortening", "code": "Slight shortening" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COLLECTION_PART", "type": "esriFieldTypeString", "alias": "Hard body part collection", "length": 255, "domain": { "type": "codedValue", "name": "hard_body_part", "description": "the part of the body used", "codedValues": [ { "name": "Cleithrum", "code": "Cleithrum" }, { "name": "Other", "code": "Other" }, { "name": "Otolith", "code": "Otolith" }, { "name": "Ray", "code": "Ray" }, { "name": "Scale", "code": "Scale" }, { "name": "Spine", "code": "Spine" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PLPRO", "type": "esriFieldTypeSingle", "alias": "Plasma Protein", "domain": null } ], "indexes": [ { "name": "R16_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G46FISH_ID", "fields": "FISH_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Fish", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "Tags", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NUMBER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FISH_ID", "type": "esriFieldTypeGUID", "alias": "Fish ID", "length": 38, "domain": null }, { "name": "NUMBER", "type": "esriFieldTypeString", "alias": "Tag Number", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "tag_types", "description": "Tag Types", "codedValues": [ { "name": "Anchor", "code": "Anchor" }, { "name": "Coded wire", "code": "Coded wire" }, { "name": "Fin clip", "code": "Fin clip" }, { "name": "Fin punch", "code": "Fin punch" }, { "name": "Grid mark", "code": "Grid mark" }, { "name": "OTC", "code": "OTC" }, { "name": "PIT", "code": "PIT" }, { "name": "Radio", "code": "Radio" }, { "name": "Spray dye", "code": "Spray dye" }, { "name": "VI alpha", "code": "VI alpha" }, { "name": "VIE", "code": "VIE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": { "type": "codedValue", "name": "tag_locations", "description": "Tag Locations", "codedValues": [ { "name": "Adipose", "code": "Adipose" }, { "name": "Anal", "code": "Anal" }, { "name": "Dorsal", "code": "Dorsal" }, { "name": "Head", "code": "Head" }, { "name": "Lateral", "code": "Lateral" }, { "name": "Left pectoral", "code": "Left pectoral" }, { "name": "Left pelvic", "code": "Left pelvic" }, { "name": "Lower caudal", "code": "Lower caudal" }, { "name": "Right pectoral", "code": "Right pectoral" }, { "name": "Right pelvic", "code": "Right pelvic" }, { "name": "Upper caudal", "code": "Upper caudal" }, { "name": "Internal", "code": "Internal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": { "type": "codedValue", "name": "tag_colors", "description": "Tag Colors", "codedValues": [ { "name": "Black", "code": "Black" }, { "name": "Blue", "code": "Blue" }, { "name": "Green", "code": "Green" }, { "name": "Orange", "code": "Orange" }, { "name": "Pink", "code": "Pink" }, { "name": "Purple", "code": "Purple" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" }, { "name": "Yellow", "code": "Yellow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NEW_TAG", "type": "esriFieldTypeString", "alias": "New Tag", "length": 50, "domain": { "type": "codedValue", "name": "true_false", "description": "Yes/No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TRANSPONDER_FREQ", "type": "esriFieldTypeString", "alias": "Transponder Frequency (kHz)", "length": 50, "domain": { "type": "codedValue", "name": "tag_frequencies", "description": "Tag Frequencies", "codedValues": [ { "name": "125", "code": "125" }, { "name": "134", "code": "134" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TRANSMITTER_FREQ", "type": "esriFieldTypeSmallInteger", "alias": "Transmitter Frequency", "domain": null }, { "name": "TRANSMITTER_FREQ_TYPE", "type": "esriFieldTypeString", "alias": "Transmitter Frequency Type", "length": 50, "domain": { "type": "codedValue", "name": "frequency_types", "description": "Frequency Types", "codedValues": [ { "name": "kHz", "code": "kHz" }, { "name": "MHz", "code": "MHz" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R21_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G51FISH_ID", "fields": "FISH_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Fish", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FISH_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 6, "name": "Habitat", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BANKVEG", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "BANKVEG", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Bank Vegatated", "domain": null }, { "name": "DOVR", "type": "esriFieldTypeString", "alias": "Dominant Overstory", "length": 50, "domain": { "type": "codedValue", "name": "dominant_overstories", "description": "Dominant Overstories", "codedValues": [ { "name": "American plum", "code": "American plum" }, { "name": "Big saltbrush", "code": "Big saltbrush" }, { "name": "Big tooth maple", "code": "Big tooth maple" }, { "name": "Blueberry elder", "code": "Blueberry elder" }, { "name": "Canyon grape", "code": "Canyon grape" }, { "name": "Carolina poplar", "code": "Carolina poplar" }, { "name": "Chokecherry", "code": "Chokecherry" }, { "name": "Desert willow", "code": "Desert willow" }, { "name": "Emory bacharis", "code": "Emory bacharis" }, { "name": "Fremont cottonwood", "code": "Fremont cottonwood" }, { "name": "Gamble oak", "code": "Gamble oak" }, { "name": "Golden currant", "code": "Golden currant" }, { "name": "Greasewood", "code": "Greasewood" }, { "name": "Hackberry", "code": "Hackberry" }, { "name": "Hopa crabapple", "code": "Hopa crabapple" }, { "name": "Lilac", "code": "Lilac" }, { "name": "Mountain ash", "code": "Mountain ash" }, { "name": "Narrowleaf cottonwood", "code": "Narrowleaf cottonwood" }, { "name": "New Mexico locust", "code": "New Mexico locust" }, { "name": "Redtop", "code": "Redtop" }, { "name": "Rocky Mountain maple", "code": "Rocky Mountain maple" }, { "name": "Russian mulberry", "code": "Russian mulberry" }, { "name": "Saskatoon serviceberry", "code": "Saskatoon serviceberry" }, { "name": "Shrub live oak", "code": "Shrub live oak" }, { "name": "Siberian peashrub", "code": "Siberian peashrub" }, { "name": "Skunk bush sumac", "code": "Skunk bush sumac" }, { "name": "Water birch", "code": "Water birch" }, { "name": "Willow", "code": "Willow" }, { "name": "Woods rose", "code": "Woods rose" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DUND", "type": "esriFieldTypeString", "alias": "Dominant Understory", "length": 50, "domain": { "type": "codedValue", "name": "dominant_understories", "description": "Dominant Understories", "codedValues": [ { "name": "Alkali sacaton", "code": "Alkali sacaton" }, { "name": "Anderson peachbush", "code": "Anderson peachbush" }, { "name": "Autum eleagus", "code": "Autum eleagus" }, { "name": "Basin big sagebrush", "code": "Basin big sagebrush" }, { "name": "Bessy cherry", "code": "Bessy cherry" }, { "name": "Bladdersenia", "code": "Bladdersenia" }, { "name": "Bulrush", "code": "Bulrush" }, { "name": "Bush cinquefoil", "code": "Bush cinquefoil" }, { "name": "Carex", "code": "Carex" }, { "name": "Cattle saltbrush", "code": "Cattle saltbrush" }, { "name": "Creeping meadow foxtail", "code": "Creeping meadow foxtail" }, { "name": "Desert peachbush", "code": "Desert peachbush" }, { "name": "Dogwood", "code": "Dogwood" }, { "name": "Douglas hawthorn", "code": "Douglas hawthorn" }, { "name": "Fourwing saltbrush", "code": "Fourwing saltbrush" }, { "name": "Great Basin wildrye", "code": "Great Basin wildrye" }, { "name": "Intermediate wheatgrass", "code": "Intermediate wheatgrass" }, { "name": "Kentucky bluegrass", "code": "Kentucky bluegrass" }, { "name": "Leadplant amorpha", "code": "Leadplant amorpha" }, { "name": "Longflower snowberry", "code": "Longflower snowberry" }, { "name": "Mammoth wildrye", "code": "Mammoth wildrye" }, { "name": "Mountain big sagebrush", "code": "Mountain big sagebrush" }, { "name": "Mountain rye", "code": "Mountain rye" }, { "name": "Mountain snowberry", "code": "Mountain snowberry" }, { "name": "Oldman wormwood", "code": "Oldman wormwood" }, { "name": "Pecking catoneaster", "code": "Pecking catoneaster" }, { "name": "Pygmy peashrub", "code": "Pygmy peashrub" }, { "name": "Reed canary grass", "code": "Reed canary grass" }, { "name": "River hawthorn", "code": "River hawthorn" }, { "name": "Rocky Mountain sumac", "code": "Rocky Mountain sumac" }, { "name": "Rubber rabbitbrush", "code": "Rubber rabbitbrush" }, { "name": "Rush", "code": "Rush" }, { "name": "Sand sagebrush", "code": "Sand sagebrush" }, { "name": "Sandberg bluegrass", "code": "Sandberg bluegrass" }, { "name": "Silver buffaloberry", "code": "Silver buffaloberry" }, { "name": "Silver sagebrush", "code": "Silver sagebrush" }, { "name": "Spikerush", "code": "Spikerush" }, { "name": "Tall oatgrass", "code": "Tall oatgrass" }, { "name": "Tall wheatgrass", "code": "Tall wheatgrass" }, { "name": "Tetarian honeysuckle", "code": "Tetarian honeysuckle" }, { "name": "Torrey saltbrush", "code": "Torrey saltbrush" }, { "name": "Utah honeysuckle", "code": "Utah honeysuckle" }, { "name": "Westerm snowberry", "code": "Westerm snowberry" }, { "name": "Western virgin bower", "code": "Western virgin bower" }, { "name": "Western wheatgrass", "code": "Western wheatgrass" }, { "name": "Wyoming big sagebrush", "code": "Wyoming big sagebrush" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LGWD", "type": "esriFieldTypeSmallInteger", "alias": "Large Woody Debris", "domain": null }, { "name": "POOL", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Pool Area", "domain": null }, { "name": "SPNG", "type": "esriFieldTypeString", "alias": "Presence of Spring", "length": 3, "domain": { "type": "codedValue", "name": "true_false", "description": "Yes/No", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RIFF", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Riffle Area", "domain": null }, { "name": "RUNA", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Run Area", "domain": null }, { "name": "SUB_FINES", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Fines Sediment Class", "domain": null }, { "name": "SUB_SAND", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Sands Sediment Class", "domain": null }, { "name": "SUB_GRAV", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Gravel Sediment Class", "domain": null }, { "name": "SUB_COBB", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Cobble Sediment Class", "domain": null }, { "name": "SUB_RUBB", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Rubble Sediment Class", "domain": null }, { "name": "SUB_BOUL", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Boulder Sediment Class", "domain": null }, { "name": "SIN", "type": "esriFieldTypeSmallInteger", "alias": "Sinuosity", "domain": null }, { "name": "EROS", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Banks Eroding", "domain": null }, { "name": "TEMP_", "type": "esriFieldTypeSingle", "alias": "Water Temperature", "domain": null }, { "name": "SUB_BEDR", "type": "esriFieldTypeSmallInteger", "alias": "Percentage of Bedrock Sediment Class", "domain": null }, { "name": "BACKWATER", "type": "esriFieldTypeSmallInteger", "alias": "Backwater Area (m2)", "domain": null }, { "name": "PH", "type": "esriFieldTypeSingle", "alias": "pH", "domain": null }, { "name": "CON", "type": "esriFieldTypeDouble", "alias": "Conductivity", "domain": null }, { "name": "OXYGEN", "type": "esriFieldTypeDouble", "alias": "Dissolved Oxygen (mg/l)", "domain": null }, { "name": "SOLIDS", "type": "esriFieldTypeDouble", "alias": "Total Dissolved Solids (ppm)", "domain": null }, { "name": "TURBIDITY", "type": "esriFieldTypeDouble", "alias": "Turbidity", "domain": null }, { "name": "ALKALINITY", "type": "esriFieldTypeDouble", "alias": "Alkalinity (ppm CaCO3)", "domain": null } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G45EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "SamplingEvent", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "Equipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "WAVEFORM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "WAVEFORM", "type": "esriFieldTypeString", "alias": "Waveform", "length": 50, "domain": { "type": "codedValue", "name": "waveforms", "description": "Waveform", "codedValues": [ { "name": "Alternate current", "code": "Alternate current" }, { "name": "Burst", "code": "Burst" }, { "name": "Direct current", "code": "Direct current" }, { "name": "Pulsed AC", "code": "Pulsed AC" }, { "name": "Pulsed DC", "code": "Pulsed DC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DUTY_CYCLE", "type": "esriFieldTypeSmallInteger", "alias": "Duty Cycle", "domain": null }, { "name": "FREQUENCY", "type": "esriFieldTypeSmallInteger", "alias": "Frequency", "domain": null }, { "name": "NUM_ANODES", "type": "esriFieldTypeSmallInteger", "alias": "# Anodes", "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "length": 50, "domain": { "type": "codedValue", "name": "equipment_models", "description": "Equipment Models", "codedValues": [ { "name": "Coffelt VVP-15", "code": "Coffelt VVP-15" }, { "name": "Coffelt VVP MK 22", "code": "Coffelt VVP MK 22" }, { "name": "Smith Root 1.5KVA", "code": "Smith Root 1.5KVA" }, { "name": "Smith Root B-12", "code": "Smith Root B-12" }, { "name": "Smith Root GPP 2.5", "code": "Smith Root GPP 2.5" }, { "name": "Smith Root GPP 5.0", "code": "Smith Root GPP 5.0" }, { "name": "Smith Root GPP 7.5", "code": "Smith Root GPP 7.5" }, { "name": "Smith Root GPP 9.0", "code": "Smith Root GPP 9.0" }, { "name": "Smith Root LR-20", "code": "Smith Root LR-20" }, { "name": "Smith Root LR-24", "code": "Smith Root LR-24" }, { "name": "Smith Root VI-A", "code": "Smith Root VI-A" }, { "name": "Smith Root VVP 15B", "code": "Smith Root VVP 15B" }, { "name": "Halltech HT2000", "code": "Halltech HT2000" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARRAY_TYPE", "type": "esriFieldTypeString", "alias": "ARRAY_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "array_types", "description": "Array types", "codedValues": [ { "name": "Diamond anode", "code": "Diamond anode" }, { "name": "Round anode", "code": "Round anode" }, { "name": "Spherical array", "code": "Spherical array" }, { "name": "Square net anode", "code": "Square net anode" }, { "name": "Wisconsin ring array", "code": "Wisconsin ring array" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NUM_NETTERS", "type": "esriFieldTypeSmallInteger", "alias": "NUM_NETTERS", "domain": null }, { "name": "CATHODE_TYPE", "type": "esriFieldTypeString", "alias": "CATHODE_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "cathode_types", "description": "Cathode Types", "codedValues": [ { "name": "Boat", "code": "Boat" }, { "name": "Non-boat", "code": "Non-boat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": { "type": "codedValue", "name": "equipment_type", "description": "Equipment Types", "codedValues": [ { "name": "Backpack", "code": "Backpack" }, { "name": "Canoe/Barge", "code": "Canoe/Barge" }, { "name": "Raft/Boat", "code": "Raft/Boat" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PEDAL_TIME", "type": "esriFieldTypeInteger", "alias": "Duration/Pedal Time in Seconds", "domain": null }, { "name": "EQUIPMENT_ID", "type": "esriFieldTypeGUID", "alias": "Equipment ID", "length": 38, "domain": null }, { "name": "VOLTAGE", "type": "esriFieldTypeSingle", "alias": "Voltage", "domain": null }, { "name": "AMPS", "type": "esriFieldTypeSingle", "alias": "Amps", "domain": null }, { "name": "CATHODE_LEN", "type": "esriFieldTypeSingle", "alias": "Cathode Length", "domain": null }, { "name": "CATHODE_DIAMETER", "type": "esriFieldTypeSingle", "alias": "Cathode Diameter", "domain": null }, { "name": "MACHINE_RES", "type": "esriFieldTypeInteger", "alias": "Machine-specific resistence", "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G44EQUIPMENT_ID", "fields": "EQUIPMENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G44EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Anodes", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 2, "name": "SamplingEvents", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "Anodes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ANODE_DIAMETER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ANODE_DIAMETER", "type": "esriFieldTypeSmallInteger", "alias": "Anode Diameter: Maximum Opening", "domain": null }, { "name": "STOCK_DIAMETER", "type": "esriFieldTypeDouble", "alias": "Stock Diameter: X-section of anode stock", "domain": null }, { "name": "EQUIPMENT_ID", "type": "esriFieldTypeGUID", "alias": "Equipment ID", "length": 38, "domain": null }, { "name": "ANODE_SHAPE", "type": "esriFieldTypeString", "alias": "Anode Shape", "length": 50, "domain": { "type": "codedValue", "name": "anode_shapes", "description": "Annode Shapes", "codedValues": [ { "name": "Round", "code": "Round" }, { "name": "Diamond", "code": "Diamond" }, { "name": "Square net", "code": "Square net" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R13_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G43EQUIPMENT_ID", "fields": "EQUIPMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Equipment", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "Transect", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BWID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeGUID", "alias": "Event ID", "length": 38, "domain": null }, { "name": "BWID", "type": "esriFieldTypeDouble", "alias": "Bankfull width", "domain": null }, { "name": "WWID", "type": "esriFieldTypeDouble", "alias": "Wetted width", "domain": null }, { "name": "STARTING_BANK", "type": "esriFieldTypeString", "alias": "Starting bank", "length": 50, "domain": { "type": "codedValue", "name": "starting_bank_types", "description": "Starting banks", "codedValues": [ { "name": "River Right", "code": "River Right" }, { "name": "River Left", "code": "River Left" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TRANSECT_ID", "type": "esriFieldTypeGUID", "alias": "Transect ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R17_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G47TRANSECT_ID", "fields": "TRANSECT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G47EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "TransectMeasurements", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "TRANSECT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 4, "name": "SamplingEvents", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EVENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "TransectMeasurements", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DEPTH", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DEPTH", "type": "esriFieldTypeDouble", "alias": "Depth", "domain": null }, { "name": "VELOCITY", "type": "esriFieldTypeDouble", "alias": "Velocity", "domain": null }, { "name": "SUBSTRATE", "type": "esriFieldTypeString", "alias": "Substrate", "length": 50, "domain": { "type": "codedValue", "name": "substrate_types", "description": "Substrate Types", "codedValues": [ { "name": "Fines", "code": "Fines" }, { "name": "Sand", "code": "Sand" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Cobble", "code": "Cobble" }, { "name": "Rubble", "code": "Rubble" }, { "name": "Boulder", "code": "Boulder" }, { "name": "Bedrock", "code": "Bedrock" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DISTANCE_START", "type": "esriFieldTypeDouble", "alias": "Distance from starting bank", "domain": null }, { "name": "TRANSECT_ID", "type": "esriFieldTypeGUID", "alias": "Transect ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R18_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G48TRANSECT_ID", "fields": "TRANSECT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Transect", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "TRANSECT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": true, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }