{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "(GeoType NOT IN ('port complex', 'inshore floating processor', 'seaplane base') And GeoID NOT IN (9100)) Or GeoID IN (6040)", "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "hasViews": true, "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 20, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Ports and Communities table", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "portcode_norpac": null, "portcode_pacfin_group": null, "geotype": null, "port_name_pacfin": null, "latitude": null, "jurisdiction": null, "portcode_akfin": null, "photo_desc": null, "link_port": null, "name_alt": null, "estuary_name": null, "link_wikipedia": null, "photo_source": null, "label_class": null, "port_use_level": null, "cd_id": null, "portcode_pacfin": null, "community_key": null, "longitude": null, "portcode_cdfw": null, "portcode_calcom": null, "census_designation": null, "portcode_pacfin_alt": null, "portcode_acepo": null, "comm_key_old": null, "iopac_port_group": null, "link_photo": null, "native_name": null, "population": null, "portcommunity_group": null, "geoid": null, "communitygeoid": null, "name": null, "pmep_estuaryid": null, "waterbody": null, "portcode_recfin": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Ports and Communities table", "displayField": "name", "supportsCalculate": true, "fields": [ { "modelName": "name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 255, "alias": "name", "type": "esriFieldTypeString" }, { "modelName": "geoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geoid", "alias": "GeoID", "type": "esriFieldTypeSmallInteger" }, { "modelName": "jurisdiction", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Jurisdiction", "description": "Jurisdiction", "type": "codedValue", "codedValues": [ { "code": "Alaska", "name": "Alaska" }, { "code": "British Columbia", "name": "British Columbia" }, { "code": "Washington", "name": "Washington" }, { "code": "Oregon", "name": "Oregon" }, { "code": "California", "name": "California" }, { "code": "Idaho", "name": "Idaho" }, { "code": "Hawaii", "name": "Hawaii" }, { "code": "Marshall Islands", "name": "Marshall Islands" }, { "code": "Kiribati", "name": "Kiribati" }, { "code": "Samoa", "name": "Samoa" }, { "code": "American Samoa", "name": "American Samoa" }, { "code": "Fiji", "name": "Fiji" }, { "code": "French Polynesia", "name": "French Polynesia" }, { "code": "New Zealand", "name": "New Zealand" }, { "code": "Mexico", "name": "Mexico" }, { "code": "Guam", "name": "Guam" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "jurisdiction", "length": 100, "alias": "jurisdiction", "type": "esriFieldTypeString" }, { "modelName": "geotype", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "GeoType", "description": "Type of geographic feature", "type": "codedValue", "codedValues": [ { "code": "community", "name": "community" }, { "code": "former community", "name": "former community" }, { "code": "inshore floating processor", "name": "inshore floating processor" }, { "code": "landmark", "name": "landmark" }, { "code": "military base/station", "name": "military base/station" }, { "code": "neighborhood", "name": "neighborhood" }, { "code": "port and community", "name": "port and community" }, { "code": "port and neighborhood", "name": "port and neighborhood" }, { "code": "port complex", "name": "port complex" }, { "code": "port or processing facility", "name": "port or processing facility" }, { "code": "seaplane base", "name": "seaplane base" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "geotype", "length": 255, "alias": "geotype", "type": "esriFieldTypeString" }, { "modelName": "portcommunity_group", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PortCommunity_Group", "description": "Grouping of community and ports.", "type": "codedValue", "codedValues": [ { "code": 1, "name": "North Slope Drainages" }, { "code": 2, "name": "Northwest Drainages" }, { "code": 3, "name": "Yukon River Drainages" }, { "code": 4, "name": "Tanana River Drainage" }, { "code": 5, "name": "Kuskokwim-Goodnews Drainages" }, { "code": 6, "name": "Bristol Bay Drainages" }, { "code": 7, "name": "Alaska Peninsula" }, { "code": 8, "name": "Kodiak Island" }, { "code": 9, "name": "Western Cook Inlet" }, { "code": 10, "name": "Susitna River" }, { "code": 11, "name": "Knik Arm" }, { "code": 12, "name": "Anchorage Bowl" }, { "code": 13, "name": "Kenai Peninsula" }, { "code": 14, "name": "North Gulf Coast" }, { "code": 15, "name": "Prince William Sound" }, { "code": 16, "name": "Upper Copper-Upper Susitna Drainages" }, { "code": 17, "name": "Yakutat Area" }, { "code": 18, "name": "Juneau-Glacier Bay Area" }, { "code": 19, "name": "Haines-Skagway Area" }, { "code": 20, "name": "Sitka Area" }, { "code": 21, "name": "Petersburg-Wrangell Area" }, { "code": 22, "name": "Prince of Wales Island Area" }, { "code": 23, "name": "Ketchikan Area" }, { "code": 24, "name": "Northern British Columbia" }, { "code": 25, "name": "Cariboo, Chilcotin, Coast" }, { "code": 26, "name": "Vancouver Island and BC Islands" }, { "code": 27, "name": "Vancouver Coast and Mountains" }, { "code": 28, "name": "Northern Puget Sound" }, { "code": 29, "name": "Central Puget Sound" }, { "code": 30, "name": "South Puget Sound" }, { "code": 31, "name": "Hood Canal" }, { "code": 32, "name": "Strait of Juan de Fuca" }, { "code": 33, "name": "Coastal Washington" }, { "code": 34, "name": "Southwest Washington" }, { "code": 35, "name": "South Central Washington" }, { "code": 36, "name": "North Central Washington" }, { "code": 37, "name": "Eastern Washington" }, { "code": 38, "name": "Northeast Oregon" }, { "code": 39, "name": "Southeast Oregon" }, { "code": 40, "name": "Central Oregon" }, { "code": 41, "name": "Willamette" }, { "code": 42, "name": "Northwest Oregon" }, { "code": 43, "name": "Southwest Oregon" }, { "code": 44, "name": "North California Coast" }, { "code": 45, "name": "Shasta Cascade" }, { "code": 46, "name": "San Francisco Bay" }, { "code": 47, "name": "Central Valley" }, { "code": 48, "name": "Gold Country" }, { "code": 49, "name": "High Sierra" }, { "code": 50, "name": "Central Coast" }, { "code": 51, "name": "Los Angeles County" }, { "code": 52, "name": "Orange County" }, { "code": 53, "name": "Inland Empire" }, { "code": 54, "name": "San Diego County" }, { "code": 55, "name": "Deserts" }, { "code": 56, "name": "Panhandle Idaho" }, { "code": 57, "name": "Clearwater" }, { "code": 58, "name": "Southwest Idaho" }, { "code": 59, "name": "Magic Valley" }, { "code": 60, "name": "Southeast Idaho" }, { "code": 61, "name": "Upper Snake" }, { "code": 62, "name": "Salmon" }, { "code": 63, "name": "Hawaii" }, { "code": 64, "name": "U.S. Pacific Territories" }, { "code": 65, "name": "Pacific Ocean non-U.S." }, { "code": 66, "name": "Mexico" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "portcommunity_group", "alias": "port/community group", "type": "esriFieldTypeSmallInteger" }, { "modelName": "native_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "native_name", "length": 255, "alias": "Native name", "type": "esriFieldTypeString" }, { "modelName": "name_alt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name_alt", "length": 255, "alias": "alt. name", "type": "esriFieldTypeString" }, { "modelName": "portcode_acepo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_acepo", "length": 255, "alias": "Port Code - ACEPO", "type": "esriFieldTypeString" }, { "modelName": "portcode_akfin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_akfin", "length": 255, "alias": "Port Code - AKFIN", "type": "esriFieldTypeString" }, { "modelName": "community_key", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "community_key", "alias": "Community Key", "type": "esriFieldTypeSmallInteger" }, { "modelName": "comm_key_old", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comm_key_old", "alias": "Community Key (alt)", "type": "esriFieldTypeInteger" }, { "modelName": "portcode_norpac", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_norpac", "alias": "Port Code - NORPAC", "type": "esriFieldTypeSmallInteger" }, { "modelName": "iopac_port_group", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PortGroup_IOPAC", "description": "IOPAC Port Groups", "type": "codedValue", "codedValues": [ { "code": "Astoria", "name": "Astoria" }, { "code": "Bodega Bay", "name": "Bodega Bay" }, { "code": "Brookings", "name": "Brookings" }, { "code": "Coos Bay", "name": "Coos Bay" }, { "code": "Crescent City", "name": "Crescent City" }, { "code": "Eureka", "name": "Eureka" }, { "code": "Fort Bragg", "name": "Fort Bragg" }, { "code": "Los Angeles", "name": "Los Angeles" }, { "code": "Monterey", "name": "Monterey" }, { "code": "Morro Bay", "name": "Morro Bay" }, { "code": "Newport", "name": "Newport" }, { "code": "North WA Coast", "name": "North WA Coast" }, { "code": "Puget Sound", "name": "Puget Sound" }, { "code": "San Diego", "name": "San Diego" }, { "code": "San Francisco", "name": "San Francisco" }, { "code": "Santa Barbara", "name": "Santa Barbara" }, { "code": "South and Central WA Coast", "name": "South and Central WA Coast" }, { "code": "Tillamook", "name": "Tillamook" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "iopac_port_group", "length": 150, "alias": "Port Group - IOPAC", "type": "esriFieldTypeString" }, { "modelName": "port_name_pacfin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "port_name_pacfin", "length": 255, "alias": "Port Name - PacFIN", "type": "esriFieldTypeString" }, { "modelName": "portcode_pacfin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_pacfin", "length": 10, "alias": "Port Code - PacFIN", "type": "esriFieldTypeString" }, { "modelName": "portcode_pacfin_alt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_pacfin_alt", "length": 255, "alias": "Agency Code - PacFIN", "type": "esriFieldTypeString" }, { "modelName": "portcode_pacfin_group", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_pacfin_group", "length": 10, "alias": "Port Group Code - PacFIN", "type": "esriFieldTypeString" }, { "modelName": "portcode_recfin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_recfin", "alias": "Port Code - RecFIN", "type": "esriFieldTypeSmallInteger" }, { "modelName": "portcode_cdfw", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_cdfw", "alias": "Port Code - CDFW", "type": "esriFieldTypeSmallInteger" }, { "modelName": "portcode_calcom", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portcode_calcom", "length": 10, "alias": "Port Code - CALCOM", "type": "esriFieldTypeString" }, { "modelName": "census_designation", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Census_Designation", "description": "U.S. Census Designation", "type": "codedValue", "codedValues": [ { "code": "incorporated community", "name": "incorporated community (city/town)" }, { "code": "Census-designated place", "name": "Census-designated place (CDP)" }, { "code": "unincorporated community", "name": "unincorporated community" }, { "code": "N/A", "name": "not applicable" }, { "code": "former Census-designated place (CDP)", "name": "former CDP" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "census_designation", "length": 255, "alias": "census type", "type": "esriFieldTypeString" }, { "modelName": "population", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "population", "alias": "population (2020)", "type": "esriFieldTypeInteger" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "port_use_level", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Port_UseLevel_43", "description": "Level of use of port by the fisheries community, according to available data (in the past ~5 years)", "type": "codedValue", "codedValues": [ { "code": 1, "name": "fishery port - major" }, { "code": 2, "name": "fishery port - moderate use" }, { "code": 3, "name": "fishery port - minor" }, { "code": 4, "name": "port - low or infrequent fishery activity" }, { "code": 5, "name": "fishery use unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "port_use_level", "alias": "port use level", "type": "esriFieldTypeSmallInteger" }, { "modelName": "waterbody", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterbody", "length": 255, "alias": "waterbody", "type": "esriFieldTypeString" }, { "modelName": "Estuary_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estuary_name", "length": 120, "alias": "estuary name", "type": "esriFieldTypeString" }, { "modelName": "pmep_estuaryid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmep_estuaryid", "alias": "PMEP Estuary ID", "type": "esriFieldTypeSmallInteger" }, { "modelName": "link_wikipedia", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "link_wikipedia", "length": 255, "alias": "Wikipedia link", "type": "esriFieldTypeString" }, { "modelName": "link_port", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "link_port", "length": 255, "alias": "port link", "type": "esriFieldTypeString" }, { "modelName": "link_photo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "link_photo", "length": 255, "alias": "photo link", "type": "esriFieldTypeString" }, { "modelName": "photo_source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_source", "length": 255, "alias": "photo source", "type": "esriFieldTypeString" }, { "modelName": "photo_desc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "photo_desc", "length": 255, "alias": "photo description", "type": "esriFieldTypeString" }, { "modelName": "label_class", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Label_Class", "description": "numeric field to indicate labeling preference or scale", "type": "codedValue", "codedValues": [ { "code": 1, "name": "major" }, { "code": 2, "name": "large" }, { "code": 3, "name": "medium-large" }, { "code": 4, "name": "medium" }, { "code": 5, "name": "medium-low" }, { "code": 6, "name": "low" }, { "code": 7, "name": "lowest" }, { "code": 8, "name": "other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "label_class", "alias": "label class", "type": "esriFieldTypeSmallInteger" }, { "modelName": "communitygeoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "communitygeoid", "alias": "GeoID (community)", "type": "esriFieldTypeSmallInteger" }, { "modelName": "cd_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cd_id", "length": 4, "alias": "congressional dist.", "type": "esriFieldTypeString" }, { "modelName": "latitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "latitude", "type": "esriFieldTypeDouble" }, { "modelName": "longitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "longitude", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "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": "i3906census_desi", "isUnique": false, "description": "", "fields": "census_designation", "isAscending": true }, { "name": "i3906geoid", "isUnique": false, "description": "", "fields": "geoid", "isAscending": true }, { "name": "i3906geotype", "isUnique": false, "description": "", "fields": "geotype", "isAscending": true }, { "name": "i3906jurisdictio", "isUnique": false, "description": "", "fields": "jurisdiction", "isAscending": true }, { "name": "i3906label_class", "isUnique": false, "description": "", "fields": "label_class", "isAscending": true }, { "name": "i3906link_port", "isUnique": false, "description": "", "fields": "link_port", "isAscending": true }, { "name": "i3906link_wikipe", "isUnique": false, "description": "", "fields": "link_wikipedia", "isAscending": true }, { "name": "i3906name", "isUnique": false, "description": "", "fields": "name", "isAscending": true }, { "name": "i3906name_alt", "isUnique": false, "description": "", "fields": "name_alt", "isAscending": true }, { "name": "i3906port_use_le", "isUnique": false, "description": "", "fields": "port_use_level", "isAscending": true }, { "name": "i3906portcommuni", "isUnique": false, "description": "", "fields": "portcommunity_group", "isAscending": true }, { "name": "r1259_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "3ad0ea3a5b5349269bc9db53d2ac32e8", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }