Author Topic: Large scale data editing....  (Read 4015 times)

jg

  • Strong Breeze
  • ***
  • Posts: 153
Large scale data editing....
« on: July 24, 2013, 03:42:30 AM »
So a lighting strike wiped out the #3 soil temp and moisture ports for my brand new davis soil/leaf station.  i was able to move the wires to port 2 and the sensors are reading fine.  is there an easy way to migrate the data from 3 to 2 (and then correct some of the weird reading like -90 degrees, etc?

jg

  • Strong Breeze
  • ***
  • Posts: 153
Re: Large scale data editing....
« Reply #1 on: July 24, 2013, 06:10:49 PM »
I was able to do a find replace to fix this in text edit.  The next question is how do I remove incorrect entries without deleting the entire row of data.  As an example, I have some Soil Temperature readings of 169, 32, etc. from when I was having problems. Looking at the data file, it looks the readings are all in Celsius, is that correct.  If I wanted to remove the ones that are definitely bad (i.e, St2:-55.6 in July), do I just replace "St2:-55.6" with ""?

WCDev

  • WeatherCat Developer
  • Administrator
  • Storm
  • *****
  • Posts: 2987
    • CW9739
    • IIBSTO2
    • Trixology
  • Station Details: Main Station: Vantage Pro-2, 24hr fars, solar, extra temp stations, no U.V. WeatherLinkLive.
Re: Large scale data editing....
« Reply #2 on: July 25, 2013, 08:17:31 PM »
Thats bad luck with the lightning!

Simplest thing to do is to replace the reading with the preceding reading for that channel.

The units in the data file are ?C for temperatures, mm's for precipitation, km/h for wind speeds and hPa's for pressure.

Always take a copy of your WeatherCatData folder before editing the data just incase of an editing mistake.

[Edit: I'd suggest an editor that won't mess the formatting of the file -  TextWrangler works well - http://www.barebones.com/products/textwrangler/]

jg

  • Strong Breeze
  • ***
  • Posts: 153
Re: Large scale data editing....
« Reply #3 on: July 26, 2013, 12:01:02 AM »
Thats bad luck with the lightning!

Simplest thing to do is to replace the reading with the preceding reading for that channel.

The units in the data file are ?C for temperatures, mm's for precipitation, km/h for wind speeds and hPa's for pressure.

Always take a copy of your WeatherCatData folder before editing the data just incase of an editing mistake.

[Edit: I'd suggest an editor that won't mess the formatting of the file -  TextWrangler works well - http://www.barebones.com/products/textwrangler/]

Thanks, unfortunately I have hundreds of incorrect entries throughout the data file.  I'll give textwrangler as shot.