New Brunswick Natural Resources
Data Dictionary
Documentation of ArcSDE geodatabase (SDE Data Feature)
New Brunswick Forest Inventory Database
Monday, June 08, 2009
18
List of Tables
Table 1. The feature class in the ArcSDE geodatabase (SDE Data Feature) theme are: 4
Table 2. The items for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 4
Table 3. The values in the item DATASRC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 5
Table 4. The values in the item SITEI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 5
Table 5. The values in the item VOLI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 6
Table 6. The values in the item FST for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 6
Table 7. The values in the item L1TRTI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 6
Table 8. The values in the item L1ORIG for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 6
Table 9. The values in the item L1TRT for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 6
Table 10. The values in the item L1S1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 7
Table 11. The values in the item L1DS1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 12. The values in the item L1PR1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 13. The values in the item L1S2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 14. The values in the item L1DS2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 15. The values in the item L1PR2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 16. The values in the item L1S3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 8
Table 17. The values in the item L1DS3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 18. The values in the item L1PR3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 19. The values in the item L1S4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 20. The values in the item L1DS4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 21. The values in the item L1PR4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 22. The values in the item L1S5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 23. The values in the item L1DS5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 24. The values in the item L1PR5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 25. The values in the item L1DS for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 26. The values in the item L1CCI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 27. The values in the item L1CC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 28. The values in the item L1STOCK for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 9
Table 29. The values in the item L1VS for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 10
Table 30. The values in the item L1ACS for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 10
Table 31. The values in the item L1DC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 10
Table 32. The values in the item L1SC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 10
Table 33. The values in the item L1FUNA for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 10
Table 34. The values in the item L1OLDFUNA for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 11
Table 35. The values in the item L2TRTI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 36. The values in the item L2ORIG for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 37. The values in the item L2TRT for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 38. The values in the item L2S1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 39. The values in the item L2DS1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 40. The values in the item L2PR1 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 41. The values in the item L2S2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 42. The values in the item L2DS2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 43. The values in the item L2PR2 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 44. The values in the item L2S3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 45. The values in the item L2DS3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 46. The values in the item L2PR3 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 47. The values in the item L2S4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 48. The values in the item L2DS4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 12
Table 49. The values in the item L2PR4 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 50. The values in the item L2S5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 51. The values in the item L2DS5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 52. The values in the item L2PR5 for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 53. The values in the item L2DS for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 54. The values in the item L2CCI for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 55. The values in the item L2CC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 56. The values in the item L2STOCK for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 57. The values in the item L2VS for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 58. The values in the item L2DC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 59. The values in the item L2SC for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 60. The values in the item L2FUNA for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 61. The values in the item L2OLDFUNA for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are: 13
Table 62. The items for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 13
Table 63. The values in the item DATASRC for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 13
Table 64. The values in the item PLU for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 14
Table 65. The values in the item SLU for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 14
Table 66. The values in the item STATUS for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 15
Table 67. The values in the item LC for the NONFOREST polygon feature class in the ArcSDE geodatabase theme are: 15
Table 68. The items for the WATERBODY polygon feature class in the ArcSDE geodatabase theme are: 15
Table 69. The values in the item DATASRC for the WATERBODY polygon feature class in the ArcSDE geodatabase theme are: 15
Table 70. The values in the item WATER_CODE for the WATERBODY polygon feature class in the ArcSDE geodatabase theme are: 15
Table 71. The values in the item BUFFER_CODE for the WATERBODY polygon feature class in the ArcSDE geodatabase theme are: 15
Table 72. The items for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 15
Table 73. The values in the item WLOC for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 16
Table 74. The values in the item WC for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 16
Table 75. The values in the item WRI for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 16
Table 76. The values in the item IM for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 17
Table 77. The values in the item VT for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 17
Table 78. The values in the item SPVC for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 17
Table 79. The values in the item PSW for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 17
Table 80. The values in the item DATASRC for the FWWETLAND polygon feature class in the ArcSDE geodatabase theme are: 17
Table 81. The items for the ROADS polygon feature class in the ArcSDE geodatabase theme are: 17
Table 82. The values in the item DATASRC for the ROADS polygon feature class in the ArcSDE geodatabase theme are: 18
Table 83. The values in the item PLU for the ROADS polygon feature class in the ArcSDE geodatabase theme are: 18
Table 84. The values in the item SLU for the ROADS polygon feature class in the ArcSDE geodatabase theme are: 18
Table 85. The values in the item STATUS for the ROADS polygon feature class in the ArcSDE geodatabase theme are: 18
18
Table 1. The feature class in the ArcSDE geodatabase (SDE Data Feature) theme are:
Name / Feature / Type / Description /FORESTINTERP / Polygon / Feature Class / Current forest polygons
FWWETLAND / Polygon / Feature Class / Current wetland polygons
NONFOREST / Polygon / Feature Class / Current non-forest polygons
ROADS / Polygon / Feature Class / Unprocessed Provincial highways, causeways and resource access roads
WATERBODY / Polygon / Feature Class / Current water polygons
Table 2. The items for the FORESTINTERP polygon feature class in the ArcSDE geodatabase theme are:
Name / Width / Output / Type / Decimals / Description /OBJECTID / 4 / 5 / B / 0 / Polygon id (internal use only)
STDLAB / 8 / 8 / I / 0 / Stand number (4-digit map number and 4 digit x,y position in relation to map tile west,north boundaries)
DATASRC / 6 / 6 / C / 0 / Source of stand attribute data
DATAYR / 4 / 4 / I / 0 / Year of stand attribute data
SITEI / 1 / 1 / C / 0 / Poor site indicator
VOLI / 1 / 1 / C / 0 / Indicator of presence of merchantable volume < 35 m3/ha
FST / 1 / 1 / I / 0 / Forest stand type
L1TRTI / 1 / 1 / C / 0 / Dominant layer silvicultural treatment indicator
L1ORIG / 1 / 1 / C / 0 / Disturbance-origin of predominant layer
L1ESTYR / 4 / 4 / I / 0 / Year of establishment (year harvested or year of full-planting) of the primary layer
L1TRT / 2 / 2 / C / 0 / Latest silvicultural treatment applied to the predominant layer
L1TRTYR / 4 / 4 / I / 0 / Year of treatment identified in the L1TRT field
L1S1 / 2 / 2 / C / 0 / Dominant layer first species code (species are listed in order of predominance)
L1DS1 / 1 / 1 / C / 0 / Dominant layer first species development stage/age class
L1PR1 / 2 / 2 / I / 0 / Dominant layer first species percent ratio
L1S2 / 2 / 2 / C / 0 / Dominant layer second species code
L1DS2 / 1 / 1 / C / 0 / Dominant layer second species development stage/age class
L1PR2 / 1 / 1 / I / 0 / Dominant layer second species percent ratio
L1S3 / 2 / 2 / C / 0 / Dominant layer third species code
L1DS3 / 1 / 1 / C / 0 / Dominant layer third species development stage/age class
L1PR3 / 1 / 1 / I / 0 / Dominant layer third species percent ratio
L1S4 / 2 / 2 / C / 0 / Dominant layer fourth species code
L1DS4 / 1 / 1 / C / 0 / Dominant layer fourth species development stage/age class
L1PR4 / 1 / 1 / I / 0 / Dominant layer fourth species percent ratio
L1S5 / 2 / 2 / C / 0 / Dominant layer fifth species code
L1DS5 / 1 / 1 / C / 0 / Dominant layer fifth species development stage/age class
L1PR5 / 1 / 1 / I / 0 / Dominant layer fifth species percent ratio
L1DS / 1 / 1 / C / 0 / Dominant layer development stage
L1CCI / 1 / 1 / I / 0 / Dominant layer variable crown closure indicator
L1CC / 1 / 1 / I / 0 / Dominant layer crown closure code
L1STOCK / 1 / 1 / I / 0 / Dominant layer stocking class (if unmerchantable)
L1VS / 1 / 1 / I / 0 / Dominant layer number of canopy layers
L1HT / 2 / 2 / I / 0 / Dominant layer average height in metres
L1ACS / 1 / 1 / I / 0 / Identifies whether dominant layer is even or uneven-aged