Madidi,VegCore,Filter,Comments

Inventory number,*Inventory number,,Not globally unique

Expedition number,projectID,,Consistent (globally unique) between PPM and PT data

Expedition name,projectName,,Consistent (globally unique) between PPM and PT data

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

Inventory name,locationName,,

Inventory code,locationID,,

First evaluation,eventDate,,

Installed and evaluated by,*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,*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,*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,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"

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

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

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

Latitude,decimalLatitude,,

Longitude,decimalLongitude,,

Latitude (DMS),latitude_DMS,,

Longitude (DMS),longitude_DMS,,

Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Altitude""::real, ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'

GROUP BY ""Altitude""::real , ""Locality""

ORDER BY ""Altitude""::real DESC

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Locality,locality,,

Locality description,communityName,,Often begins with the text in Vegetation type

Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación

Vegetation type,communityID,,

Topographical situation,landform,,

Slope,slopeGradient,,

Soil sample,*Soil sample,,Always empty

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

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

Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values

"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values

"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values

CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,

Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values

Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values

Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values

Textural class,texture,,

Observaciones,plotNotes,,

Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>Madidi</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <authorlocationcode>$Inventory name</authorlocationcode>

                        <sourceaccessioncode>$Inventory code</sourceaccessioncode>

                        <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>

                        <elevation_m>

                            <_alt>

                                <1>$Altitude</1>

                                <2>

                                    <_avg>

                                        <max><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></max>

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

                                    </_avg>

                                </2>

                            </_alt>

                        </elevation_m>

                        <elevationrange_m>

                            <_range>

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

                                <to><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></to>

                            </_range>

                        </elevationrange_m>

                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$Locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>

                        <landform>$Topographical situation</landform>

                        <locationevent>

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

                            <obsenddate><_dateRangeEnd><value>$First evaluation</value></_dateRangeEnd></obsenddate>

                            <obsstartdate><_dateRangeStart><value>$First evaluation</value></_dateRangeStart></obsstartdate>

                            <soilsample>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                                <texture>$Textural class</texture>

                            </soilsample>

                        </locationevent>

                        <locationnarrative>$Locality</locationnarrative>

                        <locationplace>

                            <place_id>

                                <place>

                                    <coordinates_id>

                                        <coordinates>

                                            <latitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$Latitude</value>

                                                </_nullIf>

                                            </latitude_deg>

                                            <longitude_deg>

                                                <_nullIf>

                                                    <null>0</null>

                                                    <type>float</type>

                                                    <value>$Longitude</value>

                                                </_nullIf>

                                            </longitude_deg>

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

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

                                        </coordinates>

                                    </coordinates_id>

                                    <matched_place_id>

                                        <place>

                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                            <coordinates_id>

                                                <coordinates>

                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>

                                                    <latitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$Latitude</value>

                                                        </_nullIf>

                                                    </latitude_deg>

                                                    <longitude_deg>

                                                        <_nullIf>

                                                            <null>0</null>

                                                            <type>float</type>

                                                            <value>$Longitude</value>

                                                        </_nullIf>

                                                    </longitude_deg>

                                                </coordinates>

                                            </coordinates_id>

                                        </place>

                                    </matched_place_id>

                                </place>

                            </place_id>

                        </locationplace>

                        <notespublic>$Observaciones</notespublic>

                        <slopeaspect_deg>

                            <_compass>

                                <value>

                                    <_alt>

                                        <1>$Direction</1>

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

                                    </_alt>

                                </value>

                            </_compass>

                        </slopeaspect_deg>

                        <slopegradient_fraction>$Slope</slopegradient_fraction>

                        <verbatimelevation>$Minimum altitude</verbatimelevation>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 28 new rows into database

Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Inventory name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",

Inventory code,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",

Inventory code,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

Inventory name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",

Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",

Area,/location/area_m2/_ha_to_m2/value,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"

Altitude,/location/elevation_m/_alt/1,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Altitude""::real, ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'

GROUP BY ""Altitude""::real , ""Locality""

ORDER BY ""Altitude""::real DESC

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,/location/elevation_m/_alt/2/_avg/max/_rangeEnd/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,/location/elevation_m/_alt/2/_avg/min/_rangeStart/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,/location/elevationrange_m/_range/from/_rangeStart/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,/location/elevationrange_m/_range/to/_rangeEnd/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,

Topographical situation,/location/landform,

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

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

First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",

Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",

Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",

First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_alt/2/_dateRangeEnd/value",

First evaluation,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_alt/2/_dateRangeStart/value",

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

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

First evaluation,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,

First evaluation,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",/location/locationevent/soilsample/calcium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Carbón Orgánico (WSP S-9,10–%–0.06)",/location/locationevent/soilsample/carbon_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

CIC (ISRIC 11–cmolc/Kg–0.05),/location/locationevent/soilsample/cationexchangecapacity_cmol_kg,

Arcilla (DIN 18 123–%–1),/location/locationevent/soilsample/clay_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

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

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilsample/magnesium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

Nitrógeno total (ISRIC 6–%–0.0014),/location/locationevent/soilsample/nitrogen_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Materia Orgánica (WSP S-9,10–%–0.1)",/location/locationevent/soilsample/organic_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

pH acuoso (ISRIC 4–– 1 - 14),/location/locationevent/soilsample/ph,

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),/location/locationevent/soilsample/phosphorus_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",/location/locationevent/soilsample/potassium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

Arena (DIN 18 123–%–2.5),/location/locationevent/soilsample/sand_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

Limo (DIN 18 123–%–1),/location/locationevent/soilsample/silt_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",/location/locationevent/soilsample/sodium_fraction/_percent_to_fraction/value,Assuming units are % based on the range of values

Textural class,/location/locationevent/soilsample/texture,

Inventory code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

Inventory name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

Locality,/location/locationnarrative/_merge/1,

Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",

Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",

Latitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,

Longitude (DMS),/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,

Latitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"

Longitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"

Observaciones,/location/notespublic,

Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación

Orientación/exposicion,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/2,Part files provide either this field or Direction

Slope,/location/slopegradient_fraction/_alt/1,

Inventory code,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",

Inventory code,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",

Minimum altitude,/location/verbatimelevation,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

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

Coordinates,,** No join mapping for *Coordinates ** Concatenation of Latitude (DMS) and Longitude (DMS)

Installed and evaluated by,,"** No join mapping for *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,,** No join mapping for *Inventory number ** Not globally unique

Number of inventory (expedition),,** No join mapping for *Number of inventory (expedition) ** The number of the event within the project

Number of stems,,** No join mapping for *Number of stems ** Do we want to store this data?

Number of trees,,** No join mapping for *Number of trees ** Do we want to store this data?

Related Epilocs,,"** No join mapping for *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,,** No join mapping for *Soil sample ** Always empty

Expedition number,projectID,,Consistent (globally unique) between PPM and PT data

Expedition name,projectName,,Consistent (globally unique) between PPM and PT data

Inventory name,locationName,,

Inventory code,locationID,,

First evaluation,eventDate,,

Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"

Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Altitude""::real, ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'

GROUP BY ""Altitude""::real , ""Locality""

ORDER BY ""Altitude""::real DESC

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].

[1] Using the following query:

-----

SELECT ""Minimum altitude"", ""Locality""

FROM ""Madidi"".""Plot""

WHERE ""Minimum altitude"" IS NOT NULL

GROUP BY ""Minimum altitude"" , ""Locality""

-----

[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"

Locality description,communityName,,Often begins with the text in Vegetation type

Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación

Vegetation type,communityID,,

Topographical situation,landform,,

Slope,slopeGradient,,

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

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

Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values

"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values

"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values

Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values

"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values

"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values

"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values

"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values

Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values

CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,

Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values

Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values

Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values

Textural class,texture,,

Observaciones,plotNotes,,

Orientación/exposicion,slopeAspect,/_alt/2,Part files provide either this field or Direction

!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

*Inventory number

*Number of inventory (expedition)

*Installed and evaluated by

*Collaborators

*Related Epilocs

*Number of stems

*Number of trees

*Coordinates

*Soil sample

Expedition,projectName,,

Inventory name,locationName,,

Inventory code,locationID,,

Tag number,tag,,

Tree number,individualCode,,

Number of subplot,subplot,,

Index collector,recordedBy,,

Specimen,catalogNumber,,

Field family,originalFamily,,

Field name,originalGenus,,Often = Genera

Family (revised),family,,

Specie+autor,scientificName,,

Genera,genus,,

Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""

Autor (revised),scientificNameAuthorship,,

Determined by,identifiedBy,,

Qualifier,identificationQualifier,,

Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values

Trunk,authorStemCode,,

Total height,height_m,,Assuming units based on the range and precision of values

Liana presence,lianaInfestation,,

Observations,fieldNotes,,

*Number of inventory (general)

*Number of inventory (expedition)

"*Type Inventory (C, PP, TP)"

*Similar specimen

*Plot specimen

*Expedition specimen

*Project specimen

*Common name

*Circumference

*Bole height

*Phenology

*Crown position

*Crown shape

*Basal area

*Plot X

*Plot Y

Madidi,VegCore,Filter,Comments

Expedition,projectName,,

Inventory name,locationName,,

Number of inventory (general),*Number of inventory (general),,

Number of inventory (expedition),*Number of inventory (expedition),,

"Type Inventory (C, PP, TP)","*Type Inventory (C, PP, TP)",,

Inventory code,locationID,,

Tag number,tag,,

Tree number,individualCode,,

Number of subplot,subplot,,

Index collector,recordedBy,,

Specimen,catalogNumber,,

Similar specimen,*Similar specimen,,

Plot specimen,*Plot specimen,,

Expedition specimen,*Expedition specimen,,

Project specimen,*Project specimen,,

Field family,originalFamily,,

Field name,originalGenus,,Often = Genera

Family (revised),family,,

Specie+autor,scientificName,,

Genera,genus,,

Specific epithet,specificEpithet,,

Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""

Autor (revised),scientificNameAuthorship,,

Determined by,identifiedBy,,

Qualifier,identificationQualifier,,

Common name,*Common name,,

Circumference,*Circumference,,

Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values

Trunk,authorStemCode,,

Total height,height_m,,Assuming units based on the range and precision of values

Bole height,*Bole height,,trunk height

Habit,growthForm,"/_map:[./{""Árbol"",Arbol,""Árbolito"",Arbolito,Palmera}=tree,Hemiepifito=hemiepiphyte,Liana=liana,Arbusto=shrub,./{""Helecho arbóreo"",""Helecho arboreo""}=forb]/value",

Phenology,*Phenology,,

Crown position,*Crown position,,

Crown shape,*Crown shape,,

Liana presence,lianaInfestation,,

Basal area,*Basal area,,"Would be basalDiameter, but need formula to translate"

Subplot X,organismX_m,,"Assuming units based on the size of values relative to the plot area, which has units of ha"

Subplot Y,organismY_m,,"Assuming units based on the size of values relative to the plot area, which has units of ha"

Plot X,*Plot X,,

Plot Y,*Plot Y,,

Observations,fieldNotes,,

Put template:

<VegBIEN>

    <_setDefault id="-1">

        <source_id><source><shortname>Madidi</shortname></source></source_id>

        <path>

            <_simplifyPath>

                <next>parent_id</next>

                <path>

                    <location>

                        <parent_id>

                            <location>

                                <authorlocationcode>$Inventory name</authorlocationcode>

                                <sourceaccessioncode>$Inventory code</sourceaccessioncode>

                            </location>

                        </parent_id>

                        <authorlocationcode>$Number of subplot</authorlocationcode>

                        <locationevent>

                            <project_id><project><projectname>$Expedition</projectname></project></project_id>

                            <taxonoccurrence>

                                <aggregateoccurrence>

                                    <notes>$Observations</notes>

                                    <plantobservation>

                                        <authorplantcode>$Tree number</authorplantcode>

                                        <specimenreplicate><catalognumber_dwc>$Specimen</catalognumber_dwc></specimenreplicate>

                                        <stemobservation>

                                            <authorstemcode>$Trunk</authorstemcode>

                                            <definedvalue fkey="tablerecord_id">

                                                <userdefined_id>

                                                    <userdefined>

                                                        <tablename>stemobservation</tablename>

                                                        <userdefinedname>lianaInfestation</userdefinedname>

                                                    </userdefined>

                                                </userdefined_id>

                                                <definedvalue>$Liana presence</definedvalue>

                                            </definedvalue>

                                            <diameterbreastheight_m><_cm_to_m><value>$Diameter</value></_cm_to_m></diameterbreastheight_m>

                                            <height_m>$Total height</height_m>

                                            <tag>$Tag number</tag>

                                            <xposition_m>$Subplot X</xposition_m>

                                            <yposition_m>$Subplot Y</yposition_m>

                                        </stemobservation>

                                    </plantobservation>

                                </aggregateoccurrence>

                                <authortaxoncode>$Tree number</authortaxoncode>

                                <collector_id><party><fullname>$Index collector</fullname></party></collector_id>

                                <growthform>

                                    <_map>

                                        <Árbol>tree</Árbol>

                                        <Arbol>tree</Arbol>

                                        <Árbolito>tree</Árbolito>

                                        <Arbolito>tree</Arbolito>

                                        <Palmera>tree</Palmera>

                                        <Hemiepifito>hemiepiphyte</Hemiepifito>

                                        <Liana>liana</Liana>

                                        <Arbusto>shrub</Arbusto>

                                        <Helecho arbóreo>forb</Helecho arbóreo>

                                        <Helecho arboreo>forb</Helecho arboreo>

                                        <value>$Habit</value>

                                    </_map>

                                </growthform>

                                <taxondetermination>

                                    <party_id><party><fullname>$Determined by</fullname></party></party_id>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <taxonlabel_id>

                                                <taxonlabel>

                                                    <parent_id>

                                                        <taxonlabel>

                                                            <parent_id>

                                                                <taxonlabel>

                                                                    <rank>cultivar</rank>

                                                                    <parent_id>

                                                                        <taxonlabel>

                                                                            <rank>forma</rank>

                                                                            <parent_id>

                                                                                <taxonlabel>

                                                                                    <rank>variety</rank>

                                                                                    <parent_id>

                                                                                        <taxonlabel>

                                                                                            <rank>subspecies</rank>

                                                                                            <parent_id>

                                                                                                <taxonlabel>

                                                                                                    <rank>species</rank>

                                                                                                    <taxonepithet>$Specific epithet</taxonepithet>

                                                                                                    <parent_id>

                                                                                                        <taxonlabel>

                                                                                                            <rank>genus</rank>

                                                                                                            <taxonepithet>$Genera</taxonepithet>

                                                                                                            <parent_id>

                                                                                                                <taxonlabel>

                                                                                                                    <rank>family</rank>

                                                                                                                    <taxonepithet>$Family (revised)</taxonepithet>

                                                                                                                </taxonlabel>

                                                                                                            </parent_id>

                                                                                                        </taxonlabel>

                                                                                                    </parent_id>

                                                                                                </taxonlabel>

                                                                                            </parent_id>

                                                                                        </taxonlabel>

                                                                                    </parent_id>

                                                                                </taxonlabel>

                                                                            </parent_id>

                                                                        </taxonlabel>

                                                                    </parent_id>

                                                                </taxonlabel>

                                                            </parent_id>

                                                        </taxonlabel>

                                                    </parent_id>

                                                    <taxonomicname>

                                                        <_merge_prefix>

                                                            <prefix><_taxon_family_require_std><family>$Family (revised)</family></_taxon_family_require_std></prefix>

                                                            <value>

                                                                <_alt>

                                                                    <1>$Specie+autor</1>

                                                                    <2>

                                                                        <_join_words>

                                                                            <1>

                                                                                <_alt>

                                                                                    <1>$Species and morphotypes</1>

                                                                                    <2>

                                                                                        <_join_words>

                                                                                            <2>$Genera</2>

                                                                                            <3>$Specific epithet</3>

                                                                                        </_join_words>

                                                                                    </2>

                                                                                </_alt>

                                                                            </1>

                                                                            <2>$Autor (revised)</2>

                                                                        </_join_words>

                                                                    </2>

                                                                </_alt>

                                                            </value>

                                                        </_merge_prefix>

                                                    </taxonomicname>

                                                </taxonlabel>

                                            </taxonlabel_id>

                                            <author>$Autor (revised)</author>

                                            <family>$Family (revised)</family>

                                            <genus>$Genera</genus>

                                            <specific_epithet>$Specific epithet</specific_epithet>

                                            <taxonname>$Species and morphotypes</taxonname>

                                            <taxonomicname>$Specie+autor</taxonomicname>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                    <taxonfit>$Qualifier</taxonfit>

                                </taxondetermination>

                                <taxondetermination>

                                    <isoriginal>true</isoriginal>

                                    <taxonverbatim_id>

                                        <taxonverbatim>

                                            <family>$Field family</family>

                                            <genus>$Field name</genus>

                                        </taxonverbatim>

                                    </taxonverbatim_id>

                                </taxondetermination>

                            </taxonoccurrence>

                        </locationevent>

                        <sourceaccessioncode>

                            <_join>

                                <1>$Inventory code</1>

                                <2>$Number of subplot</2>

                            </_join>

                        </sourceaccessioncode>

                    </location>

                </path>

            </_simplifyPath>

        </path>

    </_setDefault>

</VegBIEN>

Inserted 33 new rows into database

Madidi,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments

Specimen,"/_if[@name=""if specimen""]/cond/_exists",

Number of subplot,"/location/_if[@name=""if subplot""]/cond/_exists",

Inventory name,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",

Inventory code,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",

Specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists",

Specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",

Specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",

Inventory code,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",

Inventory name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",

Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",

Number of subplot,/location/authorlocationcode,

Expedition,/location/locationevent/*_id/project/projectname,

Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",

Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",

Inventory name,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",

Number of subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",

Inventory code,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",

Observations,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,

Tree number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,

Specimen,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",

Specimen,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",

Trunk,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,

Liana presence,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=lianaInfestation]]:[@fkey=tablerecord_id]/definedvalue",

Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,Assuming units based on the range and precision of values

Total height,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,Assuming units based on the range and precision of values

Tag number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag,

Subplot X,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/xposition_m,"Assuming units based on the size of values relative to the plot area, which has units of ha"

Subplot Y,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/yposition_m,"Assuming units based on the size of values relative to the plot area, which has units of ha"

Inventory code,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

Inventory name,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",

Tree number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",

Tag number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",

Specie+autor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",

Species and morphotypes,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3","Contains less than ""Specie+autor"""

Index collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,

Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{""Árbol"",Arbol,""Árbolito"",Arbolito,Palmera}=tree,Hemiepifito=hemiepiphyte,Liana=liana,Arbusto=shrub,./{""Helecho arbóreo"",""Helecho arboreo""}=forb]/value",

Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,

Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",

Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",

Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname",

Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",

Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,

Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,

Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor"""

Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,

Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,

Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2,

Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,

Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,

Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,

Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,

Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,"Contains less than ""Specie+autor"""

Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,

Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,

Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family,

Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus,Often = Genera

Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",

Inventory code,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",

Number of subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",

Inventory code,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",

Number of subplot,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",

Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"

Bole height,,** No join mapping for *Bole height ** trunk height

Circumference,,** No join mapping for *Circumference ** 

Common name,,** No join mapping for *Common name ** 

Crown position,,** No join mapping for *Crown position ** 

Crown shape,,** No join mapping for *Crown shape ** 

Expedition specimen,,** No join mapping for *Expedition specimen ** 

Number of inventory (expedition),,** No join mapping for *Number of inventory (expedition) ** 

Number of inventory (general),,** No join mapping for *Number of inventory (general) ** 

Phenology,,** No join mapping for *Phenology ** 

Plot X,,** No join mapping for *Plot X ** 

Plot Y,,** No join mapping for *Plot Y ** 

Plot specimen,,** No join mapping for *Plot specimen ** 

Project specimen,,** No join mapping for *Project specimen ** 

Similar specimen,,** No join mapping for *Similar specimen ** 

"Type Inventory (C, PP, TP)",,"** No join mapping for *Type Inventory (C, PP, TP) ** "