|
1
|
Note that this VegX export includes only the largest of 157 CTFS plots
|
|
2
|
(Site table), albeit with 90% of the StemObservation rows[1]:
|
|
3
|
* According to Shash, "The Veg-X file I gave you is of only one plot "bci" of Id = 1and all quadrats belongs to the same plot bci." (e-mail on 2012-2-9)
|
|
4
|
* Extracts such as VegX_CTFS_row_180000.xml have just one "top-level" <plot> entry without a <relatedPlot>:
|
|
5
|
-----
|
|
6
|
<plot>
|
|
7
|
<plotUniqueIdentifier>1</plotUniqueIdentifier>
|
|
8
|
<plotName>bci</plotName>
|
|
9
|
</plot>
|
|
10
|
-----
|
|
11
|
This is important, because it indicates that VegX creates a ~6x increase in
|
|
12
|
storage size (613.6 MB for bci.sql vs. 3.78 GB for
|
|
13
|
VegX_CTFS_row_*.xml with 1 plot, assuming roughly equal #s of stems per plot).
|
|
14
|
|
|
15
|
[1] bci plot has 2118974 of 2356190 StemObservation rows:
|
|
16
|
SELECT "PlotName", COUNT(*)
|
|
17
|
FROM "Plot"
|
|
18
|
LEFT JOIN "PlotObservation" USING ("PlotID")
|
|
19
|
LEFT JOIN "StemObservation" USING ("PlotID", "CensusID")
|
|
20
|
GROUP BY "PlotID"::int, "PlotName"
|
|
21
|
ORDER BY "PlotID"::int
|
