<?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>36220</catalog-item-id>
      <title>Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data</title>
      <short-name>Physical and Biological Effects of Fish-friendly Tide Gates Site Details Data Logger Sensor Data</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>18067</parent-catalog-item-id>
      <parent-title>Data logger database - Physical and biological effects of fish-friendly tide gates</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <status>Planned</status>
      <abstract>Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.</abstract>
   </item-identification>
   <entity-information>
      <entity-type>Data Table</entity-type>
      <active-version>Yes</active-version>
      <schema>PARR</schema>
      <description>Continuous sensor data from three two-week observation periods at each site, including water level, salinity, and temperature at one-minute intervals above and below each culvert and vault, and at each reference channel.</description>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="733162">
         <seq-order>1</seq-order>
         <name>ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Record ID.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="733163">
         <seq-order>2</seq-order>
         <name>Site</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>255</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Site name (see Site Details table for more information on each site).</description>
         <general-data-type>VARCHAR2</general-data-type>
         <format-mask>@</format-mask>
      </data-attribute>
      <data-attribute cc-id="733164">
         <seq-order>3</seq-order>
         <name>Date</name>
         <data-storage-type>DATE</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Date of observation.</description>
         <general-data-type>DATE</general-data-type>
         <format-mask>m/d/yyyy</format-mask>
      </data-attribute>
      <data-attribute cc-id="733165">
         <seq-order>4</seq-order>
         <name>Time</name>
         <data-storage-type>DATE</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Time of observation.</description>
         <general-data-type>DATE</general-data-type>
         <format-mask>Short Time</format-mask>
      </data-attribute>
      <data-attribute cc-id="733166">
         <seq-order>5</seq-order>
         <name>DCE</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Id number of data collection event, with each site having been sampled three intervals during 2011.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733167">
         <seq-order>6</seq-order>
         <name>Upstream Water Elevation (NAVD88 meters)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Measured elevation of water immediately upstream of the structure in NAVD88.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>Fixed</format-mask>
      </data-attribute>
      <data-attribute cc-id="733168">
         <seq-order>7</seq-order>
         <name>Downstream Water Elevation (NAVD88 meters)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Measured elevation of water immediately downstrem of the structure in NAVD88.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>Fixed</format-mask>
      </data-attribute>
      <data-attribute cc-id="733169">
         <seq-order>8</seq-order>
         <name>Downstream Water Elevation and Perch Elevation Difference (m)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Downstream water elevation relative to the elevation of the downstream interior floor of the structure (perch elevation), with negative values indicating that the structure is perched and a water fall has formed at the structure mouth.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>Fixed</format-mask>
      </data-attribute>
      <data-attribute cc-id="733170">
         <seq-order>9</seq-order>
         <name>Inside Depth (m)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Water depth inside the structure.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="733171">
         <seq-order>10</seq-order>
         <name>Tilt (degree)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Angle readings from tilt sensors used to determine when gate doors opened and closed. Values do not necessarily coorespond with actual angles of the door positions.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0.0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733172">
         <seq-order>11</seq-order>
         <name>Gate</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>255</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Classification of the gate door position based on the tilt data.</description>
         <general-data-type>VARCHAR2</general-data-type>
         <format-mask>0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733173">
         <seq-order>12</seq-order>
         <name>Temperature Upstream (C)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Water temperature upstream of the structure.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0.0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733174">
         <seq-order>13</seq-order>
         <name>Salinity Upstream (ppt)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Water salinity upstream of the structure.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0.0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733175">
         <seq-order>14</seq-order>
         <name>Temperature Downstream (C)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Water temperature downstream of the structure.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0.0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733176">
         <seq-order>15</seq-order>
         <name>Salinity Downstream (ppt)</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Water salinity downstream of the structure.</description>
         <general-data-type>NUMBER</general-data-type>
         <format-mask>0.0</format-mask>
      </data-attribute>
      <data-attribute cc-id="733177">
         <seq-order>16</seq-order>
         <name>TideGage</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>255</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Name of closest tide gage station.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="733178">
         <seq-order>17</seq-order>
         <name>Tide_m</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Tide height in meters - not corrected for local lags between tide gage and site.</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="733179">
         <seq-order>18</seq-order>
         <name>Tide</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>255</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Classification of tidal stage as ebbing or flooding.</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:36220</guid>
      <metadata-record-created-by pers-id="4250">Jeffrey Cowen</metadata-record-created-by>
      <metadata-record-created>2017-01-06T11:02:01</metadata-record-created>
      <metadata-record-last-modified-by pers-id="0">SysAdmin InPortAdmin</metadata-record-last-modified-by>
      <metadata-record-last-modified>2022-08-09T17:11:17</metadata-record-last-modified>
      <record-published>2018-02-27</record-published>
      <owner-organization>Northwest Fisheries Science Center</owner-organization>
      <owner-organization-acronym>NWFSC</owner-organization-acronym>
      <owner-organization-address>2725 Montlake Boulevard East</owner-organization-address>
      <owner-organization-address-city>Seattle</owner-organization-address-city>
      <owner-organization-address-state>WA</owner-organization-address-state>
      <owner-organization-address-zip>98112</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone>206-860-3200</owner-organization-phone>
      <owner-organization-url>https://www.nwfsc.noaa.gov</owner-organization-url>
      <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>2018-02-27</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2019-02-27</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
