Project

General

Profile

« Previous | Next » 

Revision 3914

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: Moved sex user-defined mapping to plantobservation because it's a property of the plant rather than the specimen, and so that it can also apply to plots data

View differences:

inputs/XAL/test/import.specimens.xml.ref
211 211 
                <aggregateoccurrence>
212 212 
                    <notes>$Notes</notes>
213 213 
                    <plantobservation>
214 
                        <definedvalue fkey="tablerecord_id">
215 
                            <userdefined_id>
216 
                                <userdefined>
217 
                                    <tablename>plantobservation</tablename>
218 
                                    <userdefinedname>sex</userdefinedname>
219 
                                </userdefined>
220 
                            </userdefined_id>
221 
                            <definedvalue>$Sex</definedvalue>
222 
                        </definedvalue>
214 223 
                        <specimenreplicate>
215 224 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
216 225 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
......
220 229 
                                    <3>$FieldNumber</3>
221 230 
                                </_alt>
222 231 
                            </collectionnumber>
223 
                            <definedvalue fkey="tablerecord_id">
224 
                                <userdefined_id>
225 
                                    <userdefined>
226 
                                        <tablename>specimenreplicate</tablename>
227 
                                        <userdefinedname>sex</userdefinedname>
228 
                                    </userdefined>
229 
                                </userdefined_id>
230 
                                <definedvalue>$Sex</definedvalue>
231 
                            </definedvalue>
232 232 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
233 233 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
234 234 
                        </specimenreplicate>
inputs/XAL/maps/VegBIEN.specimens.csv
18 18 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
19 19 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
20 20 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
21 
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",http://rs.tdwg.org/dwc/terms/#sex,26
21 22 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 23 
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
23 24 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
24 25 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
25 
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
26 26 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
27 27 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
28 28 
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayIdentified; http://rs.tdwg.org/dwc/terms/#dateIdentified,55; 120
inputs/NY/test/import.specimens.xml.ref
237 237 
                        </_merge>
238 238 
                    </notes>
239 239 
                    <plantobservation>
240 
                        <definedvalue fkey="tablerecord_id">
241 
                            <userdefined_id>
242 
                                <userdefined>
243 
                                    <tablename>plantobservation</tablename>
244 
                                    <userdefinedname>sex</userdefinedname>
245 
                                </userdefined>
246 
                            </userdefined_id>
247 
                            <definedvalue>$Sex</definedvalue>
248 
                        </definedvalue>
240 249 
                        <specimenreplicate>
241 250 
                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
242 251 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
......
246 255 
                                    <3>$FieldNumber</3>
247 256 
                                </_alt>
248 257 
                            </collectionnumber>
249 
                            <definedvalue fkey="tablerecord_id">
250 
                                <userdefined_id>
251 
                                    <userdefined>
252 
                                        <tablename>specimenreplicate</tablename>
253 
                                        <userdefinedname>sex</userdefinedname>
254 
                                    </userdefined>
255 
                                </userdefined_id>
256 
                                <definedvalue>$Sex</definedvalue>
257 
                            </definedvalue>
258 258 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
259 259 
                            <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
260 260 
                            <verbatimcollectorname>$Collector</verbatimcollectorname>
inputs/NY/maps/VegBIEN.specimens.csv
20 20 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
21 21 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
22 22 
PlantFungusDescription,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2/_label[label=""plant fungus""]/value",,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
23 
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",http://rs.tdwg.org/dwc/terms/#sex,26
23 24 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
24 25 
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
25 26 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
26 27 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
27 
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
28 28 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
29 29 
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
30 30 
Collector,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Collector; http://rs.tdwg.org/dwc/terms/#recordedBy,6; 23
inputs/ARIZ/test/import.specimens.xml.ref
224 224 
                <aggregateoccurrence>
225 225 
                    <notes>$FieldNotes</notes>
226 226 
                    <plantobservation>
227 
                        <definedvalue fkey="tablerecord_id">
228 
                            <userdefined_id>
229 
                                <userdefined>
230 
                                    <tablename>plantobservation</tablename>
231 
                                    <userdefinedname>sex</userdefinedname>
232 
                                </userdefined>
233 
                            </userdefined_id>
234 
                            <definedvalue>$Sex</definedvalue>
235 
                        </definedvalue>
227 236 
                        <specimenreplicate>
228 237 
                            <catalognumber_dwc>$CatalogNumberNumeric</catalognumber_dwc>
229 238 
                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
......
233 242 
                                    <3>$FieldNumber</3>
234 243 
                                </_alt>
235 244 
                            </collectionnumber>
236 
                            <definedvalue fkey="tablerecord_id">
237 
                                <userdefined_id>
238 
                                    <userdefined>
239 
                                        <tablename>specimenreplicate</tablename>
