Project

General

Profile

« Previous | Next » 

Revision 4183

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs: Regenerated maps for changes to bin/union, which removes empty mappings. Added /_alt suffix where needed.

View differences:

inputs/MO/specimens/VegBIEN.csv
24 24 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",
25 25 
IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
26 26 
convertednotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
27 28 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
28 29 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
29 30 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
inputs/NY/specimens/map.full.csv
52 52 
YearIdentified,YearIdentified
53 53 
UniqueNYInternalRecordNumber,occurrenceID,
54 54 
FieldNumber,recordNumber,Usage inconsistent with DwC definition
55 
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
inputs/NY/specimens/VegBIEN.csv
71 71 
RelationshipType,,** No join mapping for RelationshipType **
72 72 
TimeOfDay,,** No join mapping for TimeOfDay **
73 73 
TypeStatus,,** No join mapping for TypeStatus **
74 
key,,Not used because UniqueNYInternalRecordNumber is a better pkey
inputs/Madidi/0.plots/map.full.csv
35 35 
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,
36 36 
Textural class,texture,
37 37 
Altitude,verbatimElevation,
38 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
39 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
40 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 
Inventory number,,Not globally unique
42 
Number of inventory (expedition),,The number of the event within the project
43 
Number of stems,,Do we want to store this data?
44 
Number of trees,,Do we want to store this data?
45 
Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
46 
Soil sample,,Always empty
inputs/Madidi/0.plots/VegBIEN.csv
37 37 
Orientación/exposicion,/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or Orientación
38 38 
Slope,/location/slopegradient,
39 39 
Inventory code,/location/sourceaccessioncode,
40 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
42 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
43 
Inventory number,,Not globally unique
44 
Number of inventory (expedition),,The number of the event within the project
45 
Number of stems,,Do we want to store this data?
46 
Number of trees,,Do we want to store this data?
47 
Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
48 
Soil sample,,Always empty
inputs/Madidi/1.organisms/map.full.csv
1 1 
Madidi,Veg+,Comments
2 
Autor (revised),,
3 
Basal area,,
4 
Bole height,,
5 
Circumference,,
6 
Common name,,
7 
Crown position,,
8 
Crown shape,,
9 
Determined by,,
10 
Diameter,,
11 
Expedition,,
12 
Expedition specimen,,
13 
Family (revised),,
14 
Field family,,
15 
Field name,,
16 
Genera,,
17 
Habit,,
18 
Index collector,,
19 
Inventory code,,
20 
Inventory name,,
21 
Liana presence,,
22 
Number of inventory (expedition),,
23 
Number of inventory (general),,
24 
Number of subplot,,
25 
Observations,,
26 
Phenology,,
27 
Plot X,,
28 
Plot Y,,
29 
Plot specimen,,
30 
Project specimen,,
31 
Qualifier,,
32 
Similar specimen,,
33 
Specie+autor,,
34 
Species and morphotypes,,
35 
Specific epithet,,
36 
Specimen,,
37 
Subplot X,,
38 
Subplot Y,,
39 
Tag number,,
40 
Total height,,
41 
Tree number,,
42 
Trunk,,
43 
"Type Inventory (C, PP, TP)",,
inputs/Madidi/1.organisms/VegBIEN.csv
1 1 
Madidi,VegBIEN:,Comments
2 
Autor (revised),,** No input mapping for Autor (revised) **
3 
Basal area,,** No input mapping for Basal area **
4 
Bole height,,** No input mapping for Bole height **
5 
Circumference,,** No input mapping for Circumference **
6 
Common name,,** No input mapping for Common name **
7 
Crown position,,** No input mapping for Crown position **
8 
Crown shape,,** No input mapping for Crown shape **
9 
Determined by,,** No input mapping for Determined by **
10 
Diameter,,** No input mapping for Diameter **
11 
Expedition,,** No input mapping for Expedition **
12 
Expedition specimen,,** No input mapping for Expedition specimen **
13 
Family (revised),,** No input mapping for Family (revised) **
14 
Field family,,** No input mapping for Field family **
15 
Field name,,** No input mapping for Field name **
16 
Genera,,** No input mapping for Genera **
17 
Habit,,** No input mapping for Habit **
18 
Index collector,,** No input mapping for Index collector **
19 
Inventory code,,** No input mapping for Inventory code **
20 
Inventory name,,** No input mapping for Inventory name **
21 
Liana presence,,** No input mapping for Liana presence **
22 
Number of inventory (expedition),,** No input mapping for Number of inventory (expedition) **
23 
Number of inventory (general),,** No input mapping for Number of inventory (general) **
24 
Number of subplot,,** No input mapping for Number of subplot **
25 
Observations,,** No input mapping for Observations **
26 
Phenology,,** No input mapping for Phenology **
27 
Plot X,,** No input mapping for Plot X **
28 
Plot Y,,** No input mapping for Plot Y **
29 
Plot specimen,,** No input mapping for Plot specimen **
30 
Project specimen,,** No input mapping for Project specimen **
31 
Qualifier,,** No input mapping for Qualifier **
32 
Similar specimen,,** No input mapping for Similar specimen **
33 
Specie+autor,,** No input mapping for Specie+autor **
34 
Species and morphotypes,,** No input mapping for Species and morphotypes **
35 
Specific epithet,,** No input mapping for Specific epithet **
36 
Specimen,,** No input mapping for Specimen **
37 
Subplot X,,** No input mapping for Subplot X **
38 
Subplot Y,,** No input mapping for Subplot Y **
39 
Tag number,,** No input mapping for Tag number **
40 
Total height,,** No input mapping for Total height **
41 
Tree number,,** No input mapping for Tree number **
42 
Trunk,,** No input mapping for Trunk **
43 
"Type Inventory (C, PP, TP)",,"** No input mapping for Type Inventory (C, PP, TP) ** "
inputs/UNCC/specimens/map.full.csv
35 35 
usdaRank,taxonRank/_alt/1,
36 36 
infrarank,taxonRank/_alt/2,
37 37 
collyear,yearCollected,
38 
filler,,"Where used, same as family"
inputs/UNCC/specimens/VegBIEN.csv
39 39 
collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/4,
40 40 
locality,/location/locationnarrative/_merge/1,
41 41 
habitat,"/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?"
42 
filler,,"Where used, same as family"
43 42 
flower,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
44 43 
fruit,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
45 44 
infrarank,,** No join mapping for taxonRank/_alt/2 **
inputs/CVS/1.organisms/map.full.csv
10 10 
obsStartDate,plotEventStartDate,
11 11 
currentTaxonName sec Weakley 2006,scientificName,
12 12 
state,stateProvince,
13 
confidentialityStatus,,
inputs/CVS/1.organisms/VegBIEN.csv
12 12 
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
13 13 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2,
14 14 
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
15 
confidentialityStatus,,** No input mapping for confidentialityStatus **
inputs/SALVIAS-CSV/0.plots/map.full.csv
39 39 
temp_c,temperature,
40 40 
soil_texture,texture,
41 41 
elev_m,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
42 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
43 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/0.plots/VegBIEN.csv
42 42 
slope_aspect,/location/slopeaspect/_compass/value,
43 43 
slope_gradient,/location/slopegradient,
44 44 
PLOT_ID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
46 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/REMIB/specimens/map.full.csv
16 16 
lat_deg,verbatimLatitude,
17 17 
long_deg,verbatimLongitude,
18 18 
coll_year,yearCollected,
19 
lat_min,,
20 
lat_sec,,
21 
long_min,,
22 
long_sec,,
inputs/REMIB/specimens/VegBIEN.csv
23 23 
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
24 24 
locality,/location/locationnarrative/_merge/1,
25 25 
habitat,"/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?"
26 
lat_min,,** No input mapping for lat_min **
27 
lat_sec,,** No input mapping for lat_sec **
28 
long_min,,** No input mapping for long_min **
29 
long_sec,,** No input mapping for long_sec **
30 26 
preparation,,** No join mapping for preparation **
inputs/SALVIAS/0.plots/map.full.csv
39 39 
Temp,temperature,
40 40 
soil_texture,"texture/_units:[default=""%"",to=]/value",
41 41 
Elev,verbatimElevation,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
42 
AccessCode,,
43 
ElevSource,,
44 
Habitat,,
45 
MethodCode,,
46 
PrecipSource,,
47 
PrimOwnerID,,
48 
RevisionComments,,
49 
SiteName,,
50 
TempSource,,
51 
bearing,,
52 
lat_long_accuracy,,
53 
lat_string,,
54 
long_string,,
55 
new_world,,
56 
orig_filename,,
57 
plot_administrator,,
58 
plot_notes,,
59 
pol1_type,,
60 
pol2_type,,
61 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
62 
tmp_del,,
63 
topography_desc,,
64 
vegetation_1,,
65 
vegetation_2,,
inputs/SALVIAS/0.plots/VegBIEN.csv
42 42 
slope_aspect,/location/slopeaspect/_compass/value,
43 43 
slope_gradient,/location/slopegradient,
44 44 
PlotID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 
AccessCode,,** No input mapping for AccessCode **
46 
ElevSource,,** No input mapping for ElevSource **
47 
Habitat,,** No input mapping for Habitat **
48 
MethodCode,,** No input mapping for MethodCode **
49 
PrecipSource,,** No input mapping for PrecipSource **
50 
PrimOwnerID,,** No input mapping for PrimOwnerID **
51 
RevisionComments,,** No input mapping for RevisionComments **
52 
SiteName,,** No input mapping for SiteName **
53 
TempSource,,** No input mapping for TempSource **
54 
bearing,,** No input mapping for bearing **
55 
lat_long_accuracy,,** No input mapping for lat_long_accuracy **
56 
lat_string,,** No input mapping for lat_string **
57 
long_string,,** No input mapping for long_string **
58 
new_world,,** No input mapping for new_world **
59 
orig_filename,,** No input mapping for orig_filename **
60 
plot_administrator,,** No input mapping for plot_administrator **
61 
plot_notes,,** No input mapping for plot_notes **
62 
pol1_type,,** No input mapping for pol1_type **
63 
pol2_type,,** No input mapping for pol2_type **
64 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
65 
tmp_del,,** No input mapping for tmp_del **
66 
topography_desc,,** No input mapping for topography_desc **
67 
vegetation_1,,** No input mapping for vegetation_1 **
68 
vegetation_2,,** No input mapping for vegetation_2 **
inputs/U/specimens/map.full.csv
21 21 
Locnotes,VerbatimLocality/_merge/2,
22 22 
Collyy,YearCollected,
23 23 
Detyy,YearIdentified,
24 
Alt,,What is this?
25 
Alt2,,What is this?
26 
Coorsyst,,
27 
DateInfo,,Not used
28 
EW,,
29 
Majorarea,,
30 
NS,,
31 
Prefix,,Not used
32 
Suffix,,Not used
inputs/U/specimens/VegBIEN.csv
32 32 
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row
33 33 
Locnotes,/location/locationnarrative/_merge/2/_merge/2,
34 34 
Ecology,"/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?"
35 
Alt,,What is this?
36 
Alt2,,What is this?
37 
Coorsyst,,** No input mapping for Coorsyst **
38 
DateInfo,,Not used
39 
EW,,** No input mapping for EW **
40 
Majorarea,,** No input mapping for Majorarea **
41 
NS,,** No input mapping for NS **
42 35 
Phenology,,** No join mapping for ReproductiveCondition **
43 
Prefix,,Not used
44 
Suffix,,Not used
inputs/ARIZ/specimens/map.csv
1 1 
ARIZ[Veg+],Veg+,Comments
2 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
3 
CatalogNumberNumeric,CatalogNumber,
2 
CatalogNumber,CatalogNumber/_alt/2,Don't overwrite CatalogNumberNumeric
3 
CatalogNumberNumeric,CatalogNumber/_alt/1,
4 4 
FieldNumber,recordNumber,Usage inconsistent with DwC definition
5 5 
TimeCollected,TimeOfDay,
6 6 
VerbatimCollectingDate,dateCollected/_alt/0,
inputs/ARIZ/specimens/map.full.csv
1 1 
ARIZ[Veg+],Veg+,Comments
2 2 
BasisOfRecord,BasisOfRecord
3 3 
BoundingBox,BoundingBox
4 
CatalogNumberNumeric,CatalogNumber,
4 
CatalogNumberNumeric,CatalogNumber/_alt/1,
5 
CatalogNumber,CatalogNumber/_alt/2,Don't overwrite CatalogNumberNumeric
5 6 
Class,Class
6 7 
CollectionCode,CollectionCode
7 8 
Collector,Collector
......
62 63 
AgeClass,lifeStage,
63 64 
FieldNumber,recordNumber,Usage inconsistent with DwC definition
64 65 
OriginalCoordinateSystem,verbatimSRS,
65 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
66 
HorizontalDatum,,Not used
67 
Tissues,,Not used
inputs/ARIZ/specimens/VegBIEN.csv
2 2 
GlobalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 3 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 4 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
CatalogNumberNumeric,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 
CatalogNumberNumeric,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",
6 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric
6 7 
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7 8 
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
8 9 
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
36 37 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
37 38 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,Usage inconsistent with DwC definition
38 39 
Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,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"
39 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
40 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/1",
41 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else/_alt/2",Don't overwrite CatalogNumberNumeric
40 42 
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
41 43 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
42 44 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
......
63 65 
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes,
64 66 
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit,
65 67 
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
66 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",
69 
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2",Don't overwrite CatalogNumberNumeric
67 70 
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
68 71 
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
69 72 
Locality,/location/locationnarrative/_merge/1,
70 73 
AgeClass,,** No join mapping for lifeStage **
71 74 
BasisOfRecord,,** No join mapping for BasisOfRecord **
72 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
73 75 
DateLastModified,,** No join mapping for DateLastModified **
74 76 
GenBankNum,,"** No join mapping for associatedSequences/_label[label=""GenBank""]/value ** "
75 77 
GeorefMethod,,** No join mapping for georeferenceProtocol **
76 78 
HigherGeography,,** No join mapping for HigherGeography **
77 
HorizontalDatum,,Not used
78 79 
Island,,** No join mapping for Island **
79 80 
IslandGroup,,** No join mapping for IslandGroup **
80 81 
JulianDay,,** No join mapping for JulianDay **
......
84 85 
Preparations,,** No join mapping for Preparations **
85 86 
RelatedCatalogedItems,,** No join mapping for RelatedCatalogItem/_alt/2 ** Used only when OtherCatalogNumbers is NULL
86 87 
TimeCollected,,** No join mapping for TimeOfDay **
87 
Tissues,,Not used
88 88 
TypeStatus,,** No join mapping for TypeStatus **
89 89 
VerbatimDepth,,** No join mapping for VerbatimDepth **
inputs/ARIZ/specimens/test.xml.ref
8 8 
                    <_merge>
9 9 
                        <1>$InstitutionCode</1>
10 10 
                        <2>$CollectionCode</2>
11 
                        <3>$CatalogNumberNumeric</3>
11 
                        <3>
12 
                            <_alt>
13 
                                <1>$CatalogNumberNumeric</1>
14 
                                <2>$CatalogNumber</2>
15 
                            </_alt>
16 
                        </3>
12 17 
                    </_merge>
13 18 
                </4>
14 19 
            </_alt>
......
307 312 
                            <definedvalue>$Sex</definedvalue>
308 313 
                        </definedvalue>
309 314 
                        <specimenreplicate>
310 
                            <catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc>
315 
                            <catalognumber_dwc>
316 
                                <_alt>
317 
                                    <1>$CatalogNumberNumeric</1>
318 
                                    <2>$CatalogNumber</2>
319 
                                </_alt>
320 
                            </catalognumber_dwc>
311 321 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
312 322 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
313 323 
                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
inputs/NCU-NCSC/specimens/map.full.csv
14 14 
Cultivated?,"establishmentMeans/_map:[Yes=cultivated,No=wild]/value",
15 15 
Accession Number,occurrenceID,
16 16 
Typology,typeStatus,
17 
Alt E/W,,
18 
Alt N/S,,
19 
FIPS,,FIPS county code
inputs/NCU-NCSC/specimens/VegBIEN.csv
20 20 
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value",
21 21 
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=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",
22 22 
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
23 
Alt E/W,,** No input mapping for Alt E/W **
24 
Alt N/S,,** No input mapping for Alt N/S **
25 
FIPS,,FIPS county code
26 23 
Format,,** No join mapping for PreparationType **
27 24 
Typology,,** No join mapping for typeStatus **
inputs/MO/specimens/map.full.csv
28 28 
latitude,latitude
29 29 
longitude,longitude
30 30 
convertednotes,notes,
31 
notes,notes
31 32 
species,species
inputs/MO/specimens/test.xml.ref
235 235 
                        </_date>
236 236 
                    </collectiondate>
237 237 
                    <count>$IndividualCount</count>
238 
                    <notes>$convertednotes</notes>
238 
                    <notes>
239 
                        <_alt>
240 
                            <0>$convertednotes</0>
241 
                            <1>$notes</1>
242 
                        </_alt>
243 
                    </notes>
239 244 
                    <plantobservation>
240 245 
                        <collectionnumber>$CollectorNumber</collectionnumber>
241 246 
                        <specimenreplicate>

Also available in: Unified diff