Project

General

Profile

« Previous | Next » 

Revision 7201

Added by Aaron Marcuse-Kubitza about 12 years ago

*/new_terms.csv, */unmapped_terms.csv: Regenerated using `make missing_mappings`

View differences:

inputs/VegBank/unmapped_terms.csv
1 
Division
2 
Geographic Name
3 
Subclass
4 
Subdivision
5 
Subkingdom
6 
Superdivision
7 
accessioncode
8 
authordatum
9 
authore
10 
authorlocation
11 
authorn
12 
authorzone
13 
autotaxoncover
14 
azimuth
15 
basalarea
16 
bryophytequality
17 
collectionnumber
18 
collector_id
19 
confidentialityreason
20 
confidentialitystatus
21 
coverdispersion
22 
covermethod_id
23 
currentinterpretation
24 
d_currentaccepted
25 
d_obscount
26 
dateaccuracy
27 
dateentered
28 
dominantstratum
29 
dsgpoly
30 
effortlevel
31 
elevationaccuracy
32 
emb_observation
33 
emb_plot
34 
emb_soilobs
35 
emb_taxoninterpretation
36 
emb_taxonobservation
37 
fieldcover
38 
fieldht
39 
floatingcover
40 
floristicquality
41 
grouptype
42 
growthform1cover
43 
growthform1type
44 
growthform2cover
45 
growthform2type
46 
growthform3cover
47 
growthform3type
48 
homogeneity
49 
hydrologicregime
50 
int_currplantcode
51 
int_currplantcommon
52 
int_currplantconcept_id
53 
int_currplantscifull
54 
int_currplantscinamenoauth
55 
int_origplantcode
56 
int_origplantcommon
57 
int_origplantconcept_id
58 
int_origplantscifull
59 
int_origplantscinamenoauth
60 
interp_bestfit_cc_id
61 
interp_bestfit_ci_id
62 
interp_bestfit_code
63 
interp_bestfit_party_id
64 
interp_bestfit_partyname
65 
interp_bestfit_sciname
66 
interp_current_cc_id
67 
interp_current_ci_id
68 
interp_current_code
69 
interp_current_party_id
70 
interp_current_partyname
71 
interp_current_sciname
72 
interp_orig_cc_id
73 
interp_orig_ci_id
74 
interp_orig_code
75 
interp_orig_party_id
76 
interp_orig_partyname
77 
interp_orig_sciname
78 
interpretationtype
79 
landscapenarrative
80 
layoutnarrative
81 
lichenquality
82 
museum_id
83 
nameother
84 
nonvascularcover
85 
nonvascularht
86 
notesmgt
87 
notespublic
88 
numberoftaxa
89 
observationnarrative
90 
organicdepth
91 
originaldata
92 
originalinterpretation
93 
party_id
94 
percentbaresoil
95 
percentbedrock
96 
percentlitter
97 
percentother
98 
percentrockgravel
99 
percentwater
100 
percentwood
101 
permanence
102 
phenologicaspect
103 
placementmethod
104 
plantcode
105 
plantconcept_accessioncode
106 
plantconcept_id
107 
plantconcept_reference_id
108 
plantdescription
109 
plantname
110 
plantname_id
111 
plotrationalenarrative
112 
plotvalidationlevel
113 
previousobs_id
114 
quadrangle
115 
reference_id
116 
representativeness
117 
revisions
118 
rocktype
119 
role_id
120 
row_num
121 
shoredistance
122 
shrubcover
123 
shrubht
124 
soilcoarse
125 
soilcolor
126 
soildepth
127 
soildepthbottom
128 
soildepthtop
129 
soildescription
130 
soildrainage
131 
soilhorizon
132 
soilmoistureregime
133 
soilobs_id
134 
soiltaxon_id
135 
soiltaxonsrc
136 
standmaturity
137 
standsize
138 
stemlocation_id
139 
stemobservationarea
140 
stemsamplemethod
141 
stemsizelimit
142 
stratummethod_id
143 
submergedcover
144 
submergedht
145 
submitter_email
146 
submitter_givenname
147 
submitter_surname
148 
successionalstatus
149 
surficialdeposits
150 
taxonconfidence
151 
taxoninferencearea
152 
taxoninterpretation_accessioncode
153 
taxoninterpretation_id
154 
taxoninterpretation_plantname_id
155 
taxonobservation_accessioncode
156 
taxonobservation_reference_id
157 
taxonobservationarea
158 
topoposition
159 
toptaxon1name
160 
toptaxon2name
161 
toptaxon3name
162 
toptaxon4name
163 
toptaxon5name
164 
totalcover
165 
treecover
166 
treeht
167 
waterdepth
168 
watersalinity
1 
*Division
2 
*Geographic Name
3 
*Subclass
4 
*Subdivision
5 
*Subkingdom
6 
*Superdivision
7 
*accessioncode
8 
*authordatum
9 
*authore
10 
*authorlocation
11 
*authorn
12 
*authorzone
13 
*autotaxoncover
14 
*azimuth
15 
*basalarea
16 
*biomass
17 
*bryophytequality
18 
*collectionnumber
19 
*collector_id
20 
*confidentialityreason
21 
*contactinstructions
22 
*covercode
23 
*coverdispersion
24 
*covermethod_id
25 
*currentinterpretation
26 
*currentname_id
27 
*d_currentaccepted
28 
*d_obscount
29 
*dateaccuracy
30 
*dateentered
31 
*dominantstratum
32 
*dsgpoly
33 
*effortlevel
34 
*elevationaccuracy
35 
*email
36 
*emb_observation
37 
*emb_plot
38 
*emb_soilobs
39 
*emb_stemcount
40 
*emb_stemlocation
41 
*emb_taxonimportance
42 
*emb_taxoninterpretation
43 
*emb_taxonobservation
44 
*fieldcover
45 
*fieldht
46 
*floatingcover
47 
*floristicquality
48 
*grouptype
49 
*growthform1cover
50 
*growthform1type
51 
*growthform2cover
52 
*growthform2type
53 
*growthform3cover
54 
*growthform3type
55 
*homogeneity
56 
*hydrologicregime
57 
*inferencearea
58 
*int_currplantcode
59 
*int_currplantcommon
60 
*int_currplantconcept_id
61 
*int_currplantscifull
62 
*int_currplantscinamenoauth
63 
*int_origplantcode
64 
*int_origplantcommon
65 
*int_origplantconcept_id
66 
*int_origplantscifull
67 
*int_origplantscinamenoauth
68 
*interp_bestfit_cc_id
69 
*interp_bestfit_ci_id
70 
*interp_bestfit_code
71 
*interp_bestfit_party_id
72 
*interp_bestfit_partyname
73 
*interp_bestfit_sciname
74 
*interp_current_cc_id
75 
*interp_current_ci_id
76 
*interp_current_code
77 
*interp_current_party_id
78 
*interp_current_partyname
79 
*interp_current_sciname
80 
*interp_orig_cc_id
81 
*interp_orig_ci_id
82 
*interp_orig_code
83 
*interp_orig_party_id
84 
*interp_orig_partyname
85 
*interp_orig_sciname
86 
*landscapenarrative
87 
*layoutnarrative
88 
*lichenquality
89 
*middlename
90 
*museum_id
91 
*nameother
92 
*nonvascularcover
93 
*nonvascularht
94 
*notesmgt
95 
*notespublic
96 
*numberoftaxa
97 
*observationnarrative
98 
*organicdepth
99 
*organizationname
100 
*originaldata
101 
*originalinterpretation
102 
*party_d_obscount
103 
*party_id
104 
*partypublic
105 
*partytype
106 
*percentbaresoil
107 
*percentbedrock
108 
*percentlitter
109 
*percentother
110 
*percentrockgravel
111 
*percentwater
112 
*percentwood
113 
*permanence
114 
*phenologicaspect
115 
*placementmethod
116 
*plantcode
117 
*plantconcept_accessioncode
118 
*plantconcept_id
119 
*plantconcept_reference_id
120 
*plantdescription
121 
*plantname
122 
*plantname_id
123 
*plotrationalenarrative
124 
*plotvalidationlevel
125 
*previousobs_id
126 
*quadrangle
127 
*reference_id
128 
*representativeness
129 
*revisions
130 
*rocktype
131 
*role_id
132 
*salutation
133 
*shoredistance
134 
*shrubcover
135 
*shrubht
136 
*soilcoarse
137 
*soilcolor
138 
*soildepth
139 
*soildepthbottom
140 
*soildepthtop
141 
*soildescription
142 
*soildrainage
143 
*soilhorizon
144 
*soilmoistureregime
145 
*soilobs_id
146 
*soiltaxon_id
147 
*soiltaxonsrc
148 
*standmaturity
149 
*standsize
150 
*stemdiameteraccuracy
151 
*stemhealth
152 
*stemheightaccuracy
153 
*stemlocation_id
154 
*stemobservationarea
155 
*stemsamplemethod
156 
*stemsizelimit
157 
*stemtaxonarea
158 
*stratum_id
159 
*stratumbase
160 
*stratumheight
161 
*stratummethod_id
162 
*submergedcover
163 
*submergedht
164 
*submitter_email
165 
*submitter_givenname
166 
*submitter_surname
167 
*successionalstatus
168 
*surficialdeposits
169 
*taxonconfidence
170 
*taxoninferencearea
171 
*taxoninterpretation_accessioncode
172 
*taxoninterpretation_id
173 
*taxoninterpretation_party_id
174 
*taxoninterpretation_plantname_id
175 
*taxonobservation_accessioncode
176 
*taxonobservation_reference_id
177 
*taxonobservationarea
178 
*topoposition
179 
*toptaxon1name
180 
*toptaxon2name
181 
*toptaxon3name
182 
*toptaxon4name
183 
*toptaxon5name
184 
*totalcover
185 
*treecover
186 
*treeht
187 
*waterdepth
188 
*watersalinity
189 
interpretationType
inputs/MT/unmapped_terms.csv
1 1 
basisOfRecord
2 2 
countryCode
3 3 
datasetName
4 
dcterms:language
5 
dcterms:rights
6 
dcterms:rightsHolder
7 
dcterms:type
4 
language
8 5 
occurrenceRemarks
6 
rightsHolder
7 
type
inputs/XAL/new_terms.csv
5 5 
darwin:Collector,recordedBy,,
6 6 
darwin:CollectorNumber,recordNumber,,
7 7 
darwin:ContinentOcean,continent,,
8 
darwin:CoordinatePrecision,coordinatePrecision,,
8 
darwin:CoordinatePrecision,UNUSED,,
9 9 
darwin:Country,country,,
10 10 
darwin:County,county,,
11 
darwin:DateLastModified,dcterms:modified,,
11 
darwin:DateLastModified,modified,,
12 12 
darwin:DayCollected,dayCollected,,
13 13 
darwin:DayIdentified,dayIdentified,,
14 14 
darwin:Family,family,,
15 
darwin:FieldNumber,UNUSED,,"`grep -F ""<darwin:FieldNumber>"" inputs/XAL/src/digir.specimens.xml` returns no lines. This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber)."
15 
darwin:FieldNumber,UNUSED,,This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber).
16 16 
darwin:Genus,genus,,
17 17 
darwin:IdentifiedBy,identifiedBy,,
18 18 
darwin:IndividualCount,individualCount,,
19 19 
darwin:InstitutionCode,institutionCode,,
20 20 
darwin:JulianDay,day,,
21 21 
darwin:Kingdom,kingdom,,
22 
darwin:Latitude,verbatimLatitude,,
22 
darwin:Latitude,decimalLatitude,,
23 23 
darwin:Locality,locality,,
24 
darwin:Longitude,verbatimLongitude,,
24 
darwin:Longitude,decimalLongitude,,
25 25 
darwin:MaximumDepth,maximumDepthInMeters,,
26 26 
darwin:MaximumElevation,maximumElevationInMeters,,
27 27 
darwin:MinimumDepth,minimumDepthInMeters,,
......
35 35 
darwin:PreviousCatalogNumber,otherCatalogNumbers,,
36 36 
darwin:RelatedCatalogItem,relatedResourceID,,
37 37 
darwin:RelationshipType,relationshipOfResource,,
38 
darwin:ScientificName,scientificName,,
38 
darwin:ScientificName,taxonName,,
39 39 
darwin:ScientificNameAuthor,scientificNameAuthorship,,
40 40 
darwin:Sex,sex,,
41 41 
darwin:Species,specificEpithet,,
inputs/XAL/unmapped_terms.csv
1 1 
basisOfRecord
2 2 
day
3 
dcterms:modified
4 3 
eventTime
4 
modified
5 5 
otherCatalogNumbers
6 6 
preparations
7 7 
relatedResourceID
inputs/NCU/new_terms.csv
1 
Accession Number,occurrenceID,,
2 
Accuracy,coordinateUncertaintyInMeters,,
3 
Barcode,catalogNumber,,
4 
Collect Date,dateCollected,,
5 
Format,preparations,,
6 
Full Taxon Name,scientificName,,
7 
Lat (-=S),verbatimLatitude,"/_replace:[""\?$""=]/value",
8 
Long (-=W),verbatimLongitude,"/_replace:[""\?$""=]/value",
9 
SeriesName,collectionCode,,
10 
Typology,typeStatus,,
1 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
2 
CatalogSeriesPrefix,institutionCode,/_alt/1,
3 
CityLocality,verbatimLocality,/_alt/2,
4 
CollectionDate,dateCollected,,
5 
CollectionGUID,collectionID,,
6 
CurrentScientificName,taxonName,,
7 
CurrentScientificNameWithAuthor,scientificName,,
8 
Description,fieldNotes,,
9 
Latitude1,decimalLatitude,,
10 
Loc_AltE,verbatimLongitude,,
11 
Loc_AltN,verbatimLatitude,,
12 
Longitude1,decimalLongitude,,
13 
OriginalTaxonLabel,originalScientificName,,
14 
OwnerInstitution,institutionCode,/_alt/2,
15 
SpecimenPK,occurrenceID,,
16 
firstCollectorName,recordedBy,,
17 
firstCollectorRemarks,recordNumber,,"Actually the collector's number, not remarks"
inputs/NCU/unmapped_terms.csv
1 
Alt E/W
2 
Alt N/S
3 
FIPS
4 
preparations
1 
*BlockLocationReason
2 
*BlockSpecificLocation
3 
*CollectionObjectID
4 
*CollectionObjectTypeID
5 
*DerivedFromID
6 
*FIPSStateCounty
7 
*LandOwner
8 
*LastAnnotationDateVerbatim
9 
*LastAnnotationLabelTaxon
10 
*LastAnnotationRemarks
11 
*database
12 
*lastAnnotationAgent
13 
eventRemarks
5 14 
typeStatus
inputs/TEAM/new_terms.csv
1 
1ha Plot Number,plotName,,
2 
1ha Plot X Coordinate,organismX,,
3 
1ha Plot Y Coordinate,organismY,,
1 
1ha Plot Number,locationName,,
2 
1ha Plot X Coordinate,organismX_m,,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
3 
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
4 4 
CollectionDate,eventDate,,
5 5 
Diameter at 1.3m,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
6 6 
Diameter,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
7 
Method,samplingProtocol,,
8 
Name,plotName,,
7 
Method,OMIT,,"Just contains ""Derived"", for 357 rows"
8 
Name,locationName,,
9 9 
Names of Collectors,recordedBy,,
10 10 
Observation Date,eventDate,,
11 11 
Site Name,projectName,,
12 
Spatial Method,samplingProtocol,,
12 
Spatial Method,OMIT,,"Just contains ""Derived"", for 14927 rows"
13 13 
Subplot Number,subplot,,
14 14 
Tree Number,tag,,
inputs/TEAM/unmapped_terms.csv
1 
1ha Plot Coordinate
2 
Comments
3 
Condition Codes
4 
Data Level
5 
Data Set Contact
6 
Data Set Creator Institution
7 
Data Set Creator Scientist
8 
Location Codes
9 
Max Diameter
10 
Max Diameter POM
11 
New Diameter
12 
New POM Height
13 
POM Height
14 
Protocol Version
15 
Sampling Period
16 
Sampling Unit Name
1 
*1ha Plot Coordinate
2 
*Comments
3 
*Condition Codes
4 
*Data Level
5 
*Data Set Contact
6 
*Data Set Creator Institution
7 
*Data Set Creator Scientist
8 
*Location Codes
9 
*Max Diameter
10 
*Max Diameter POM
11 
*New Diameter
12 
*New POM Height
13 
*POM Height
14 
*Protocol Version
15 
*Sampling Period
16 
*Sampling Unit Name
inputs/ACAD/unmapped_terms.csv
1 1 
basisOfRecord
2 
dcterms:bibliographicCitation
3 
dcterms:language
4 
dcterms:modified
5 
dcterms:rights
6 
dcterms:rightsHolder
7 
dcterms:type
2 
bibliographicCitation
8 3 
dynamicProperties
9 4 
geodeticDatum
10 5 
georeferenceSources
11 6 
georeferenceVerificationStatus
12 7 
identificationRemarks
8 
language
13 9 
locationRemarks
10 
modified
14 11 
municipality
15 12 
occurrenceRemarks
16 13 
ownerInstitutionCode
17 14 
reproductiveCondition
15 
rightsHolder
16 
type
18 17 
verbatimDepth
inputs/CTFS/new_terms.csv
2 2 
MeasureID,individualID,,
3 3 
SizeOfSite,plotArea_ha,,"""Size in hectares"" (SizeOfSite comments in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>)"
4 4 
SpeciesAuthority,scientificNameAuthorship,,
5 
x,organismX,,
6 
y,organismY,,
5 
x,organismX_m,,"Assuming units based on the size of values relative to plot area, which has units of ha. Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>."
6 
y,organismY_m,,"Assuming units based on the size of values relative to plot area, which has units of ha. Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>."
inputs/CTFS/unmapped_terms.csv
1 
CountryID
2 
Description
3 
DimX
4 
DimY
5 
ExactDate
6 
FamilyID
7 
FieldFamily
8 
GenusAuthority
9 
GenusID
10 
GenusReferenceID
11 
HOM
12 
IDLevel
13 
InfraSpecificLevel
14 
PrimaryStem
15 
ReferenceID
16 
ReferenceX
17 
ReferenceY
18 
SpeciesAuthority
19 
SpeciesCurrentTaxonFlag
20 
SpeciesID
21 
SpeciesMnemonic
22 
SpeciesObsoleteTaxonFlag
23 
SpeciesReferenceID
24 
StemDescription
25 
SubSpeciesAuthority
26 
SubSpeciesCurrentTaxonFlag
27 
SubSpeciesID
28 
SubSpeciesMnemonic
29 
SubSpeciesObsoleteTaxonFlag
30 
TreeID
31 
row_num
1 
*CountryID
2 
*Description
3 
*DimX
4 
*DimY
5 
*ExactDate
6 
*FamilyID
7 
*FieldFamily
8 
*GenusAuthority
9 
*GenusID
10 
*GenusReferenceID
11 
*HOM
12 
*IDLevel
13 
*InfraSpecificLevel
14 
*PrimaryStem
15 
*ReferenceID
16 
*ReferenceX
17 
*ReferenceY
18 
*SpeciesCurrentTaxonFlag
19 
*SpeciesID
20 
*SpeciesMnemonic
21 
*SpeciesObsoleteTaxonFlag
22 
*SpeciesReferenceID
23 
*StemDescription
24 
*SubSpeciesAuthority
25 
*SubSpeciesCurrentTaxonFlag
26 
*SubSpeciesID
27 
*SubSpeciesMnemonic
28 
*SubSpeciesObsoleteTaxonFlag
29 
*TreeID
inputs/SALVIAS/new_terms.csv
1 1 
-----
2 2 
-----"
3 
AccessCode,accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
4 
Country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
3 5 
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."
4 6 
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.
5 7 
FROM ""SALVIAS"".organisms
6 8 
GROUP BY ""PlotID"", ""Line""
7 9 
HAVING count(DISTINCT census_date) > 1
8 
Ind,recordNumber,,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
10 
Ind,individualCode,,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
9 11 
LatDec,decimalLatitude,,
10 12 
Line,subplot,,
11 13 
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"
12 14 
LongDec,decimalLongitude,,
13 15 
MajorGeo,continent,,
16 
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
14 17 
NoInd,individualCount,,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
15 18 
NoInd,stemCount,,
16 
OrigFamily,verbatimFamily,,Brad: OMIT
17 
OrigGenus,verbatimGenus,,
18 
OrigSpecies,verbatimSpecificEpithet,,Brad: OMIT
19 
PlotCode,plotName,,
19 
OrigFamily,originalFamily,,Brad: OMIT
20 
OrigGenus,originalGenus,,
21 
OrigSpecies,originalSpecificEpithet,,Brad: OMIT
22 
PlotCode,locationName,,
23 
PlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
20 24 
PlotMethod,samplingProtocol,,
21 25 
PlotObsID,individualID,,
22 26 
PlotObsID,individualID,,"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."
23 27 
PolDiv1,stateProvince,,Brad: No; pol1=stateProvince
24 28 
Precip,precipitation,,
29 
PrimOwnerID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
25 30 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
26 
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
27 
SourceVoucher,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
31 
SiteCode,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
32 
SourceVoucher,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
28 33 
Temp,temperature,,
29 34 
WHERE ""Line"" IS NOT NULL AND census_date IS NOT NULL
30 35 
auth,scientificNameAuthorship,,Brad: This is the author of the scientificName.
......
32 37 
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
33 38 
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."
34 39 
cfaff,identificationQualifier,,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
35 
clay_percent,clay,"/_units:[default=""%"",to=]/value",
36 
coll_firstname,recordedBy.givenName,,Brad: See comment above
37 
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."
38 
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string
40 
coll_firstname,recordedBy_givenName,,Brad: See comment above
41 
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."
42 
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string
39 43 
date_finish,endDate,,
40 44 
date_start,startDate,,
45 
det_by,identifiedBy,,
41 46 
elev_max_m,maximumElevationInMeters,,
42 47 
elev_min_m,minimumElevationInMeters,,
48 
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
49 
gen_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
43 50 
gentry_dbh,diameterBreastHeightGentry,,
44 
height_m,height,,
45 51 
ht_first_branch_m,heightFirstBranch,,
46 52 
infra_ep_1,infraspecificEpithet,,
47 53 
infra_rank_1,taxonRank,,
48 
life_zone,communityName,,
49 
life_zone_code,communityID,,
50 
organic_percent,organic,"/_units:[default=""%"",to=]/value",
54 
lat_string,verbatimLatitude,,
55 
life_zone,communityID,/_alt/3,
56 
life_zone_code,communityID,/_alt/4,
57 
long_string,verbatimLongitude,,
58 
lookup_MethodCode_Description,observationMeasure,,
59 
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."
60 
plot_administrator_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
61 
plotobs_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
51 62 
pol2,county,,Brad: No pol2=countyParish
52 
sand_percent,sand,"/_units:[default=""%"",to=]/value",
53 
silt_percent,silt,"/_units:[default=""%"",to=]/value",
54 
soil_C,carbon,"/_units:[default=""%"",to=]/value",
55 
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",
56 
soil_K,potassium,"/_units:[default=""%"",to=]/value",
57 
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",
58 
soil_N,nitrogen,"/_units:[default=""%"",to=]/value",
59 
soil_Na,sodium,"/_units:[default=""%"",to=]/value",
60 
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",
61 
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",
62 
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",
63 
soil_cation_cap,cationExchangeCapacity,,
63 
project_id_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
64 
soil_C,carbon_percent,,Assuming units are % based on the range of values
65 
soil_Ca,calcium_percent,,Assuming units are % based on the range of values
66 
soil_K,potassium_percent,,Assuming units are % based on the range of values
67 
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values
68 
soil_N,nitrogen_percent,,Assuming units are % based on the range of values
69 
soil_Na,sodium_percent,,Assuming units are % based on the range of values
70 
soil_P,phosphorus_percent,"/_map:[""<1,5""=0,*=*]/value",Assuming units are % based on the range of values
71 
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values
72 
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values
73 
soil_cation_cap,cationExchangeCapacity_cmol_kg,,
64 74 
soil_conductivity,conductivity,,
65 
soil_texture,texture,"/_units:[default=""%"",to=]/value",
75 
soil_texture,texture,,
66 76 
stem_canopy_form,canopyForm,,
67 77 
stem_canopy_position,canopyPosition,,
68 78 
stem_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for plotObservations.intercept_cm, which measures the same dimension"
69 79 
stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."
70 
stem_height_m,height,,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."
80 
stem_height_m,height_m,,"""Total height of this stem only, in meters"" (stem_height_m definition at < http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: Same as for height, but applies to individuals stems, not trees. Rare."
71 81 
stem_liana_infestation,lianaInfestation,,
72 82 
stem_tag1,tag,/_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."
73 83 
stem_tag2,tag,/_alt/1,"The second tag supercedes the first. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
74 84 
tag1,tag,/_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."
75 85 
tag2,tag,/_alt/1,"The second tag supercedes the first. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
76 86 
temp_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"
77 
x_position,organismX,,"Brad: These are important, fundamental values of many tree plots"
78 
y_position,organismY,,Brad: See comment above for x_position
87 
tmp_PlotObsID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
88 
tmp_del_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
89 
topography_desc,landform,,
90 
vegetation_1,communityID,/_alt/2,Second because less detailed than vegetation_2
91 
vegetation_2,communityID,/_alt/1,
92 
x_position,organismX_m,,"""x coordinate in meters"" (x_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: These are important, fundamental values of many tree plots"
93 
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"
inputs/SALVIAS/unmapped_terms.csv
1 
AccessCode
2 
Country_index
3 
ElevSource
4 
GenAuth
5 
IsMorpho
6 
MethodCode
7 
OrigAuth
8 
OrigRecordID
9 
PlotID_index
10 
PrecipSource
11 
PrimOwnerID
12 
PrimOwnerID_index
13 
RevisionComments
14 
SiteName
15 
SpAuthStatus
16 
TempSource
17 
allow_download_all
18 
bearing
19 
coll_inits
20 
collector_code
21 
common_name
22 
det_by
23 
dist
24 
fam_status
25 
gen_status
26 
height_class
27 
height_m_commercial
28 
ind_id
29 
infra_auth_1
30 
ipr_specific
31 
ipr_specific_updated
32 
lat_long_accuracy
33 
lat_string
34 
long_string
35 
morphocf
36 
morphoname
37 
name_status
38 
new_world
39 
on_project_list_index
40 
orig_filename
41 
origrecord_id_stems
42 
other_annotations
43 
perp_dist
44 
phenology
45 
plot_administrator
46 
plot_administrator_index
47 
plotobs_id_index
48 
pol1_type
49 
pol2_type
50 
project_distinct_index
51 
project_id_index
52 
project_name_index
53 
project_pi
54 
recensused
55 
species_code
56 
temp_liandbh
57 
tmp_del
58 
topography_desc
59 
vegetation_1
60 
vegetation_2
1 
*ElevSource
2 
*GenAuth
3 
*IsMorpho
4 
*OrigAuth
5 
*OrigRecordID
6 
*PrecipSource
7 
*PrimOwnerID
8 
*RevisionComments
9 
*SiteName
10 
*SpAuthStatus
11 
*TempSource
12 
*allow_download_all
13 
*bearing
14 
*coll_inits
15 
*collector_code
16 
*common_name
17 
*dist
18 
*height_class
19 
*height_m_commercial
20 
*ind_id
21 
*infra_auth_1
22 
*ipr_specific
23 
*ipr_specific_updated
24 
*lat_long_accuracy
25 
*morphocf
26 
*new_world
27 
*on_project_list_index
28 
*orig_filename
29 
*origrecord_id_stems
30 
*other_annotations
31 
*perp_dist
32 
*phenology
33 
*plot_administrator
34 
*pol1_type
35 
*pol2_type
36 
*project_distinct_index
37 
*project_name_index
38 
*project_pi
39 
*recensused
40 
*species_code
41 
*temp_liandbh
42 
*tmp_PlotObsID
43 
*tmp_del
inputs/U/unmapped_terms.csv
1 
Alt
2 
Alt2
3 
Coorsyst
4 
EW
5 
Majorarea
6 
NS
1 
*Alt
2 
*Alt2
3 
*Coorsyst
4 
*EW
5 
*Majorarea
6 
*NS
7 7 
reproductiveCondition
inputs/GBIF/new_terms.csv
1 1 
AuthorOfScientificName,scientificNameAuthorship,,
2 2 
CatalogNO,catalogNumber,,
3 3 
CollectionCD,collectionCode,,
4 
GBIFFamilyOriginal,verbatimFamily,,
5 
GBIFGenusOriginal,verbatimGenus,,
4 
GBIFFamilyOriginal,originalFamily,,
5 
GBIFGenusOriginal,originalGenus,,
6 6 
InstitutionCD,institutionCode,,
7 
LastDateModified,dcterms:modified,,
7 
LastDateModified,modified,,
8 8 
LatestDateCollected,dateCollected,,
9 9 
MaximumElevationInMeter,maximumElevationInMeters,,
10 10 
MinimumElevationInMeter,minimumElevationInMeters,,
11 
ScientificNameOriginal,verbatimScientificName,,
11 
ScientificNameOriginal,originalTaxonName,,
inputs/GBIF/unmapped_terms.csv
1 
0
2 
1
3 
25
4 
3
5 
OMIT
6 
dcterms:modified
1 
*0
2 
*1
3 
*25
4 
*3
5 
modified
inputs/SpeciesLink/new_terms.csv
13 13 
conceptual_darwin_2003_1_0_CoordinatePrecision,coordinatePrecision,,
14 14 
conceptual_darwin_2003_1_0_Country,country,,
15 15 
conceptual_darwin_2003_1_0_County,county,,
16 
conceptual_darwin_2003_1_0_DateLastModified,dcterms:modified,,
16 
conceptual_darwin_2003_1_0_DateLastModified,modified,,
17 17 
conceptual_darwin_2003_1_0_DayCollected,dayCollected,,
18 18 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
19 19 
conceptual_darwin_2003_1_0_Family,family,,
......
24 24 
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,,
25 25 
conceptual_darwin_2003_1_0_JulianDay,day,/_alt/1,
26 26 
conceptual_darwin_2003_1_0_Kingdom,kingdom,,
27 
conceptual_darwin_2003_1_0_Latitude,verbatimLatitude,,
27 
conceptual_darwin_2003_1_0_Latitude,decimalLatitude,,
28 28 
conceptual_darwin_2003_1_0_Locality,locality,,
29 
conceptual_darwin_2003_1_0_Longitude,verbatimLongitude,,
29 
conceptual_darwin_2003_1_0_Longitude,decimalLongitude,,
30 30 
conceptual_darwin_2003_1_0_MaximumDepth,maximumDepthInMeters,,
31 31 
conceptual_darwin_2003_1_0_MaximumElevation,maximumElevationInMeters,,
32 32 
conceptual_darwin_2003_1_0_MinimumDepth,minimumDepthInMeters,,
......
40 40 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,
41 41 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,
42 42 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,
43 
conceptual_darwin_2003_1_0_ScientificName,scientificName,,
43 
conceptual_darwin_2003_1_0_ScientificName,taxonName,,
44 44 
conceptual_darwin_2003_1_0_ScientificNameAuthor,scientificNameAuthorship,/_alt/2,
45 45 
conceptual_darwin_2003_1_0_Sex,sex,,
46 46 
conceptual_darwin_2003_1_0_Species,specificEpithet,,
......
64 64 
dwc_dwcore_Continent,continent,,
65 65 
dwc_dwcore_Country,country,,
66 66 
dwc_dwcore_County,county,,
67 
dwc_dwcore_DateLastModified,dcterms:modified,,
67 
dwc_dwcore_DateLastModified,modified,,
68 68 
dwc_dwcore_DayOfYear,day,/_alt/2,
69 69 
dwc_dwcore_Family,family,,
70 70 
dwc_dwcore_Genus,genus,,
......
80 80 
dwc_dwcore_Order,order,,
81 81 
dwc_dwcore_Phylum,phylum,,
82 82 
dwc_dwcore_Remarks,taxonRemarks,,
83 
dwc_dwcore_ScientificName,scientificName,,
83 
dwc_dwcore_ScientificName,taxonName,,
84 84 
dwc_dwcore_Sex,sex,,
85 85 
dwc_dwcore_SpecificEpithet,specificEpithet,,
86 86 
dwc_dwcore_StateProvince,stateProvince,,
87 87 
dwc_geospatial_DecimalLatitude,decimalLatitude,,
88 88 
dwc_geospatial_DecimalLongitude,decimalLongitude,,
89 
dwc_geospatial_VerbatimLatitude,verbatimLatitude,,
90 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,,
89 
dwc_geospatial_VerbatimLatitude,verbatimLatitude,,Contains a mix of DMS and other verbatim coordinates
90 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,,Contains a mix of DMS and other verbatim coordinates
91 91 
dwc_terms_basisOfRecord,basisOfRecord,,
92 92 
dwc_terms_catalogNumber,catalogNumber,,
93 93 
dwc_terms_class,class,,
......
124 124 
dwc_terms_preparations,preparations,,
125 125 
dwc_terms_recordNumber,recordNumber,/_alt/1,
126 126 
dwc_terms_recordedBy,recordedBy,,
127 
dwc_terms_scientificName,scientificName,,
127 
dwc_terms_scientificName,taxonName,,
128 128 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
129 129 
dwc_terms_sex,sex,,
130 130 
dwc_terms_specificEpithet,specificEpithet,,
......
134 134 
dwc_terms_verbatimLatitude,verbatimLatitude,,
135 135 
dwc_terms_verbatimLongitude,verbatimLongitude,,
136 136 
dwc_terms_year,year,,
137 
http__purl_org_dc_terms_modified,dcterms:modified,,
137 
http__purl_org_dc_terms_modified,modified,,
inputs/SpeciesLink/unmapped_terms.csv
1 1 
basisOfRecord
2 
coordinatePrecision
2 3 
day
3 
dcterms:modified
4 4 
endDayOfYear
5 5 
eventTime
6 
modified
6 7 
month
7 8 
occurrenceRemarks
8 9 
otherCatalogNumbers
inputs/NY/new_terms.csv
1 
CoordinatePrecision,coordinateUncertaintyInMeters,,"Usage inconsistent with DwC definition, which only allows degrees. Assuming units based on the range and precision of values."
1 2 
PlantFungusDescription,fieldNotes,"/_join/2/_label[label=""plant fungus""]/value",
2 3 
Substrate,locality,"/_join/2/_label[label=""substrate""]/value",
3 
UniqueNYInternalRecordNumber,occurrenceID,,
4 
UniqueNYInternalRecordNumber,OMIT,,"Globally unique when provided, but omitted to avoid confusion since this is an internal-only ID"
4 5 
Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",
5 6 
key,OMIT,,UniqueNYInternalRecordNumber is a better pkey
inputs/NY/unmapped_terms.csv
1 1 
basisOfRecord
2 2 
day
3 
dcterms:modified
4 3 
eventTime
4 
modified
5 5 
otherCatalogNumbers
6 6 
preparations
7 7 
relatedResourceID
inputs/Madidi/new_terms.csv
1 1 

  		




  2
  
  
    
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium,,


  		




  3
  
  
    
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon,,


  		




  4
  
  
    
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium,,


  		




  5
  
  
    
"Materia Orgánica (WSP S-9,10–%–0.1)",organic,,


  		




  6
  
  
    
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium,,


  		




  7
  
  
    
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium,,


  		




  
  2
  
    
"Calcio intercambiable (WSP S-5,10–cmolc/Kg–0.016)",calcium_percent,,Assuming units are % based on the range of values


  		




  
  3
  
    
"Carbón Orgánico (WSP S-9,10–%–0.06)",carbon_percent,,Assuming units are % based on the range of values


  		




  
  4
  
    
"Magnesio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",magnesium_percent,,Assuming units are % based on the range of values


  		




  
  5
  
    
"Materia Orgánica (WSP S-9,10–%–0.1)",organic_percent,,Assuming units are % based on the range of values


  		




  
  6
  
    
"Potasio intercambiable (WSP S-5,10–cmolc/Kg–0.0053)",potassium_percent,,Assuming units are % based on the range of values


  		




  
  7
  
    
"Sodio intercambiable (WSP S-5,10–cmolc/Kg–0.00083)",sodium_percent,,Assuming units are % based on the range of values


  		




  8
  8
  
    
-----


  		




  9
  
  
    
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity,,


  		




  
  9
  
    
Acidez intercambiable (ISRIC 11–cmolc/Kg–0.05),acidity_percent,,Assuming units are % based on the range of values


  		




  10
  10
  
    
Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  11
  
  
    
Arcilla (DIN 18 123–%–1),clay,,


  		




  
  11
  
    
Arcilla (DIN 18 123–%–1),clay_percent,,Assuming units are % based on the range of values


  		




  12
  12
  
    
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"


  		




  13
  
  
    
Arena (DIN 18 123–%–2.5),sand,,


  		




  
  13
  
    
Arena (DIN 18 123–%–2.5),sand_percent,,Assuming units are % based on the range of values


  		




  14
  14
  
    
Autor (revised),scientificNameAuthorship,,


  		




  15
  
  
    
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity,,


  		




  
  15
  
    
CIC (ISRIC 11–cmolc/Kg–0.05),cationExchangeCapacity_cmol_kg,,


  		




  16
  16
  
    
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,


  		




  17
  17
  
    
Determined by,identifiedBy,,


  		




  18
  18
  
    
Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values


  		




  ......




  22
  22
  
    
Expedition,projectName,,


  		




  23
  23
  
    
FROM ""Madidi"".""Plot""


  		




  24
  24
  
    
Family (revised),family,,


  		




  25
  
  
    
Field family,verbatimFamily,,


  		




  26
  
  
    
Field name,verbatimGenus,,Often = Genera


  		




  
  25
  
    
Field family,originalFamily,,


  		




  
  26
  
    
Field name,originalGenus,,Often = Genera


  		




  27
  27
  
    
First evaluation,eventDate,,


  		




  28
  
  
    
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus,,


  		




  
  28
  
    
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values


  		




  29
  29
  
    
GROUP BY ""Altitude""::real , ""Locality""


  		




  30
  30
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  31
  31
  
    
Genera,genus,,


  		




  32
  32
  
    
Index collector,recordedBy,,


  		




  33
  33
  
    
Inventory code,locationID,,


  		




  34
  
  
    
Inventory name,plotName,,


  		




  35
  
  
    
Latitude (DMS),verbatimLatitude,,


  		




  
  34
  
    
Inventory name,locationName,,


  		




  36
  35
  
    
Liana presence,lianaInfestation,,


  		




  37
  
  
    
Limo (DIN 18 123–%–1),silt,,


  		




  
  36
  
    
Limo (DIN 18 123–%–1),silt_percent,,Assuming units are % based on the range of values


  		




  38
  37
  
    
Locality description,communityName,,Often begins with the text in Vegetation type


  		




  39
  
  
    
Longitude (DMS),verbatimLongitude,,


  		




  40
  38
  
    
Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  41
  
  
    
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen,,


  		




  
  39
  
    
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values


  		




  42
  40
  
    
Number of subplot,subplot,,


  		




  43
  41
  
    
ORDER BY ""Altitude""::real DESC


  		




  44
  42
  
    
Observaciones,plotNotes,,


  		




  ......




  48
  46
  
    
SELECT ""Altitude""::real, ""Locality""


  		




  49
  47
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  50
  48
  
    
Slope,slopeGradient,,


  		




  51
  
  
    
Specie+autor,scientificNameWithAuthorship,,


  		




  52
  
  
    
Species and morphotypes,scientificName,,"Contains less than ""Specie+autor"""


  		




  
  49
  
    
Specie+autor,scientificName,,


  		




  
  50
  
    
Species and morphotypes,taxonName,,"Contains less than ""Specie+autor"""


  		




  53
  51
  
    
Specimen,catalogNumber,,


  		




  54
  52
  
    
Tag number,tag,,


  		




  55
  53
  
    
Textural class,texture,,


  		




  56
  54
  
    
Topographical situation,landform,,


  		




  57
  
  
    
Total height,height,,


  		




  58
  
  
    
Tree number,recordNumber,,


  		




  
  55
  
    
Total height,height_m,,Assuming units based on the range and precision of values


  		




  
  56
  
    
Tree number,individualCode,,


  		




  59
  57
  
    
Trunk,authorStemCode,,


  		




  60
  58
  
    
Vegetation type,communityID,,


  		




  61
  59
  
    
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'


  		












  

    
      inputs/Madidi/unmapped_terms.csv
    
  





  1
  
  
    
"Type Inventory (C, PP, TP)"


  		




  2
  
  
    
Basal area


  		




  3
  
  
    
Bole height


  		




  4
  
  
    
Circumference


  		




  5
  
  
    
Collaborators


  		




  6
  
  
    
Common name


  		




  7
  
  
    
Coordinates


  		




  8
  
  
    
Crown position


  		




  9
  
  
    
Crown shape


  		




  10
  
  
    
Expedition specimen


  		




  11
  
  
    
Installed and evaluated by


  		




  12
  
  
    
Inventory number


  		




  13
  
  
    
Number of inventory (expedition)


  		




  14
  
  
    
Number of inventory (general)


  		




  15
  
  
    
Number of stems


  		




  16
  
  
    
Number of trees


  		




  17
  
  
    
Phenology


  		




  18
  
  
    
Plot X


  		




  19
  
  
    
Plot Y


  		




  20
  
  
    
Plot specimen


  		




  21
  
  
    
Project specimen


  		




  22
  
  
    
Related Epilocs


  		




  23
  
  
    
Similar specimen


  		




  24
  
  
    
Soil sample


  		




  
  1
  
    
"*Type Inventory (C, PP, TP)"


  		




  
  2
  
    
*Basal area


  		




  
  3
  
    
*Bole height


  		




  
  4
  
    
*Circumference


  		




  
  5
  
    
*Collaborators


  		




  
  6
  
    
*Common name


  		




  
  7
  
    
*Coordinates


  		




  
  8
  
    
*Crown position


  		




  
  9
  
    
*Crown shape


  		




  
  10
  
    
*Expedition specimen


  		




  
  11
  
    
*Installed and evaluated by


  		




  
  12
  
    
*Inventory number


  		




  
  13
  
    
*Number of inventory (expedition)


  		




  
  14
  
    
*Number of inventory (general)


  		




  
  15
  
    
*Number of stems


  		




  
  16
  
    
*Number of trees


  		




  
  17
  
    
*Phenology


  		




  
  18
  
    
*Plot X


  		




  
  19
  
    
*Plot Y


  		




  
  20
  
    
*Plot specimen


  		




  
  21
  
    
*Project specimen


  		




  
  22
  
    
*Related Epilocs


  		




  
  23
  
    
*Similar specimen


  		




  
  24
  
    
*Soil sample


  		












  

    
      inputs/UNCC/new_terms.csv
    
  





  1
  
  
    
SciName,scientificName,,


  		




  2
  
  
    
accession,occurrenceID,,


  		




  
  1
  
    

  		




  
  2
  
    
-----


  		




  
  3
  
    
-----"


  		




  
  4
  
    
FROM ""UNCC"".""Specimen""


  		




  
  5
  
    
GROUP BY herbarium, accession


  		




  
  6
  
    
HAVING count(*) > 1


  		




  
  7
  
    
SELECT herbarium, accession, count(*)


  		




  
  8
  
    
SciName,taxonName,,


  		




  
  9
  
    
[1] Using the following query:


  		




  
  10
  
    
accession,occurrenceID,,"Globally unique, although occasionally duplicated. [1]


  		




  3
  11
  
    
authors,scientificNameAuthorship,,


  		




  4
  12
  
    
campus,fieldNotes,"/_join/5/_label[label=""campus""]/value",


  		




  5
  13
  
    
collday,dayCollected,,


  		












  

    
      inputs/UNCC/unmapped_terms.csv
    
  





  
  1
  
    
*filler


  		




  1
  2
  
    
associatedMedia


  		




  2
  
  
    
filler


  		




  3
  3
  
    
reproductiveCondition


  		












  

    
      inputs/SALVIAS-CSV/new_terms.csv
    
  





  10
  10
  
    
census_date,eventDate,,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:


  		




  11
  11
  
    
census_no,censusNumber,,"Brad: Assigned by SALVIAS. 1 for first plot, then 2, 3, etc. I can't recall if we even have repeat censuses in SALVIAS. Probably not."


  		




  12
  12
  
    
cf_aff,identificationQualifier,,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."


  		




  13
  
  
    
clay_percent,clay,"/_units:[default=""%"",to=]/value",


  		




  14
  
  
    
coll_firstname,recordedBy.givenName,,Brad: See comment above


  		




  15
  
  
    
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."


  		




  16
  
  
    
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string


  		




  
  13
  
    
coll_firstname,recordedBy_givenName,,Brad: See comment above


  		




  
  14
  
    
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."


  		




  
  15
  
    
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string


  		




  17
  16
  
    
date_finish,endDate,,


  		




  18
  17
  
    
date_start,startDate,,


  		




  19
  18
  
    
det_type,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."


  		




  20
  19
  
    
elev_m,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.


  		




  21
  20
  
    
elev_max_m,maximumElevationInMeters,,


  		




  22
  21
  
    
elev_min_m,minimumElevationInMeters,,


  		




  23
  
  
    
height_m,height,/_alt/2,


  		




  24
  22
  
    
holdridge_life_zone,communityID,,


  		




  25
  23
  
    
ht_first_branch_m,heightFirstBranch,,


  		




  26
  
  
    
individual_code,recordNumber,,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."


  		




  27
  24
  
    
infra_ep_1,infraspecificEpithet,,


  		




  28
  25
  
    
infra_rank_1,taxonRank,,


  		




  29
  26
  
    
lat_decimal,decimalLatitude,,


  		




  ......




  32
  29
  
    
long_decimal,decimalLongitude,,


  		




  33
  30
  
    
major_geo,continent,,


  		




  34
  31
  
    
no_of_individuals,individualCount,,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."


  		




  35
  
  
    
organic_percent,organic,"/_units:[default=""%"",to=]/value",


  		




  36
  
  
    
orig_family,verbatimFamily,,Brad: OMIT


  		




  37
  
  
    
orig_species,verbatimSpecificEpithet,,Brad: OMIT


  		




  38
  
  
    
plot_code,plotName,,


  		




  39
  
  
    
plot_code,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)


  		




  
  32
  
    
orig_family,originalFamily,,Brad: OMIT


  		




  
  33
  
    
orig_species,originalSpecificEpithet,,Brad: OMIT


  		




  
  34
  
    
plot_code,locationName,,


  		




  
  35
  
    
plot_code,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)


  		




  40
  36
  
    
plot_methodology,samplingProtocol,,


  		




  41
  37
  
    
pol1,stateProvince,,Brad: No; pol1=stateProvince


  		




  42
  38
  
    
pol2,county,,Brad: No pol2=countyParish


  		




  43
  39
  
    
precip_mm,precipitation,,


  		




  44
  40
  
    
project,projectName,,


  		




  45
  
  
    
sand_percent,sand,"/_units:[default=""%"",to=]/value",


  		




  46
  
  
    
silt_percent,silt,"/_units:[default=""%"",to=]/value",


  		




  47
  
  
    
soil_C,carbon,"/_units:[default=""%"",to=]/value",


  		




  48
  
  
    
soil_Ca,calcium,"/_units:[default=""%"",to=]/value",


  		




  49
  
  
    
soil_K,potassium,"/_units:[default=""%"",to=]/value",


  		




  50
  
  
    
soil_Mg,magnesium,"/_units:[default=""%"",to=]/value",


  		




  51
  
  
    
soil_N,nitrogen,"/_units:[default=""%"",to=]/value",


  		




  52
  
  
    
