We're looking at trying to estimate the actual local time of observations from the timestamps. The cleanest way to do this would be to work out the time difference based on the site longitude and the effective longitude of the UTC offset for each site. That difference is usually going to be pretty small but for sites in wide timezones (e.g. Asia/Shanghai) it could be pretty big.
It looks like you already include some site metadata from the BADM files in the site level tables - would it be possible to extract and include the UTF_OFFSET field in that table?
We're looking at trying to estimate the actual local time of observations from the timestamps. The cleanest way to do this would be to work out the time difference based on the site longitude and the effective longitude of the UTC offset for each site. That difference is usually going to be pretty small but for sites in wide timezones (e.g. Asia/Shanghai) it could be pretty big.
It looks like you already include some site metadata from the BADM files in the site level tables - would it be possible to extract and include the
UTF_OFFSETfield in that table?