1 |
3613
|
aaronmk
|
Important:
|
2 |
|
|
Cleaned up and exported spreadsheets are in "Madidi.cleaned_up.zip" and *.xls.
|
3 |
|
|
Exported file names may not contain spaces.
|
4 |
|
|
Before exporting a spreadsheet tab to CSV, delete the 2nd header row.
|
5 |
|
|
Otherwise, it will be interpreted as a data row.
|
6 |
|
|
Remember to export both plots and organisms tabs (see translations below).
|
7 |
|
|
|
8 |
|
|
Translations:
|
9 |
|
|
Inventory description, Datos descripcion de las PPM = plots
|
10 |
|
|
Data base, Datos de las PPM = organisms
|
11 |
|
|
PPM, PP = Parcelas Permanentes de Muestreo = BIEN2.datasources.xlsx "Madidi Permanent Plots"
|
12 |
|
|
PT = BIEN2.datasources.xlsx "Madidi Transects"
|
13 |
|
|
|
14 |
|
|
Notes:
|
15 |
|
|
Expedition number and Expedition name are consistent (globally unique) between PPM and PT data
|
16 |
|
|
There appears to be no data of inventory type C, although it's listed in the column name "Type Inventory (C, PP, TP)"
|
17 |
|
|
|
18 |
|
|
Questions:
|
19 |
|
|
How should an "expedition" (trip) be mapped: project, plot, plot event, or something else?
|
20 |
|
|
See note above about Expedition name/number
|
21 |
|
|
How should an "inventory" be mapped: plot or plot event?
|
22 |
|
|
Why is inventory type only in the organisms sheet, but important enough to be included in the flat file name?
|
23 |
|
|
|
24 |
|
|
To do:
|
25 |
|
|
Need a SQL function to translate Spanish dates to English
|
26 |
|
|
can Python strptime(), Python dateutil.parser.parse(), or PHP/GNU strtotime() do this?
|