search

jasonelaw / nrsa

R package for calculating habitat metrics from the National Rivers and Streams Assessment protocol
3 stars 1 forks source link

d50 - change DB data type #20

Closed juliaabond closed 5 years ago

juliaabond commented 6 years ago

d50 (Median mobile substrate diameter) Approx. 50 of the records have a D50 value of 0. I'm guess this is because the pct_fn substrate size corresponds to 0.001 and the pct_sa substrate size corresponds to 0.06mm, so the small value is being rounded to zero when converting to an integer.

To resolve this we need to modify the data type in the DB.

image

jasonelaw commented 5 years ago

I think this has been fixed in db.