Revision 4367
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/CTFS/_archive/Organism.VegX/README.TXT | ||
|---|---|---|
| 1 |
Note that this VegX export includes only *one* of 157 CTFS plots (Site table): |
|
| 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]: |
|
| 2 | 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) |
| 3 | 4 |
* Extracts such as VegX_CTFS_row_180000.xml have just one "top-level" <plot> entry without a <relatedPlot>: |
| 4 | 5 |
----- |
| ... | ... | |
| 7 | 8 |
<plotName>bci</plotName> |
| 8 | 9 |
</plot> |
| 9 | 10 |
----- |
| 10 |
This is important, because it indicates that VegX creates a ~1000x (!) increase
|
|
| 11 |
in storage size (613.6 MB for bci.sql with 157 plots vs. 3.78 GB for
|
|
| 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
|
|
| 12 | 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 |
|
Also available in: Unified diff
inputs/CTFS/_archive/Organism.VegX/README.TXT: Added calculation of StemObservation rows distribution for each plot, which indicates that the bci plot actually contains 90% of the StemObservation rows. This brings the size inflation of VegX down to ~6x.