<?xml version="1.0" encoding="UTF-8"?>
<inport-metadata xmlns:xs="http://www.w3.org/2001/XMLSchema"
                 version="1.11"
                 source="https://www.fisheries.noaa.gov">
   <item-identification>
      <catalog-item-id>36762</catalog-item-id>
      <title>ESD_NCRMP_CTD_DataDictionary_SAMOA</title>
      <short-name>CTD Entity</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>36761</parent-catalog-item-id>
      <parent-title>National Coral Reef Monitoring Program: Shallow Water Conductivity-Temperature-Depth (CTD) Profiles for select locations across American Samoa from 2015 to 2023</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <abstract>Conductivity-Temperature-Depth Entity and Attributes</abstract>
   </item-identification>
   <entity-information>
      <entity-type>Spreadsheet</entity-type>
      <active-version>Yes</active-version>
      <description>Conductivity-Temperature-Depth Entity</description>
      <change-summary>As of 2018, these are the active / relevant fields: 

SHALLOWCTDID, CTDDATAKEY, CTDCASTID, ASSOC_OCC_SITEID, ASSOC_REA_SITE, CRUISE, REGIONCODE, REGION, LOCATIONCODE, LOCATION, LATITUDE, LONGITUDE, UTCDATETIME, CASTYEAR, WATERSAMPLE, OFFSHORE_YN, SURVEY_DESIGN, PRESSURE_DB, DEPTH_M, TEMP_DEGC, COND_S_PER_M, SALN_PSU, DENSITY_SIGMAT

In 2023, CTDDATAKEY was updated to CTDDATAID , SHALLOWCTDID updated to CTDCASTNAME.</change-summary>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="1044661">
         <seq-order>1</seq-order>
         <name>CTDCASTNAME</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Unique ID for CTDCASTID: typically cruise/MISSION ID, last 4 digits of CTD serial number, date and cast number/id.</description>
      </data-attribute>
      <data-attribute cc-id="1044639">
         <seq-order>2</seq-order>
         <name>CTDDATAID</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Unique numeric ID for each depth bin within a CTD cast (6-digit number).
</description>
      </data-attribute>
      <data-attribute cc-id="1044640">
         <seq-order>3</seq-order>
         <name>CTDCASTID</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Unique numeric ID of CTD cast (4-digit number).</description>
      </data-attribute>
      <data-attribute cc-id="1044641">
         <seq-order>4</seq-order>
         <name>ASSOC_OCC_SITEID</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>An identifier for the fixed climate site associated with the CTD cast, if any. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed NCRMP climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number. CTD casts are assigned an associated OCC_SITEID (ASSOC_OCC_SITEID) rather than an OCC_SITEID because the CTD profile includes the entire water column rather than a single depth on the benthos. A CTD cast is assigned an ASSOC_OCC_SITEID only if its coordinates are within a 150-m radius of a pre-existing OCC_SITEID; otherwise, no ASSOC_OCC_SITEID is assigned.</description>
      </data-attribute>
      <data-attribute cc-id="1044642">
         <seq-order>5</seq-order>
         <name>ASSOC_REA_SITE</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>An identifier for the ecological site at the island or atoll (LOCATION) associated with the CTD cast. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.</description>
      </data-attribute>
      <data-attribute cc-id="1044643">
         <seq-order>6</seq-order>
         <name>CRUISE</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Mission identifier.
</description>
      </data-attribute>
      <data-attribute cc-id="1044644">
         <seq-order>7</seq-order>
         <name>REGIONCODE</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Code for REGION.</description>
      </data-attribute>
      <data-attribute cc-id="1044645">
         <seq-order>8</seq-order>
         <name>REGION</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>The name of the region where the CTD cast was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.</description>
      </data-attribute>
      <data-attribute cc-id="1044646">
         <seq-order>9</seq-order>
         <name>LOCATIONCODE</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>3-Letter unique code for LOCATION.</description>
      </data-attribute>
      <data-attribute cc-id="1044647">
         <seq-order>10</seq-order>
         <name>LOCATION</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Name of island or atoll where the CTD cast was conducted in the Pacific Islands region (REGION).</description>
      </data-attribute>
      <data-attribute cc-id="1044648">
         <seq-order>11</seq-order>
         <name>LATITUDE</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Latitude in decimal degrees, WGS84, for the CTD cast.</description>
      </data-attribute>
      <data-attribute cc-id="1044649">
         <seq-order>12</seq-order>
         <name>LONGITUDE</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Longitude in decimal degrees, WGS84, for the CTD cast.
</description>
      </data-attribute>
      <data-attribute cc-id="1044650">
         <seq-order>13</seq-order>
         <name>UTCDATETIME</name>
         <data-storage-type>DATE</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>UTC date and time of CTD cast (yyyy-mm-dd hh:mm:ss).</description>
      </data-attribute>
      <data-attribute cc-id="1044651">
         <seq-order>14</seq-order>
         <name>CASTYEAR</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>4-digit year the CTD cast was conducted (UTCDATETIME).</description>
      </data-attribute>
      <data-attribute cc-id="1044652">
         <seq-order>15</seq-order>
         <name>WATERSAMPLE</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>A discrete water sample was/was not (TRUE/FALSE) collected in conjunction with the CTD cast.
</description>
      </data-attribute>
      <data-attribute cc-id="1044653">
         <seq-order>16</seq-order>
         <name>OFFSHORE_YN</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>CTD cast was/was not (YES/NO) conducted offshore, where offshore is defined as a cast location (LATITUDE and LONGITUDE) more than 10km away from land (for islands) or the 20m depth contour (for atolls).</description>
      </data-attribute>
      <data-attribute cc-id="1044654">
         <seq-order>17</seq-order>
         <name>SURVEY_DESIGN</name>
         <data-storage-type>TEXT</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>	NCRMP survey design associated with the CTD cast. Survey designs include: casts conducted at permanent climate sites (Permanent); casts co-located with fish or benthic stratified random survey sites (Stratified_Random); casts at random sites not associated with climate, benthic, or fish sites (Random); and casts conducted offshore to collect end member data (End_member).</description>
      </data-attribute>
      <data-attribute cc-id="1044655">
         <seq-order>18</seq-order>
         <name>PRESSURE_DB</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Measured pressure value in decibars.
</description>
      </data-attribute>
      <data-attribute cc-id="1044656">
         <seq-order>19</seq-order>
         <name>DEPTH_M</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Calculated depth value in meters.
</description>
      </data-attribute>
      <data-attribute cc-id="1044657">
         <seq-order>20</seq-order>
         <name>TEMP_DEGC</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Measured temperature value in degrees Celsius.</description>
      </data-attribute>
      <data-attribute cc-id="1044658">
         <seq-order>21</seq-order>
         <name>COND_S_PER_M</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Measured conductivity value in Siemens per meter.</description>
      </data-attribute>
      <data-attribute cc-id="1044659">
         <seq-order>22</seq-order>
         <name>SALN_PSU</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Calculated salinity value in Practical Salinity Units (PSU).
</description>
      </data-attribute>
      <data-attribute cc-id="1044819">
         <seq-order>23</seq-order>
         <name>DENSITY_SIGMAT</name>
         <data-storage-type>NUMERIC</data-storage-type>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms / cubic meter.</description>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:36762</guid>
      <metadata-record-created-by pers-id="13169">Kevin Trick</metadata-record-created-by>
      <metadata-record-created>2017-02-10T18:56:04</metadata-record-created>
      <metadata-record-last-modified-by pers-id="22115">Lori Luers</metadata-record-last-modified-by>
      <metadata-record-last-modified>2025-01-21T19:18:49</metadata-record-last-modified>
      <record-published>2025-01-21</record-published>
      <owner-organization>Pacific Islands Fisheries Science Center</owner-organization>
      <owner-organization-acronym>PIFSC</owner-organization-acronym>
      <owner-organization-address>1845 Wasp Blvd.</owner-organization-address>
      <owner-organization-address-city>Honolulu</owner-organization-address-city>
      <owner-organization-address-state>HI</owner-organization-address-state>
      <owner-organization-address-zip>96818</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone>808-725-5300</owner-organization-phone>
      <owner-organization-url>https://www.pifsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>8:00 a.m. - 4:30 p.m.</owner-organization-business-hours>
      <owner-organization-group-id>1001</owner-organization-group-id>
      <publication-status>Public</publication-status>
      <is-do-not-publish>No</is-do-not-publish>
      <metadata-last-review-date>2021-03-10</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2022-03-10</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
