INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (1, 'LITTER_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 'SIN', '自然碳汇', NULL, 1); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (2, '', '', '{\r\n \"species\" : \"云杉、冷杉\",\r\n \"a\" : 20.738491,\r\n \"b\" : -0.010164\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 1); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (3, '', '', '{\r\n \"species\" : \"落叶松\",\r\n \"a\" : 67.412962,\r\n \"b\" : -0.014074\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 2); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (4, '', '', '{\r\n \"species\" : \"油松\",\r\n \"a\" : 24.826509,\r\n \"b\" : -0.023362\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 3); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (5, '', '', '{\r\n \"species\" : \"马尾松\",\r\n \"a\" : 7.217506,\r\n \"b\" : -0.006710\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 4); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (6, '', '', '{\r\n \"species\" : \"其他松类(包括思茅松、云南松、台湾松、赤松、黑松、高山松、长白松、火炬松、红松、樟子松、华山松、湿地松等)\",\r\n \"a\" : 13.119797,\r\n \"b\" : -0.009026\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 5); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (7, '', '', '{\r\n \"species\" : \"柏木\",\r\n \"a\" : 3.759535,\r\n \"b\" : -0.004670\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 6); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (8, '', '', '{\r\n \"species\" : \"杉木和其他杉类\",\r\n \"a\" : 4.989672,\r\n \"b\" : -0.002545\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 7); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (9, '', '', '{\r\n \"species\" : \"栎类\",\r\n \"a\" : 7.732453,\r\n \"b\" : -0.004769\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 8); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (10, '', '', '{\r\n \"species\" : \"其他硬阔类(桦木、枫香、荷木、水胡黄、樟树、楠木等)\",\r\n \"a\" : 6.977898,\r\n \"b\" : -0.004312\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 9); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (11, '', '', '{\r\n \"species\" : \"杨树\",\r\n \"a\" : 12.310620,\r\n \"b\" : -0.006901\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 10); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (12, '', '', '{\r\n \"species\" : \"桉树\",\r\n \"a\" : 24.696643,\r\n \"b\" : -0.013687\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 11); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (13, '', '', '{\r\n \"species\" : \"相思\",\r\n \"a\" : 9.538834,\r\n \"b\" : -0.000408\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 12); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (14, '', '', '{\r\n \"species\" : \"其他软阔类(椴树、檫木、柳树、泡桐、楝树、木麻黄等)\",\r\n \"a\" : 8.128553,\r\n \"b\" : -0.004563\r\n}', 'DEATH_AND_LIFE_RATIO', '枯落物碳储量与活立木生物质碳储量之比', NULL, 13); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (15, 'TREE_SPECIES', '树种信息', NULL, 'SIN', '自然碳汇', NULL, 3); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (16, 'BIOMASS_EQUATION', '生物量方程', NULL, 'SIN', '自然碳汇', NULL, 4); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (17, 'VOLUME_EQUATION', '材积方程', NULL, 'SIN', '自然碳汇', NULL, 5); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (18, 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 'SIN', '自然碳汇', NULL, 6); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (19, '', '东北内蒙(辽宁、吉林、黑龙江和内蒙古东部)', '0.0351', 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 1); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (20, '', '华北中原(北京、天津、河北、山西、山东、河南)', '0.0206', 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 2); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (21, '', '西北(陕西、甘肃、青海、宁夏、新疆和内蒙古中西部)', '0.0311', 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 3); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (22, '', '华东华中华南(上海、江苏、浙江、安徽、福建、江西、湖北、湖南、广东、广西、海南)', '0.0225', 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 4); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (23, '', '西南(重庆、四川、贵州、云南、西藏)', '0.0188', 'DEAD_WOOD_AND_LIFE_RATIO', '枯死木碳储量与林木生物质碳储量之比', NULL, 5); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (24, 'PRODUCT_PARAMETER', '木(竹)产品参数', NULL, 'SIN', '自然碳汇', NULL, 7); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (25, 'FERTILIZER_PARAMETER', '化肥参数', NULL, 'SIN', '自然碳汇', NULL, 8); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (26, 'FOSSIL_FUEL_PARAMETER', '化石燃料参数', NULL, 'SIN', '自然碳汇', NULL, 9); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (27, 'TRACTOR_PARAMETER', '农机参数', NULL, 'SIN', '自然碳汇', NULL, 10); INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (28, 'LEGUME_FORAGE_PARAMETER', '豆科牧草参数', NULL, 'SIN', '自然碳汇', NULL, 11); -- 初始化林木树种信息: [云杉, 樟子松, 落叶松] INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (29, 'TREE_SPECIES', '树种信息', '云杉', 'ys_Bio_1', '{\"woodDensity\":\"0.342\",\"carbonContent\":\"0.521\",\"biomassRatio\":\"0.224\",\"expansionFactor\":\"1.734\",\"tableDataSource\":[],\"B_a\":\"4.165749\",\"B_b\":\"4.165749\",\"LIa\":\"20.738491\",\"LIb\":\"-0.010164\",\"leafCF\":\"0.37\"}', NULL, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (30, 'TREE_SPECIES', '树种信息', '樟子松', 'zzs_Bio_1', '{\"woodDensity\":\"0.375\",\"carbonContent\":\"0.522\",\"biomassRatio\":\"0.241\",\"expansionFactor\":\"2.513\",\"tableDataSource\":[],\"B_a\":\"2.844362\",\"B_b\":\"2.844362\",\"LIa\":\"13.119797\",\"LIb\":\"-0.009026\",\"leafCF\":\"0.37\"}', NULL, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (31, 'TREE_SPECIES', '树种信息', '落叶松', 'lys_Bio_1', '{\"woodDensity\":\"0.490\",\"carbonContent\":\"0.521\",\"biomassRatio\":\"0.212\",\"expansionFactor\":\"1.416\",\"tableDataSource\":[{\"key\":0.025523332720136738,\"requestStrName\":\"\",\"potionName\":\"北方\",\"startingPrice\":1,\"id\":\"\"}],\"B_a\":\"1.641699\",\"B_b\":\"1.641699\",\"LIa\":\"67.412962\",\"LIb\":\"-0.014074\",\"leafCF\":\"0.37\"}', NULL, null); -- 初始化生物量方程: [云杉, 樟子松, 落叶松] INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (32, 'BIOMASS_EQUATION', '生物量方程', '云杉', 'ys_Bio_1', '{\"breastFormula\":\"8.5727*ln(A)-17.852\",\"biomassFormula\":\"5.2883-2.3268*DBH+0.5775*DBH^2\",\"calculationPart\":\"地上\",\"suitableAgeStart\":10,\"time\":\"2021-11-20T10:58:38.173Z\",\"province\":\"11\",\"passRecord\":\"存疑\"}', '存疑', null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (33, 'BIOMASS_EQUATION', '生物量方程', '樟子松', 'zzs_Bio_1', '{\"breastFormula\":\"25.60009*(1-e^(-0.054015*A))^1.911613\",\"biomassFormula\":\"0.8316*DBH^1.5056\",\"calculationPart\":\"地上\",\"suitableAgeStart\":5,\"suitableAgeEnd\":null,\"time\":\"2021-11-04T07:35:42.643Z\",\"province\":\"11\",\"passRecord\":\"存疑\"}', '存疑', null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (34, 'BIOMASS_EQUATION', '生物量方程', '落叶松', 'lys_Bio_1', '{\"breastFormula\":\"25.821*e^(-13.678/A)\",\"biomassFormula\":\"0.1549*DBH^2.2688\",\"calculationPart\":\"全部\",\"suitableAgeStart\":null,\"suitableAgeEnd\":null,\"time\":\"2021-11-05T03:05:21.038Z\",\"province\":\"11\",\"passRecord\":\"存疑\"}', '存疑', null); -- 初始化材积方程: [云杉, 樟子松, 落叶松] INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (35, 'VOLUME_EQUATION', '材积方程', '云杉', 'ys_Bio_1', '{\"usage\":\"监测\",\"volumeFormula\":\"0.33050596446*(1-e^(-0.029683022346463*A))^3.094640905157\",\"releaseYear\":\"2021-11-20T10:59:51.563Z\",\"provinceName\":\"11\",\"passRecord\":\"否\"}', '否', null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (36, 'VOLUME_EQUATION', '材积方程', '樟子松', 'zzs_Bio_1', '{\"usage\":\"监测\",\"volumeFormula\":\"3019.5*(1-e^(-0.06*A))^5.128\",\"releaseYear\":\"2021-11-20T10:59:35.895Z\",\"provinceName\":\"11\",\"passRecord\":\"否\"}', '否', null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (37, 'VOLUME_EQUATION', '材积方程', '落叶松', 'lys_Bio_1', '{\"usage\":\"监测\",\"volumeFormula\":\"3019.5*(1-e^(-0.06*A))^5.128\",\"releaseYear\":\"2021-11-20T10:59:06.062Z\",\"provinceName\":\"11\",\"passRecord\":\"否\"}', '否', null); -- 初始化电网因子方程 相关 INSERT INTO `sin_knowledge_base`(`id`, `base_code`, `base_name`, `base_value`, `category_code`, `category_name`, `pass_record`, `sort_no`) VALUES (38, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', NULL, 'SIN', '自然碳汇', NULL, 12); -- 初始化2019年6大电网区域下的电网因子 INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (39, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '华北区域电网', '2019', '{\"area\":\"华北区域电网\",\"yearNum\":2019,\"ef_om\":0.1859,\"ef_bm\":0.9999}', null, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (40, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '华中区域电网', '2019', '{\"area\":\"华中区域电网\",\"yearNum\":2019,\"ef_om\":0.5236,\"ef_bm\":0.6969}', null, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (41, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '东北区域电网', '2019', '{\"area\":\"东北区域电网\",\"yearNum\":2019,\"ef_om\":1.2522,\"ef_bm\":0.9852}', null, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (42, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '华东区域电网', '2019', '{\"area\":\"华东区域电网\",\"yearNum\":2019,\"ef_om\":1.0023,\"ef_bm\":2.5121}', null, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (43, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '西北区域电网', '2019', '{\"area\":\"西北区域电网\",\"yearNum\":2019,\"ef_om\":0.3264,\"ef_bm\":0.8451}', null, null); INSERT INTO `sin_knowledge_base`(`id`, `category_code`, `category_name`, `base_name`, `base_code`, `base_value`, `pass_record`, `sort_no`) VALUES (44, 'ELECTRICITY_RELEASE_FACTOR', '电网基准线排放因子', '南方区域电网', '2019', '{\"area\":\"南方区域电网\",\"yearNum\":2019,\"ef_om\":3.0212,\"ef_bm\":1.2306}', null, null); -- 初始化化肥参数: -- 初始化化石燃料参数: -- 初始化农机参数: -- 初始化豆科牧草参数: