Project

General

Profile

« Previous | Next » 

Revision 6154

inputs/SALVIAS/: Mapped unmapped fields with a VegCore/VegBIEN equivalent. plotMetadata_/: Remapped life_zone to communityID because it is now alt-ed together with vegetation*, and thus not just a description with life_zone_code as its globally unique name.

View differences:

inputs/SALVIAS/stems/map.csv
15 15
stem_canopy_position,canopyPosition,,
16 16
stem_liana_infestation,lianaInfestation,,
17 17
tmp_del,*tmp_del,,
18
plotobs_id_index,*plotobs_id_index,,
18
plotobs_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/stems/VegBIEN.csv
17 17
stem_tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2","The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
18 18
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else",
19 19
origrecord_id_stems,,** No join mapping for *origrecord_id_stems ** 
20
plotobs_id_index,,** No join mapping for *plotobs_id_index ** 
20
plotobs_id_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
21 21
tmp_del,,** No join mapping for *tmp_del ** 
inputs/SALVIAS/stems/new_terms.csv
10 10
stem_canopy_form,canopyForm,,
11 11
stem_canopy_position,canopyPosition,,
12 12
stem_liana_infestation,lianaInfestation,,
13
plotobs_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/stems/unmapped_terms.csv
1 1
*origrecord_id_stems
2 2
*tmp_del
3
*plotobs_id_index
inputs/SALVIAS/plotObservations/map.csv
28 28
coll_lastname,recordedBy.surName,,"Brad: 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."
29 29
coll_firstname,recordedBy.givenName,,Brad: See comment above
30 30
DetType,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
31
det_by,*det_by,,
32
fam_status,*fam_status,,Brad: OMIT. This will be determined later by using TNRS.
33
gen_status,*gen_status,,Brad: OMIT. This will be determined later by using TNRS.
34
name_status,*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."
31
det_by,identifiedBy,,
32
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
33
gen_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
34
name_status,OMIT,,"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."
35 35
SpAuthStatus,*SpAuthStatus,,
36 36
Family,family,,
37 37
Genus,genus,,
......
42 42
infra_ep_1,infraspecificEpithet,,
43 43
infra_auth_1,*infra_auth_1,,
44 44
common_name,*common_name,,
45
morphoname,*morphoname,,
45
morphoname,*morphoname,,"Not the morphospecies, which is stored in Species"
46 46
species_code,*species_code,,
47 47
Habit,verbatimGrowthForm,,"Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
48 48
height_class,*height_class,,
......
68 68
temp_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"
69 69
temp_liandbh,*temp_liandbh,,
70 70
tmp_del,*tmp_del,,
71
PlotID_index,*PlotID_index,,
71
PlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/plotObservations/VegBIEN.csv
83 83
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2","The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
84 84
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""Hemiepífito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
85 85
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
86
det_by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
86 87
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family",
87 88
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
88 89
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[reference_id/reference/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
......
139 140
IsMorpho,,** No join mapping for *IsMorpho ** 
140 141
OrigAuth,,** No join mapping for *OrigAuth ** 
141 142
OrigRecordID,,** No join mapping for *OrigRecordID ** 
142
PlotID_index,,** No join mapping for *PlotID_index ** 
143
PlotID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
143 144
SpAuthStatus,,** No join mapping for *SpAuthStatus ** 
144 145
coll_inits,,** No join mapping for *coll_inits ** 
145 146
collector_code,,** No join mapping for *collector_code ** Brad: OMIT
146 147
common_name,,** No join mapping for *common_name ** 
147
det_by,,** No join mapping for *det_by ** 
148 148
dist,,** No join mapping for *dist ** 
149
fam_status,,** No join mapping for *fam_status ** Brad: OMIT. This will be determined later by using TNRS.
150
gen_status,,** No join mapping for *gen_status ** Brad: OMIT. This will be determined later by using TNRS.
149
fam_status,,** No non-empty join mapping for OMIT ** Brad: OMIT. This will be determined later by using TNRS.
150
gen_status,,** No non-empty join mapping for OMIT ** Brad: OMIT. This will be determined later by using TNRS.
151 151
height_class,,** No join mapping for *height_class ** 
152 152
height_m_commercial,,** No join mapping for *height_m_commercial ** 
153 153
ind_id,,** No join mapping for *ind_id ** Brad: OMIT
154 154
infra_auth_1,,** No join mapping for *infra_auth_1 ** 
155 155
morphocf,,** No join mapping for *morphocf ** 
156
morphoname,,** No join mapping for *morphoname ** 
157
name_status,,"** No join mapping for *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."
156
morphoname,,"** No join mapping for *morphoname ** Not the morphospecies, which is stored in Species"
157
name_status,,"** No non-empty join mapping for OMIT ** 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."
158 158
other_annotations,,** No join mapping for *other_annotations ** 
159 159
perp_dist,,** No join mapping for *perp_dist ** 
160 160
phenology,,** No join mapping for *phenology ** 
inputs/SALVIAS/plotObservations/test.xml.ref
138 138
                        </growthform>
139 139
                        <sourceaccessioncode>$PlotObsID</sourceaccessioncode>
140 140
                        <taxondetermination>
141
                            <party_id><party><fullname>$det_by</fullname></party></party_id>
141 142
                            <taxonverbatim_id>
142 143
                                <taxonverbatim>
143 144
                                    <taxonlabel_id>
inputs/SALVIAS/plotObservations/new_terms.csv
20 20
coll_lastname,recordedBy.surName,,"Brad: 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."
21 21
coll_firstname,recordedBy.givenName,,Brad: See comment above
22 22
DetType,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
23
det_by,identifiedBy,,
24
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
25
gen_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
26
name_status,OMIT,,"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."
23 27
auth,scientificNameAuthorship,,Brad: This is the author of the scientificName.
24 28
infra_rank_1,taxonRank,,
25 29
infra_ep_1,infraspecificEpithet,,
......
30 34
OrigGenus,originalGenus,,
31 35
OrigSpecies,originalSpecificEpithet,,Brad: OMIT
32 36
temp_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"
37
PlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
inputs/SALVIAS/plotObservations/unmapped_terms.csv
4 4
*perp_dist
5 5
*collector_code
6 6
*coll_inits
7
*det_by
8
*fam_status
9
*gen_status
10
*name_status
11 7
*SpAuthStatus
12 8
*GenAuth
13 9
*infra_auth_1
......
23 19
*phenology
24 20
*temp_liandbh
25 21
*tmp_del
26
*PlotID_index
inputs/SALVIAS/plotMetadata_/map.csv
1 1
SALVIAS,VegCore,Filter,Comments
2
MethodCode,*MethodCode,,
2
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
3 3
PlotID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
4 4
orig_filename,*orig_filename,,
5
AccessCode,*AccessCode,,
5
AccessCode,*AccessCode,,"3 plots contain 3 in this field and ""del"" in tmp_del"
6 6
project_id,projectID,,
7 7
PrimOwnerID,*PrimOwnerID,,
8 8
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
......
14 14
pol1_type,*pol1_type,,
15 15
pol2,county,,Brad: No pol2=countyParish
16 16
pol2_type,*pol2_type,,
17
lat_string,*lat_string,,
18
long_string,*long_string,,
17
lat_string,verbatimLatitude,,
18
long_string,verbatimLongitude,,
19 19
LatDec,decimalLatitude,,
20 20
LongDec,decimalLongitude,,
21
lat_long_accuracy,*lat_long_accuracy,,
21
lat_long_accuracy,*lat_long_accuracy,,"Plain text description of accuracy, not numeric"
22 22
Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
23 23
elev_max_m,maximumElevationInMeters,,
24 24
elev_min_m,minimumElevationInMeters,,
......
49 49
soil_texture,texture,,
50 50
RevisionComments,*RevisionComments,,
51 51
Locality_Description,locality,,"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"
52
topography_desc,*topography_desc,,
53
vegetation_1,*vegetation_1,,
54
vegetation_2,*vegetation_2,,
52
topography_desc,landform,,
53
vegetation_1,communityID,/_alt/2,Second because less detailed than vegetation_2
54
vegetation_2,communityID,/_alt/1,
55 55
Habitat,habitat,,
56
life_zone_code,communityID,,
57
life_zone,communityName,,
56
life_zone_code,communityID,/_alt/4,
57
life_zone,communityID,/_alt/3,
58 58
PlotMethod,samplingProtocol,,
59 59
plot_area_ha,plotArea_ha,,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
60 60
recensused,*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 62
date_finish,endDate,,
63 63
plot_administrator,*plot_administrator,,
64 64
plot_notes,plotNotes,,
65
tmp_del,*tmp_del,,
66
Country_index,*Country_index,,
67
PrimOwnerID_index,*PrimOwnerID_index,,
68
plot_administrator_index,*plot_administrator_index,,
69
project_id_index,*project_id_index,,
65
tmp_del,*tmp_del,,"3 plots contain ""del"" in this field and 3 in AccessCode"
66
Country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
67
PrimOwnerID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
68
plot_administrator_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
69
project_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
70 70
lookup_MethodCode_Description,observationMeasure,,
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
8 8
Elev,/location/elevation_m/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
9 9
elev_max_m,/location/elevation_m/_alt/2/_avg/max,
10 10
elev_min_m,/location/elevation_m/_alt/2/_avg/min,
11
topography_desc,/location/landform,
11 12
PlotMethod,/location/locationevent/*_id/method/name,
12 13
lookup_MethodCode_Description,/location/locationevent/*_id/method/observationmeasure,
13 14
project_id,/location/locationevent/*_id/project/sourceaccessioncode,
......
17 18
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
18 19
date_finish,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsenddate/_*/date/_alt/1",
19 20
date_start,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/obsstartdate/_*/date/_alt/1",
20
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
21
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
21
vegetation_2,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_alt/1,
22
vegetation_1,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_alt/2,Second because less detailed than vegetation_2
23
life_zone,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_alt/3,
24
life_zone_code,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_alt/4,
22 25
date_finish,/location/locationevent/obsenddate/_*/date/_alt/1,
23 26
date_start,/location/locationevent/obsstartdate/_*/date/_alt/1,
24 27
Precip,/location/locationevent/precipitation_m,
......
46 49
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
47 50
LatDec,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
48 51
LongDec,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
52
lat_string,/location/locationplace/*_id/place/*_id/coordinates/verbatimlatitude,
53
long_string,/location/locationplace/*_id/place/*_id/coordinates/verbatimlongitude,
49 54
MajorGeo,/location/locationplace/*_id/place/continent,
50 55
Country,/location/locationplace/*_id/place/country,
51 56
pol2,/location/locationplace/*_id/place/county,Brad: No pol2=countyParish
......
60 65
slope_gradient,/location/slopegradient_fraction/_alt/1,
61 66
PlotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
62 67
SiteCode,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
63
AccessCode,,** No join mapping for *AccessCode ** 
64
Country_index,,** No join mapping for *Country_index ** 
68
AccessCode,,"** No join mapping for *AccessCode ** 3 plots contain 3 in this field and ""del"" in tmp_del"
69
Country_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
65 70
ElevSource,,** No join mapping for *ElevSource ** 
66
MethodCode,,** No join mapping for *MethodCode ** 
71
MethodCode,,** No non-empty join mapping for OMIT ** Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
67 72
PrecipSource,,** No join mapping for *PrecipSource ** 
68 73
PrimOwnerID,,** No join mapping for *PrimOwnerID ** 
69
PrimOwnerID_index,,** No join mapping for *PrimOwnerID_index ** 
74
PrimOwnerID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
70 75
RevisionComments,,** No join mapping for *RevisionComments ** 
71 76
SiteName,,** No join mapping for *SiteName ** 
72 77
TempSource,,** No join mapping for *TempSource ** 
73 78
bearing,,** No join mapping for *bearing ** 
74
lat_long_accuracy,,** No join mapping for *lat_long_accuracy ** 
75
lat_string,,** No join mapping for *lat_string ** 
76
long_string,,** No join mapping for *long_string ** 
79
lat_long_accuracy,,"** No join mapping for *lat_long_accuracy ** Plain text description of accuracy, not numeric"
77 80
new_world,,** No join mapping for *new_world ** 
78 81
orig_filename,,** No join mapping for *orig_filename ** 
79 82
plot_administrator,,** No join mapping for *plot_administrator ** 
80
plot_administrator_index,,** No join mapping for *plot_administrator_index ** 
83
plot_administrator_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
81 84
pol1_type,,** No join mapping for *pol1_type ** 
82 85
pol2_type,,** No join mapping for *pol2_type ** 
83
project_id_index,,** No join mapping for *project_id_index ** 
86
project_id_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
84 87
recensused,,"** No join mapping for *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"
85
tmp_del,,** No join mapping for *tmp_del ** 
86
topography_desc,,** No join mapping for *topography_desc ** 
87
vegetation_1,,** No join mapping for *vegetation_1 ** 
88
vegetation_2,,** No join mapping for *vegetation_2 ** 
88
tmp_del,,"** No join mapping for *tmp_del ** 3 plots contain ""del"" in this field and 3 in AccessCode"
inputs/SALVIAS/plotMetadata_/test.xml.ref
18 18
                        </2>
19 19
                    </_alt>
20 20
                </elevation_m>
21
                <landform>$topography_desc</landform>
21 22
                <locationevent>
22 23
                    <method_id>
23 24
                        <method>
......
30 31
                        <commdetermination>
31 32
                            <commconcept_id>
32 33
                                <commconcept>
33
                                    <commname_id><commname><commname>$life_zone_code</commname></commname></commname_id>
34
                                    <commdescription>$life_zone</commdescription>
34
                                    <commname_id>
35
                                        <commname>
36
                                            <commname>
37
                                                <_alt>
38
                                                    <1>$vegetation_2</1>
39
                                                    <2>$vegetation_1</2>
40
                                                    <3>$life_zone</3>
41
                                                    <4>$life_zone_code</4>
42
                                                </_alt>
43
                                            </commname>
44
                                        </commname>
45
                                    </commname_id>
35 46
                                </commconcept>
36 47
                            </commconcept_id>
37 48
                        </commdetermination>
......
110 121
                                            <value>$LongDec</value>
111 122
                                        </_nullIf>
112 123
                                    </longitude_deg>
124
                                    <verbatimlatitude>$lat_string</verbatimlatitude>
125
                                    <verbatimlongitude>$long_string</verbatimlongitude>
113 126
                                </coordinates>
114 127
                            </coordinates_id>
115 128
                            <continent>$MajorGeo</continent>
inputs/SALVIAS/plotMetadata_/new_terms.csv
1
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
1 2
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
2 3
MajorGeo,continent,,
3 4
PolDiv1,stateProvince,,Brad: No; pol1=stateProvince
4 5
pol2,county,,Brad: No pol2=countyParish
6
lat_string,verbatimLatitude,,
7
long_string,verbatimLongitude,,
5 8
LatDec,decimalLatitude,,
6 9
LongDec,decimalLongitude,,
7 10
Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
......
22 25
soil_conductivity,conductivity,,
23 26
soil_texture,texture,,
24 27
Locality_Description,locality,,"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"
25
life_zone_code,communityID,,
26
life_zone,communityName,,
28
topography_desc,landform,,
29
vegetation_1,communityID,/_alt/2,Second because less detailed than vegetation_2
30
vegetation_2,communityID,/_alt/1,
31
life_zone_code,communityID,/_alt/4,
32
life_zone,communityID,/_alt/3,
27 33
PlotMethod,samplingProtocol,,
28 34
date_start,startDate,,
29 35
date_finish,endDate,,
36
Country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
37
PrimOwnerID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
38
plot_administrator_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
39
project_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
30 40
lookup_MethodCode_Description,observationMeasure,,
inputs/SALVIAS/plotMetadata_/unmapped_terms.csv
1
*MethodCode
2 1
*orig_filename
3 2
*AccessCode
4 3
*PrimOwnerID
......
6 5
*new_world
7 6
*pol1_type
8 7
*pol2_type
9
*lat_string
10
*long_string
11 8
*lat_long_accuracy
12 9
*ElevSource
13 10
*PrecipSource
14 11
*TempSource
15 12
*bearing
16 13
*RevisionComments
17
*topography_desc
18
*vegetation_1
19
*vegetation_2
20 14
*recensused
21 15
*plot_administrator
22 16
*tmp_del
23
*Country_index
24
*PrimOwnerID_index
25
*plot_administrator_index
26
*project_id_index

Also available in: Unified diff