Project

General

Profile

« Previous | Next » 

Revision 3915

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: Remapped eventDate to new aggregateoccurrence.collectiondate, which is a more accurate place than locationevent.obsstartdate/obsenddate because the date refers to a specific specimen. This also makes eventDate compatible with plots data.

View differences:

mappings/DwC2-VegBIEN.specimens.csv
15 15 
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
16 16 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
17 17 
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
18 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 19 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 20 
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
22 21 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
mappings/for_review/VegBIEN-DwC2.specimens.csv
15 15 
//locationdetermination/namedplace_id[rank=stateProvince]/placename,stateProvince,,http://rs.tdwg.org/dwc/terms/#stateProvince,65
16 16 
//locationdetermination/namedplace_id[rank=country]/placename,country,,http://rs.tdwg.org/dwc/terms/#country,63
17 17 
//locationdetermination/namedplace_id[rank=continent]/placename,continent,,http://rs.tdwg.org/dwc/terms/#continent,59
18 
//locationevent/obsenddate/_*/date,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 
//locationevent/obsstartdate/_*/date,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
//aggregateoccurrence/collectiondate/_*/date,eventDate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 19 
//aggregateoccurrence/notes,fieldNotes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 20 
"//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
22 21 
//specimenreplicate/catalognumber_dwc,catalogNumber,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
mappings/DwC.cs-VegBIEN.specimens.csv
25 25 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
26 26 
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
27 27 
continentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
28 
eventDate/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
29 
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
30 
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
31 
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
32 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
33 
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
34 
eventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
35 
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
36 
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
37 
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
38 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
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
28 
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
29 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
30 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
31 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
32 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
33 
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 34 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
41 35 
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 36 
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
inputs/XAL/test/import.specimens.xml.ref
133 133 
            </namedplace_id>
134 134 
        </locationdetermination>
135 135 
        <locationevent>
136 
            <obsenddate>
137 
                <_date>
138 
                    <date>
139 
                        <_dateRangeEnd>
140 
                            <value>
136 
            <taxonoccurrence>
137 
                <aggregateoccurrence>
138 
                    <collectiondate>
139 
                        <_date>
140 
                            <date>
141 141 
                                <_alt>
142 142 
                                    <1>
143 143 
                                        <_date>
......
165 165 
                                        </_date>
166 166 
                                    </1>
167 167 
                                </_alt>
168 
                            </value>
169 
                        </_dateRangeEnd>
170 
                    </date>
171 
                </_date>
172 
            </obsenddate>
173 
            <obsstartdate>
174 
                <_date>
175 
                    <date>
176 
                        <_dateRangeStart>
177 
                            <value>
178 
                                <_alt>
179 
                                    <1>
180 
                                        <_date>
181 
                                            <day>
182 
                                                <_nullIf>
183 
                                                    <null>0</null>
184 
                                                    <type>float</type>
185 
                                                    <value>$DayCollected</value>
186 
                                                </_nullIf>
187 
                                            </day>
188 
                                            <month>
189 
                                                <_nullIf>
190 
                                                    <null>0</null>
191 
                                                    <type>float</type>
192 
                                                    <value>$MonthCollected</value>
193 
                                                </_nullIf>
194 
                                            </month>
195 
                                            <year>
196 
                                                <_nullIf>
197 
                                                    <null>0</null>
198 
                                                    <type>float</type>
199 
                                                    <value>$YearCollected</value>
200 
                                                </_nullIf>
201 
                                            </year>
202 
                                        </_date>
203 
                                    </1>
204 
                                </_alt>
205 
                            </value>
206 
                        </_dateRangeStart>
207 
                    </date>
208 
                </_date>
209 
            </obsstartdate>
210 
            <taxonoccurrence>
211 
                <aggregateoccurrence>
168 
                            </date>
169 
                        </_date>
170 
                    </collectiondate>
212 171 
                    <notes>$Notes</notes>
213 172 
                    <plantobservation>
214 173 
                        <definedvalue fkey="tablerecord_id">
inputs/XAL/maps/VegBIEN.specimens.csv
11 11 
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
12 12 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
13 13 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
14 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
15 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
16 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
17 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
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 
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
14 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
15 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
16 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 17 
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 18 
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
22 19 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
inputs/NY/test/import.specimens.xml.ref
149 149 
            </namedplace_id>
150 150 
        </locationdetermination>
151 151 
        <locationevent>
152 
            <obsenddate>
153 
                <_date>
154 
                    <date>
155 
                        <_dateRangeEnd>
156 
                            <value>
152 
            <taxonoccurrence>
153 
                <aggregateoccurrence>
154 
                    <collectiondate>
155 
                        <_date>
156 
                            <date>
157 157 
                                <_alt>
158 158 
                                    <1>
159 159 
                                        <_date>
......
181 181 
                                        </_date>
182 182 
                                    </1>
183 183 
                                </_alt>
184 
                            </value>
185 
                        </_dateRangeEnd>
186 
                    </date>
187 
                </_date>
188 
            </obsenddate>
189 
            <obsstartdate>
190 
                <_date>
191 
                    <date>
192 
                        <_dateRangeStart>
193 
                            <value>
194 
                                <_alt>
195 
                                    <1>
196 
                                        <_date>
197 
                                            <day>
198 
                                                <_nullIf>
199 
                                                    <null>0</null>
200 
                                                    <type>float</type>
201 
                                                    <value>$DayCollected</value>
202 
                                                </_nullIf>
203 
                                            </day>
204 
                                            <month>
205 
                                                <_nullIf>
206 
                                                    <null>0</null>
207 
                                                    <type>float</type>
208 
                                                    <value>$MonthCollected</value>
209 
                                                </_nullIf>
210 
                                            </month>
211 
                                            <year>
212 
                                                <_nullIf>
213 
                                                    <null>0</null>
214 
                                                    <type>float</type>
215 
                                                    <value>$YearCollected</value>
216 
                                                </_nullIf>
217 
                                            </year>
218 
                                        </_date>
219 
                                    </1>
220 
                                </_alt>
221 
                            </value>
222 
                        </_dateRangeStart>
223 
                    </date>
224 
                </_date>
225 
            </obsstartdate>
226 
            <taxonoccurrence>
227 
                <aggregateoccurrence>
184 
                            </date>
185 
                        </_date>
186 
                    </collectiondate>
228 187 
                    <notes>
229 188 
                        <_merge>
230 189 
                            <1>$Notes</1>
inputs/NY/maps/VegBIEN.specimens.csv
12 12 
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
13 13 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
14 14 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
15 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
16 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
17 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
18 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
19 
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
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
15 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
16 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
17 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 18 
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 19 
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 20 
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
inputs/UNCC/test/import.specimens.xml.ref
28 28 
            </namedplace_id>
29 29 
        </locationdetermination>
30 30 
        <locationevent>
31 
            <obsenddate>
32 
                <_date>
33 
                    <date>
34 
                        <_dateRangeEnd>
35 
                            <value>
31 
            <taxonoccurrence>
32 
                <aggregateoccurrence>
33 
                    <collectiondate>
34 
                        <_date>
35 
                            <date>
36 36 
                                <_alt>
37 37 
                                    <1>
38 38 
                                        <_date>
......
60 60 
                                        </_date>
61 61 
                                    </1>
62 62 
                                </_alt>
63 
                            </value>
64 
                        </_dateRangeEnd>
65 
                    </date>
66 
                </_date>
67 
            </obsenddate>
68 
            <obsstartdate>
69 
                <_date>
70 
                    <date>
71 
                        <_dateRangeStart>
72 
                            <value>
73 
                                <_alt>
74 
                                    <1>
75 
                                        <_date>
76 
                                            <day>
77 
                                                <_nullIf>
78 
                                                    <null>0</null>
79 
                                                    <type>float</type>
80 
                                                    <value>$collday</value>
81 
                                                </_nullIf>
82 
                                            </day>
83 
                                            <month>
84 
                                                <_nullIf>
85 
                                                    <null>0</null>
86 
                                                    <type>float</type>
87 
                                                    <value>$collmonth</value>
88 
                                                </_nullIf>
89 
                                            </month>
90 
                                            <year>
91 
                                                <_nullIf>
92 
                                                    <null>0</null>
93 
                                                    <type>float</type>
94 
                                                    <value>$collyear</value>
95 
                                                </_nullIf>
96 
                                            </year>
97 
                                        </_date>
98 
                                    </1>
99 
                                </_alt>
100 
                            </value>
101 
                        </_dateRangeStart>
102 
                    </date>
103 
                </_date>
104 
            </obsstartdate>
