sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 17:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 17:53:00-0800',44.06,82.31,99567.91,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 18:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 18:53:00-0800',42.98,82.23,99567.91,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 19:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 19:53:00-0800',42.98,82.23,99601.59,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 20:24:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 20:24:00-0800',44.06,78.9,99601.59,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 20:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 20:53:00-0800',44.96,76.24,99601.59,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 21:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 21:53:00-0800',46.04,79.07,99601.59,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 22:35:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 22:35:00-0800',44.6,87.09,99635.27,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 22:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 22:53:00-0800',44.96,85.9,99635.27,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-19 23:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-19 23:53:00-0800',46.04,85.97,99635.27,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 00:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 00:53:00-0800',46.94,86.02,99567.91,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 01:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 01:53:00-0800',41,95.89,99534.23,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 02:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 02:53:00-0800',39.02,100,99601.59,1.778)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 03:12:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 03:12:00-0800',39.02,100,99567.91,1.778)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 03:48:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 03:48:00-0800',39.2,100,99534.23,2.794)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 03:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 03:53:00-0800',39.92,96.55,99534.23,3.048)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 04:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 04:53:00-0800',39.92,100,99500.54,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 05:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 05:53:00-0800',39.92,100,99466.86,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 06:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 06:53:00-0800',39.92,100,99466.86,1.524)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 07:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 07:53:00-0800',41,95.89,99567.91,2.794)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 08:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 08:53:00-0800',41,100,99668.95,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 09:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 09:53:00-0800',42.08,95.91,99770,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 10:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 10:53:00-0800',44.06,95.95,99938.42,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 11:10:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 11:10:00-0800',44.6,93.35,100005.79,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 11:30:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 11:30:00-0800',44.6,93.35,100039.47,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 11:32:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 11:32:00-0800',44.06,95.95,100073.16,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 11:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 11:53:00-0800',44.06,100,100106.84,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 12:27:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 12:27:00-0800',44.06,100,100174.21,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 12:51:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 12:51:00-0800',44.6,100,100241.57,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 12:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 12:53:00-0800',44.96,96.63,100241.57,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 13:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 13:53:00-0800',44.96,100,100409.99,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 14:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 14:53:00-0800',44.96,96.63,100544.72,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 15:00:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 15:00:00-0800',46.4,93.4,100544.72,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 15:46:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 15:46:00-0800',46.04,92.75,100679.46,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 15:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 15:53:00-0800',46.04,92.75,100679.46,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 16:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 16:53:00-0800',44.06,95.95,100780.51,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 17:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 17:53:00-0800',42.08,100,100847.87,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 18:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 18:53:00-0800',42.08,95.91,100982.6,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 19:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 19:53:00-0800',39.02,95.86,101083.65,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 20:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 20:53:00-0800',42.08,88.81,101218.39,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 21:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 21:53:00-0800',39.92,92.55,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 22:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 22:53:00-0800',37.04,95.82,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 23:10:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 23:10:00-0800',33.8,100,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 23:16:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 23:16:00-0800',35.06,95.78,101285.76,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 23:20:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 23:20:00-0800',33.8,100,101285.76,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 23:28:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 23:28:00-0800',35.06,95.78,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-20 23:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-20 23:53:00-0800',35.06,100,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 00:06:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 00:06:00-0800',33.98,100,101353.12,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 00:18:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 00:18:00-0800',33.98,100,101319.44,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 00:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 00:53:00-0800',35.06,95.78,101252.07,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 01:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 01:53:00-0800',35.96,96.49,101252.07,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 02:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 02:53:00-0800',37.04,95.82,101184.71,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 03:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 03:53:00-0800',37.94,96.52,101117.34,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 04:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 04:53:00-0800',37.94,96.52,101083.65,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 05:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 05:53:00-0800',41,85.67,101016.29,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 06:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 06:53:00-0800',42.08,85.13,101049.97,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 07:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 07:53:00-0800',41,92.59,101016.29,1.524)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 08:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 08:53:00-0800',42.08,91.98,100948.92,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 09:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 09:53:00-0800',42.08,91.98,100881.55,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 10:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 10:53:00-0800',42.98,92.65,100780.51,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 11:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 11:53:00-0800',44.06,95.95,100645.77,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 12:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 12:53:00-0800',44.06,95.95,100477.35,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 13:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 13:53:00-0800',44.96,96.63,100308.93,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 14:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 14:53:00-0800',44.96,100,100241.57,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 15:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 15:53:00-0800',46.04,100,100275.25,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 16:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 16:53:00-0800',60.08,83.43,100207.89,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 17:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 17:53:00-0800',59,86.7,100308.93,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 18:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 18:53:00-0800',57.02,89.49,100376.3,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 19:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 19:53:00-0800',57.02,89.49,100477.35,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 20:16:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 20:16:00-0800',55.94,96.79,100477.35,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 20:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 20:53:00-0800',57.02,93.09,100544.72,2.032)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 21:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 21:53:00-0800',55.94,100,100679.46,4.318)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 22:42:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 22:42:00-0800',57.02,100,100645.77,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 22:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 22:53:00-0800',57.02,100,100679.46,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-21 23:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-21 23:53:00-0800',57.02,96.17,100746.83,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 00:01:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 00:01:00-0800',55.94,100,100746.83,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 00:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 00:53:00-0800',55.04,100,100780.51,1.524)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 01:01:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 01:01:00-0800',50,100,100746.83,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 01:13:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 01:13:00-0800',50,100,100746.83,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 01:32:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 01:32:00-0800',48.02,100,100746.83,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 01:45:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 01:45:00-0800',48.2,93.45,100746.83,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 01:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 01:53:00-0800',46.94,100,100746.83,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 02:01:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 02:01:00-0800',46.94,100,100713.14,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 02:33:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 02:33:00-0800',46.94,100,100746.83,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 02:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 02:53:00-0800',46.94,100,100746.83,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 03:18:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 03:18:00-0800',46.94,100,100746.83,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 03:39:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 03:39:00-0800',46.94,100,100713.14,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 03:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 03:53:00-0800',46.94,100,100679.46,0.762)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 04:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 04:53:00-0800',57.02,100,100746.83,0.254)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 05:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 05:53:00-0800',60.98,86.81,100746.83,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 06:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 06:53:00-0800',62.06,83.56,100746.83,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 07:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 07:53:00-0800',62.06,83.56,100746.83,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 08:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 08:53:00-0800',62.96,80.96,100679.46,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 09:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 09:53:00-0800',62.96,80.96,100713.14,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 10:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 10:53:00-0800',66.02,72.77,100645.77,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 11:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 11:53:00-0800',66.02,69.98,100578.41,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 11:54:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 11:54:00-0800',66.92,67.84,100612.09,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 12:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 12:53:00-0800',66.92,70.54,100511.04,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 13:21:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 13:21:00-0800',66.02,72.77,100477.35,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 13:37:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 13:37:00-0800',66.02,69.98,100477.35,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 13:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 13:53:00-0800',66.02,69.98,100477.35,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 14:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 14:53:00-0800',60.98,86.81,100409.99,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 15:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 15:53:00-0800',62.06,83.56,100409.99,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 15:54:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 15:54:00-0800',62.96,80.96,100409.99,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 16:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 16:53:00-0800',60.08,89.63,100275.25,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 17:40:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 17:40:00-0800',60.8,87.94,100275.25,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 17:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 17:53:00-0800',60.08,89.63,100207.89,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 18:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 18:53:00-0800',59,89.58,100207.89,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 19:06:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 19:06:00-0800',57.92,93.11,100174.21,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 19:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 19:53:00-0800',57.92,93.11,100275.25,2.794)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 20:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 20:53:00-0800',55.94,100,100308.93,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 21:12:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 21:12:00-0800',55.94,100,100308.93,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 21:30:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 21:30:00-0800',57.2,100,100342.62,4.826)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 21:41:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 21:41:00-0800',57.02,100,100342.62,5.334)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 21:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 21:53:00-0800',57.02,100,100342.62,5.588)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 22:25:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 22:25:00-0800',55.4,100,100308.93,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 22:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 22:53:00-0800',55.94,100,100308.93,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 23:15:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 23:15:00-0800',55.4,100,100308.93,1.778)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 23:24:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 23:24:00-0800',55.94,100,100308.93,2.286)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-22 23:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-22 23:53:00-0800',55.94,100,100275.25,2.286)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 00:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 00:53:00-0800',55.04,100,100308.93,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 01:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 01:53:00-0800',57.92,77.94,100376.3,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 02:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 02:53:00-0800',57.02,71.83,100409.99,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 03:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 03:53:00-0800',55.04,77.17,100376.3,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 04:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 04:53:00-0800',53.06,92.97,100342.62,0.508)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 05:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 05:53:00-0800',53.06,92.97,100342.62,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 06:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 06:53:00-0800',51.98,96.73,100342.62,2.286)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 07:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 07:53:00-0800',51.08,100,100275.25,1.778)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 08:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 08:53:00-0800',51.08,96.07,100308.93,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 09:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 09:53:00-0800',51.08,96.07,100308.93,1.27)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 10:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 10:53:00-0800',51.08,92.29,100376.3,1.016)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 11:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 11:53:00-0800',51.08,89.23,100308.93,0.025)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 12:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 12:53:00-0800',51.08,85.68,100308.93,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 13:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 13:53:00-0800',53.96,74.5,100342.62,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 14:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 14:53:00-0800',53.06,73.9,100376.3,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 15:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 15:53:00-0800',53.06,68.52,100409.99,0)sql: if not exists (select observationTime from tblHistory where observationTime = '2017-11-23 16:53:00-0800')INSERT INTO tblHistory (ObservationTime, Temperature, humidity, pressure, precipitation) VALUES ('2017-11-23 16:53:00-0800',51.98,68.87,100477.35,0) Bellingham WA Weather Charts & Galbraith Mountain Mud Index

