Columbus Ohio water profile? - Page 3 - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brew Science > Columbus Ohio water profile?
Cool Brewing Corny 5G & Mini Giveaway
Sign-up To NEW HBT Article Newsletter - Brewing Articles Direct To You!

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

Default

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
RDbrew is offline
Brewphish Likes This 
Reply With Quote
Old 09-04-2013, 05:09 PM   #22
bnstewa
Recipes 
 
Join Date: Mar 2012
Posts: 1
Liked 2 Times on 1 Posts

Default

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


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

Default

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

Name:	water2014.png
Views:	92
Size:	42.1 KB
ID:	291457  
Hopcalypse is offline
vinylrooster Likes This 
Reply With Quote
Old 07-21-2015, 03:48 PM   #24
vinylrooster
Recipes 
 
Join Date: May 2013
Location: Columbus, OH and Buffalo, NY
Posts: 339
Liked 45 Times on 31 Posts
Likes Given: 23

Default

Quote:
Originally Posted by Hopcalypse View Post
Here is an update for the Dublin Road Plant 2014:
Thanks for the updated version
__________________
-Rooster
vinylrooster is offline
 
Reply With Quote
Old 08-01-2015, 03:08 PM   #25
merriman44
Recipes 
 
Join Date: Jan 2014
Posts: 26
Liked 3 Times on 1 Posts
Likes Given: 5

Default

Anybody have the updated data for the Hap Cremean?
merriman44 is offline
 
Reply With Quote
Old 02-16-2016, 04:12 PM   #26
cdj42086
Recipes 
 
Join Date: Jan 2016
Posts: 4
Default 2014 Dublin Road Plant Averages

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:	51
Size:	218.7 KB
ID:	337948  
cdj42086 is offline
 
Reply With Quote
Old 02-16-2016, 07:09 PM   #27
mabrungard
HBT_LIFETIMESUPPORTER.png
 
mabrungard's Avatar
Recipes 
 
Join Date: Feb 2011
Location: Carmel, IN
Posts: 3,942
Liked 526 Times on 415 Posts
Likes Given: 33

Default

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
mabrungard is offline
 
Reply With Quote
Old 02-16-2016, 09:51 PM   #28
cdj42086
Recipes 
 
Join Date: Jan 2016
Posts: 4
Default

That makes a lot of sense, thanks for help. I may go by the month by month readings rather than the average.
cdj42086 is offline
 
Reply With Quote
Old 02-17-2016, 09:23 PM   #29
ajdelange
HBT_LIFETIMESUPPORTER.png
Recipes 
 
Join Date: Aug 2010
Location: McLean/Ogden, Virginia/Quebec
Posts: 8,658
Liked 1271 Times on 978 Posts
Likes Given: 38

Default

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:	31
Size:	123.6 KB
ID:	338167  
ajdelange is offline
 
Reply With Quote
Old 02-22-2016, 04:49 AM   #30
cdj42086
Recipes 
 
Join Date: Jan 2016
Posts: 4
Default 2015 Columbus OH Water Profile

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:	23
Size:	128.4 KB
ID:	339201  
File Type: pdf DRWP_Tap2015 ANO2.pdf (22.4 KB, 18 views)
File Type: bsmx Columbus_Ohio_Water.bsmx (978 Bytes, 6 views)
cdj42086 is offline
 
Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columbus hop profile minduim Beginners Beer Brewing Forum 23 03-20-2015 12:39 PM
Columbus, Ohio - Columbus Microbrew Festival FireNightFly Ohio 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