Project

General

Profile

« Previous | Next » 

Revision 4107

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs: Renamed plots table to 0.plots so import order would be inherent in the dir name, using steps at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCSV_subfolders#Rename-subfolders-with-import-order>

View differences:

inputs/Madidi/test/import.plots.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <area>$Area</area>
5 
        <authorlocationcode>$Inventory name</authorlocationcode>
6 
        <elevation>
7 
            <_alt>
8 
                <1>
9 
                    <_replace>
10 
                        <\bca\.?></\bca\.?>
11 
                        <value>$Altitude</value>
12 
                    </_replace>
13 
                </1>
14 
                <2>
15 
                    <_avg>
16 
                        <min>
17 
                            <_units>
18 
                                <default>m</default>
19 
                                <to>m</to>
20 
                                <to></to>
21 
                                <value>
22 
                                    <_rangeStart>
23 
                                        <value>
24 
                                            <_replace>
25 
                                                <\bca\.?></\bca\.?>
26 
                                                <value>$Minimum altitude</value>
27 
                                            </_replace>
28 
                                        </value>
29 
                                    </_rangeStart>
30 
                                </value>
31 
                            </_units>
32 
                        </min>
33 
                    </_avg>
34 
                </2>
35 
            </_alt>
36 
        </elevation>
37 
        <elevationrange>
38 
            <_range>
39 
                <from>
40 
                    <_units>
41 
                        <default>m</default>
42 
                        <to>m</to>
43 
                        <to></to>
44 
                        <value>
45 
                            <_rangeStart>
46 
                                <value>
47 
                                    <_replace>
48 
                                        <\bca\.?></\bca\.?>
49 
                                        <value>$Minimum altitude</value>
50 
                                    </_replace>
51 
                                </value>
52 
                            </_rangeStart>
53 
                        </value>
54 
                    </_units>
55 
                </from>
56 
                <to>
57 
                    <_units>
58 
                        <default>m</default>
59 
                        <to>m</to>
60 
                        <to></to>
61 
                        <value>
62 
                            <_rangeEnd>
63 
                                <value>
64 
                                    <_replace>
65 
                                        <\bca\.?></\bca\.?>
66 
                                        <value>$Minimum altitude</value>
67 
                                    </_replace>
68 
                                </value>
69 
                            </_rangeEnd>
70 
                        </value>
71 
                    </_units>
72 
                </to>
73 
            </_range>
74 
        </elevationrange>
75 
        <landform>$Topographical situation</landform>
76 
        <locationdetermination>
77 
            <latitude>
78 
                <_nullIf>
79 
                    <null>0</null>
80 
                    <type>float</type>
81 
                    <value>
82 
                        <_alt>
83 
                            <1>$Latitude</1>
84 
                            <2>$Latitude (DMS)</2>
85 
                        </_alt>
86 
                    </value>
87 
                </_nullIf>
88 
            </latitude>
89 
            <longitude>
90 
                <_nullIf>
91 
                    <null>0</null>
92 
                    <type>float</type>
93 
                    <value>
94 
                        <_alt>
95 
                            <1>$Longitude</1>
96 
                            <2>$Longitude (DMS)</2>
97 
                        </_alt>
98 
                    </value>
99 
                </_nullIf>
100 
            </longitude>
101 
        </locationdetermination>
102 
        <locationevent>
103 
            <project_id>
104 
                <project>
105 
                    <projectname>$Expedition name</projectname>
106 
                    <sourceaccessioncode>$Expedition number</sourceaccessioncode>
107 
                </project>
108 
            </project_id>
109 
            <commclass>
110 
                <commdetermination>
111 
                    <commconcept_id>
112 
                        <commconcept>
113 
                            <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>
114 
                            <commdescription>$Locality description</commdescription>
115 
                        </commconcept>
116 
                    </commconcept_id>
117 
                </commdetermination>
118 
            </commclass>
119 
            <obsstartdate><_date><date><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></date></_date></obsstartdate>
120 
            <soilobs>
121 
                <acidity>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</acidity>
122 
                <calcium>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</calcium>
123 
                <carbon>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</carbon>
124 
                <cationexchangecapacity>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity>
