Skip to content

Instantly share code, notes, and snippets.

@afcotroneo

afcotroneo/omni-noaa-table.sql

Last active September 27, 2021 18:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save afcotroneo/1d828cd6c02ef8ea1c2e7677404cc075 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save afcotroneo/1d828cd6c02ef8ea1c2e7677404cc075 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
omni-noaa-table.sql
CREATE TABLE noaa_data_geo as (
SELECT
a.id,
a.dt,
a.element_,
a.value_,
b.latitude,
b.longitude,
b.elevation,
b.NAME
FROM noaa_data_table_name a
JOIN ghcnd_stations b
ON a.id = b.id
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment