search

rssidlowski / Pollution_Source_Tracking

City of Baltimore Pollution Source Tracking
0 stars 0 forks source link

Data conversion: flow volume #154

Closed rssidlowski closed 9 years ago

rssidlowski commented 9 years ago

Looks like the data conversion needs to be corrected for flow volume calculations. From the legacy system see this sample for 801 N. Linwood: flow1 See flow tab and note flow volume is 3 liter bottle, time is 60 sec: flow2 Here is the legacy data table: flowsamplelegacy But after the conversion the pst sample table has flowsamplenew The conversion is converting the type (flownum)to the fl_bottle_size and the bottle size (fvolume) to fl_volume_cfs. See the same sample record in the new PST app: flowsampleappnew

It should be the other way around, convert the flownum to the correct lookup value for flow method. fvolume should convert to the fl_bottle_size.

Also, the calculations are not being stored in the new solution. See #10 for the calculations for cfs and gpm.

.

gerrykelly commented 9 years ago

I also calced the gpm/cfs for all and increased the number of digits for those fields in the app calc function (since the cfs especially often rounded down to zero)

rssidlowski commented 9 years ago

Verified.