|
1
|
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?
|
