{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "Munsell", "type": "Table", "description": "The Munsell table is a collection of datasets summarizing sediment colors using the Munsell color system, which is based on three color dimensions: hue, value (lightness), and chroma (color purity). The Munsell color of sediment is one of several factors used in the determination of sediment resource compatibility for renourishment of beaches and coastal habitat. The Munsell color data gathered into this MMIS table were acquired from multiple investigators and projects, whose research on or around the Outer Continental Shelf (OCS) was funded fully or partially by the Bureau of Ocean Energy Management (BOEM) or partner/stakeholder agencies. Attribution consists of sediment hue, value, and chroma for dry, washed and wet samples. The Munsell table is linked to the Samples table, which is subsequently linked to both the Grab Samples feature class and the Core Samples feature class. Updates to this dataset will occur regularly as new and existing reports and data are incorporated into the MMIS geodatabase.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "composite": false, "catalogID": "{D8CAF564-0FA1-4A29-AC3F-410B6D714CC1}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MunsellHueWet", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "Munsell Hue Wet", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Wet" }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "Munsell Value Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Wet" }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Wet" }, { "name": "MunsellHueWashed", "type": "esriFieldTypeString", "alias": "Munsell Hue Washed", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Washed" }, { "name": "MunsellValueWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Value Washed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Washed" }, { "name": "MunsellChromaWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Washed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Washed" }, { "name": "MunsellHueDry", "type": "esriFieldTypeString", "alias": "Munsell Hue Dry", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Dry" }, { "name": "MunsellValueDry", "type": "esriFieldTypeDouble", "alias": "Munsell Value Dry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Dry" }, { "name": "MunsellChromaDry", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Dry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Dry" }, { "name": "MunsellHueUnknown", "type": "esriFieldTypeString", "alias": "Munsell Hue Unknown", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Unknown" }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Value Unknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueUnknown" }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Unknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Unknown" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Munsell_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Munsell_GlobalTableID" } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G40Munsell_Globa", "isAscending": true, "isUnique": false, "description": "", "fields": "Munsell_GlobalTableID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Munsell", "description": "", "prototype": { "attributes": { "last_edited_date": null, "Munsell_GlobalTableID": null, "StudyID": null, "SampleID": null, "MunsellHueWet": null, "MunsellValueWet": null, "MunsellChromaWet": null, "MunsellHueWashed": null, "MunsellValueWashed": null, "MunsellChromaWashed": null, "MunsellHueDry": null, "MunsellValueDry": null, "MunsellChromaDry": null, "MunsellHueUnknown": null, "MunsellValueUnknown": null, "MunsellChromaUnknown": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }