Meteogalicia PostgreSQL Database (2000 - 2018)

Resumen

This database contains: rainfall, humidity, temperature, global solar radiation, wind velocity and wind direction ten-minute data from 150 stations of the Meteogalicia network between 1-jan-2000 and 31-dec-2018. Version installed: postgresql 9.1 Extension installed: postgis 1.5.3-1 Instructions to restore the database: Create template:  createdb -E UTF8 -O postgres -U postgres template_postgis Activate PL/pgSQL language:  createlang plpgsql -d template_postgis -U postgres Load definitions of PostGIS: psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql psql -d template_postgis -U postgres -f /usr/share/postgresql/9.1/contrib/postgis_comments.sql Create database with "MeteoGalicia" name with PostGIS extension:  createdb -U postgres -T template_postgis MeteoGalicia Restore backup:  cat Meteogalicia* | psql MeteoGalicia