<VegBIEN>

    <_ignore><inLabel>Madidi</inLabel></_ignore>

    <locationevent id="-1">

        <location_id>

            <location>

                <area>$Area</area>

                <elevation>

                    <_alt>

                        <1>$Altitude</1>

                        <2>

                            <_avg>

                                <min>

                                    <_units>

                                        <default>m</default>

                                        <to>m</to>

                                        <to></to>

                                        <value><_rangeStart><value>$Minimum altitude</value></_rangeStart></value>

                                    </_units>

                                </min>

                            </_avg>

                        </2>

                    </_alt>

                </elevation>

                <landform>$Topographical situation</landform>

                <locationnarrative>$Locality</locationnarrative>

                <notespublic>$Observaciones</notespublic>

                <slopeaspect>

                    <_compass>

                        <value>

                            <_alt>

                                <1>$Direction</1>

                                <2>$Orientaci&#243;n/exposicion</2>

                            </_alt>

                        </value>

                    </_compass>

                </slopeaspect>

                <slopegradient>$Slope</slopegradient>

                <elevationrange>

                    <_range>

                        <from>

                            <_units>

                                <default>m</default>

                                <to>m</to>

                                <to></to>

                                <value><_rangeStart><value>$Minimum altitude</value></_rangeStart></value>

                            </_units>

                        </from>

                    </_range>

                </elevationrange>

                <locationdetermination>

                    <latitude>

                        <_alt>

                            <1>$Latitude</1>

                            <2>$Latitude (DMS)</2>

                        </_alt>

                    </latitude>

                    <longitude>

                        <_alt>

                            <1>$Longitude</1>

                            <2>$Longitude (DMS)</2>

                        </_alt>

                    </longitude>

                </locationdetermination>

                <centerlatitude>

                    <_alt>

                        <1>$Latitude</1>

                        <2>$Latitude (DMS)</2>

                    </_alt>

                </centerlatitude>

                <centerlongitude>

                    <_alt>

                        <1>$Longitude</1>

                        <2>$Longitude (DMS)</2>

                    </_alt>

                </centerlongitude>

                <sourceaccessioncode>

                    <_merge>

                        <2>

                            <_alt>

                                <2>$Inventory name</2>

                                <1>$Inventory code</1>

                            </_alt>

                        </2>

                    </_merge>

                </sourceaccessioncode>

            </location>

        </location_id>

        <project_id>

            <project>

                <projectname>$Expedition name</projectname>

                <sourceaccessioncode>$Expedition number</sourceaccessioncode>

            </project>

        </project_id>

        <commclass>

            <commdetermination>

                <commconcept_id>

                    <commconcept>

                        <commname_id><commname><commname>$Vegetation type</commname></commname></commname_id>

                        <commdescription>$Locality description</commdescription>

                    </commconcept>

                </commconcept_id>

            </commdetermination>

        </commclass>

        <obsstartdate>$First evaluation</obsstartdate>

        <soilobs>

            <acidity>$Acidez intercambiable (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</acidity>

            <calcium>$Calcio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.016)</calcium>

            <carbon>$Carb&#243;n Org&#225;nico (WSP S-9,10&#8211;%&#8211;0.06)</carbon>

            <cationexchangecapacity>$CIC (ISRIC 11&#8211;cmolc/Kg&#8211;0.05)</cationexchangecapacity>

            <clay>$Arcilla (DIN 18 123&#8211;%&#8211;1)</clay>

            <conductivity>$Conductividad electrica (ASPT 6&#8211;&#181;S/cm&#8211; 1 - 10000)</conductivity>

            <magnesium>$Magnesio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</magnesium>

            <nitrogen>$Nitr&#243;geno total (ISRIC 6&#8211;%&#8211;0.0014)</nitrogen>

            <organic>$Materia Org&#225;nica (WSP S-9,10&#8211;%&#8211;0.1)</organic>

            <ph>$pH acuoso (ISRIC 4&#8211;&#8211; 1 - 14)</ph>

            <phosphorus>$F&#243;sforo disponible (ISRIC 14-2&#8211;mg/Kg&#8211;1.5)</phosphorus>

            <potassium>$Potasio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.0053)</potassium>

            <sand>$Arena (DIN 18 123&#8211;%&#8211;2.5)</sand>

            <silt>$Limo (DIN 18 123&#8211;%&#8211;1)</silt>

            <sodium>$Sodio intercambiable (WSP S-5,10&#8211;cmolc/Kg&#8211;0.00083)</sodium>

            <texture>$Textural class</texture>

        </soilobs>

        <authorlocationcode>$Inventory name</authorlocationcode>

        <sourceaccessioncode>$Inventory code</sourceaccessioncode>

    </locationevent>

</VegBIEN>

Inserted 19 new rows into database

Inventory number,,Not globally unique

Expedition number,/*ID->/*s/project/title[@id=sourceAccessionCode],Consistent (globally unique) between PPM and PT data

Expedition name,/*ID->/*s/project/title[@id=name],Consistent (globally unique) between PPM and PT data

Number of inventory (expedition),,The number of the event within the project

Inventory name,/*UniqueIdentifierID->/*s/plot/plotName,

Inventory code,/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,

First evaluation,/obsStartDate,

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"

Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"

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."

Area,/*UniqueIdentifierID->/*s/plot/area,

Number of stems,,Do we want to store this data?

Number of trees,,Do we want to store this data?

Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)

Latitude,/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude/_alt/1,

Longitude,/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude/_alt/1,

Latitude (DMS),/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude/_alt/2,

Longitude (DMS),/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude/_alt/2,

Altitude,/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,

Minimum altitude,/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,

Locality,/*UniqueIdentifierID->/*s/plot/locationNarrative,

Locality description,->/*s/communityDetermination[*ID]/*s/communityConcept/name,Often begins with the text in Vegetation type

Direction,/*UniqueIdentifierID->/*s/plot/slopeAspect/_alt/1,Part files provide either this field or Direction

Vegetation type,->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,

Topographical situation,/*UniqueIdentifierID->/*s/plot/landform,

Slope,/*UniqueIdentifierID->/*s/plot/slopeGradient,

Soil sample,,Always empty

pH acuoso (ISRIC 4–– 1 - 14),->/*s/abioticObservation[*ID]/ph,

Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,

Nitrógeno total (ISRIC 6–%–0.0014),->/*s/abioticObservation[*ID]/nitrogen,

"Carbón Orgánico (WSP S-9,10–%–0.06)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,

"Materia Orgánica (WSP S-9,10–%–0.1)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=organic]/value,

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),->/*s/abioticObservation[*ID]/phosphorus,

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",->/*s/abioticObservation[*ID]/potassium,

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",->/*s/abioticObservation[*ID]/magnesium,

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,

CIC (ISRIC 11–cmolc/Kg–0.05),->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationExchangeCapacity]/value,

Arena (DIN 18 123–%–2.5),->/*s/abioticObservation[*ID]/simpleUserdefined[name=sand]/value,

Limo (DIN 18 123–%–1),->/*s/abioticObservation[*ID]/simpleUserdefined[name=silt]/value,

Arcilla (DIN 18 123–%–1),->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,

Textural class,->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,

Observaciones,/*UniqueIdentifierID->/*s/plot/note,

Orientación/exposicion,/*UniqueIdentifierID->/*s/plot/slopeAspect/_alt/2,Part files provide either this field or Orientación

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",->/*s/abioticObservation[*ID]/magnesium,

Nitrógeno total (ISRIC 6–%–0.0014),->/*s/abioticObservation[*ID]/nitrogen,

pH acuoso (ISRIC 4–– 1 - 14),->/*s/abioticObservation[*ID]/ph,

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),->/*s/abioticObservation[*ID]/phosphorus,

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",->/*s/abioticObservation[*ID]/potassium,

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,

"Carbón Orgánico (WSP S-9,10–%–0.06)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=carbon]/value,

CIC (ISRIC 11–cmolc/Kg–0.05),->/*s/abioticObservation[*ID]/simpleUserdefined[name=cationExchangeCapacity]/value,

Arcilla (DIN 18 123–%–1),->/*s/abioticObservation[*ID]/simpleUserdefined[name=clay]/value,

Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),->/*s/abioticObservation[*ID]/simpleUserdefined[name=conductivity]/value,

"Materia Orgánica (WSP S-9,10–%–0.1)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=organic]/value,

Arena (DIN 18 123–%–2.5),->/*s/abioticObservation[*ID]/simpleUserdefined[name=sand]/value,

Limo (DIN 18 123–%–1),->/*s/abioticObservation[*ID]/simpleUserdefined[name=silt]/value,

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",->/*s/abioticObservation[*ID]/simpleUserdefined[name=sodium]/value,

Textural class,->/*s/abioticObservation[*ID]/simpleUserdefined[name=texture]/value,

Vegetation type,->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,

Locality description,->/*s/communityDetermination[*ID]/*s/communityConcept/name,Often begins with the text in Vegetation type

Expedition name,/*ID->/*s/project/title[@id=name],Consistent (globally unique) between PPM and PT data

Expedition number,/*ID->/*s/project/title[@id=sourceAccessionCode],Consistent (globally unique) between PPM and PT data

Area,/*UniqueIdentifierID->/*s/plot/area,

Latitude,/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude/_alt/1,

Latitude (DMS),/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude/_alt/2,

Longitude,/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude/_alt/1,

Longitude (DMS),/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude/_alt/2,

Minimum altitude,/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,

Altitude,/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,

Topographical situation,/*UniqueIdentifierID->/*s/plot/landform,

Locality,/*UniqueIdentifierID->/*s/plot/locationNarrative,

Observaciones,/*UniqueIdentifierID->/*s/plot/note,

Inventory name,/*UniqueIdentifierID->/*s/plot/plotName,

Inventory code,/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,

Direction,/*UniqueIdentifierID->/*s/plot/slopeAspect/_alt/1,Part files provide either this field or Direction

Orientación/exposicion,/*UniqueIdentifierID->/*s/plot/slopeAspect/_alt/2,Part files provide either this field or Orientación

Slope,/*UniqueIdentifierID->/*s/plot/slopeGradient,

First evaluation,/obsStartDate,

Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"

Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)

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"

Inventory number,,Not globally unique

Number of inventory (expedition),,The number of the event within the project

Number of stems,,Do we want to store this data?

Number of trees,,Do we want to store this data?

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."

Soil sample,,Always empty

Area,/*_id/location/area,

Altitude,/*_id/location/elevation/_alt/1,

Topographical situation,/*_id/location/landform,

Locality,/*_id/location/locationnarrative,

Observaciones,/*_id/location/notespublic,

Direction,/*_id/location/slopeaspect/_compass/value/_alt/1,Part files provide either this field or Direction

Orientación/exposicion,/*_id/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or Orientación

Slope,/*_id/location/slopegradient,

Minimum altitude,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_units:[default=m,to=m,to=]/value/_rangeStart/value",

Latitude,"/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1",

Latitude (DMS),"/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2",

Longitude,"/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1",

Longitude (DMS),"/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2",

Expedition name,/*_id/project/projectname,Consistent (globally unique) between PPM and PT data

Expedition number,/*_id/project/sourceaccessioncode,Consistent (globally unique) between PPM and PT data

Vegetation type,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,

Locality description,/commclass/commdetermination/*_id/commconcept/commdescription,Often begins with the text in Vegetation type

First evaluation,/obsstartdate,

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/soilobs/acidity,

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/soilobs/calcium,

"Carbón Orgánico (WSP S-9,10–%–0.06)",/soilobs/carbon,

CIC (ISRIC 11–cmolc/Kg–0.05),/soilobs/cationexchangecapacity,

Arcilla (DIN 18 123–%–1),/soilobs/clay,

Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),/soilobs/conductivity,

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/soilobs/magnesium,

Nitrógeno total (ISRIC 6–%–0.0014),/soilobs/nitrogen,

"Materia Orgánica (WSP S-9,10–%–0.1)",/soilobs/organic,

pH acuoso (ISRIC 4–– 1 - 14),/soilobs/ph,

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/soilobs/phosphorus,

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/soilobs/potassium,

Arena (DIN 18 123–%–2.5),/soilobs/sand,

Limo (DIN 18 123–%–1),/soilobs/silt,

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/soilobs/sodium,

Textural class,/soilobs/texture,

Inventory name,"/{authorlocationcode,*_id/location/sourceaccessioncode/_merge/2/_alt/2}",

Inventory code,"/{sourceaccessioncode,*_id/location/sourceaccessioncode/_merge/2/_alt/1}",

Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"

Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)

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"

Inventory number,,Not globally unique

Number of inventory (expedition),,The number of the event within the project

Number of stems,,Do we want to store this data?

Number of trees,,Do we want to store this data?

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."

Soil sample,,Always empty