105 
            <taxonoccurrence>
106 
                <aggregateoccurrence>
63 
                            </date>
64 
                        </_date>
65 
                    </collectiondate>
107 66 
                    <notes>
108 67 
                        <_merge>
109 68 
                            <1>$comment1</1>
inputs/UNCC/maps/VegBIEN.specimens.csv
2 2 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
3 3 
state,"/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",,"NCU-NCSC#State, REMIB#state, UNCC#state; http://rs.tdwg.org/dwc/terms/#stateProvince",65
4 4 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
5 
collday,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
6 
collmonth,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
7 
collyear,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
8 
collday,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
9 
collmonth,"/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
10 
collyear,"/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
5 
collday,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
6 
collmonth,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
7 
collyear,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
11 8 
comment1,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/1,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
12 9 
comment2,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/2,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
13 10 
comment3,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_merge/3,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
inputs/ACAD/test/import.specimens.xml.ref
56 56 
            </namedplace_id>
57 57 
        </locationdetermination>
58 58 
        <locationevent>
59 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$eventDate</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
60 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
61 59 
            <taxonoccurrence>
62 60 
                <aggregateoccurrence>
61 
                    <collectiondate><_date><date><_alt><2>$eventDate</2></_alt></date></_date></collectiondate>
63 62 
                    <plantobservation>
64 63 
                        <specimenreplicate>
65 64 
                            <catalognumber_dwc>$catalogNumber</catalognumber_dwc>
inputs/ACAD/maps/VegBIEN.specimens.csv
5 5 
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
6 6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
7 7 
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
8 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
9 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
8 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
10 9 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
11 10 
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
12 11 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
inputs/REMIB/test/import.specimens.xml.ref
50 50 
            </namedplace_id>
51 51 
        </locationdetermination>
52 52 
        <locationevent>
53 
            <obsenddate>
54 
                <_date>
55 
                    <date>
56 
                        <_dateRangeEnd>
57 
                            <value>
53 
            <taxonoccurrence>
54 
                <aggregateoccurrence>
55 
                    <collectiondate>
56 
                        <_date>
57 
                            <date>
58 58 
                                <_alt>
59 59 
                                    <1>
60 60 
                                        <_date>
......
82 82 
                                        </_date>
83 83 
                                    </1>
84 84 
                                </_alt>
85 
                            </value>
86 
                        </_dateRangeEnd>
87 
                    </date>
88 
                </_date>
89 
            </obsenddate>
90 
            <obsstartdate>
91 
                <_date>
92 
                    <date>
93 
                        <_dateRangeStart>
94 
                            <value>
95 
                                <_alt>
96 
                                    <1>
97 
                                        <_date>
98 
                                            <day>
99 
                                                <_nullIf>
100 
                                                    <null>0</null>
101 
                                                    <type>float</type>
102 
                                                    <value>$coll_day</value>
103 
                                                </_nullIf>
104 
                                            </day>
105 
                                            <month>
106 
                                                <_nullIf>
107 
                                                    <null>0</null>
108 
                                                    <type>float</type>
109 
                                                    <value>$coll_month</value>
110 
                                                </_nullIf>
111 
                                            </month>
112 
                                            <year>
113 
                                                <_nullIf>
114 
                                                    <null>0</null>
115 
                                                    <type>float</type>
116 
                                                    <value>$coll_year</value>
117 
                                                </_nullIf>
118 
                                            </year>
119 
                                        </_date>
120 
                                    </1>
121 
                                </_alt>
122 
                            </value>
123 
                        </_dateRangeStart>
124 
                    </date>
125 
                </_date>
126 
            </obsstartdate>
127 
            <taxonoccurrence>
128 
                <aggregateoccurrence>
85 
                            </date>
86 
                        </_date>
87 
                    </collectiondate>
129 88 
                    <plantobservation>
130 89 
                        <specimenreplicate>
131 90 
                            <collectioncode_dwc>$acronym</collectioncode_dwc>
inputs/REMIB/maps/VegBIEN.specimens.csv
4 4 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
5 5 
state,"/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",,"NCU-NCSC#State, REMIB#state, UNCC#state; http://rs.tdwg.org/dwc/terms/#stateProvince",65
6 6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
7 
coll_day,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
8 
coll_month,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
9 
coll_year,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
10 
coll_day,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
11 
coll_month,"/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
12 
coll_year,"/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
7 
coll_day,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
8 
coll_month,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
9 
coll_year,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
13 10 
acronym,/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
14 11 
accession_number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,,http://rs.tdwg.org/dwc/terms/#occurrenceID,19
15 12 
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/U/test/import.specimens.xml.ref
48 48 
            </namedplace_id>
49 49 
        </locationdetermination>
50 50 
        <locationevent>
51 
            <obsenddate>
52 
                <_date>
53 
                    <date>
54 
                        <_dateRangeEnd>
55 
                            <value>
51 
            <taxonoccurrence>
52 
                <aggregateoccurrence>
53 
                    <collectiondate>
54 
                        <_date>
55 
                            <date>
56 56 
                                <_alt>
57 57 
                                    <1>
58 58 
                                        <_date>
......
80 80 
                                        </_date>
81 81 
                                    </1>
82 82 
                                </_alt>
83 
                            </value>
84 
                        </_dateRangeEnd>
85 
                    </date>
86 
                </_date>
87 
            </obsenddate>
88 
            <obsstartdate>
89 
                <_date>
90 
                    <date>
91 
                        <_dateRangeStart>
92 
                            <value>
93 
                                <_alt>
94 
                                    <1>
95 
                                        <_date>
96 
                                            <day>
97 
                                                <_nullIf>
98 
                                                    <null>0</null>
99 
                                                    <type>float</type>
100 
                                                    <value>$Colldd</value>
101 
                                                </_nullIf>
102 
                                            </day>
103 
                                            <month>
104 
                                                <_nullIf>
105 
                                                    <null>0</null>
106 
                                                    <type>float</type>
107 
                                                    <value>$Collmm</value>
108 
                                                </_nullIf>
109 
                                            </month>
110 
                                            <year>
111 
                                                <_nullIf>
112 
                                                    <null>0</null>
113 
                                                    <type>float</type>
114 
                                                    <value>$Collyy</value>
115 
                                                </_nullIf>
116 
                                            </year>
117 
                                        </_date>
118 
                                    </1>
119 
                                </_alt>
120 
                            </value>
121 
                        </_dateRangeStart>
122 
                    </date>
123 
                </_date>
124 
            </obsstartdate>
125 
            <taxonoccurrence>
126 
                <aggregateoccurrence>
83 
                            </date>
84 
                        </_date>
85 
                    </collectiondate>
127 86 
                    <notes>$Notes</notes>
128 87 
                    <plantobservation>
129 88 
                        <specimenreplicate>
inputs/U/maps/VegBIEN.specimens.csv
2 2 
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLatitude,85
3 3 
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,http://rs.tdwg.org/dwc/terms/#decimalLongitude,86
4 4 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
5 
Colldd,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
6 
Collmm,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
7 
Collyy,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
8 
Colldd,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
9 
Collmm,"/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
10 
Collyy,"/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
5 
Colldd,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
6 
Collmm,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
7 
Collyy,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
11 8 
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
12 9 
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
13 10 
Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_alt/1/_alt/2,,http://rs.tdwg.org/dwc/terms/#recordNumber,22
inputs/ARIZ/test/import.specimens.xml.ref
144 144 
            </namedplace_id>
145 145 
        </locationdetermination>
146 146 
        <locationevent>
147 
            <obsenddate>
148 
                <_date>
149 
                    <date>
150 
                        <_dateRangeEnd>
151 
                            <value>
147 
            <taxonoccurrence>
148 
                <aggregateoccurrence>
149 
                    <collectiondate>
150 
                        <_date>
151 
                            <date>
152 152 
                                <_alt>
153 153 
                                    <0>$VerbatimCollectingDate</0>
154 154 
                                    <1>
......
177 177 
                                        </_date>
178 178 
                                    </1>
179 179 
                                </_alt>
180 
                            </value>
181 
                        </_dateRangeEnd>
182 
                    </date>
183 
                </_date>
184 
            </obsenddate>
185 
            <obsstartdate>
186 
                <_date>
187 
                    <date>
188 
                        <_dateRangeStart>
189 
                            <value>
190 
                                <_alt>
191 
                                    <0>$VerbatimCollectingDate</0>
192 
                                    <1>
193 
                                        <_date>
194 
                                            <day>
195 
                                                <_nullIf>
196 
                                                    <null>0</null>
