Copernicus (2025). 1984 Tanzania 2m Temperature Yearly Average (Copernicus) [gis dataset]. OHDSI. last updated: 0001-01-01 (update frequency: As Needed). A raster dataset with yearly averages of the 2m temperature from the ERA 5 renanalysis data from Copernicus satellite sensors for Tanzania. ERA5 is the fifth generation ECMWF reanalysis for the global climate and weather for the past 8 decades. Data is available from 1940 onwards. ERA5 replaces the ERA-Interim reanalysis. Key words: Tanzania, temperature Open Geospatial Consortium Standards: Analytical Functions:

gdsc_zonal_statistics( table, lat, lng, radius )

ETL documentation

ETL for tz_1984_copernicus_avg_temp

######### # GDSC ETL is performed in two steps: shell script to ETL data into postgres # and then additional transformations with SQL in postGIS (if needed). #### ######### # Step 1 - bash script (pseudo code) #### # create directory structure and move into it mkdir -p /data/tz_1984_copernicus_avg_temp/download -p /data/tz_1984_copernicus_avg_temp/etl chmod 777 /data/tz_1984_copernicus_avg_temp/download cd /data/tz_1984_copernicus_avg_temp # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # clone a git repo and run the code# save netcdf as tif cd download gdal_translate NETCDF:tz_1984_copernicus_avg_temp.nc:2m_temperature tz_1984_copernicus_avg_temp.tif cd .. ######### # Step 2 - SQL script (pseudo code): #### # load raster into postGIS with: raster2pgsql -s 4326 -d -C -I -t auto tz_1984_copernicus_avg_temp.tif -F tz_1984_copernicus_avg_temp > load_raster.sql psql < load_raster.sql rm load_raster.sql # Move into corrrect directory and create derivative directory in data package on osgeo cd /data/tz_1984_copernicus_avg_temp/ mkdir -p derived # Create downloadable zip of download/geotiff in derivate directory rm -f derived/tz_1984_copernicus_avg_temp.tif.tar.gz tar -czf derived/tz_1984_copernicus_avg_temp.tif.tar.gz meta_dcat_tz_1984_copernicus_avg_temp.json -C download tz_1984_copernicus_avg_temp.tif # Move into correct directory cd /data/tz_1984_copernicus_avg_temp/