Project

General

Profile

« Previous | Next » 

Revision 1439

Added by Aaron Marcuse-Kubitza over 12 years ago

Renamed inputs/UArizona to inputs/ARIZ to match herbarium code

View differences:

inputs/UArizona/test/DwC.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 
    <list id="0">
4 
        <institutionID>UArizona</institutionID>
5 
        <BasisOfRecord>PreservedSpecimen</BasisOfRecord>
6 
        <CatalogNumber>104</CatalogNumber>
7 
        <CollectionCode>ARIZ</CollectionCode>
8 
        <Collector>J. Freeland</Collector>
9 
        <CollectorNumber>36</CollectorNumber>
10 
        <Country>Mexico</Country>
11 
        <DateLastModified>2000-12-12 00:00:01</DateLastModified>
12 
        <DayCollected>23</DayCollected>
13 
        <DayIdentified>23</DayIdentified>
14 
        <Family>Rubiaceae</Family>
15 
        <FieldNotes>Much branched shrub with long white thorns and pale yellow catkins.</FieldNotes>
16 
        <FieldNumber>36</FieldNumber>
17 
        <Genus>Cephaelis</Genus>
18 
        <HigherGeography>Mexico:Guerrero:</HigherGeography>
19 
        <InstitutionCode>Herbarium</InstitutionCode>
20 
        <Kingdom>Plantae</Kingdom>
21 
        <Locality>Iguala, Hwy. 95, 4/10 mi. So. of La Cabana Motel. Dry valley.</Locality>
22 
        <MonthCollected>1</MonthCollected>
23 
        <MonthIdentified>1</MonthIdentified>
24 
        <Order>Gentianales</Order>
25 
        <ScientificName>Cephaelis elata Sw.</ScientificName>
26 
        <Species>elata</Species>
27 
        <StateProvince>Guerrero</StateProvince>
28 
        <YearCollected>1971</YearCollected>
29 
        <YearIdentified>1971</YearIdentified>
30 
        <eventDate>23 January 1971</eventDate>
31 
        <occurrenceID>Herbarium:ARIZ:dbsn104</occurrenceID>
32 
    </list>
33 
    <list id="1">
34 
        <institutionID>UArizona</institutionID>
35 
        <BasisOfRecord>PreservedSpecimen</BasisOfRecord>
36 
        <CatalogNumber>198483</CatalogNumber>
37 
        <CollectionCode>ARIZ</CollectionCode>
38 
        <Collector>M. F. Wojciechowski &amp; M. J. Sanderson</Collector>
39 
        <CollectorNumber>172</CollectorNumber>
40 
        <Country>Afghanistan</Country>
41 
        <DateLastModified>2008-02-11 10:52:02</DateLastModified>
42 
        <DayCollected>1</DayCollected>
43 
        <DayIdentified>1</DayIdentified>
44 
        <Family>Fabaceae</Family>
45 
        <FieldNumber>172</FieldNumber>
46 
        <Genus>Astragalus</Genus>
47 
        <HigherGeography>Afghanistan::</HigherGeography>
48 
        <InstitutionCode>Herbarium</InstitutionCode>
49 
        <Kingdom>Plantae</Kingdom>
50 
        <Locality>Grown in University of Arizona (tucson, AZ) greenhouses from seeds provided by the USDA, Plant Introduction accession 220085. .</Locality>
51 
        <MonthCollected>2</MonthCollected>
52 
        <MonthIdentified>2</MonthIdentified>
53 
        <Order>Fabales</Order>
54 
        <RelatedCatalogItem>353971</RelatedCatalogItem>
55 
        <ScientificName>Astragalus tribuloides Kotschy ex Bunge</ScientificName>
56 
        <Species>tribuloides</Species>
57 
        <YearCollected>1993</YearCollected>
58 
        <YearIdentified>1993</YearIdentified>
59 
        <eventDate>1 february 1993</eventDate>
60 
        <occurrenceID>Herbarium:ARIZ:dbsn198483</occurrenceID>
61 
    </list>
62 
</DwC>
inputs/UArizona/test/VegBIEN.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegBIEN>
3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
12 
                                        <namedplace>
13 
                                            <rank>stateProvince</rank>
14 
                                            <placename>Guerrero</placename>
15 
                                            <parent_id>
16 
                                                <namedplace>
17 
                                                    <rank>country</rank>
18 
                                                    <placename>Mexico</placename>
19 
                                                </namedplace>
20 
                                            </parent_id>
21 
                                        </namedplace>
22 
                                    </namedplace_id>
23 
                                </locationdetermination>
24 
                                <locationnarrative>Iguala, Hwy. 95, 4/10 mi. So. of La Cabana Motel. Dry valley.</locationnarrative>
25 
                            </location>
26 
                        </location_id>
27 
                        <obsstartdate>1971-01-23</obsstartdate>
28 
                        <obsenddate/>
29 
                    </locationevent>
30 
                </locationevent_id>
31 
                <taxondetermination>
32 
                    <role>identifier</role>
33 
                    <determinationdate>1971-01-23</determinationdate>
34 
                    <isoriginal>true</isoriginal>
35 
                    <iscurrent>true</iscurrent>
36 
                    <plantconcept_id>
37 
                        <plantconcept>
38 
                            <plantname_id>
39 
                                <plantname>
40 
                                    <rank>binomial</rank>
41 
                                    <plantname>Cephaelis elata Sw.</plantname>
42 
                                    <parent_id>
43 
                                        <plantname>
44 
                                            <rank>species</rank>
45 
                                            <plantname>elata</plantname>
46 
                                            <parent_id>
47 
                                                <plantname>
48 
                                                    <rank>genus</rank>
49 
                                                    <plantname>Cephaelis</plantname>
50 
                                                    <parent_id>
51 
                                                        <plantname>
52 
                                                            <rank>family</rank>
53 
                                                            <plantname>Rubiaceae</plantname>
54 
                                                            <parent_id>
55 
                                                                <plantname>
56 
                                                                    <rank>order</rank>
57 
                                                                    <plantname>Gentianales</plantname>
58 
                                                                    <parent_id>
59 
                                                                        <plantname>
60 
                                                                            <rank>kingdom</rank>
61 
                                                                            <plantname>Plantae</plantname>
62 
                                                                        </plantname>
63 
                                                                    </parent_id>
64 
                                                                </plantname>
65 
                                                            </parent_id>
66 
                                                        </plantname>
67 
                                                    </parent_id>
68 
                                                </plantname>
69 
                                            </parent_id>
70 
                                        </plantname>
71 
                                    </parent_id>
72 
                                </plantname>
73 
                            </plantname_id>
74 
                        </plantconcept>
75 
                    </plantconcept_id>
76 
                </taxondetermination>
77 
                <verbatimcollectorname>J. Freeland</verbatimcollectorname>
78 
            </taxonoccurrence>
79 
        </taxonoccurrence_id>
80 
        <collectioncode_dwc>ARIZ</collectioncode_dwc>
81 
        <description>Much branched shrub with long white thorns and pale yellow catkins.</description>
82 
        <datasource_id><party><organizationname>UArizona</organizationname></party></datasource_id>
83 
        <catalognumber_dwc>104</catalognumber_dwc>
84 
        <sourceaccessioncode>Herbarium:ARIZ:dbsn104</sourceaccessioncode>
85 
        <collectionnumber>36</collectionnumber>