Bellingham WA Weather Charts

Temperature | Humidity | Barometer | Precipitation | Cumulative Precipitation | Galbraith Mud Index
Plot period:
Last updated: .
Bellingham Temperature
Bellingham Relative Humidity
Bellingham Barametric Pressure
Bellingham Precipitation
Bellingham Cumulative Precipitation
Galbraith Mud Index

Current Index: 243.8
Legend: < 5 dry conditions, 5-15 typical muddy conditions, > 15 hardcore mud

The Galbraith mud index is more accurate for graph plots of one month or more. It is based upon a dubious mathematical equation that incorporates the relationship between precipitation, temperature, time and the absorption properties of Galbraith mountain mud.

Galbraith Mountain is located east of Bellingham on Lookout Mountain (directions) and is famous for its world-class mountain biking. During the rainy months (November - May) it is reported to have more mud than the entire country of Australia. For more information see the Whatcom Mountain Bike Coalition (WMBC) web site.

Disclaimer: The purpose of this page is to demonstrate ideas for student projects in Professor Sandvig's ASP.NET courses. The accuracy of the data is not guaranteed.

Weather data scraped from NOAA and stored locally.
Code for time series graphs created by Bjorn Stickler (currently no web site).


Insert error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Regular Expressions HTML Color Names Color Picker ASCII Character Codes Unicode Character Codes
Top