20260506 15531200 1.0 NAP 002 qry_SampPhi 150000000 5000 20260625 15484400 FALSE 20260625 15484400 <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> SampPhi 2024-10-01T00:00:00 tabular digital data U.S. Department of Interior, Bureau of Ocean Energy Management, Marine Minerals Program marineminerals@boem.gov 45600 Woodland Road, VAM-LD Sterling VA 20166 US http://www.boem.gov/Marine-Minerals-Program HyperText Protocol web browser BOEM MMIS website Monday through Friday 8:00 AM to 5:00 PM (Eastern Time) U.S. Department of Interior, Bureau of Ocean Energy Management, Marine Minerals Program publication date 2021-07-23T00:00:00 2024-10-01T00:00:00 Oceanographer U.S. Department of Interior, Bureau of Ocean Energy Management, Marine Minerals Program marineminerals@boem.gov 45600 Woodland Road, VAM-LD Sterling VA 20166 US 703-787-1747 http://www.boem.gov/Marine-Minerals-Program HyperText Protocol web browser BOEM MMIS website http://www.boem.gov/Marine-Minerals-Program U.S. Department of Interior, Bureau of Ocean Energy Management, Marine Minerals Program Mesh Study Offshore Grain Size OCS Physical Research Benthic Sieve Sediment Sample Sand Phi Marine Minerals 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. This data is in the public domain and has no access restrictions. FIPS 199 Security Classification There are no restrictions; the data is releasable to the public. <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> Esri ArcPro None U.S. Department of Commerce, 1995, Countries, dependencies, areas of special sovereignty, and their principal administrative divisions, Federal Information Processing Standard (FIPS) 10-4): Washington, D.C., National Institute of Standards and Technology. 1995-01-01T00:00:00 US NASA/GCMD Location Keywords 2021-01-26T00:00:00 ATLANTIC OCEAN GULF OF MEXICO SEA FLOOR GLOBAL OCEAN Outer Continental Shelf dataset 86C8F281-4E1E-459A-AAC8-213A27924595 20241001 Oceanographer U.S. Department of Interior, Bureau of Ocean Energy Management, Marine Minerals Program marineminerals@boem.gov 45600 Woodland Road, VAM-LD Sterling VA 20166 US 703-787-1747 http://www.boem.gov/Marine-Minerals-Program HyperText Protocol web browser BOEM MMIS website http://www.boem.gov/Marine-Minerals-Program MMIS.Phi and MMIS.Samples This dataset is a dynamic SQL qry of the MMIS.Phi and MMIS.Sample tables. These data do not undergo any processing. The MMIS data model utilizes a hierarchical structure where an ESRI enterprise geodatabase represents the top tier, and feature datasets and raster catalogs are the secondary tiers which contain groupings of similar data layers. These individual data layers were identified by MMP as important, and they make up the bottom tier. Most individual vector layers and tables are collections of data from multiple sources and across multiple dates. Extensive research went into the construction of (1) the hierarchical groupings of data (primarily by subject matter and file format) and (2) technical aspects of the data model. Data within the geodatabase was consolidated to reduce redundancy, resulting in several stand-alone tables. Relationship classes utilizing global IDs were built between vector layers and stand-alone tables in order to link disparate data. The entire MMIS data model was originally constructed using ESRI ArcGIS Diagrammer, a tool that creates and edits a geodatabase schema. The resulting geodatabase structure, data, and relationship classes were reviewed thoroughly by multiple individuals using ESRI Geodatabase Diagrammer Add-In, ESRI ArcGIS, and Microsoft Visio. ESRI Geodatabase Diagrammer Add-In creates a detailed break-down of the geodatabase and a Visio data model poster. Conceptual consistency: adherence to rules of the conceptual schema The MMIS data model utilizes a hierarchical structure where an ESRI enterprise geodatabase represents the top tier, and feature datasets and raster catalogs are the secondary tiers which contain groupings of similar data layers. These individual data layers were identified by MMP as important, and they make up the bottom tier. Most individual vector layers and tables are collections of data from multiple sources and across multiple dates. Extensive research went into the construction of (1) the hierarchical groupings of data (primarily by subject matter and file format) and (2) technical aspects of the data model. Data within the geodatabase was consolidated to reduce redundancy, resulting in several stand-alone tables. Relationship classes utilizing global IDs were built between vector layers and stand-alone tables in order to link disparate data. The entire MMIS data model was originally constructed using ESRI ArcGIS Diagrammer, a tool that creates and edits a geodatabase schema. The resulting geodatabase structure, data, and relationship classes were reviewed thoroughly by multiple individuals using ESRI Geodatabase Diagrammer Add-In, ESRI ArcGIS, and Microsoft Visio. ESRI Geodatabase Diagrammer Add-In creates a detailed break-down of the geodatabase and a Visio data model poster. The spatial data and attribute tables loaded into the MMIS data model are believed to be complete, in regards to maintaining each data layer/table after retrieving it from its source. Please refer to the scientific reports, as well as BOEM MMP Leases, negotiated agreements, Memoranda of Agreements, and project completion reports, for discussions of the results on the corresponding source data. Most individual vector layers and tables in the MMIS data model are collections of data from multiple sources and across multiple dates. Most likely, these MMIS layers/tables will continue to have more data loaded in the future, therefore expanding upon the list of sources and dates. Additionally, the Pacific Outer Continental Shelf (OCS) and Alaska OCS regions may eventually be added to the data model, aside from the Atlantic and Gulf of Mexico OCS regions. Completeness omission: data absent from the dataset, as described by the scope The spatial data and attribute tables loaded into the MMIS data model are believed to be complete, in regards to maintaining each data layer/table after retrieving it from its source. Please refer to the scientific reports, as well as BOEM MMP Leases, negotiated agreements, Memoranda of Agreements, and project completion reports, for discussions of the results on the corresponding source data. Most individual vector layers and tables in the MMIS data model are collections of data from multiple sources and across multiple dates. Most likely, these MMIS layers/tables will continue to have more data loaded in the future, therefore expanding upon the list of sources and dates. Additionally, the Pacific Outer Continental Shelf (OCS) and Alaska OCS regions may eventually be added to the data model, aside from the Atlantic and Gulf of Mexico OCS regions. Please refer to the scientific reports, as well as Bureau of Ocean Energy Management (BOEM) Marine Minerals Program (MMP) Leases, negotiated agreements, cooperative agreements, Memoranda of Agreements, and project completion reports, for accuracy statements on the corresponding source data. These documents are referenced in the attribute tables, where appropriate. In regards to attribute assignment in the Marine Minerals Information Systems (MMIS) data model, every effort was made to load source data into MMIS without error or modification. Some attributes contain domain restrictions in an effort to standardize the field entries and to decrease potential inconsistent entries (e.g., spelling, grammar, typographical errors, and subject matter) in the attribute. Quantitative attribute accuracy: accuracy of quantitative attributes Please refer to the scientific reports, as well as Bureau of Ocean Energy Management (BOEM) Marine Minerals Program (MMP) Leases, negotiated agreements, cooperative agreements, Memoranda of Agreements, and project completion reports, for accuracy statements on the corresponding source data. These documents are referenced in the attribute tables, where appropriate. In regards to attribute assignment in the Marine Minerals Information Systems (MMIS) data model, every effort was made to load source data into MMIS without error or modification. Some attributes contain domain restrictions in an effort to standardize the field entries and to decrease potential inconsistent entries (e.g., spelling, grammar, typographical errors, and subject matter) in the attribute. Absolute external positional accuracy: closeness of reported coordinate values to values accepted as or being true Absolute external positional accuracy: closeness of reported coordinate values to values accepted as or being true Absolute external positional accuracy: closeness of reported coordinate values to values accepted as or being true Absolute external positional accuracy: closeness of reported coordinate values to values accepted as or being true https://geoseas.geoplatform.gov/hosting/rest/services/MMP ArcGIS 10.8.1 Enterprise Geodatabase Table 2026-01-01T00:00:00 SampPhi Contains information regarding grain size distribution within a core or grab sample BOEM Table PHI_N_04 Weight percent retained of sample of grain size -4 phi. BOEM Weight percent retained of sample of grain size -4 phi. PHI_N_04 Double 8 38 8 PHI_N_03 Weight percent retained of sample of grain size -3 phi. BOEM Weight percent retained of sample of grain size -3 phi. PHI_N_03 Double 8 38 8 PHI_N_06_50 Weight percent retained of sample of grain size -6.5 phi. BOEM Weight percent retained of sample of grain size -6.5 phi. PHI_N_06_50 Double 8 38 8 PHI_N_06_25 Weight percent retained of sample of grain size -6.25 phi. BOEM Weight percent retained of sample of grain size -6.25 phi. PHI_N_06_25 Double 8 38 8 PHI_N_10Less Weight percent retained of sample of grain size -10 phi. BOEM Weight percent retained of sample of grain size -10 phi. PHI_N_10Less Double 8 38 8 PHI_N_09 Weight percent retained of sample of grain size -9 phi. BOEM Weight percent retained of sample of grain size -9 phi. PHI_N_09 Double 8 38 8 PHI_N_02_75 Weight percent retained of sample of grain size -2.75 phi. BOEM Weight percent retained of sample of grain size -2.75 phi. PHI_N_02_75 Double 8 38 8 PHI_N_02_25 Weight percent retained of sample of grain size -2.25 phi. BOEM Weight percent retained of sample of grain size -2.25 phi. PHI_N_02_25 Double 8 38 8 PHI_N_04_75 Weight percent retained of sample of grain size -4.75 phi. BOEM Weight percent retained of sample of grain size -4.75 phi. PHI_N_04_75 Double 8 38 8 PHI_N_05_50 Weight percent retained of sample of grain size -5.5 phi. BOEM Weight percent retained of sample of grain size -5.5 phi. PHI_N_05_50 Double 8 38 8 PHI_N_05 Weight percent retained of sample of grain size -5 phi. BOEM Weight percent retained of sample of grain size -5 phi. PHI_N_05 Double 8 38 8 PHI_N_06 Weight percent retained of sample of grain size -6 phi. BOEM Weight percent retained of sample of grain size -6 phi. PHI_N_06 Double 8 38 8 StudyID Study ID of the study in which the feature was identified. Study ID following the convention noted in the Data Management Plan BOEM Study ID of the study in which the feature was identified. Study ID following the convention noted in the Data Management Plan StudyID String 250 0 0 PHI_N_01_75 Weight percent retained of sample of grain size -1.75 phi. BOEM Weight percent retained of sample of grain size -1.75 phi. PHI_N_01_75 Double 8 38 8 PHI_N_05_25 Weight percent retained of sample of grain size -5.25 phi. BOEM Weight percent retained of sample of grain size -5.25 phi. PHI_N_05_25 Double 8 38 8 PHI_02 Weight percent retained of sample of grain size 2 phi. BOEM Weight percent retained of sample of grain size 2 phi. PHI_02 Double 8 38 8 SampleID Sample ID as indicated by the study BOEM Sample ID as indicated by the study SampleID String 50 0 0 PHI_N_01_50 Weight percent retained of sample of grain size -1.5 phi. BOEM Weight percent retained of sample of grain size -1.5 phi. PHI_N_01_50 Double 8 38 8 PHI_N_05_75 Weight percent retained of sample of grain size -5.75 phi. BOEM Weight percent retained of sample of grain size -5.75 phi. PHI_N_05_75 Double 8 38 8 PHI_01 Weight percent retained of sample of grain size 1 phi. BOEM Weight percent retained of sample of grain size 1 phi. PHI_01 Double 8 38 8 PHI_02_50 Weight percent retained of sample of grain size 2.5 phi. BOEM Weight percent retained of sample of grain size 2.5 phi. PHI_02_50 Double 8 38 8 PHI_00_50 Weight percent retained of sample of grain size 0.5 phi. BOEM Weight percent retained of sample of grain size 0.5 phi. PHI_00_50 Double 8 38 8 PHI_10Greater Weight percent retained of sample of grain size 10 phi or larger. BOEM Weight percent retained of sample of grain size 10 phi or larger. PHI_10Greater Double 8 38 8 PHI_04_75 Weight percent retained of sample of grain size 4.75 phi. BOEM Weight percent retained of sample of grain size 4.75 phi. PHI_04_75 Double 8 38 8 PHI_N_08 Weight percent retained of sample of grain size -8 phi. BOEM Weight percent retained of sample of grain size -8 phi. PHI_N_08 Double 8 38 8 PHI_N_07 Weight percent retained of sample of grain size -7 phi. BOEM Weight percent retained of sample of grain size -7 phi. PHI_N_07 Double 8 38 8 PHI_05 Weight percent retained of sample of grain size 5 phi. BOEM Weight percent retained of sample of grain size 5 phi. PHI_05 Double 8 38 8 PHI_N_02 Weight percent retained of sample of grain size -2 phi. BOEM Weight percent retained of sample of grain size -2 phi. PHI_N_02 Double 8 38 8 PHI_04_25 Weight percent retained of sample of grain size 4.25 phi. BOEM Weight percent retained of sample of grain size 4.25 phi. PHI_04_25 Double 8 38 8 PHI_N_00_25 Weight percent retained of sample of grain size -0.25 phi. BOEM Weight percent retained of sample of grain size -0.25 phi. PHI_N_00_25 Double 8 38 8 PHI_00 Weight percent retained of sample of grain size 0 phi. BOEM Weight percent retained of sample of grain size 0 phi. PHI_00 Double 8 38 8 Phi_GlobalTableID Uniquely identifies a Phi record to a sample BOEM Uniquely identifies a Phi record to a sample Phi_GlobalTableID GUID 38 0 0 PHI_N_00_50 Weight percent retained of sample of grain size -0.5 phi. BOEM Weight percent retained of sample of grain size -0.5 phi. PHI_N_00_50 Double 8 38 8 PHI_04_50 Weight percent retained of sample of grain size 4.5 phi. BOEM Weight percent retained of sample of grain size 4.5 phi. PHI_04_50 Double 8 38 8 PHI_N_04_50 Weight percent retained of sample of grain size -4.5 phi. BOEM Weight percent retained of sample of grain size -4.5 phi. PHI_N_04_50 Double 8 38 8 PHI_02_75 Weight percent retained of sample of grain size 2.75 phi. BOEM Weight percent retained of sample of grain size 2.75 phi. PHI_02_75 Double 8 38 8 PHI_06 Weight percent retained of sample of grain size 6 phi. BOEM Weight percent retained of sample of grain size 6 phi. PHI_06 Double 8 38 8 PHI_03_50 Weight percent retained of sample of grain size 3.5 phi. BOEM Weight percent retained of sample of grain size 3.5 phi. PHI_03_50 Double 8 38 8 PHI_N_03_75 Weight percent retained of sample of grain size -3.75 phi. BOEM Weight percent retained of sample of grain size -3.75 phi. PHI_N_03_75 Double 8 38 8 PHI_03_75 Weight percent retained of sample of grain size 3.75 phi. BOEM Weight percent retained of sample of grain size 3.75 phi. PHI_03_75 Double 8 38 8 PHI_N_03_50 Weight percent retained of sample of grain size -3.5 phi. BOEM Weight percent retained of sample of grain size -3.5 phi. PHI_N_03_50 Double 8 38 8 OBJECTID Internal feature number Esri Internal feature number OBJECTID OID 4 10 0 PHI_N_02_50 Weight percent retained of sample of grain size -2.5 phi. BOEM Weight percent retained of sample of grain size -2.5 phi. PHI_N_02_50 Double 8 38 8 PHI_N_04_25 Weight percent retained of sample of grain size -4.25 phi. BOEM Weight percent retained of sample of grain size -4.25 phi. PHI_N_04_25 Double 8 38 8 PHI_N_01 Weight percent retained of sample of grain size -1 phi. BOEM Weight percent retained of sample of grain size -1 phi. PHI_N_01 Double 8 38 8 PHI_04 Weight percent retained of sample of grain size 4 phi. BOEM Weight percent retained of sample of grain size 4 phi. PHI_04 Double 8 38 8 PHI_03_25 Weight percent retained of sample of grain size 3.25 phi. BOEM Weight percent retained of sample of grain size 3.25 phi. PHI_03_25 Double 8 38 8 PHI_07 Weight percent retained of sample of grain size 7 phi. BOEM Weight percent retained of sample of grain size 7 phi. PHI_07 Double 8 38 8 PHI_00_75 Weight percent retained of sample of grain size 0.75 phi. BOEM Weight percent retained of sample of grain size 0.75 phi. PHI_00_75 Double 8 38 8 PHI_01_25 Weight percent retained of sample of grain size 1.25 phi. BOEM Weight percent retained of sample of grain size 1.25 phi. PHI_01_25 Double 8 38 8 PHI_09 Weight percent retained of sample of grain size 9 phi. BOEM Weight percent retained of sample of grain size 9 phi. PHI_09 Double 8 38 8 PHI_N_01_25 Weight percent retained of sample of grain size -1.25 phi. BOEM Weight percent retained of sample of grain size -1.25 phi. PHI_N_01_25 Double 8 38 8 PHI_N_00_75 Weight percent retained of sample of grain size -0.75 phi. BOEM Weight percent retained of sample of grain size -0.75 phi. PHI_N_00_75 Double 8 38 8 PHI_08 Weight percent retained of sample of grain size 8 phi. BOEM Weight percent retained of sample of grain size 8 phi. PHI_08 Double 8 38 8 PHI_00_25 Weight percent retained of sample of grain size 0.25 phi. BOEM Weight percent retained of sample of grain size 0.25 phi. PHI_00_25 Double 8 38 8 PHI_03 Weight percent retained of sample of grain size 3 phi. BOEM Weight percent retained of sample of grain size 3 phi. PHI_03 Double 8 38 8 PHI_01_75 Weight percent retained of sample of grain size 1.75 phi. BOEM Weight percent retained of sample of grain size 1.75 phi. PHI_01_75 Double 8 38 8 PHI_N_03_25 Weight percent retained of sample of grain size -3.25 phi. BOEM Weight percent retained of sample of grain size -3.25 phi. PHI_N_03_25 Double 8 38 8 PHI_01_50 Weight percent retained of sample of grain size 1.5 phi. BOEM Weight percent retained of sample of grain size 1.5 phi. PHI_01_50 Double 8 38 8 Comments Additional comments or notes containg supporting information BOEM Additional comments or notes containg supporting information Comments String 250 0 0 PHI_02_25 Weight percent retained of sample of grain size 2.25 phi. BOEM Weight percent retained of sample of grain size 2.25 phi. PHI_02_25 Double 8 38 8 PHI_N_06_75 Weight percent retained of sample of grain size -6.75 phi. BOEM Weight percent retained of sample of grain size -6.75 phi. PHI_N_06_75 Double 8 38 8 created_date created_date Stores the date and time a feature or record was created Esri Date 8 Read-only. Stores the date and time a feature or record was created. 1 0 last_edited_date last_edited_date Stores the date a feature or record was last edited Esri Date 8 Read-only. Stores the date a feature or record was last edited. 1 0 Samples_GlobalSampleID Samples_GlobalSampleID GUID 38 0 0 Global ID which relates the record to its respective core/grab Studying the grain size distribution of sediment samples is important for many reasons. For example, sediments structure benthic communities because of grain size preferences by various organisms. Also, the rate and manner in which sediment particles are transported to the sea, and the rate at which they sink to the sea floor is controlled by their size. Similarly, particle size provides information about how much energy was necessary to carry that particle as well as the environment in which the particle was transported and deposited. Lastly, the grain size distribution of particles is one of the many factors used in the determination of suitability for prospective use in beach nourishment and coastal rehabilitation. The data derived from the Phi table will provide a synthesis of the Outer Continental Shelf (OCS) sedimentation and geology to support a wide variety of planning and management decisions and to provide a basis for further process-oriented investigations. BOEM