125 
                <clay>$Arcilla (DIN 18 123&#8211;%&#8211;1)</clay>
126 
                <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>
127 
                <magnesium>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</magnesium>
128 
                <nitrogen>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</nitrogen>
129 
                <organic>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</organic>
130 
                <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>
131 
                <phosphorus>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</phosphorus>
132 
                <potassium>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</potassium>
133 
                <sand>$Arena (DIN 18 123&#8211;%&#8211;2.5)</sand>
134 
                <silt>$Limo (DIN 18 123&#8211;%&#8211;1)</silt>
135 
                <sodium>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</sodium>
136 
                <texture>$Textural class</texture>
137 
            </soilobs>
138 
        </locationevent>
139 
        <locationnarrative>$Locality</locationnarrative>
140 
        <notespublic>$Observaciones</notespublic>
141 
        <slopeaspect>
142 
            <_compass>
143 
                <value>
144 
                    <_alt>
145 
                        <1>$Direction</1>
146 
                        <2>$Orientaci&#243;n/exposicion</2>
147 
                    </_alt>
148 
                </value>
149 
            </_compass>
150 
        </slopeaspect>
151 
        <slopegradient>$Slope</slopegradient>
152 
        <sourceaccessioncode>$Inventory code</sourceaccessioncode>
153 
    </location>
154 
</VegBIEN>
155 
Inserted 19 new rows into database
inputs/Madidi/maps/Veg+.plots.csv
1 
Madidi,Veg+,Comments
2 
Inventory number,,Not globally unique
3 
Expedition number,projectID,Consistent (globally unique) between PPM and PT data
4 
Expedition name,projectName,Consistent (globally unique) between PPM and PT data
5 
Number of inventory (expedition),,The number of the event within the project
6 
Inventory name,plotName,
7 
Inventory code,locationID,
8 
First evaluation,plotEventStartDate,
9 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
10 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
11 
Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
12 
Area,plotArea,
13 
Number of stems,,Do we want to store this data?
14 
Number of trees,,Do we want to store this data?
15 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
16 
Latitude,decimalLatitude/_alt/1,
17 
Longitude,decimalLongitude/_alt/1,
18 
Latitude (DMS),decimalLatitude/_alt/2,
19 
Longitude (DMS),decimalLongitude/_alt/2,
20 
Altitude,verbatimElevation,
21 
Minimum altitude,minimumElevationInMeters,
22 
Locality,locality,
23 
Locality description,communityName,Often begins with the text in Vegetation type
24 
Direction,slopeAspect/_alt/1,Part files provide either this field or Direction
25 
Vegetation type,communityID,
26 
Topographical situation,landform,
27 
Slope,slopeGradient,
28 
Soil sample,,Always empty
29 
pH acuoso (ISRIC 4–– 1 - 14),ph,
30 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,
31 
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,
32 
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon,
33 
"Materia Orgánica (WSP S-9,10–%–0.1)",organic,
34 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus,
35 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,
36 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium,
37 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium,
38 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium,
39 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,
40 
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity,
41 
Arena (DIN 18 123–%–2.5),sand,
42 
Limo (DIN 18 123–%–1),silt,
43 
Arcilla (DIN 18 123–%–1),clay,
44 
Textural class,texture,
45 
Observaciones,plotNotes,
46 
Orientación/exposicion,slopeAspect/_alt/2,Part files provide either this field or Orientación
inputs/Madidi/maps/src.plots.csv
1 
Madidi,Veg+,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/VegBIEN.plots.csv
1 
Madidi,VegBIEN:,Comments
2 
Area,/location/area,
3 
Inventory name,/location/authorlocationcode/_alt/1,
4 
Altitude,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
5 
Minimum altitude,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
6 
Minimum altitude,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 
Minimum altitude,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
8 
Topographical situation,/location/landform,
9 
Latitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",
10 
Latitude (DMS),"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",
11 
Longitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/1",
12 
Longitude (DMS),"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value/_alt/2",
13 
Expedition name,/location/locationevent/*_id/project/projectname,Consistent (globally unique) between PPM and PT data
14 
Expedition number,/location/locationevent/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data
15 
Vegetation type,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
16 
Locality description,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type
17 
First evaluation,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
18 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/acidity,
19 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilobs/calcium,
20 
"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilobs/carbon,
21 
CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilobs/cationexchangecapacity,
22 
Arcilla (DIN 18 123–%–1),/location/locationevent/soilobs/clay,
23 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),/location/locationevent/soilobs/conductivity,
24 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/magnesium,
25 
Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilobs/nitrogen,
26 
"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilobs/organic,
27 
pH acuoso (ISRIC 4–– 1 - 14),/location/locationevent/soilobs/ph,
28 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilobs/phosphorus,
29 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilobs/potassium,
30 
Arena (DIN 18 123–%–2.5),/location/locationevent/soilobs/sand,
31 
Limo (DIN 18 123–%–1),/location/locationevent/soilobs/silt,
32 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilobs/sodium,
33 
Textural class,/location/locationevent/soilobs/texture,
34 
Locality,/location/locationnarrative/_merge/1,
35 
Observaciones,/location/notespublic,
36 
Direction,/location/slopeaspect/_compass/value/_alt/1,Part files provide either this field or Direction
37 
Orientación/exposicion,/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or Orientación
38 
Slope,/location/slopegradient,
39 
Inventory code,/location/sourceaccessioncode,
40 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
42 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
43 
Inventory number,,Not globally unique
44 
Number of inventory (expedition),,The number of the event within the project
45 
Number of stems,,Do we want to store this data?
46 
Number of trees,,Do we want to store this data?
47 
Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
48 
Soil sample,,Always empty
inputs/Madidi/maps/Veg+.plots.full.csv
1 
Madidi,Veg+,Comments
2 
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,
3 
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium,
4 
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon,
5 
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity,
6 
Arcilla (DIN 18 123–%–1),clay,
7 
Vegetation type,communityID,
8 
Locality description,communityName,Often begins with the text in Vegetation type
9 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,
10 
Latitude,decimalLatitude/_alt/1,
11 
Latitude (DMS),decimalLatitude/_alt/2,
12 
Longitude,decimalLongitude/_alt/1,
13 
Longitude (DMS),decimalLongitude/_alt/2,
14 
Topographical situation,landform,
15 
Locality,locality,
16 
Inventory code,locationID,
17 
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium,
18 
Minimum altitude,minimumElevationInMeters,
19 
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,
20 
"Materia Orgánica (WSP S-9,10–%–0.1)",organic,
21 
pH acuoso (ISRIC 4–– 1 - 14),ph,
22 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus,
23 
Area,plotArea,
24 
First evaluation,plotEventStartDate,
25 
Inventory name,plotName,
26 
Observaciones,plotNotes,
27 
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium,
28 
Expedition number,projectID,Consistent (globally unique) between PPM and PT data
29 
Expedition name,projectName,Consistent (globally unique) between PPM and PT data
30 
Arena (DIN 18 123–%–2.5),sand,
31 
Limo (DIN 18 123–%–1),silt,
32 
Direction,slopeAspect/_alt/1,Part files provide either this field or Direction
33 
Orientación/exposicion,slopeAspect/_alt/2,Part files provide either this field or Orientación
34 
Slope,slopeGradient,
35 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,
36 
Textural class,texture,
37 
Altitude,verbatimElevation,
38 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
39 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
40 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 
Inventory number,,Not globally unique
42 
Number of inventory (expedition),,The number of the event within the project
43 
Number of stems,,Do we want to store this data?
44 
Number of trees,,Do we want to store this data?
45 
Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
46 
Soil sample,,Always empty
inputs/Madidi/src/plots/+header.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
inputs/SALVIAS-CSV/test/import.plots.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <area>$plot_area_ha</area>
5 
        <authorlocationcode>$plot_code</authorlocationcode>
6 
        <elevation>
7 
            <_alt>
8 
                <1>
9 
                    <_replace>
10 
                        <\bca\.?></\bca\.?>
11 
                        <value>$elev_m</value>
12 
                    </_replace>
13 
                </1>
14 
                <2>
15 
                    <_avg>
16 
                        <max>
17 
                            <_units>
18 
                                <default>m</default>
19 
                                <to>m</to>
20 
                                <to></to>
21 
                                <value>
22 
                                    <_replace>
23 
                                        <\bca\.?></\bca\.?>
24 
                                        <value>$elev_max_m</value>
25 
                                    </_replace>
26 
                                </value>
27 
                            </_units>
28 
                        </max>
29 
                        <min>
30 
                            <_units>
31 
                                <default>m</default>
32 
                                <to>m</to>
33 
                                <to></to>
34 
                                <value>
35 
                                    <_rangeStart>
36 
                                        <value>
37 
                                            <_replace>
38 
                                                <\bca\.?></\bca\.?>
39 
                                                <value>$elev_min_m</value>
40 
                                            </_replace>
41 
                                        </value>
42 
                                    </_rangeStart>
43 
                                </value>
44 
                            </_units>
45 
                        </min>
46 
                    </_avg>
47 
                </2>
48 
            </_alt>
49 
        </elevation>
50 
        <elevationrange>
51 
            <_range>
52 
                <from>
53 
                    <_units>
54 
                        <default>m</default>
55 
                        <to>m</to>
56 
                        <to></to>
57 
                        <value>
58 
                            <_rangeStart>
59 
                                <value>
60 
                                    <_replace>
61 
                                        <\bca\.?></\bca\.?>
62 
                                        <value>$elev_min_m</value>
63 
                                    </_replace>
64 
                                </value>
65 
                            </_rangeStart>
66 
                        </value>
67 
                    </_units>
68 
                </from>
69 
                <to>
70 
                    <_units>
71 
                        <default>m</default>
72 
                        <to>m</to>
73 
                        <to></to>
74 
                        <value>
75 
                            <_alt>
76 
                                <1>
77 
                                    <_replace>
78 
                                        <\bca\.?></\bca\.?>
79 
                                        <value>$elev_max_m</value>
80 
                                    </_replace>
81 
                                </1>
82 
                                <2>
83 
                                    <_rangeEnd>
84 
                                        <value>
85 
                                            <_replace>
86 
                                                <\bca\.?></\bca\.?>
87 
                                                <value>$elev_min_m</value>
88 
                                            </_replace>
89 
                                        </value>
90 
                                    </_rangeEnd>
91 
                                </2>
92 
                            </_alt>
93 
                        </value>
94 
                    </_units>
95 
                </to>
96 
            </_range>
97 
        </elevationrange>
98 
        <locationdetermination>
99 
            <latitude>
100 
                <_nullIf>
101 
                    <null>0</null>
102 
                    <type>float</type>
103 
                    <value>$lat_decimal</value>
104 
                </_nullIf>
105 
            </latitude>
106 
            <longitude>
107 
                <_nullIf>
108 
                    <null>0</null>
109 
                    <type>float</type>
110 
                    <value>$long_decimal</value>
111 
                </_nullIf>
112 
            </longitude>
113 
            <namedplace_id>
114 
                <_simplifyPath>
115 
                    <next>parent_id/namedplace</next>
116 
                    <require>placename</require>
117 
                    <path>
118 
                        <namedplace>
119 
                            <rank>county</rank>
120 
                            <placename>$pol2</placename>
121 
                            <parent_id>
122 
                                <namedplace>
123 
                                    <rank>stateProvince</rank>
124 
                                    <placename>$pol1</placename>
125 
                                    <parent_id>
126 
                                        <namedplace>
127 
                                            <rank>country</rank>
128 
                                            <placename>$country</placename>
129 
                                            <parent_id>
130 
                                                <namedplace>
131 
                                                    <rank>continent</rank>
132 
                                                    <placename>$major_geo</placename>
133 
                                                </namedplace>
134 
                                            </parent_id>
135 
                                        </namedplace>
136 
                                    </parent_id>
137 
                                </namedplace>
138 
                            </parent_id>
139 
                        </namedplace>
140 
                    </path>
141 
                </_simplifyPath>
142 
            </namedplace_id>
143 
        </locationdetermination>
144 
        <locationevent>
145 
            <method_id><method><name>$plot_methodology</name></method></method_id>
146 
            <project_id><project><projectname>$project</projectname></project></project_id>
147 
            <commclass>
148 
                <commdetermination>
149 
                    <commconcept_id>
150 
                        <commconcept>
151 
                            <commname_id><commname><commname>$holdridge_life_zone</commname></commname></commname_id>
152 
                            <commdescription>$life_zone_code</commdescription>
153 
                        </commconcept>
154 
                    </commconcept_id>
155 
                </commdetermination>
156 
            </commclass>
157 
            <obsenddate><_date><date><_dateRangeEnd><value>$date_finish</value></_dateRangeEnd></date></_date></obsenddate>
158 
            <obsstartdate><_date><date><_dateRangeStart><value>$date_start</value></_dateRangeStart></date></_date></obsstartdate>
159 
            <precipitation>$precip_mm</precipitation>
160 
            <soilobs>
161 
                <acidity>
162 
                    <_units>
163 
                        <default>%</default>
164 
                        <to></to>
165 
                        <value>
166 
                            <_map>
167 
                                <<0.05>0</<0.05>
168 
                                <*>*</*>
169 
                                <value>$soil_acidity</value>
170 
                            </_map>
171 
                        </value>
172 
                    </_units>
173 
                </acidity>
174 
                <basesaturation>
175 
                    <_units>
176 
                        <default>%</default>
177 
                        <to></to>
178 
                        <value>$soil_base</value>
179 
                    </_units>
180 
                </basesaturation>
181 
                <calcium>
182 
                    <_units>
183 
                        <default>%</default>
184 
                        <to></to>
185 
                        <value>$soil_Ca</value>
186 
                    </_units>
187 
                </calcium>
188 
                <carbon>
189 
                    <_units>
190 
                        <default>%</default>
191 
                        <to></to>
192 
                        <value>$soil_C</value>
193 
                    </_units>
194 
                </carbon>
195 
                <cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
196 
                <clay>
197 
                    <_units>
198 
                        <default>%</default>
199 
                        <to></to>
200 
                        <value>$clay_percent</value>
201 
                    </_units>
202 
                </clay>
203 
                <conductivity>$soil_conductivity</conductivity>
204 
                <magnesium>
205 
                    <_units>
206 
                        <default>%</default>
207 
                        <to></to>
208 
                        <value>$soil_Mg</value>
209 
                    </_units>
210 
                </magnesium>
211 
                <nitrogen>
212 
                    <_units>
213 
                        <default>%</default>
214 
                        <to></to>
215 
                        <value>$soil_N</value>
216 
                    </_units>
217 
                </nitrogen>
218 
                <organic>
219 
                    <_units>
220 
                        <default>%</default>
221 
                        <to></to>
222 
                        <value>$organic_percent</value>
223 
                    </_units>
224 
                </organic>
225 
                <ph>$pH</ph>
226 
                <phosphorus>
227 
                    <_units>
228 
                        <default>%</default>
229 
                        <to></to>
230 
                        <value>
231 
                            <_map>
232 
                                <<1,5>0</<1,5>
233 
                                <*>*</*>
234 
                                <value>$soil_P</value>
235 
                            </_map>
236 
                        </value>
237 
                    </_units>
238 
                </phosphorus>
239 
                <potassium>
240 
                    <_units>
241 
                        <default>%</default>
242 
                        <to></to>
243 
                        <value>$soil_K</value>
244 
                    </_units>
245 
                </potassium>
246 
                <sand>
247 
                    <_units>
248 
                        <default>%</default>
249 
                        <to></to>
250 
                        <value>$sand_percent</value>
251 
                    </_units>
252 
                </sand>
253 
                <silt>
254 
                    <_units>
255 
                        <default>%</default>
256 
                        <to></to>
257 
                        <value>$silt_percent</value>
258 
                    </_units>
259 
                </silt>
260 
                <sodium>
261 
                    <_units>
262 
                        <default>%</default>
263 
                        <to></to>
264 
                        <value>$soil_Na</value>
265 
                    </_units>
266 
                </sodium>
267 
                <texture>$soil_texture</texture>
268 
            </soilobs>
269 
            <temperature>$temp_c</temperature>
270 
        </locationevent>
271 
        <locationnarrative>$locality_description</locationnarrative>
272 
        <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
273 
        <slopegradient>$slope_gradient</slopegradient>
274 
        <sourceaccessioncode>$PLOT_ID</sourceaccessioncode>
275 
    </location>
276 
</VegBIEN>
277 
Inserted 16 new rows into database
inputs/SALVIAS-CSV/maps/Veg+.plots.csv
1 
SALVIAS-CSV,Veg+,Comments
2 
project,projectName,
3 
PLOT_ID,locationID,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
4 
plot_code,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
5 
major_geo,continent,
6 
country,country,
7 
pol1,stateProvince,Brad: No; pol1=stateProvince
8 
pol2,county,Brad: No pol2=countyParish
9 
locality_description,locality,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
10 
lat_decimal,decimalLatitude,
11 
long_decimal,decimalLongitude,
12 
elev_m,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
13 
elev_max_m,maximumElevationInMeters,
14 
elev_min_m,minimumElevationInMeters,
15 
temp_c,temperature,
16 
precip_mm,precipitation,
17 
slope_aspect,slopeAspect,
18 
slope_gradient,slopeGradient,
19 
clay_percent,"clay/_units:[default=""%"",to=]/value",
20 
silt_percent,"silt/_units:[default=""%"",to=]/value",
21 
sand_percent,"sand/_units:[default=""%"",to=]/value",
22 
organic_percent,"organic/_units:[default=""%"",to=]/value",
23 
pH,ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
24 
soil_N,"nitrogen/_units:[default=""%"",to=]/value",
25 
soil_P,"phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
26 
soil_C,"carbon/_units:[default=""%"",to=]/value",
27 
soil_K,"potassium/_units:[default=""%"",to=]/value",
28 
soil_Mg,"magnesium/_units:[default=""%"",to=]/value",
29 
soil_Ca,"calcium/_units:[default=""%"",to=]/value",
30 
soil_Na,"sodium/_units:[default=""%"",to=]/value",
31 
soil_acidity,"acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
32 
soil_base,"baseSaturation/_units:[default=""%"",to=]/value",
33 
soil_cation_cap,cationExchangeCapacity,
34 
soil_conductivity,conductivity,
35 
soil_texture,texture,
36 
holdridge_life_zone,communityID,
37 
life_zone_code,communityName,
38 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
39 
plot_methodology,samplingProtocol,
40 
plot_area_ha,plotArea,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
41 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
42 
date_start,plotEventStartDate,
43 
date_finish,plotEventEndDate,
inputs/SALVIAS-CSV/maps/src.plots.csv
1 
SALVIAS-CSV,Veg+,Comments
2 
project,,
3 
PLOT_ID,,
4 
plot_code,,
5 
major_geo,,
6 
country,,
7 
pol1,,
8 
pol2,,
9 
locality_description,,
10 
lat_decimal,,
11 
long_decimal,,
12 
elev_m,,
13 
elev_max_m,,
14 
elev_min_m,,
15 
temp_c,,
16 
precip_mm,,
17 
slope_aspect,,
18 
slope_gradient,,
19 
clay_percent,,
20 
silt_percent,,
21 
sand_percent,,
22 
organic_percent,,
23 
pH,,
24 
soil_N,,
25 
soil_P,,
26 
soil_C,,
27 
soil_K,,
28 
soil_Mg,,
29 
soil_Ca,,
30 
soil_Na,,
31 
soil_acidity,,
32 
soil_base,,
33 
soil_cation_cap,,
34 
soil_conductivity,,
35 
soil_texture,,
36 
holdridge_life_zone,,
37 
life_zone_code,,
38 
observation_type,,
39 
plot_methodology,,
40 
plot_area_ha,,
41 
recensused,,
42 
date_start,,
43 
date_finish,,
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
1 
SALVIAS-CSV,VegBIEN:,Comments
2 
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
3 
plot_code,/location/authorlocationcode/_alt/1,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
4 
elev_m,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
5 
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8 
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9 
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10 
lat_decimal,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
11 
long_decimal,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
12 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
13 
pol1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince
14 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
15 
major_geo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
16 
plot_methodology,/location/locationevent/*_id/method/name,
17 
project,/location/locationevent/*_id/project/projectname,
18 
holdridge_life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
19 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
20 
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
21 
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
22 
precip_mm,/location/locationevent/precipitation,
23 
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
24 
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value",
25 
soil_Ca,"/location/locationevent/soilobs/calcium/_units:[default=""%"",to=]/value",
26 
soil_C,"/location/locationevent/soilobs/carbon/_units:[default=""%"",to=]/value",
27 
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity,
28 
clay_percent,"/location/locationevent/soilobs/clay/_units:[default=""%"",to=]/value",
29 
soil_conductivity,/location/locationevent/soilobs/conductivity,
30 
soil_Mg,"/location/locationevent/soilobs/magnesium/_units:[default=""%"",to=]/value",
31 
soil_N,"/location/locationevent/soilobs/nitrogen/_units:[default=""%"",to=]/value",
32 
organic_percent,"/location/locationevent/soilobs/organic/_units:[default=""%"",to=]/value",
33 
pH,/location/locationevent/soilobs/ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
34 
soil_P,"/location/locationevent/soilobs/phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
35 
soil_K,"/location/locationevent/soilobs/potassium/_units:[default=""%"",to=]/value",
36 
sand_percent,"/location/locationevent/soilobs/sand/_units:[default=""%"",to=]/value",
37 
silt_percent,"/location/locationevent/soilobs/silt/_units:[default=""%"",to=]/value",
38 
soil_Na,"/location/locationevent/soilobs/sodium/_units:[default=""%"",to=]/value",
39 
soil_texture,/location/locationevent/soilobs/texture,
40 
temp_c,/location/locationevent/temperature,
41 
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 
slope_aspect,/location/slopeaspect/_compass/value,
43 
slope_gradient,/location/slopegradient,
44 
PLOT_ID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
46 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/maps/Veg+.plots.full.csv
1 
SALVIAS-CSV,Veg+,Comments
2 
soil_acidity,"acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
3 
soil_base,"baseSaturation/_units:[default=""%"",to=]/value",
4 
soil_Ca,"calcium/_units:[default=""%"",to=]/value",
5 
soil_C,"carbon/_units:[default=""%"",to=]/value",
6 
soil_cation_cap,cationExchangeCapacity,
7 
clay_percent,"clay/_units:[default=""%"",to=]/value",
8 
holdridge_life_zone,communityID,
9 
life_zone_code,communityName,
10 
soil_conductivity,conductivity,
11 
major_geo,continent,
12 
country,country,
13 
pol2,county,Brad: No pol2=countyParish
14 
lat_decimal,decimalLatitude,
15 
long_decimal,decimalLongitude,
16 
locality_description,locality,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
17 
PLOT_ID,locationID,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
18 
soil_Mg,"magnesium/_units:[default=""%"",to=]/value",
19 
elev_max_m,maximumElevationInMeters,
20 
elev_min_m,minimumElevationInMeters,
21 
soil_N,"nitrogen/_units:[default=""%"",to=]/value",
22 
organic_percent,"organic/_units:[default=""%"",to=]/value",
23 
pH,ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
24 
soil_P,"phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
25 
plot_area_ha,plotArea,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
26 
date_finish,plotEventEndDate,
27 
date_start,plotEventStartDate,
28 
plot_code,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
29 
soil_K,"potassium/_units:[default=""%"",to=]/value",
30 
precip_mm,precipitation,
31 
project,projectName,
32 
plot_methodology,samplingProtocol,
33 
sand_percent,"sand/_units:[default=""%"",to=]/value",
34 
silt_percent,"silt/_units:[default=""%"",to=]/value",
35 
slope_aspect,slopeAspect,
36 
slope_gradient,slopeGradient,
37 
soil_Na,"sodium/_units:[default=""%"",to=]/value",
38 
pol1,stateProvince,Brad: No; pol1=stateProvince
39 
temp_c,temperature,
40 
soil_texture,texture,
41 
elev_m,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
42 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
43 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS/test/import.plots.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <area>$plot_area_ha</area>
5 
        <authorlocationcode>$SiteCode</authorlocationcode>
6 
        <elevation>
7 
            <_alt>
8 
                <1>
9 
                    <_replace>
10 
                        <\bca\.?></\bca\.?>
11 
                        <value>$Elev</value>
12 
                    </_replace>
13 
                </1>
14 
                <2>
15 
                    <_avg>
16 
                        <max>
17 
                            <_units>
18 
                                <default>m</default>
19 
                                <to>m</to>
20 
                                <to></to>
21 
                                <value>
22 
                                    <_replace>
23 
                                        <\bca\.?></\bca\.?>
24 
                                        <value>$elev_max_m</value>
25 
                                    </_replace>
26 
                                </value>
27 
                            </_units>
28 
                        </max>
29 
                        <min>
30 
                            <_units>
31 
                                <default>m</default>
32 
                                <to>m</to>
33 
                                <to></to>
34 
                                <value>
35 
                                    <_rangeStart>
36 
                                        <value>
37 
                                            <_replace>
38 
                                                <\bca\.?></\bca\.?>
39 
                                                <value>$elev_min_m</value>
40 
                                            </_replace>
41 
                                        </value>
42 
                                    </_rangeStart>
43 
                                </value>
44 
                            </_units>
45 
                        </min>
46 
                    </_avg>
47 
                </2>
48 
            </_alt>
49 
        </elevation>
50 
        <elevationrange>
51 
            <_range>
52 
                <from>
53 
                    <_units>
54 
                        <default>m</default>
55 
                        <to>m</to>
56 
                        <to></to>
57 
                        <value>
58 
                            <_rangeStart>
59 
                                <value>
60 
                                    <_replace>
61 
                                        <\bca\.?></\bca\.?>
62 
                                        <value>$elev_min_m</value>
63 
                                    </_replace>
64 
                                </value>
65 
                            </_rangeStart>
66 
                        </value>
67 
                    </_units>
68 
                </from>
69 
                <to>
70 
                    <_units>
71 
                        <default>m</default>
72 
                        <to>m</to>
73 
                        <to></to>
74 
                        <value>
75 
                            <_alt>
76 
                                <1>
77 
                                    <_replace>
78 
                                        <\bca\.?></\bca\.?>
79 
                                        <value>$elev_max_m</value>
80 
                                    </_replace>
81 
                                </1>
82 
                                <2>
83 
                                    <_rangeEnd>
84 
                                        <value>
85 
                                            <_replace>
86 
                                                <\bca\.?></\bca\.?>
87 
                                                <value>$elev_min_m</value>
88 
                                            </_replace>
89 
                                        </value>
90 
                                    </_rangeEnd>
91 
                                </2>
92 
                            </_alt>
93 
                        </value>
94 
                    </_units>
95 
                </to>
96 
            </_range>
97 
        </elevationrange>
98 
        <locationdetermination>
99 
            <latitude>
100 
                <_nullIf>
101 
                    <null>0</null>
102 
                    <type>float</type>
103 
                    <value>$LatDec</value>
104 
                </_nullIf>
105 
            </latitude>
106 
            <longitude>
107 
                <_nullIf>
108 
                    <null>0</null>
109 
                    <type>float</type>
110 
                    <value>$LongDec</value>
111 
                </_nullIf>
112 
            </longitude>
113 
            <namedplace_id>
114 
                <_simplifyPath>
115 
                    <next>parent_id/namedplace</next>
116 
                    <require>placename</require>
117 
                    <path>
118 
                        <namedplace>
119 
                            <rank>county</rank>
120 
                            <placename>$pol2</placename>
121 
                            <parent_id>
122 
                                <namedplace>
123 
                                    <rank>stateProvince</rank>
124 
                                    <placename>$PolDiv1</placename>
125 
                                    <parent_id>
126 
                                        <namedplace>
127 
                                            <rank>country</rank>
128 
                                            <placename>$Country</placename>
129 
                                            <parent_id>
130 
                                                <namedplace>
131 
                                                    <rank>continent</rank>
132 
                                                    <placename>$MajorGeo</placename>
133 
                                                </namedplace>
134 
                                            </parent_id>
135 
                                        </namedplace>
136 
                                    </parent_id>
137 
                                </namedplace>
138 
                            </parent_id>
139 
                        </namedplace>
140 
                    </path>
141 
                </_simplifyPath>
142 
            </namedplace_id>
143 
        </locationdetermination>
144 
        <locationevent>
145 
            <method_id><method><name>$PlotMethod</name></method></method_id>
146 
            <project_id><project><projectname>$project_id</projectname></project></project_id>
147 
            <commclass>
148 
                <commdetermination>
149 
                    <commconcept_id>
150 
                        <commconcept>
151 
                            <commname_id><commname><commname>$life_zone_code</commname></commname></commname_id>
152 
                            <commdescription>$life_zone</commdescription>
153 
                        </commconcept>
154 
                    </commconcept_id>
155 
                </commdetermination>
156 
            </commclass>
157 
            <obsenddate><_date><date><_dateRangeEnd><value>$date_finish</value></_dateRangeEnd></date></_date></obsenddate>
158 
            <obsstartdate><_date><date><_dateRangeStart><value>$date_start</value></_dateRangeStart></date></_date></obsstartdate>
159 
            <precipitation>$Precip</precipitation>
160 
            <soilobs>
161 
                <acidity>
162 
                    <_units>
163 
                        <default>%</default>
164 
                        <to></to>
165 
                        <value>
166 
                            <_map>
167 
                                <<0.05>0</<0.05>
168 
                                <*>*</*>
169 
                                <value>$soil_acidity</value>
170 
                            </_map>
171 
                        </value>
172 
                    </_units>
173 
                </acidity>
174 
                <basesaturation>
175 
                    <_units>
176 
                        <default>%</default>
177 
                        <to></to>
178 
                        <value>$soil_base</value>
179 
                    </_units>
180 
                </basesaturation>
181 
                <calcium>
182 
                    <_units>
183 
                        <default>%</default>
184 
                        <to></to>
185 
                        <value>$soil_Ca</value>
186 
                    </_units>
187 
                </calcium>
188 
                <carbon>
189 
                    <_units>
190 
                        <default>%</default>
191 
                        <to></to>
192 
                        <value>$soil_C</value>
193 
                    </_units>
194 
                </carbon>
195 
                <cationexchangecapacity>$soil_cation_cap</cationexchangecapacity>
196 
                <clay>
197 
                    <_units>
198 
                        <default>%</default>
199 
                        <to></to>
200 
                        <value>$clay_percent</value>
201 
                    </_units>
202 
                </clay>
203 
                <conductivity>$soil_conductivity</conductivity>
204 
                <magnesium>
205 
                    <_units>
206 
                        <default>%</default>
207 
                        <to></to>
208 
                        <value>$soil_Mg</value>
209 
                    </_units>
210 
                </magnesium>
211 
                <nitrogen>
212 
                    <_units>
213 
                        <default>%</default>
214 
                        <to></to>
215 
                        <value>$soil_N</value>
216 
                    </_units>
217 
                </nitrogen>
218 
                <organic>
219 
                    <_units>
220 
                        <default>%</default>
221 
                        <to></to>
222 
                        <value>$organic_percent</value>
223 
                    </_units>
224 
                </organic>
225 
                <ph>$pH</ph>
226 
                <phosphorus>
227 
                    <_units>
228 
                        <default>%</default>
229 
                        <to></to>
230 
                        <value>
231 
                            <_map>
232 
                                <<1,5>0</<1,5>
233 
                                <*>*</*>
234 
                                <value>$soil_P</value>
235 
                            </_map>
236 
                        </value>
237 
                    </_units>
238 
                </phosphorus>
239 
                <potassium>
240 
                    <_units>
241 
                        <default>%</default>
242 
                        <to></to>
243 
                        <value>$soil_K</value>
244 
                    </_units>
245 
                </potassium>
246 
                <sand>
247 
                    <_units>
248 
                        <default>%</default>
249 
                        <to></to>
250 
                        <value>$sand_percent</value>
251 
                    </_units>
252 
                </sand>
253 
                <silt>
254 
                    <_units>
255 
                        <default>%</default>
256 
                        <to></to>
257 
                        <value>$silt_percent</value>
258 
                    </_units>
259 
                </silt>
260 
                <sodium>
261 
                    <_units>
262 
                        <default>%</default>
263 
                        <to></to>
264 
                        <value>$soil_Na</value>
265 
                    </_units>
266 
                </sodium>
267 
                <texture>
268 
                    <_units>
269 
                        <default>%</default>
270 
                        <to></to>
271 
                        <value>$soil_texture</value>
272 
                    </_units>
273 
                </texture>
274 
            </soilobs>
275 
            <temperature>$Temp</temperature>
276 
        </locationevent>
277 
        <locationnarrative>$Locality_Description</locationnarrative>
278 
        <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
279 
        <slopegradient>$slope_gradient</slopegradient>
280 
        <sourceaccessioncode>$PlotID</sourceaccessioncode>
281 
    </location>
282 
</VegBIEN>
283 
Inserted 23 new rows into database
inputs/SALVIAS/maps/Veg+.plots.csv
1 
SALVIAS,Veg+,Comments
2 
PlotID,locationID,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
3 
orig_filename,,
4 
AccessCode,,
5 
project_id,projectName,
6 
PrimOwnerID,,
7 
SiteCode,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
8 
SiteName,,
9 
new_world,,
10 
MajorGeo,continent,
11 
Country,country,
12 
PolDiv1,stateProvince,Brad: No; pol1=stateProvince
13 
pol1_type,,
14 
pol2,county,Brad: No pol2=countyParish
15 
pol2_type,,
16 
lat_string,,
17 
long_string,,
18 
LatDec,decimalLatitude,
19 
LongDec,decimalLongitude,
20 
lat_long_accuracy,,
21 
Elev,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
22 
elev_max_m,maximumElevationInMeters,
23 
elev_min_m,minimumElevationInMeters,
24 
Precip,precipitation,
25 
ElevSource,,
26 
Temp,temperature,
27 
PrecipSource,,
28 
TempSource,,
29 
bearing,,
30 
slope_aspect,slopeAspect,
31 
slope_gradient,slopeGradient,
32 
clay_percent,"clay/_units:[default=""%"",to=]/value",
33 
silt_percent,"silt/_units:[default=""%"",to=]/value",
34 
sand_percent,"sand/_units:[default=""%"",to=]/value",
35 
pH,ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
36 
soil_N,"nitrogen/_units:[default=""%"",to=]/value",
37 
soil_P,"phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
38 
soil_C,"carbon/_units:[default=""%"",to=]/value",
39 
soil_K,"potassium/_units:[default=""%"",to=]/value",
40 
soil_Mg,"magnesium/_units:[default=""%"",to=]/value",
41 
soil_Ca,"calcium/_units:[default=""%"",to=]/value",
42 
soil_Na,"sodium/_units:[default=""%"",to=]/value",
43 
soil_acidity,"acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
44 
soil_base,"baseSaturation/_units:[default=""%"",to=]/value",
45 
soil_cation_cap,cationExchangeCapacity,
46 
soil_conductivity,conductivity,
47 
organic_percent,"organic/_units:[default=""%"",to=]/value",
48 
soil_texture,"texture/_units:[default=""%"",to=]/value",
49 
RevisionComments,,
50 
Locality_Description,locality,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
51 
topography_desc,,
52 
vegetation_1,,
53 
vegetation_2,,
54 
Habitat,,
55 
life_zone_code,communityID,
56 
life_zone,communityName,
57 
PlotMethod,samplingProtocol,
58 
MethodCode,,
59 
plot_area_ha,plotArea,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
60 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
61 
date_start,plotEventStartDate,
62 
date_finish,plotEventEndDate,
63 
plot_administrator,,
64 
plot_notes,,
65 
tmp_del,,
inputs/SALVIAS/maps/src.plots.csv
1 
SALVIAS,Veg+,Comments
2 
PlotID,,
3 
orig_filename,,
4 
AccessCode,,
5 
project_id,,
6 
PrimOwnerID,,
7 
SiteCode,,
8 
SiteName,,
9 
new_world,,
10 
MajorGeo,,
11 
Country,,
12 
PolDiv1,,
13 
pol1_type,,
14 
pol2,,
15 
pol2_type,,
16 
lat_string,,
17 
long_string,,
18 
LatDec,,
19 
LongDec,,
20 
lat_long_accuracy,,
21 
Elev,,
22 
elev_max_m,,
23 
elev_min_m,,
24 
Precip,,
25 
ElevSource,,
26 
Temp,,
27 
PrecipSource,,
28 
TempSource,,
29 
bearing,,
30 
slope_aspect,,
31 
slope_gradient,,
32 
clay_percent,,
33 
silt_percent,,
34 
sand_percent,,
35 
pH,,
36 
soil_N,,
37 
soil_P,,
38 
soil_C,,
39 
soil_K,,
40 
soil_Mg,,
41 
soil_Ca,,
42 
soil_Na,,
43 
soil_acidity,,
44 
soil_base,,
45 
soil_cation_cap,,
46 
soil_conductivity,,
47 
organic_percent,,
48 
soil_texture,,
49 
RevisionComments,,
50 
Locality_Description,,
51 
topography_desc,,
52 
vegetation_1,,
53 
vegetation_2,,
54 
Habitat,,
55 
life_zone_code,,
56 
life_zone,,
57 
PlotMethod,,
58 
MethodCode,,
59 
plot_area_ha,,
60 
recensused,,
61 
date_start,,
62 
date_finish,,
63 
plot_administrator,,
64 
plot_notes,,
65 
tmp_del,,
inputs/SALVIAS/maps/Veg+.plots.full.csv
1 
SALVIAS,Veg+,Comments
2 
soil_acidity,"acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
3 
soil_base,"baseSaturation/_units:[default=""%"",to=]/value",
4 
soil_Ca,"calcium/_units:[default=""%"",to=]/value",
5 
soil_C,"carbon/_units:[default=""%"",to=]/value",
6 
soil_cation_cap,cationExchangeCapacity,
7 
clay_percent,"clay/_units:[default=""%"",to=]/value",
8 
life_zone_code,communityID,
9 
life_zone,communityName,
10 
soil_conductivity,conductivity,
11 
MajorGeo,continent,
12 
Country,country,
13 
pol2,county,Brad: No pol2=countyParish
14 
LatDec,decimalLatitude,
15 
LongDec,decimalLongitude,
16 
Locality_Description,locality,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
17 
PlotID,locationID,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
18 
soil_Mg,"magnesium/_units:[default=""%"",to=]/value",
19 
elev_max_m,maximumElevationInMeters,
20 
elev_min_m,minimumElevationInMeters,
21 
soil_N,"nitrogen/_units:[default=""%"",to=]/value",
22 
organic_percent,"organic/_units:[default=""%"",to=]/value",
23 
pH,ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
24 
soil_P,"phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
25 
plot_area_ha,plotArea,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
26 
date_finish,plotEventEndDate,
27 
date_start,plotEventStartDate,
28 
SiteCode,plotName,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
29 
soil_K,"potassium/_units:[default=""%"",to=]/value",
30 
Precip,precipitation,
31 
project_id,projectName,
32 
PlotMethod,samplingProtocol,
33 
sand_percent,"sand/_units:[default=""%"",to=]/value",
34 
silt_percent,"silt/_units:[default=""%"",to=]/value",
35 
slope_aspect,slopeAspect,
36 
slope_gradient,slopeGradient,
37 
soil_Na,"sodium/_units:[default=""%"",to=]/value",
38 
PolDiv1,stateProvince,Brad: No; pol1=stateProvince
39 
Temp,temperature,
40 
soil_texture,"texture/_units:[default=""%"",to=]/value",
41 
Elev,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
42 
AccessCode,,
43 
ElevSource,,
44 
Habitat,,
45 
MethodCode,,
46 
PrecipSource,,
47 
PrimOwnerID,,
48 
RevisionComments,,
49 
SiteName,,
50 
TempSource,,
51 
bearing,,
52 
lat_long_accuracy,,
53 
lat_string,,
54 
long_string,,
55 
new_world,,
56 
orig_filename,,
57 
plot_administrator,,
58 
plot_notes,,
59 
pol1_type,,
60 
pol2_type,,
61 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
62 
tmp_del,,
63 
topography_desc,,
64 
vegetation_1,,
65 
vegetation_2,,
inputs/SALVIAS/maps/VegBIEN.plots.csv
1 
SALVIAS,VegBIEN:,Comments
2 
plot_area_ha,/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
3 
SiteCode,/location/authorlocationcode/_alt/1,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
4 
Elev,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
5 
elev_max_m,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 
elev_min_m,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 
elev_min_m,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
8 
elev_max_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
9 
elev_min_m,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
10 
LatDec,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
11 
LongDec,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
12 
pol2,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",Brad: No pol2=countyParish
13 
PolDiv1,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",Brad: No; pol1=stateProvince
14 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
15 
MajorGeo,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
16 
PlotMethod,/location/locationevent/*_id/method/name,
17 
project_id,/location/locationevent/*_id/project/projectname,
18 
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
19 
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
20 
date_finish,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,
21 
date_start,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,
22 
Precip,/location/locationevent/precipitation,
23 
soil_acidity,"/location/locationevent/soilobs/acidity/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
24 
soil_base,"/location/locationevent/soilobs/basesaturation/_units:[default=""%"",to=]/value",
25 
soil_Ca,"/location/locationevent/soilobs/calcium/_units:[default=""%"",to=]/value",
26 
soil_C,"/location/locationevent/soilobs/carbon/_units:[default=""%"",to=]/value",
27 
soil_cation_cap,/location/locationevent/soilobs/cationexchangecapacity,
28 
clay_percent,"/location/locationevent/soilobs/clay/_units:[default=""%"",to=]/value",
29 
soil_conductivity,/location/locationevent/soilobs/conductivity,
30 
soil_Mg,"/location/locationevent/soilobs/magnesium/_units:[default=""%"",to=]/value",
31 
soil_N,"/location/locationevent/soilobs/nitrogen/_units:[default=""%"",to=]/value",
32 
organic_percent,"/location/locationevent/soilobs/organic/_units:[default=""%"",to=]/value",
33 
pH,/location/locationevent/soilobs/ph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss."
34 
soil_P,"/location/locationevent/soilobs/phosphorus/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
35 
soil_K,"/location/locationevent/soilobs/potassium/_units:[default=""%"",to=]/value",
36 
sand_percent,"/location/locationevent/soilobs/sand/_units:[default=""%"",to=]/value",
37 
silt_percent,"/location/locationevent/soilobs/silt/_units:[default=""%"",to=]/value",
38 
soil_Na,"/location/locationevent/soilobs/sodium/_units:[default=""%"",to=]/value",
39 
soil_texture,"/location/locationevent/soilobs/texture/_units:[default=""%"",to=]/value",
40 
Temp,/location/locationevent/temperature,
41 
Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 
slope_aspect,/location/slopeaspect/_compass/value,
43 
slope_gradient,/location/slopegradient,
44 
PlotID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 
AccessCode,,** No input mapping for AccessCode **
46 
ElevSource,,** No input mapping for ElevSource **
47 
Habitat,,** No input mapping for Habitat **
48 
MethodCode,,** No input mapping for MethodCode **
49 
PrecipSource,,** No input mapping for PrecipSource **
50 
PrimOwnerID,,** No input mapping for PrimOwnerID **
51 
RevisionComments,,** No input mapping for RevisionComments **
52 
SiteName,,** No input mapping for SiteName **
53 
TempSource,,** No input mapping for TempSource **
54 
bearing,,** No input mapping for bearing **
55 
lat_long_accuracy,,** No input mapping for lat_long_accuracy **
56 
lat_string,,** No input mapping for lat_string **
57 
long_string,,** No input mapping for long_string **
58 
new_world,,** No input mapping for new_world **
59 
orig_filename,,** No input mapping for orig_filename **
60 
plot_administrator,,** No input mapping for plot_administrator **
61 
plot_notes,,** No input mapping for plot_notes **
62 
pol1_type,,** No input mapping for pol1_type **
63 
pol2_type,,** No input mapping for pol2_type **
64 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
65 
tmp_del,,** No input mapping for tmp_del **
66 
topography_desc,,** No input mapping for topography_desc **
67 
vegetation_1,,** No input mapping for vegetation_1 **
68 
vegetation_2,,** No input mapping for vegetation_2 **
inputs/Madidi/test/import.0.plots.xml.ref
1 
Put template:
2 
<VegBIEN>
3 
    <location id="-1">
4 
        <area>$Area</area>
5 
        <authorlocationcode>$Inventory name</authorlocationcode>
6 
        <elevation>
7 
            <_alt>
8 
                <1>
9 
                    <_replace>
10 
                        <\bca\.?></\bca\.?>
11 
                        <value>$Altitude</value>
12 
                    </_replace>
13 
                </1>
14 
                <2>
15 
                    <_avg>
16 
                        <min>
17 
                            <_units>
18 
                                <default>m</default>
19 
                                <to>m</to>
20 
                                <to></to>
21 
                                <value>
22 
                                    <_rangeStart>
23 
                                        <value>
24 
                                            <_replace>
25 
                                                <\bca\.?></\bca\.?>
26 
                                                <value>$Minimum altitude</value>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff