{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "The qry_SampMun SQL view creates an integrated dataset that joins sediment Sample records with their corresponding Munsell color classifications. The resulting dataset returns one record per sample\u2013munsell pairing and includes system\u2011generated ObjectIDs to support Esri feature\u2011service requirements. All munsell color componenet fields in varying conditions (e.g., Munsell Hue Wet, Munsell Chroma Dry, etc.) are surfaced, along with sample identifiers and relevant metadata fields (SampleID, editing timestamps, global sample identifier).\nThis unified table supports MMIS Viewer tools, ArcGIS Experience Builder interactions, and Registered Feature Service publishing workflows by eliminating the need for runtime joins.", "description": "

qry_SampMun is a SQL Server spatial view built by performing an INNER JOIN between the SAMPLE table and the MUNSELL table. The join leverages the shared global table identifiers (Samples_GlobalTableID and Munsell_GlobalTableID). The view generates one row per matching sample\u2013Munsell pair. An Esri\u2011compatible OBJECTID field is created using ROW_NUMBER() to allow the view to be registered with the geodatabase and published as part of an Registered Feature Service.<\/span><\/span><\/p><\/div><\/div><\/div>", "summary": "The qry_SampMun SQL view creates an integrated dataset that joins sediment Sample records with their corresponding Munsell color classifications. The resulting dataset returns one record per sample\u2013munsell pairing and includes system\u2011generated ObjectIDs to support Esri feature\u2011service requirements. All munsell color componenet fields in varying conditions (e.g., Munsell Hue Wet, Munsell Chroma Dry, etc.) are surfaced, along with sample identifiers and relevant metadata fields (SampleID, editing timestamps, global sample identifier).\nThis unified table supports MMIS Viewer tools, ArcGIS Experience Builder interactions, and Registered Feature Service publishing workflows by eliminating the need for runtime joins.", "title": "SampMun", "tags": [ "OCS", "Physical Research", "Wet", "Dry", "Offshore", "Benthic", "Munsell Color System", "Study", "Lightness", "Washed", "Hue", "Chroma", "Sediment Sample", "Sand", "Color", "Marine Minerals" ], "type": "", "typeKeywords": [], "thumbnail": "", "url": "", "minScale": 150000000, "maxScale": 5000, "spatialReference": "", "accessInformation": "", "licenseInfo": "

The Bureau of Ocean Energy Management (BOEM) provides the data for use \"as is\". BOEM provides this information with the understanding that it is not guaranteed to be accurate, correct or complete and conclusions drawn from such information are the responsibility of the user. While every effort has been made to ensure the accuracy, correctness and timeliness of materials presented within the limits of the current state of the art, BOEM assumes no responsibility for errors or omissions, nor as a result of the failure of the data to function on a particular system. BOEM makes no warranty, expressed or implied, nor does the fact of distribution constitute such a warranty. Users are cautioned to consider carefully the provisional nature of these data and information before using them for decisions that concern personal or public safety or the conduct of business that involves substantial monetary or operational consequences. Conclusions drawn from or actions undertaken on the basis of, such data and information are the sole responsibility of the user. The maps shown here are for illustration and planning purposes only and are not suitable for site-specific decision making. The data are not suitable for navigational purposes. Information found here should not be used for making financial or any other commitments. This data was developed by the U.S. Government; no other proprietary rights may be attached to them nor may they be sold to the U.S. Government as part of any procurement of products or services. Public domain data from the U.S. Government are freely redistributable with proper metadata and source attribution. Please recognize the Bureau of Ocean Energy Management (BOEM) as the source of this information.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "portalUrl": "" }