{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "all_sites_coordinates", "type" : "Feature Layer", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "long_name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784578227029, "schemaLastEditDate" : 1784578227029, "dataLastEditDate" : 1784228670676 }, "relationships" : [ { "id" : 2, "name" : "pH_All_Years_Sites", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 5, "name" : "shellfish_allyears", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 3, "name" : "Salinity_All_Years_Sites", "relatedTableId" : 9, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 1, "name" : "Light_All_Years_Sites", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 0, "name" : "DO_All_Years_Sites", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 7, "name" : "bird_focalfollow_allyears", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 6, "name" : "bird_scan_allyears", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false }, { "id" : 4, "name" : "eelgrass_allyears", "relatedTableId" : 6, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -13811720.1381, "ymin" : 5860044.2122000009, "xmax" : -13623823.7469, "ymax" : 6257390.6329, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"long_name","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,85,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"long name","classes":[{"label":"Anderson Cove","description":"Anderson Cove","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[120,153,49,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Anderson Cove"]]},{"label":"Case Inlet","description":"Case Inlet","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[43,53,148,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Case Inlet"]]},{"label":"Cherry Point","description":"Cherry Point","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,33,45,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Cherry Point"]]},{"label":"Dungeness Bay","description":"Dungeness Bay","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[45,137,156,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Dungeness Bay"]]},{"label":"Elliott Bay","description":"Elliott Bay","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[173,38,140,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Elliott Bay"]]},{"label":"Fidalgo Bay","description":"Fidalgo Bay","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[176,130,37,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Fidalgo Bay"]]},{"label":"Grays Harbor","description":"Grays Harbor","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,173,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Grays Harbor"]]},{"label":"Hermosa Point","description":"Hermosa Point","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,62,86,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Hermosa Point"]]},{"label":"Maury Island","description":"Maury Island","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,93,63,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Maury Island"]]},{"label":"Nisqually Reach","description":"Nisqually Reach","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[103,39,176,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Nisqually Reach"]]},{"label":"Port Gamble","description":"Port Gamble","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,105,168,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Port Gamble"]]},{"label":"Sequim Bay","description":"Sequim Bay","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[118,64,128,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Sequim Bay"]]},{"label":"Skokomish Delta","description":"Skokomish Delta","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,119,51,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Skokomish Delta"]]},{"label":"Whidbey Island","description":"Whidbey Island","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[36,173,68,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Whidbey Island"]]},{"label":"Willapa Bay","description":"Willapa Bay","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[61,128,68,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"values":[["Willapa Bay"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[120,153,49,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Anderson Cove","label":"Anderson Cove"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[43,53,148,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Case Inlet","label":"Case Inlet"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,33,45,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Cherry Point","label":"Cherry Point"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[45,137,156,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Dungeness Bay","label":"Dungeness Bay"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[173,38,140,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Elliott Bay","label":"Elliott Bay"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[176,130,37,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Fidalgo Bay","label":"Fidalgo Bay"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,173,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Grays Harbor","label":"Grays Harbor"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,62,86,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Hermosa Point","label":"Hermosa Point"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[138,93,63,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Maury Island","label":"Maury Island"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[103,39,176,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Nisqually Reach","label":"Nisqually Reach"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,105,168,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Port Gamble","label":"Port Gamble"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[118,64,128,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Sequim Bay","label":"Sequim Bay"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,119,51,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Skokomish Delta","label":"Skokomish Delta"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[36,173,68,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Whidbey Island","label":"Whidbey Island"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[61,128,68,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0.7}},"value":"Willapa Bay","label":"Willapa Bay"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[133,121,44,255],"toColor":[133,121,44,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[75,49,168,255],"toColor":[75,49,168,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[49,115,143,255],"toColor":[49,115,143,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,54,98,255],"toColor":[163,54,98,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[44,171,55,255],"toColor":[44,171,55,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[150,54,35,255],"toColor":[150,54,35,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[30,130,93,255],"toColor":[30,130,93,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[137,75,153,255],"toColor":[137,75,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[150,176,46,255],"toColor":[150,176,46,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[56,99,168,255],"toColor":[56,99,168,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[68,171,169,255],"toColor":[68,171,169,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[145,40,166,255],"toColor":[145,40,166,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[88,135,58,255],"toColor":[88,135,58,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[171,101,84,255],"toColor":[171,101,84,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[171,104,38,255],"toColor":[171,104,38,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "long_name", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "long_name", "type" : "esriFieldTypeString", "alias" : "long name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Station_Lat__DD_", "type" : "esriFieldTypeDouble", "alias" : "Station Lat (DD)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Station_Long__DD_", "type" : "esriFieldTypeDouble", "alias" : "Station Long (DD)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DDLat", "type" : "esriFieldTypeString", "alias" : "DDLat", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DDLon", "type" : "esriFieldTypeString", "alias" : "DDLon", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ORIG_OID", "type" : "esriFieldTypeInteger", "alias" : "ORIG_OID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85D09EB72B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_349.ANEMONE_DATABASE_ALL_SITES_COORDINATES2_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "G3site", "fields" : "site", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G3code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "long_name_Index", "fields" : "long_name", "isAscending" : true, "isUnique" : false, "description" : "long_name_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Anderson Cove", "name" : "Anderson Cove", "domains" : { }, "templates" : [ { "name" : "Anderson Cove", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Anderson Cove", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Case Inlet", "name" : "Case Inlet", "domains" : { }, "templates" : [ { "name" : "Case Inlet", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Case Inlet", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Cherry Point", "name" : "Cherry Point", "domains" : { }, "templates" : [ { "name" : "Cherry Point", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Cherry Point", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Dungeness Bay", "name" : "Dungeness Bay", "domains" : { }, "templates" : [ { "name" : "Dungeness Bay", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Dungeness Bay", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Elliott Bay", "name" : "Elliott Bay", "domains" : { }, "templates" : [ { "name" : "Elliott Bay", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Elliott Bay", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Fidalgo Bay", "name" : "Fidalgo Bay", "domains" : { }, "templates" : [ { "name" : "Fidalgo Bay", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Fidalgo Bay", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Grays Harbor", "name" : "Grays Harbor", "domains" : { }, "templates" : [ { "name" : "Grays Harbor", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Grays Harbor", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Hermosa Point", "name" : "Hermosa Point", "domains" : { }, "templates" : [ { "name" : "Hermosa Point", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Hermosa Point", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Maury Island", "name" : "Maury Island", "domains" : { }, "templates" : [ { "name" : "Maury Island", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Maury Island", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Nisqually Reach", "name" : "Nisqually Reach", "domains" : { }, "templates" : [ { "name" : "Nisqually Reach", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Nisqually Reach", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Port Gamble", "name" : "Port Gamble", "domains" : { }, "templates" : [ { "name" : "Port Gamble", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Port Gamble", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Sequim Bay", "name" : "Sequim Bay", "domains" : { }, "templates" : [ { "name" : "Sequim Bay", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Sequim Bay", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Skokomish Delta", "name" : "Skokomish Delta", "domains" : { }, "templates" : [ { "name" : "Skokomish Delta", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Skokomish Delta", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Whidbey Island", "name" : "Whidbey Island", "domains" : { }, "templates" : [ { "name" : "Whidbey Island", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Whidbey Island", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] }, { "id" : "Willapa Bay", "name" : "Willapa Bay", "domains" : { }, "templates" : [ { "name" : "Willapa Bay", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "DDLon" : null, "ORIG_OID" : null, "long_name" : "Willapa Bay", "site" : null, "habitat" : null, "code" : null, "Station_Lat__DD_" : null, "Station_Long__DD_" : null, "notes" : null, "DDLat" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 400000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 3, "name" : "bird_focalfollow_allyears", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784228670802 }, "relationships" : [ { "id" : 7, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date", "type" : "esriFieldTypeDateOnly", "alias" : "date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "tide", "type" : "esriFieldTypeString", "alias" : "tide", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "year", "type" : "esriFieldTypeInteger", "alias" : "year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "survey", "type" : "esriFieldTypeInteger", "alias" : "survey", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_time", "type" : "esriFieldTypeString", "alias" : "start.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "end_time", "type" : "esriFieldTypeString", "alias" : "end.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "time_total", "type" : "esriFieldTypeString", "alias" : "time.total", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "time_in_min", "type" : "esriFieldTypeInteger", "alias" : "time.in.min", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "functional_group", "type" : "esriFieldTypeString", "alias" : "functional.group", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bird_species", "type" : "esriFieldTypeString", "alias" : "bird.species", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat_region", "type" : "esriFieldTypeString", "alias" : "habitat.region", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sub_habitat", "type" : "esriFieldTypeString", "alias" : "sub.habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "resting", "type" : "esriFieldTypeInteger", "alias" : "resting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "moving", "type" : "esriFieldTypeInteger", "alias" : "moving", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "foraging", "type" : "esriFieldTypeInteger", "alias" : "foraging", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "preening", "type" : "esriFieldTypeInteger", "alias" : "preening", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "neg_interacting", "type" : "esriFieldTypeInteger", "alias" : "neg.interacting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pos_interacting", "type" : "esriFieldTypeInteger", "alias" : "pos.interacting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exiting", "type" : "esriFieldTypeString", "alias" : "exiting", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_resting", "type" : "esriFieldTypeDouble", "alias" : "prop.resting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_moving", "type" : "esriFieldTypeDouble", "alias" : "prop.moving", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_foraging", "type" : "esriFieldTypeDouble", "alias" : "prop.foraging", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_preening", "type" : "esriFieldTypeDouble", "alias" : "prop.preening", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_neg_interacting", "type" : "esriFieldTypeDouble", "alias" : "prop.neg.interacting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_pos_interacting", "type" : "esriFieldTypeDouble", "alias" : "prop.pos.interacting", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85007D3D93", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G9code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "bird_focalfollow_allyears", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "comments" : null, "code" : null, "site" : null, "date" : null, "tide" : null, "year" : null, "survey" : null, "start_time" : null, "end_time" : null, "time_total" : null, "time_in_min" : null, "functional_group" : null, "bird_species" : null, "habitat_region" : null, "sub_habitat" : null, "resting" : null, "moving" : null, "foraging" : null, "preening" : null, "neg_interacting" : null, "pos_interacting" : null, "exiting" : null, "prop_resting" : null, "prop_moving" : null, "prop_foraging" : null, "prop_preening" : null, "prop_neg_interacting" : null, "prop_pos_interacting" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "bird_scan_allyears", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784228670912 }, "relationships" : [ { "id" : 6, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "subbasin", "type" : "esriFieldTypeString", "alias" : "subbasin", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "year", "type" : "esriFieldTypeInteger", "alias" : "year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date", "type" : "esriFieldTypeDateOnly", "alias" : "date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "tide", "type" : "esriFieldTypeString", "alias" : "tide", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_time", "type" : "esriFieldTypeString", "alias" : "start.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "predicted_low_tide", "type" : "esriFieldTypeString", "alias" : "predicted.low.tide", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "end_time", "type" : "esriFieldTypeString", "alias" : "end.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "scan_time", "type" : "esriFieldTypeDouble", "alias" : "scan.time", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "functional_group", "type" : "esriFieldTypeString", "alias" : "functional.group", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bird_species", "type" : "esriFieldTypeString", "alias" : "bird.species", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "count_", "type" : "esriFieldTypeInteger", "alias" : "count", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sub_habitat", "type" : "esriFieldTypeString", "alias" : "sub.habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "notes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85C479567D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G10code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "bird_scan_allyears", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "notes" : null, "code" : null, "site" : null, "subbasin" : null, "year" : null, "date" : null, "tide" : null, "start_time" : null, "predicted_low_tide" : null, "end_time" : null, "scan_time" : null, "functional_group" : null, "bird_species" : null, "count_" : null, "habitat" : null, "sub_habitat" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 5, "name" : "DO_All_Years_Sites", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229051095 }, "relationships" : [ { "id" : 0, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "times", "type" : "esriFieldTypeDate", "alias" : "times", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "do_mgl_not_adj", "type" : "esriFieldTypeDouble", "alias" : "do.mgl.not.adj", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "do_mgl_adj", "type" : "esriFieldTypeString", "alias" : "do.mgl.adj", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "temp_c_do", "type" : "esriFieldTypeString", "alias" : "temp.c.do", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "conductivity_uspcm", "type" : "esriFieldTypeString", "alias" : "conductivity.uspcm", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "do", "type" : "esriFieldTypeDouble", "alias" : "do", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sal_adj", "type" : "esriFieldTypeString", "alias" : "sal.adj", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "gross_range_test", "type" : "esriFieldTypeString", "alias" : "gross_range_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "spike_test", "type" : "esriFieldTypeString", "alias" : "spike_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flat_line_test", "type" : "esriFieldTypeString", "alias" : "flat_line_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "climatology_test", "type" : "esriFieldTypeString", "alias" : "climatology_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rate_of_change_test", "type" : "esriFieldTypeString", "alias" : "rate_of_change_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "variance_test", "type" : "esriFieldTypeString", "alias" : "variance_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "final_summary", "type" : "esriFieldTypeString", "alias" : "final_summary", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_do", "type" : "esriFieldTypeString", "alias" : "qc_do", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_wl", "type" : "esriFieldTypeString", "alias" : "qc_wl", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "in_water", "type" : "esriFieldTypeString", "alias" : "in.water", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D8562433941", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G8code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "DO_All_Years_Sites", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "qc_wl" : null, "in_water" : null, "times" : null, "site" : null, "habitat" : null, "do_mgl_not_adj" : null, "do_mgl_adj" : null, "temp_c_do" : null, "conductivity_uspcm" : null, "do" : null, "sal_adj" : null, "gross_range_test" : null, "spike_test" : null, "flat_line_test" : null, "climatology_test" : null, "rate_of_change_test" : null, "variance_test" : null, "final_summary" : null, "qc_do" : null, "code" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "eelgrass_allyears", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "names", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229051861 }, "relationships" : [ { "id" : 4, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ObjectID_1", "type" : "esriFieldTypeString", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeString", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "subbasin", "type" : "esriFieldTypeString", "alias" : "subbasin", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date", "type" : "esriFieldTypeDateOnly", "alias" : "date", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "names", "type" : "esriFieldTypeString", "alias" : "names", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "year", "type" : "esriFieldTypeInteger", "alias" : "year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "season", "type" : "esriFieldTypeString", "alias" : "season", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "season_year", "type" : "esriFieldTypeString", "alias" : "season.year", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "tide", "type" : "esriFieldTypeString", "alias" : "tide", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "predicted_tide_height", "type" : "esriFieldTypeString", "alias" : "predicted.tide.height", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "predicted_tide_time", "type" : "esriFieldTypeString", "alias" : "predicted.tide.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_time", "type" : "esriFieldTypeString", "alias" : "start.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "end_time", "type" : "esriFieldTypeString", "alias" : "end.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "total_time", "type" : "esriFieldTypeString", "alias" : "total.time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "total_time_min", "type" : "esriFieldTypeString", "alias" : "total.time.min", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "dice", "type" : "esriFieldTypeString", "alias" : "dice", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "transect_depth", "type" : "esriFieldTypeString", "alias" : "transect.depth", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "quadrat", "type" : "esriFieldTypeInteger", "alias" : "quadrat", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "percent_japonica", "type" : "esriFieldTypeString", "alias" : "percent.japonica", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "total_shoots", "type" : "esriFieldTypeInteger", "alias" : "total.shoots", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "total_shoots_meter", "type" : "esriFieldTypeInteger", "alias" : "total.shoots.meter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "total_flowering", "type" : "esriFieldTypeString", "alias" : "total.flowering", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_flowering_meter", "type" : "esriFieldTypeInteger", "alias" : "prop.flowering.meter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prop_flowering_meter_new", "type" : "esriFieldTypeString", "alias" : "prop.flowering.meter.new", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shoot_length_1", "type" : "esriFieldTypeInteger", "alias" : "shoot.length.1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shoot_length_2", "type" : "esriFieldTypeDouble", "alias" : "shoot.length.2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shoot_length_3", "type" : "esriFieldTypeDouble", "alias" : "shoot.length.3", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "avg_shoot_length", "type" : "esriFieldTypeDouble", "alias" : "avg.shoot.length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flowering_present", "type" : "esriFieldTypeDouble", "alias" : "flowering.present", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "percent_marina", "type" : "esriFieldTypeString", "alias" : "percent.marina", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "percent_green", "type" : "esriFieldTypeString", "alias" : "percent.green", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "percent_brown", "type" : "esriFieldTypeString", "alias" : "percent.brown", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "percent_red", "type" : "esriFieldTypeString", "alias" : "percent.red", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "comments", "type" : "esriFieldTypeString", "alias" : "comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sensor_check_eelgrass", "type" : "esriFieldTypeString", "alias" : "sensor.check.eelgrass", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sensor_check_bare", "type" : "esriFieldTypeString", "alias" : "sensor.check.bare", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "eelgrass_deployed", "type" : "esriFieldTypeString", "alias" : "eelgrass.deployed", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "eelgrass_collected", "type" : "esriFieldTypeString", "alias" : "eelgrass.collected", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bare_deployed", "type" : "esriFieldTypeString", "alias" : "bare.deployed", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "bare_collected", "type" : "esriFieldTypeString", "alias" : "bare.collected", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field43", "type" : "esriFieldTypeString", "alias" : "Field43", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D854996B551", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G11code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "eelgrass_allyears", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Field43" : null, "code" : null, "ObjectID_1" : null, "GlobalID" : null, "site" : null, "habitat" : null, "subbasin" : null, "date" : null, "names" : null, "year" : null, "season" : null, "season_year" : null, "tide" : null, "predicted_tide_height" : null, "predicted_tide_time" : null, "start_time" : null, "end_time" : null, "total_time" : null, "total_time_min" : null, "dice" : null, "transect_depth" : null, "quadrat" : null, "percent_japonica" : null, "total_shoots" : null, "total_shoots_meter" : null, "total_flowering" : null, "prop_flowering_meter" : null, "prop_flowering_meter_new" : null, "shoot_length_1" : null, "shoot_length_2" : null, "shoot_length_3" : null, "avg_shoot_length" : null, "flowering_present" : null, "percent_marina" : null, "percent_green" : null, "percent_brown" : null, "percent_red" : null, "comments" : null, "sensor_check_eelgrass" : null, "sensor_check_bare" : null, "eelgrass_deployed" : null, "eelgrass_collected" : null, "bare_deployed" : null, "bare_collected" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "Light_All_Years_Sites", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229091853 }, "relationships" : [ { "id" : 1, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "temp_c_light", "type" : "esriFieldTypeDouble", "alias" : "temp.c.light", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "light", "type" : "esriFieldTypeDouble", "alias" : "light", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "times", "type" : "esriFieldTypeDate", "alias" : "times", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "gross_range_test", "type" : "esriFieldTypeString", "alias" : "gross_range_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "spike_test", "type" : "esriFieldTypeString", "alias" : "spike_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flat_line_test", "type" : "esriFieldTypeString", "alias" : "flat_line_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "climatology_test", "type" : "esriFieldTypeString", "alias" : "climatology_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rate_of_change_test", "type" : "esriFieldTypeString", "alias" : "rate_of_change_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "summary", "type" : "esriFieldTypeString", "alias" : "summary", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_light", "type" : "esriFieldTypeString", "alias" : "qc_light", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_wl", "type" : "esriFieldTypeString", "alias" : "qc_wl", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "in_water", "type" : "esriFieldTypeString", "alias" : "in.water", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85D1D895D3", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G7code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Light_All_Years_Sites", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "in_water" : null, "code" : null, "site" : null, "habitat" : null, "temp_c_light" : null, "light" : null, "times" : null, "gross_range_test" : null, "spike_test" : null, "flat_line_test" : null, "climatology_test" : null, "rate_of_change_test" : null, "summary" : null, "qc_light" : null, "qc_wl" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 8, "name" : "pH_All_Years_Sites", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229186861 }, "relationships" : [ { "id" : 2, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pH", "type" : "esriFieldTypeDouble", "alias" : "pH", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "times", "type" : "esriFieldTypeDate", "alias" : "times", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "gross_range_test", "type" : "esriFieldTypeString", "alias" : "gross_range_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rate_of_change_test", "type" : "esriFieldTypeString", "alias" : "rate_of_change_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "climatology_test", "type" : "esriFieldTypeString", "alias" : "climatology_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flat_line_test", "type" : "esriFieldTypeString", "alias" : "flat_line_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "spike_test", "type" : "esriFieldTypeString", "alias" : "spike_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "variance_test", "type" : "esriFieldTypeString", "alias" : "variance_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hand_qc_ph", "type" : "esriFieldTypeString", "alias" : "hand_qc_ph", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "final_summary", "type" : "esriFieldTypeString", "alias" : "final_summary", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_ph", "type" : "esriFieldTypeString", "alias" : "qc_ph", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_wl", "type" : "esriFieldTypeString", "alias" : "qc_wl", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "in_water", "type" : "esriFieldTypeString", "alias" : "in.water", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85BB03F058", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G4code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "pH_All_Years_Sites", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "qc_wl" : null, "in_water" : null, "site" : null, "habitat" : null, "pH" : null, "times" : null, "gross_range_test" : null, "rate_of_change_test" : null, "climatology_test" : null, "flat_line_test" : null, "spike_test" : null, "variance_test" : null, "hand_qc_ph" : null, "final_summary" : null, "qc_ph" : null, "code" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 9, "name" : "Salinity_All_Years_Sites", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "times", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229438461 }, "relationships" : [ { "id" : 3, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "times", "type" : "esriFieldTypeString", "alias" : "times", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "temp_c_sal", "type" : "esriFieldTypeDouble", "alias" : "temp.c.sal", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "conductivity_uspcm", "type" : "esriFieldTypeDouble", "alias" : "conductivity.uspcm", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "sal", "type" : "esriFieldTypeDouble", "alias" : "sal", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "habitat", "type" : "esriFieldTypeString", "alias" : "habitat", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "gross_range_test", "type" : "esriFieldTypeString", "alias" : "gross_range_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "spike_test", "type" : "esriFieldTypeString", "alias" : "spike_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "flat_line_test", "type" : "esriFieldTypeString", "alias" : "flat_line_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "climatology_test", "type" : "esriFieldTypeString", "alias" : "climatology_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rate_of_change_test", "type" : "esriFieldTypeString", "alias" : "rate_of_change_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "variance_test", "type" : "esriFieldTypeString", "alias" : "variance_test", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "hand_qc_sal", "type" : "esriFieldTypeString", "alias" : "hand_qc_sal", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "final_summary", "type" : "esriFieldTypeString", "alias" : "final_summary", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_sal", "type" : "esriFieldTypeString", "alias" : "qc_sal", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "qc_wl", "type" : "esriFieldTypeString", "alias" : "qc_wl", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "in_water", "type" : "esriFieldTypeString", "alias" : "in.water", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date_time_utc", "type" : "esriFieldTypeString", "alias" : "date.time.utc", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85BEF3277D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G6code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Salinity_All_Years_Sites", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "code" : null, "date_time_utc" : null, "times" : null, "temp_c_sal" : null, "conductivity_uspcm" : null, "sal" : null, "site" : null, "habitat" : null, "gross_range_test" : null, "spike_test" : null, "flat_line_test" : null, "climatology_test" : null, "rate_of_change_test" : null, "variance_test" : null, "hand_qc_sal" : null, "final_summary" : null, "qc_sal" : null, "qc_wl" : null, "in_water" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 10, "name" : "shellfish_allyears", "type" : "Table", "serviceItemId" : "7f8286a3162543bbadd1a0d0dd3a9ff7", "cacheMaxAge" : 3600, "displayField" : "site", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1784567124961, "schemaLastEditDate" : 1784567124961, "dataLastEditDate" : 1784229439027 }, "relationships" : [ { "id" : 5, "name" : "all_sites_coordinates", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "code", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "site", "type" : "esriFieldTypeString", "alias" : "site", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "location", "type" : "esriFieldTypeString", "alias" : "location", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "year", "type" : "esriFieldTypeInteger", "alias" : "year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "tide_collected", "type" : "esriFieldTypeString", "alias" : "tide.collected", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date_outplanted", "type" : "esriFieldTypeDateOnly", "alias" : "date.outplanted", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date_collected", "type" : "esriFieldTypeDateOnly", "alias" : "date.collected", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date_counted", "type" : "esriFieldTypeString", "alias" : "date.counted", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shell_number", "type" : "esriFieldTypeInteger", "alias" : "shell.number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shell_length_cm", "type" : "esriFieldTypeString", "alias" : "shell.length.cm", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shell_width_cm", "type" : "esriFieldTypeString", "alias" : "shell.width.cm", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "shell_area", "type" : "esriFieldTypeString", "alias" : "shell.area", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "pacific_oyster", "type" : "esriFieldTypeInteger", "alias" : "pacific.oyster", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "olympia_oyster", "type" : "esriFieldTypeInteger", "alias" : "olympia.oyster", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "mussels", "type" : "esriFieldTypeInteger", "alias" : "mussels", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "geoduck_horse_clam", "type" : "esriFieldTypeString", "alias" : "geoduck.horse.clam", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "other_clam", "type" : "esriFieldTypeInteger", "alias" : "other.clam", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "barnacles", "type" : "esriFieldTypeInteger", "alias" : "barnacles", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "notes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "code", "type" : "esriFieldTypeString", "alias" : "code", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "site_code", "type" : "esriFieldTypeString", "alias" : "site_code", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__ANEMONE___F4B70D85D6E9C0FA", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G5code", "fields" : "code", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "shellfish_allyears", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "code" : null, "site_code" : null, "site" : null, "location" : null, "year" : null, "tide_collected" : null, "date_outplanted" : null, "date_collected" : null, "date_counted" : null, "shell_number" : null, "shell_length_cm" : null, "shell_width_cm" : null, "shell_area" : null, "pacific_oyster" : null, "olympia_oyster" : null, "mussels" : null, "geoduck_horse_clam" : null, "other_clam" : null, "barnacles" : null, "notes" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 400000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }