Revision 920
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/maps/DwC.specimens.csv | ||
|---|---|---|
| 52 | 52 |
"Notes","bien.specimenDescription/_merge/1", |
| 53 | 53 |
"Habitat","habitat", |
| 54 | 54 |
"PlantFungusDescription","bien.specimenDescription/_merge/2/_label[label=""plant fungus""]/value", |
| 55 |
"Substrate",, |
|
| 56 |
"Vegetation",, |
|
| 55 |
"Substrate","bien.substrate",
|
|
| 56 |
"Vegetation","bien.vegetation",
|
|
| 57 | 57 |
"UniqueNYInternalRecordNumber","occurrenceID", |
| inputs/NYBG/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 9 | 9 |
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallongitude/_alt/2,,82 |
| 10 | 10 |
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 11 | 11 |
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 12 |
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,, |
|
| 12 | 13 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44 |
| 13 | 14 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/month,,44 |
| 14 | 15 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44 |
| 16 |
Substrate,/*_id/taxonoccurrence/*_id/locationevent/soilobs:[soilhorizon=unknown]/soildescription,, |
|
| 15 | 17 |
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 16 | 18 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74 |
| 17 | 19 |
Habitat,"/*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| ... | ... | |
| 50 | 52 |
PreviousCatalogNumber,,?; Brad: OMIT,35 |
| 51 | 53 |
RelatedCatalogItem,,Brad: OMIT,161 |
| 52 | 54 |
RelationshipType,,Brad: OMIT,162 |
| 53 |
Substrate,, |
|
| 54 | 55 |
TimeOfDay,,Brad: OMIT,45 |
| 55 | 56 |
TypeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125 |
| 56 |
Vegetation,, |
|
| 57 | 57 |
key,, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 12 | 12 |
verbatimLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/reallongitude/_alt/2,,82 |
| 13 | 13 |
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 14 | 14 |
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 15 |
bien.vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,, |
|
| 15 | 16 |
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44 |
| 16 | 17 |
eventDate/_alt/1/_*/date,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_*/date,,44 |
| 17 | 18 |
eventDate/_alt/2/_date/day,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44 |
| 18 | 19 |
eventDate/_alt/2/_date/month,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/month,,44 |
| 19 | 20 |
eventDate/_alt/2/_date/year,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44 |
| 21 |
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/soilobs:[soilhorizon=unknown]/soildescription,, |
|
| 20 | 22 |
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 21 | 23 |
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74 |
| 22 | 24 |
habitat,"/*_id/taxonoccurrence/aggregateoccurrence/*_id/plantobservation/stemobservation/definedvalue[*_id/userdefined[tablename=stemobservation,userdefinedname=habitat]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
Also available in: Unified diff
DwC mappings: Mapped Substrate and Vegetation