Table:SiteGrid

From Free State Drivers
Revision as of 21:24, 18 November 2017 by Cvopicka (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Description

The 10-meter SiteGrid is a GIS layer which spans the entire geographic area of the working forest. It provides a permanent reference grid of natural site growth capacity regardless of silvicultural regimes or species occurring within each stand polygon.

Since it is a point grid (typically on a one-acre basis), any updates for average site index on a stand polygon are merely the average of all points spatially occurring within the polygon. Thus, breaking stand polygons into harvest units or dissolving small polygons into larger ones creates no problem in the underlying basis of productivity for each new polygon generated anywhere across the forest.

Columns

  1. Pnt_ID
    • Long Integer
    • Unique numeric index for each geographic point
    • Primary Key
  2. GIS_ID
    • Long Integer
    • Default 0
    • Numeric index to the forest polygon (Gis_ID in VegPoly)
  3. Flag
    • Long Integer
    • Default 0
    • Numeric temporary value for selecting subsets of data
  4. Strata
    • Long Integer
    • Default 0
  5. Elev
    • Long Integer
    • Default 0
    • Elevation in feet (or meters) above sea level from DEM
  6. Aspect
    • Long Integer
    • Default 0
    • Elevation in feet (or meters) above sea level from DEM
  7. Slope
    • Long Integer
    • Default 0
    • Slope in percentages from DEM at this point location
  8. WetA
    • Long Integer
    • Default 0
    • Annual precipitation in inches (cm)
  9. WetB
    • Long Integer
    • Default 0
    • Growing season precipitation in inches (cm) from past history (May - Sept)
  10. WetC
    • Long Integer
    • Default 0
    • Summer precipitation in inches (cm) from past history (Jul - Sept)
  11. Soil
    • Long Integer
    • Default 20
    • Soil rooting depth, moisture or drainage as best for site influence
    • This parameter is always expected to range between 0 – 60
  12. Sun2
    • Single
    • Default 0
    • Average daily solar radiation at elevation on flat ground
    • Calculated only once. If this value is non zero, it will not be calculated again.
  13. Day2
    • Long Integer
    • Default 0
    • Number of growing season days above 10 degrees C for Sun2
    • Calculated only once. If this value is non zero, it will not be calculated again.
  14. Sun3
    • Single
    • Default 0
    • Average daily solar radiation at elevation, aspect, and slope
    • Calculated only once. If this value is non zero, it will not be calculated again.
  15. Day3
    • Long Integer
    • Default 0
    • Number of growing season days for elevation, aspect, and slope
    • Calculated only once. If this value is non zero, it will not be calculated again.
  16. Site10
    • Single
    • Default 0
    • 10-meter site index capacity at this point (meters/decade)
  17. Shp10
    • Single
    • Default 0
    • 10-meter site index capacity at this point (meters/decade)
  18. SiteBH
    • Long Integer
    • Default 0
    • Traditional Breast Height (4.5') site index capacity at this point
  19. Lat
    • Double
    • Default 0
    • Y (Decimal Degrees North(+)/South(-))
  20. Lng
    • Double
    • Default 0
    • X (Decimal Degrees East(+)/West(-))
  21. XGIS
    • Double
    • Default 0
    • Geographic location in feet (m) on West-East plane
  22. YGIS
    • Double
    • Default 0
    • Geographic location in feet (m) on South-North plane
  23. EHor
    • Single
    • Default 0
    • Eastern horizon
  24. WHor
    • Single
    • Default 0
    • Western horizon

I/O Functions

  • Editors
  • Update SiteGrid.Veg_ID from VegPoly.Gis_ID
UPDATE SiteGrid INNER JOIN SiteJoin ON SiteGrid.Pnt_ID = SiteJoin.Pnt_ID 
 SET SiteGrid.Gis_ID = SiteJoin.Gis_ID
  • Make SiteGrid Site10 Updateable (Flag = 1)
UPDATE SiteGrid 
 SET Flag = 1 
 WHERE Flag <> 10
  • Update Physical Site from SiteGrid
    FP7Phys.exe
  • View SiteGrid Update Summary
  • Lock SiteGrid Site10 ( Set Flag = 0 or 10)
UPDATE SiteGrid 
 SET Flag = 0 
 WHERE Flag <> 10

SQL

MS Access

MS SQL Server

MySQL

CREATE TABLE `SiteGrid` (
 `Pnt_ID` INTEGER NOT NULL COMMENT 'Unique numeric index for each geographic point', 
 `GIS_ID` INTEGER COMMENT 'Numeric index to the forest polygon (Gis_ID in VegPoly)', 
 `Flag` INTEGER COMMENT 'Numeric temporary value for selecting subsets of data', 
 `Strata` INTEGER COMMENT 'Strata', 
 `Elev` INTEGER COMMENT 'Elevation in feet (or meters) above sea level from DEM', 
 `Aspect` INTEGER COMMENT 'Aspect in degrees (1 – 360) from DEM', 
 `Slope` INTEGER COMMENT 'Slope in percentages from DEM at this point location', 
 `WetA` INTEGER COMMENT 'Annual precipitation in inches (cm) from National Weather', 
 `WetB` INTEGER COMMENT 'Growing season precipitation in inches (cm) from past history', 
 `WetC` INTEGER COMMENT 'Summer precipitation in inches (cm) from past history', 
 `Soil` INTEGER COMMENT 'Soil rooting depth, moisture or drainage as best for site influence (This parameter is always expected to range between 0 – 60)', 
 `Sun2` FLOAT NULL COMMENT 'Average daily solar radiation at elevation on flat ground', 
 `Day2` INTEGER COMMENT 'Number of growing season days above 10 degrees C for Sun2', 
 `Sun3` FLOAT NULL COMMENT 'Average daily solar radiation at elevation, aspect and slope', 
 `Day3` INTEGER COMMENT 'Number of growing season days for elevation, aspect and slope', 
 `Site10` FLOAT NULL COMMENT '10-meter site index capacity at this point (meters/decade)', 
 `Shp10` FLOAT NULL COMMENT '10-meter site curve shape at this point location (percentage basis)', 
 `SiteBH` INTEGER COMMENT 'Traditional Breast Height (4.5ft) site index capacity at this point', 
 `Lat` DOUBLE NULL COMMENT 'Geographic location', 
 `Lng` DOUBLE NULL COMMENT 'Geographic location', 
 `XGIS` DOUBLE NULL COMMENT 'Geographic location in feet (m) on West – East plane', 
 `YGIS` DOUBLE NULL COMMENT 'Geographic location in feet (m) on South – North plane', 
 `EHor` FLOAT NULL COMMENT 'Eastern Horizon', 
 `WHor` FLOAT NULL COMMENT 'Western Horizon', 
 PRIMARY KEY (`Pnt_ID`)
) ENGINE=myisam DEFAULT CHARSET=utf8;

ANSI SQL

Footnotes

Notes


References