poissonconsulting / tsdbr

R package to create, populate, maintain and query SQLite databases of environmental time series data
https://poissonconsulting.github.io/tsdbr/
Other
1 stars 0 forks source link

may need more dynamic ts_read_zrxp if 2023-01 data errors on read in #31

Closed evanamiesgalonski closed 1 year ago

evanamiesgalonski commented 1 year ago

fixed zrxp file this time but if recurring problem will need to improve read in code to rely more completely on REGEX to format data from text files (zrxp)

record of fix based on comparison of last months Poisson_ColumbiaWISKI.zrxp: <-- indicates insertion point

1.  addition
#REXCHANGEFQU_ENVR_Air_Temp_00|*|TSPATH/08N/FQU/Obs_AirTemp/Cmd.PrimaryQC|*|
#CUNIT?C|*|RINVAL-777|*|SNAMEArrow Res at Fauquier|*|SANRFQU|*|
##SITENAMESTFIX_S, STAA_FORMAT_S, KLDT|*| <--

2. addition
#TSPATH/08N/DON/Modelled_StreamDischarge/Hour.Mean.Best|*|CUNITcms|*|RINVAL-777|*|
##SITENAME           |*| <--

3. replacement
#REXCHANGECNN_TW_Raw|*|TSPATH/08N/CNN/Obs_WaterTemp/Cmd.Raw|*|CUNIT?C|*|
#RINVAL-777|*|SNAMEColumbia R bl Norns Ck|*|SANRCNN|*|
##SITENAMESTFIX_S, STAA_FORMAT_S, KLDT|*| <--

#replace <-- line with
##SITENAME           |*|

4. removal
# for site #REXCHANGEDCN_ENVR_Air_Temp_00|*|TSPATH/08N/DCN/Obs_AirTemp/Cmd.PrimaryQC|*|
# and secondary #TSPATH/08N/DCN/Obs_AirTemp/Cmd.SecondaryQC|*|CUNIT?C|*|RINVAL-777|*|
# remove in each
##SITENAMESTFIX_S, STAA_FORMAT_S, KLDT|*|