Project

General

Profile

« Previous | Next » 

Revision 731

Added by Aaron Marcuse-Kubitza almost 13 years ago

join: Report which input mappings are missing a mapping in the join map

View differences:

mappings/SALVIAS_db-VegBIEN.organisms.csv
38 38 
PlotCode,,"Brad: Same as plotCode, above"
39 39 
SourceVoucher,,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
40 40 
SpAuthStatus,,
41 
canopy_form,,Brad: Should also be userDefined for VegBank.
42 
canopy_position,,Brad: Should also be userDefined for VegBank.
41 
canopy_form,,** No join mapping for /simpleUserdefined[name=canopyForm]/value ** Brad: Should also be userDefined for VegBank.
42 
canopy_position,,** No join mapping for /simpleUserdefined[name=canopyPosition]/value ** Brad: Should also be userDefined for VegBank.
43 43 
coll_inits,,
44 44 
collector_code,,Brad: OMIT
45 45 
common_name,,
......
51 51 
height_m_commercial,,
52 52 
ind_id,,Brad: OMIT
53 53 
infra_auth_1,,
54 
liana_infestation,,Brad: Should also be userDefined for VegBank.
54 
liana_infestation,,** No join mapping for /simpleUserdefined[name=lianaInfestation]/value ** Brad: Should also be userDefined for VegBank.
55 55 
morphocf,,
56 56 
morphoname,,
57 57 
name_status,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
mappings/for_review/SALVIAS_db-VegBIEN.organisms.csv
38 38 
PlotCode,,"Brad: Same as plotCode, above"
39 39 
SourceVoucher,,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
40 40 
SpAuthStatus,,
41 
canopy_form,,Brad: Should also be userDefined for VegBank.
42 
canopy_position,,Brad: Should also be userDefined for VegBank.
41 
canopy_form,,** No join mapping for /simpleUserdefined[name=canopyForm]/value ** Brad: Should also be userDefined for VegBank.
42 
canopy_position,,** No join mapping for /simpleUserdefined[name=canopyPosition]/value ** Brad: Should also be userDefined for VegBank.
43 43 
coll_inits,,
44 44 
collector_code,,Brad: OMIT
45 45 
common_name,,
......
51 51 
height_m_commercial,,
52 52 
ind_id,,Brad: OMIT
53 53 
infra_auth_1,,
54 
liana_infestation,,Brad: Should also be userDefined for VegBank.
54 
liana_infestation,,** No join mapping for /simpleUserdefined[name=lianaInfestation]/value ** Brad: Should also be userDefined for VegBank.
55 55 
morphocf,,
56 56 
morphoname,,
57 57 
name_status,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
mappings/for_review/SALVIAS-VegBIEN.plots.csv
37 37 
silt_percent,//soilobs/soilsilt,
38 38 
soil_texture,//soilobs/soiltexture,
39 39 
PLOT_ID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
40 
holdridge_life_zone,,
41 
life_zone_code,,
40 
holdridge_life_zone,,** No join mapping for ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name **
41 
life_zone_code,,** No join mapping for ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName **
42 42 
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"
43 43 
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"
mappings/SALVIAS-VegBIEN.plots.csv
37 37 
silt_percent,/soilobs:[soilhorizon=unknown]/soilsilt,
38 38 
soil_texture,/soilobs:[soilhorizon=unknown]/soiltexture,
39 39 
PLOT_ID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
40 
holdridge_life_zone,,
41 
life_zone_code,,
40 
holdridge_life_zone,,** No join mapping for ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name **
41 
life_zone_code,,** No join mapping for ->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName **
42 42 
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"
43 43 
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"

Also available in: Unified diff