About Weatherwest
Weather Bug Stations:
query
RESULTSET
query
  CITY CONTRACTDATE COUNTRY ELEVATION EXTRASENSORS INSTALLTYPE ISACTIVE ISAPAS ISPI ISREMOVED LATESTWEATHERDT LATITUDE LONGITUDE MACADDRESS NOTES POCEMAIL POCMAILINGADD POCNAME POCPHONE PROVINCE SBVERSION SBV_DATECHECKED STATIONID STATIONNAME TZ TZNAME
1 Howden [empty string] Canada 780.0 1 ground 1 0 1 0 2014-04-22 00:00:00.0 49.69611 -97.11417 [empty string] [empty string] kelburn@richardson.ca [empty string] Brian Hellegards 204-269-2722 MB [empty string] [empty string] P0005 Richardson Kelburn Farm -5 America/Winnipeg
2 Winnipeg [empty string] Canada 768.0 0 [empty string] 0 0 0 0 [empty string] 49.80972 -97.21861 [empty string] [empty string] mar_guy.ash@shaw.ca [empty string] Guy Ash 204-229-6820 MB [empty string] [empty string] P0008 Whyte Ridge -5 America/Winnipeg
3 Airdrie [empty string] Canada 3330.0 0 ground 1 0 1 0 2018-04-22 00:00:00.0 51.30083 -113.81080 [empty string] [empty string] Glunde@efirehose.net [empty string] Gord Lunde 403-948-7080 AB 1.1.5_sshfix 2018-04-21 23:49:00.0 P0009 Lunde Farm Inc. -6 America/Edmonton
4 Saskatoon [empty string] Canada 1545.0 0 [empty string] 0 0 0 1 [empty string] 52.13000 -106.62000 [empty string] [empty string] [empty string] [empty string] Craig Douglas 306-975-6999 SK [empty string] [empty string] P0010 Saskatoon -6 America/Regina
5 Birsay [empty string] Canada 2276.0 0 [empty string] 0 0 1 1 2015-06-03 10:00:00.0 51.14306 -107.09780 [empty string] [empty string] dp.erickson@sasktel.net Box 94 Birsay SK, S0L 0G0 Don Erickson 306-573-4647 SK 1.1.4_dbfix 2015-06-30 23:51:00.0 P0011 Erickson Farms -6 America/Regina
6 Brunkild [empty string] Canada 785.0 0 [empty string] 0 0 0 0 2014-07-07 16:00:00.0 49.55611 -97.63194 [empty string] [empty string] steven.pauls@richardson.ca; Scott.Wurmnest@richardson.ca [empty string] Scott Wurmnest; Steven Pauls 204-736-5000 MB [empty string] [empty string] P0012 Richardson Mollard -5 America/Winnipeg
7 St. Adolph [empty string] Canada 741.0 0 [empty string] 1 0 1 0 2016-10-21 03:00:00.0 49.67139 -97.11111 [empty string] [empty string] twaddell@ritchot.com [empty string] Tanya Waddell 204-883-2293 MB 1.1.1 2018-04-22 00:44:00.0 P0013 MB Water Stewardship - St. Adolphe -5 America/Winnipeg
8 Dominion City [empty string] Canada 787.0 0 [empty string] 1 0 1 0 2018-04-22 00:00:00.0 49.14111 -97.15305 [empty string] [empty string] rmfrank@escape.ca [empty string] Tracy French 204-427-2557 MB 1.1.1_sshfix 2018-04-22 00:54:00.0 P0014 MB Water Stewardship - Dominion City -5 America/Winnipeg
9 Vita [empty string] Canada 988.0 0 [empty string] 1 0 1 0 2018-04-22 00:00:00.0 49.13389 -96.56306 [empty string] Office is closed daily from 12:00 to 12:45 [empty string] [empty string] Judy Reimer 204-425-3218 MB 1.1.5 2018-04-22 00:55:00.0 P0015 MB Water Stewardship - Vita -5 America/Winnipeg
10 Elm Creek [empty string] Canada 827.0 0 ground 1 0 1 0 2018-04-10 13:00:00.0 49.67611 -97.99277 [empty string] Good siting. Open location. Info@rmofgrey.ca Box 99 27 Church Ave E Elm Creek MB, R0G 0N0 Annette Potvin 204-436-2014 MB 1.1.1_sshfix 2018-04-10 00:56:00.0 P0016 MB Water Stewardship - Elm Creek -5 America/Winnipeg
11 Rosenort [empty string] Canada 774.0 0 ground 1 0 1 0 2017-07-17 08:00:00.0 49.45778 -97.42972 [empty string] Not good siting. In town. Near streets. Near buildings. POC alternate number (c) 204-746-4774. dbenjami@mts.net Box 184 Rosenort MB, R0G 1W0 Myron Kroeker 204-746-2011 MB 1.1.1_dbfix 2018-04-22 00:57:00.0 P0017 MB Water Stewardship - Rosenort -5 America/Winnipeg
12 Rosenfeld [empty string] Canada 234.0 0 roof 1 0 1 0 2015-07-22 07:00:00.0 49.20078 -97.54969 [empty string] Ernie is at division office in Altona. Custodian: Warren Schroeder. School phone: 204-324-8438. Console in staff room. ernie@blsd.ca schroederw@blsd.ca Rosenfeld Public School, Box 72 Austin MB, R0H 0C0 Ernie Neufeld 204-324-6491 MB 1.1.5_dbfix 2016-05-09 00:48:00.0 P0018 MB Water Stewardship - Rosenfeld -5 America/Winnipeg
13 Ninette [empty string] Canada 1352.0 0 [empty string] 1 0 1 0 2016-11-29 08:00:00.0 49.40195 -99.63000 [empty string] On roof in town [empty string] [empty string] Linda Stephenson 204-528-5060 MB 1.1.1_dbfix 2017-03-14 00:59:00.0 P0019 MB Water Stewardship - Ninette -5 America/Winnipeg
14 Beausejour [empty string] Canada 784.0 0 [empty string] 1 0 1 0 2016-08-16 08:00:00.0 50.06278 -96.49611 [empty string] [empty string] rmbroken@granite.mb.ca Box 490 Beausejour MB, R0E 0C0 Gary Hanna 204-268-6700 MB 1.1.1_sshfix 2018-04-22 00:50:00.0 P0020 MB Water Stewardship - Beausejour -5 America/Winnipeg
15 Briercrest [empty string] Canada 1905.0 0 [empty string] 1 0 1 0 2018-04-22 00:00:00.0 50.16945 -105.26720 [empty string] [empty string] lwheeler@briergrain.ca Briercrest Grain Ltd Box 157 Briercrest SK, S0H 0K0 Lorrie Wheeler 306-799-4421 SK 1.1.4_sshfix 2018-04-21 23:51:00.0 P0021 Briercrest -6 America/Regina
16 Springside [empty string] Canada 1710.0 0 roof 1 0 1 0 2018-02-22 14:00:00.0 51.34472 -102.74170 [empty string] [empty string] springside@sasktel.net [empty string] Nancy Duns 306-792-2022 SK 1.1.3_dbfix 2018-02-22 00:52:00.0 P0022 MB Water Stewardship - Springside -6 America/Regina
17 Kamsack [empty string] Canada 1460.0 0 roof 1 0 1 0 2017-08-31 20:00:00.0 51.56222 -101.90250 [empty string] radio tower at rear for access rm271@sasktel.net [empty string] Sherry Guenther 306-542-2121 SK 1.1.5_dbfix 2017-08-30 23:53:00.0 P0023 MB Water Stewardship - Kamsack -6 America/Regina
18 Langham [empty string] Canada 1630.0 0 [empty string] 1 0 1 0 2018-04-22 00:00:00.0 52.27861 -106.98940 [empty string] [empty string] dvwiebe@yourlink.ca Box 680 Langham, SK, S0K 2L0 Doyle Wiebe 306-283-4340 SK 1.1.4_sshfix 2018-04-21 23:54:00.0 P0024 Langham -6 America/Regina
19 Hanley [empty string] Canada 1950.0 0 [empty string] 1 0 1 0 2016-10-18 07:00:00.0 51.63194 -106.43170 [empty string] [empty string] trailbreak@sasktel.net Box 324, 703 Lincoln St., Hanley SK, SOG 2EO Cam Goff 306-544-2526 SK 1.1.4_sshfix 2018-04-21 23:55:00.0 P0025 Hanley -6 America/Regina
20 Cremona [empty string] Canada 3680.0 0 ground 1 0 1 0 2018-01-31 17:00:00.0 51.55950 -114.39290 [empty string] console in shop. Manhattan USB connecter. bbmac@telusplanet.net [empty string] Bill MacFarquar 403-888-3980 AB 1.1.5_sshfix 2018-01-30 23:56:00.0 P0026 MacFarm -6 America/Edmonton
CACHED false
EXECUTIONTIME 9
SQL SELECT Top 20 * FROM weatherfarm.dbo.weatherbugstation WHERE StationID Like 'P[0-9]%'
Web User Table:
query
RESULTSET
query
  PASSWORD STATIONID USERID USERNAME
1 123 ARTHRCA 1 wf@weatherinnovations.com
2 [empty string] 44137 2 [empty string]
3 123 P0008 3 mar_guy.ash@shaw.ca
4 123 P0005 4 kelburn@richardson.ca
5 123 P0009 5 Glunde@efirehose.net
6 123 P0014 6 rmfrank@escape.ca
7 123 P2001 7 bdz@telus.net
8 123 P0013 8 twaddell@ritchot.com
9 123 P0016 9 Info@rmofgrey.ca
10 123 P0021 11 lwheeler@briergrain.ca
11 123 P0022 12 springside@sasktel.net
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM weatherfarm.dbo.WebUser