back to first page ..
back to CookBook Eda
back to Temperature

EXTRACT the data from CRU with TETYN

Download Tetyn at : ​http://sourceforge.net/projects/tetyn/
Download the data at ​http://www.cru.uea.ac.uk/cru/data/hrg/cru_ts_2.10/data_all/
cru_ts_2_10.1901-2002.pre.Z (137MB)
cru_ts_2_10.1901-2002.tmn.Z (118MB)
cru_ts_2_10.1901-2002.tmp.Z (118MB)
cru_ts_2_10.1901-2002.tmx.Z (119MB)

Unzippe the data

Open TETYN > Climate dataset > CRU TS 2.10

In-out > Data folder choose the folder where you have extracted the data and the output folder
Query : select the year, the month, parameters : temperature, temperature minimum, temperature maximum, precipitation
Space : select the country

Create the table in Postgre to import to

Import the temperature tmp (temperature moyenne)

Import the temperature tmx (temperature maximum)

Import the temperature tmn (temperature minimum)

DROP TABLE IF EXISTS temperature.tmn;

Create table tmn

COPY temperature.tmn FROM 'D:/Celine Jouanin/Temperature/tmn.txt' USING DELIMITERS ';' CSV HEADER;