86 
    </specimenreplicate>
87 
    <specimenreplicate id="1">
88 
        <taxonoccurrence_id>
89 
            <taxonoccurrence>
90 
                <locationevent_id>
91 
                    <locationevent>
92 
                        <location_id>
93 
                            <location>
94 
                                <locationdetermination>
95 
                                    <namedplace_id>
96 
                                        <namedplace>
97 
                                            <rank>country</rank>
98 
                                            <placename>Afghanistan</placename>
99 
                                        </namedplace>
100 
                                    </namedplace_id>
101 
                                </locationdetermination>
102 
                                <locationnarrative>Grown in University of Arizona (tucson, AZ) greenhouses from seeds provided by the USDA, Plant Introduction accession 220085. .</locationnarrative>
103 
                            </location>
104 
                        </location_id>
105 
                        <obsstartdate>1993-02-01</obsstartdate>
106 
                        <obsenddate/>
107 
                    </locationevent>
108 
                </locationevent_id>
109 
                <taxondetermination>
110 
                    <role>identifier</role>
111 
                    <determinationdate>1993-02-01</determinationdate>
112 
                    <isoriginal>true</isoriginal>
113 
                    <iscurrent>true</iscurrent>
114 
                    <plantconcept_id>
115 
                        <plantconcept>
116 
                            <plantname_id>
117 
                                <plantname>
118 
                                    <rank>binomial</rank>
119 
                                    <plantname>Astragalus tribuloides Kotschy ex Bunge</plantname>
120 
                                    <parent_id>
121 
                                        <plantname>
122 
                                            <rank>species</rank>
123 
                                            <plantname>tribuloides</plantname>
124 
                                            <parent_id>
125 
                                                <plantname>
126 
                                                    <rank>genus</rank>
127 
                                                    <plantname>Astragalus</plantname>
128 
                                                    <parent_id>
129 
                                                        <plantname>
130 
                                                            <rank>family</rank>
131 
                                                            <plantname>Fabaceae</plantname>
132 
                                                            <parent_id>
133 
                                                                <plantname>
134 
                                                                    <rank>order</rank>
135 
                                                                    <plantname>Fabales</plantname>
136 
                                                                    <parent_id>
137 
                                                                        <plantname>
138 
                                                                            <rank>kingdom</rank>
139 
                                                                            <plantname>Plantae</plantname>
140 
                                                                        </plantname>
141 
                                                                    </parent_id>
142 
                                                                </plantname>
143 
                                                            </parent_id>
144 
                                                        </plantname>
145 
                                                    </parent_id>
146 
                                                </plantname>
147 
                                            </parent_id>
148 
                                        </plantname>
149 
                                    </parent_id>
150 
                                </plantname>
151 
                            </plantname_id>
152 
                        </plantconcept>
153 
                    </plantconcept_id>
154 
                </taxondetermination>
155 
                <verbatimcollectorname>M. F. Wojciechowski &amp; M. J. Sanderson</verbatimcollectorname>
156 
            </taxonoccurrence>
157 
        </taxonoccurrence_id>
158 
        <collectioncode_dwc>ARIZ</collectioncode_dwc>
159 
        <datasource_id><party><organizationname>UArizona</organizationname></party></datasource_id>
160 
        <catalognumber_dwc>198483</catalognumber_dwc>
161 
        <sourceaccessioncode>Herbarium:ARIZ:dbsn198483</sourceaccessioncode>
162 
        <collectionnumber>172</collectionnumber>
163 
    </specimenreplicate>
164 
</VegBIEN>
inputs/UArizona/test/import.specimens.out.ref
1 
Inserted 29 new rows into database
inputs/UArizona/maps/DwC.specimens.csv
1 
"UArizona[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2 
"GlobalUniqueIdentifier","occurrenceID",
3 
"CatalogNumber",,"Map to nothing so it doesn't overwrite CatalogNumberNumeric"
4 
"CatalogNumberNumeric","CatalogNumber",
5 
"TimeCollected","TimeOfDay",
6 
"VerbatimCollectingDate","eventDate/_alt/0",
7 
"HorizontalDatum",,"Not used"
8 
"OriginalCoordinateSystem","verbatimSRS",
9 
"GeorefMethod","georeferenceProtocol",
10 
"LatLongComments","georeferenceRemarks",
11 
"ScientificName","ScientificName/_alt/2",
12 
"ScientificNameAuthor","ScientificName/_alt/1","Contains the binomial in addition to the authority"
13 
"IdentificationModifier","identificationQualifier",
14 
"Tissues",,"Not used"
15 
"AgeClass","lifeStage",
16 
"GenBankNum","associatedSequences/_label[label=""GenBank""]/value",
17 
"OtherCatalogNumbers","RelatedCatalogItem",
18 
"RelatedCatalogedItems","RelatedCatalogItem","Used only when OtherCatalogNumbers is NULL, so _alt not needed"
19 
"Remarks","taxonRemarks",
inputs/UArizona/maps/DwC.specimens.full.csv
1 
UArizona[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2 
AcceptedNameUsage,AcceptedNameUsage
3 
AcceptedNameUsageID,AcceptedNameUsageID
4 
AssociatedMedia,AssociatedMedia
5 
AssociatedOccurrences,AssociatedOccurrences
6 
AssociatedReferences,AssociatedReferences
7 
AssociatedSequences,AssociatedSequences
8 
AssociatedTaxa,AssociatedTaxa
9 
BasisOfRecord,BasisOfRecord
10 
Bed,Bed
11 
Behavior,Behavior
12 
BoundingBox,BoundingBox
13 
CatalogNumberNumeric,CatalogNumber,
14 
Class,Class
15 
CollectedDate,CollectedDate
16 
CollectionCode,CollectionCode
17 
CollectionID,CollectionID
18 
Collector,Collector
19 
CollectorNumber,CollectorNumber
20 
Continent,Continent
21 
ContinentOcean,ContinentOcean
22 
CoordinatePrecision,CoordinatePrecision
23 
CoordinateUncertaintyInMeters,CoordinateUncertaintyInMeters
24 
Country,Country
25 
CountryCode,CountryCode
26 
County,County
27 
DataGeneralizations,DataGeneralizations
28 
DatasetID,DatasetID
29 
DatasetName,DatasetName
30 
DateIdentified,DateIdentified
31 
DateLastModified,DateLastModified
32 
Day,Day
33 
DayCollected,DayCollected
34 
DayIdentified,DayIdentified
35 
Dcterms:accessRights,Dcterms:accessRights
36 
Dcterms:bibliographicCitation,Dcterms:bibliographicCitation
37 
Dcterms:language,Dcterms:language
38 
Dcterms:modified,Dcterms:modified
39 
Dcterms:references,Dcterms:references
40 
Dcterms:rights,Dcterms:rights
41 
Dcterms:rightsHolder,Dcterms:rightsHolder
42 
Dcterms:type,Dcterms:type
43 
DecimalLatitude,DecimalLatitude
44 
DecimalLongitude,DecimalLongitude
45 
Disposition,Disposition
46 
DynamicProperties,DynamicProperties
47 
EarliestAgeOrLowestStage,EarliestAgeOrLowestStage
48 
EarliestEonOrLowestEonothem,EarliestEonOrLowestEonothem
49 
EarliestEpochOrLowestSeries,EarliestEpochOrLowestSeries
50 
EarliestEraOrLowestErathem,EarliestEraOrLowestErathem
51 
EarliestPeriodOrLowestSystem,EarliestPeriodOrLowestSystem
52 
EndDayOfYear,EndDayOfYear
53 
EstablishmentMeans,EstablishmentMeans
54 
EventDate,EventDate
55 
EventID,EventID
56 
EventRemarks,EventRemarks
57 
EventTime,EventTime
58 
Family,Family
59 
FieldNotes,FieldNotes
60 
FieldNumber,FieldNumber
61 
FootprintSRS,FootprintSRS
62 
FootprintSpatialFit,FootprintSpatialFit
63 
FootprintWKT,FootprintWKT
64 
Formation,Formation
65 
Genus,Genus
66 
GeodeticDatum,GeodeticDatum
67 
GeologicalContextID,GeologicalContextID
68 
GeoreferenceProtocol,GeoreferenceProtocol
69 
GeoreferenceRemarks,GeoreferenceRemarks
70 
GeoreferenceSources,GeoreferenceSources
71 
GeoreferenceVerificationStatus,GeoreferenceVerificationStatus
72 
GeoreferencedBy,GeoreferencedBy
73 
GeoreferencedDate,GeoreferencedDate
74 
Group,Group
75 
Habitat,Habitat
76 
HigherClassification,HigherClassification
77 
HigherGeography,HigherGeography
78 
HigherGeographyID,HigherGeographyID
79 
HighestBiostratigraphicZone,HighestBiostratigraphicZone
80 
IdentificationID,IdentificationID
81 
IdentificationQualifier,IdentificationQualifier
82 
IdentificationReferences,IdentificationReferences
83 
IdentificationRemarks,IdentificationRemarks
84 
IdentificationVerificationStatus,IdentificationVerificationStatus
85 
IdentifiedBy,IdentifiedBy
86 
IdentifiedDate,IdentifiedDate
87 
IndividualCount,IndividualCount
88 
IndividualID,IndividualID
89 
InformationWithheld,InformationWithheld
90 
InfraspecificEpithet,InfraspecificEpithet
91 
InstitutionCode,InstitutionCode
92 
InstitutionID,InstitutionID
93 
Island,Island
94 
IslandGroup,IslandGroup
95 
JulianDay,JulianDay
96 
Kingdom,Kingdom
97 
LatestAgeOrHighestStage,LatestAgeOrHighestStage
98 
LatestEonOrHighestEonothem,LatestEonOrHighestEonothem
99 
LatestEpochOrHighestSeries,LatestEpochOrHighestSeries
100 
LatestEraOrHighestErathem,LatestEraOrHighestErathem
101 
LatestPeriodOrHighestSystem,LatestPeriodOrHighestSystem
102 
Latitude,Latitude
103 
LifeStage,LifeStage
104 
LithostratigraphicTerms,LithostratigraphicTerms
105 
Locality,Locality
106 
LocationAccordingTo,LocationAccordingTo
107 
LocationID,LocationID
108 
LocationRemarks,LocationRemarks
109 
Longitude,Longitude
110 
LowestBiostratigraphicZone,LowestBiostratigraphicZone
111 
MaximumDepth,MaximumDepth
112 
MaximumDepthInMeters,MaximumDepthInMeters
113 
MaximumDistanceAboveSurfaceInMeters,MaximumDistanceAboveSurfaceInMeters
114 
MaximumElevation,MaximumElevation
115 
MaximumElevationInMeters,MaximumElevationInMeters
116 
MeasurementAccuracy,MeasurementAccuracy
117 
MeasurementDeterminedBy,MeasurementDeterminedBy
118 
MeasurementDeterminedDate,MeasurementDeterminedDate
119 
MeasurementID,MeasurementID
120 
MeasurementMethod,MeasurementMethod
121 
MeasurementRemarks,MeasurementRemarks
122 
MeasurementType,MeasurementType
123 
MeasurementUnit,MeasurementUnit
124 
MeasurementValue,MeasurementValue
125 
Member,Member
126 
MinimumDepth,MinimumDepth
127 
MinimumDepthInMeters,MinimumDepthInMeters
128 
MinimumDistanceAboveSurfaceInMeters,MinimumDistanceAboveSurfaceInMeters
129 
MinimumElevation,MinimumElevation
130 
MinimumElevationInMeters,MinimumElevationInMeters
131 
Month,Month
132 
MonthCollected,MonthCollected
133 
MonthIdentified,MonthIdentified
134 
Municipality,Municipality
135 
NameAccordingTo,NameAccordingTo
136 
NameAccordingToID,NameAccordingToID
137 
NamePublishedIn,NamePublishedIn
138 
NamePublishedInID,NamePublishedInID
139 
NamePublishedInYear,NamePublishedInYear
140 
NomenclaturalCode,NomenclaturalCode
141 
NomenclaturalStatus,NomenclaturalStatus
142 
Notes,Notes
143 
OccurrenceID,OccurrenceID
144 
OccurrenceRemarks,OccurrenceRemarks
145 
OccurrenceStatus,OccurrenceStatus
146 
Order,Order
147 
OriginalNameUsage,OriginalNameUsage
148 
OriginalNameUsageID,OriginalNameUsageID
149 
OwnerInstitutionCode,OwnerInstitutionCode
150 
ParentNameUsage,ParentNameUsage
151 
ParentNameUsageID,ParentNameUsageID
152 
Phylum,Phylum
153 
PointRadiusSpatialFit,PointRadiusSpatialFit
154 
PreparationType,PreparationType
155 
Preparations,Preparations
156 
PreviousCatalogNumber,PreviousCatalogNumber
157 
PreviousIdentifications,PreviousIdentifications
158 
RecordNumber,RecordNumber
159 
RecordedBy,RecordedBy
160 
OtherCatalogNumbers,RelatedCatalogItem,
161 
RelatedCatalogItem,RelatedCatalogItem
162 
RelatedCatalogedItems,RelatedCatalogItem,"Used only when OtherCatalogNumbers is NULL, so _alt not needed"
163 
RelatedResourceID,RelatedResourceID
164 
RelationshipAccordingTo,RelationshipAccordingTo
165 
RelationshipEstablishedDate,RelationshipEstablishedDate
166 
RelationshipOfResource,RelationshipOfResource
167 
RelationshipRemarks,RelationshipRemarks
168 
RelationshipType,RelationshipType
169 
ReproductiveCondition,ReproductiveCondition
170 
ResourceID,ResourceID
171 
ResourceRelationshipID,ResourceRelationshipID
172 
SamplingEffort,SamplingEffort
173 
SamplingProtocol,SamplingProtocol
174 
ScientificNameAuthor,ScientificName/_alt/1,Contains the binomial in addition to the authority
175 
ScientificName,ScientificName/_alt/2,
176 
ScientificNameAuthorship,ScientificNameAuthorship
177 
ScientificNameID,ScientificNameID
178 
Sex,Sex
179 
Species,Species
180 
SpecificEpithet,SpecificEpithet
181 
StartDayOfYear,StartDayOfYear
182 
StateProvince,StateProvince
183 
Subgenus,Subgenus
184 
Subspecies,Subspecies
185 
TaxonConceptID,TaxonConceptID
186 
TaxonID,TaxonID
187 
TaxonRank,TaxonRank
188 
TaxonRemarks,TaxonRemarks
189 
TaxonomicStatus,TaxonomicStatus
190 
TimeCollected,TimeOfDay,
191 
TimeOfDay,TimeOfDay
192 
TypeStatus,TypeStatus
193 
VerbatimCoordinateSystem,VerbatimCoordinateSystem
194 
VerbatimCoordinates,VerbatimCoordinates
195 
VerbatimDepth,VerbatimDepth
196 
VerbatimElevation,VerbatimElevation
197 
VerbatimEventDate,VerbatimEventDate
198 
VerbatimLatitude,VerbatimLatitude
199 
VerbatimLocality,VerbatimLocality
200 
VerbatimLongitude,VerbatimLongitude
201 
VerbatimSRS,VerbatimSRS
202 
VerbatimTaxonRank,VerbatimTaxonRank
203 
VernacularName,VernacularName
204 
WaterBody,WaterBody
205 
Year,Year
206 
YearCollected,YearCollected
207 
YearIdentified,YearIdentified
208 
acceptedNameUsage,acceptedNameUsage
209 
acceptedNameUsageID,acceptedNameUsageID
210 
associatedMedia,associatedMedia
211 
associatedOccurrences,associatedOccurrences
212 
associatedReferences,associatedReferences
213 
associatedSequences,associatedSequences
214 
GenBankNum,"associatedSequences/_label[label=""GenBank""]/value",
215 
associatedTaxa,associatedTaxa
216 
basisOfRecord,basisOfRecord
217 
bed,bed
218 
behavior,behavior
219 
catalogNumber,catalogNumber
220 
class,class
221 
collectionCode,collectionCode
222 
collectionID,collectionID
223 
continent,continent
224 
coordinatePrecision,coordinatePrecision
225 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
226 
country,country
227 
countryCode,countryCode
228 
county,county
229 
dataGeneralizations,dataGeneralizations
230 
datasetID,datasetID
231 
datasetName,datasetName
232 
dateIdentified,dateIdentified
233 
dateIdentified/_alt,dateIdentified/_alt
234 
day,day
235 
dcterms:accessRights,dcterms:accessRights
236 
dcterms:bibliographicCitation,dcterms:bibliographicCitation
237 
dcterms:language,dcterms:language
238 
dcterms:modified,dcterms:modified
239 
dcterms:references,dcterms:references
240 
dcterms:rights,dcterms:rights
241 
dcterms:rightsHolder,dcterms:rightsHolder
242 
dcterms:type,dcterms:type
243 
decimalLatitude,decimalLatitude
244 
decimalLongitude,decimalLongitude
245 
disposition,disposition
246 
dynamicProperties,dynamicProperties
247 
earliestAgeOrLowestStage,earliestAgeOrLowestStage
248 
earliestEonOrLowestEonothem,earliestEonOrLowestEonothem
249 
earliestEpochOrLowestSeries,earliestEpochOrLowestSeries
250 
earliestEraOrLowestErathem,earliestEraOrLowestErathem
251 
earliestPeriodOrLowestSystem,earliestPeriodOrLowestSystem
252 
endDayOfYear,endDayOfYear
253 
establishmentMeans,establishmentMeans
254 
eventDate,eventDate
255 
eventDate/_alt,eventDate/_alt
256 
VerbatimCollectingDate,eventDate/_alt/0,
257 
eventID,eventID
258 
eventRemarks,eventRemarks
259 
eventTime,eventTime
260 
family,family
261 
fieldNotes,fieldNotes
262 
fieldNumber,fieldNumber
263 
footprintSRS,footprintSRS
264 
footprintSpatialFit,footprintSpatialFit
265 
footprintWKT,footprintWKT
266 
formation,formation
267 
genus,genus
268 
geodeticDatum,geodeticDatum
269 
geologicalContextID,geologicalContextID
270 
GeorefMethod,georeferenceProtocol,
271 
georeferenceProtocol,georeferenceProtocol
272 
LatLongComments,georeferenceRemarks,
273 
georeferenceRemarks,georeferenceRemarks
274 
georeferenceSources,georeferenceSources
275 
georeferenceVerificationStatus,georeferenceVerificationStatus
276 
georeferencedBy,georeferencedBy
277 
georeferencedDate,georeferencedDate
278 
group,group
279 
habitat,habitat
280 
higherClassification,higherClassification
281 
higherGeography,higherGeography
282 
higherGeographyID,higherGeographyID
283 
highestBiostratigraphicZone,highestBiostratigraphicZone
284 
identificationID,identificationID
285 
IdentificationModifier,identificationQualifier,
286 
identificationQualifier,identificationQualifier
287 
identificationReferences,identificationReferences
288 
identificationRemarks,identificationRemarks
289 
identificationVerificationStatus,identificationVerificationStatus
290 
identifiedBy,identifiedBy
291 
individualCount,individualCount
292 
individualID,individualID
293 
informationWithheld,informationWithheld
294 
infraspecificEpithet,infraspecificEpithet
295 
institutionCode,institutionCode
296 
institutionID,institutionID
297 
island,island
298 
islandGroup,islandGroup
299 
kingdom,kingdom
300 
latestAgeOrHighestStage,latestAgeOrHighestStage
301 
latestEonOrHighestEonothem,latestEonOrHighestEonothem
302 
latestEpochOrHighestSeries,latestEpochOrHighestSeries
303 
latestEraOrHighestErathem,latestEraOrHighestErathem
304 
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
305 
AgeClass,lifeStage,
306 
lifeStage,lifeStage
307 
lithostratigraphicTerms,lithostratigraphicTerms
308 
locality,locality
309 
locationAccordingTo,locationAccordingTo
310 
locationID,locationID
311 
locationRemarks,locationRemarks
312 
lowestBiostratigraphicZone,lowestBiostratigraphicZone
313 
maximumDepthInMeters,maximumDepthInMeters
314 
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
315 
maximumElevationInMeters,maximumElevationInMeters
316 
measurementAccuracy,measurementAccuracy
317 
measurementDeterminedBy,measurementDeterminedBy
318 
measurementDeterminedDate,measurementDeterminedDate
319 
measurementID,measurementID
320 
measurementMethod,measurementMethod
321 
measurementRemarks,measurementRemarks
322 
measurementType,measurementType
323 
measurementUnit,measurementUnit
324 
measurementValue,measurementValue
325 
member,member
326 
minimumDepthInMeters,minimumDepthInMeters
327 
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
328 
minimumElevationInMeters,minimumElevationInMeters
329 
month,month
330 
municipality,municipality
331 
nameAccordingTo,nameAccordingTo
332 
nameAccordingToID,nameAccordingToID
333 
namePublishedIn,namePublishedIn
334 
namePublishedInID,namePublishedInID
335 
namePublishedInYear,namePublishedInYear
336 
nomenclaturalCode,nomenclaturalCode
337 
nomenclaturalStatus,nomenclaturalStatus
338 
GlobalUniqueIdentifier,occurrenceID,
339 
occurrenceID,occurrenceID
340 
occurrenceRemarks,occurrenceRemarks
341 
occurrenceStatus,occurrenceStatus
342 
order,order
343 
originalNameUsage,originalNameUsage
344 
originalNameUsageID,originalNameUsageID
345 
otherCatalogNumbers,otherCatalogNumbers
346 
ownerInstitutionCode,ownerInstitutionCode
347 
parentNameUsage,parentNameUsage
348 
parentNameUsageID,parentNameUsageID
349 
phylum,phylum
350 
pointRadiusSpatialFit,pointRadiusSpatialFit
351 
preparations,preparations
352 
previousIdentifications,previousIdentifications
353 
recordNumber,recordNumber
354 
recordedBy,recordedBy
355 
relatedResourceID,relatedResourceID
356 
relationshipAccordingTo,relationshipAccordingTo
357 
relationshipEstablishedDate,relationshipEstablishedDate
358 
relationshipOfResource,relationshipOfResource
359 
relationshipRemarks,relationshipRemarks
360 
reproductiveCondition,reproductiveCondition
361 
resourceID,resourceID
362 
resourceRelationshipID,resourceRelationshipID
363 
samplingEffort,samplingEffort
364 
samplingProtocol,samplingProtocol
365 
scientificName,scientificName
366 
scientificNameAuthorship,scientificNameAuthorship
367 
scientificNameID,scientificNameID
368 
sex,sex
369 
specificEpithet,specificEpithet
370 
startDayOfYear,startDayOfYear
371 
stateProvince,stateProvince
372 
subgenus,subgenus
373 
taxonConceptID,taxonConceptID
374 
taxonID,taxonID
375 
taxonRank,taxonRank
376 
Remarks,taxonRemarks,
377 
taxonRemarks,taxonRemarks
378 
taxonomicStatus,taxonomicStatus
379 
typeStatus,typeStatus
380 
verbatimCoordinateSystem,verbatimCoordinateSystem
381 
verbatimCoordinates,verbatimCoordinates
382 
verbatimDepth,verbatimDepth
383 
verbatimElevation,verbatimElevation
384 
verbatimEventDate,verbatimEventDate
385 
verbatimLatitude,verbatimLatitude
386 
verbatimLocality,verbatimLocality
387 
verbatimLongitude,verbatimLongitude
388 
OriginalCoordinateSystem,verbatimSRS,
389 
verbatimSRS,verbatimSRS
390 
verbatimTaxonRank,verbatimTaxonRank
391 
vernacularName,vernacularName
392 
waterBody,waterBody
393 
year,year
394 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
395 
HorizontalDatum,,Not used
396 
Tissues,,Not used
inputs/UArizona/maps/VegBIEN.specimens.csv
1 
UArizona[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7 
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
10 
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
11 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",,65
12 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",,65
13 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
14 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
15 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
17 
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
18 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
19 
Habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
20 
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
21 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
22 
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
23 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
25 
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
26 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27 
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
28 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
29 
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
30 
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
31 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32 
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
33 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
34 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
35 
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
36 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37 
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
38 
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
39 
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40 
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
41 
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
42 
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43 
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
44 
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
45 
VerbatimCollectingDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/0",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
46 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
47 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
48 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
49 
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
50 
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
51 
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
52 
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
53 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
54 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
55 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
56 
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
57 
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
58 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
59 
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
60 
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
61 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/1","Contains the binomial in addition to the authority; Brad: Bob, Nick, please is this mapping OK?",134
62 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/2","Brad: Bob, Nick, please is this mapping OK?",134
63 
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
64 
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
65 
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
66 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
67 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
68 
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
69 
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
70 
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
71 
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
72 
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
73 
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
74 
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
75 
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
76 
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
77 
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
78 
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
79 
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
80 
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
81 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
82 
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
83 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
84 
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
85 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
86 
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
87 
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
88 
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
89 
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
90 
FieldNotes,/description/_merge/1,,
91 
Notes,/description/_merge/1,,
92 
fieldNotes,/description/_merge/1,,
93 
Remarks,/description/_merge/2,,158
94 
TaxonRemarks,/description/_merge/2,,158
95 
taxonRemarks,/description/_merge/2,,158
96 
CatalogNumberNumeric,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
97 
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
98 
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
99 
OccurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
100 
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
101 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
102 
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
103 
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
104 
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
105 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
106 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
107 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
108 
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
109 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
110 
AcceptedNameUsage,,,135
111 
AcceptedNameUsageID,,,128
112 
AgeClass,,,27
113 
AssociatedMedia,,,36
114 
AssociatedOccurrences,,,38
115 
AssociatedReferences,,,37
116 
AssociatedSequences,,,39
117 
AssociatedTaxa,,,40
118 
BasisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
119 
Bed,,,117
120 
Behavior,,,29
121 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
122 
Continent,,Brad: OMIT,59
123 
ContinentOcean,,Brad: OMIT,59
124 
CountryCode,,,64
125 
DataGeneralizations,,,17
126 
DatasetID,,,10
127 
DatasetName,,,13
128 
DateLastModified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
129 
Day,,Brad: OMIT,50
130 
Dcterms:accessRights,,,5
131 
Dcterms:bibliographicCitation,,,6
132 
Dcterms:language,,,2
133 
Dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
134 
Dcterms:references,,,7
135 
Dcterms:rights,,,3
136 
Dcterms:rightsHolder,,,4
137 
Dcterms:type,,,0
138 
Disposition,,,33
139 
DynamicProperties,,,18
140 
EarliestAgeOrLowestStage,,,109
141 
EarliestEonOrLowestEonothem,,,101
142 
EarliestEpochOrLowestSeries,,,107
143 
EarliestEraOrLowestErathem,,,103
144 
EarliestPeriodOrLowestSystem,,,105
145 
EndDayOfYear,,,47
146 
EstablishmentMeans,,,30
147 
EventID,,,41
148 
EventRemarks,,,55
149 
EventTime,,Brad: OMIT,45
150 
FootprintSRS,,,92
151 
FootprintSpatialFit,,,93
152 
Formation,,,115
153 
GenBankNum,,,39
154 
GeodeticDatum,,,87
155 
GeologicalContextID,,,100
156 
GeorefMethod,,,96
157 
GeoreferenceProtocol,,,96
158 
GeoreferenceRemarks,,,99
159 
GeoreferenceSources,,,97
160 
GeoreferenceVerificationStatus,,,98
161 
GeoreferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
162 
GeoreferencedDate,,,95
163 
Group,,,114
164 
HigherClassification,,,141
165 
HigherGeography,,,58
166 
HigherGeographyID,,,57
167 
HighestBiostratigraphicZone,,,112
168 
HorizontalDatum,,Not used
169 
IdentificationID,,,118
170 
IdentificationModifier,,,124
171 
IdentificationQualifier,,,124
172 
IdentificationReferences,,,121
173 
IdentificationRemarks,,,123
174 
IdentificationVerificationStatus,,,122
175 
IndividualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
176 
IndividualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
177 
InformationWithheld,,,16
178 
InstitutionCode,,,
179 
Island,,,62
180 
IslandGroup,,,61
181 
JulianDay,,Brad: OMIT,50
182 
LatLongComments,,,99
183 
LatestAgeOrHighestStage,,,110
184 
LatestEonOrHighestEonothem,,,102
185 
LatestEpochOrHighestSeries,,,108
186 
LatestEraOrHighestErathem,,,104
187 
LatestPeriodOrHighestSystem,,,106
188 
LifeStage,,,27
189 
LithostratigraphicTerms,,,113
190 
LocationAccordingTo,,,78
191 
LocationID,,,56
192 
LocationRemarks,,,79
193 
LowestBiostratigraphicZone,,,111
194 
MaximumDistanceAboveSurfaceInMeters,,,77
195 
MeasurementAccuracy,,,169
196 
MeasurementDeterminedBy,,,172
197 
MeasurementDeterminedDate,,,171
198 
MeasurementID,,,166
199 
MeasurementMethod,,,173
200 
MeasurementRemarks,,,174
201 
MeasurementType,,,167
202 
MeasurementUnit,,,170
203 
MeasurementValue,,,168
204 
Member,,,116
205 
MinimumDistanceAboveSurfaceInMeters,,,76
206 
Month,,,49
207 
Municipality,,,67
208 
NameAccordingTo,,,138
209 
NameAccordingToID,,,131
210 
NamePublishedIn,,,139
211 
NamePublishedInID,,,132
212 
NamePublishedInYear,,,140
213 
NomenclaturalCode,,,155
214 
NomenclaturalStatus,,,157
215 
OccurrenceRemarks,,,21
216 
OccurrenceStatus,,,31
217 
OriginalCoordinateSystem,,,84
218 
OriginalNameUsage,,,137
219 
OriginalNameUsageID,,,130
220 
OtherCatalogNumbers,,Brad: OMIT,161
221 
OwnerInstitutionCode,,,14
222 
ParentNameUsage,,,136
223 
ParentNameUsageID,,,129
224 
PointRadiusSpatialFit,,,90
225 
PreparationType,,Brad: OMIT,32
226 
Preparations,,Brad: OMIT,32
227 
PreviousCatalogNumber,,?; Brad: OMIT,35
228 
PreviousIdentifications,,Brad: OMIT,35
229 
RelatedCatalogItem,,Brad: OMIT,161
230 
RelatedCatalogedItems,,"Used only when OtherCatalogNumbers is NULL, so _alt not needed; Brad: OMIT",161
231 
RelatedResourceID,,Brad: OMIT,161
232 
RelationshipAccordingTo,,,163
233 
RelationshipEstablishedDate,,,164
234 
RelationshipOfResource,,Brad: OMIT,162
235 
RelationshipRemarks,,,165
236 
RelationshipType,,Brad: OMIT,162
237 
ReproductiveCondition,,,28
238 
ResourceID,,,160
239 
ResourceRelationshipID,,,159
240 
SamplingEffort,,,43
241 
SamplingProtocol,,,42
242 
ScientificNameID,,,127
243 
StartDayOfYear,,,46
244 
Subgenus,,,148
245 
TaxonConceptID,,,133
246 
TaxonID,,,126
247 
TaxonRank,,,151
248 
TaxonomicStatus,,,156
249 
TimeCollected,,Brad: OMIT,45
250 
TimeOfDay,,Brad: OMIT,45
251 
Tissues,,Not used
252 
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
253 
VerbatimCoordinateSystem,,,83
254 
VerbatimCoordinates,,,80
255 
VerbatimDepth,,,73
256 
VerbatimElevation,,,70
257 
VerbatimEventDate,,,51
258 
VerbatimSRS,,,84
259 
VerbatimTaxonRank,,,152
260 
VernacularName,,,154
261 
WaterBody,,,60
262 
Year,,,48
263 
acceptedNameUsage,,,135
264 
acceptedNameUsageID,,,128
265 
associatedMedia,,,36
266 
associatedOccurrences,,,38
267 
associatedReferences,,,37
268 
associatedSequences,,,39
269 
associatedTaxa,,,40
270 
basisOfRecord,,Brad: OMIT? See http://rs.tdwg.org/dwc/terms/index.htm#basisOfRecord for definition of this term.,15
271 
bed,,,117
272 
behavior,,,29
273 
continent,,Brad: OMIT,59
274 
countryCode,,,64
275 
dataGeneralizations,,,17
276 
datasetID,,,10
277 
datasetName,,,13
278 
day,,Brad: OMIT,50
279 
dcterms:accessRights,,,5
280 
dcterms:bibliographicCitation,,,6
281 
dcterms:language,,,2
282 
dcterms:modified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
283 
dcterms:references,,,7
284 
dcterms:rights,,,3
285 
dcterms:rightsHolder,,,4
286 
dcterms:type,,,0
287 
disposition,,,33
288 
dynamicProperties,,,18
289 
earliestAgeOrLowestStage,,,109
290 
earliestEonOrLowestEonothem,,,101
291 
earliestEpochOrLowestSeries,,,107
292 
earliestEraOrLowestErathem,,,103
293 
earliestPeriodOrLowestSystem,,,105
294 
endDayOfYear,,,47
295 
establishmentMeans,,,30
296 
eventID,,,41
297 
eventRemarks,,,55
298 
eventTime,,Brad: OMIT,45
299 
footprintSRS,,,92
300 
footprintSpatialFit,,,93
301 
formation,,,115
302 
geodeticDatum,,,87
303 
geologicalContextID,,,100
304 
georeferenceProtocol,,,96
305 
georeferenceRemarks,,,99
306 
georeferenceSources,,,97
307 
georeferenceVerificationStatus,,,98
308 
georeferencedBy,,Brad: Correct for VB. Nick: is there a way to specifically identify this party as collector of a specimen?,94
309 
georeferencedDate,,,95
310 
group,,,114
311 
higherClassification,,,141
312 
higherGeography,,,58
313 
higherGeographyID,,,57
314 
highestBiostratigraphicZone,,,112
315 
identificationID,,,118
316 
identificationQualifier,,,124
317 
identificationReferences,,,121
318 
identificationRemarks,,,123
319 
identificationVerificationStatus,,,122
320 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
321 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
322 
informationWithheld,,,16
323 
institutionCode,,,
324 
island,,,62
325 
islandGroup,,,61
326 
latestAgeOrHighestStage,,,110
327 
latestEonOrHighestEonothem,,,102
328 
latestEpochOrHighestSeries,,,108
329 
latestEraOrHighestErathem,,,104
330 
latestPeriodOrHighestSystem,,,106
331 
lifeStage,,,27
332 
lithostratigraphicTerms,,,113
333 
locationAccordingTo,,,78
334 
locationID,,,56
335 
locationRemarks,,,79
336 
lowestBiostratigraphicZone,,,111
337 
maximumDistanceAboveSurfaceInMeters,,,77
338 
measurementAccuracy,,,169
339 
measurementDeterminedBy,,,172
340 
measurementDeterminedDate,,,171
341 
measurementID,,,166
342 
measurementMethod,,,173
343 
measurementRemarks,,,174
344 
measurementType,,,167
345 
measurementUnit,,,170
346 
measurementValue,,,168
347 
member,,,116
348 
minimumDistanceAboveSurfaceInMeters,,,76
349 
month,,,49
350 
municipality,,,67
351 
nameAccordingTo,,,138
352 
nameAccordingToID,,,131
353 
namePublishedIn,,,139
354 
namePublishedInID,,,132
355 
namePublishedInYear,,,140
356 
nomenclaturalCode,,,155
357 
nomenclaturalStatus,,,157
358 
occurrenceRemarks,,,21
359 
occurrenceStatus,,,31
360 
originalNameUsage,,,137
361 
originalNameUsageID,,,130
362 
otherCatalogNumbers,,,34
363 
ownerInstitutionCode,,,14
364 
parentNameUsage,,,136
365 
parentNameUsageID,,,129
366 
pointRadiusSpatialFit,,,90
367 
preparations,,Brad: OMIT,32
368 
previousIdentifications,,Brad: OMIT,35
369 
relatedResourceID,,Brad: OMIT,161
370 
relationshipAccordingTo,,,163
371 
relationshipEstablishedDate,,,164
372 
relationshipOfResource,,Brad: OMIT,162
373 
relationshipRemarks,,,165
374 
reproductiveCondition,,,28
375 
resourceID,,,160
376 
resourceRelationshipID,,,159
377 
samplingEffort,,,43
378 
samplingProtocol,,,42
379 
scientificNameID,,,127
380 
startDayOfYear,,,46
381 
subgenus,,,148
382 
taxonConceptID,,,133
383 
taxonID,,,126
384 
taxonRank,,,151
385 
taxonomicStatus,,,156
386 
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
387 
verbatimCoordinateSystem,,,83
388 
verbatimCoordinates,,,80
389 
verbatimDepth,,,73
390 
verbatimElevation,,,70
391 
verbatimEventDate,,,51
392 
verbatimSRS,,,84
393 
verbatimTaxonRank,,,152
394 
vernacularName,,,154
395 
waterBody,,,60
396 
year,,,48
inputs/UArizona/maps/src.join.specimens.csv
1 
UArizona[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7 
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9 
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
10 
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
11 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",,65
12 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",,65
13 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
14 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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",Brad: Required; reject record if this field NULL,63
15 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
16 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
17 
VerbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
18 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
19 
Habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
20 
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
21 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
22 
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
23 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
25 
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
26 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27 
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
28 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
29 
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
30 
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
31 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32 
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
33 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
34 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
35 
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
36 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37 
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
38 
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
39 
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40 
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
41 
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
42 
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43 
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
44 
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
45 
VerbatimCollectingDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/0",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
46 
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
47 
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
48 
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
49 
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
50 
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
51 
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
52 
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
53 
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
54 
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
55 
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
56 
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
57 
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
58 
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
59 
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
60 
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname","Brad: Bob, Nick, please is this mapping OK?",134
61 
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/1","Contains the binomial in addition to the authority; Brad: Bob, Nick, please is this mapping OK?",134
62 
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname/_alt/2","Brad: Bob, Nick, please is this mapping OK?",134
63 
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
64 
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
65 
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
66 
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
67 
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
68 
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
69 
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
70 
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
71 
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
72 
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",,147
73 
Family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
74 
family,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",,146
75 
Order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
76 
order,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",,145
77 
Class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
78 
class,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",,144
79 
Phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
80 
phylum,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",,143
81 
Kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
82 
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",,142
83 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
84 
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
85 
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
86 
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
87 
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
88 
Sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
89 
sex,"/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26
90 
FieldNotes,/description/_merge/1,,
91 
Notes,/description/_merge/1,,
92 
fieldNotes,/description/_merge/1,,
93 
Remarks,/description/_merge/2,,158
94 
TaxonRemarks,/description/_merge/2,,158
95 
taxonRemarks,/description/_merge/2,,158
96 
CatalogNumberNumeric,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
97 
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
98 
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
99 
OccurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
100 
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
101 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
102 
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
103 
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
104 
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
105 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
106 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
107 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
108 
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
109 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
110 
AgeClass,,** No join mapping for lifeStage **
111 
BasisOfRecord,,** No join mapping for BasisOfRecord **
112 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
113 
ContinentOcean,,** No join mapping for ContinentOcean **
114 
DateLastModified,,** No join mapping for DateLastModified **
115 
GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** "
116 
GeorefMethod,,** No join mapping for georeferenceProtocol **
117 
HigherGeography,,** No join mapping for HigherGeography **
118 
HorizontalDatum,,Not used
119 
IdentificationModifier,,** No join mapping for identificationQualifier **
120 
IndividualCount,,** No join mapping for IndividualCount **
121 
InstitutionCode,,** No join mapping for InstitutionCode **
122 
Island,,** No join mapping for Island **
123 
IslandGroup,,** No join mapping for IslandGroup **
124 
JulianDay,,** No join mapping for JulianDay **
125 
LatLongComments,,** No join mapping for georeferenceRemarks **
126 
OriginalCoordinateSystem,,** No join mapping for verbatimSRS **
127 
OtherCatalogNumbers,,** No join mapping for RelatedCatalogItem **
128 
Preparations,,** No join mapping for Preparations **
129 
RelatedCatalogedItems,,"** No join mapping for RelatedCatalogItem ** Used only when OtherCatalogNumbers is NULL, so _alt not needed"
130 
TimeCollected,,** No join mapping for TimeOfDay **
131 
Tissues,,Not used
132 
TypeStatus,,** No join mapping for TypeStatus **
133 
VerbatimDepth,,** No join mapping for VerbatimDepth **
134 
VerbatimElevation,,** No join mapping for VerbatimElevation **
inputs/UArizona/maps/src.specimens.csv
1 
"UArizona[DwC]"
2 
"GlobalUniqueIdentifier"
3 
"DateLastModified"
4 
"BasisOfRecord"
5 
"InstitutionCode"
6 
"CollectionCode"
7 
"CatalogNumber"
8 
"CatalogNumberNumeric"
9 
"Collector"
10 
"CollectorNumber"
11 
"FieldNumber"
12 
"YearCollected"
13 
"MonthCollected"
14 
"DayCollected"
15 
"TimeCollected"
16 
"VerbatimCollectingDate"
17 
"FieldNotes"
18 
"JulianDay"
19 
"HigherGeography"
20 
"ContinentOcean"
21 
"IslandGroup"
22 
"Island"
23 
"Country"
24 
"StateProvince"
25 
"County"
26 
"Locality"
27 
"DecimalLatitude"
28 
"DecimalLongitude"
29 
"HorizontalDatum"
30 
"OriginalCoordinateSystem"
31 
"VerbatimLatitude"
32 
"VerbatimLongitude"
33 
"GeorefMethod"
34 
"CoordinateUncertaintyInMeters"
35 
"LatLongComments"
36 
"BoundingBox"
37 
"MinimumElevationInMeters"
38 
"MaximumElevationInMeters"
39 
"VerbatimElevation"
40 
"MinimumDepthInMeters"
41 
"MaximumDepthInMeters"
42 
"VerbatimDepth"
43 
"ScientificName"
44 
"Kingdom"
45 
"Phylum"
46 
"Class"
47 
"Order"
48 
"Family"
49 
"Genus"
50 
"Species"
51 
"Subspecies"
52 
"ScientificNameAuthor"
53 
"IdentifiedBy"
54 
"IdentificationModifier"
55 
"YearIdentified"
56 
"MonthIdentified"
57 
"DayIdentified"
58 
"TypeStatus"
59 
"Sex"
60 
"Preparations"
61 
"Tissues"
62 
"IndividualCount"
63 
"AgeClass"
64 
"GenBankNum"
65 
"OtherCatalogNumbers"
66 
"RelatedCatalogedItems"
67 
"Remarks"
inputs/ARIZ/test/DwC.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 
    <list id="0">
4 
        <institutionID>ARIZ</institutionID>
5 
        <BasisOfRecord>PreservedSpecimen</BasisOfRecord>
6 
        <CatalogNumber>104</CatalogNumber>
7 
        <CollectionCode>ARIZ</CollectionCode>
8 
        <Collector>J. Freeland</Collector>
9 
        <CollectorNumber>36</CollectorNumber>
10 
        <Country>Mexico</Country>
11 
        <DateLastModified>2000-12-12 00:00:01</DateLastModified>
12 
        <DayCollected>23</DayCollected>
13 
        <DayIdentified>23</DayIdentified>
14 
        <Family>Rubiaceae</Family>
15 
        <FieldNotes>Much branched shrub with long white thorns and pale yellow catkins.</FieldNotes>
16 
        <FieldNumber>36</FieldNumber>
17 
        <Genus>Cephaelis</Genus>
18 
        <HigherGeography>Mexico:Guerrero:</HigherGeography>
19 
        <InstitutionCode>Herbarium</InstitutionCode>
20 
        <Kingdom>Plantae</Kingdom>
21 
        <Locality>Iguala, Hwy. 95, 4/10 mi. So. of La Cabana Motel. Dry valley.</Locality>
22 
        <MonthCollected>1</MonthCollected>
23 
        <MonthIdentified>1</MonthIdentified>
24 
        <Order>Gentianales</Order>
25 
        <ScientificName>Cephaelis elata Sw.</ScientificName>
26 
        <Species>elata</Species>
27 
        <StateProvince>Guerrero</StateProvince>
28 
        <YearCollected>1971</YearCollected>
29 
        <YearIdentified>1971</YearIdentified>
30 
        <eventDate>23 January 1971</eventDate>
31 
        <occurrenceID>Herbarium:ARIZ:dbsn104</occurrenceID>
32 
    </list>
33 
    <list id="1">
34 
        <institutionID>ARIZ</institutionID>
35 
        <BasisOfRecord>PreservedSpecimen</BasisOfRecord>
36 
        <CatalogNumber>198483</CatalogNumber>
37 
        <CollectionCode>ARIZ</CollectionCode>
38 
        <Collector>M. F. Wojciechowski &amp; M. J. Sanderson</Collector>
39 
        <CollectorNumber>172</CollectorNumber>
40 
        <Country>Afghanistan</Country>
41 
        <DateLastModified>2008-02-11 10:52:02</DateLastModified>
42 
        <DayCollected>1</DayCollected>
43 
        <DayIdentified>1</DayIdentified>
44 
        <Family>Fabaceae</Family>
45 
        <FieldNumber>172</FieldNumber>
46 
        <Genus>Astragalus</Genus>
47 
        <HigherGeography>Afghanistan::</HigherGeography>
48 
        <InstitutionCode>Herbarium</InstitutionCode>
49 
        <Kingdom>Plantae</Kingdom>
50 
        <Locality>Grown in University of Arizona (tucson, AZ) greenhouses from seeds provided by the USDA, Plant Introduction accession 220085. .</Locality>
51 
        <MonthCollected>2</MonthCollected>
52 
        <MonthIdentified>2</MonthIdentified>
53 
        <Order>Fabales</Order>
54 
        <RelatedCatalogItem>353971</RelatedCatalogItem>
55 
        <ScientificName>Astragalus tribuloides Kotschy ex Bunge</ScientificName>
56 
        <Species>tribuloides</Species>
57 
        <YearCollected>1993</YearCollected>
58 
        <YearIdentified>1993</YearIdentified>
59 
        <eventDate>1 february 1993</eventDate>
60 
        <occurrenceID>Herbarium:ARIZ:dbsn198483</occurrenceID>
61 
    </list>
62 
</DwC>
inputs/ARIZ/test/VegBIEN.specimens.xml.ref
1 
<?xml version="1.0" ?>
2 
<VegBIEN>
3 
    <specimenreplicate id="0">
4 
        <taxonoccurrence_id>
5 
            <taxonoccurrence>
6 
                <locationevent_id>
7 
                    <locationevent>
8 
                        <location_id>
9 
                            <location>
10 
                                <locationdetermination>
11 
                                    <namedplace_id>
12 
                                        <namedplace>
13 
                                            <rank>stateProvince</rank>
14 
                                            <placename>Guerrero</placename>
15 
                                            <parent_id>
16 
                                                <namedplace>
17 
                                                    <rank>country</rank>
18 
                                                    <placename>Mexico</placename>
19 
                                                </namedplace>
20 
                                            </parent_id>
21 
                                        </namedplace>
22 
                                    </namedplace_id>
23 
                                </locationdetermination>
24 
                                <locationnarrative>Iguala, Hwy. 95, 4/10 mi. So. of La Cabana Motel. Dry valley.</locationnarrative>
25 
                            </location>
26 
                        </location_id>
27 
                        <obsstartdate>1971-01-23</obsstartdate>
28 
                        <obsenddate/>
29 
                    </locationevent>
30 
                </locationevent_id>
31 
                <taxondetermination>
32 
                    <role>identifier</role>
33 
                    <determinationdate>1971-01-23</determinationdate>
34 
                    <isoriginal>true</isoriginal>
35 
                    <iscurrent>true</iscurrent>
36 
                    <plantconcept_id>
37 
                        <plantconcept>
38 
                            <plantname_id>
39 
                                <plantname>
40 
                                    <rank>binomial</rank>
41 
                                    <plantname>Cephaelis elata Sw.</plantname>
42 
                                    <parent_id>
43 
                                        <plantname>
44 
                                            <rank>species</rank>
45 
                                            <plantname>elata</plantname>
46 
                                            <parent_id>
47 
                                                <plantname>
48 
                                                    <rank>genus</rank>
49 
                                                    <plantname>Cephaelis</plantname>
50 
                                                    <parent_id>
51 
                                                        <plantname>
52 
                                                            <rank>family</rank>
53 
                                                            <plantname>Rubiaceae</plantname>
54 
                                                            <parent_id>
55 
                                                                <plantname>
56 
                                                                    <rank>order</rank>
57 
                                                                    <plantname>Gentianales</plantname>
58 
                                                                    <parent_id>
59 
                                                                        <plantname>
60 
                                                                            <rank>kingdom</rank>
61 
                                                                            <plantname>Plantae</plantname>
62 
                                                                        </plantname>
63 
                                                                    </parent_id>
64 
                                                                </plantname>
65 
                                                            </parent_id>
66 
                                                        </plantname>
67 
                                                    </parent_id>
68 
                                                </plantname>
69 
                                            </parent_id>
70 
                                        </plantname>
71 
                                    </parent_id>
72 
                                </plantname>
73 
                            </plantname_id>
74 
                        </plantconcept>
75 
                    </plantconcept_id>
76 
                </taxondetermination>
77 
                <verbatimcollectorname>J. Freeland</verbatimcollectorname>
78 
            </taxonoccurrence>
79 
        </taxonoccurrence_id>
80 
        <collectioncode_dwc>ARIZ</collectioncode_dwc>
81 
        <description>Much branched shrub with long white thorns and pale yellow catkins.</description>
82 
        <datasource_id><party><organizationname>ARIZ</organizationname></party></datasource_id>
83 
        <catalognumber_dwc>104</catalognumber_dwc>
84 
        <sourceaccessioncode>Herbarium:ARIZ:dbsn104</sourceaccessioncode>
85 
        <collectionnumber>36</collectionnumber>
86 
    </specimenreplicate>
87 
    <specimenreplicate id="1">
88 
        <taxonoccurrence_id>
89 
            <taxonoccurrence>
90 
                <locationevent_id>
91 
                    <locationevent>
92 
                        <location_id>
93 
                            <location>
94 
                                <locationdetermination>
95 
                                    <namedplace_id>
96 
                                        <namedplace>
97 
                                            <rank>country</rank>
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff