RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2014",0.5874705882,0.9950782353,17,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2014",0.6580505882,1.0339305882,17,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2014",1.1168952632,1.8383363158,19,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2014",1.2312621053,1.5091300000,19,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2014",0.9845266667,1.0081222222,18,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2014",0.7139611111,0.8868738889,18,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2014",0.4445194444,0.6280722222,18,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2014",0.9438594444,1.2979405556,18,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2014",0.9285811111,1.2682277778,18,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2014",0.8843177778,1.3630344444,18,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2014",1.1255055556,1.4204488889,18,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2014",1.2988783333,1.6876061111,18,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2014",0.9624466667,1.3296738889,18,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2014",0.8880441176,1.2566970588,17,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2014",0.8867400000,1.2673300000,18,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2014",0.6354458824,1.0104594118,17,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2014",0.8590816667,1.0481394444,18,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2014 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2014",0.9386176471,1.0961988235,17,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END
RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2015",0.6812850526,0.8636076842,19,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2015",0.8375686316,1.0802465263,19,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2015",0.8370297000,1.0201949500,20,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2015",0.7457838500,0.8935282000,20,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2015",0.6925651000,0.8499564000,20,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2015",0.7624388000,0.8954194500,20,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2015",0.8228685000,1.0425722500,20,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2015",1.1545579500,1.3877961500,20,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2015",0.8365767500,1.0857404000,20,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2015",1.5343364000,1.9656237000,20,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2015",1.2274994000,1.6011401500,20,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2015",1.2724870000,1.4966011579,19,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2015",0.5331630500,0.6560423500,20,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2015",0.3596732000,0.5289052000,20,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2015",0.5086825500,0.6053090500,20,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2015",0.3117255000,0.4377826500,20,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2015",0.7158960000,0.8569141053,19,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2015 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2015",0.6496108000,0.7326559500,20,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END
RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2016",0.5438906250,0.7325643333,24,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2016",0.4929340417,0.6786397917,24,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2016",0.7516092917,1.0513989583,24,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2016",0.6173803333,0.7551152917,24,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2016",0.7897548333,1.0820615833,24,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2016",0.8308867500,1.0419040833,24,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2016",0.8320189583,1.0974462083,24,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2016",0.9804985000,1.2900697500,24,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2016",0.8226920417,1.1765122083,24,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2016",0.8397887917,1.1049967500,24,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2016",0.9138850417,1.1047453333,24,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2016",0.9157819167,1.1183224583,24,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=CE11 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Union Road North
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE11","2016",0.8081633043,1.0242225217,23,43.920685,-87.781731,"Union Road North")

END
RRTsiteid=CE12 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Union Road Mid
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE12","2016",0.8912430000,1.0536397143,7,43.906631,-87.780914,"Union Road Mid")

END
RRTsiteid=CE13 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Union Road South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE13","2016",2.3612887917,3.6858264167,24,43.894852,-87.781631,"Union Road South")

END
RRTsiteid=CE14 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Highway DL
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE14","2016",1.6591985417,2.2607645000,24,43.903069,-87.761703,"Highway DL")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2016",0.5579959583,0.6956859167,24,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2016",0.4488976818,0.5552920455,22,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2016",0.3003557917,0.3796067500,24,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2016",0.3295070000,0.4467535833,24,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2016",0.4554277500,0.6905630417,24,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2016 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2016",0.5253587083,0.6422787500,24,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END
RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2017",0.3210181818,0.4543327273,22,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2017",0.3446063636,0.4734163636,22,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2017",0.5380862727,0.8182352727,22,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2017",0.6372103182,0.9011930455,22,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2017",0.5031309091,0.7053279545,22,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2017",0.6149491818,0.8514449091,22,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2017",0.6828897273,0.8914024545,22,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2017",0.7583357273,1.1505956818,22,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2017",0.3536183182,0.4731505909,22,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2017",0.3687250000,0.5529281364,22,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2017",0.4320707727,0.5396759091,22,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2017",0.4339253182,0.5508091818,22,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=CE11 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Union Road North
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE11","2017",0.3758815455,0.7482640909,22,43.920685,-87.781731,"Union Road North")

END
RRTsiteid=CE12 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Union Road Mid
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE12","2017",0.2596187500,0.4473750000,8,43.906631,-87.780914,"Union Road Mid")

END
RRTsiteid=CE13 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Union Road South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE13","2017",2.1602742273,2.9029352727,22,43.894852,-87.781631,"Union Road South")

END
RRTsiteid=CE14 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Highway DL
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE14","2017",1.4978005909,1.9038437273,22,43.903069,-87.761703,"Highway DL")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2017",0.2836445455,0.6337618182,22,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2017",0.3120059091,0.4283600000,22,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2017",0.2611177273,0.3613040909,22,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2017",0.6708722727,1.0862868182,22,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2017",0.3838336364,0.5309077273,22,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2017 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2017",0.3705809091,0.4811022727,22,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END
RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2018",0.6263580500,0.9350306000,20,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2018",0.4337715000,0.6276394000,20,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2018",0.6185514286,1.1227548571,21,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2018",0.6205235238,1.2284704762,21,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2018",0.6201328095,1.0183016190,21,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE03-N RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03-N","2018",0.4981222857,1.0056658571,21,43.917549,-87.729668,"")

