Difference between revisions of "Eutrofização Albufeiras"
From MohidWiki
Davidbrito (talk | contribs) (→Input Data) |
Davidbrito (talk | contribs) (→Input Data) |
||
| Line 8: | Line 8: | ||
==Input Data== | ==Input Data== | ||
| − | |||
| − | |||
| − | ''' | + | '''Water Quantity in the reservoir''' |
| − | + | #Go to http://snirh.pt | |
| − | + | #For water quantity in the reservoir click "Albufeiras->Dados de base". | |
| − | + | #Choose your desired station (reservoir name) and click "Seleccionar estações" | |
| + | #click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections) | ||
| + | #After all desired parameters selected, click "Ver/Guardar Dados" | ||
| + | #Wait until all data is dowloaded and the click upper right button "Export CSV" | ||
| + | #Choose a folder and a name for your file (use the recommended structure) | ||
| + | #Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls. | ||
| − | + | List of input data needed: | |
| − | |||
| − | |||
Consumo agrícola mensal | Consumo agrícola mensal | ||
Consumo municipal mensal | Consumo municipal mensal | ||
| Line 28: | Line 29: | ||
Volume armazenado (convencional) - recommned to download together with the previous to a different file because is daily data | Volume armazenado (convencional) - recommned to download together with the previous to a different file because is daily data | ||
| − | ''' | + | '''Water Quality in the reservoir''' |
| + | #Go to http://snirh.pt | ||
| + | #For water quality in the reservoir click "Rios->Dados de base(qualidade)". | ||
| + | #Choose your desired station (reservoir name) and click "Seleccionar estações" | ||
| + | #click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections) | ||
| + | #After all desired parameters selected, click "Ver/Guardar Dados" | ||
| + | #Wait until all data is dowloaded and the click upper right button "Export CSV" | ||
| + | #Choose a folder and a name for your file (use the recommended structure) | ||
| + | #Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls. | ||
| + | |||
| + | List of input data needed: | ||
Temperatura da amostra | Temperatura da amostra | ||
Transparência | Transparência | ||
| Line 47: | Line 58: | ||
Ferro particulado | Ferro particulado | ||
| − | ''' | + | '''Meteorology''' - need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them. |
| + | #Go to http://snirh.pt | ||
| + | #For meteorology click "Meteorologia->Dados de base". | ||
| + | #Choose your desired stations and click "Seleccionar estações" | ||
| + | #click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections) | ||
| + | #After all desired parameters selected, click "Ver/Guardar Dados" | ||
| + | #Wait until all data is dowloaded and the click upper right button "Export CSV" | ||
| + | #Choose a folder and a name for your file (use the recommended structure) | ||
| + | #Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls. | ||
| + | |||
| + | List of input data needed: | ||
| + | Temperatura do ar média diária | ||
| + | Humidade relativa média diária - for dew point calculation | ||
| + | Velocidade do vento médio diário | ||
| + | |||
| + | Direcção do vento horário - recommned to download to a different file because is hourly data | ||
| + | |||
| + | |||
| + | '''Water Quantity in the incoming rivers''' - need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them. | ||
| + | #Go to http://snirh.pt | ||
| + | #For water quantity in the river click "Rios->Dados de base(quantidade)". | ||
| + | #Choose your desired station and click "Seleccionar estações" | ||
| + | #click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections) | ||
| + | #After all desired parameters selected, click "Ver/Guardar Dados" | ||
| + | #Wait until all data is dowloaded and the click upper right button "Export CSV" | ||
| + | #Choose a folder and a name for your file (use the recommended structure) | ||
| + | #Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls. | ||
| + | |||
| + | List of input data needed: | ||
Caudal médio diário | Caudal médio diário | ||
Nível médio diário (se não existir caudal) | Nível médio diário (se não existir caudal) | ||
| − | ''' | + | '''Water Quality in the incoming rivers'''- need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them. |
| + | #Go to http://snirh.pt | ||
| + | #For water quality in the river click "Rios->Dados de base(qualidade)". | ||
| + | #Choose your desired station and click "Seleccionar estações" | ||
| + | #click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections) | ||
| + | #After all desired parameters selected, click "Ver/Guardar Dados" | ||
| + | #Wait until all data is dowloaded and the click upper right button "Export CSV" | ||
| + | #Choose a folder and a name for your file (use the recommended structure) | ||
| + | #Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls. | ||
| + | |||
| + | List of input data needed: | ||
Temperatura da amostra | Temperatura da amostra | ||
Nitrato Total (em NO3) | Nitrato Total (em NO3) | ||
Revision as of 17:25, 7 August 2009
Contents
Overview
It is intended to produce a step-by-step procedure to run reservoir model CE-QUAL-W2
Where to Start?
- If you need to have first insights on CEQUAL-W2 model, applications already done see \\datacenter\Albufeiras_Eutrofizacao\ComoFazer\0.Bibliografia
- If you already feel ready to start, initiate with collecting all the data available for your reservoir and watershed in snirh (http://snirh.pt). First use the shapes in \\datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check which flow and quality stations are in the reservoir and watershed. Then, go to snirh to download the desired data from that stations.
- Follow the steps in \\datacenter\Albufeiras_Eutrofizacao\ComoFazer
Input Data
Water Quantity in the reservoir
- Go to http://snirh.pt
- For water quantity in the reservoir click "Albufeiras->Dados de base".
- Choose your desired station (reservoir name) and click "Seleccionar estações"
- click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections)
- After all desired parameters selected, click "Ver/Guardar Dados"
- Wait until all data is dowloaded and the click upper right button "Export CSV"
- Choose a folder and a name for your file (use the recommended structure)
- Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls.
List of input data needed:
Consumo agrícola mensal Consumo municipal mensal Descarga de fundo mensal Descarga de superfície mensal Volume armazenado mensal (final do mês)
Cota da Albufeira - recommned to download together with the next to a different file because is daily data (sometimes also hourly) Volume armazenado (convencional) - recommned to download together with the previous to a different file because is daily data
Water Quality in the reservoir
- Go to http://snirh.pt
- For water quality in the reservoir click "Rios->Dados de base(qualidade)".
- Choose your desired station (reservoir name) and click "Seleccionar estações"
- click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections)
- After all desired parameters selected, click "Ver/Guardar Dados"
- Wait until all data is dowloaded and the click upper right button "Export CSV"
- Choose a folder and a name for your file (use the recommended structure)
- Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls.
List of input data needed:
Temperatura da amostra Transparência Nitrato Total (em NO3) Amónia Total (em NH4) Nitrito Total (em NO2) Azoto Orgânico(ou Azoto Kjeldahl) Azoto Total Ortofosfato Total Fósforo Total Clorofila-a Fitoplancton ... (Espécies de algas - normalmente não existe esta informação) Sólidos Suspensos Totais Oxigénio dissolvido mg/l (normalmente aparecem vários) CBO 5dias Ferro dissolvido Ferro total Ferro particulado
Meteorology - need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them.
- Go to http://snirh.pt
- For meteorology click "Meteorologia->Dados de base".
- Choose your desired stations and click "Seleccionar estações"
- click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections)
- After all desired parameters selected, click "Ver/Guardar Dados"
- Wait until all data is dowloaded and the click upper right button "Export CSV"
- Choose a folder and a name for your file (use the recommended structure)
- Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls.
List of input data needed:
Temperatura do ar média diária Humidade relativa média diária - for dew point calculation Velocidade do vento médio diário
Direcção do vento horário - recommned to download to a different file because is hourly data
Water Quantity in the incoming rivers - need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them.
- Go to http://snirh.pt
- For water quantity in the river click "Rios->Dados de base(quantidade)".
- Choose your desired station and click "Seleccionar estações"
- click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections)
- After all desired parameters selected, click "Ver/Guardar Dados"
- Wait until all data is dowloaded and the click upper right button "Export CSV"
- Choose a folder and a name for your file (use the recommended structure)
- Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls.
List of input data needed:
Caudal médio diário Nível médio diário (se não existir caudal)
Water Quality in the incoming rivers- need to know which station are closer. Use ArcGIS, reservoir and station shapefiles in \\Datacenter\Albufeiras_Eutrofizacao\Produtos\ProjectosGIS\ShapesBase to check them.
- Go to http://snirh.pt
- For water quality in the river click "Rios->Dados de base(qualidade)".
- Choose your desired station and click "Seleccionar estações"
- click "Validar Lista". Check below which parameters to choose to download (holding shift while clicking will perform multiple selections)
- After all desired parameters selected, click "Ver/Guardar Dados"
- Wait until all data is dowloaded and the click upper right button "Export CSV"
- Choose a folder and a name for your file (use the recommended structure)
- Open and transform your data using "Data->Text to Columns" then save the .csv file into excel .xls.
List of input data needed:
Temperatura da amostra Nitrato Total (em NO3) Amónia Total (em NH4) Nitrito Total (em NO2) Azoto Orgânico(ou Azoto Kjeldahl) Azoto Total Ortofosfato Total Fósforo Total Clorofila-a Fitoplancton ... (Espécies de algas - normalmente não existe esta informação) Sólidos Suspensos Totais Oxigénio dissolvido mg/l (normalmente aparecem vários) CBO 5dias Ferro dissolvido Ferro total
How to prepare input data for model to run see \\datacenter\Albufeiras_Eutrofizacao\ComoFazer\1.PreparaInputs
Note It is important to check input data for a) outliers b) detection limit values c) understanding the dynamic. As so, always perform time serie graphs for each property. Also ploting several related properties (e.g. nutrients and chlorofila) will help in understanding the dynamic.
Running the model
In order to see some project examples check \\datacenter\Albufeiras_Eutrofizacao\ComoFazer\2.CorreCeQual\ExemplosHenrique The .exe file to run the model will be also avilable there
Evaluating Results
FAQ
Q: What is the software that I need to install?
A: For Cequal you only will need an .exe file that will be distributed. For the first steps you will need any GIS software that opens shapefiles and georeferenced images (ArcGIS, MohidGIS, etc.). If any doubt on how to install them call David. IE or Mozilla web browser will work just fine in www.snirh.pt
Q: Where do I find data?
A: All the data needed up to now is from http://snirh.pt. Water flows in the reservoir, water height and volumes are taken from "Albufeiras" network. However, water quality in the reservoir is taken from "Rios->Dados de base (qualidade)"; this may cause confusion because reservoir data is in river network. Water flow and water quality entering in the reservoir from tributaries are taken from "Rios->Dados de base (qualidade)" and "Rios->Dados de base (quantidade)" - remember to check first which stations are inside the reservoir watershed.
Q: What is the desired period time of the simulation?
A: The desired period of simulation is around 10-20 years. The best practice is not to filter data (as much of it e.g. water quality has not yet reached 10 years) because all the data may be needed.
Support Material
- The kick-off internal meeting video is available at \\datacenter\Albufeiras_Eutrofizacao\Produtos\Apresentacoes
- For information about the dam for each reservoir: http://cnpgb.inag.pt/gr_barragens/gbportugal/Lista.htm
