search

USEPA / Phytoplankton-Data-Analysis

Phytoplankton Data Analysis
3 stars 0 forks source link

6 character station id #15

Open mjpdenver opened 10 years ago

mjpdenver commented 10 years ago

How should station ids with a letter be recorded within the 24 digit to preserve the standard width? By default, I am stripping the letter, but keeping the full station id in the separate id field.

20001A

jbeaulie commented 10 years ago

Can you point me to an example of this?

mjpdenver commented 10 years ago

Here is a list of the file names greater than 5 characters. Often it is just a matter of a letter appended to the station name.

"20001A" "20001b" "20001B" "20001C" "20005A" "20005B" "20005C" "20011A" "20011B" "20011C" "20014A" "20014B" "20014C" "21001A" "21001B" "21001C" "2DEG3A" "2DEG3B" "A2DEG4" "ADEG4A" "ADEG4B" "BDEG4A" "BDEG4B" "CDEG4A" "CDEG4B"

Here is an full file path to an example.

Drew data/l/Phytoplankton 2006.xls

jbeaulie commented 10 years ago

We received "Corrected Site Names.xlsx" from Jade's staff on June 10, 2014. The spreadsheet indicates the correct site names.

Typically the trailing letter is stripped.

mjpdenver commented 10 years ago

I saved this in the QC/ folder and will commit to github.

On the algae tab, where there is no corrected name, by default - the original name will be used. Likewise, where there is no name in the "Different Name" column, the incorrect name will be used.

mjpdenver commented 10 years ago

Linked to ISSUE 9#