Copernicus (2025). 1984 Tanzania 2m Temperature Yearly Average (Copernicus) [gis dataset]. OHDSI. https://cds.climate.copernicus.eu/datasets/reanalysis-era5-land. 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: | WMS (coming soon) | WFS (coming soon) Analytical Functions: gdsc_zonal_statistics(table=tz_1984_copernicus_avg_temp,lat=25.718,lng=-80.279,radius=500) 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,etl} && 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): #### # Move into corrrect directory and create derivative directory in data package on osgeo cd /data/tz_1984_copernicus_avg_temp/ mkdir -p derived # Move into correct directory cd /data/tz_1984_copernicus_avg_temp/