-- WlkTranformer - export SQL du 01/12/2014 23:01:44 UTC -- Version 0.6 du 01/12/2014 -- http://meteofrouzins.fr/wlktransformer.php -- -- Structure de la table 'DQUOT' -- CREATE TABLE IF NOT EXISTS `DQUOT` ( `jour` date NOT NULL default '0000-00-00', `hiOutTemp` float NOT NULL, `lowOutTemp` float NOT NULL, `avgOutTemp` float NOT NULL, `hiOutHum` float NOT NULL, `lowOutHum` float NOT NULL, `avgOutHum` float NOT NULL, `hiBar` float NOT NULL, `lowBar` float NOT NULL, `avgBar` float NOT NULL, `hiSpeed` float NOT NULL, `avgSpeed` float NOT NULL, `dailyWindRunTotal` float NOT NULL, `hi10MinSpeed` float NOT NULL, `dirHiSpeed` char(5), `hi10MinDir` char(5), `dailyRainTotal` float NOT NULL, `hiRainRate` float NOT NULL, UNIQUE KEY (`jour`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; -- -- Contenu de la table 'DQUOT' -- INSERT INTO `DQUOT` (`jour`, `hiOutTemp`, `lowOutTemp`, `avgOutTemp`, `hiOutHum`, `lowOutHum`, `avgOutHum`, `hiBar`, `lowBar`, `avgBar`, `hiSpeed`, `avgSpeed`, `dailyWindRunTotal`, `hi10MinSpeed`, `dirHiSpeed`, `hi10MinDir`, `dailyRainTotal`, `hiRainRate`) VALUES ('2014-02-01', '7.7', '3.2', '5.8', '99.0', '87.0', '92.4', '1014.5', '1005.7', '1009.6', '33.8', '2.9', '70.3', '-9999.9', 'WNW', 'N', '7.8', '0.3'), ('2014-02-02', '9.2', '0.8', '5.0', '98.0', '75.0', '88.7', '1020.1', '1014.5', '1018.1', '29.0', '3.9', '93.0', '-9999.9', 'WNW', 'N', '0.0', '0.0'), ('2014-02-03', '10.6', '-2.2', '4.1', '99.0', '70.0', '89.9', '1017.1', '1005.7', '1009.9', '29.0', '1.6', '37.0', '-9999.9', 'SE', 'N', '2.4', '0.2'), ('2014-02-04', '11.9', '-0.3', '6.6', '99.0', '58.0', '84.6', '1014.4', '1001.6', '1010.5', '27.4', '2.4', '57.0', '-9999.9', 'SE', 'N', '0.8', '0.1'), ('2014-02-05', '11.2', '1.8', '7.3', '98.0', '65.0', '83.4', '1014.9', '998.2', '1006.1', '30.6', '2.4', '57.0', '-9999.9', 'W', 'N', '4.0', '1.3'), ('2014-02-06', '12.7', '1.3', '7.6', '99.0', '72.0', '86.7', '1014.9', '1000.2', '1007.9', '41.8', '5.8', '137.4', '-9999.9', 'SE', 'N', '0.0', '0.0'), ('2014-02-07', '13.1', '2.9', '8.4', '97.0', '49.0', '80.3', '1015.4', '1001.0', '1011.1', '25.7', '3.7', '87.7', '-9999.9', 'NW', 'N', '2.0', '1.2'), ('2014-02-08', '12.9', '2.9', '7.1', '94.0', '79.0', '87.1', '1010.9', '1001.2', '1005.6', '33.8', '2.9', '71.0', '-9999.9', 'WNW', 'N', '2.0', '0.4'), ('2014-02-09', '11.5', '0.6', '6.6', '98.0', '51.0', '79.8', '1011.5', '991.3', '1005.5', '29.0', '2.9', '70.0', '-9999.9', 'ESE', 'N', '0.4', '0.0'), ('2014-02-10', '9.8', '4.5', '6.9', '94.0', '66.0', '85.7', '1014.4', '987.2', '998.7', '41.8', '7.1', '171.1', '-9999.9', 'NNW', 'N', '6.6', '1.0'), ('2014-02-11', '9.1', '1.1', '6.2', '98.0', '72.0', '89.1', '1016.9', '1007.3', '1012.7', '40.2', '2.9', '68.9', '-9999.9', 'WNW', 'N', '7.4', '0.6'), ('2014-02-12', '12.6', '1.5', '7.7', '98.0', '57.0', '81.4', '1019.9', '1011.2', '1015.4', '20.9', '1.3', '32.3', '-9999.9', 'WNW', 'N', '0.8', '0.3'), ('2014-02-13', '14.0', '3.7', '8.1', '94.0', '67.0', '86.1', '1017.1', '1008.5', '1012.3', '46.7', '2.9', '70.5', '-9999.9', 'W', 'N', '2.0', '0.3'), ('2014-02-14', '13.6', '5.4', '9.1', '97.0', '75.0', '86.7', '1015.5', '1004.1', '1008.3', '33.8', '4.3', '102.7', '-9999.9', 'ESE', 'N', '0.0', '0.0'), ('2014-02-15', '10.3', '6.7', '8.4', '97.0', '90.0', '94.7', '1016.3', '1005.4', '1010.5', '16.1', '0.3', '7.4', '-9999.9', 'NE', 'N', '5.8', '1.0'), ('2014-02-16', '10.1', '2.1', '6.7', '98.0', '78.0', '92.7', '1018.7', '1015.7', '1017.0', '11.3', '0.3', '9.3', '-9999.9', 'ENE', 'N', '1.0', '0.5'), ('2014-02-17', '13.5', '-0.9', '6.1', '99.0', '61.0', '85.2', '1016.8', '1012.1', '1014.1', '27.4', '2.9', '70.8', '-9999.9', 'E', 'N', '0.2', '0.0'), ('2014-02-18', '12.6', '3.4', '7.5', '98.0', '70.0', '90.0', '1019.9', '1013.6', '1016.2', '12.9', '0.8', '21.2', '-9999.9', 'WNW', 'N', '0.0', '0.0'), ('2014-02-19', '12.5', '3.3', '8.7', '99.0', '75.0', '89.2', '1022.9', '1019.4', '1021.2', '22.5', '2.6', '61.0', '-9999.9', 'WNW', 'N', '0.4', '0.2'), ('2014-02-20', '14.5', '1.8', '7.9', '99.0', '75.0', '90.7', '1022.4', '1014.7', '1017.9', '30.6', '0.5', '10.3', '-9999.9', 'WNW', 'N', '0.2', '0.0'), ('2014-02-21', '9.9', '0.4', '7.0', '96.0', '70.0', '89.9', '1022.4', '1016.8', '1019.6', '27.4', '2.4', '57.6', '-9999.9', 'NW', 'N', '3.8', '0.7'), ('2014-02-22', '14.7', '-1.7', '6.5', '99.0', '43.0', '77.8', '1025.5', '1021.1', '1022.8', '20.9', '1.4', '33.5', '-9999.9', 'WNW', 'N', '0.2', '0.0'), ('2014-02-23', '15.9', '-0.7', '7.7', '99.0', '51.0', '80.1', '1025.5', '1013.2', '1019.5', '35.4', '4.8', '117.6', '-9999.9', 'ESE', 'N', '0.0', '0.0'), ('2014-02-24', '16.1', '8.5', '11.4', '92.0', '54.0', '76.2', '1016.8', '1011.8', '1014.1', '30.6', '6.1', '145.2', '-9999.9', 'ESE', 'N', '0.0', '0.0'), ('2014-02-25', '15.8', '4.4', '9.4', '98.0', '57.0', '84.3', '1019.0', '1013.1', '1015.4', '35.4', '1.0', '22.9', '-9999.9', 'W', 'N', '4.2', '3.1'), ('2014-02-26', '9.3', '3.2', '6.1', '98.0', '74.0', '87.0', '1028.9', '1018.7', '1023.4', '30.6', '4.7', '110.7', '-9999.9', 'WNW', 'N', '0.4', '0.0'), ('2014-02-27', '11.9', '-1.0', '5.4', '98.0', '75.0', '90.9', '1028.8', '1022.6', '1025.3', '33.8', '1.3', '30.7', '-9999.9', 'WNW', 'N', '3.4', '3.0'), ('2014-02-28', '9.1', '4.1', '5.7', '97.0', '78.0', '90.6', '1023.0', '1010.0', '1013.9', '51.5', '5.0', '120.9', '-9999.9', 'NW', 'N', '10.4', '1.4');