| snippet:
|
The qry_SampPhi SQL view integrates sediment Sample records with their associated Phi grain-size distribution values. The resulting dataset returns one record per sample–phi pairing and includes system‑generated ObjectIDs to support Esri feature‑service requirements. All PHI grain‑size increment fields (e.g., PHI_N_10Less through PHI_N_03_25) are surfaced, along with sample identifiers and relevant metadata fields (SampleID, editing timestamps, global sample identifier).
This unified table supports MMIS Viewer tools, ArcGIS Experience Builder interactions, and Registered Feature Service publishing workflows by eliminating the need for runtime joins. |
| summary:
|
The qry_SampPhi SQL view integrates sediment Sample records with their associated Phi grain-size distribution values. The resulting dataset returns one record per sample–phi pairing and includes system‑generated ObjectIDs to support Esri feature‑service requirements. All PHI grain‑size increment fields (e.g., PHI_N_10Less through PHI_N_03_25) are surfaced, along with sample identifiers and relevant metadata fields (SampleID, editing timestamps, global sample identifier).
This unified table supports MMIS Viewer tools, ArcGIS Experience Builder interactions, and Registered Feature Service publishing workflows by eliminating the need for runtime joins. |
| accessInformation:
|
|
| thumbnail:
|
|
| maxScale:
|
5000 |
| typeKeywords:
|
[] |
| description:
|
<div style="text-align:Left;"><div><div><div style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);color:rgb(0, 0, 0);font-family:Calibri;font-size:14.6667px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;orphans:2;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-wrap;widows:2;word-spacing:0px;">qry_SampPhi is a SQL Server spatial view that performs an INNER JOIN between the SAMPLE table and the PHI table.</div><div style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);color:rgb(0, 0, 0);font-family:Calibri;font-size:14.6667px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;orphans:2;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-wrap;widows:2;word-spacing:0px;">The join leverages the shared global table identifiers (Samples_GlobalTableID and Phi_GlobalTableID). The view generates one row per matching sample–phi pair. An Esri‑compatible 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.</div></div></div></div> |
| licenseInfo:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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> |
| catalogPath:
|
|
| title:
|
SampPhi |
| type:
|
|
| url:
|
|
| tags:
|
["Mesh","Study","Offshore","Grain Size","OCS","Physical Research","Benthic","Sieve","Sediment Sample","Sand","Phi","Marine Minerals"] |
| culture:
|
en-US |
| portalUrl:
|
|
| name:
|
|
| guid:
|
|
| minScale:
|
150000000 |
| spatialReference:
|
|