Changes between Initial Version and Version 1 of Temperature download and load

Timestamp:

May 11, 2010 10:21:15 AM (15 years ago)

Author:

celine

Comment:

--

Temperature download and load

@@ +1 @@
+back to first page [..][[BR]]
+back to ["CookBook Eda"][[BR]]
+back to ["Temperature"][[BR]]
+
+== EXTRACT the data from CRU with TETYN ==
+
+Download Tetyn at : http://sourceforge.net/projects/tetyn/  [[BR]]
+Download the data at http://www.cru.uea.ac.uk/cru/data/hrg/cru_ts_2.10/data_all/  [[BR]]
+cru_ts_2_10.1901-2002.pre.Z (137MB) [[BR]]
+cru_ts_2_10.1901-2002.tmn.Z (118MB) [[BR]]
+cru_ts_2_10.1901-2002.tmp.Z (118MB) [[BR]]
+cru_ts_2_10.1901-2002.tmx.Z (119MB) [[BR]]
+
+Unzippe the data [[BR]]
+
+Open TETYN > Climate dataset > CRU TS 2.10 [[BR]]
+
+In-out > Data folder choose the folder where you have extracted the data and the output folder[[BR]]
+Query : select the year, the month, parameters : temperature, temperature minimum, temperature maximum, precipitation[[BR]]
+Space : select the country [[BR]]
+
+== 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;
+}}}