Project

General

Profile

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?