soil_Na,sodium,"/_units:[default=""%"",to=]/value",


  		




  53
  
  
    
soil_P,phosphorus,"/_units:[default=""%"",to=]/value/_map:[""<1,5""=0,*=*]/value",


  		




  54
  
  
    
soil_acidity,acidity,"/_units:[default=""%"",to=]/value/_map:[""<0.05""=0,*=*]/value",


  		




  55
  
  
    
soil_base,baseSaturation,"/_units:[default=""%"",to=]/value",


  		




  56
  
  
    
soil_cation_cap,cationExchangeCapacity,,


  		




  
  41
  
    
soil_C,carbon_percent,,Assuming units are % based on the range of values


  		




  
  42
  
    
soil_Ca,calcium_percent,,Assuming units are % based on the range of values


  		




  
  43
  
    
soil_K,potassium_percent,,Assuming units are % based on the range of values


  		




  
  44
  
    
soil_Mg,magnesium_percent,,Assuming units are % based on the range of values


  		




  
  45
  
    
soil_N,nitrogen_percent,,Assuming units are % based on the range of values


  		




  
  46
  
    
soil_Na,sodium_percent,,Assuming units are % based on the range of values


  		




  
  47
  
    
soil_P,phosphorus_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values


  		




  
  48
  
    
soil_acidity,acidity_percent,"/_map:[""<0.05""=0,*=*]/value",Assuming units are % based on the range of values


  		




  
  49
  
    
soil_base,baseSaturation_percent,,Assuming units are % based on the range of values


  		




  
  50
  
    
soil_cation_cap,cationExchangeCapacity_cmol_kg,,


  		




  57
  51
  
    
soil_conductivity,conductivity,,


  		




  58
  52
  
    
soil_texture,texture,,


  		




  59
  53
  
    
specific_authority,scientificNameAuthorship,,Brad: This is the author of the scientificName.


  		




  ......




  61
  55
  
    
stem_canopy_position,canopyPosition,,


  		




  62
  56
  
    
stem_dbh,diameterBreastHeight_cm,,"Assuming units based on the units for intercept_cm, which measures the same dimension"


  		




  63
  57
  
    
stem_height_first_branch_m,heightFirstBranch,,"Brad: Same as for ht_first_branch_m, but applies to individuals stems, not trees. Rare."


  		




  64
  
  
    
stem_height_m,height,/_alt/1,"Brad: Same as for height, but applies to individuals stems, not trees. Rare."


  		




  
  58
  
    
stem_height_m,height_m,/_alt/1,"""Total height of this stem only, in meters"" (stem_height_m definition at < http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: Same as for height, but applies to individuals stems, not trees. Rare."


  		




  65
  59
  
    
stem_liana_infestation,lianaInfestation,,


  		




  66
  60
  
    
stem_tag1,tag,/_alt/1/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Same as tag1 & tag2, but applied to individual stems. I'm still not clear how to distinguish between methods which tag only individuals trees, and those which tag individual stems."


  		




  67
  61
  
    
stem_tag2,tag,/_alt/1/_alt/1,The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: see above


  		




  68
  62
  
    
tag1,tag,/_alt/2/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. 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."


  		




  69
  63
  
    
tag2,tag,/_alt/2/_alt/1,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."


  		




  70
  64
  
    
temp_c,temperature,,


  		




  71
  
  
    
voucher_string,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."


  		




  72
  
  
    
x_position,organismX,,"Brad: These are important, fundamental values of many tree plots"


  		




  73
  
  
    
y_position,organismY,,Brad: See comment above for x_position


  		




  
  65
  
    
voucher_string,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."


  		




  
  66
  
    
x_position,organismX_m,,"""x coordinate in meters"" (x_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: These are important, fundamental values of many tree plots"


  		




  
  67
  
    
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"


  		












  

    
      inputs/SALVIAS-CSV/unmapped_terms.csv
    
  





  1
  
  
    
collector_code


  		




  2
  
  
    
comments


  		




  3
  
  
    
fam_status


  		




  4
  
  
    
gen_status


  		




  5
  
  
    
ind_id


  		




  6
  
  
    
observation_type


  		




  7
  
  
    
recensused


  		




  8
  
  
    
species_status


  		




  
  1
  
    
*collector_code


  		




  
  2
  
    
*comments


  		




  
  3
  
    
*fam_status


  		




  
  4
  
    
*gen_status


  		




  
  5
  
    
*ind_id


  		




  
  6
  
    
*recensused


  		




  
  7
  
    
*species_status


  		












  

    
      inputs/CVS/unmapped_terms.csv
    
  





  1
  
  
    
confidentialityStatus


  		




  
  1
  
    
"?baseSaturation_percent, baseSaturation_fraction"


  		




  
  2
  
    
*COVERMETHOD_ID


  		




  
  3
  
    
*Division


  		




  
  4
  
    
*Geographic Name


  		




  
  5
  
    
*PARTY_ID


  		




  
  6
  
    
*PLANTCONCEPT_ID


  		




  
  7
  
    
*PLANTNAME_ID


  		




  
  8
  
    
*PREVIOUSOBS_ID


  		




  
  9
  
    
*REPLACEMENTPLOT_ID


  		




  
  10
  
    
*ROLE_ID


  		




  
  11
  
    
*River Basin


  		




  
  12
  
    
*SOILOBS_ID


  		




  
  13
  
    
*SOILTAXON_ID


  		




  
  14
  
    
*STRATUMMETHOD_ID


  		




  
  15
  
    
*Subclass


  		




  
  16
  
    
*Subkingdom


  		




  
  17
  
    
*TAXONINTERPRETATION_ID


  		




  
  18
  
    
*USDAPlantsCode


  		




  
  19
  
    
*VascularPlant


  		




  
  20
  
    
*accessionCode


  		




  
  21
  
    
*authorCoordinateType


  		




  
  22
  
    
*authorCoordinateUnits


  		




  
  23
  
    
*authorDatum


  		




  
  24
  
    
*authorE


  		




  
  25
  
    
*authorLocation


  		




  
  26
  
    
*authorN


  		




  
  27
  
    
*authorZone


  		




  
  28
  
    
*autoTaxonCover


  		




  
  29
  
    
*azimuth


  		




  
  30
  
    
*basalArea


  		




  
  31
  
    
*basalarea


  		




  
  32
  
    
*biomass


  		




  
  33
  
    
*bryophyteQuality


  		




  
  34
  
    
*category


  		




  
  35
  
    
*collectionNumber


  		




  
  36
  
    
*collector_ID


  		




  
  37
  
    
*commonName


  		




  
  38
  
    
*composite family


  		




  
  39
  
    
*composite genus


  		




  
  40
  
    
*composite species


  		




  
  41
  
    
*composite variety


  		




  
  42
  
    
*confidentialityFieldsBlocked


  		




  
  43
  
    
*confidentialityReason


  		




  
  44
  
    
*contactInstructions


  		




  
  45
  
    
*coverDispersion


  		




  
  46
  
    
*currentInterpretation


  		




  
  47
  
    
*currentName_ID


  		




  
  48
  
    
*currentTaxonInterpPlantConcept_ID


  		




  
  49
  
    
*cust_cvs_Al_ppm


  		




  
  50
  
    
*cust_cvs_B_ppm


  		




  
  51
  
    
*cust_cvs_Ca_over_Mg_ppm


  		




  
  52
  
    
*cust_cvs_Ca_ppm


  		




  
  53
  
    
*cust_cvs_CanopyHeight


  		




  
  54
  
    
*cust_cvs_CowardinSystem


  		




  
  55
  
    
*cust_cvs_Cu_ppm


  		




  
  56
  
    
*cust_cvs_Density


  		




  
  57
  
    
*cust_cvs_Fe_ppm


  		




  
  58
  
    
*cust_cvs_GPSLocationX


  		




  
  59
  
    
*cust_cvs_GPSLocationY


  		




  
  60
  
    
*cust_cvs_K_ppm


  		




  
  61
  
    
*cust_cvs_Lab


  		




  
  62
  
    
*cust_cvs_LeafPhenology


  		




  
  63
  
    
*cust_cvs_LeafType


  		




  
  64
  
    
*cust_cvs_LocationSource


  		




  
  65
  
    
*cust_cvs_Mg_ppm


  		




  
  66
  
    
*cust_cvs_Mn_ppm


  		




  
  67
  
    
*cust_cvs_N


  		




  
  68
  
    
*cust_cvs_Na_ppm


  		




  
  69
  
    
*cust_cvs_Ownership


  		




  
  70
  
    
*cust_cvs_P


  		




  
  71
  
    
*cust_cvs_S


  		




  
  72
  
    
*cust_cvs_StemFrequency


  		




  
  73
  
    
*cust_cvs_Zn_ppm


  		




  
  74
  
    
*cust_cvs_collectionFlag


  		




  
  75
  
    
*cust_cvs_collectionName


  		




  
  76
  
    
*cust_cvs_compassType


  		




  
  77
  
    
*cust_cvs_corner1Presence


  		




  
  78
  
    
*cust_cvs_corner2Presence


  		




  
  79
  
    
*cust_cvs_corner3Presence


  		




  
  80
  
    
*cust_cvs_corner4Presence


  		




  
  81
  
    
*cust_cvs_corner5Presence


  		




  
  82
  
    
*cust_cvs_ddh


  		




  
  83
  
    
*cust_cvs_ddhAccuracy


  		




  
  84
  
    
*cust_cvs_isPlanted


  		




  
  85
  
    
*cust_cvs_lengthSoilProbe


  		




  
  86
  
    
*cust_cvs_mcnab_LFI


  		




  
  87
  
    
*cust_cvs_mcnab_LFI_135


  		




  
  88
  
    
*cust_cvs_mcnab_LFI_180


  		




  
  89
  
    
*cust_cvs_mcnab_LFI_225


  		




  
  90
  
    
*cust_cvs_mcnab_LFI_270


  		




  
  91
  
    
*cust_cvs_mcnab_LFI_315


  		




  
  92
  
    
*cust_cvs_mcnab_LFI_45


  		




  
  93
  
    
*cust_cvs_mcnab_LFI_90


  		




  
  94
  
    
*cust_cvs_mcnab_LFI_asp


  		




  
  95
  
    
*cust_cvs_mcnab_TSI


  		




  
  96
  
    
*cust_cvs_mcnab_TSI_135


  		




  
  97
  
    
*cust_cvs_mcnab_TSI_180


  		




  
  98
  
    
*cust_cvs_mcnab_TSI_225


  		




  
  99
  
    
*cust_cvs_mcnab_TSI_270


  		




  
  100
  
    
*cust_cvs_mcnab_TSI_315


  		




  
  101
  
    
*cust_cvs_mcnab_TSI_45


  		




  
  102
  
    
*cust_cvs_mcnab_TSI_90


  		




  
  103
  
    
*cust_cvs_mcnab_TSI_asp


  		




  
  104
  
    
*cust_cvs_originalCoverCode


  		




  
  105
  
    
*cust_cvs_percentBedrock


  		




  
  106
  
    
*cust_cvs_percentBoulder


  		




  
  107
  
    
*cust_cvs_percentCWD


  		




  
  108
  
    
*cust_cvs_percentDuff


  		




  
  109
  
    
*cust_cvs_percentFWD


  		




  
  110
  
    
*cust_cvs_percentGravelCobble


  		




  
  111
  
    
*cust_cvs_percentHistosol


  		




  
  112
  
    
*cust_cvs_percentLitter


  		




  
  113
  
    
*cust_cvs_percentMineralSoil


  		




  
  114
  
    
*cust_cvs_percentNonVasc


  		




  
  115
  
    
*cust_cvs_percentOther


  		




  
  116
  
    
*cust_cvs_percentOtherName


  		




  
  117
  
    
*cust_cvs_percentWater


  		




  
  118
  
    
*cust_cvs_percent_Ca


  		




  
  119
  
    
*cust_cvs_percent_H


  		




  
  120
  
    
*cust_cvs_percent_K


  		




  
  121
  
    
*cust_cvs_percent_Mg


  		




  
  122
  
    
*cust_cvs_percent_Na


  		




  
  123
  
    
*cust_cvs_percent_Othr


  		




  
  124
  
    
*cust_cvs_postDsgPoly


  		




  
  125
  
    
*cust_cvs_province


  		




  
  126
  
    
*cust_cvs_resprout


  		




  
  127
  
    
*cust_cvs_samplingLevel


  		




  
  128
  
    
*cust_cvs_stemComment


  		




  
  129
  
    
*cust_cvs_stemSamplingNarrative


  		




  
  130
  
    
*cust_cvs_stemSource


  		




  
  131
  
    
*cust_cvs_stemsSampled


  		




  
  132
  
    
*cust_cvs_subsamplingFactor


  		




  
  133
  
    
*cust_cvs_taxaRichness


  		




  
  134
  
    
*cust_eep_plotLastPlantedDate


  		




  
  135
  
    
*cust_eep_plotNotSampled


  		




  
  136
  
    
*cust_eep_plotNotSampledReason


  		




  
  137
  
    
*cust_eep_reach


  		




  
  138
  
    
*dateAccuracy


  		




  
  139
  
    
*dateEntered


  		




  
  140
  
    
*dateentered


  		




  
  141
  
    
*dba_notes


  		




  
  142
  
    
*dba_src_ID


  		




  
  143
  
    
*dba_unsure


  		




  
  144
  
    
*division


  		




  
  145
  
    
*dominantStratum


  		




  
  146
  
    
*dsgpoly


  		




  
  147
  
    
*effortLevel


  		




  
  148
  
    
*elevationAccuracy


  		




  
  149
  
    
*email


  		




  
  150
  
    
*entry_IntensiveModuleList


  		




  
  151
  
    
*entry_ares_herbs


  		




  
  152
  
    
*entry_ares_trees


  		




  
  153
  
    
*entry_currentLandUse


  		




  
  154
  
    
*entry_depth


  		




  
  155
  
    
*entry_elevationUnits


  		




  
  156
  
    
*entry_formerLandUse


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff