Columbus Ohio water profile? - Page 3 - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brew Science > Columbus Ohio water profile?

Reply
 
Thread Tools
Old 03-27-2013, 01:37 PM   #21
RDbrew
Recipes 
 
Feb 2013
, Ohio
Posts: 25
Liked 2 Times on 2 Posts


I know this is an old thread, but I wanted to update it with the active link for the current and archived copies of Columbus water profile -
http://publicutilities.columbus.gov/....aspx?id=38046


__________________
Primary: DFH 60min
Secondaries: Orange Honey Wheat
Bottled: Apfelwein, Irish Deadred

Coming Soon: Kentucky Rye

Brewphish Likes This 
Reply With Quote
Old 09-04-2013, 05:09 PM   #22
bnstewa
Recipes 
 
Mar 2012
Posts: 1
Liked 2 Times on 1 Posts


Quick Update:
I just called the water lab and got the most recent detailed numbers (2012) for the Hap Cremean plant

Total Alkalinity 30
Hardness 99
Ca 28
Mg 8
Na 12.7
Sulfate 58.6
Cl 24

Potassium 4.9



2
People Like This 
Reply With Quote
Old 07-21-2015, 02:09 PM   #23
Hopcalypse
Recipes 
 
Jul 2015
Columbus, OH
Posts: 7
Liked 1 Times on 1 Posts


Here is an update for the Dublin Road Plant 2014:
Click image for larger version

Name:	water2014.png
Views:	117
Size:	42.1 KB
ID:	291457  

vinylrooster Likes This 
Reply With Quote
Old 07-21-2015, 03:48 PM   #24
vinylrooster
Recipes 
 
May 2013
Columbus, OH and Buffalo, NY
Posts: 339
Liked 45 Times on 31 Posts


Quote:
Originally Posted by Hopcalypse View Post
Here is an update for the Dublin Road Plant 2014:
Thanks for the updated version
__________________
-Rooster

 
Reply With Quote
Old 08-01-2015, 03:08 PM   #25
merriman44
Recipes 
 
Jan 2014
Posts: 26
Liked 3 Times on 1 Posts


Anybody have the updated data for the Hap Cremean?

 
Reply With Quote
Old 02-16-2016, 04:12 PM   #26
cdj42086
Recipes 
 
Jan 2016
Posts: 4

Here are the averages from the Dublin Road Plant based on 2014 (latest available at this point):

Calcium 36
Magnesium 8
Sodium 68
Chloride 61
Sulfate 124
Alkalinity 48

Unfortunately, the sodium, sulfate, and chloride numbers suffer HUGE swings from month to month (deltas of 50ppm or more throughout the year) so it's hard to dial anything in without on-the-spot measurements here. I have included the full report just in case.

I made a water profile in Brewer's Friend Water Chemistry Calculator as well:
http://www.brewersfriend.com/mash-ch...or/?id=LRHMT8H
Click image for larger version

Name:	Columbus OH Dublin Rd Plant Water Report (2014).png
Views:	69
Size:	218.7 KB
ID:	337948  

 
Reply With Quote
Old 02-16-2016, 07:09 PM   #27
mabrungard
HBT_LIFETIMESUPPORTER.png
 
mabrungard's Avatar
Recipes 
 
Feb 2011
Carmel, IN
Posts: 4,085
Liked 584 Times on 451 Posts


Quote:
Originally Posted by cdj42086 View Post
Unfortunately, the sodium, sulfate, and chloride numbers suffer HUGE swings from month to month (deltas of 50ppm or more throughout the year) so it's hard to dial anything in without on-the-spot measurements here.
The measurements peak during the winter months. The increase is due to road salting. Its typical for many surface water sources in the north.
__________________
Martin B
Carmel, IN
BJCP National
Foam Blowers of Indiana (FBI)

Brewing Water Information at:
https://sites.google.com/site/brunwater/

Like Bru'n Water on Facebook for occasional discussions on brewing water and Bru'n Water
https://www.facebook.com/pages/Brun-...?ref=bookmarks

 
Reply With Quote
Old 02-16-2016, 09:51 PM   #28
cdj42086
Recipes 
 
Jan 2016
Posts: 4

That makes a lot of sense, thanks for help. I may go by the month by month readings rather than the average.

 
Reply With Quote
Old 02-17-2016, 09:23 PM   #29
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Aug 2010
McLean/Ogden, Virginia/Quebec
Posts: 8,925
Liked 1367 Times on 1042 Posts


