DB21T 1591-2020 数字林业 数据库 森林资源调查数据表结构　　

DB21辽宁省市场监督管理局发布I ——修改了术语和定义，调整了术语的顺序，——修改了数据表命名和分层存储规则、数据表的表结构；——增加和删除了部分数据表；——拆分和合并了部分数据表；——更新了参考文献。归口管理部门通讯地址：辽宁省林业和草原局（沈阳市和平区太原北街2号），联系电话：），1数字林业数据库森林资源调查数据表结构本标准规定了省级森林资源数据属性表结构的相关术语和定义；规定了森林资源清查数据属性表构、规划设计调查数据属性表结构、作业设计调查数据属本标准适用于森林资源管理、森林资源管理数据库建库、林业信息化(数字林业)及数凡是不注日期的引用文件，其最新版本（包括所有的修改单）LY/T2188.2森林资源数DB21/T1590数字林业数据库森林理等需要进行的调查活动。简称二类调查，也称森林经理2类区划图以及其他林业专题图的编绘原图；又是森林资源经营作业设计和森林资源管理的重要基础资ABCDE3FGHXN（3）因子字段命名不允许重复。若发生重复5森林资源清查（一类调查）属性表结构描述5.1森林资源清查数据命名和分层存储规则_XXXXXX _XXXX_XXXXXX__YM（样木）_XXXX_XXXXXX _KJ（跨角样地）_XXXX_XXXXXX_XX_MP(样地点状图)_XXXX5.2地面样地因子表3J1_XXXXXX_XX_YD_XXXX样地调查因子1223MAP_NO475ABSCISSA8677886Y9WATER_SHED4Y1Y2Y1YALTITUDE4ASPECT1Y41Y2Y3Y33A_DEPTH3343434Y3YWETLAND_TYPE3Y1Y1Y1Y3Y1Y2Y31WIND_EROSION11Y1Y3Y2Y3YAVG_AGE3AGE_GROUP1YAVG_DBH4AVG_HEIGHT4211Y1Y1Y1Y1Y2Y3Y52Y1YMANAGE_CLASS1Y2Y1Y1Y1Y441YAREA_CLASS1Y3Y13848484848484AVF_DGR41AREA8888888234Y5.3样木因子表4J1_XXXXXX_XX_YM_XXXX样木调查因子记录表1Y6表4（续）2432Y42Y55Y65271Y81Y9141132845.4跨角林样地因子1Y213AREA_RATIO344Y51Y61Y73Y82Y93YAVG_GROUP1Y21AVG_HEIGHT41Y1YMANAGE_CLASS1Y1Y848484846森林资源规划设计调查（二类调查）属性7表6规划设计调查数据命名和分层存储规则G_XXXXXX_XXXXX_XXXXXX_XXXXX_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXXN_XXXXXX_XXXX表7J2JBG_XXXXXX_XXXX基本图属123县649563758941133421283县649563758914131123县649563758933122211111112129表9（续）232312414111111324211511111422111214241表9（续）411341311313414312114220表9（续）1010101002020201010109003010国家公益林生态区位301行政区划+经营区划2县63945365758292323322224141323512000469416.7.1材积生长量（率）表132213214215216216.7.2胸径生长量（率）表132213214215216216.7.3树高生长量（率）表13221321421521621121311321321421521621721_XXXXXX_XXXX_XXXXXX_XXXX12434252627282922222222222222222222表18（续）单位：公顷222222221243425262728292222222222222222222222222222124342516273829222222222222222222表20（续）单位：公顷222222124344526272829222222222222222222222表21（续）单位：公顷22222222表22J2TJ05_XXXXXX_X1243415262728292222222222222222222表22（续）单位：公顷2222222222表23J2TJ06_XXXXXX_XX124342526728922226.10.2.7各类森林、林木按水系面积12434452262782922226.10.2.8各类森林、林木按生态分区面积12434152262782922226.10.2.9林分各林种按组成树种面积、蓄1243425363728922222124342516273819222222222222222222226.10.2.11各工程类别公益林（地）面124342516272839122222222222222222222124342516372829222222222222222222226.10.2.13各工程类别商品林（地）面1243425162738892222222222222222表30（续）222226.10.2.14林分各林种按龄组面积、蓄表31J2TJ14_XXXXXX_X124342526373829222222222221243425263738292222222222222212434252637382922222222222226.10.2.17用材林按龄级面积、蓄表34J2TJ17_XXXXXX_X12434252637289222222表34（续）22226.10.2.18用材林近成过熟林按组成树种可及度面积、蓄积统表35J2TJ18_XXXXXX_XXXX用材林近成过熟林按组成树种可及度面积、蓄积统计表1243425362782922222222124342526373Y82922222222221243425164728292222222222212434352617485922222222221243452622729222表40J2TJBH01_XXXXXX_X124345262728292222616161616161616161618181616181818181表40（续）单位：公顷61816.10.3.2林分各树种组按龄组面积、表41J2TJBH02_XXXXXX_XX12434253681781898181818181124348158168178188198181表42（续）单位：公顷816161616161616161616181816161表43J2TJBH04_XXXXXX_XX1243456789表43（续）124342516817819818181816161618181611243426272829222表45（续）单位：公顷2222812222表46J2TJBH07_XXXXXX_XX1243426817282922222222221243表47（续）462227282922221243462728292222222222226.10.3.10林地保护等级变化分124342516817819818181816161618181616.10.3.11森林类别变化原因分表50J2TJBH11_XXXXXX_XXXX124346272829222222222表50（续）单位：公顷226.10.3.12各类林地与森林类别面积变化表51J2TJBH12_XXXXXX12434251681781981818181616161818161表52采伐作业设计数据命名和分层存储规则_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX表52（续）_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX _N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CFDCB（标准地调查簿）_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX_CF_N_XXXXXX_XXXX表53J3_CFCSNXXXXXX_XXXX系统参数表122346表54J3_CFYHNXXXXXX_XXXX用户表1234656789表55J3_CFCDNXXXXXX_XXXX系统菜单表126314656注：菜单编号按菜单级别编码，两位为一个级别支持最多三级菜单，如010000为一级的第一个菜单、020103是指第二个一级菜单中第三个三级菜单项，与020101同属于020100二级菜单；上级菜单记录的是所属的上级菜单编号，如表56J3_CFQXNXXXXXX_XXXX权限表123643表57J3_CFCJNXXXXXX_XXXX树种材积表123Y334525表58J3_CFDJCJNXXXXXX_XXXX树种地径材积表123Y33表58（续）452表59J3_CFJIELNXXXXXX_XXXX径阶出材率表122Y33Y44254264273842942注：此表以起源+树种+径阶为联合主键或唯一索引。当径阶表60J3_CFCBSNXXXXXX_XXXX森林经营作业设计1236435363758392表60（续）123县45678947.1.4.1森林主伐更新、抚育间伐、改造作业设计一览表62J3_CFNZFGY_XXXXXX_XXXX森林主伐更新、抚育间伐、改造作业设计一览表(一)122633435365738294242545412332333212131表62（续）3112125554543355545425527.1.4.2森林主伐更新、抚育间伐、改造作业设计一览表63J3_CFNZFGE_XXXXXX_XXXX森林主伐更新、抚12324353637483924254545454545454表63（续）545454545454545455455452543131311232435363748392421233452表64（续）342551133331Y2364353637583656262626262621Y2表66（续）36435363758365626262626262表67J3_CFSCTNXXXXX1232435363758392232111表68（续）232Y435363758392232111236435363758392334254425412233464表69（续）2表70J3_CFJJILNXXXXXX_XXXX小班出材率表12CZ材种nvarchar503树种nvarchar504CCL出材率decimal5212树种nvarchar3树种代码nvarchar4decimal515材种nvarchar6材种代码nvarchar7decimal5189表72J3_CFXJJCNXXXXXX_XXXX平均标准木出材率_造材蓄积检尺12树种nvarchar3树种代码nvarchar4胸径decimal515径阶6树高decimal51表73J3_CFNPJJL_XXXXXX_XXXX平均标准木造材记录表1表73（续）2364353637584935312154431215431215431212454312154312154312154312154表73（续）3121543121543121表74J3_CFNJJJL_XXXXXX_XXXX径阶标准木12364353637584935312124312124313121243131212431