197 
                                                    <type>float</type>
198 
                                                    <value>$DayCollected</value>
199 
                                                </_nullIf>
200 
                                            </day>
201 
                                            <month>
202 
                                                <_nullIf>
203 
                                                    <null>0</null>
204 
                                                    <type>float</type>
205 
                                                    <value>$MonthCollected</value>
206 
                                                </_nullIf>
207 
                                            </month>
208 
                                            <year>
209 
                                                <_nullIf>
210 
                                                    <null>0</null>
211 
                                                    <type>float</type>
212 
                                                    <value>$YearCollected</value>
213 
                                                </_nullIf>
214 
                                            </year>
215 
                                        </_date>
216 
                                    </1>
217 
                                </_alt>
218 
                            </value>
219 
                        </_dateRangeStart>
220 
                    </date>
221 
                </_date>
222 
            </obsstartdate>
223 
            <taxonoccurrence>
224 
                <aggregateoccurrence>
180 
                            </date>
181 
                        </_date>
182 
                    </collectiondate>
225 183 
                    <notes>$FieldNotes</notes>
226 184 
                    <plantobservation>
227 185 
                        <definedvalue fkey="tablerecord_id">
inputs/ARIZ/maps/VegBIEN.specimens.csv
14 14 
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
15 15 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
16 16 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
17 
VerbatimCollectingDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/0,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
19 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
20 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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 
VerbatimCollectingDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/0,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
22 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
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 
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
17 
VerbatimCollectingDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/0,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
19 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
20 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 21 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
26 22 
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
27 23 
CatalogNumberNumeric,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
inputs/GBIF/test/import.specimens.xml.ref
136 136 
            </namedplace_id>
137 137 
        </locationdetermination>
138 138 
        <locationevent>
139 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
140 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$LatestDateCollected</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
141 139 
            <taxonoccurrence>
142 140 
                <aggregateoccurrence>
141 
                    <collectiondate><_date><date><_alt><2>$LatestDateCollected</2></_alt></date></_date></collectiondate>
143 142 
                    <plantobservation>
144 143 
                        <specimenreplicate>
145 144 
                            <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
inputs/GBIF/maps/VegBIEN.specimens.csv
11 11 
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
12 12 
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
13 13 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
14 
LatestDateCollected,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
15 
LatestDateCollected,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
14 
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
16 15 
CatalogNO,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
17 16 
CollectionCD,/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
18 17 
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,,http://rs.tdwg.org/dwc/terms/#institutionCode,11
inputs/NCU-NCSC/test/import.specimens.xml.ref
61 61 
            </namedplace_id>
62 62 
        </locationdetermination>
63 63 
        <locationevent>
64 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeEnd></date></_date></obsenddate>
65 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><3>$Collect Date</3></_alt></value></_dateRangeStart></date></_date></obsstartdate>
66 64 
            <taxonoccurrence>
67 65 
                <aggregateoccurrence>
66 
                    <collectiondate><_date><date><_alt><3>$Collect Date</3></_alt></date></_date></collectiondate>
68 67 
                    <plantobservation>
69 68 
                        <specimenreplicate>
70 69 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
5 5 
County,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,http://rs.tdwg.org/dwc/terms/#county,66
6 6 
State,"/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",,"NCU-NCSC#State, REMIB#state, UNCC#state; http://rs.tdwg.org/dwc/terms/#stateProvince",65
7 7 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
8 
Collect Date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
9 
Collect Date,/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
8 
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
10 9 
Barcode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
11 10 
SeriesName,/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
12 11 
Cultivated?,"/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/_map:[Yes=cultivated,No=wild]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
inputs/SpeciesLink/test/import.specimens.xml.ref
213 213 
            </namedplace_id>
214 214 
        </locationdetermination>
215 215 
        <locationevent>
216 
            <obsenddate>
217 
                <_date>
218 
                    <date>
219 
                        <_dateRangeEnd>
220 
                            <value>
216 
            <taxonoccurrence>
217 
                <aggregateoccurrence>
218 
                    <collectiondate>
219 
                        <_date>
220 
                            <date>
221 221 
                                <_alt>
222 222 
                                    <1>
223 223 
                                        <_date>
......
245 245 
                                        </_date>
246 246 
                                    </1>
247 247 
                                </_alt>
248 
                            </value>
249 
                        </_dateRangeEnd>
250 
                    </date>
251 
                </_date>
252 
            </obsenddate>
253 
            <obsstartdate>
254 
                <_date>
255 
                    <date>
256 
                        <_dateRangeStart>
257 
                            <value>
258 
                                <_alt>
259 
                                    <1>
260 
                                        <_date>
261 
                                            <day>
262 
                                                <_nullIf>
263 
                                                    <null>0</null>
264 
                                                    <type>float</type>
265 
                                                    <value>$conceptual_darwin_2003_1_0_DayCollected</value>
266 
                                                </_nullIf>
267 
                                            </day>
268 
                                            <month>
269 
                                                <_nullIf>
270 
                                                    <null>0</null>
271 
                                                    <type>float</type>
272 
                                                    <value>$conceptual_darwin_2003_1_0_MonthCollected</value>
273 
                                                </_nullIf>
274 
                                            </month>
275 
                                            <year>
276 
                                                <_nullIf>
277 
                                                    <null>0</null>
278 
                                                    <type>float</type>
279 
                                                    <value>$conceptual_darwin_2003_1_0_YearCollected</value>
280 
                                                </_nullIf>
281 
                                            </year>
282 
                                        </_date>
283 
                                    </1>
284 
                                </_alt>
285 
                            </value>
286 
                        </_dateRangeStart>
287 
                    </date>
288 
                </_date>
289 
            </obsstartdate>
290 
            <taxonoccurrence>
291 
                <aggregateoccurrence>
248 
                            </date>
249 
                        </_date>
250 
                    </collectiondate>
292 251 
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
293 252 
                    <plantobservation>
294 253 
                        <definedvalue fkey="tablerecord_id">
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
36 36 
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
37 37 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
38 38 
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
39 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
40 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
41 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
42 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
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 
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
39 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
40 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
41 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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 42 
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 43 
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 44 
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
inputs/MO/test/import.specimens.xml.ref
132 132 
            </namedplace_id>
133 133 
        </locationdetermination>
134 134 
        <locationevent>
135 
            <obsenddate>
136 
                <_date>
137 
                    <date>
138 
                        <_dateRangeEnd>
139 
                            <value>
135 
            <taxonoccurrence>
136 
                <aggregateoccurrence>
137 
                    <collectiondate>
138 
                        <_date>
139 
                            <date>
140 140 
                                <_alt>
141 141 
                                    <1>
142 142 
                                        <_date>
......
164 164 
                                        </_date>
165 165 
                                    </1>
166 166 
                                </_alt>
167 
                            </value>
168 
                        </_dateRangeEnd>
169 
                    </date>
170 
                </_date>
171 
            </obsenddate>
172 
            <obsstartdate>
173 
                <_date>
174 
                    <date>
175 
                        <_dateRangeStart>
176 
                            <value>
177 
                                <_alt>
178 
                                    <1>
179 
                                        <_date>
180 
                                            <day>
181 
                                                <_nullIf>
182 
                                                    <null>0</null>
183 
                                                    <type>float</type>
184 
                                                    <value>$DayCollected</value>
185 
                                                </_nullIf>
186 
                                            </day>
187 
                                            <month>
188 
                                                <_nullIf>
189 
                                                    <null>0</null>
190 
                                                    <type>float</type>
191 
                                                    <value>$MonthCollected</value>
192 
                                                </_nullIf>
193 
                                            </month>
194 
                                            <year>
195 
                                                <_nullIf>
196 
                                                    <null>0</null>
197 
                                                    <type>float</type>
198 
                                                    <value>$YearCollected</value>
199 
                                                </_nullIf>
200 
                                            </year>
201 
                                        </_date>
202 
                                    </1>
203 
                                </_alt>
204 
                            </value>
205 
                        </_dateRangeStart>
206 
                    </date>
207 
                </_date>
208 
            </obsstartdate>
209 
            <taxonoccurrence>
210 
                <aggregateoccurrence>
167 
                            </date>
168 
                        </_date>
169 
                    </collectiondate>
211 170 
                    <notes>$convertednotes</notes>
212 171 
                    <plantobservation>
213 172 
                        <specimenreplicate>
inputs/MO/maps/VegBIEN.specimens.csv
10 10 
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
11 11 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
12 12 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
13 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
14 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
15 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
16 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
17 
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
18 
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
13 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
14 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
15 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
19 16 
convertednotes,/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
20 17 
CatalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 18 
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
inputs/QMOR/test/import.specimens.xml.ref
144 144 
            </namedplace_id>
