Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hebertmj13
Starting Member
1 Post |
 Posted - 2009-09-03 : 16:14:15
|
This is kind of a SQL and a GIS question.I am working on a Field Calculation in ESRI Arc Map.I have a Hazen- Williams Hydrant flow formula that I am trying to replicate in SQL.This is the formula that I have to put into sql.QR = QF x hr^0.54hf^0.54 The values are as follows:QR = Desired flow @20 PSIhr = Static(psi)- Desired (psi)hf = Static (psi) - Residual(psi)QF= Flow )gpm)This is what I have written in SQL:[Flow_GPM] *(( [Static_PSI] - [Desired_PS])) * Exp ( 0.54) /( [Static_PSI] - [Residual_P]) * Exp ( 0.54 )I am not getting a clean batch run through field calculator.Any suggestions.Thanks. |
|
|
|
|
|
GIS SQL Formula _ Hazen-Williams