Project

General

Profile

« Previous | Next » 

Revision 4063

mappings/VegCSV-VegBIEN.specimens.csv: locationID: location.sourceaccessioncode mapping: Added /_alt suffix for mergability with DwC

View differences:

inputs/Madidi/maps/VegBIEN.plots.csv
36 36
Direction,/location/slopeaspect/_compass/value/_alt/1,Part files provide either this field or Direction
37 37
OrientaciĆ³n/exposicion,/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or OrientaciĆ³n
38 38
Slope,/location/slopegradient,
39
Inventory code,/location/sourceaccessioncode,
39
Inventory code,/location/sourceaccessioncode/_alt/2,
40 40
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 41
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
42 42
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
41 41
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 42
slope_aspect,/location/slopeaspect/_compass/value,
43 43
slope_gradient,/location/slopegradient,
44
PLOT_ID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
44
PLOT_ID,/location/sourceaccessioncode/_alt/2,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 45
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
46 46
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS/maps/VegBIEN.plots.csv
41 41
Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 42
slope_aspect,/location/slopeaspect/_compass/value,
43 43
slope_gradient,/location/slopegradient,
44
PlotID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
44
PlotID,/location/sourceaccessioncode/_alt/2,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 45
AccessCode,,** No input mapping for AccessCode ** 
46 46
ElevSource,,** No input mapping for ElevSource ** 
47 47
Habitat,,** No input mapping for Habitat ** 
mappings/VegCSV-VegBIEN.specimens.csv
104 104
parentLocationID,/location/parent_id/location/sourceaccessioncode,
105 105
slopeAspect,/location/slopeaspect/_compass/value,
106 106
slopeGradient,/location/slopegradient,
107
locationID,/location/sourceaccessioncode,
107
locationID,/location/sourceaccessioncode/_alt/2,

Also available in: Unified diff