Quote:
Originally Posted by mabrungard View Post
The measurements peak during the winter months. The increase is due to road salting. Its typical for many surface water sources in the north.
That certainly used to be the case but governments have become much more sensitive to this and whereas one used to see piles of salt in road maintenance yards in the past one now typically sees those things that look like beehives with the salt piles inside. This keeps rain from washing salt into/onto the area near the maintenance yards and has, apparently cut down on the amount of NaCl making it into the environment from that source.

So lets see what the data in #6 tell us. The upper array of numbers are the correlation coefficients for the monthly data in the table. The data in Mjn are the months from June. For example, for May Mjn = 2 as it does for August. Low Mjn numbers represent warm weather months and higher numbers represent cold weather months. Reading across the first (Mjn) row we see that sodium (0.8296) and chloride (0.8509) are both strongly correlated with months from summer but alkalinity is even more so at 0.9210 and sulfate (0.7797) slightly less so. Potassium, Calcium and Magnesium are not strongly tied to (correlated with) the months from June but they are highly predictable from the straight month of the year. This can be seen from reading across the bottom line (Mo = straight month numbers: Jan =1, Feb = 2...) where we note that potassium and magnesium are strongly correlated with how far into the year we are but that calcium is strongly anti-correlated (less calcium in the fall than in the spring).

The numbers in the bottom table are measures of the quality of the correlations in the top table. For example at the intersection of calcium and chloride in the upper table we see a weak correlation (0.1587) between those two ions. In that bottom table we see, at that same intersection, the number 0.3156. This is the probability that we would see a correlation as high or higher than 0.1587 if calcium and chloride were in fact not correlated. A probability as high as 1/3 (one chance in 3) isn't very convincing and we accept that there may be no relationship between the calcium and chloride. The county apparently isn't using calcium chloride for road deicing. We have much more confidence in the correlation between sodium and chloride where r =0.7579 and the probability that they are uncorrelated is only 0.15%. The county could be using sodium chloride but correlation doesn't prove causation and they probably aren't using sodium bicarbonate which is supported by r = 0.8086 and only an 0.04% chance that those ions are in fact independent. Nor are they probably using sodium sulfate.

This exercise was kind of fun and suggests several hypotheses. There could be a common explanation for the increases in Na, Cl, SO4 and Alkalinity or there could be separate ones (road salting for Na and Cl and something else for alkalinity and sulfate) etc.
Click image for larger version

Name:	Untitled 3.jpg
Views:	51
Size:	123.6 KB
ID:	338167  

 
Reply With Quote
Old 02-22-2016, 04:49 AM   #30
cdj42086
Recipes 
 
Jan 2016
Posts: 4

I was able to get the almost completed 2015 profile from the Dublin Rd plant as well (just missing Na for December). Hope this helps.

Calcium 34
Magnesium 9
Sodium 70.4
Chloride 61.5
Sulfate 116
Alkalinity 49
pH 7.75

Overall, pretty similar to 2014 so we are dealing with a pretty stable source.

See attachments for full report and the appropriate BeerSmith water profile.

As a side note (for anyone looking for more detail) the majority of Columbus City Water is surface water retrieved from the Scioto River and Big Walnut Creek as well as a bit of groundwater from an "unconfined" (not covered by layers of clay) sand/gravel aquifer located in the Scioto River Valley. Columbus City Water is treated with Chlorine (1.51 ppm avg.) rather than Chloramine, which is beneficial for brewing given the ease of removal vs its counterpart. Check out this great link on the many ways to remove it and pros/cons of each: http://homebrew.stackexchange.com/qu...from-tap-water


Click image for larger version

Name:	2015_Water_Profile.PNG
Views:	45
Size:	128.4 KB
ID:	339201  
File Type: pdf DRWP_Tap2015 ANO2.pdf (22.4 KB, 22 views)
File Type: bsmx Columbus_Ohio_Water.bsmx (978 Bytes, 10 views)

 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columbus hop profile minduim Beginners Beer Brewing Forum 24 05-20-2016 05:35 PM
Columbus, Ohio - Columbus Microbrew Festival FireNightFly Great Lakes Homebrew Forum 10 09-14-2009 02:51 PM
Columbus Ohio Hop Buy dfohio General Beer Discussion 16 09-08-2009 12:41 PM


Forum Jump