Project

General

Profile

« Previous | Next » 

Revision 1740

Added by Aaron Marcuse-Kubitza almost 13 years ago

join: Also produce warnings for no input mapping (if no comment explaining why no input mapping), in addition to no join mapping

View differences:

inputs/REMIB/maps/VegBIEN.specimens.csv
15 15 
collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
16 16 
acronym,/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,12
17 17 
accession_number,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
18 
lat_min,,
19 
lat_sec,,
20 
long_min,,
21 
long_sec,,
18 
lat_min,,** No input mapping for lat_min **
19 
lat_sec,,** No input mapping for lat_sec **
20 
long_min,,** No input mapping for long_min **
21 
long_sec,,** No input mapping for long_sec **
22 22 
preparation,,** No join mapping for preparation **
inputs/SALVIAS/maps/VegBIEN.stems.csv
12 12 
stem_height_first_branch_m,/heightfirstbranch,
13 13 
stem_tag1,"/stemtag[""""/iscurrent/_alt/2=true]/tag",Quotes sort it before tag2
14 14 
stem_tag2,/stemtag[iscurrent=true]:[../stemtag?[iscurrent/_alt/2=true]/iscurrent/_alt/1=false]/tag,
15 
origrecord_id_stems,,
16 
stem_id,,
17 
tmp_del,,
15 
origrecord_id_stems,,** No input mapping for origrecord_id_stems **
16 
stem_id,,** No input mapping for stem_id **
17 
tmp_del,,** No input mapping for tmp_del **
inputs/SALVIAS/maps/VegBIEN.plots.csv
39 39 
Temp,/temperature,
40 40 
SiteCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
41 41 
PlotID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
42 
AccessCode,,
43 
ElevSource,,
44 
Habitat,,
45 
MethodCode,,
46 
PrecipSource,,
47 
PrimOwnerID,,
48 
RevisionComments,,
49 
SiteName,,
50 
TempSource,,
51 
bearing,,
52 
lat_long_accuracy,,
53 
lat_string,,
54 
long_string,,
55 
new_world,,
56 
orig_filename,,
57 
plot_administrator,,
58 
plot_notes,,
59 
pol1_type,,
60 
pol2_type,,
42 
AccessCode,,** No input mapping for AccessCode **
43 
ElevSource,,** No input mapping for ElevSource **
44 
Habitat,,** No input mapping for Habitat **
45 
MethodCode,,** No input mapping for MethodCode **
46 
PrecipSource,,** No input mapping for PrecipSource **
47 
PrimOwnerID,,** No input mapping for PrimOwnerID **
48 
RevisionComments,,** No input mapping for RevisionComments **
49 
SiteName,,** No input mapping for SiteName **
50 
TempSource,,** No input mapping for TempSource **
51 
bearing,,** No input mapping for bearing **
52 
lat_long_accuracy,,** No input mapping for lat_long_accuracy **
53 
lat_string,,** No input mapping for lat_string **
54 
long_string,,** No input mapping for long_string **
55 
new_world,,** No input mapping for new_world **
56 
orig_filename,,** No input mapping for orig_filename **
57 
plot_administrator,,** No input mapping for plot_administrator **
58 
plot_notes,,** No input mapping for plot_notes **
59 
pol1_type,,** No input mapping for pol1_type **
60 
pol2_type,,** No input mapping for pol2_type **
61 61 
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"
62 
tmp_del,,
63 
topography_desc,,
64 
vegetation_1,,
65 
vegetation_2,,
62 
tmp_del,,** No input mapping for tmp_del **
63 
topography_desc,,** No input mapping for topography_desc **
64 
vegetation_1,,** No input mapping for vegetation_1 **
65 
vegetation_2,,** No input mapping for vegetation_2 **
inputs/SALVIAS/maps/VegBIEN.organisms.csv
36 36 
OrigFamily,"/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",Brad: OMIT
37 37 
coll_firstname,/verbatimcollectorname/_name/first,Brad: See comment above
38 38 
coll_lastname,/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
39 
GenAuth,,
40 
IsMorpho,,
41 
OrigAuth,,
42 
OrigRecordID,,
43 
SpAuthStatus,,
44 
coll_inits,,
39 
GenAuth,,** No input mapping for GenAuth **
40 
IsMorpho,,** No input mapping for IsMorpho **
41 
OrigAuth,,** No input mapping for OrigAuth **
42 
OrigRecordID,,** No input mapping for OrigRecordID **
43 
SpAuthStatus,,** No input mapping for SpAuthStatus **
44 
coll_inits,,** No input mapping for coll_inits **
45 45 
collector_code,,Brad: OMIT
46 
common_name,,
47 
det_by,,
48 
dist,,
46 
common_name,,** No input mapping for common_name **
47 
det_by,,** No input mapping for det_by **
48 
dist,,** No input mapping for dist **
49 49 
fam_status,,Brad: OMIT. This will be determined later by using TNRS.
50 50 
gen_status,,Brad: OMIT. This will be determined later by using TNRS.
51 
height_class,,
52 
height_m_commercial,,
51 
height_class,,** No input mapping for height_class **
52 
height_m_commercial,,** No input mapping for height_m_commercial **
53 53 
ind_id,,Brad: OMIT
54 
infra_auth_1,,
55 
morphocf,,
56 
morphoname,,
54 
infra_auth_1,,** No input mapping for infra_auth_1 **
55 
morphocf,,** No input mapping for morphocf **
56 
morphoname,,** No input mapping for 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."
58 
other_annotations,,
59 
perp_dist,,
60 
phenology,,
61 
species_code,,
62 
temp_liandbh,,
63 
tmp_del,,
58 
other_annotations,,** No input mapping for other_annotations **
59 
perp_dist,,** No input mapping for perp_dist **
60 
phenology,,** No input mapping for phenology **
61 
species_code,,** No input mapping for species_code **
62 
temp_liandbh,,** No input mapping for temp_liandbh **
63 
tmp_del,,** No input mapping for tmp_del **
inputs/U/maps/VegBIEN.specimens.csv
19 19 
Number,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
20 20 
Alt,,What is this?
21 21 
Alt2,,What is this?
22 
Coorsyst,,
22 
Coorsyst,,** No input mapping for Coorsyst **
23 23 
DateInfo,,Not used
24 
EW,,
25 
Gazetteer,,
26 
Majorarea,,
27 
NS,,
28 
Newgazett,,
24 
EW,,** No input mapping for EW **
25 
Gazetteer,,** No input mapping for Gazetteer **
26 
Majorarea,,** No input mapping for Majorarea **
27 
NS,,** No input mapping for NS **
28 
Newgazett,,** No input mapping for Newgazett **
29 29 
Phenology,,** No join mapping for ReproductiveCondition **
30 30 
Prefix,,Not used
31 31 
Suffix,,Not used
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
11 11 
SeriesName,/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,12
12 12 
Barcode,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
13 13 
Accession Number,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
14 
Alt E/W,,
15 
Alt N/S,,
14 
Alt E/W,,** No input mapping for Alt E/W **
15 
Alt N/S,,** No input mapping for Alt N/S **
16 16 
Elevation,,** No join mapping for VerbatimElevation **
17 17 
FIPS,,FIPS county code
18 18 
Format,,** No join mapping for PreparationType **
19 
Typology,,
19 
Typology,,** No input mapping for Typology **
inputs/MO/maps/VegBIEN.specimens.csv
29 29 
IndividualCount,,** No join mapping for IndividualCount **
30 30 
InstitutionCode,,** No join mapping for InstitutionCode **
31 31 
TypeStatus,,** No join mapping for TypeStatus **
32 
convertednotes,,
32 
convertednotes,,** No input mapping for convertednotes **

Also available in: Unified diff