Project

General

Profile

« Previous | Next » 

Revision 3613

Added by Aaron Marcuse-Kubitza over 12 years ago

Added inputs/Madidi/ with empty mappings

View differences:

inputs/Madidi/test/VegX.plots.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegX/>
inputs/Madidi/test/VegX.organisms.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegX/>
inputs/Madidi/test/VegBIEN.plots.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegBIEN/>
inputs/Madidi/test/VegBIEN.organisms.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegBIEN/>
inputs/Madidi/test/import.plots.out.ref
1 
Inserted 0 new rows into database
inputs/Madidi/test/import.organisms.out.ref
1 
Inserted 0 new rows into database
inputs/Madidi/maps/src.plots.csv
1 
Madidi,VegX:/*s/plotObservation,Comments
2 
Inventory number,,
3 
Expedition number,,
4 
Expedition name,,
5 
Number of inventory (expedition),,
6 
Inventory name,,
7 
Inventory code,,
8 
First evaluation,,
9 
Installed and evaluated by,,
10 
Collaborators,,
11 
Related Epilocs,,
12 
Area,,
13 
Number of stems,,
14 
Number of trees,,
15 
Coordinates,,
16 
Latitude,,
17 
Longitude,,
18 
Latitude (DMS),,
19 
Longitude (DMS),,
20 
Altitude,,
21 
Minimum altitude,,
22 
Locality,,
23 
Locality description,,
24 
Direction,,
25 
Vegetation type,,
26 
Topographical situation,,
27 
Slope,,
28 
Soil sample,,
29 
pH acuoso (ISRIC 4–– 1 - 14),,
30 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),,
31 
Nitrógeno total (ISRIC 6–%–0.0014),,
32 
"Carbón Orgánico (WSP S-9,10–%–0.06)",,
33 
"Materia Orgánica (WSP S-9,10–%–0.1)",,
34 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),,
35 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
36 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",,
37 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",,
38 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
39 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),,
40 
CIC (ISRIC 11–cmolc/Kg–0.05),,
41 
Arena (DIN 18 123–%–2.5),,
42 
Limo (DIN 18 123–%–1),,
43 
Arcilla (DIN 18 123–%–1),,
44 
Textural class,,
45 
Observaciones,,
46 
Orientación/exposicion,,
inputs/Madidi/maps/src.organisms.csv
1 
Madidi,VegX:/*s/individualOrganismObservation,Comments
2 
Expedition,,
3 
Inventory name,,
4 
Number of inventory (general),,
5 
Number of inventory (expedition),,
6 
"Type Inventory (C, PP, TP)",,
7 
Inventory code,,
8 
Tag number,,
9 
Tree number,,
10 
Number of subplot,,
11 
Index collector,,
12 
Specimen,,
13 
Similar specimen,,
14 
Plot specimen,,
15 
Expedition specimen,,
16 
Project specimen,,
17 
Field family,,
18 
Field name,,
19 
Family (revised),,
20 
Specie+autor,,
21 
Genera,,
22 
Specific epithet,,
23 
Species and morphotypes,,
24 
Autor (revised),,
25 
Determined by,,
26 
Qualifier,,
27 
Common name,,
28 
Circumference,,
29 
Diameter,,
30 
Trunk,,
31 
Total height,,
32 
Bole height,,
33 
Habit,,
34 
Phenology,,
35 
Crown position,,
36 
Crown shape,,
37 
Liana presence,,
38 
Basal area,,
39 
Subplot X,,
40 
Subplot Y,,
41 
Plot X,,
42 
Plot Y,,
43 
Observations,,
inputs/Madidi/maps/VegX.plots.csv
1 
Madidi,VegX:/*s/plotObservation,Comments
2 
Inventory number,,
3 
Expedition number,,
4 
Expedition name,,
5 
Number of inventory (expedition),,
6 
Inventory name,,
7 
Inventory code,,
8 
First evaluation,,
9 
Installed and evaluated by,,
10 
Collaborators,,
11 
Related Epilocs,,
12 
Area,,
13 
Number of stems,,
14 
Number of trees,,
15 
Coordinates,,
16 
Latitude,,
17 
Longitude,,
18 
Latitude (DMS),,
19 
Longitude (DMS),,
20 
Altitude,,
21 
Minimum altitude,,
22 
Locality,,
23 
Locality description,,
24 
Direction,,
25 
Vegetation type,,
26 
Topographical situation,,
27 
Slope,,
28 
Soil sample,,
29 
pH acuoso (ISRIC 4–– 1 - 14),,
30 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),,
31 
Nitrógeno total (ISRIC 6–%–0.0014),,
32 
"Carbón Orgánico (WSP S-9,10–%–0.06)",,
33 
"Materia Orgánica (WSP S-9,10–%–0.1)",,
34 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),,
35 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
36 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",,
37 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",,
38 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
39 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),,
40 
CIC (ISRIC 11–cmolc/Kg–0.05),,
41 
Arena (DIN 18 123–%–2.5),,
42 
Limo (DIN 18 123–%–1),,
43 
Arcilla (DIN 18 123–%–1),,
44 
Textural class,,
45 
Observaciones,,
46 
Orientación/exposicion,,
inputs/Madidi/maps/VegX.plots.full.csv
1 
Madidi,VegX:/*s/plotObservation,Comments
2 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),,
3 
Altitude,,
4 
Arcilla (DIN 18 123–%–1),,
5 
Area,,
6 
Arena (DIN 18 123–%–2.5),,
7 
CIC (ISRIC 11–cmolc/Kg–0.05),,
8 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",,
9 
"Carbón Orgánico (WSP S-9,10–%–0.06)",,
10 
Collaborators,,
11 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),,
12 
Coordinates,,
13 
Direction,,
14 
Expedition name,,
15 
Expedition number,,
16 
First evaluation,,
17 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),,
18 
Installed and evaluated by,,
19 
Inventory code,,
20 
Inventory name,,
21 
Inventory number,,
22 
Latitude,,
23 
Latitude (DMS),,
24 
Limo (DIN 18 123–%–1),,
25 
Locality,,
26 
Locality description,,
27 
Longitude,,
28 
Longitude (DMS),,
29 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
30 
"Materia Orgánica (WSP S-9,10–%–0.1)",,
31 
Minimum altitude,,
32 
Nitrógeno total (ISRIC 6–%–0.0014),,
33 
Number of inventory (expedition),,
34 
Number of stems,,
35 
Number of trees,,
36 
Observaciones,,
37 
Orientación/exposicion,,
38 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",,
39 
Related Epilocs,,
40 
Slope,,
41 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,
42 
Soil sample,,
43 
Textural class,,
44 
Topographical situation,,
45 
Vegetation type,,
46 
pH acuoso (ISRIC 4–– 1 - 14),,
inputs/Madidi/maps/VegX.organisms.csv
1 
Madidi,VegX:/*s/individualOrganismObservation,Comments
2 
Expedition,,
3 
Inventory name,,
4 
Number of inventory (general),,
5 
Number of inventory (expedition),,
6 
"Type Inventory (C, PP, TP)",,
7 
Inventory code,,
8 
Tag number,,
9 
Tree number,,
10 
Number of subplot,,
11 
Index collector,,
12 
Specimen,,
13 
Similar specimen,,
14 
Plot specimen,,
15 
Expedition specimen,,
16 
Project specimen,,
17 
Field family,,
18 
Field name,,
19 
Family (revised),,
20 
Specie+autor,,
21 
Genera,,
22 
Specific epithet,,
23 
Species and morphotypes,,
24 
Autor (revised),,
25 
Determined by,,
26 
Qualifier,,
27 
Common name,,
28 
Circumference,,
29 
Diameter,,
30 
Trunk,,
31 
Total height,,
32 
Bole height,,
33 
Habit,,
34 
Phenology,,
35 
Crown position,,
36 
Crown shape,,
37 
Liana presence,,
38 
Basal area,,
39 
Subplot X,,
40 
Subplot Y,,
41 
Plot X,,
42 
Plot Y,,
43 
Observations,,
inputs/Madidi/maps/VegX.organisms.full.csv
1 
Madidi,"VegX::[@xmlns:tcs=""http://www.tdwg.org/schemas/tcs/1.01""]/*s/individualOrganismObservation",Comments
2 
Autor (revised),,
3 
Basal area,,
4 
Bole height,,
5 
Circumference,,
6 
Common name,,
7 
Crown position,,
8 
Crown shape,,
9 
Determined by,,
10 
Diameter,,
11 
Expedition,,
12 
Expedition specimen,,
13 
Family (revised),,
14 
Field family,,
15 
Field name,,
16 
Genera,,
17 
Habit,,
18 
Index collector,,
19 
Inventory code,,
20 
Inventory name,,
21 
Liana presence,,
22 
Number of inventory (expedition),,
23 
Number of inventory (general),,
24 
Number of subplot,,
25 
Observations,,
26 
Phenology,,
27 
Plot X,,
28 
Plot Y,,
29 
Plot specimen,,
30 
Project specimen,,
31 
Qualifier,,
32 
Similar specimen,,
33 
Specie+autor,,
34 
Species and morphotypes,,
35 
Specific epithet,,
36 
Specimen,,
37 
Subplot X,,
38 
Subplot Y,,
39 
Tag number,,
40 
Total height,,
41 
Tree number,,
42 
Trunk,,
43 
"Type Inventory (C, PP, TP)",,
inputs/Madidi/maps/VegBIEN.plots.csv
1 
Madidi,VegBIEN:/locationevent,Comments
2 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),,** No input mapping for Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05) **
3 
Altitude,,** No input mapping for Altitude **
4 
Arcilla (DIN 18 123–%–1),,** No input mapping for Arcilla (DIN 18 123–%–1) **
5 
Area,,** No input mapping for Area **
6 
Arena (DIN 18 123–%–2.5),,** No input mapping for Arena (DIN 18 123–%–2.5) **
7 
CIC (ISRIC 11–cmolc/Kg–0.05),,** No input mapping for CIC (ISRIC 11–cmolc/Kg–0.05) **
8 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",,"** No input mapping for Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016) ** "
9 
"Carbón Orgánico (WSP S-9,10–%–0.06)",,"** No input mapping for Carbón Orgánico (WSP S-9,10–%–0.06) ** "
10 
Collaborators,,** No input mapping for Collaborators **
11 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),,** No input mapping for Conductividad electrica (ASPT 6–µS/cm– 1 - 10000) **
12 
Coordinates,,** No input mapping for Coordinates **
13 
Direction,,** No input mapping for Direction **
14 
Expedition name,,** No input mapping for Expedition name **
15 
Expedition number,,** No input mapping for Expedition number **
16 
First evaluation,,** No input mapping for First evaluation **
17 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),,** No input mapping for Fósforo disponible (ISRIC 14-2–mg/Kg–1.5) **
18 
Installed and evaluated by,,** No input mapping for Installed and evaluated by **
19 
Inventory code,,** No input mapping for Inventory code **
20 
Inventory name,,** No input mapping for Inventory name **
21 
Inventory number,,** No input mapping for Inventory number **
22 
Latitude,,** No input mapping for Latitude **
23 
Latitude (DMS),,** No input mapping for Latitude (DMS) **
24 
Limo (DIN 18 123–%–1),,** No input mapping for Limo (DIN 18 123–%–1) **
25 
Locality,,** No input mapping for Locality **
26 
Locality description,,** No input mapping for Locality description **
27 
Longitude,,** No input mapping for Longitude **
28 
Longitude (DMS),,** No input mapping for Longitude (DMS) **
29 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,"** No input mapping for Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083) ** "
30 
"Materia Orgánica (WSP S-9,10–%–0.1)",,"** No input mapping for Materia Orgánica (WSP S-9,10–%–0.1) ** "
31 
Minimum altitude,,** No input mapping for Minimum altitude **
32 
Nitrógeno total (ISRIC 6–%–0.0014),,** No input mapping for Nitrógeno total (ISRIC 6–%–0.0014) **
33 
Number of inventory (expedition),,** No input mapping for Number of inventory (expedition) **
34 
Number of stems,,** No input mapping for Number of stems **
35 
Number of trees,,** No input mapping for Number of trees **
36 
Observaciones,,** No input mapping for Observaciones **
37 
Orientación/exposicion,,** No input mapping for Orientación/exposicion **
38 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",,"** No input mapping for Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053) ** "
39 
Related Epilocs,,** No input mapping for Related Epilocs **
40 
Slope,,** No input mapping for Slope **
41 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",,"** No input mapping for Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083) ** "
42 
Soil sample,,** No input mapping for Soil sample **
43 
Textural class,,** No input mapping for Textural class **
44 
Topographical situation,,** No input mapping for Topographical situation **
45 
Vegetation type,,** No input mapping for Vegetation type **
46 
pH acuoso (ISRIC 4–– 1 - 14),,** No input mapping for pH acuoso (ISRIC 4–– 1 - 14) **
inputs/Madidi/maps/VegBIEN.organisms.csv
1 
Madidi,VegBIEN:/plantobservation,Comments
2 
Autor (revised),,** No input mapping for Autor (revised) **
3 
Basal area,,** No input mapping for Basal area **
4 
Bole height,,** No input mapping for Bole height **
5 
Circumference,,** No input mapping for Circumference **
6 
Common name,,** No input mapping for Common name **
7 
Crown position,,** No input mapping for Crown position **
8 
Crown shape,,** No input mapping for Crown shape **
9 
Determined by,,** No input mapping for Determined by **
10 
Diameter,,** No input mapping for Diameter **
11 
Expedition,,** No input mapping for Expedition **
12 
Expedition specimen,,** No input mapping for Expedition specimen **
13 
Family (revised),,** No input mapping for Family (revised) **
14 
Field family,,** No input mapping for Field family **
15 
Field name,,** No input mapping for Field name **
16 
Genera,,** No input mapping for Genera **
17 
Habit,,** No input mapping for Habit **
18 
Index collector,,** No input mapping for Index collector **
19 
Inventory code,,** No input mapping for Inventory code **
20 
Inventory name,,** No input mapping for Inventory name **
21 
Liana presence,,** No input mapping for Liana presence **
22 
Number of inventory (expedition),,** No input mapping for Number of inventory (expedition) **
23 
Number of inventory (general),,** No input mapping for Number of inventory (general) **
24 
Number of subplot,,** No input mapping for Number of subplot **
25 
Observations,,** No input mapping for Observations **
26 
Phenology,,** No input mapping for Phenology **
27 
Plot X,,** No input mapping for Plot X **
28 
Plot Y,,** No input mapping for Plot Y **
29 
Plot specimen,,** No input mapping for Plot specimen **
30 
Project specimen,,** No input mapping for Project specimen **
31 
Qualifier,,** No input mapping for Qualifier **
32 
Similar specimen,,** No input mapping for Similar specimen **
33 
Specie+autor,,** No input mapping for Specie+autor **
34 
Species and morphotypes,,** No input mapping for Species and morphotypes **
35 
Specific epithet,,** No input mapping for Specific epithet **
36 
Specimen,,** No input mapping for Specimen **
37 
Subplot X,,** No input mapping for Subplot X **
38 
Subplot Y,,** No input mapping for Subplot Y **
39 
Tag number,,** No input mapping for Tag number **
40 
Total height,,** No input mapping for Total height **
41 
Tree number,,** No input mapping for Tree number **
42 
Trunk,,** No input mapping for Trunk **
43 
"Type Inventory (C, PP, TP)",,"** No input mapping for Type Inventory (C, PP, TP) ** "
inputs/Madidi/src/_README.TXT
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?


  		












  

    
      inputs/Madidi/src/+header.plots.csv
    
  





  
  1
  
    
!Inventory number,Expedition number,Expedition name,Number of inventory (expedition),Inventory name,Inventory code,First evaluation,Installed and evaluated by,Collaborators,Related Epilocs,Area,Number of stems,Number of trees,Coordinates,Latitude,Longitude,Latitude (DMS),Longitude (DMS),Altitude,Minimum altitude,Locality,Locality description,Direction,Vegetation type,Topographical situation,Slope,Soil sample,pH acuoso (ISRIC 4–– 1 - 14),Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),Nitrógeno total (ISRIC 6–%–0.0014),"Carbón Orgánico (WSP S-9,10–%–0.06)","Materia Orgánica (WSP S-9,10–%–0.1)",Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)","Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)","Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)","Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),CIC (ISRIC 11–cmolc/Kg–0.05),Arena (DIN 18 123–%–2.5),Limo (DIN 18 123–%–1),Arcilla (DIN 18 123–%–1),Textural class,Observaciones,Orientación/exposicion


  		












Also available in:  Unified diff