Revision 4043
Added by Aaron Marcuse-Kubitza about 12 years ago
| import.specimens.xml.ref | ||
|---|---|---|
| 9 | 9 |
</_merge> |
| 10 | 10 |
</authorlocationcode> |
| 11 | 11 |
<elevation> |
| 12 |
<_alt> |
|
| 13 |
<2> |
|
| 14 |
<_avg> |
|
| 15 |
<max> |
|
| 16 |
<_units> |
|
| 17 |
<default>m</default> |
|
| 18 |
<to>m</to> |
|
| 19 |
<to></to> |
|
| 12 |
<_avg> |
|
| 13 |
<max> |
|
| 14 |
<_units> |
|
| 15 |
<default>m</default> |
|
| 16 |
<to>m</to> |
|
| 17 |
<to></to> |
|
| 18 |
<value> |
|
| 19 |
<_replace> |
|
| 20 |
<\bca\.?></\bca\.?> |
|
| 21 |
<value>$MaximumElevation</value> |
|
| 22 |
</_replace> |
|
| 23 |
</value> |
|
| 24 |
</_units> |
|
| 25 |
</max> |
|
| 26 |
<min> |
|
| 27 |
<_units> |
|
| 28 |
<default>m</default> |
|
| 29 |
<to>m</to> |
|
| 30 |
<to></to> |
|
| 31 |
<value> |
|
| 32 |
<_rangeStart> |
|
| 20 | 33 |
<value> |
| 21 | 34 |
<_replace> |
| 22 | 35 |
<\bca\.?></\bca\.?> |
| 23 |
<value>$MaximumElevation</value> |
|
| 24 |
</_replace> |
|
| 25 |
</value> |
|
| 26 |
</_units> |
|
| 27 |
</max> |
|
| 28 |
<min> |
|
| 29 |
<_units> |
|
| 30 |
<default>m</default> |
|
| 31 |
<to>m</to> |
|
| 32 |
<to></to> |
|
| 33 |
<value> |
|
| 34 |
<_rangeStart> |
|
| 35 | 36 |
<value> |
| 36 |
<_replace> |
|
| 37 |
<\bca\.?></\bca\.?> |
|
| 38 |
<value> |
|
| 39 |
<_nullIf> |
|
| 40 |
<null>.</null> |
|
| 41 |
<value>$MinimumElevation</value> |
|
| 42 |
</_nullIf> |
|
| 43 |
</value> |
|
| 44 |
</_replace> |
|
| 37 |
<_nullIf> |
|
| 38 |
<null>.</null> |
|
| 39 |
<value>$MinimumElevation</value> |
|
| 40 |
</_nullIf> |
|
| 45 | 41 |
</value> |
| 46 |
</_rangeStart>
|
|
| 42 |
</_replace>
|
|
| 47 | 43 |
</value> |
| 48 |
</_units>
|
|
| 49 |
</min>
|
|
| 50 |
</_avg>
|
|
| 51 |
</2>
|
|
| 52 |
</_alt>
|
|
| 44 |
</_rangeStart>
|
|
| 45 |
</value>
|
|
| 46 |
</_units>
|
|
| 47 |
</min>
|
|
| 48 |
</_avg>
|
|
| 53 | 49 |
</elevation> |
| 54 | 50 |
<elevationrange> |
| 55 | 51 |
<_range> |
| ... | ... | |
| 110 | 106 |
</_range> |
| 111 | 107 |
</elevationrange> |
| 112 | 108 |
<locationdetermination> |
| 113 |
<coordsaccuracy><_noCV><value><_alt><2>$CoordinatePrecision</2></_alt></value></_noCV></coordsaccuracy>
|
|
| 109 |
<coordsaccuracy><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy>
|
|
| 114 | 110 |
<footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc> |
| 115 | 111 |
<latitude> |
| 116 |
<_alt> |
|
| 117 |
<2> |
|
| 118 |
<_nullIf> |
|
| 119 |
<null>0</null> |
|
| 120 |
<type>float</type> |
|
| 121 |
<value>$Latitude</value> |
|
| 122 |
</_nullIf> |
|
| 123 |
</2> |
|
| 124 |
</_alt> |
|
| 112 |
<_nullIf> |
|
| 113 |
<null>0</null> |
|
| 114 |
<type>float</type> |
|
| 115 |
<value>$Latitude</value> |
|
| 116 |
</_nullIf> |
|
| 125 | 117 |
</latitude> |
| 126 | 118 |
<longitude> |
| 127 |
<_alt> |
|
| 128 |
<2> |
|
| 129 |
<_nullIf> |
|
| 130 |
<null>0</null> |
|
| 131 |
<type>float</type> |
|
| 132 |
<value>$Longitude</value> |
|
| 133 |
</_nullIf> |
|
| 134 |
</2> |
|
| 135 |
</_alt> |
|
| 119 |
<_nullIf> |
|
| 120 |
<null>0</null> |
|
| 121 |
<type>float</type> |
|
| 122 |
<value>$Longitude</value> |
|
| 123 |
</_nullIf> |
|
| 136 | 124 |
</longitude> |
| 137 | 125 |
<namedplace_id> |
| 138 | 126 |
<_simplifyPath> |
| ... | ... | |
| 171 | 159 |
<date> |
| 172 | 160 |
<_dateRangeEnd> |
| 173 | 161 |
<value> |
| 174 |
<_alt> |
|
| 175 |
<1> |
|
| 176 |
<_date> |
|
| 177 |
<day> |
|
| 178 |
<_nullIf> |
|
| 179 |
<null>0</null> |
|
| 180 |
<type>float</type> |
|
| 181 |
<value>$DayCollected</value> |
|
| 182 |
</_nullIf> |
|
| 183 |
</day> |
|
| 184 |
<month> |
|
| 185 |
<_nullIf> |
|
| 186 |
<null>0</null> |
|
| 187 |
<type>float</type> |
|
| 188 |
<value>$MonthCollected</value> |
|
| 189 |
</_nullIf> |
|
| 190 |
</month> |
|
| 191 |
<year> |
|
| 192 |
<_nullIf> |
|
| 193 |
<null>0</null> |
|
| 194 |
<type>float</type> |
|
| 195 |
<value>$YearCollected</value> |
|
| 196 |
</_nullIf> |
|
| 197 |
</year> |
|
| 198 |
</_date> |
|
| 199 |
</1> |
|
| 200 |
</_alt> |
|
| 162 |
<_date> |
|
| 163 |
<day> |
|
| 164 |
<_nullIf> |
|
| 165 |
<null>0</null> |
|
| 166 |
<type>float</type> |
|
| 167 |
<value>$DayCollected</value> |
|
| 168 |
</_nullIf> |
|
| 169 |
</day> |
|
| 170 |
<month> |
|
| 171 |
<_nullIf> |
|
| 172 |
<null>0</null> |
|
| 173 |
<type>float</type> |
|
| 174 |
<value>$MonthCollected</value> |
|
| 175 |
</_nullIf> |
|
| 176 |
</month> |
|
| 177 |
<year> |
|
| 178 |
<_nullIf> |
|
| 179 |
<null>0</null> |
|
| 180 |
<type>float</type> |
|
| 181 |
<value>$YearCollected</value> |
|
| 182 |
</_nullIf> |
|
| 183 |
</year> |
|
| 184 |
</_date> |
|
| 201 | 185 |
</value> |
| 202 | 186 |
</_dateRangeEnd> |
| 203 | 187 |
</date> |
| ... | ... | |
| 208 | 192 |
<date> |
| 209 | 193 |
<_dateRangeStart> |
| 210 | 194 |
<value> |
| 211 |
<_alt> |
|
| 212 |
<1> |
|
| 213 |
<_date> |
|
| 214 |
<day> |
|
| 215 |
<_nullIf> |
|
| 216 |
<null>0</null> |
|
| 217 |
<type>float</type> |
|
| 218 |
<value>$DayCollected</value> |
|
| 219 |
</_nullIf> |
|
| 220 |
</day> |
|
| 221 |
<month> |
|
| 222 |
<_nullIf> |
|
| 223 |
<null>0</null> |
|
| 224 |
<type>float</type> |
|
| 225 |
<value>$MonthCollected</value> |
|
| 226 |
</_nullIf> |
|
| 227 |
</month> |
|
| 228 |
<year> |
|
| 229 |
<_nullIf> |
|
| 230 |
<null>0</null> |
|
| 231 |
<type>float</type> |
|
| 232 |
<value>$YearCollected</value> |
|
| 233 |
</_nullIf> |
|
| 234 |
</year> |
|
| 235 |
</_date> |
|
| 236 |
</1> |
|
| 237 |
</_alt> |
|
| 195 |
<_date> |
|
| 196 |
<day> |
|
| 197 |
<_nullIf> |
|
| 198 |
<null>0</null> |
|
| 199 |
<type>float</type> |
|
| 200 |
<value>$DayCollected</value> |
|
| 201 |
</_nullIf> |
|
| 202 |
</day> |
|
| 203 |
<month> |
|
| 204 |
<_nullIf> |
|
| 205 |
<null>0</null> |
|
| 206 |
<type>float</type> |
|
| 207 |
<value>$MonthCollected</value> |
|
| 208 |
</_nullIf> |
|
| 209 |
</month> |
|
| 210 |
<year> |
|
| 211 |
<_nullIf> |
|
| 212 |
<null>0</null> |
|
| 213 |
<type>float</type> |
|
| 214 |
<value>$YearCollected</value> |
|
| 215 |
</_nullIf> |
|
| 216 |
</year> |
|
| 217 |
</_date> |
|
| 238 | 218 |
</value> |
| 239 | 219 |
</_dateRangeStart> |
| 240 | 220 |
</date> |
| ... | ... | |
| 245 | 225 |
<collectiondate> |
| 246 | 226 |
<_date> |
| 247 | 227 |
<date> |
| 248 |
<_alt> |
|
| 249 |
<1> |
|
| 250 |
<_date> |
|
| 251 |
<day> |
|
| 252 |
<_nullIf> |
|
| 253 |
<null>0</null> |
|
| 254 |
<type>float</type> |
|
| 255 |
<value>$DayCollected</value> |
|
| 256 |
</_nullIf> |
|
| 257 |
</day> |
|
| 258 |
<month> |
|
| 259 |
<_nullIf> |
|
| 260 |
<null>0</null> |
|
| 261 |
<type>float</type> |
|
| 262 |
<value>$MonthCollected</value> |
|
| 263 |
</_nullIf> |
|
| 264 |
</month> |
|
| 265 |
<year> |
|
| 266 |
<_nullIf> |
|
| 267 |
<null>0</null> |
|
| 268 |
<type>float</type> |
|
| 269 |
<value>$YearCollected</value> |
|
| 270 |
</_nullIf> |
|
| 271 |
</year> |
|
| 272 |
</_date> |
|
| 273 |
</1> |
|
| 274 |
</_alt> |
|
| 228 |
<_date> |
|
| 229 |
<day> |
|
| 230 |
<_nullIf> |
|
| 231 |
<null>0</null> |
|
| 232 |
<type>float</type> |
|
| 233 |
<value>$DayCollected</value> |
|
| 234 |
</_nullIf> |
|
| 235 |
</day> |
|
| 236 |
<month> |
|
| 237 |
<_nullIf> |
|
| 238 |
<null>0</null> |
|
| 239 |
<type>float</type> |
|
| 240 |
<value>$MonthCollected</value> |
|
| 241 |
</_nullIf> |
|
| 242 |
</month> |
|
| 243 |
<year> |
|
| 244 |
<_nullIf> |
|
| 245 |
<null>0</null> |
|
| 246 |
<type>float</type> |
|
| 247 |
<value>$YearCollected</value> |
|
| 248 |
</_nullIf> |
|
| 249 |
</year> |
|
| 250 |
</_date> |
|
| 275 | 251 |
</date> |
| 276 | 252 |
</_date> |
| 277 | 253 |
</collectiondate> |
| ... | ... | |
| 306 | 282 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode> |
| 307 | 283 |
<specimenreplicate> |
| 308 | 284 |
<_if name="if indirect voucher"><else><catalognumber_dwc>$CatalogNumber</catalognumber_dwc></else></_if> |
| 309 |
<collectioncode_dwc><_alt><1>$CollectionCode</1></_alt></collectioncode_dwc>
|
|
| 285 |
<collectioncode_dwc>$CollectionCode</collectioncode_dwc>
|
|
| 310 | 286 |
<collectionnumber> |
| 311 | 287 |
<_alt> |
| 312 | 288 |
<1>$CollectorNumber</1> |
| ... | ... | |
| 414 | 390 |
<date> |
| 415 | 391 |
<_dateRangeStart> |
| 416 | 392 |
<value> |
| 417 |
<_alt> |
|
| 418 |
<1> |
|
| 419 |
<_date> |
|
| 420 |
<day> |
|
| 421 |
<_nullIf> |
|
| 422 |
<null>0</null> |
|
| 423 |
<type>float</type> |
|
| 424 |
<value>$DayIdentified</value> |
|
| 425 |
</_nullIf> |
|
| 426 |
</day> |
|
| 427 |
<month> |
|
| 428 |
<_nullIf> |
|
| 429 |
<null>0</null> |
|
| 430 |
<type>float</type> |
|
| 431 |
<value>$MonthIdentified</value> |
|
| 432 |
</_nullIf> |
|
| 433 |
</month> |
|
| 434 |
<year> |
|
| 435 |
<_nullIf> |
|
| 436 |
<null>0</null> |
|
| 437 |
<type>float</type> |
|
| 438 |
<value>$YearIdentified</value> |
|
| 439 |
</_nullIf> |
|
| 440 |
</year> |
|
| 441 |
</_date> |
|
| 442 |
</1> |
|
| 443 |
</_alt> |
|
| 393 |
<_date> |
|
| 394 |
<day> |
|
| 395 |
<_nullIf> |
|
| 396 |
<null>0</null> |
|
| 397 |
<type>float</type> |
|
| 398 |
<value>$DayIdentified</value> |
|
| 399 |
</_nullIf> |
|
| 400 |
</day> |
|
| 401 |
<month> |
|
| 402 |
<_nullIf> |
|
| 403 |
<null>0</null> |
|
| 404 |
<type>float</type> |
|
| 405 |
<value>$MonthIdentified</value> |
|
| 406 |
</_nullIf> |
|
| 407 |
</month> |
|
| 408 |
<year> |
|
| 409 |
<_nullIf> |
|
| 410 |
<null>0</null> |
|
| 411 |
<type>float</type> |
|
| 412 |
<value>$YearIdentified</value> |
|
| 413 |
</_nullIf> |
|
| 414 |
</year> |
|
| 415 |
</_date> |
|
| 444 | 416 |
</value> |
| 445 | 417 |
</_dateRangeStart> |
| 446 | 418 |
</date> |
| ... | ... | |
| 507 | 479 |
</3> |
| 508 | 480 |
</_merge> |
| 509 | 481 |
</locationnarrative> |
| 510 |
<sourceaccessioncode><_alt><1>$UniqueNYInternalRecordNumber</1></_alt></sourceaccessioncode>
|
|
| 482 |
<sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
|
|
| 511 | 483 |
</location> |
| 512 | 484 |
</VegBIEN> |
| 513 | 485 |
Inserted 39 new rows into database |
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv, DwC1-DwC2.specimens.csv: Split eventDate into eventDate and dateCollected, where eventDate refers only to the date of the sampling event, but dateCollected also refers to the date the particular specimen was collected. (This distinction is important in merging with VegCSV, because in plots data, these two fields are distinct.) Remapped datasources with dateCollected-related fields to new dateCollected.