|
1
|
NPS - Plots DB errors in upload
|
|
2
|
-------------------------------
|
|
3
|
1) Project not defined in NPS DB - yet plots got assigned to project: BADL Vegetation Mapping Project -- NATURESERVE
|
|
4
|
2) The following fields have data, but I do not know where those data come from, they are probably assumed:
|
|
5
|
PLOT:<standSize><permanence><country>
|
|
6
|
OBSERVATION:<authorObsCode>(this seems to be VegBank Obs Code)<coverDispersion><autotaxonCover><effortLevel><observationNarrative>(This is from "other comments"?)<treeHt>0 <mtl>assumed value, wrong</mtl>
|
|
7
|
<basalArea>(basal area was 0, though the plot had stems, so this is false)<treeHt><shrubHt><floatingCover><submergedCover><growthform1cover>(set to 0)
|
|
8
|
3) Elevation was stored in NPS in feet and should have been converted to meters for VegBank, but feet value was imported? (Or feet value is automatically output?)
|
|
9
|
4) The following fields have data that are correct from NPS, but the values do not fit VegBank closed lists - shouldn't be able to exist in our DB structure
|
|
10
|
PLOT:<geology>
|
|
11
|
OBSERVATION:<representativeness><dominantStratum>(This from leaf type and does not match my thinking here, but Bob may have instructed John so)
|
|
12
|
5) The field observationSequence has a long value with a date, but probably only needs to be VB.2
|
|
13
|
6) The following foreign keys are required, but somehow loaded with nulls:
|
|
14
|
<coverMethodId/>
|
|
15
|
<stratumMethodId/>
|
|
16
|
7) <sampleMethodId> is an old field and should have been deleted. SAMPLE METHOD, not stratum method, which we do keep
|
|
17
|
8) plotValidationLevel was given a value of 1, not sure if this was calculated or assumed.
|
|
18
|
9) communityClassification : Why 2 classInspection fields? only need 1
|
|
19
|
10) observationContributor : I assume observation contributors were taken from project contributors, which is not necessarily correct. Here, other obs contrib are mentioned in PLOTs, but are not here: Dan Cogan, Brent Dekker
|
|
20
|
11) There is no role associated with obs or project Contributors!
|
|
21
|
12) stratum : all strata are correct in Cover, but incorrect in Height and Base!, Except H, which has correct Height and Base!
|
|
22
|
13) <taxonObservation> The only minor error is that cover is rounded off to nearest percent, which should still be fixed.
|
|
23
|
14) stems are not loaded
|