Skip to content

Acceptable File Formats for Tide

You can upload your own tides to be used for tide correction. CoastSeg accepts the tides from CSV files in formats below.

Acceptable CSV formats for Specific Dates

  • Note: The exact columns names (capitalizations too) must match

Acceptable Forms of Dates

  1. Dates in ISO 8601
    • specify year-month-day followed by the time in 24-hour format with an offset from UTC (Coordinated Universal Time)
    • Example: 2023-12-25 18:40:14+00:00
    • We recommend this format since this is the same format used to save the dates in the timeseries CSV files saved by CoastSeg
  2. Dates in YYYY-MM-DD
    • Example 2021-04-05

CSV Formats for Specific Dates

  1. Format 1: Tides for each transect ID

    columns : transect_id, tide

    • Please be sure to supply a tide for each transect id, otherwise tide correction cannot be applied to that transect id and it will be removed from the tide corrected output
    • All your transect ids can be found in the raw_transect_time_series_merged.csv file
    transect_id tide
    1 0.05
    2 0.04
    3 0.02

  2. Format 2: Dates and tides for each transect ID

    columns : transect_id, tide, dates

    • Uses the tide for everything up to and including the date for that transect
    • For example for transect 2 tide 0.04 will be used for all tide corrections for dates before or on 2021-04-05, but for dates after 2021-04-05 the tide 0.03 will be used
    transect_id tide dates
    1 0.05 2021-04-05
    2 0.04 2021-04-05
    2 0.03 2021-04-08
    3 0.02 2021-04-06

  3. Format 3: Dates and latitude & longitude values for each tide

    columns : tide,longitude,latitude,dates

    • Use the tide for the transect closet to the longitude(x) and latitude(y) location and the closest date
    tide latitude longitude dates
    0.05 34.0522 -118.2437 2021-04-05
    0.04 36.7783 -119.4179 2021-04-07
    0.02 37.7749 -122.4194 2021-04-08

  4. Form 4: Transect IDs as the columns and dates as the row index

    columns: transect ids (the actual transect ids)

    • This is a pivot of format 2 and its like the format of raw_transect_time_series.csv
    • This format has the tide value for each transect id and date
    • All your transect ids can be found in the raw_transect_time_series_merged.csv file
    • In the examples below 1,2,3 are transect ids
    1 2 3
    2004-04-07 00:00:00+00:00 0.05 0.04 0.04
    2004-04-08 00:00:00+00:00 0.04 0.05 0.08
    2004-04-09 00:00:00+00:00 0.03 0.09 0.07
    2004-04-10 00:00:00+00:00 0.02 0.01 0.07