Metadata: Identification_Information: Citation: Citation_Information: Originator: Breanna N. Williams Originator: Heather A. Schreppel Originator: Christopher D. Reich Originator: Kathryn E.L. Smith Originator: Ginger Tiling-Range Originator: Chelsea A. Stalk Originator: Steven H. Douglas Originator: Shawn V. Dadisman Originator: James G. Flocks Originator: Lauren T. Toth Originator: Anastasios Stathakopoulos Publication_Date: 20130725 Title: St. Petersburg Coastal and Marine Science Center's Geologic Core and Sample Database Metadata Geospatial_Data_Presentation_Form: application/service, tabular digital data Larger_Work_Citation: Citation_Information: Originator: Breanna N. Williams Originator: Heather A. Schreppel Originator: Christopher D. Reich Originator: Kathryn E.L. Smith Originator: Ginger Tiling-Range Originator: Chelsea A. Stalk Originator: Steven H. Douglas Originator: Shawn V. Dadisman Originator: James G. Flocks Originator: Lauren T. Toth Originator: Anastasios Stathakopoulos Publication_Date: 20130725 Title: St. Petersburg Coastal and Marine Science Center's Geologic Core and Sample Database Publication_Information: Publication_Place: St. Petersburg, Florida Publisher: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Online_Linkage: https://doi.org/10.5066/F7319TR3 Description: Abstract: This database contains a comprehensive inventory of geologic (coral, coral reef, limestone, and sediment) cores and samples collected, analyzed, published, and/or archived by, or in collaboration with, the U.S. Geological Survey St. Petersburg Coastal and Marine Science Center (USGS SPCMSC). The SPCMSC Geologic Core and Sample Database includes geologic cores and samples collected beginning in the 1970s to present day, from study sites across the world. This database captures metadata about samples throughout the USGS Science Data Lifecycle: including field collection, laboratory analysis, publication of research, and archival or deaccession. For more information about the USGS Science Data Lifecycle, see USGS Open-File Report 2013-1265 (https://doi.org/10.3133/ofr20131265). The SPCMSC Geologic Core and Sample Database also includes storage locations for physical samples and cores archived in a repository (USGS SPCMSC or elsewhere, if known). The majority of the samples and cores in this database come from field activities associated with the SPCMSC and have been assigned a field activity number (FAN) in the field activity management and data inventory tool for USGS Coastal and Marine Hazards and Resources Program (CMHRP) Coastal and Marine Geoscience Data System (CMGDS), https://cmgds.marine.usgs.gov/. Some cores and samples were retroactively assigned FANs based on existing metadata and published information. Cores and samples without FANs indicate there is insufficient information regarding collection of the core(s) or sample(s) needed in order to assign a field activity number in CMGDS. Please see the supplemental information section of the metadata for more information about FANs. All samples and cores contained in this database are described in published research. The database contains a link to the FAN page within the CMGDS for each sample or core where associated publications can be accessed. For a complete list of fields used in this database, please refer to the entity and attribute information section of this metadata record. Purpose: The purpose of this database is to provide a comprehensive inventory of geologic samples collected, analyzed, published, and/or archived by, or in collaboration with, USGS SPCMSC. This inventory has been compiled, organized, and released online to provide researchers and the public with a means to discover and browse through information about physical samples and cores utilized by SPCMSC along with their associated metadata and publications. This database serves to ensure preservation of sample metadata for future research and reuse. Supplemental_Information: Field activity numbers (FANs) are data collection events carried out by, or in collaboration with, the USGS Coastal and Marine Hazards and Resources Program (CMHRP). Each FAN is a unique number given to data collected during a field activity. There are two common formats used for a FAN. The first is: ##XXX##. The first two digits represent the year the data were collected. The third through fifth digits represent the project identification information, coded by the USGS to be unique to each project. The last two digits represent the number of field activities in that year under that project code. The second format for a FAN is: ####-###-FA. The first four digits represent the year the data were collected and the second, 3-digit set represents numbers assigned to a specific USGS center (for example, USGS SPCMSC numbers begin at 300). FANs are publicly accessible via the USGS Coastal and Marine Geoscience Data System (CMGDS). To view field activity details for any of the samples included in this database, CMGDS can be used to look up the FANs, by replacing the FAN (2020-301-FA) in the following URL: https://cmgds.marine.usgs.gov/fan_info.php?fan=2020-301-FA. A geonarrative titled The SPCMSC Geologic Core and Sample Database was published in September 2022 to include revised, non-interpretive methodology for updating and publishing the database and to provide database documentation for this USGS-owned Online Database and Web Data Service. For more information and to access this resource, refer to Williams and Schreppel (2022). The database is also accessible through ScienceBase, which is a USGS Trusted Digital Repository (TDR) providing access to USGS data products and resources. To access this resource, refer to Williams and Schreppel (2013). Lastly, this database is also accessible through the National Oceanic and Atmospheric Administration National Centers for Environmental Information's (NOAA NCEI) Index to Marine and Lacustrine Geological Samples (IMLGS). The IMLGS viewer is a tool used by scientists and the public to locate geologic material archived by participating institutions around the world. Each curatorial facility prepares and submits data about their own collection to the IMLGS. SPCMSC submits an updated record of samples to the IMLGS with every database update. For more information and to access this resource, refer to Curators of Marine and Lacustrine Geological Samples Consortium (2015). Time_Period_of_Content: Time_Period_Information: Range_of_Dates/Times: Beginning_Date: 19740907 Ending_Date: 20211215 Currentness_Reference: ground condition Status: Progress: Complete Maintenance_and_Update_Frequency: As needed Spatial_Domain: Bounding_Coordinates: West_Bounding_Coordinate: -124.046882 East_Bounding_Coordinate: 162.250000 North_Bounding_Coordinate: 46.740893 South_Bounding_Coordinate: -3.272100 Keywords: Theme: Theme_Keyword_Thesaurus: USGS Metadata Identifier Theme_Keyword: USGS:e51b16f7-3c8c-48e0-8f95-8533934535b8 Theme: Theme_Keyword_Thesaurus: ISO 19115 Topic Categories Theme_Keyword: biota Theme_Keyword: environment Theme_Keyword: geoscientificInformation Theme_Keyword: oceans Theme: Theme_Keyword_Thesaurus: USGS Thesaurus Theme_Keyword: age estimation methods Theme_Keyword: atomic emission spectroscopy Theme_Keyword: augering Theme_Keyword: box coring Theme_Keyword: bulk density Theme_Keyword: carbon isotope analysis Theme_Keyword: carbon-14 analysis Theme_Keyword: chemical analysis Theme_Keyword: contamination and pollution Theme_Keyword: core analysis Theme_Keyword: CTD measurement Theme_Keyword: drilling and coring Theme_Keyword: faunal and floral census (microscopic) Theme_Keyword: field sampling Theme_Keyword: geolocation measurement Theme_Keyword: geology Theme_Keyword: grab sampling Theme_Keyword: grain-size analysis Theme_Keyword: information technology methods Theme_Keyword: isotopic analysis Theme_Keyword: laboratory methods Theme_Keyword: light stable isotope analysis Theme_Keyword: luminescence dating Theme_Keyword: magnetic susceptibility Theme_Keyword: marine geology Theme_Keyword: mass spectroscopy Theme_Keyword: paleomagnetic analysis Theme_Keyword: permeability Theme_Keyword: photography Theme_Keyword: piston coring Theme_Keyword: porosity Theme_Keyword: protists Theme_Keyword: push coring Theme_Keyword: radiometric dating Theme_Keyword: rotary drilling Theme_Keyword: salinity Theme_Keyword: sample repositories Theme_Keyword: sea surface temperature Theme_Keyword: soil sciences Theme_Keyword: stratigraphy Theme_Keyword: subsampling Theme_Keyword: tomography Theme_Keyword: vibracoring Theme_Keyword: water chemistry Theme_Keyword: water quality Theme_Keyword: x-ray diffraction Theme_Keyword: x-ray fluorescence Theme: Theme_Keyword_Thesaurus: None Theme_Keyword: samples Theme_Keyword: cores Theme_Keyword: sediment Theme_Keyword: coral Theme_Keyword: coral reef Theme_Keyword: limestone Place: Place_Keyword_Thesaurus: None Place_Keyword: Alabama Place_Keyword: Florida Place_Keyword: Georgia Place_Keyword: Louisiana Place_Keyword: Maryland Place_Keyword: Mexico Place_Keyword: Mississippi Place_Keyword: New Jersey Place_Keyword: New Mexico Place_Keyword: New York Place_Keyword: Texas Place_Keyword: Virginia Place_Keyword: Washington Place_Keyword: Bahamas Place_Keyword: Belize Place_Keyword: Brazil Place_Keyword: China Place_Keyword: Honduras Place_Keyword: Marshall Islands Place_Keyword: Navassa Island Place_Keyword: Philippines Place_Keyword: Puerto Rico Place_Keyword: Turks and Caicos Islands Place_Keyword: U.S. Virgin Islands Place_Keyword: United States Place_Keyword: Atlantic Ocean Place_Keyword: Caribbean Sea Place_Keyword: Gulf of Mexico Place_Keyword: Pacific Ocean Stratum: Stratum_Keyword_Thesaurus: None Stratum_Keyword: bedrock Stratum_Keyword: benthic Stratum_Keyword: sediment Stratum_Keyword: subsurface Stratum_Keyword: surface Access_Constraints: None Use_Constraints: Prior to use of these records in any analysis or report, the USGS must be notified and if used the provenance of the original data must be acknowledged. Acknowledge the use of specific records from contributing USGS databases and recognize the limitations of data. Point_of_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: USGS SPCMSC Data Management Group Contact_Position: Data Management Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Voice_Telephone: gs-g-spcmsc_data_inquiries@usgs.gov Data_Set_Credit: The USGS St. Petersburg Coastal and Marine Science Center would like to recognize additional collaborators that assisted with field collection, analysis, and/or archival for some samples found within this database, Louisiana Department of Natural Resources (LDNR), Nova Southeastern University, Ocean-Seismic Survey, Inc (Ocean-Seis), U.S. Army Corps of Engineers (USACE), Eckerd College, Department of Agriculture's Natural Resources Conservation Service (USDA-NRCS), Virginia Institute of Marine Science (VIMS), Florida Geological Survey (FGS), USGS South Atlantic Water Science Center, USGS Pacific Coastal and Marine Science Center (PCMSC), University of New Orleans (UNO), Dial Cordy & Associates, Inc., and Florida Atlantic University. Native_Data_Set_Environment: Microsoft Windows 10; Microsoft Excel Version 16.0; Esri ArcMap 10.1 through 10.6 (original methodology); Esri ArcGIS Pro 2.8 (current methodology). Cross_Reference: Citation_Information: Originator: Breanna N. Williams Originator: Heather A. Schreppel Publication_Date: 20220916 Title: The USGS SPCMSC Geologic Core and Sample Database Geospatial_Data_Presentation_Form: application/service Publication_Information: Publication_Place: ArcGIS Online Publisher: Esri Online_Linkage: https://doi.org/10.5066/P9X3XFIN Cross_Reference: Citation_Information: Originator: Breanna N. Williams Originator: Heather A. Schreppel Publication_Date: 20130725 Title: St. Petersburg Coastal and Marine Science Center's Geologic Core and Sample Database Geospatial_Data_Presentation_Form: tabular digital data Publication_Information: Publication_Place: Online Publisher: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Online_Linkage: https://www.sciencebase.gov/catalog/item/607eca01d34e8564d6809dfc Cross_Reference: Citation_Information: Originator: Curators of Marine and Lacustrine Geological Samples Consortium Publication_Date: 20151009 Title: The Index to Marine and Lacustrine Geological Samples (IMLGS) Geospatial_Data_Presentation_Form: application/service Publication_Information: Publication_Place: Online Publisher: NOAA NCEI Online_Linkage: https://doi.org/10.7289/V5H41PB8 Data_Quality_Information: Attribute_Accuracy: Attribute_Accuracy_Report: The validity or accuracy of information on the geologic samples and cores are dependent on individual surveys and the availability of information regarding historic field collection procedures. Database fields have been left blank when the information could not be obtained from available records and publications. Latitude/Longitude coordinates of field locations where cores and samples were collected could not always be determined, particularly for samples or cores obtained prior to the availability of Global Positioning System (GPS). Therefore, some locations should be considered approximate. The error for location coordinates ranges considerably depending on the date of collection and the availability of information in existing records. Samples or cores whose collection locations have been approximated are indicated as such in the geog_approx field. Consult the associated publication(s) for that sample or core for more information regarding locational accuracy. Logical_Consistency_Report: This database includes samples and cores collected during multiple field activities and various publications; therefore, no fidelity checks have been conducted. Samples or cores may have the same coordinates due to close proximity and spatial accuracy of geographic records. Completeness_Report: Data are considered complete and available records for samples and cores published by the U.S. Geological Survey's St. Petersburg Coastal and Marine Science Center are found within the database. Unpublished records for samples or cores are not included in the publicly available version of the database. Positional_Accuracy: Horizontal_Positional_Accuracy: Horizontal_Positional_Accuracy_Report: The coordinates for many of the cores collected prior to GPS technology are generalized and based on general descriptions of field surveys; therefore, the spatial error can be up to several hundred meters. With the use of modern GPS tools, most samples and cores collected after 1991 have the potential to be more accurate; however, no estimate of accuracy has been conducted. Consult the associated publication(s) for that sample or core for more information regarding horizontal positional accuracy details. Lineage: Source_Information: Source_Citation: Citation_Information: Originator: Chris D. Reich Originator: Matt I. Streubert Originator: Brendan Dwyer Originator: Megan Godbout Originator: Adis Muslic Originator: Dan Umberger Publication_Date: 20120104 Title: St. Petersburg Coastal and Marine Science Center's Core Archive Portal Geospatial_Data_Presentation_Form: vector digital data Series_Information: Series_Name: U.S. Geological Survey Data Series Issue_Identification: 626 Online_Linkage: https://doi.org/10.3133/ds626 Type_of_Source_Media: tabular digital data Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 20120104 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: SPCMSC Core Archive Portal Source_Contribution: This data set is the original USGS SPCMSC Core Archive Portal. Data consisted predominately of coral and rock cores collected by the USGS in south Florida, Bahamas, Gulf of Mexico, and Virgin Islands. All rock sample records recorded in Data Series 626 have since been reclassified to either coral, coral reef, limestone, or sediment material during an update the database in April 2022 to improve descriptive accuracy. The database was combined with the SPCMSC sediment sample database to create a more comprehensive record of past geologic sampling efforts from SPCMSC. Some dates and other collection information may have been altered from this publication since its original release, as more accurate information from published research was discovered. Source_Information: Source_Citation: Citation_Information: Originator: Heather A. Schreppel Originator: Kathryn E.L. Smith Originator: James G. Flocks Originator: Shawn A. Dadisman Originator: Ginger Tiling-Range Originator: Steven H. Douglas Originator: Chelsea A. Stalk Originator: Breanna N. Williams Publication_Date: 20130122 Title: St. Petersburg Coastal and Marine Science Center's Sediment Samples Database Geospatial_Data_Presentation_Form: tabular digital data Type_of_Source_Media: tabular digital data Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 20130122 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: SPCMSC Sediment Samples Database Source_Contribution: The SPCSMC Sediment Samples Database contained information on sediment cores and samples collected by SPCMSC staff and collaborators located predominately in the Gulf of Mexico. The database only contained information on sediment grab samples and cores that have been published in an official USGS publication or a peer-reviewed scholarly publication. Data from the SPCMSC Core Archive Portal (Reich and others, 2012) was combined with this database (Schreppel and others, 2013) to create a more comprehensive record of geologic cores and samples associated with USGS SPCMSC. Some dates and other collection information may have been altered from this database since its original release, as more accurate information from published research was discovered. Process_Step: Process_Description: Information from core description sheets and publications on sediment samples and cores were populated into an Excel spreadsheet by manual entry. Sediment samples and cores that were physically archived in the USGS SPCMSC Core Laboratory were populated with associated repository storage locations in the database. Source_Used_Citation_Abbreviation: SPCMSC Sediment Samples Database Process_Date: 2012 Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Heather A. Schreppel Contact_Position: Geographer (Data Management Specialist) Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: hschreppel@usgs.gov Process_Step: Process_Description: Information from description sheets and published research on rock (which have since been reclassified to a different material type to improve descriptive accuracy) and coral cores archived within the USGS SPCMSC Core Laboratory repository were populated into Excel spreadsheet by manual entry. Source_Used_Citation_Abbreviation: SPCMSC Core Archive Portal Process_Date: 2012 Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Christopher D. Reich Contact_Position: Geologist Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: creich@usgs.gov Process_Step: Process_Description: Publishing the database (original methodology): Data from the SPCMSC Core Archive Portal were combined into comparable columns in the SPCSMC Sediment Samples Database in Microsoft Excel to create a single, complete database of all SPCMSC geologic samples and cores, formally known as the SPCMSC Geologic Core and Sample Database. Attribute names were adjusted, but no essential information was lost or deleted during the collation. After collation of the two datasets, the Excel spreadsheet file (.xlsx) of the database was filtered to exclude cores and samples that have not been documented in published research. A filter was applied to the ‘publish’ field as ‘TRUE’ in the .xlsx. This filtered copy of the published-only database was saved as a comma-separated values file (.csv). To preserve attribute field names, the .csv file was imported as a feature class into a file geodatabase using ArcMap 10.1. Next, the file geodatabase feature class was imported into an ArcSDE enterprise geodatabase. The enterprise geodatabase feature class was added and saved into a map document (.mxd), and then published as a web service using ArcGIS Server in ArcGIS Enterprise. The web service was then added to a new web map (SPCMSC Core Viewer Web Map) in ArcGIS Online and saved. Lastly, the web map was added to a web mapping application using ArcGIS Web AppBuilder and various widgets and functionality were developed on the application. The SPCMSC Geologic Core and Sample Database was made publicly accessible on ArcGIS Online via a web mapping application, known as the SPCMSC Core Viewer Web Mapping Application, at https://doi.org/10.5066/F7319TR3. Source_Used_Citation_Abbreviation: SPCMSC Core Archive Portal Source_Used_Citation_Abbreviation: SPCMSC Sediment Samples Database Process_Date: 20130624 Source_Produced_Citation_Abbreviation: SPCMSC Geologic Core and Sample Database Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Mapping Application Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Map Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Kathryn E.L. Smith Contact_Position: Research Ecologist Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: kelsmith@usgs.gov Process_Step: Process_Description: Republishing the database (original methodology): Information about samples and cores were added to the existing Excel spreadsheet as more were collected in the field, or new information was published about previously collected cores or samples. Only the published cores and sample records were republished at every iteration. Core and sample information may have been altered in the database from previous iterations of the database, as more accurate information from published research was discovered. Once updated with new information, the database (.csv) was republished using the methodology mentioned in the previous process step. The version of ArcMap used to republish the database changed over time as new versions were released by Esri. The final version used for this publishing method was ArcMap 10.6. Once the enterprise geodatabase feature class was updated and the web service was republished, the existing web map and web application automatically updated on ArcGIS Online. This methodology was performed on a continual, as-needed basis from 2013-2021. New publishing methodology was introduced in September 2022. Please refer to the subsequent process steps for more information. Source_Used_Citation_Abbreviation: SPCMSC Geologic Core and Sample Database Process_Date: 2021 Source_Produced_Citation_Abbreviation: SPCMSC Geologic Core and Sample Database Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Mapping Application Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Map Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Breanna N. Williams Contact_Position: Geographer Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: bnwilliams@usgs.gov Process_Step: Process_Description: Editing the database in PostgreSQL (current methodology): A new editing method for the SPCMSC Geologic Core and Sample Database was implemented in September 2022 to improve and modernize management of the database. The .xlsx copy of the database containing both the unpublished and published sample records was uploaded into Navicat (version 11.2.16) as a PostgreSQL database. Navicat is graphical database management and development software. PostgreSQL is an open-source relational database management system that utilizes Structured Query Language (SQL), a programming language used for database design, manipulation, and management. Edits to the database are made periodically throughout the biannual update window, and a backup is exported each day edits occur (in .sql format). The backups are stored on an internal server for safekeeping. Edits to the database are executed by either of the following methods: manual edit to the database within Navicat using an edit session in the software, or upload of a .csv to the database in Navicat containing edits of additions using the primary key identifier (pk_id) to add a new record or edit existing records. Updates and edits to the database are made in the following instances: new samples are collected by SPCMSC researchers, new donated or contracted samples are received by SPCMSC, new research about samples are published, changes are made to disposition or storage locations, or new sample information becomes available. All published edits to the database are recorded within a version history document. Process_Date: 20220906 Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Breanna N. Williams Contact_Position: Geographer Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: bnwilliams@usgs.gov Process_Step: Process_Description: Quality control and quality assurance (QA/QC) (current methodology): Once edits are complete for the biannual update, they are quality checked by another member of the SPCMSC data management group to ensure data integrity. This reviewer validates the following: geospatial and temporal coordinates have been transcribed/transposed correctly, changes to the metadata are complete and accurate, the version history fully documents changes made to the database, no typos or errors were introduced during the data entry process, field activity numbers and associated publications are accurate with valid links, and the analyses field uses controlled vocabulary from the USGS Thesaurus. Process_Date: 20220906 Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Heather A. Schreppel Contact_Position: Geographer (Data Management Specialist) Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: hschreppel@usgs.gov Process_Step: Process_Description: Publishing the database (current methodology): After QA/QC has been performed, a copy of the database is published to ArcGIS Online. This new method improves the integration of the database with online services. The current methods are as follows: 1. In Navicat, the samples database manager applies a filter to the database. Samples with 'TRUE' in the 'publish' attribute are selected, and the data is exported as a comma-separated values (.csv) file. 2. A pre-defined template ArcGIS Project File (.aprx) is opened in ArcGIS Pro 2.8.3. The ‘Table to Point Feature Class’ geoprocessing tool is used to convert the .csv file into a feature class and is saved in a file geodatabase (.gdb) on an internal server to preserve the field names. The coordinate system for the shapefile is set to the World Geodetic System of 1984 (WGS 84). 3. Six copies of the samples database feature class are added to the Contents pane within ArcGIS Pro. These layers are then selected and placed into a Group Layer and each sample category is defined using a Definition Query. This process sorts the data by the material and sample type fields. The data is currently classified into the following categories: coral cores, coral samples, coral reef cores, limestone cores, sediment cores, and sediment samples. Each layer in the Contents pane is renamed to reflect these sample categories. Additional categories may be added in the future if new sample types are collected and published. 4. Next, each sample category is uniquely symbolized for increased accessibility. Symbol colors and shapes have been chosen to make the dataset and web applicable more accessible to people with disabilities based on Section 508 standards for information and communication technology. For more information about Section 508, refer to https://www.section508.gov/. 5. The group layer is shared as a hosted feature layer to ArcGIS Online as the SPCMSC Geologic Core and Sample Database Feature Layer (hosted). To do this, in ArcGIS Pro, the samples database manager selects the group layer in the contents pane and choses 'Share' > 'Share As Web Layer' > 'Publish'. Other supporting documents and files are also published to the web for user access, which includes this metadata record (.txt and .xml), a version history document (version_history_SPCMSC_samples_database.docx) and a comma-separated values (CSV) file (SPCMSC_samples_database.csv) export of the database. These files are published as a CSV Collection (SPCMSC_samples_database.zip) item in ArcGIS Online and are uploaded directly to the item using a web browser. Next, the samples database manager sends an email request to the USGS Enterprise GIS (EGIS) team to make the ArcGIS Online items (Feature Layer (hosted) and CSV collection) publicly available. During the first time publishing the database, the hosted feature layer was added to the SPCMSC Core Viewer Web Map. This was completed by opening the existing ArcGIS Online web map (generated from the previous publishing methodology) and replacing the prior web service URL to the database with the URL of the new hosted feature layer. In subsequent updates, this web map is automatically updated with new data once the hosted feature layer is published and made public. This web map is also linked to the SPCMSC Core Viewer Web Mapping Application, and automatically updates within the application. The SPCMSC Geologic Core and Sample Database is republished approximately every six months. During republishing, the same steps are followed but the older copy of the database feature class in the geodatabase is renamed to append the date of the last update in YYYYMMDD format. The data source for the group layer is also updated to the new feature class source, which reloads and updates the dataset while preserving the previously set definition queries and symbology. Next, the hosted feature layer is overwritten by clicking on the group layer and selecting Share > Overwrite Web Layer > Publish. Upon overwriting the layer, it is no longer publicly shared, and the samples database manager will send an email to the USGS EGIS team requesting the item be made public again. This may result in a brief downtime, where the database may be unavailable to users. At this time, the ArcGIS Online CSV Collection item is also updated with the newest files by the samples database manager via the ArcGIS Online website. Source_Used_Citation_Abbreviation: SPCMSC Geologic Core and Sample Database Process_Date: 20220906 Source_Produced_Citation_Abbreviation: SPCMSC Geologic Core and Sample Database Feature Layer (hosted) Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Mapping Application Source_Produced_Citation_Abbreviation: SPCMSC Core Viewer Web Map Source_Produced_Citation_Abbreviation: SPCMSC_samples_database.csv Source_Produced_Citation_Abbreviation: version_history_SPCMSC_samples_database.docx Source_Produced_Citation_Abbreviation: SPCMSC_samples_database.zip Process_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Breanna N. Williams Contact_Position: Geographer Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: bnwilliams@usgs.gov Spatial_Data_Organization_Information: Direct_Spatial_Reference_Method: Vector Point_and_Vector_Object_Information: SDTS_Terms_Description: SDTS_Point_and_Vector_Object_Type: Entity point Point_and_Vector_Object_Count: 6451 Spatial_Reference_Information: Horizontal_Coordinate_System_Definition: Geographic: Latitude_Resolution: 8.98315284119521e-009 Longitude_Resolution: 8.98315284119521e-009 Geographic_Coordinate_Units: Decimal Degrees Geodetic_Model: Horizontal_Datum_Name: D_WGS_1984 Ellipsoid_Name: WGS_1984 Semi-major_Axis: 6378137.0 Denominator_of_Flattening_Ratio: 298.257223563 Entity_and_Attribute_Information: Detailed_Description: Entity_Type: Entity_Type_Label: SPCMSC_samples_database.csv, SPCMSC Geologic Core and Sample Database Feature Layer (hosted) Entity_Type_Definition: A comprehensive inventory of geologic (coral, coral reef, limestone, and sediment) cores and samples collected, analyzed, published, and/or archived by, or in collaboration with, USGS SPCMSC. Fields in this database include, but are not limited to: sample identification, field activity number, sample type, sampling device, site name, collection date, associated publications, types of conducted analysis(es), geographic location (latitude/longitude), collection time, collecting agency, name(s) and contact information, sample disposition, storage location, and additional notes. Please read the entity and attribute information section below for the complete list and explanation of fields in this database. Entity_Type_Definition_Source: USGS Attribute: Attribute_Label: OBJECTID* Attribute_Definition: Internal feature number. Attribute_Definition_Source: Esri Attribute_Domain_Values: Unrepresentable_Domain: Sequential unique whole numbers that are automatically generated. *Present in the hosted feature layer. Attribute: Attribute_Label: pk_id Attribute_Definition: Primary key identifier. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: Sequential unique whole numbers (starting at 1) assigned to each sample or core upon database accession by USGS SPCMSC. Gaps may exist in the numbering, as not all numbered records are published, or some records may have been deleted. Attribute: Attribute_Label: field_activity_id Attribute_Definition: The field activity number of the sample collection. Blanks in this field indicate there is insufficient information regarding collection of the cores(s) or sample(s) needed in order to assign a field activity number in CMGDS. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the field activity number (FAN). This number ensures that CMHRP data management protocols were followed. If this field is blank, the FAN is either unknown or could not be assigned to a sample collection activity due to a lack of metadata. Some FANs were retroactively created and assigned after the field activity occurred. Please visit the specific FAN's CMGDS web page for more details about the field activity. Attribute: Attribute_Label: sample_id Attribute_Definition: Sample identifier assigned in the field. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the sample identification code assigned by the collecting agency or group. Attribute: Attribute_Label: sample_type Attribute_Definition: The type of sample collected in the field. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: core Enumerated_Domain_Value_Definition: A vertical sample of relatively undisturbed geologic material (coral, coral reef, limestone, or sediment) obtained using a coring device. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: surface Enumerated_Domain_Value_Definition: A sample collected at the surface of the geologic material. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: material Attribute_Definition: The type of geologic material contained in the sample or core. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: coral Enumerated_Domain_Value_Definition: The core or sample material is a coral skeleton. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: coral reef Enumerated_Domain_Value_Definition: The core or sample material is coral-reef framework, which can be composed of a combination of coral skeletons, reef sediment, and other calcium carbonate substrates. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: limestone Enumerated_Domain_Value_Definition: The core or sample material is consolidated calcium carbonate that is either not primarily composed of coral-reef framework or is composed of coral-reef framework that has been diagenetically altered to a secondary carbonate minerology. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: sediment Enumerated_Domain_Value_Definition: The core or sample material consists of unconsolidated sediment material. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: device Attribute_Definition: Device used to collect the geologic core or sample. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: auger Enumerated_Domain_Value_Definition: A type of auger coring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: borehole Enumerated_Domain_Value_Definition: A type of borehole coring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: box core Enumerated_Domain_Value_Definition: A box core device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: gravity core Enumerated_Domain_Value_Definition: A gravity core device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: hand sample Enumerated_Domain_Value_Definition: The sample was collected by hand. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: hydraulic coring drill Enumerated_Domain_Value_Definition: A hydraulic coring drill device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: miniSEABOSS Enumerated_Domain_Value_Definition: A miniSEABOSS device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: piston core Enumerated_Domain_Value_Definition: A type of piston coring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: ponar-type grab Enumerated_Domain_Value_Definition: A type of ponar grab was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: push core Enumerated_Domain_Value_Definition: A type of push coring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: rotary core Enumerated_Domain_Value_Definition: A type of rotary coring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: sediment tile Enumerated_Domain_Value_Definition: A type of sediment tile device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: sediment trap Enumerated_Domain_Value_Definition: A sediment trap device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: shovel Enumerated_Domain_Value_Definition: A shovel was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: surface grab Enumerated_Domain_Value_Definition: The sample was collected using a surface grab technique. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: unknown Enumerated_Domain_Value_Definition: The type of device used to collect the sample is not known. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Van Veen grab Enumerated_Domain_Value_Definition: A Van Veen grab device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: vibracore Enumerated_Domain_Value_Definition: A vibracoring device was used to collect the sample. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: age_range Attribute_Definition: The estimated age range of the sampled material for coral, coral reef, or limestone. Approximate age obtained through various laboratory methods performed on the sample material (for example, radiometric dating). Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: modern Enumerated_Domain_Value_Definition: The age of the core or sample is younger than 1950 CE (Common Era). Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: 0-10,000 years Enumerated_Domain_Value_Definition: The age of the core or sample is between 0 and 10,000 years before present, where "present" by radiocarbon convention is defined as 1950 CE. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: >10,000 years Enumerated_Domain_Value_Definition: The age of the core or sample is before 10,000 years before present, where "present" by radiocarbon convention is defined as 1950 CE. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: coral_species Attribute_Definition: The species of coral if the core or sample is of coral material. Blanks indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the binomial name of a coral species. If the species was identified, then the abbreviated genus with full species name schema was used. Example: C. natans. If a species was not identified, then the full genus name was used, followed by "spp." Example: Orbicella spp. Attribute: Attribute_Label: site_name Attribute_Definition: The name of the sampling site. Blanks indicate it is either unknown or not applicable for the sample or core. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the name of the sample site, which is assigned by the principal investigator. Attribute: Attribute_Label: core_number Attribute_Definition: The core identification number. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A combination of numeric or alphanumeric string containing the core number, which is assigned by the principal investigator. Attribute: Attribute_Label: date_collected Attribute_Definition: The date of sample collection. Blanks in this field indicate it is unknown. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: Date the sample was collected, in YYYYMMDD format. Some dates were approximated (to the month or year) due to a lack of available metadata. Attribute: Attribute_Label: length_cm Attribute_Definition: The length of the core collected. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: 1.5 Range_Domain_Maximum: 2835 Attribute_Units_of_Measure: centimeters Attribute: Attribute_Label: water_depth_m Attribute_Definition: The measured water depth at the location where the core or sample was collected. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: 0 Range_Domain_Maximum: 2259 Attribute_Units_of_Measure: meters Attribute: Attribute_Label: publish Attribute_Definition: Indicates whether the sample or core has associated publications. The publicly available database does not contain unpublished samples or cores. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: TRUE Enumerated_Domain_Value_Definition: The sample or core has an associated publication(s). Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: pub_url Attribute_Definition: Web URL to the applicable CMGDS field activity details page containing links to associated publication(s) pertaining to the sample or core. Some samples or cores originally published in the SPCMSC Core Archive Portal (Reich and others, 2012), did not have sufficient sample collection information for retroactive FAN assignment, and therefore do not have a URL in this field to a CMGDS field activity details page. Instead, a direct link to the associated publication(s), such as https://doi.org/10.3133/ds626, was used in this field. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the URL to the publication(s) or the list of publication(s) on the CMGDS field activity details page. Attribute: Attribute_Label: type_of_analyses Attribute_Definition: Indicates what types of analyses or scientific studies were conducted on the sample or core. The terms in this field are a controlled vocabulary from the USGS Thesaurus (https://apps.usgs.gov/thesaurus/). If multiple analyses were conducted on a core or sample, each are listed in alphabetical order, separated by commas. Blanks in this field indicate it is either unknown or not applicable. See the associated publication(s) for detailed information regarding conducted analyses. Attribute_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: age estimation methods Enumerated_Domain_Value_Definition: Methods used to determine the age of earth materials, typically by laboratory analysis of properties of those materials. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: atomic emission spectroscopy Enumerated_Domain_Value_Definition: Chemical detection of element concentration by examining the intensity and wavelength of light emitted from the sample when gaseous sample is ionized and maintained in a plasma state. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: bulk density Enumerated_Domain_Value_Definition: Overall density of an unconsolidated earth material. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: carbon-14 analysis Enumerated_Domain_Value_Definition: Method to determine the age of organic geologic and archaeological specimens, aged approximately 3,000 to 50,000 years, by determining the decay of the radioactive isotope carbon-14. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: carbon isotope analysis Enumerated_Domain_Value_Definition: Experimental determination of the proportion of a given stable carbon isotope (C12 or C13) in a sample. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: chemical analysis Enumerated_Domain_Value_Definition: Chemical techniques used to identify the composition of substances. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: contamination and pollution Enumerated_Domain_Value_Definition: Introduction of harmful substances into the environment by human action or natural processes. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: core analysis Enumerated_Domain_Value_Definition: Study of the composition and layers of cylindrical samples of rocks, trees, ice, and other materials extracted by drilling into a mass. Intended for broad use for the analysis of all types of core samples. The combination of this term with other terms will convey the context of the activity. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: CTD measurement Enumerated_Domain_Value_Definition: Instrumental determination of conductivity, temperature, and pressure as a function of depth to determine the salinity of seawater. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: faunal and floral census (microscopic) Enumerated_Domain_Value_Definition: Records of counts of the different microscopic species in a core, soil, sediment, rock or water sample to determine geologic age or other characteristic of the sample. Use for microscopic examinations. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: grain-size analysis Enumerated_Domain_Value_Definition: Method of studying soils, sediments, sands, or rock by determining the size, distribution, and proportion of selected particles. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: isotopic analysis Enumerated_Domain_Value_Definition: Experimental determination of the proportion of a given isotope (or isotopes) in a sample. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: laboratory methods Enumerated_Domain_Value_Definition: Techniques to analyze and test samples in a place equipped and designed for the work. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: light stable isotope analysis Enumerated_Domain_Value_Definition: Analytical technique using mass spectrometry to measure the different isotopic forms of low mass (light) elements such as oxygen, hydrogen, carbon, nitrogen and sulfur that occur in samples. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: luminescence dating Enumerated_Domain_Value_Definition: Dating methods that involve the analysis of the optical properties of minerals exposed to environmental radiation. Typically used to determine the age of subaerial exposure of surficial sediments. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: magnetic susceptibility Enumerated_Domain_Value_Definition: Nondestructive evaluation and location of magnetic materials in rock based on measuring the intensity of attraction of the materials to an induced magnetic field. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: mass spectroscopy Enumerated_Domain_Value_Definition: Instrumental technique to separate and identify molecules. Gaseous ions are formed, with or without fragmentation. Their mass/charge ratios and relative electrical abundance are then measured or the spectra are recorded. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: paleomagnetic analysis Enumerated_Domain_Value_Definition: Determination of the intensity and direction of residual magnetism in rocks to study changes in the earth's magnetic field during past geologic time. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: permeability Enumerated_Domain_Value_Definition: The ability of fluids to pass through an earth material, typically depending on the connectedness of pore space in the material. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: photography Enumerated_Domain_Value_Definition: Process of using digital or film cameras to collect images of objects. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: porosity Enumerated_Domain_Value_Definition: The proportion of open space in a rock or unconsolidated material. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: radiometric dating Enumerated_Domain_Value_Definition: Methods for age determination of rocks and fossils by measuring the proportions of naturally occurring radioactive isotopes to their decay products. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: salinity Enumerated_Domain_Value_Definition: Measure of the concentration of salts dissolved in a solution. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: sea surface temperature Enumerated_Domain_Value_Definition: Observed temperature of surface ocean waters, typically encompassing the entire mixed layer. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: stratigraphy Enumerated_Domain_Value_Definition: Branch of geology concerned with the study of the formation, composition, ordering in time, and arrangement in space of stratified rocks. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: tomography Enumerated_Domain_Value_Definition: Observation of the internal structure of an object or, as is more typical in USGS research, a cross section of the earth's crust by changing the relative orientation of a signal generator, a sensor, or both. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: water chemistry Enumerated_Domain_Value_Definition: Branch of chemistry that deals with the elements and compounds in water. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: water quality Enumerated_Domain_Value_Definition: The chemical, physical, and biological characteristics of water, usually in respect to its suitability for a particular purpose. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: x-ray diffraction Enumerated_Domain_Value_Definition: Study of crystals which uses short wave electromagnetic radiations (x-rays). The x-rays, scattered by the crystal atoms, show a characteristic interference pattern that is dependent upon the structure of the crystal. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: x-ray fluorescence Enumerated_Domain_Value_Definition: Estimation of chemical element concentration by measuring the energy level of secondary X-rays generated when the sample is bombarded with high-energy X-rays or gamma rays. Enumerated_Domain_Value_Definition_Source: USGS Thesaurus Attribute: Attribute_Label: latitude Attribute_Definition: The latitude coordinate for where the sample was collected. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: -3.2721 Range_Domain_Maximum: 46.74089256 Attribute_Units_of_Measure: decimal degrees Attribute: Attribute_Label: longitude Attribute_Definition: The longitude coordinate for where the sample was collected. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: -124.0468823 Range_Domain_Maximum: 162.25 Attribute_Units_of_Measure: decimal degrees Attribute: Attribute_Label: reef_tract Attribute_Definition: A description of the reef tract where the coral, coral reef, or limestone core or sample was collected, defined by the principal investigator. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the reef tract name. Attribute: Attribute_Label: time_collected Attribute_Definition: The time of sample collection. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: Time the sample was collected in HH:MM format (time zone is local and dependent on the area of study). Attribute: Attribute_Label: diameter_cm Attribute_Definition: The diameter (in centimeters) of the core or sample. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: 0.76 Range_Domain_Maximum: 15 Attribute_Units_of_Measure: centimeters Attribute: Attribute_Label: compaction_m Attribute_Definition: The measured compaction (in meters) of the core or sample. Blanks in this field indicate it is either unknown or not applicable. Attribute_Definition_Source: USGS Attribute_Domain_Values: Range_Domain: Range_Domain_Minimum: 0 Range_Domain_Maximum: 2.77 Attribute_Units_of_Measure: meters Attribute: Attribute_Label: agency Attribute_Definition: Name of the agency that collected the sample. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: USGS Enumerated_Domain_Value_Definition: U.S. Geological Survey Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: USDA-NRCS Enumerated_Domain_Value_Definition: United States Department of Agriculture-Natural Resources Conservation Service Enumerated_Domain_Value_Definition_Source: USDA-NRCS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: LDNR Enumerated_Domain_Value_Definition: Louisiana Department of Natural Resources Enumerated_Domain_Value_Definition_Source: LDNR Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Ocean-Seis Enumerated_Domain_Value_Definition: Ocean-Seismic Survey, Inc. Enumerated_Domain_Value_Definition_Source: Ocean-Seis Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: USACE Enumerated_Domain_Value_Definition: U.S. Army Corp of Engineers Enumerated_Domain_Value_Definition_Source: USACE Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Nova Southeastern University Enumerated_Domain_Value_Definition: Nova Southeastern University Enumerated_Domain_Value_Definition_Source: Nova Southeastern University Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: unknown Enumerated_Domain_Value_Definition: Collecting agency is unknown. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: VIMS Enumerated_Domain_Value_Definition: Virginia Institute of Marine Science Enumerated_Domain_Value_Definition_Source: VIMS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Dial Cordy & Associates, Inc. Enumerated_Domain_Value_Definition: Dial Cordy & Associates, Inc. environmental consulting firm Enumerated_Domain_Value_Definition_Source: Dial Cordy & Associates, Inc. Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Florida Atlantic University Enumerated_Domain_Value_Definition: Florida Atlantic University Enumerated_Domain_Value_Definition_Source: FAU Attribute: Attribute_Label: platform Attribute_Definition: Ship or vessel (if aquatic), or terrestrial platform upon which the sample or core was collected when known. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the ship or vessel name, if aquatic collection. If a terrestrial collection, the vehicle name, or "on foot" label was used. Field value has been entered as "unknown" if the collecting platform is not known. Attribute: Attribute_Label: pi_name Attribute_Definition: The name(s) of the principal investigators(s) who were responsible for core or field collection. Field value has been entered as "unknown" if the principal investigator is not known. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing principal investigator name(s) by last name, first name. If multiple names are listed, each full name is separated by a semicolon. Attribute: Attribute_Label: pi_email Attribute_Definition: The email address(es) of the principal investigator(s) who were responsible for field collection. Blanks in this field indicate the principal investigator is unknown or the sample or core is deaccessioned. Field value has been entered as "Contact curator" if the sample is archived, but the principal investigator is no longer with the USGS. In this case, users can refer to the curator's name and email for contact information. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing an email address(es). Attribute: Attribute_Label: disposition Attribute_Definition: Status of the sample after it was collected in the field. This field value is subject to change at any time, as the sample database is continually re-assessed and updated. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Active Enumerated_Domain_Value_Definition: The sample or core has been collected but has not been added to the archive, this may indicate it is still being actively processed or analyzed. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Archived Enumerated_Domain_Value_Definition: The sample or core is stored in a repository. See storage_facility field for more information. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Deaccessioned Enumerated_Domain_Value_Definition: The sample or core is no longer stored in a repository. The sample may have been destroyed, disposed of due to not meeting archival requirements (such as lack of adequate metadata), or consumed entirely during analysis. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: unknown Enumerated_Domain_Value_Definition: The disposition of the sample is currently not known. Please contact the sample curator for more information regarding the sample's disposition. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: in_collections Attribute_Definition: Indicates whether the sample or core is available in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection, or in an external repository. For more information, also see the disposition and storage_facility fields. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Yes Enumerated_Domain_Value_Definition: The sample or core is currently stored at USGS SPCMSC, in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection, or elsewhere within the center. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: No Enumerated_Domain_Value_Definition: The sample or core is not stored at USGS SPCMSC, in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection, or elsewhere within the center. The sample may be deaccessioned or located in an external repository, please see the disposition and storage_facility fields for more information. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: unknown Enumerated_Domain_Value_Definition: The location of the sample or core in an archival repository is not known at this time. Enumerated_Domain_Value_Definition_Source: USGS Attribute: Attribute_Label: curator_name Attribute_Definition: The name of the person who has responsibility for the sample or core located in the repository. This person is the point of contact for data inquiries. Blanks in this field indicate the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing curator name(s) by last name, first name. Attribute: Attribute_Label: curator_email Attribute_Definition: The email address of the person who has responsibility for the sample or core in the repository. This email address can be used for data inquiries. Blanks in this field indicate the sample or core has been deaccessioned. All known information for the sample or core is available in this database and accompanying publications. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing an email address. Attribute: Attribute_Label: storage_facility Attribute_Definition: The name of the organization or storage facility where the archived sample or core is located. Blanks in this field indicate it is either unknown, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing the organization or storage facility name. Attribute: Attribute_Label: room Attribute_Definition: The room in the storage facility where the archived sample or core is located at USGS SPCMSC. Blanks in this field indicate the room location is either unknown, not applicable, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing information regarding storage location. Attribute: Attribute_Label: floor Attribute_Definition: The floor in the storage facility where the archived sample or core is located. This field is only applicable to samples archived in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection. Blanks in this field indicate the floor is either unknown, not applicable, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing information regarding storage location. Attribute: Attribute_Label: stack_wall Attribute_Definition: The stack or wall number in the storage facility where the archived sample or core is located. This field is only applicable to samples or cores archived in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection. Blanks in this field indicate it is either unknown, not applicable, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing information regarding storage location. Attribute: Attribute_Label: column Attribute_Definition: The column of shelves in the storage location where the archived sample or core is located. This field is only applicable to samples or cores archived in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection. Blanks in this field indicate it is either unknown, not applicable, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing information regarding storage location. Attribute: Attribute_Label: row Attribute_Definition: The row of shelves in the storage location where the archived sample or core is located. This field is only applicable to samples or cores archived in the USGS SPCMSC Geologic Core and Sample Physical Storage Collection. Blanks in this field indicate it is either unknown, not applicable, or the sample or core is deaccessioned. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing information regarding storage location. Attribute: Attribute_Label: field_activity_url Attribute_Definition: Web URL to the applicable CMGDS field activity details page containing field activity information and links to associated publication(s) pertaining to the sample or core. Blanks in this field indicate there was insufficient field collection information needed for retroactive FAN assignment. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing a URL. Attribute: Attribute_Label: notes Attribute_Definition: Additional information about the sample or core that may be of interest. Attribute_Definition_Source: USGS Attribute_Domain_Values: Unrepresentable_Domain: A text string containing notes regarding the sample or core. Attribute: Attribute_Label: geog_approx Attribute_Definition: Indicates if the geographic coordinates used to identify the location of sample collected are approximate and did not use modern GPS technology, the location was identified using a map, or some other geographic approximation method. Attribute_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: Yes Enumerated_Domain_Value_Definition: Geographic coordinates are considered approximate. Enumerated_Domain_Value_Definition_Source: USGS Attribute_Domain_Values: Enumerated_Domain: Enumerated_Domain_Value: No Enumerated_Domain_Value_Definition: Geographic coordinates are not considered approximate. Enumerated_Domain_Value_Definition_Source: USGS Distribution_Information: Distributor: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: USGS SPCMSC Data Management Group Contact_Position: Data Management Contact_Address: Address_Type: physical and mailing Address: 600 4th Street South City: St. Petersburg State_or_Province: Florida Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: gs-g-spcmsc_data_inquiries@usgs.gov Distribution_Liability: This publication was prepared by an agency of the United States Government. Although these data have been processed successfully on a computer system at the U.S. Geological Survey, no warranty expressed or implied is made regarding the display or utility of the data on any other system, nor shall the act of distribution imply any such warranty. The U.S. Geological Survey shall not be held liable for improper or incorrect use of the data described and (or) contained herein. Reference herein to any specific commercial product, process, or service by trade name, trademark, manufacturer, or otherwise does not constitute or imply its endorsement, recommendation, or favoring by the United States Government or any agency thereof. Standard_Order_Process: Digital_Form: Digital_Transfer_Information: Format_Name: feature services, comma-delimited text, Microsoft Word document File_Decompression_Technique: ZIP Digital_Transfer_Option: Online_Option: Computer_Contact_Information: Network_Address: Network_Resource_Name: https://doi.org/10.5066/F7319TR3 Network_Resource_Name: https://usgs.maps.arcgis.com/home/item.html?id=4add5d8cbc9f4ea48c8797b859a53491 Network_Resource_Name: https://usgs.maps.arcgis.com/home/item.html?id=a5d63eeb709d49b188a260c70376fb94 Network_Resource_Name: https://usgs.maps.arcgis.com/home/item.html?id=3012a799c82e486fb2c25751bd605962 Fees: None, if obtained online Metadata_Reference_Information: Metadata_Date: 20220914 Metadata_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey - St. Petersburg Coastal and Marine Science Center Contact_Person: Breanna Williams Contact_Position: Geographer Contact_Address: Address_Type: mailing and physical Address: 600 4th Street South City: St. Petersburg State_or_Province: FL Postal_Code: 33701 Country: USA Contact_Voice_Telephone: 727-502-8000 Contact_Electronic_Mail_Address: bnwilliams@usgs.gov Metadata_Standard_Name: Content Standard for Digital Geospatial Metadata Metadata_Standard_Version: FGDC-STD-001-1998 Metadata_Time_Convention: local time