Skip to content

Acceptable File Formats for Slope

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

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

Acceptable Forms for dates

  1. Dates in ISO 8601, specifying 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

Acceptable CSV formats

Any of the following CSV formats will be accepted. - Note: The exact columns names (capitalizations too) must match

  1. Format 1: Slopes for each transect ID

    • columns : transect_id, slope
    • Please be sure to supply a slope for each transect id
    • All your transect ids can be found in the raw timeseries csv files
    transect_id slope
    1 0.05
    2 0.04
    3 0.02

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

    • columns : transect_id, slope, dates
    • Uses the slope for everything up to and including the date for that transect
    • For example for transect 2 slope 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 slope 0.03 will be used
    transect_id slope 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 slope

    • columns : slope,longitude,latitude,dates
    • Use the slope for the transect closet to the longitude(x) and latitude(y) location and the closest date
    slope 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
    • Basically its a pivot of form 2
    • This format has the slope value for each transect id and date
    • In the examples below 123, 1234 ... are transect ids
    123 1234 12345 123456
    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