NOAA San Francisco Water Levels

Source

api.tidesandcurrents.noaa.gov

Quality score: 100/100.

Initial recorded revision.

Current Source Files

• datagetter.json 20260907135533-95862c5911bd Provider source

Contract Versions

• 20260907135533-95862c5911bd Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: noaa-san-francisco-water-levels
title: NOAA San Francisco Water Levels
description: NOAA San Francisco Water Levels discovered from api.tidesandcurrents.noaa.gov.
  Fixed-date source extract (begin_date=20260906, end_date=20260907).
source_name: api.tidesandcurrents.noaa.gov
source_url: https://api.tidesandcurrents.noaa.gov/api/prod/datagetter?product=water_level&application=OpenDataODC&begin_date=20260906&end_date=20260907&datum=MLLW&station=9414290&time_zone=gmt&units=metric&format=json
update_frequency: daily
next_scan_at: '2026-09-07T17:55:33.359962+00:00'
license:
  name: NOAA terms and conditions
  url: https://www.noaa.gov/information-technology/terms-and-conditions
tags:
- api.tidesandcurrents.noaa.gov
geography:
- United States
- San Francisco
revisions:
- revision_id: 20260907135533-95862c5911bd
  detected_at: '2026-09-07T13:55:33+00:00'
  source_updated_at: null
  context: datagetter.json detected from datagetter.
  assets:
  - asset_id: asset-559be612dd76df1b
    name: datagetter.json
    source_url: https://api.tidesandcurrents.noaa.gov/api/prod/datagetter?product=water_level&application=OpenDataODC&begin_date=20260906&end_date=20260907&datum=MLLW&station=9414290&time_zone=gmt&units=metric&format=json
    media_type: application/json;charset=UTF-8
    content_hash: 559be612dd76df1b22b592dcfd18c38a4743b53164b3d5ae0a4a482b368dde9d
    size_bytes: 28455
    parent_archive_id: null
  row_count: 379
  headers:
  - f
  - q
  - s
  - t
  - v
  sample_rows:
  - t: 2026-09-06 00:00
    v: '1.814'
    s: '0.053'
    f: 0,0,0,0
    q: p
  - t: 2026-09-06 00:06
    v: '1.839'
    s: '0.054'
    f: 1,0,0,0
    q: p
  - t: 2026-09-06 00:12
    v: '1.869'
    s: '0.062'
    f: 1,0,0,0
    q: p
  - t: 2026-09-06 00:18
    v: '1.881'
    s: '0.058'
    f: 1,0,0,0
    q: p
  - t: 2026-09-06 00:24
    v: '1.889'
    s: '0.055'
    f: 0,0,0,0
    q: p
  parser_errors: []
  logical_asset_id: null
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: null

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: noaa_san_francisco_water_levels
  description: NOAA San Francisco Water Levels discovered from api.tidesandcurrents.noaa.gov.
    Fixed-date source extract (begin_date=20260906, end_date=20260907).
  meta:
    opendataodc:
      dataset_id: noaa-san-francisco-water-levels
      revision_id: 20260907135533-95862c5911bd
      detected_at: '2026-09-07T13:55:33+00:00'
      source_url: https://api.tidesandcurrents.noaa.gov/api/prod/datagetter?product=water_level&application=OpenDataODC&begin_date=20260906&end_date=20260907&datum=MLLW&station=9414290&time_zone=gmt&units=metric&format=json
  tables:
  - name: datagetter_json
    description: Source asset datagetter.json.
    meta:
      opendataodc:
        source_url: https://api.tidesandcurrents.noaa.gov/api/prod/datagetter?product=water_level&application=OpenDataODC&begin_date=20260906&end_date=20260907&datum=MLLW&station=9414290&time_zone=gmt&units=metric&format=json
        content_hash: 559be612dd76df1b22b592dcfd18c38a4743b53164b3d5ae0a4a482b368dde9d
        row_count: 379
        parser_errors: []
    columns:
    - name: f
    - name: q
    - name: s
    - name: t
    - name: v

Sample Rows

datagetter.json

379 parsed rows. 20260907135533-95862c5911bd