A weather station is a facility, either on land or sea, with instruments and equipment for measuring atmospheric conditions to provide information for weather forecasts and to studythe weather and climate. The measurements taken include temperature, atmospheric pressure,humidity, wind speed, wind direction, and precipitation amounts. Wind measurements are takenwith as few other obstructions as possible, while temperature and humidity measurements arekept free from direct solar radiation, or insolation. Manual observations are taken at least once daily, while automated measurements are taken at least once an hour. Weather conditions out at sea are taken by ships and buoys, which measure slightly different meteorological quantities such as sea surface temperature (SST), wave height, and wave period. Drifting weather buoys outnumber their moored versions by a significant amount.
Average monthly precipitation per commune.
Morocco have multiple rivers such as : Bouregreg, Moulouya, Ouargha, Oum Errabiaa, Ourika, Sebou, Souss, Tensift, Drรขa ...
Table | Columns |
aeroports |
id, geom, "OID_", "Name", "SymbolID", "AltMode", "Base", "Snippet", "PopupInfo", "HasLabel", "LabelID" |
communes | id, geom, "OBJECTID", "NAME", "mean2018" |
maroc | id, geom, "name", "descriptio" |
stations | id, geom, "Code", "Nom", "Bassin", "Type" |
Try queries like:
select id, "NAME", mean2018 from communes where
mean2018 > 80
For these spatial queries please fetch the geometry as GeoJSON and alias itgeom as: ST_AsGeoJSON(geom) AS geom
Table | Columns |
aeroports |
id, geom, "OID_", "Name", "SymbolID", "AltMode", "Base", "Snippet", "PopupInfo", "HasLabel", "LabelID" |
communes | id, geom, "OBJECTID", "NAME", "mean2018" |
maroc | id, geom, "name", "descriptio" |
stations | id, geom, "Code", "Nom", "Bassin", "Type" |
Try queries like:
SELECT id, ST_AsGeoJSON(geom) AS geom FROM
maroc
SELECT id,
ST_AsGeoJSON(geom) AS geom FROM communes WHERE mean2018 > 50
SELECT a.id, ST_AsGeoJSON(c.geom) AS geom FROM communes AS c, aeroports AS a WHERE
ST_Intersects(a.geom, c.geom)
We'll forecast precipitation January 2019; but normally we'll have data of each month of the 12 months before the current month and forecast it.
Try with any 12 months to forecast with the trained LSTM model.