145 145 
        </locationdetermination>
146 146 
        <locationevent>
147 
            <obsenddate><_date><date><_dateRangeEnd><value><_alt><2>$eventDate</2></_alt></value></_dateRangeEnd></date></_date></obsenddate>
148 
            <obsstartdate><_date><date><_dateRangeStart><value><_alt><2>$eventDate</2></_alt></value></_dateRangeStart></date></_date></obsstartdate>
149 147 
            <taxonoccurrence>
150 148 
                <aggregateoccurrence>
149 
                    <collectiondate><_date><date><_alt><2>$eventDate</2></_alt></date></_date></collectiondate>
151 150 
                    <plantobservation>
152 151 
                        <definedvalue fkey="tablerecord_id">
153 152 
                            <userdefined_id>
inputs/QMOR/maps/VegBIEN.specimens.csv
14 14 
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
15 15 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",,http://rs.tdwg.org/dwc/terms/#country,63
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 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
17 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 18 
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
20 19 
catalogNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
21 20 
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
mappings/VegCSV-VegBIEN.specimens.csv
74 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 75 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/iscultivated/_map:[cultivated=t,wild=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
76 76 
establishmentMeans,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/isnative/_map:[native=t,exotic=f,*=]/value",,http://rs.tdwg.org/dwc/terms/#establishmentMeans,30
77 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
78 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,,http://rs.tdwg.org/dwc/terms/#eventDate,44
79 77 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate,,http://rs.tdwg.org/dwc/terms/#eventDate,44
78 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
80 79 
eventID,,,http://rs.tdwg.org/dwc/terms/#eventID,41
81 80 
eventRemarks,,,http://rs.tdwg.org/dwc/terms/#eventRemarks,55
82 81 
eventTime,,Brad: OMIT,http://rs.tdwg.org/dwc/terms/#eventTime,45
mappings/for_review/DwC2-VegBIEN.specimens.csv
15 15 
stateProvince,//locationdetermination/namedplace_id[rank=stateProvince]/placename,,http://rs.tdwg.org/dwc/terms/#stateProvince,65
16 16 
country,//locationdetermination/namedplace_id[rank=country]/placename,,http://rs.tdwg.org/dwc/terms/#country,63
17 17 
continent,//locationdetermination/namedplace_id[rank=continent]/placename,,http://rs.tdwg.org/dwc/terms/#continent,59
18 
eventDate,//locationevent/obsenddate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
19 
eventDate,//locationevent/obsstartdate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
18 
eventDate,//aggregateoccurrence/collectiondate/_*/date,,http://rs.tdwg.org/dwc/terms/#eventDate,44
20 19 
fieldNotes,//aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
21 20 
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
22 21 
catalogNumber,//specimenreplicate/catalognumber_dwc,,http://rs.tdwg.org/dwc/terms/#catalogNumber,20
mappings/DwC-VegBIEN.specimens.csv
51 51 
ContinentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
52 52 
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
53 53 
continentOcean,"/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://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/ContinentOcean; http://rs.tdwg.org/dwc/terms/#continent,17; 59
54 
EventDate/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
55 
eventDate/_alt,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
56 
DayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
57 
dayCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
58 
MonthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
59 
monthCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
60 
YearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
61 
yearCollected,"/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
62 
EventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
63 
eventDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
64 
CollectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
65 
collectedDate,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/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
66 
EventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
67 
eventDate/_alt,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
68 
DayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
69 
dayCollected,"/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
70 
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
71 
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
72 
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
73 
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
74 
EventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
75 
eventDate,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
76 
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
77 
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
54 
EventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
55 
eventDate/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt,Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,http://rs.tdwg.org/dwc/terms/#eventDate,44
56 
DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
57 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/DayCollected; http://rs.tdwg.org/dwc/terms/#eventDate,11; 44
58 
MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
59 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
60 
YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
61 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
62 
EventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
63 
eventDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_alt/2,,http://rs.tdwg.org/dwc/terms/#eventDate,44
64 
CollectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
65 
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_*/date/_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
78 66 
FieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54
79 67 
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 68 
fieldNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,,http://rs.tdwg.org/dwc/terms/#fieldNotes,54

Also available in: Unified diff