Note that this VegX export includes only the largest of 157 CTFS plots (Site table), albeit with 90% of the StemObservation rows[1]: * 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) * Extracts such as VegX_CTFS_row_180000.xml have just one "top-level" entry without a : ----- 1 bci ----- This is important, because it indicates that VegX creates a ~6x increase in storage size (613.6 MB for bci.sql vs. 3.78 GB for VegX_CTFS_row_*.xml with 1 plot, assuming roughly equal #s of stems per plot). [1] bci plot has 2118974 of 2356190 StemObservation rows: SELECT "PlotName", COUNT(*) FROM "Plot" LEFT JOIN "PlotObservation" USING ("PlotID") LEFT JOIN "StemObservation" USING ("PlotID", "CensusID") GROUP BY "PlotID"::int, "PlotName" ORDER BY "PlotID"::int