{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 30, "name": "WaterResults", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StationID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StationID", "type": "esriFieldTypeString", "alias": "Station ID", "length": 20, "domain": null }, { "name": "DepthID", "type": "esriFieldTypeString", "alias": "Depth ID", "length": 20, "domain": null }, { "name": "Depth", "type": "esriFieldTypeDouble", "alias": "Depth (ft)", "domain": null }, { "name": "Temp_C", "type": "esriFieldTypeDouble", "alias": "Temperature (Celsius)", "domain": null }, { "name": "Eh_mV", "type": "esriFieldTypeDouble", "alias": "Oxidation Potential (mV)", "domain": null }, { "name": "Sal_ppt", "type": "esriFieldTypeDouble", "alias": "Salinity (ppt)", "domain": null }, { "name": "Cond_mmho", "type": "esriFieldTypeDouble", "alias": "Conductivity (mmho)", "domain": null }, { "name": "O2_mgl", "type": "esriFieldTypeDouble", "alias": "Dissolved Oxygen (mg/L)", "domain": null }, { "name": "Turb_NTU", "type": "esriFieldTypeDouble", "alias": "Turbidity (NTU)", "domain": null }, { "name": "Pres_dbars", "type": "esriFieldTypeDouble", "alias": "Pressure (Dbars)", "domain": null }, { "name": "Dens_kgm3", "type": "esriFieldTypeDouble", "alias": "Density (kg/m3)", "domain": null }, { "name": "Velocity_msec", "type": "esriFieldTypeDouble", "alias": "Velocity (meters/sec)", "domain": null }, { "name": "CDOM", "type": "esriFieldTypeDouble", "alias": "Color Dissolved Organic Matter", "domain": null }, { "name": "Water_GlobalResultID", "type": "esriFieldTypeGUID", "alias": "Global Water ID", "length": 38, "domain": null }, { "name": "WCLayer", "type": "esriFieldTypeString", "alias": "CMECS Water Component Layer", "length": 50, "domain": { "type": "codedValue", "name": "WCLayer", "description": "CMECS Water Component Layer", "codedValues": [ { "name": "Marine Nearshore Surface Layer", "code": "Marine Nearshore Surface Layer" }, { "name": "Marine Nearshore Upper Water Column", "code": "Marine Nearshore Upper Water Column" }, { "name": "Marine Nearshore Pycnocline", "code": "Marine Nearshore Pycnocline" }, { "name": "Marine Nearshore Lower Water Column", "code": "Marine Nearshore Lower Water Column" }, { "name": "Marine Offshore Surface Layer", "code": "Marine Offshore Surface Layer" }, { "name": "Marine Offshore Upper Water Column", "code": "Marine Offshore Upper Water Column" }, { "name": "Marine Offshore Pycnocline", "code": "Marine Offshore Pycnocline" }, { "name": "Marine Offshore Lower Water Column", "code": "Marine Offshore Lower Water Column" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WCTemperature", "type": "esriFieldTypeString", "alias": "CMECS Water Component Temperature", "length": 50, "domain": { "type": "codedValue", "name": "WCTemp", "description": "CMECS Water Component Temperature", "codedValues": [ { "name": "Frozen/Superchilled Water", "code": "Frozen Water" }, { "name": "Very Cold Water", "code": "Very Cold Water" }, { "name": "Cold Water", "code": "Cold Water" }, { "name": "Cool Water", "code": "Cool Water" }, { "name": "Moderate Water", "code": "Moderate Water" }, { "name": "Warm Water", "code": "Warm Water" }, { "name": "Very Warm Water", "code": "Very Warm Water" }, { "name": "Hot Water", "code": "Hot Water" }, { "name": "Very Hot Water", "code": "Very Hot Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WCSalinity", "type": "esriFieldTypeString", "alias": "CMECS Water Component Salinity", "length": 50, "domain": { "type": "codedValue", "name": "WCSalinity", "description": "CMECS Water Component Salinity", "codedValues": [ { "name": "Oligohaline Water", "code": "Oligohaline Water" }, { "name": "Mesohaline Water", "code": "Mesohaline Water" }, { "name": "Lower Polyhaline Water", "code": "Lower Polyhaline Water" }, { "name": "Upper Polyhaline Water", "code": "Upper Polyhaline Water" }, { "name": "Euhaline Water", "code": "Euhaline Water" }, { "name": "Hyperhaline Water", "code": "Hyperhaline Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "pH", "type": "esriFieldTypeDouble", "alias": "pH", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G113Water_Global", "fields": "Water_GlobalResultID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Water Results", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Water_GlobalResultID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CD826B0C-852F-440B-AB43-F6B8168F231B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }