Improving cost of water by considering pumping/extraction cost

[ipsitakumar]

Getting cost data at one of these levels

1. Source
2. County
3. State, or
4. Infrastructure

[ulall]

these are water costs?
production costs?
storage costs?

On Thu, Jul 28, 2016 at 10:51 AM, ipsitakumar notifications@github.com
wrote:

Getting cost data at one of these levels

1. Source
2. County
3. State, or
4. Infrastructure

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#4, or mute the thread
https://github.com/notifications/unsubscribe-auth/AE3cO6adkMeyuUiUl5Wntc6Z4lwYKjtQks5qaMHygaJpZM4JXTAD
.

Upmanu Lall
Alan & Carol Silberstein Professor of Engineering,
Dept. of Earth & Environmental Engineering
Dept. of Civil Eng. & Eng. Mechanics
Director, Columbia Water Center
Senior Research Scientist, International Research Institute for Climate &
Society
842F Mudd
Columbia University
500 W 120th Street
New York, NY 10027

http://www.columbia.edu/~ula2/
http://water.columbia.edu/
http://bigthink.com/users/upmanulall

[ipsitakumar]

This is cost of water supply

[ulall]

hmm

On Thu, Jul 28, 2016 at 5:17 PM, ipsitakumar notifications@github.com
wrote:

This is cost of water supply

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#4 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AE3cO_Q9iJsXxu-LKzqL4ukfCHA-H_GTks5qaRx7gaJpZM4JXTAD
.

Upmanu Lall
Alan & Carol Silberstein Professor of Engineering,
Dept. of Earth & Environmental Engineering
Dept. of Civil Eng. & Eng. Mechanics
Director, Columbia Water Center
Senior Research Scientist, International Research Institute for Climate &
Society
842F Mudd
Columbia University
500 W 120th Street
New York, NY 10027

http://www.columbia.edu/~ula2/
http://water.columbia.edu/
http://bigthink.com/users/upmanulall

[mallaire]

Hi Ipsita,
Did those EPA surveys help (cost of water treatment)?

Another source for treatment costs: McGiveney and Kawamura 2008 'Cost
estimating manual for water treatment facilities'

On Thu, Jul 28, 2016 at 5:22 PM, ulall notifications@github.com wrote:

hmm

On Thu, Jul 28, 2016 at 5:17 PM, ipsitakumar notifications@github.com
wrote:

This is cost of water supply

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#4 (comment)
,
or mute the thread
<
https://github.com/notifications/unsubscribe-auth/AE3cO_Q9iJsXxu-LKzqL4ukfCHA-H_GTks5qaRx7gaJpZM4JXTAD

.

Upmanu Lall
Alan & Carol Silberstein Professor of Engineering,
Dept. of Earth & Environmental Engineering
Dept. of Civil Eng. & Eng. Mechanics
Director, Columbia Water Center
Senior Research Scientist, International Research Institute for Climate &
Society
842F Mudd
Columbia University
500 W 120th Street
New York, NY 10027

http://www.columbia.edu/~ula2/
http://water.columbia.edu/
http://bigthink.com/users/upmanulall

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#4 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/APp6gAlPX4q6vPwbaAJlUL_KS8AccRCTks5qaR1-gaJpZM4JXTAD
.

Maura Allaire
Postdoctoral Research Scientist

Columbia Water Center
842 S.W. Mudd
Columbia University
500 W 120th Street
New York, NY 10027

[LaurelineJ]

Following our last meeting, we will replace national fixed values to reflect extraction cost.

GW: height of water table are now available in each county. We will assume a cost linear to the depth to the water table and to energy price.
SW: if the point of use is at higher elevation than point of withdrawal, costs are introduced (similarly to GW).

[jrising]

From operational-problem: "This is used for cost calculations for surface water. The pressure of delivery for urban should be 20 m, and for irrigation should be 5 m."

[jrising]

We now use the AWWA regression to estimate water costs, and an RA (Harshit?) is working on improving this with per-meter pumping costs. @LaurelineJ Can you add Harshit to our github organization and assign this task? I'm going to set the task to the WSEC milestone.

[LaurelineJ]

Xiangyu has already done this work (you can find it here). Using ground water table depth information from a global hydrogeological model calibrated based on USGS data or using the raw USGS data directly, Xiangyu sees no significant correlation between cost and depth:

plm(formula = costs ~ SurfaceMG + GroundMG + PurchasesMG + depth, 
   data = awwa2, model = "between")

Unbalanced Panel: n = 320, T = 1-1, N = 320
Observations used in estimation: 320

Residuals:
     Min.   1st Qu.    Median      Mean   3rd Qu.      Max. 
-1.92e+08 -1.17e+07 -7.71e+06  0.00e+00  1.53e+06  3.02e+08 

Coefficients:
               Estimate  Std. Error t-value  Pr(>|t|)    
(Intercept) 16402565.15  4849033.88  3.3826 0.0008085 ***
SurfaceMG       1628.72      131.20 12.4141 < 2.2e-16 ***
GroundMG        1916.46      293.67  6.5259 2.698e-10 ***
PurchasesMG     3122.46      215.10 14.5164 < 2.2e-16 ***
depth          -5758.38     3659.43 -1.5736 0.1165901    
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Total Sum of Squares:    1.3123e+18
Residual Sum of Squares: 5.4859e+17
R-Squared:      0.58196
Adj. R-Squared: 0.57666
F-statistic: 109.631 on 4 and 315 DF, p-value: < 2.22e-16

This issue is a sub-part of the WIP: watercost pull request. I think we can drop this thread.

[jrising]

This regression isn't what I was expecting. Don't we want to regress
Costs ~ SurfaceMG + GroundMG + PurchasesMG + depth * GroundMG.

If that produces negative values for any of the terms, then you need to use nnnpls or its Julia equivalent.

The last commit I see on that PR is a year ago.