{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1777326644870}, "relationships": [ { "keyField": "regulationid", "role": "esriRelRoleOrigin", "composite": false, "name": "SPORTAL_RegulationDate", "relatedTableId": 2, "id": 1, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "bodyofwaterspatialid", "role": "esriRelRoleDestination", "composite": false, "name": "LocationInfo", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 1, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SPORTAL_Regulations_Salmon", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "statewiderulesapply": null, "baglimit": null, "created": null, "season_id": null, "nomorethaninches": null, "maxsizeininches": null, "nomorethancount": null, "sizeininches": null, "statewide_rules": null, "species": null, "bodyofwaterspatialid": null, "regulationid": null, "name": null, "speciesgroup": null, "name_y": null, "details": null, "name_x": null, "sort_order": null, "gear": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "SPORTAL_Regulations_Salmon", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "bodyofwaterspatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bodyofwaterspatialid", "length": 8000, "alias": "bodyOfWaterSpatialId", "type": "esriFieldTypeString" }, { "modelName": "name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 8000, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "virtual coordinate field", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name_x", "alias": "Name_X", "type": "esriFieldTypeDouble" }, { "modelName": "virtual coordinate field", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name_y", "alias": "Name_Y", "type": "esriFieldTypeDouble" }, { "modelName": "season_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "season_id", "length": 8000, "alias": "Season_Id", "type": "esriFieldTypeString" }, { "modelName": "speciesgroup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "speciesgroup", "length": 8000, "alias": "SpeciesGroup", "type": "esriFieldTypeString" }, { "modelName": "gear", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gear", "length": 8000, "alias": "Gear", "type": "esriFieldTypeString" }, { "modelName": "details", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "details", "length": 8000, "alias": "Details", "type": "esriFieldTypeString" }, { "modelName": "baglimit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "baglimit", "alias": "BagLimit", "type": "esriFieldTypeInteger" }, { "modelName": "sizeininches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sizeininches", "alias": "SizeInInches", "type": "esriFieldTypeInteger" }, { "modelName": "maxsizeininches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maxsizeininches", "alias": "MaxSizeInInches", "type": "esriFieldTypeInteger" }, { "modelName": "statewiderulesapply", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statewiderulesapply", "length": 8000, "alias": "StatewideRulesApply", "type": "esriFieldTypeString" }, { "modelName": "nomorethancount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nomorethancount", "alias": "NoMoreThanCount", "type": "esriFieldTypeInteger" }, { "modelName": "nomorethaninches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nomorethaninches", "alias": "NoMoreThanInches", "type": "esriFieldTypeInteger" }, { "modelName": "sort_order", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sort_order", "alias": "sort_order", "type": "esriFieldTypeInteger" }, { "modelName": "created", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created", "length": 8000, "alias": "created", "type": "esriFieldTypeString" }, { "modelName": "species", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "species", "length": 8000, "alias": "species", "type": "esriFieldTypeString" }, { "modelName": "statewide_rules", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statewide_rules", "length": 8000, "alias": "statewide_rules", "type": "esriFieldTypeString" }, { "modelName": "regulationid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "regulationid", "length": 255, "alias": "regulationID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g388bodyofwaters", "isUnique": false, "description": "", "fields": "bodyofwaterspatialid", "isAscending": true }, { "name": "g388regulationid", "isUnique": false, "description": "", "fields": "regulationid", "isAscending": true }, { "name": "r287_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4130155dacff4a1e9560333461a15d46", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1777326645238}, "relationships": [ { "keyField": "regulationid", "role": "esriRelRoleDestination", "composite": false, "name": "SPORTAL_Regulations_Salmon", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 2, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SPORTAL_RegulationDate", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "end_date_text": null, "regulationid": null, "created_at": null, "season_id": null, "effective_date_range_id": null, "start_date_text": null, "until_further_notice": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "SPORTAL_RegulationDate", "displayField": "effective_date_range_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "effective_date_range_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "effective_date_range_id", "length": 8000, "alias": "effective_date_range_id", "type": "esriFieldTypeString" }, { "modelName": "regulationid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "regulationid", "length": 8000, "alias": "regulation_id", "type": "esriFieldTypeString" }, { "modelName": "season_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "season_id", "length": 8000, "alias": "season_id", "type": "esriFieldTypeString" }, { "modelName": "start_date_text", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date_text", "length": 8000, "alias": "start_date_text", "type": "esriFieldTypeString" }, { "modelName": "end_date_text", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "end_date_text", "length": 8000, "alias": "end_date_text", "type": "esriFieldTypeString" }, { "modelName": "created_at", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "created_at", "length": 29, "alias": "created_at", "type": "esriFieldTypeDate" }, { "modelName": "until_further_notice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "until_further_notice", "length": 8000, "alias": "until_further_notice", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "i389regulationid", "isUnique": false, "description": "", "fields": "regulationid", "isAscending": true }, { "name": "r288_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4130155dacff4a1e9560333461a15d46", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1777326645612}, "relationships": [ { "keyField": "bodyofwaterspatialid", "role": "esriRelRoleOrigin", "composite": false, "name": "Regulations_Salmon", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToOne" }, { "keyField": "segmentid", "role": "esriRelRoleDestination", "composite": false, "name": "MarineAreaPolygonSegments", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 3, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SPORTAL_LocationInfo", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "applicationarea_id": null, "areatitle": null, "description": null, "stateprovince_id": null, "fisheryarea_id": null, "fisherysubarea_id": null, "ruleareaname": null, "locationinfo_id": null, "fisheryselectsubarea_id": null, "waters_id": null, "bodyofwaterspatialid": null, "segmentid": null, "name": null, "fisheryregion_id": null, "parentlocation": null, "country_id": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "SPORTAL_LocationInfo", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "segmentid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "segmentid", "length": 255, "alias": "SegmentID", "type": "esriFieldTypeString" }, { "modelName": "locationinfo_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "locationinfo_id", "alias": "LocationInfo_ID", "type": "esriFieldTypeInteger" }, { "modelName": "country_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "country_id", "length": 255, "alias": "Country_ID", "type": "esriFieldTypeString" }, { "modelName": "stateprovince_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stateprovince_id", "length": 255, "alias": "StateProvince_ID", "type": "esriFieldTypeString" }, { "modelName": "fisheryregion_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fisheryregion_id", "length": 255, "alias": "FisheryRegion_ID", "type": "esriFieldTypeString" }, { "modelName": "fisheryarea_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fisheryarea_id", "length": 255, "alias": "FisheryArea_ID", "type": "esriFieldTypeString" }, { "modelName": "fisherysubarea_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fisherysubarea_id", "length": 255, "alias": "FisherySubarea_ID", "type": "esriFieldTypeString" }, { "modelName": "fisheryselectsubarea_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fisheryselectsubarea_id", "length": 1000, "alias": "FisherySelectSubarea_ID", "type": "esriFieldTypeString" }, { "modelName": "parentlocation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentlocation", "alias": "ParentLocation", "type": "esriFieldTypeInteger" }, { "modelName": "applicationarea_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationarea_id", "length": 255, "alias": "ApplicationArea_ID", "type": "esriFieldTypeString" }, { "modelName": "waters_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waters_id", "length": 255, "alias": "Waters_ID", "type": "esriFieldTypeString" }, { "modelName": "AreaName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 50, "alias": "Area Name", "type": "esriFieldTypeString" }, { "modelName": "AreaTitle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "areatitle", "length": 50, "alias": "Area Title", "type": "esriFieldTypeString" }, { "modelName": "RuleAreaName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ruleareaname", "length": 100, "alias": "Rule Area Name", "type": "esriFieldTypeString" }, { "modelName": "RuleAreaDescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 1000, "alias": "Rule Area Description", "type": "esriFieldTypeString" }, { "modelName": "bodyofwaterspatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bodyofwaterspatialid", "length": 108, "alias": "Body of Water Spatial ID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "Global ID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g390bodyofwaters", "isUnique": false, "description": "", "fields": "bodyofwaterspatialid", "isAscending": true }, { "name": "g390segmentid", "isUnique": false, "description": "", "fields": "segmentid", "isAscending": true }, { "name": "r289_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_289", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4130155dacff4a1e9560333461a15d46", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 5820473.532200001, "xmin": -1.43746140996E7, "ymax": 6275230.192100003, "xmax": -1.36011125321E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1777326644313}, "relationships": [ { "keyField": "spatial_id", "role": "esriRelRoleOrigin", "composite": false, "name": "LocationInfo", "relatedTableId": 3, "id": 0, "cardinality": "esriRelCardinalityOneToOne" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 0, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "MarineAreaPolygonSegments", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "bodyofwaterspatialid": null, "name": null, "areatitle": null, "description": null, "ruleareaname": null, "spatial_id": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "MarineAreaPolygonSegments", "allowTrueCurvesUpdates": false, "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "AreaName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 50, "alias": "Area Name", "type": "esriFieldTypeString" }, { "modelName": "AreaTitle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "areatitle", "length": 50, "alias": "Area Title", "type": "esriFieldTypeString" }, { "modelName": "RuleAreaName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ruleareaname", "length": 100, "alias": "Rule Area Name", "type": "esriFieldTypeString" }, { "modelName": "RuleAreaDescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 1000, "alias": "Rule Area Description", "type": "esriFieldTypeString" }, { "modelName": "bodyofwaterspatialid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bodyofwaterspatialid", "length": 108, "alias": "Body of Water Spatial ID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "Global ID" }, { "modelName": "spatial_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatial_id", "length": 255, "alias": "Spatial_ID", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"WGS_1984_Web_Mercator_Auxiliary_Sphere\",GEOGCS[\"GCS_WGS_1984\",DATUM[\"D_WGS_1984\",SPHEROID[\"WGS_1984\",6378137.0,298.257223563]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Mercator_Auxiliary_Sphere\"],PARAMETER[\"False_Easting\",0.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",0.0],PARAMETER[\"Standard_Parallel_1\",0.0],PARAMETER[\"Auxiliary_Sphere_Type\",0.0],UNIT[\"Meter\",1.0]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3857, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "description": "Provides a geographic definition of Washington Department of Fish and Wildlife's catch reporing areas for various recreational marine finfish and shellfish fisheries.http://apps.leg.wa.gov/WAC/default.aspx?cite=220-56-185WAC 220-56-185Marine area codesThe term \"marine area code numbers\" is defined as the catch area for the catch record card. The following is a list of the catch areas:(1) Area 1 (Ilwaco): Waters west of the Buoy 10 Line and north to Leadbetter Point.???? - The Buoy 10 Line is defined in WAC 220-56-100, section 7 as \"... a true north-south line projected through Buoy 10 at the mouth of the Columbia River\" and should be referenced or defined in this WAC.(2)(a) Area 2 (Westport-Ocean Shores): From Leadbetter Point north to the Queets River. Area 2 excludes waters of Willapa Bay and Grays Harbor.(b) Area 2-1: Willapa Bay east of a line from Leadbetter Point to Willapa Channel Marker 8 (Buoy 8) then to the westerly most landfall on Cape Shoalwater.(c) Area 2-2: Grays Harbor east of a line from the outermost end of the north jetty to the outermost exposed end of the south jetty.(3) Area 3 (La Push): From the Queets River north to Cape Alava.(4) Area 4 (Neah Bay): From Cape Alava north and inside Juan de Fuca Strait to the Sekiu River.(5) Area 5 (Sekiu and Pillar Point): From mouth of Sekiu River east to Low Point, mouth of the Lyre River.(6) Area 6 (East Juan de Fuca Strait): From Low Point east to the Partridge Point-Point Wilson line north to the line from Trial Island (near Victoria, B.C.) - Rosario Strait Traffic Lane Entrance Lighted Buoy R (USCG Light List No. 16340, referenced as Y \"R\" on National Ocean Service Chart No. 18400-1 dated 1997-08-30 - Smith Island - the most northeasterly of the Lawson Reef lighted buoys (RB1 QK Fl Bell) - Northwest Island - the Initiative 77 marker on Fidalgo Island.(7) Area 7 (San Juan Islands): All marine waters north of the line described under Area 6 to the United States-Canadian boundary.???? - And north of the Burlington Northern Railroad Bridge at the north end of Swinomish Slough.(8)(a) Area 8 (Deception Pass, Hope and Camano Islands): Line projected from West Point on Whidbey Island to Reservation Head on Fidalgo Island east through Deception Pass, including all waters east of Whidbey Island to the Possession Point - Shipwreck Line.(b) Area 8-1 (Deception Pass and Hope Island): East of a line projected from West Point on Whidbey Island to Reservation Head on Fidalgo Island, south of the Burlington Northern Railroad Bridge at the north end of Swinomish Slough, north of the Highway 532 Bridge between Camano Island and the mainland, and westerly of a line from the East Point Light on Whidbey Island to the Saratoga Pass Light #4 on Camano Island (Fl red 4 sec.).(c) Area 8-2 (Port Susan and Port Gardner): East of a line from the East Point Light on Whidbey Island to the Saratoga Pass Light #2 on Camano Island (Fl red 4 sec.) and north of a line from the south tip of Possession Point 110 degrees true to a shipwreck on the opposite shore.???? - The Saratoga Pass Light is #4 (also mentioned in \"b\", 8-1), not 2.(9) Area 9 (Admiralty Inlet): All waters inside and south of the Partridge Point-Point Wilson Line and a line projected from the southerly tip of Possession Point 110 degrees true to a shipwreck on the opposite shore and northerly of the Hood Canal Bridge and the Apple Cove Point-Edwards Point Line.(10) Area 10 (Seattle-Bremerton): From the Apple Cove Point-Edwards Point Line to a line projected true east-west through the northern tip of Vashon Island.(11) Area 11 (Tacoma-Vashon Island): From the northern tip of Vashon Island to the Tacoma Narrows Bridge.(12) Area 12 (Hood Canal): All contiguous waters south of the Hood Canal Bridge and adjacent waters north of the Hood Canal Bridge when fishing from the pontoon beneath the bridge.(13) Area 13 (South Puget Sound): All contiguous waters south of the Tacoma Narrows Bridge.[Statutory Authority: RCW 75.08.080, 77.12.040. 00-08-038 (Order 00-29), § 220-56-185, filed 3/29/00, effective 5/1/00; 99-15-081 (Order 99-102), § 220-56-185, filed 7/20/99, effective 8/20/99; 99-08-029 (Order 99-13), § 220-56-185, filed 3/30/99, effective 5/1/99. Statutory Authority: RCW 75.08.080. 95-04-066 (Order 95-10), § 220-56-185, filed 1/30/95, effective 5/1/95; 91-08-054 (Order 91-13), § 220-56-185, filed 4/2/91, effective 5/3/91; 89-07-060 (Order 89-12), § 220-56-185, filed 3/16/89; 88-10-013 (Order 88-15), § 220-56-185, filed 4/26/88; 85-18-026 (Order 85-111), § 220-56-185, filed 5/27/85; 85-09-017 (Order 85-20), § 220-56-185, filed 4/9/85; 80-03-064 (Order 80-12), § 220-56-185, filed 2/27/80, effective 4/1/80.]", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g387spatial_id", "isUnique": false, "description": "", "fields": "spatial_id", "isAscending": true }, { "name": "i387bodyofwaters", "isUnique": false, "description": "", "fields": "bodyofwaterspatialid", "isAscending": true }, { "name": "r286_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_286", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a168_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4130155dacff4a1e9560333461a15d46", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 112, 255, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 201, 241, 252, 0 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "shape", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }