Metadata: Identification_Information: Citation: Citation_Information: Originator: Andrew W. Stevens Originator: Shailesh van de Steeg Originator: Susan A. Wherry Originator: Tamara M. Wood Publication_Date: 20210409 Title: Hydrodynamic model of the lower Columbia River, Oregon and Washington, 2017-2020 Geospatial_Data_Presentation_Form: text Series_Information: Series_Name: data release Issue_Identification: DOI:10.5066/P9ESBJQ0 Publication_Information: Publication_Place: Pacific Coastal and Marine Science Center, Santa Cruz, California Publisher: U.S. Geological Survey Online_Linkage: https://doi.org/10.5066/P9ESBJQ0 Description: Abstract: A three-dimensional hydrodynamic model of the lower Columbia River (LCR) was constructed using the Delft3D Flexible Mesh (DFM) modeling suite to simulate water levels, flow, and seabed stresses for time period of January 1, 2017 to April 20, 2020. This data release describes the construction and validation of the model application and provides input files suitable to run the model on Delft3D Flexible Mesh software version 2021.01. Purpose: The hydrodynamic model was constructed to investigate tidal propagation and circulation of the lower Columbia River. Supplemental_Information: Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government. Time_Period_of_Content: Time_Period_Information: Range_of_Dates/Times: Beginning_Date: 20170101 Ending_Date: 20200401 Currentness_Reference: ground condition at time data were collected Status: Progress: Complete Maintenance_and_Update_Frequency: Not planned Spatial_Domain: Bounding_Coordinates: West_Bounding_Coordinate: -125.941041 East_Bounding_Coordinate: -121.963307 North_Bounding_Coordinate: 47.475717 South_Bounding_Coordinate: 44.979972 Keywords: Theme: Theme_Keyword_Thesaurus: USGS Thesaurus Theme_Keyword: marine water quality Theme_Keyword: coastal processes Theme_Keyword: water circulation Theme: Theme_Keyword_Thesaurus: ISO 19115 Topic Category Theme_Keyword: oceans Theme: Theme_Keyword_Thesaurus: Data Categories for Marine Planning Theme_Keyword: water column features Theme: Theme_Keyword_Thesaurus: Marine Realms Information Bank (MRIB) keywords Theme_Keyword: numerical modeling Theme: Theme_Keyword_Thesaurus: None Theme_Keyword: U.S. Geological Survey Theme_Keyword: USGS Theme_Keyword: Coastal and Marine Hazards and Resources Program Theme_Keyword: CMHRP Theme_Keyword: Pacific Coastal and Marine Science Center Theme_Keyword: PCMSC Theme: Theme_Keyword_Thesaurus: USGS Metadata Identifier Theme_Keyword: USGS:5ff4b239d34ea5387df03099 Place: Place_Keyword_Thesaurus: Geographic Names Information System (GNIS) Place_Keyword: Pacific Ocean Place_Keyword: Columbia River Place_Keyword: State of Washington Place_Keyword: State of Oregon Access_Constraints: none Use_Constraints: USGS-authored or produced data and information are in the public domain from the U.S. Government and are freely redistributable with proper metadata and source attribution. Please recognize and acknowledge the U.S. Geological Survey as the originator(s) of the dataset and in products derived from these data. This information is not intended for navigational purposes. Point_of_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: PCMSC Science Data Coordinator Contact_Organization: U.S. Geological Survey, Pacific Coastal and Marine Science Center Contact_Address: Address_Type: mailing and physical Address: 2885 Mission Street City: Santa Cruz State_or_Province: CA Postal_Code: 95060 Contact_Voice_Telephone: 831-427-4747 Contact_Electronic_Mail_Address: pcmsc_data@usgs.gov Browse_Graphic: Browse_Graphic_File_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=dfm_bathy_with_detail.png&allowOpen=true Browse_Graphic_File_Description: Map of model bathymetry showing A, overall model domain, and B, detail area showing the lower Columbia River. Locations of data sources used for validation of water levels (circles) and discharges (triangles) are shown in B. Browse_Graphic_File_Type: PNG Browse_Graphic: Browse_Graphic_File_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=dfm_boundaries.png&allowOpen=true Browse_Graphic_File_Description: Time series of A, water levels and non-tidal residual water levels applied to the oceanic boundary and, B, time series of river discharges applied to the fluvial boundaries of the lower Columbia River model. Browse_Graphic_File_Type: PNG Browse_Graphic: Browse_Graphic_File_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=cr_fm_wl_q_target.png&allowOpen=true Browse_Graphic_File_Description: Target diagram showing bulk statistics describing comparisons between modeled and measured A, water levels, and B, discharge computed between January 1, 2017, and April 20, 2020. Browse_Graphic_File_Type: PNG Browse_Graphic: Browse_Graphic_File_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=cr_fm_rkm_ttide_longterm.png&allowOpen=true Browse_Graphic_File_Description: Comparison of modeled and measured tidal propagation showing A, map of observation locations, B, amplitudes, and C, phases of modeled (lines) and measured (markers) M2, K1, and O1 tidal constituents between the river mouth and 200 km upstream. Along channel distances at 50-km intervals are denoted in A. Browse_Graphic_File_Type: PNG Native_Data_Set_Environment: Matlab version 9.8.0.1396136 running on Microsoft Windows 10 Cross_Reference: Citation_Information: Originator: Shailesh van der Steeg Publication_Date: 2016 Title: Investigations of tidal hydrodynamics in the lower Columbia River and estuary (Masters thesis) Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Delft, Netherlands Publisher: Delft University of Technology Cross_Reference: Citation_Information: Originator: Susan A. Wherry Originator: Tamara M. Wood Originator: Hans R. Moritz Originator: Keith B. Duffy Publication_Date: 2019 Title: Assessment of Columbia and Willamette River flood stage on the Columbia Corridor Levee System at Portland, Oregon, in a future climate Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Reston, Virginia Publisher: U.S. Geological Survey Scientific Investigations Report 2018-5161 Online_Linkage: https://doi.org/10.3133/sir20185161 Cross_Reference: Citation_Information: Originator: Florent Lyard Originator: Fabien Lefevre Originator: Thierry Letellier Originator: Oliver Francis Publication_Date: 2006 Title: Modelling the global ocean tides: modern insights from FES2004 Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: New York, New York Publisher: Ocean Dynamics Online_Linkage: https://doi.org/10.1007/s10236-006-0086-x Cross_Reference: Citation_Information: Originator: General bathymetric chart of the oceans Publication_Date: 2018 Title: Gridded bathymetry data Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Monaco Publisher: International Hydrographic Organization and the Intergovernmental Oceanographic Commission database Online_Linkage: https://www.gebco.net/data_and_products/gridded_bathymetry_data/ Cross_Reference: Citation_Information: Originator: Jason K. Jolliff Originator: John C. Kindle Originator: Igor Shulman Originator: Bradley Penta Originator: Marjorie A.M. Friedrichs Originator: Robert Helber Originator: Robert A. Arnone Publication_Date: 2009 Title: Summary diagrams for coupled hydrodynamic-ecosystem model skill assessment Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Amsterdam, Netherlands Publisher: Journal of Marine Systems Online_Linkage: https://doi.org/10.1016/j.jmarsys.2008.05.014 Cross_Reference: Citation_Information: Originator: Rich Pawlowicz Originator: Bob Beardsley Originator: Steve Lentz Publication_Date: 2002 Title: Classical tidal harmonic analysis including error estimates in MATLAB using T_TIDE Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Amsterdam, Netherlands Publisher: Computers and Geosciences Online_Linkage: https://doi.org/10.1016/S0098-3004(02)00013-4 Cross_Reference: Citation_Information: Originator: Deltares Publication_Date: 2020 Title: D-Flow Flexible Mesh User Manual (version 0.9.1) Geospatial_Data_Presentation_Form: comma-delimited text Publication_Information: Publication_Place: Delft, Netherlands Publisher: Deltares Online_Linkage: https://oss.deltares.nl/web/delft3dfm/manuals Data_Quality_Information: Attribute_Accuracy: Attribute_Accuracy_Report: Model outputs were compared to observed water levels and discharges to assess the accuracy of simulated results as described in the process steps below. Logical_Consistency_Report: All data falls within expected ranges. Completeness_Report: Dataset is considered complete for the information presented, as described in the abstract. Users are advised to read the rest of the metadata record carefully for additional details. Positional_Accuracy: Horizontal_Positional_Accuracy: Horizontal_Positional_Accuracy_Report: No formal positional accuracy tests were conducted. Vertical_Positional_Accuracy: Vertical_Positional_Accuracy_Report: No formal positional accuracy tests were conducted. Lineage: Process_Step: Process_Description: A three-dimensional hydrodynamic model of the lower Columbia River (LCR) constructed using the Delft3D Flexible Mesh (DFM) modeling suite (Deltares, 2020) was used to simulate water levels, flow, and seabed stresses between January 1, 2017 and April 20, 2020. The model application was adapted from van der Steeg (2016) and Wherry and others (2019). The model domain extends between the Bonneville Dam at its upstream limit to about 130 km offshore of the river mouth in the Pacific Ocean. Ten equally spaced vertical sigma layers were used to simulate 3D effects within the model domain. A high resolution digital elevation model constructed from recent topographic lidar and bathymetry data was used for the model bathymetry (http://www.estuarypartnership.org/lower-columbia-digital-terrain-model). Offshore bathymetry was derived from the General Bathymetric Chart of the Oceans (General Bathymetric Chart of the Oceans, 2018). Over 250 levees, stone jetties, and pile dikes were prescribed as sub-grid weirs with 0 transmission throughout the model domain. Roughness in the model was prescribed using a Chezy value of 65 for the ocean and lower estuary and a value of 70 farther upstream. Oceanic boundaries of the LCR model were forced using astronomic tidal constituents derived from the satellite-derived FES 2012 global tide model (Lyard and others, 2006). A vertical offset of 1.21 m (positive up) was applied at the oceanic boundary to account for the difference between local mean sea level and NAVD88 based on the tidal datum at nearby Toke Point, WA (NOAA station 9440910). Oceanic subtidal variations were imposed at the oceanic open boundary as a time-varying correction to the astronomic tides. The subtidal time-series was derived from observations of water levels at NOAA stations 9440910 (Toke Point, WA) and 9437540 (Garibaldi, OR). Water level time series from the two stations were low-pass filtered with a 66-hr cutoff to remove fluctuations at tidal frequencies. The low pass filtered values from both stations were highly correlated and an average for the two stations was applied to the oceanic model boundaries. Upstream, fluvial discharges from the main stem Columbia River, Cowlitz, Lewis, Willamette, and Sandy Rivers were prescribed based on observations made at various USGS gauge stations. The oceanic and fluvial boundaries were prescribed constant salinity values of 33 and 0 PSU, respectively. The effects of variations of temperature, wind, and waves on circulation and enhanced bed stresses were neglected in the present model application. Process_Date: 20200702 Process_Step: Process_Description: Simulated water levels and discharges were compared against time-series measurements of observed water levels from locations throughout the study area. All water level observations were converted to a common vertical datum (NAVD88) and water level and discharge data were interpolated in time from the native measurement interval (between 6 and 15 minutes depending on site) to the 10-minute output interval that was available for model simulations. Bulk error metrics describing the comparisons between model and observations over the entire simulation time frame (January 2017 to April 2020) were calculated following Jolliff and others (2009). Total root-mean-square error (RMSE) was less than 20 cm for water levels at all of the measurement sites. However, peak water levels were underestimated by as much as 0.75 m during high river discharge at Vancouver despite slightly overestimating total discharge at that location. Process_Date: 20200817 Process_Step: Process_Description: Harmonic tidal analysis on the simulated and observed water levels (Pawlowicz and others, 2002) over the analysis time frame was performed to validate model predictions of tidal propagation into the estuary and tidal river. The model accurately predicts the initial amplification of the M2 tidal constituent between the river mouth and Astoria tide gauge and subsequent decay farther upstream. The predicted phase of the M2 tidal constituent initially agrees well with observed values, but the simulated tidal wave is slower than observed upstream of the Wauna tide gauge. Further investigation is needed to determine the cause of the discrepancy and improve model predictions. Other major tidal constituents including K1, O1, and N2 were adequately characterized in the model simulation. Process_Date: 20210105 Spatial_Data_Organization_Information: Direct_Spatial_Reference_Method: Point Point_and_Vector_Object_Information: SDTS_Terms_Description: SDTS_Point_and_Vector_Object_Type: Point Point_and_Vector_Object_Count: 35626 Spatial_Reference_Information: Horizontal_Coordinate_System_Definition: Planar: Grid_Coordinate_System: Grid_Coordinate_System_Name: Universal Transverse Mercator Universal_Transverse_Mercator: UTM_Zone_Number: 10 Transverse_Mercator: Scale_Factor_at_Central_Meridian: 0.9996 Longitude_of_Central_Meridian: -123.0 Latitude_of_Projection_Origin: 0.0 False_Easting: 500000.0 False_Northing: 0.0 Planar_Coordinate_Information: Planar_Coordinate_Encoding_Method: row and column Coordinate_Representation: Abscissa_Resolution: 78 Ordinate_Resolution: 38 Planar_Distance_Units: Meter Geodetic_Model: Horizontal_Datum_Name: North American Datum of 1983 Ellipsoid_Name: GRS_1980 Semi-major_Axis: 6378137.0 Denominator_of_Flattening_Ratio: 298.257222101 Vertical_Coordinate_System_Definition: Altitude_System_Definition: Altitude_Datum_Name: North American Vertical Datum of 1988 Altitude_Resolution: 0.01 Altitude_Distance_Units: meters Altitude_Encoding_Method: Explicit elevation coordinate included with horizontal coordinates Entity_and_Attribute_Information: Overview_Description: Entity_and_Attribute_Overview: Compressed .zip archive contains files of various types and formats Entity_and_Attribute_Detail_Citation: See Deltares (2020) for descriptions of the formats and entity information for files contained in the .zip archive. Distribution_Information: Distributor: Contact_Information: Contact_Person_Primary: Contact_Person: U.S. Geological Survey - Science Base Contact_Organization: U.S. Geological Survey Contact_Address: Address_Type: mailing and physical Address: Denver Federal Center, Building 810, Mail Stop 302 City: Denver State_or_Province: CO Postal_Code: 80225 Country: USA Contact_Voice_Telephone: 1-888-275-8747 Contact_Electronic_Mail_Address: sciencebase@usgs.gov Resource_Description: Model input files (lcr_dmf_input.zip) compatible with windows executable of Delft3D Flexible Mesh version 2021.01 are provided in the zip archive "lcr_dfm_input.zip". Browse graphics showing the model bathymetry and validation are also provided along with associated metadata. Distribution_Liability: Unless otherwise stated, all data, metadata and related materials are considered to satisfy the quality standards relative to the purpose for which the data were collected. Although these data and associated metadata have been reviewed for accuracy and completeness and approved for release by the U.S. Geological Survey (USGS), no warranty expressed or implied is made regarding the display or utility of the data on any other system or for general or scientific purposes, nor shall the act of distribution constitute any such warranty. Standard_Order_Process: Digital_Form: Digital_Transfer_Information: Format_Name: various Format_Version_Number: Delft3D Flexible Mesh 2021.01 Format_Specification: Zip file Format_Information_Content: compatible with windows executable of Delft3D Flexible Mesh version 2021.01 File_Decompression_Technique: zip Transfer_Size: 65.75 Digital_Transfer_Option: Online_Option: Computer_Contact_Information: Network_Address: Network_Resource_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=lcr_dfm_input.zip Network_Resource_Name: https://doi.org/10.5066/P9ESBJQ0 Access_Instructions: Data can be downloaded using the Network_Resource_Name links. The first link is a direct link to download the model input data. The second link points to a landing page for the entire data release. Digital_Form: Digital_Transfer_Information: Format_Name: png Format_Version_Number: Matlab 9.8.0.1396136 Format_Information_Content: Zip archive with browse graphics showing comparisons between modeled and measured water levels and discharges for each measurement site File_Decompression_Technique: zip Transfer_Size: 1.84 Digital_Transfer_Option: Online_Option: Computer_Contact_Information: Network_Address: Network_Resource_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=lcr_model_validation_figs.zip Network_Resource_Name: https://doi.org/10.5066/P9ESBJQ0 Access_Instructions: Data can be downloaded using the Network_Resource_Name links. The first link is a direct link to download the zip archive. The second link points to a landing page for the entire data release. Digital_Form: Digital_Transfer_Information: Format_Name: netCDF Format_Version_Number: Delft3D Flexible Mesh 2021.01 Format_Information_Content: Zip archive with time-series model outputs at selected sites used for validation File_Decompression_Technique: zip Transfer_Size: 1510 Digital_Transfer_Option: Online_Option: Computer_Contact_Information: Network_Address: Network_Resource_Name: https://www.sciencebase.gov/catalog/file/get/5ff4b239d34ea5387df03099?name=cr_fm_his.zip Network_Resource_Name: https://doi.org/10.5066/P9ESBJQ0 Access_Instructions: Data can be downloaded using the Network_Resource_Name links. The first link is a direct link to download the zip archive. The second link points to a landing page for the entire data release. Fees: None Metadata_Reference_Information: Metadata_Date: 20210409 Metadata_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: PCMSC Science Data Coordinator Contact_Organization: U.S. Geological Survey, Pacific Coastal and Marine Science Center Contact_Address: Address_Type: mailing and physical Address: 2885 Mission St. City: Santa Cruz State_or_Province: CA Postal_Code: 95060 Contact_Voice_Telephone: 831-427-4747 Contact_Electronic_Mail_Address: pcmsc_data@usgs.gov Metadata_Standard_Name: Content Standard for Digital Geospatial Metadata Metadata_Standard_Version: FGDC-STD-001-1998