240 
                                        <userdefinedname>sex</userdefinedname>
241 
                                    </userdefined>
242 
                                </userdefined_id>
243 
                                <definedvalue>$Sex</definedvalue>
244 
                            </definedvalue>
245 245 
                            <description>$Remarks</description>
246 246 
                            <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
247 247 
                            <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
inputs/ARIZ/maps/VegBIEN.specimens.csv
23 23 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
24 24 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
25 25 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
26 
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",http://rs.tdwg.org/dwc/terms/#sex,26
26 27 
CatalogNumberNumeric,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
27 28 
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
28 29 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
29 30 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
30 
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
31 31 
Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
32 32 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
33 33 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/tdwg_dw_core.xsd#/GlobalUniqueIdentifier; http://rs.tdwg.org/dwc/terms/#occurrenceID,0; 19
inputs/SpeciesLink/test/import.specimens.xml.ref
291 291 
                <aggregateoccurrence>
292 292 
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
293 293 
                    <plantobservation>
294 
                        <definedvalue fkey="tablerecord_id">
295 
                            <userdefined_id>
296 
                                <userdefined>
297 
                                    <tablename>plantobservation</tablename>
298 
                                    <userdefinedname>sex</userdefinedname>
299 
                                </userdefined>
300 
                            </userdefined_id>
301 
                            <definedvalue>
302 
                                <_alt>
303 
                                    <0>$dwc_dwcore_Sex</0>
304 
                                    <1>$conceptual_darwin_2003_1_0_Sex</1>
305 
                                    <2>$dwc_terms_sex</2>
306 
                                </_alt>
307 
                            </definedvalue>
308 
                        </definedvalue>
294 309 
                        <specimenreplicate>
295 310 
                            <catalognumber_dwc>
296 311 
                                <_alt>
......
329 344 
                                    </3>
330 345 
                                </_alt>
331 346 
                            </collectionnumber>
332 
                            <definedvalue fkey="tablerecord_id">
333 
                                <userdefined_id>
334 
                                    <userdefined>
335 
                                        <tablename>specimenreplicate</tablename>
336 
                                        <userdefinedname>sex</userdefinedname>
337 
                                    </userdefined>
338 
                                </userdefined_id>
339 
                                <definedvalue>
340 
                                    <_alt>
341 
                                        <0>$dwc_dwcore_Sex</0>
342 
                                        <1>$conceptual_darwin_2003_1_0_Sex</1>
343 
                                        <2>$dwc_terms_sex</2>
344 
                                    </_alt>
345 
                                </definedvalue>
346 
                            </definedvalue>
347 347 
                            <description>$dwc_dwcore_Remarks</description>
348 348 
                            <institution_id>
349 349 
                                <party>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
43 43 
MonthCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/MonthCollected; http://rs.tdwg.org/dwc/terms/#eventDate,10; 44
44 44 
YearCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/YearCollected; http://rs.tdwg.org/dwc/terms/#eventDate,9; 44
45 45 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
46 
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",http://rs.tdwg.org/dwc/terms/#sex,26
47 
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",http://rs.tdwg.org/dwc/terms/#sex,26
46 48 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
47 49 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
48 50 
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
......
52 54 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
53 55 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
54 56 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
55 
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
56 
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
57 57 
Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
58 58 
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
59 59 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
inputs/QMOR/test/import.specimens.xml.ref
149 149 
            <taxonoccurrence>
150 150 
                <aggregateoccurrence>
151 151 
                    <plantobservation>
152 
                        <definedvalue fkey="tablerecord_id">
153 
                            <userdefined_id>
154 
                                <userdefined>
155 
                                    <tablename>plantobservation</tablename>
156 
                                    <userdefinedname>sex</userdefinedname>
157 
                                </userdefined>
158 
                            </userdefined_id>
159 
                            <definedvalue>$sex</definedvalue>
160 
                        </definedvalue>
152 161 
                        <specimenreplicate>
153 162 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
154 163 
                            <collectioncode_dwc>$collectionCode</collectioncode_dwc>
155 164 
                            <collectionnumber><_alt><2>$collectionID</2></_alt></collectionnumber>
156 
                            <definedvalue fkey="tablerecord_id">
157 
                                <userdefined_id>
158 
                                    <userdefined>
159 
                                        <tablename>specimenreplicate</tablename>
160 
                                        <userdefinedname>sex</userdefinedname>
161 
                                    </userdefined>
162 
                                </userdefined_id>
163 
                                <definedvalue>$sex</definedvalue>
164 
                            </definedvalue>
165 165 
                            <institution_id><party><organizationname>$institutionCode</organizationname></party></institution_id>
166 166 
                            <sourceaccessioncode>$id</sourceaccessioncode>
167 167 
                            <verbatimcollectorname>$recordedBy</verbatimcollectorname>
