HomeProductsServicesWhat's NewAbout Us

DendroMetrics, LLC
 Call us at: 503-224-3445
Compile Ready Report
The Compile Ready Report performs a set of checks on your raw cruise data, as populated in the CruiseRecs, SamplePoints, and CruiseLogs tables. Also created a new table, lkpBOUNDS, which defines minimum/maximum diameter and height values for the database.

In order to run this report, simply select the stands with raw cruise data that you wish to perform the checks on and from the Utilities folder choose the option for "Run Compile Ready Report". After the system has finished the checks, a .txt file will be created and saved automatically in the same location of your MBGTools Access database.

The following checks are made:
  • Checks to confirm the Species in CruiseRecs are also defined in the lkpSppCodes table.
  • ​Checks to confirm all SampleTypes in CruiseRecs are also defined in the lkpSampleTypes table.
  • Checks to confirm all PointIDs in CruiseRecs are also defined in the SamplePoints table.
  • Checks to confirm the SampGrp column in ADMIN is not Null.
  • Checks to confirm if any of the following columns are Null in the CruiseRecs table: PlotType, TreeCount, DBH, TotalHt, Dia1, Ht1, Dia2, Ht2, BHAge, CrownRatio.
  • Checks the minimum DBH in CruiseRecs vs the minimum DBH in the lkpBounds table.
  • Checks the maximum DBH in CruiseRecs vs the maximum DBH in the lkpBounds table.
  • Checks the maximum TotalHt in CruiseRecs vs the maximum TotalHt in the lkpBounds table.
  • Checks the minimum TotalHt:DBH ratio in CruiseRecs vs the minimum Height:DBH ratio in lkpBounds table.
  • Checks the maximum TotalHt:DBH ratio in CruiseRecs vs the maximum Height:DBH ratio in lkpBounds table.
  • Checks to confirm the ratio of Dia1 / DBH in CruiseRecs is less than or equal to 0.9, if VolTaperType in ADMIN is set to SIS.
  • Checks to confirm all records in CruiseRecs have a Dia1 < DBH.
  • Checks to confirm all records in CruiseRecs have a Dia2 < DBH.
  • Checks to confirm all records in CruiseRecs have a Ht1 < TotalHt.
  • Checks to confirm all records in CruiseRecs have a Ht2 < TotalHt.
  • Checks to confirm any records in CruiseRecs that have a BHAge recorded also have a TotalHt > 0.
  • Checks if the cruise date in SamplePoints is not more than 30 years old. This is intended to detect false cruise dates or typos in the cruise date.
  • Checks the log numbers in CruiseLogs to confirm they are sequentially numbered from 1 to n for every tree, without skipping any log numbers.
  • Checks to confirm minimum and maximum DBH on fixed and variable radius plots within the same stand.
  • Checks to confirm only a single basal area factor is used within a given stand.
  • Checks for a DBH of 0 in CruiseRecs on any plots that are not flagged as a no tally plot in the PlotType column. Any records with 0 TPA will be excluded from INVYDATA.
  • Checks for any plots flagged as no tally plots, based on Plot Type column in CruiseRecs, are also noted as a TreeCount of 0.
  • Checks to confirm the Species in CruiseRecs are also defined in the lkpSppSubst table.
  • Checks to confirm the FieldCode in CruiseLogs are also defined in the lkpProduct table.



​Example Report


  *********************************
  * MBGTools Compile-Ready Report *
  *********************************

Source Database: C:\Client\DendroMetrics2\TEST_1.mdb
Time of Report:3/16/2018 1:32:14 PM
Version: MBG Tools 20180307


SUMMARY:
********
Number of Checks Passed:20
Number of Checks Failed: 3

Checks that failed:
*** CHECK: All records in CRUISERECS have DBH >= MinimumDBH ****
*** CHECK: Therre are no missing logs in CRUISELOGS ****
*** CHECK: DBH in CRUISERECS are greater than 0 ****


DETAILS:
*******

*** CHECK: Species in CRUISERECS are in lkpSPPCODES ****
PASS



*** CHECK: Sampletypes in CRUISERECS are in lkpSampleTypes ****
PASS



*** CHECK: Samplepoints in CRUISERECS are in SAMPLEPOINTS ****
PASS



*** CHECK: No null fields in ADMIN ****
PASS



*** CHECK: No null fields in CRUISERECS ****
PASS



*** CHECK: All records in CRUISERECS have DBH >= MinimumDBH ****
FAIL: The following records in CruiseRecs have a smaller DBH than specified in lkpBOUNDS:

Stand: 1 PointID: 2 TreeID: 1 DBH = 0



*** CHECK: All records in CRUISERECS have DBH <= MaximumDBH ****
PASS



*** CHECK: All records in CRUISERECS have TotalHt <= MaximumTotalHt ****
PASS



*** CHECK: All records in CRUISERECS have Ht/Dbh ratio >= MinimumHtDbhRatio ****
PASS



*** CHECK: All records in CRUISERECS have Ht/Dbh ratio <= MaximumHtDbhRatio ****
PASS



*** CHECK: All records in CRUISERECS with SIS taper have dia1/Dbh ratio <= 0.9 ****
PASS



*** CHECK: All records in CRUISERECS have dia1 < Dbh ****
PASS



*** CHECK: All records in CRUISERECS have dia2 < Dbh ****
PASS



*** CHECK: All records in CRUISERECS have ht1 < TotalHt ****
PASS



*** CHECK: All records in CRUISERECS have ht2 < TotalHt ****
PASS



*** CHECK: All records in CRUISELOGS have Defect between 0-100 ****
PASS



*** CHECK: All records in CRUISERECS with a BHAge ahve TotalHt > 0 ****
PASS



*** CHECK: All records in SAMPLEPOINTS have a valid Date Cruised ****
PASS



*** CHECK: Therre are no missing logs in CRUISELOGS ****
FAIL: The following trees has log numbers out of sequence in CruiseLogs:

StandID: 1 PointID: 1 TreeID: 1

StandID: 1 PointID: 3 TreeID: 2



*** CHECK: There are NO stands with trees that have DBHs greater on fixed radius plots than on the variable radius plots ****
PASS



*** CHECK: Stands do not more than one variable radius sampletype ****
PASS



*** CHECK: DBH in CRUISERECS are greater than 0 ****
FAIL: There are records in CruiseRecs with DBH = 0; these will not get processed into INVYDATA/CURRATA.


*** CHECK: Blank plot records in CRUISERECS have TreeCount of 0 ****
PASS