Microsoft Word 施建平_new_.doc

Size: px

Start display at page:

Download "Microsoft Word 施建平_new_.doc"

凰宏燕
7 years ago
Views:

1 土壤 (Soils), 2016, 48(6): DOI: /j.cnki.tr 基于 Web 的中国土种数据库 ( ) Web - (entity-relationship E-R) S159.2 [1] ( ) ( ph) ( ) ( ) 28 [2 3] (GB/T 17296) [4] (XXH ) (1954 ) jpshi@issas.ac.cn

2 6 Web [5 8] 9 1) SOIL_TYPE 2) PROFILE_LANDSCAPE 3) 3 LOCATION_NAME sublocation LOCATION_USAGE (sublocation_id 1518) (soil_id 60241) (soil_id 60765) LOCATION_ USAGE sublocation_id soil_id ( 1) 表 1 县市名 ( 四川省马尔康县 ) 与土种分布关系示例 Table 1 The example for the corresponding relationship between a city/county (Maerkang County, Sichuan Province) and several soil local types location_usage_id soil_id sublocation_id (soil_id 60035) (sublocation_id 1407) (sublocation_id 1408) (sublocation_id 1409) LOCATION_USAGE soil_id sublocation_id ( 2) 表 2 土种 ( 西昌红泥土 ) 与地点的分布关系示例 Table 2 The example for the corresponding relationship between a soil local type (Xichang-Hongnitu) and several locations location_usage_id soil_id sublocation_id ) 2 SOIL_GROUP SOIL_ SUBGROUP 5) 2 VALUM1 VALUM_Stat 1 2 Web VisualDB Web [9] VisualDB VisualDB Web VisualDB Web ( 5 ( 3) 4

3 Fig. 1 图 1 中国土种数据库关系结构的实体关系图 (E-R 图 ) The entity-relationship diagram (E-R diagram) to describe the data relationship structure in Soil Type Database of China 表 3 中国土种数据库中按地点查询福建省漳州市的结果 Table 3 The results of a location query to Zhangzhou, Fujian Province in Soil Species Database of China (hm 2 ) m m m m ( 2) ( 5) ( 4) 3 (version 1.0) % 10 g/kg

4 6 Web 1249 表 4 中国土种数据库中泥赤土典型剖面主要理化性质 Table 4 The physico-chemical properties of a typical profile of Nichitu in Soil Species Database of China ID (1) A AB B BC (cm) (cm) (cm) >2 mm (%) (2) 2 ~ 0.02 mm(g/kg) 2 ~ 0.2 mm(g/kg) ~ 0.02 mm(g/kg) ~ mm(g/kg <0.002 mm(g/kg) (3) LC C C LC (g/cm 3 ) (%) (g/kg) (g/kg) (g/kg) (g/kg) (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) 0.82 (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) (cmol/kg(+)) (1) A AB B BC B (C ) (2) (3) LC C 图 2 中国土种数据库中按土壤类型查询的界面 Fig. 2 The soil type query interface in Soil Type Database of China ppm mg/kg me/100g cmol(+)/kg % 10 g/kg g/cm ( 20)

5 表 5 中国土种数据库中按中国土壤发生分类 (GSCC) 查询泥赤土分布情况的结果 Table 5 The results on Nichitu distribution by a Genetic Soil Classification of China (GSCC) query in Soil Species Database of China (hm 2 ) 300 m ISO [8] ( 0 20) 3.3 GB/T [4] GB/T SOIL_SUBGROUP subgroup_ GB_name (CSCC) (CST) [10] ( ) ( ) ( 3) 36 /10 4 km /10 4 km /10 4 km 2 ( 4) Fig. 3 图 3 中国土种数据库收录的土种在各省的分布 The soil local type distribution of Soil Type Database of China in 30 provinces ph ph

6 6 Web 1251 Fig. 4 图 4 中国土种数据库收录的土种在各省的典型剖面分布密度 The typical profile distribution densities of Soil Type Database of China in 30 provinces DOI doi: /geo ver1.db. Web SOTER [11] [12 15] 致谢 : 周慧珍孙波潘贤章徐江兵王昌昆参加了中国土种数据库建设的部分工作, 特此致谢! [1]. ( )[M]. :, 1996 [2] Soil Data Subcommittee, Federal Geographic Data Committee. Soil Geographic Data Standard (FGDC- STD-006) [R/OL]. Reston, Virginia. 1997[ ]. [3] United States Department of Agriculture, Natural Resources Conservation Service. SSURGO Data Packaging and Use[R/OL]. 2012[ ]. wps/pa_nrcsconsumption/download?cid=stelprdb &ext=pdf [4],,. (GB/T )[S]. :, 2009 [5] Shi X Z, Yu D S, Warner E D, et al. Soil database of digital soil survey and reference system of the Chinese genetic soil classification system[j]. Soil Survey Horizons, 2004, 45(4): [6] Nachtergaele F, Velthuizen H, Verelst L. Harmonized World Soil Database (version 1.2)[R/OL]. 2009[ ]. SD/HWSD_Documentation.pdf [7] GlobalSoilMap.net Science Committee. Specifications Version 2 GlobalSoilMap.net products[r/ol]. 2011[ ]. SoilMap_net_specifications_v2_0_edited_draft_Sept_2011_ RAM_V12.pdf [8] Soil quality-digital exchange of soil-related data (ISO 28258:2013(E))[S]. Switzerland, 2013 [9].VisualDB2.0 ( )[R]. :, 2010 [10],. (GB/T ) [S]. :, 2007 [11],,. SOTER [J]., 2010, 26(4): 1 8 [12] Yan X Y, Cai Z C. Number of soil profiles needed to give a reliable overall estimate[j]. Soil Science and Plant Nutrition, 2008, 54(5): [13],. [J]. :, 2010, 40(7):

7 [14],,,. (0~20 cm) 1 m [J]., 2014, 51(1): [15],,,. [J]., 2016, 53(1): Web Based Soil Type Database of China SHI Jianping, SONG Ge (Institute of Soil Science, Chinese Academy of Sciences, Nanjing , China) Abstract: Soil type database of China based on the second national soil survey is the most comprehensive soil data resource on the national scale. It embodies most soil types throughout the country in the 1980 s, including distribution, area, characteristics, land-use and product performance of these soil types. Since 2000, the task of building the web based soil type database of China has been undertaken by Institute of Soil Science, Chinese Academy of Sciences. An entity-relationship (E-R) data model was constructed which involved the spatial relationship between location and soil type, and the classification relationship according to Genetic Soil Classification of China. The database contains typical profiles, soil horizons and the corresponding physical and chemical properties. The database can be widely used for land degradation evaluations, environmental impact studies, and soil carbon sequestration studies. It also can be used as a basic data for agricultural practices. Key words: Soil Type Database; China; The second national soil survey; Data integration

Microsoft Word - 201506定版

Microsoft Word - 201506定版 56 Chinese Journal of Library and Information Science for Traditional Chinese Medicine Dec. 2015 Vol. 39 No. 6 综述中医药学语言系统研究综述于彤, 贾李蓉, 刘静, 杨硕 *, 董燕, 朱玲中国中医科学院中医药信息研究所,