inputs/QMOR/maps/VegBIEN.specimens.csv
16 16 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",,http://rs.tdwg.org/dwc/terms/#continent,59
17 17 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 18 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 
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",http://rs.tdwg.org/dwc/terms/#sex,26
19 20 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
20 21 
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
21 22 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
22 
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
23 23 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
24 24 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,"ACAD#id, MT#id, QMOR#id, U#ID; http://rs.tdwg.org/dwc/terms/#occurrenceID",19
25 25 
recordedBy,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/verbatimcollectorname,,http://rs.tdwg.org/dwc/terms/#recordedBy,23
mappings/VegCSV-VegBIEN.specimens.csv
242 242 
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
243 243 
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
244 244 
scientificNameID,,,http://rs.tdwg.org/dwc/terms/#scientificNameID,127
245 
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
245 
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",http://rs.tdwg.org/dwc/terms/#sex,26
246 246 
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
247 247 
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
248 248 
slopeGradient,/location/slopegradient,,http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/plots/plot/slopeGradient,16
mappings/DwC2-VegBIEN.specimens.csv
18 18 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 19 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 20 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 
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",http://rs.tdwg.org/dwc/terms/#sex,26
21 22 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 23 
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
23 24 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
24 25 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
25 26 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
26 
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
27 27 
taxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
28 28 
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
29 29 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
mappings/for_review/DwC2-VegBIEN.specimens.csv
18 18 
eventDate,//locationevent/obsenddate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 19 
eventDate,//locationevent/obsstartdate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 20 
fieldNotes,//aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 
sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/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
21 22 
catalogNumber,//specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 23 
collectionCode,//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
23 24 
recordNumber,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
24 25 
collectionID,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#collectionID,9
25 26 
fieldNumber,//specimenreplicate/collectionnumber,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
26 
sex,"//specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]/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
27 27 
taxonRemarks,//specimenreplicate/description,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
28 28 
establishmentMeans,//specimenreplicate/growthform,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
29 29 
institutionCode,//party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
mappings/for_review/VegBIEN-DwC2.specimens.csv
18 18 
//locationevent/obsenddate/_*/date,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 19 
//locationevent/obsstartdate/_*/date,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 20 
//aggregateoccurrence/notes,fieldNotes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 
"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/definedvalue",sex,"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
21 22 
//specimenreplicate/catalognumber_dwc,catalogNumber,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
22 23 
//specimenreplicate/collectioncode_dwc,collectionCode,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
23 24 
//specimenreplicate/collectionnumber,recordNumber,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
24 25 
//specimenreplicate/collectionnumber,collectionID,,http://rs.tdwg.org/dwc/terms/#collectionID,9
25 26 
//specimenreplicate/collectionnumber,fieldNumber,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
26 
"//specimenreplicate/definedvalue[*_id/userdefined[tablename=specimenreplicate,userdefinedname=sex]]/definedvalue",sex,"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
27 27 
//specimenreplicate/description,taxonRemarks,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
28 28 
//specimenreplicate/growthform,establishmentMeans,,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
29 29 
//party/organizationname,institutionCode,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
mappings/DwC-VegBIEN.specimens.csv
79 79 
Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
80 80 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
81 81 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
82 
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",http://rs.tdwg.org/dwc/terms/#sex,26
83 
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",http://rs.tdwg.org/dwc/terms/#sex,26
82 84 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
83 85 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
84 86 
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
......
91 93 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
92 94 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
93 95 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
94 
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
95 
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
96 96 
Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
97 97 
TaxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
98 98 
remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
mappings/DwC.cs-VegBIEN.specimens.csv
39 39 
collectedDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/3,,http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=bien2_staging&table=nybg_raw&target=tbl_structure.php#CollectedDate; http://rs.tdwg.org/dwc/terms/#eventDate,29; 44
40 40 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
41 41 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://digir.net/schema/conceptual/darwin/2003/1.0/darwin2.xsd#/Notes; http://rs.tdwg.org/dwc/terms/#fieldNotes,47; 54
42 
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",http://rs.tdwg.org/dwc/terms/#sex,26
42 43 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
43 44 
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
44 45 
collectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/1,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/CollectorNumber; http://rs.tdwg.org/dwc/terms/#recordNumber,7; 22
45 46 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
46 47 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/2,,http://rs.tdwg.org/dwc/terms/#collectionID,9
47 48 
fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/3,,http://rs.tdwg.org/dwc/terms/#fieldNumber,53
48 
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
49 49 
remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/Remarks; http://rs.tdwg.org/dwc/terms/#taxonRemarks,65; 158
50 50 
taxonRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/description,,http://rs.tdwg.org/dwc/terms/#taxonRemarks,158
51 51 
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

Also available in: Unified diff