END
RRTsiteid=CE03-S RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03-S","2018",0.7359342857,0.9582943333,21,43.917549,-87.729668,"")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2018",0.6971643333,1.0595178095,21,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2018",0.7857441429,1.3139508571,21,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2018",1.0865484286,1.9682384762,21,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2018",0.4748815714,0.7043880476,21,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2018",0.6203333810,1.0822238095,21,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2018",0.4839621500,0.7365322000,20,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2018",0.5834267500,1.0287350500,20,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=CE11 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Union Road North
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE11","2018",0.4116109444,0.6712652778,18,43.920685,-87.781731,"Union Road North")

END
RRTsiteid=CE13 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Union Road South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE13","2018",2.5117143810,3.5331339048,21,43.894852,-87.781631,"Union Road South")

END
RRTsiteid=CE14 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Highway DL
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE14","2018",1.3701882500,1.7810926250,16,43.903069,-87.761703,"Highway DL")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2018",0.4405671000,0.6592318000,20,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2018",0.3157525000,0.5035148000,20,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2018",0.2617747500,0.3639629000,20,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2018",0.2784077500,0.3995936500,20,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2018",0.3908488500,0.5424190500,20,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2018 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2018",0.3498355500,0.5302527500,20,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END
RRTsiteid=CA02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Calvin Creek South 26th St.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA02","2019",0.1244980000,0.2801206667,6,44.036640,-87.680809,"Calvin Creek South 26th St.")

END
RRTsiteid=CA03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Calvin Creek Northeim Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CA03","2019",0.0542170000,0.1521085000,4,44.029545,-87.701324,"Calvin Creek Northeim Rd.")

END
RRTsiteid=CE01 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville Flowage Dam
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE01","2019",0.0642570000,0.3303213333,6,43.916050,-87.726120,"Centerville Flowage Dam")

END
RRTsiteid=CE02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville Flowage Midpoint
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE02","2019",0.0642570000,0.2851403333,6,43.916389,-87.726662,"Centerville Flowage Midpoint")

END
RRTsiteid=CE03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville Flowage Confluence
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE03","2019",0.0993976667,0.2449800000,6,43.917549,-87.729668,"Centerville Flowage Confluence")

END
RRTsiteid=CE04 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville South Branch Birch
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE04","2019",0.0592373333,0.1596383333,6,43.917309,-87.731163,"Centerville South Branch Birch")

END
RRTsiteid=CE05 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville South Branch Cente
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE05","2019",0.0592370000,0.1144576667,6,43.916176,-87.741478,"Centerville South Branch Cente")

END
RRTsiteid=CE06 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville South Branch South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE06","2019",0.0542165000,0.1671690000,4,43.906696,-87.755829,"Centerville South Branch South")

END
RRTsiteid=CE07 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville North Branch Frank
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE07","2019",0.0466865000,0.7771085000,4,43.921532,-87.732712,"Centerville North Branch Frank")

END
RRTsiteid=CE08 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville North Branch Dairy
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE08","2019",0.0542165000,0.1521085000,4,43.926060,-87.747787,"Centerville North Branch Dairy")

END
RRTsiteid=CE09 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville North Branch LTC
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE09","2019",0.0542170000,0.2500000000,4,43.921398,-87.754227,"Centerville North Branch LTC")

END
RRTsiteid=CE10 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Centerville North Branch Washi
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE10","2019",0.1445780000,0.2274100000,4,43.914040,-87.767342,"Centerville North Branch Washi")

END
RRTsiteid=CE11 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Union Road North
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE11","2019",0.0466865000,0.2198795000,4,43.920685,-87.781731,"Union Road North")

END
RRTsiteid=CE13 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Union Road South
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE13","2019",0.0617470000,0.2725905000,4,43.894852,-87.781631,"Union Road South")

END
RRTsiteid=CE14 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Highway DL
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("CE14","2019",0.0768070000,0.1972895000,4,43.903069,-87.761703,"Highway DL")

END
RRTsiteid=FI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Fischer Creek LS
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI02","2019",0.0592370000,0.1746986667,6,43.937405,-87.724663,"Fischer Creek LS")

END
RRTsiteid=FI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Fischer Creek Dairyland Dr.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("FI03","2019",0.1596385000,0.2500000000,4,43.941109,-87.742012,"Fischer Creek Dairyland Dr.")

END
RRTsiteid=PI02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Pine Creek Hwy. U
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI02","2019",0.1295180000,0.3604416667,6,43.994171,-87.702438,"Pine Creek Hwy. U")

END
RRTsiteid=PI03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Pine Creek South Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PI03","2019",0.1521080000,0.5286145000,4,44.000099,-87.721153,"Pine Creek South Gass Lake Rd.")

END
RRTsiteid=PO02 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Point Creek Schuettes
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO02","2019",0.0642573333,0.2751003333,6,43.956692,-87.718971,"Point Creek Schuettes")

END
RRTsiteid=PO03 RRTavg_phosphatetotal= RRTavg_phosphatetotal_cnt= RRTavg_year=2019 RRTsite=Point Creek S. Gass Lake Rd.
INSERT INTO tempDataShowIt06_12_58am (siteid, avg_year, avg_analysisTwo, avg_analysisOne, avg_analysisOne_cnt, lat, lng, site) VALUES ("PO03","2019",0.0391565000,0.0993975000,4,43.961498,-87.721840,"Point Creek S. Gass Lake Rd.")

END LNRP UW-Manitowoc Intern Water Sampling
LNRP/LWI-Manitowoc
Water Sampling Sites
Showing Each Year
All Samples
2014-2018 Averages
phosphatetotal and phosphate
Value with 2 decimal places
Click for HELP or ALL the data.