Last active
August 1, 2022 13:26
-
-
Save orian/977e031e73b56c9779f9f2f6b6160841 to your computer and use it in GitHub Desktop.
simple schema for weather table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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