afcotroneo · December 13, 2021 18:14
diff --git a/omni-noaa-snow.sql b/omni-noaa-snow.sql
 CREATE TABLE df_snow_geo as (
  SELECT
    a.id,
    a.dt,
    a.element_,
    a.value_,
    b.latitude,
    b.longitude,
    b.elevation,
    b.NAME
  FROM
    df_snow a
  JOIN ghcnd_stations b 
  ON a.id = b.id
 );
	CREATE TABLE df_snow_geo as (
	SELECT
	a.id,
	a.dt,
	a.element_,
	a.value_,
	b.latitude,
	b.longitude,
	b.elevation,
	b.NAME
	FROM
	df_snow a
	JOIN ghcnd_stations b
	ON a.id = b.id
	);