Skip to content

Instantly share code, notes, and snippets.

@orian
Last active August 1, 2022 13:26
Show Gist options
  • Save orian/977e031e73b56c9779f9f2f6b6160841 to your computer and use it in GitHub Desktop.
Save orian/977e031e73b56c9779f9f2f6b6160841 to your computer and use it in GitHub Desktop.
simple schema for weather table
create table weather (longitude double not null,
latitude double not null,
time_ timestamp not null,
u10 double not null,
v10 double not null,
snow_density float not null,
snow_depth float not null,
snowfall float not null,
snowc double not null,
smlt double not null,
surface_pressure double not null,
surface_solar_radiation_downwards double not null,
surface_net_solar_radiation double not null,
total_precipitation double not null,
evaporation double not null,
temperature_2m double not null,
divergence_2m double not null,
skin_temperature double not null,
surface_runoff double not null)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment