Project

General

Profile

« Previous | Next » 

Revision 3909

schemas/vegbien.sql: Moved collectiondate from specimenreplicate to aggregateoccurrence because it's actually the SALVIAS census_date, which is the date the plant was sampled, rather than the DwC eventDate, which is the date the specimen was collected

View differences:

inputs/SALVIAS/test/import.organisms.xml.ref
38 38
                                            <2>$SourceVoucher</2>
39 39
                                        </_alt>
40 40
                                    </catalognumber_dwc>
41
                                    <collectiondate><_date><date>$census_date</date></_date></collectiondate>
42 41
                                    <description><_merge><1>$Notes</1></_merge></description>
43 42
                                </specimenreplicate>
44 43
                            </specimenreplicate_id>
......
54 53
                                            <2>$SourceVoucher</2>
55 54
                                        </_alt>
56 55
                                    </catalognumber_dwc>
57
                                    <collectiondate><_date><date>$census_date</date></_date></collectiondate>
58 56
                                    <description><_merge><1>$Notes</1></_merge></description>
59 57
                                </specimenreplicate>
60 58
                            </plantobservation>
......
62 60
                    </then>
63 61
                </_if>
64 62
                <aggregateoccurrence>
63
                    <collectiondate><_date><date>$census_date</date></_date></collectiondate>
65 64
                    <count>$NoInd</count>
66 65
                    <cover>$cover_percent</cover>
67 66
                    <definedvalue fkey="tablerecord_id">
inputs/SALVIAS/maps/VegBIEN.organisms.csv
7 7
DetType,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
8 8
coll_number,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
9 9
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
10
census_date,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate/_*/date,
11 10
Notes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,
12 11
coll_number,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/1,Brad: Incorrect. Map instead as for voucher_string
13 12
SourceVoucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
14
census_date,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate/_*/date,
15 13
Notes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,
14
census_date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,
16 15
NoInd,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,"Brad: Incorrect for VegX. This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
17 16
cover_percent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
18 17
census_no,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue","Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
schemas/vegbien.my.sql
163 163
    datasource_id int(11) NOT NULL,
164 164
    sourceaccessioncode text,
165 165
    taxonoccurrence_id int(11) NOT NULL,
166
    collectiondate timestamp NULL,
166 167
    cover double precision,
167 168
    basalarea double precision,
168 169
    biomass double precision,
......
2185 2186
    collectioncode_dwc text,
2186 2187
    catalognumber_dwc text,
2187 2188
    collectionnumber text,
2188
    collectiondate timestamp NULL,
2189 2189
    description text,
2190 2190
    specimen_id int(11)
2191 2191
)
schemas/vegbien.sql
384 384
    datasource_id integer NOT NULL,
385 385
    sourceaccessioncode text,
386 386
    taxonoccurrence_id integer NOT NULL,
387
    collectiondate timestamp with time zone,
387 388
    cover double precision,
388 389
    basalarea double precision,
389 390
    biomass double precision,
......
2682 2683
    collectioncode_dwc text,
2683 2684
    catalognumber_dwc text,
2684 2685
    collectionnumber text,
2685
    collectiondate timestamp with time zone,
2686 2686
    description text,
2687 2687
    specimen_id integer,
2688 2688
    CONSTRAINT specimenreplicate_required_key CHECK ((((plantobservation_id IS NOT NULL) OR (sourceaccessioncode IS NOT NULL)) OR (catalognumber_dwc IS NOT NULL)))
mappings/VegCSV-VegBIEN.specimens.csv
16 16
canopyForm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyForm]]:[@fkey=tablerecord_id]/definedvalue",,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_canopy_form,40
17 17
canopyPosition,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=canopyPosition]]:[@fkey=tablerecord_id]/definedvalue",,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.stem_canopy_position,41
18 18
carbon,/location/locationevent/soilobs/carbon,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_C,37
19
catalogNumber,/location/locationevent/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 19
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 20
catalogNumber,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 22
catalogNumber,/location/sourceaccessioncode/_alt/2/_merge/3,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
23 23
cationExchangeCapacity,/location/locationevent/soilobs/cationexchangecapacity,Expanded for clarity,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#exchangeCapacity, http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_cation_cap","13, 44"
24 24
censusNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",Expanded for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.census_no,3
25
class,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#class,144
26 25
class,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#class,144
27 26
clay,/location/locationevent/soilobs/clay,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilClay,10
28
collectionCode,/location/locationevent/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
27
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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,http://rs.tdwg.org/dwc/terms/#collectionCode,12
29 28
collectionCode,/location/sourceaccessioncode/_alt/2/_merge/2,,http://rs.tdwg.org/dwc/terms/#collectionCode,12
30
collectionID,/location/locationevent/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
29
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
31 30
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,Table shortened for standardization,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
32 31
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,Table shortened for standardization,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/communityDeterminations/communityDetermination/communityConcepts/communityConcept/name,0
33 32
computer.family,"/location/locationevent/taxonoccurrence/taxondetermination[role=computer]:[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",,"https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/schemas/vegbien.sql#role.computer, http://rs.tdwg.org/dwc/terms/#family","2, 146"
......
48 47
dataGeneralizations,,,http://rs.tdwg.org/dwc/terms/#dataGeneralizations,17
49 48
datasetID,,,http://rs.tdwg.org/dwc/terms/#datasetID,10
50 49
datasetName,,,http://rs.tdwg.org/dwc/terms/#datasetName,13
51
dateIdentified,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
50
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#dateIdentified,120
52 51
day,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#day,50
53 52
dcterms:accessRights,,,http://rs.tdwg.org/dwc/terms/#dcterms:accessRights,5
54 53
dcterms:bibliographicCitation,,,http://rs.tdwg.org/dwc/terms/#dcterms:bibliographicCitation,6
......
72 71
earliestEraOrLowestErathem,,,http://rs.tdwg.org/dwc/terms/#earliestEraOrLowestErathem,103
73 72
earliestPeriodOrLowestSystem,,,http://rs.tdwg.org/dwc/terms/#earliestPeriodOrLowestSystem,105
74 73
endDayOfYear,,,http://rs.tdwg.org/dwc/terms/#endDayOfYear,47
75
establishmentMeans,"/location/locationevent/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
76
establishmentMeans,"/location/locationevent/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
77
establishmentMeans,"/location/locationevent/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
74
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/growthform/_map:[./{tree,shrub,liana,vine,herb,hemiepiphyte,epiphyte,grass,forb,moss,lichen,fungus,""floating aquatic"",""submerged aquatic""}=*,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
75
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
76
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
78 77
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
79 78
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
80
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
81
eventDate,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
79
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
82 80
eventID,,,http://rs.tdwg.org/dwc/terms/#eventID,41
83 81
eventRemarks,,,http://rs.tdwg.org/dwc/terms/#eventRemarks,55
84 82
eventTime,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#eventTime,45
85
family,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#family,146
86 83
family,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#family,146
87
fieldNotes,/location/locationevent/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
88 84
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
89 85
fieldNotes,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
90
fieldNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
86
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
91 87
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
88
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
92 89
fieldNumber,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#fieldNumber,53
93 90
footprintSRS,,,http://rs.tdwg.org/dwc/terms/#footprintSRS,92
94 91
footprintSpatialFit,,,http://rs.tdwg.org/dwc/terms/#footprintSpatialFit,93
95 92
footprintWKT,/location/locationdetermination/footprintgeometry_dwc,,http://rs.tdwg.org/dwc/terms/#footprintWKT,91
96 93
formation,,,http://rs.tdwg.org/dwc/terms/#formation,115
97
genus,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#genus,147
98 94
genus,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#genus,147
99 95
geodeticDatum,,,http://rs.tdwg.org/dwc/terms/#geodeticDatum,87
100 96
geologicalContextID,,,http://rs.tdwg.org/dwc/terms/#geologicalContextID,100
......
121 117
identificationReferences,,,http://rs.tdwg.org/dwc/terms/#identificationReferences,121
122 118
identificationRemarks,,,http://rs.tdwg.org/dwc/terms/#identificationRemarks,123
123 119
identificationVerificationStatus,,,http://rs.tdwg.org/dwc/terms/#identificationVerificationStatus,122
124
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
125
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
126
identifiedBy,/location/locationevent/specimenreplicate/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
120
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/givenname/_namePart/first,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
121
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/middlename/_namePart/middle,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
122
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/surname/_namePart/last,,http://rs.tdwg.org/dwc/terms/#identifiedBy,119
127 123
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,,http://rs.tdwg.org/dwc/terms/#individualCount,25
128 124
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,,http://rs.tdwg.org/dwc/terms/#individualCount,25
129 125
individualCount,,,http://rs.tdwg.org/dwc/terms/#individualCount,25
130 126
individualID,,,http://rs.tdwg.org/dwc/terms/#individualID,24
131 127
informationWithheld,,,http://rs.tdwg.org/dwc/terms/#informationWithheld,16
132
infraspecificEpithet,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
133 128
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/*_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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
134
institutionCode,/location/locationevent/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
129
infraspecificEpithet,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#infraspecificEpithet,150
130
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
135 131
institutionCode,/location/sourceaccessioncode/_alt/2/_merge/1,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
136 132
institutionID,,,http://rs.tdwg.org/dwc/terms/#institutionID,8
137 133
island,,,http://rs.tdwg.org/dwc/terms/#island,62
138 134
islandGroup,,,http://rs.tdwg.org/dwc/terms/#islandGroup,61
139
kingdom,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#kingdom,142
140 135
kingdom,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#kingdom,142
141 136
landform,/location/landform,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/landform,18
142 137
latestAgeOrHighestStage,,,http://rs.tdwg.org/dwc/terms/#latestAgeOrHighestStage,110
......
187 182
nitrogen,/location/locationevent/soilobs/nitrogen,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/nitrogen,5
188 183
nomenclaturalCode,,,http://rs.tdwg.org/dwc/terms/#nomenclaturalCode,155
189 184
nomenclaturalStatus,,,http://rs.tdwg.org/dwc/terms/#nomenclaturalStatus,157
190
occurrenceID,/location/locationevent/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
191 185
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
186
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
192 187
occurrenceID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,"""{"" sorts it with other _if:[name=specimenreplicate_via]s",http://rs.tdwg.org/dwc/terms/#occurrenceID,19
193 188
occurrenceID,/location/sourceaccessioncode/_alt/1,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
194 189
occurrenceRemarks,,,http://rs.tdwg.org/dwc/terms/#occurrenceRemarks,21
195 190
occurrenceStatus,,,http://rs.tdwg.org/dwc/terms/#occurrenceStatus,31
196
order,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#order,145
197 191
order,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#order,145
198 192
organic,/location/locationevent/soilobs/organic,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilOrganic,6
199 193
originalNameUsage,,,http://rs.tdwg.org/dwc/terms/#originalNameUsage,137
......
210 204
parentPlotName,/location/sourceaccessioncode/_merge/1/_alt/2,,"http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#PARENT_ID, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName","3, 1"
211 205
ph,/location/locationevent/soilobs/ph,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/ph,6
212 206
phosphorus,/location/locationevent/soilobs/phosphorus,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/abioticObservations/abioticObservation/phosphorus,2
213
phylum,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#phylum,143
214 207
phylum,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#phylum,143
215 208
plotArea,/location/area,Table added for clarity,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/area,11
216 209
plotEventEndDate,/location/locationevent/obsenddate,Table added for uniqueness,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot, http://rs.tdwg.org/dwc/terms/#eventDate, http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=observation&entity=dba_tabledescription&where=where_tablename#obsEndDate",", 44, 6"
......
228 221
previousTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,Number replaced with named prefix for clarity,http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.tag1,8
229 222
projectID,/location/locationevent/*_id/project/sourceaccessioncode,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://rs.tdwg.org/dwc/terms/#occurrenceID",", 0"
230 223
projectName,/location/locationevent/*_id/project/projectname,,"http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/projects/project, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/plotName",", 1"
231
recordNumber,/location/locationevent/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
232
recordedBy,/location/locationevent/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
224
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
225
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
233 226
recordedBy.givenName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/first,,"http://rs.tdwg.org/dwc/terms/#recordedBy, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/givenName","23, 01"
234 227
recordedBy.surName,/location/locationevent/taxonoccurrence/verbatimcollectorname/_name/last,,"http://rs.tdwg.org/dwc/terms/#recordedBy, http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/surName","23, 02"
235 228
relatedResourceID,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#relatedResourceID,161
......
246 239
samplingProtocol,/location/locationevent/*_id/method/name,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
247 240
samplingProtocol,,,http://rs.tdwg.org/dwc/terms/#samplingProtocol,42
248 241
sand,/location/locationevent/soilobs/sand,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSand,8
249
scientificName,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
250 242
scientificName,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/3,,http://rs.tdwg.org/dwc/terms/#scientificName,134
243
scientificName,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#scientificName,134
251 244
scientificName,"/location/locationevent/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/_name/first",,http://rs.tdwg.org/dwc/terms/#scientificName,134
252
scientificNameAuthorship,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
253 245
scientificNameAuthorship,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#scientificNameAuthorship,153
254 246
scientificNameID,,,http://rs.tdwg.org/dwc/terms/#scientificNameID,127
255
sex,"/location/locationevent/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/#sex,26
247
sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/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",http://rs.tdwg.org/dwc/terms/#sex,26
256 248
silt,/location/locationevent/soilobs/silt,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilSilt,9
257 249
slopeAspect,/location/slopeaspect/_compass/value,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeAspect,15
258 250
slopeGradient,/location/slopegradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16
259 251
sodium,/location/locationevent/soilobs/sodium,Expanded for clarity,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#soil_Na,41
260
specificEpithet,"/location/locationevent/specimenreplicate/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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
261 252
specificEpithet,"/location/locationevent/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",,http://rs.tdwg.org/dwc/terms/#specificEpithet,149
262 253
startDayOfYear,,,http://rs.tdwg.org/dwc/terms/#startDayOfYear,46
263 254
stateProvince,"/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",,http://rs.tdwg.org/dwc/terms/#stateProvince,65
......
267 258
taxonConceptID,,,http://rs.tdwg.org/dwc/terms/#taxonConceptID,133
268 259
taxonID,,,http://rs.tdwg.org/dwc/terms/#taxonID,126
269 260
taxonRank,,,http://rs.tdwg.org/dwc/terms/#taxonRank,151
270
taxonRemarks,/location/locationevent/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
261
taxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description/_merge/2,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
271 262
taxonomicStatus,,,http://rs.tdwg.org/dwc/terms/#taxonomicStatus,156
272 263
temperature,/location/locationevent/temperature,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plotObservations/plotObservation/observationConditions/temperature,1900
273 264
texture,/location/locationevent/soilobs/texture,,http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#soilTexture,7
mappings/for_review/VegX-VegBIEN.stems.csv
47 47
/*s/plot/plotUniqueIdentifier,//locationevent/sourceaccessioncode,
48 48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",//locationevent/taxonoccurrence,
49 49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc,
50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectiondate,
51 50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,//locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/description,
52 51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,
53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectiondate,
54 52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,//locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,
53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,//aggregateoccurrence/collectiondate,
55 54
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,//aggregateoccurrence/count,
56 55
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,//aggregateoccurrence/cover,
57 56
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"//aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]/definedvalue",
mappings/VegX-VegBIEN.stems.csv
47 47
/*s/plot/plotUniqueIdentifier,/location/locationevent/sourceaccessioncode,
48 48
"/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=collector]/groupType",/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/cond/_eq:[right=direct]/left,
49 49
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/catalognumber_dwc,
50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/collectiondate,
51 50
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/else/voucher/*_id/specimenreplicate/description/_merge/1,
52 51
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/voucher,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/catalognumber_dwc,
53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/collectiondate,
54 52
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept/note/text,/location/locationevent/taxonoccurrence/_if:[name=specimenreplicate_via]/then/aggregateoccurrence:[@merge=1]/plantobservation:[@merge=1]/specimenreplicate/description/_merge/1,
53
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=collectionDate]/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate,
55 54
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/*ID->/*s/individualOrganism/*ID->/*s/taxonNameUsageConcept->/*s/aggregateOrganismObservation[*ID]/*/aggregateValue/value,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
56 55
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/volumeCanopy/*ID->/*s/attribute/ordinal/coverPercent,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover,
57 56
/*s/plot->/*s/plotObservation[*UniqueIdentifierID]->/*s/individualOrganismObservation[*ID]/simpleUserdefined[name=censusNo]/value,"/location/locationevent/taxonoccurrence/aggregateoccurrence/definedvalue[*_id/userdefined[tablename=aggregateoccurrence,userdefinedname=censusNo]]:[@fkey=tablerecord_id]/definedvalue",

Also available in: Unified diff