Banca dati relativa al monitoraggio dei laghi

A relational database was set up to host the high resolution biological, cvhemical and hydromorphological data produced within the InHabit project. Based on previous partial databases (Deliverables I1d2 and I1d3) the database was built using PostgreSQL, an Open Source Relational Database Management system. The data base contains information on the habitat surveys, information on lake water chemistry and the four biological quality elements quoted in the Annex V of the Directive 2000/60/EC (Water Framework Directive) for lakes: phytoplankton, macrophytes, benthic macroinvertebrates and fishes. With respect to the previous databases, more temporal and taxonomical resolution is provided. At the moment, Lake Habitat survey information are available for 13 lakes and or reservoirs, totaling 170 habitat plots an 170 inter-plot shore descriptions. Chemical data are available for 13 lakes and 258 samples. For what concern the biological quality elements, phytoplankton (58 samples and 281 taxa), macrophyte (94 samples and 20 taxa) and benthos (28 sample and 177 taxa) data are stored at the species level, while fish data are stored at the speciemen level (607 specimen, belonging to 29 species in 16 samples).