Meteogalicia PostgreSQL Database (2000 - 2018)
收藏NIAID Data Ecosystem2026-05-02 收录
下载链接:
https://zenodo.org/record/11915324
下载链接
链接失效反馈官方服务:
资源简介:
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
创建时间:
2024-09-09



