A method for compiling a high-precision multi-region input-output table of the marine economy

Abstract

The present invention relates to the field of data processing technology, and in particular to a method for compiling a high-precision multi-region marine economic input-output table. The method comprises the following steps: obtaining a database; obtaining an initial MRIO table containing the study area based on the data in the database; if the input-output information of the study area is not in the same MRIO table, performing sector matching to construct a sector-consistent MRIO table; otherwise, not performing sector matching; adjusting the order of regions in the sector-consistent MRIO table to obtain a standard MRIO table; constructing a bridge matrix and a sub-bridge matrix based on the added value share of each region's marine industry in its respective industries; verifying and updating the original bridge matrix and sub-bridge matrix; and separating the marine industry input-output information from the standard MRIO table based on the bridge matrix, and performing balancing processing to obtain a balanced MMRIO table. The present invention provides a scientific basis and technical support for the systematic and precise compilation of MMRIO tables.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method for compiling a high-precision multi-region marine economic input-output table. Background Art

[0002] Trade between the marine and terrestrial economies means that the development of the marine industry not only drives economic growth in non-coastal regions and non-marine industries, but also leads to indirect resource consumption and ecological and environmental impacts across the entire industrial chain, across regions and industries. Quantifying the economic and trade relationship between marine and non-marine industries in coastal regions, analyzing the economic effects and resource and environmental impacts across the entire industrial chain, and using this information to develop policies for marine industry management and resource and ecological optimization are urgent issues that need to be addressed. However, due to difficulties in data collection and limitations in data compilation, the cross-regional economic and trade impacts of marine industry development across the entire industrial chain remain unclear. Therefore, a method for compiling high-precision multi-region marine economic input-output tables is urgently needed. Summary of the Invention

[0003] The purpose of the present invention is to provide a method for compiling a high-precision multi-regional marine economic input-output table. By splitting the national economic sectors in the original multi-regional input-output table into refined marine sectors, the new multi-regional marine economic input-output table can more finely capture the economic and trade relations between the marine sectors in various coastal areas and between these sectors and inland sectors. The marine economic input-output table is spatially refined to a multi-regional level in a breakthrough manner, which improves the spatial resolution and solves the problem of difficulty in compiling tables at a small geographical scale in the past. The modular compilation framework and compilation process enable it to have the functions of dynamic update and cross-validation. Compared with existing theories and methods, the present invention clarifies the teleconnection mechanism between marine sectors and non-marine sectors across regions, and by introducing a bridge matrix, it realizes the interconnection of intermediate trade between regions and sectors, providing a scientific basis and technical support for national marine industry development research and strategy formulation.

[0004] To achieve the above object, the present invention provides the following solutions:

[0005] A method for compiling a high-precision multi-region marine economic input-output table, including:

[0006] Collect initial data of the study area and modularize it to obtain a database;

[0007] Obtaining an initial MRIO table containing the study area based on the data in the database; if the input-output information of the study area is not in the same MRIO table, performing department matching to construct a department-consistent MRIO table; otherwise, no department matching is performed;

[0008] Adjust the order of regions in the department-consistent MRIO table. If the input-output information of the study area is not in the same MRIO table, first perform modular processing and re-module splicing according to the standard structure of the multi-region input-output table. Then adjust the order of regions to obtain the standard MRIO table.

[0009] According to the added value proportion of each region's marine industry in its own industry, a bridge matrix and a sub-bridge matrix are constructed;

[0010] Verify and update the original bridge matrix and sub-bridge matrix based on the latest historical data provided by the marine department;

[0011] According to the bridge matrix, the input-output information of the marine industry is separated from the standard MRIO table to obtain a multi-regional marine economic input-output MMRIO table;

[0012] The multi-regional marine economic input-output (MMRIO) table is balanced to obtain a balanced multi-regional marine economic input-output (MMRIO) table.

[0013] Optionally, collecting initial data of the research area and modularizing it includes: collecting initial data including input-output tables, customs data, marine industry economic data, and macroeconomic data, and storing the initial data in the database according to a preset format.

[0014] Optionally, performing department matching includes: splitting, merging, and reorganizing department data through the production end and the consumption end in turn, and mapping the department data to a unified benchmark department.

[0015] Optionally, obtain a standard form MRIO form including:

[0016] If the input-output information of the study areas is in the same MRIO table, the data in the sector-consistent MRIO table will be adjusted according to the order of coastal and non-coastal regions. If the input-output information of the study areas is not in the same MRIO table, the sector-consistent MRIO table will be modularized according to its components, and the trade volume between the missing regions will be estimated using customs data and the global multi-regional input-output table. Then, the modularization will be spliced according to the standard structure of the MRIO table to construct a complete MRIO table including all the study areas. The study areas in the complete MRIO table will then be sorted according to the order of coastal and non-coastal regions to form the standard form of the MRIO table.

[0017] Optionally, build a bridge matrix including:

[0018] = ;

[0019] Where C is the bridge matrix, is the sub-bridge matrix, i=1…k, is the number of study areas in the standardized MRIO table;

[0020] Among them, the sub-bridge matrix is:

[0021] ;

[0022] in, is the identity matrix, is the number of marine sectors, is the number of national economic sectors, and is the sub-bridge matrix C i In the two cases, the corresponding forms, elements is the proportion of the added value of the pth marine sector in the added value of the national economic sector to which it belongs, q is the serial number of the national economic sector to which the pth marine sector belongs, is the proportion of non-marine sector value added in the value added of national economic sector q;

[0023] for:

[0024] ;

[0025] Among them, p is the serial number of the ocean department, is the added value of the pth marine sector, is the added value of the qth national economic sector related to the pth marine sector.

[0026] Optionally, separating the marine industry input-output information from the standard MRIO table includes:

[0027] Using the added value data of the marine industry and its national economic sectors in each region, the input-output information of the marine sector is separated from the standard MRIO table from the production side and the consumption side according to the bridge matrix. The method is as follows:

[0028] ;

[0029] ;

[0030] ;

[0031] ;

[0032] ;

[0033] in, is the bridge matrix, is the transpose of the bridge matrix, For the intermediate matrix after splitting, For the intermediate matrix before splitting, is the final usage matrix after splitting, is the final use matrix before splitting, is the export matrix after splitting, is the export matrix before splitting, is the added value matrix after splitting, is the added value matrix before splitting, is the import matrix after splitting, is the import matrix before splitting;

[0034] The split intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix are spliced according to the structure of the standard MRIO table to form the multi-regional marine economic input-output MMRIO table.

[0035] Optionally, separating the input-output information of the marine industry from the standard MRIO table also includes:

[0036] The standard form MRIO table and the bridge matrix are divided into blocks, the sub-bridge matrix of each region is extracted, and the input-output information of the marine department of each region is separated from the standard form MRIO table by:

[0037] ;

[0038] ;

[0039] ;

[0040] ;

[0041] ;

[0042] in, is the sub-bridge matrix of region a on the production side, is the transpose of the sub-bridge matrix of region b on the consumer side, is a modular intermediate matrix, For modularity the matrix is finally used, For modular export matrix, Adding value to the modular matrix, For modular import matrices, To separate the modular intermediate use matrix of the marine sector, To create a modular export matrix after separating the marine sector, To create a modular end-use matrix after separating the marine sector, For the modular value-added matrix after separating the marine sector, A modular import matrix after the separation of the marine sector;

[0043] The modular intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix after the marine sector is split out are spliced according to the structure of the standard MRIO table to form the multi-regional marine economic input-output MMRIO table.

[0044] Optional, balanced multi-regional marine economic input-output MRIO tables include:

[0045] The dual-proportional scaling method RAS or the cross-entropy method CE is used to level the spliced multi-regional marine economic input-output MMRIO table to obtain a balanced multi-regional marine economic input-output MMRIO table.

[0046] The present invention also provides a system for compiling a high-precision multi-region marine economic input-output table, comprising: a data module, a matching module, a standardization module, a bridge matrix and sub-bridge matrix construction module, a verification module, a splitting module, and a balancing module;

[0047] The data module is used to collect initial data of the research area and modularize it to obtain a database;

[0048] The matching module is configured to obtain an initial MRIO table containing the study area based on the data in the database, and if the input-output information of the study area is not in the same MRIO table, perform department matching to construct a department-consistent MRIO table; otherwise, no department matching is performed;

[0049] The standardization module is used to adjust the order of regions in the department-consistent MRIO table. If the input-output information of the research area is not in the same MRIO table, it is first modularized and re-modularized according to the standard structure of the multi-region input-output table. Then, the order of regions is adjusted to obtain the standard MRIO table.

[0050] The bridge matrix and sub-bridge matrix construction module is used to construct the bridge matrix and sub-bridge matrix according to the added value proportion of the marine industry in each region in its own industry;

[0051] The verification module is used to verify and update the original bridge matrix and sub-bridge matrix based on the latest historical data provided by the marine department;

[0052] The splitting module is used to split the input-output information of the marine industry from the standard MRIO table according to the bridge matrix to obtain a multi-region marine economic input-output MMRIO table;

[0053] The balancing module is used to balance the multi-regional marine economic input-output (MMRIO) table to obtain a balanced multi-regional marine economic input-output (MMRIO) table.

[0054] The beneficial effects of the present invention are as follows: (1) The technology of the present invention is applicable to the compilation of MMRIO tables at various spatial scales, including the global level, national level, regional level (such as coastal economic belts, urban agglomerations, bay areas, etc.) and city level (such as provincial cities or counties, cities or counties within a region, etc.). (2) The technology of the present invention is also applicable to the more refined splitting of marine sector economic and trade relations between regions, the splitting of marine-related industrial economic and trade relations between regions, and the refined splitting of other national economic sectors between regions. (3) The present invention can be used for land-sea economic linkage analysis, global value chain analysis of the marine economy, and the impact of sudden events on the marine economic system and non-marine economic system. (4) In the future, by nesting with resource accounts and ecological environment accounts, the present invention can comprehensively analyze the production and consumption ends of marine and non-marine industries and the impact of resources and the ecological environment on the entire industrial chain. In short, the present invention has wide applicability and provides a scientific basis and technical support for the systematic and detailed compilation of multi-regional marine economic input-output MMRIO tables. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0056] Figure 1 This is a flow chart of a method for compiling a high-precision multi-region marine economic input-output table according to an embodiment of the present invention;

[0057] Figure 2 Schematic diagram of a bridge matrix structure according to an embodiment of the present invention;

[0058] Figure 3 This is a schematic diagram of the splitting of the ocean department in an embodiment of the present invention. DETAILED DESCRIPTION

[0059] To make the above-mentioned purposes, features and advantages of the present invention more clearly understood, the technical solutions in the embodiments of the present invention are clearly and completely described below in conjunction with the drawings and specific implementation methods in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0060] Example 1:

[0061] For the case where the input-output information of the studied area is in the same input-output table, such as the construction of the multi-regional marine economic input-output MMRIO table for my country's coastal provinces (or coastal cities), as shown in the following example: Figure 1 As shown, the specific steps include:

[0062] Step 1: Collect initial data of the study area and modularize it:

[0063] In this implementation, initial data is modularized, utilizing a modular compilation framework and workflow. Initial data collection includes input-output data (including multi-regional input-output tables at the provincial or city level), marine industry economic development data, and macroeconomic data from various national economic sectors. Where data on marine industry value added, output value, and marine economic production activities are missing, prioritizing the use of known data is necessary. Using high-scale output data on marine economic activities and existing regional marine industry value added data, estimates are made using methods such as downscaling and aggregate constraints. Initial data is then stored in a data module in a pre-set format. Existing initial data can be verified and updated later through automatic access to the latest official statistics and data from other reliable sources.

[0064] Step 2: Obtain provincial or city-level input-output tables and perform sector matching:

[0065] Collect input-output tables that include coastal provinces or cities. Currently available input-output tables include MRIO tables for 31 Chinese provinces (including municipalities and autonomous regions) from the China Carbon Emission Database (CEADs), and MRIO tables for 313 regions, including Chinese cities and provinces. For both types of MRIO tables, input-output information for the studied regions is contained in the same table. Both MRIO tables cover 42 national economic sectors that meet national standards, so sector matching is not required.

[0066] Step 3: Construct a standard multi-regional marine economic input-output table:

[0067] Obtaining the standard form of the MRIO table includes: when the input-output information of the study area is in the same MRIO table, the data corresponding to the area in the MRIO table are adjusted in sequence according to the order of coastal areas and non-coastal areas, so as to obtain the standard form of the MRIO table.

[0068] Step 4: Construct bridge matrix and sub-bridge matrix:

[0069] (1) Estimation of the added value of marine industries in coastal provinces and cities:

[0070] Thirteen major marine industries that currently have public data and can be technically decomposed have been identified: marine fisheries, marine oil and gas, marine mining, marine salt, marine shipbuilding, marine chemical, marine biomedicine, marine engineering and construction, marine power, seawater utilization, marine transportation, coastal tourism, and marine scientific research, education, management and services.

[0071] Estimating the value added of marine industries at the provincial level and above: Assuming that the volume of economic production activity in marine industries is proportional to value added, actual data are prioritized. Specifically, the gross domestic product (GDP) data for each marine industry in provinces with official statistics (such as Guangdong Province) are fixed. For those without such data, a linear relationship is used for estimation, followed by an aggregate constraint. Specifically, based on the national value added data for each marine industry, the sum of the value added of each marine industry in the unknown province (the national total minus the known value added of Guangdong Province) is split among the remaining 10 coastal provinces according to the ratio of marine economic production activity in the 11 coastal provinces (cities, and municipalities). The values are then further adjusted using a dual aggregate constraint. Specifically, the initial estimated GDP data for each marine industry in the unknown province are used as the initial data. Under the dual equilibrium constraints of the total value added of all major marine industries in each unknown province and the total value added of each major marine industry in all unknown provinces (the national total minus the known value added of Guangdong Province), the classic dual scaling method (RAS) or the cross-entropy method (CE) is used to adjust the initial data and estimate the final value added of each marine industry in each coastal province. It should be noted that (1) in the case of missing marine economic production activities, it is necessary to use the output value of the marine sector (defined here as "the national economic sector where the marine sector is located"), use the output value distribution ratio between the known provinces and the provinces with unknown data, and then use the marine economic production activity data of the known provinces to estimate the marine economic production activity data of the missing provinces; (2) in the case of missing data for the required years, it is estimated by the ratio of the economic development scale (such as GDP) in different years; (3) in the case of a large difference in the original data, it is treated as 0; (4) in the case of no statistical data, it is first estimated according to the linear relationship, and then the total amount constraint is applied.

[0072] Estimating the added value of marine industries at or above the city level: Based on the above estimates, we assume that (1) the ratio between the marine sector and its marine-related sectors in each coastal city is the same as the ratio between the marine sector and its marine-related sectors in the province where it is located; and (2) only coastal cities have marine economies, not coastal inland cities. Using the ratio of GDP between coastal cities in each coastal province, we allocate the added value of the 13 marine industries in the 11 coastal provinces to each coastal city through downscaling.

[0073] (2) If Figure 2 As shown in the figure, according to the proportion of added value of marine industry in its own industry, the bridge matrix and sub-bridge matrix are constructed:

[0074] Construct the bridge matrix:

[0075]

[0076] Where C is the bridge matrix, is the sub-bridge matrix, i=1…k, is the number of coastal provinces (or cities).

[0077] Among them, the sub-bridge matrix is:

[0078]

[0079] in, is the identity matrix, is the number of marine sectors, is the number of national economic sectors, and is the sub-bridge matrix C i In the two cases, the corresponding forms, elements is the proportion of the added value of the pth marine sector in the added value of its corresponding marine-related sector, q is the serial number of the national economic sector to which the pth marine sector belongs, is the proportion of non-marine sector value added in the value added of national economic sector q;

[0080] for:

[0081]

[0082] Among them, p is the serial number of the ocean department, is the added value of the pth marine sector, is the value added of the qth national economic sector associated with the pth marine sector. When the estimated value added of China's marine industries at the city level results in a share greater than 1, the share of the value added of the marine sector at the provincial level in the value added of the corresponding marine-related sector should be used. If the share at the provincial level is also greater than 1, the share of the value added of the marine sector at the national level in the value added of the corresponding marine-related sector should be used to ensure the rationality of the estimate.

[0083] Step 5: Verify data:

[0084] The existing database will be updated and optimized using the latest multi-regional input-output tables (MRIOs) and marine industry economic activity statistics. The latest data will be collected from official statistics, scientific research results, and other sources, and compared and corrected with the existing database. This will update the existing data and improve potential assumptions.

[0085] Step 6: Split the marine sector:

[0086] Using the added value data of the marine industry and its national economic sectors in each region, the input-output information of the marine sector is split from the production and consumption sides of the standard MRIO table according to the bridge matrix. The detailed splitting principles and splitting methods are expressed as follows:

[0087]

[0088] in, is the bridge matrix, is the transpose of the bridge matrix, For the intermediate matrix after splitting, For the intermediate matrix before splitting, is the final usage matrix after splitting, is the final use matrix before splitting, is the export matrix after splitting, is the export matrix before splitting, is the added value matrix after splitting, is the added value matrix before splitting, is the import matrix after splitting, is the import matrix before splitting;

[0089] Subsequently, the split intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix are stored according to the structure of the standard MRIO table to obtain the MMRIO table.

[0090] The standard form MRIO table and bridge matrix can also be divided into blocks to extract the sub-bridge matrix of each region, and the input-output information of each part of the marine department of each region can be separated from the standard form MRIO table. First, each part of the MRIO table is modularized. Specifically, the intermediate use matrix Z is divided into blocks according to the number of departments. (number of departments) as a group, forming ; The final demand matrix and export matrix According to each (number of departments) 1 as a group, forming and , will increase the value matrix , import matrix According to each 1 (number of departments) as a group, forming , .

[0091]

[0092] Among them, a is the number of national economic sectors in each province (or city) on the production side, and b is the number of national economic sectors in each province (or city) on the consumption side, both of which are 42. For the intermediate matrix before block processing, For the final matrix before block processing, is the export matrix before block processing, is the value-added matrix before block processing, is the import matrix before block processing. is a modular intermediate matrix, For modularity the matrix is finally used, For modular export matrix, Adding value to the modular matrix, For modular import matrix.

[0093] The various parts of the MRIO table are separated into the ocean sector by introducing the bridge matrix. The detailed modular splitting process is as follows:

[0094]

[0095] in, is the sub-bridge matrix of region a on the production side, is the transpose of the sub-bridge matrix of region b on the consumer side, is a modular intermediate matrix, For modularity the matrix is finally used, For modular export matrix, Adding value to the modular matrix, For modular import matrices, To separate the modular intermediate use matrix of the marine sector, To create a modular export matrix after separating the marine sector, For the modular value-added matrix after separating the marine sector, A modular import matrix after the separation of the marine sector;

[0096] The modular intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix after the marine sector is split out are spliced according to the structure of the multi-regional input-output table to form the MMRIO table.

[0097] The split diagram of the marine sector is as follows: Figure 3 shown.

[0098] Step 7: Perform balancing:

[0099] The concatenated MMRIO table is leveled using the dual-ratio scaling method RAS or the cross entropy method CE to obtain a balanced MMRIO table. The balanced MMRIO table satisfies:

[0100] Use the GDP of each region to shrink the final use and exports of each sector in the corresponding region proportionally;

[0101] Use the GDP of each region to shrink the value added of each sector in the corresponding region proportionally;

[0102] The row limit for each region and sector is = total output - final use - export;

[0103] The column limit for each region and department is = total input - added value - import amount.

[0104] Finally, the basic form of the compiled multi-regional marine economic input-output table is shown in Table 1.

[0105] Table 1

[0106] .

[0107] The method in this example is universally applicable to a variety of situations, both domestically and internationally, including global, national, regional (e.g., coastal economic zones, city clusters, bay areas), and city (e.g., cities or counties within provincial administrative divisions, and cities or counties within regions). In practice, the initial data can be replaced with input-output tables and marine economic data for the study area.

[0108] Example 2:

[0109] For the case where the input-output information of the studied region is not in the same input-output table, such as for the target region in China, the construction of its MMRIO table specifically includes the following steps:

[0110] Step 1: Modularize the initial data.

[0111] Step 2: Obtain the city-level input-output table and perform sector matching:

[0112] If the input-output information for the study area is not contained in the same input-output table, it is necessary to match the sectors of all input-output tables to consistent sectors, i.e., perform sector matching. Sector matching involves first establishing 42 benchmark sectors based on the National Economic Industry Classification Standard. Then, using these benchmark sectors, the data for each MRIO table is meticulously split, merged, and reorganized from both the production side (processing the intermediate use matrix, final use matrix, and export matrix in the row direction) and the consumption side (processing the intermediate use matrix, value-added matrix, and import matrix in the column direction). This accurately maps the data for all national economic sectors in each MRIO table to the aforementioned benchmark sectors, generating new data corresponding to the benchmark sectors. This allows all MRIO tables to be matched to consistent sectoral data.

[0113] The city-level input-output tables here are derived from the MRIO tables (42 sectors) for 313 regions in China from the China Carbon Emission Database (CEADs), as well as the multi-regional MRIO tables (134 sectors) for emerging economies worldwide from the EMERGING database. Based on research needs, the data corresponding to the production and consumption sectors in the EMERGING database were merged, split, and reorganized to generate data for 42 national economic sectors.

[0114] Step 3: Process the input-output table into a standard Bay Area-level multi-region input-output table:

[0115] If the input-output information of the study area is not in the same MRIO table, the MRIO table after department matching will be modularized according to its components, and the trade volume between the missing regions will be estimated using customs data and the global multi-regional input-output table. Then, modular splicing will be performed according to the standard structure of the multi-regional input-output table to construct a complete multi-regional input-output table including all study areas. The study areas in the complete multi-regional input-output table will then be sorted according to coastal and non-coastal areas to obtain a standard MRIO table. Specifically:

[0116] It is necessary to embed the input-output table of China Region A with the input-output information of China Region B and China Region C. Assume that (1) the proportion of trade in services between China Region A and China Region B, China Region C, and other overseas regions is consistent with the proportion of trade of China Region A as a whole with these regions; (2) the proportion of trade in various types of final products between China Region A and China Region B, China Region C, and other overseas regions is consistent with the proportion of trade of China Region A as a whole with these regions; (3) the distribution between intermediate products and final products is based on the structure of importing cities. Then, using customs data and global multi-regional input-output tables, we connect the MRIO table of coastal provinces / cities in China Region A with the MRIO table including China Region B and China Region C, and obtain the trade volume of intermediate products and final products between each region in China Region A and China Region B, China Region C, and other overseas regions.

[0117] (1) Input-output information of City A in the target region of China:

[0118] Table 2 shows the modular form of the multi-regional marine economic input-output table for China's target areas. , , , , , , , , , , , , , , , , , Among them, Z11 is the intermediate use matrix of China region D; Z14 is the intermediate use matrix of China's 304 regions for China region D; Z41 is the intermediate use matrix of China region D for China's 304 regions; Z44 is the intermediate use matrix of China's 304 regions; F11 is the final use matrix of China region D; F14 is the final use matrix of China's 304 regions for region D; F41 is the final use matrix of China region D for China's 304 regions; F44 is the final use matrix of China's 304 regions; Im1 is China region D The import matrix of intermediate use of D; Im4 is the import matrix of intermediate use of 304 regions in China; Im5 is the import matrix of final use of D in China; Im8 is the import matrix of final use of 304 regions in China; VA1 is the value-added matrix of D in China; VA4 is the value-added matrix of 304 regions in China; Tot1 is the total input or total output matrix of D in China; Tot4 is the total input or total output matrix of 304 regions in China; Ex1 is the export matrix of D in China; Ex4 is the export matrix of 304 regions in China.

[0119] Table 2

[0120] .

[0121] (2) For China Region B and China Region C, prepare their own non-competitive single-region input-output tables and store them according to their input-output structures. The non-competitive single-region input-output table is an economic analysis tool used to describe the sources and uses of various products in the national economy. Unlike the competitive input-output table, the non-competitive input-output table breaks down intermediate and final uses, distinguishing between domestic products and imported goods.

[0122] (3) The trade data between China region B and China region C are stored according to the trade direction.

[0123] Divide the data in (2) and (3) into different modules for storage: , , , , , , , , , , , ; , , , ; , , , .in, is the intermediate usage matrix for region B in China; The final use matrix of China region B; Ex_HK is the export matrix of China region B; is the intermediate use matrix of China region C; F33 is the final use matrix of China region C; Ex_MAC is the export matrix of China region C; Im2 is the import matrix of intermediate use of China region B; Import matrix used by C in China; The import matrix for the final use of region B in China; The import matrix for the final use of region C in China; is the value-added matrix of region B in China; is the value-added matrix of region C in China; is the total output of region B in China; is the total output of region C in China; The usage matrix for flows from region B in China to region C in China; The final use matrix for flows from region B in China to region C in China; The usage matrix for flows from China region C to China region B; The final use matrix for flows from China region C to China region B; It is the intermediate usage matrix for flows from various regions in China A to China B; It is the intermediate usage matrix of the flow from various places in China region A to China region C; The final use matrix of flows from various regions in China A to China B; This is the final use matrix of the flow from various places in region A in China to region C in China.

[0124] (4) Calculate the ratio between the intermediate use matrix (Z) and the final use matrix (F) of China region A flowing to China region B and China region C:

[0125] For the intermediate use matrix Z of 42 national economic sectors, customs data (agriculture, industry, and construction) and intermediate product data (services) from the EMERGING database were used. Specifically: ① For agriculture, industry, and construction, the customs data were processed by comparing the customs codes (HS) with the national economic sector codes to obtain the import and export data between agriculture, industry, and construction in 313 regions and Region B, Region C, and other overseas regions. The trade ratios between Region A and Region B, Region C, and other overseas regions were also calculated. ② For services, since customs trade statistics for individual cities in Region A are unavailable, data on trade in services between Region A and Region B, Region C, and other overseas regions from the EMERGING database were used to obtain the trade ratios between Region A and Region B, Region C, and other overseas regions. Here, it is assumed that the trade ratios of services between each region within Region A and Region B, Region C, and other overseas regions remain consistent with the trade ratios of Region A as a whole. Finally, by combining the above proportions of agriculture, industry, construction, and services, we can obtain the import and export ratios of the 42 national economic sectors in the 313 regions of China Region A among China Region B, China Region C, and other overseas regions, which are recorded as vector sets Ratio1 and Ratio2 respectively.

[0126] For the final use demand (F), we use the final product data from the EMERGING database. By processing the final product trade data between China Region A, China Region B, China Region C, and other overseas regions in the EMERGING database, we can determine the ratios between these three regions. Furthermore, we assume that the trade ratios of each final product category between each region within China Region A and China Region B, China Region C, and other overseas regions are consistent with the trade ratios of China Region A as a whole. This yields the import and export ratios of each final product category within China Region A's 313 regions with China Region B, China Region C, and other overseas regions. In reality, only one ratio is used; here, the import ratio is denoted as the vector set Ratio3.

[0127] (5) Expand the Z and F of each region in China region A to all departments in China region B and China region C:

[0128] ① Use Ratio2 to extract the export values (Ex) of 42 sectors in 313 regions to China B, China C, and other overseas regions from the export statistics of each sector in each region in China A.

[0129] ② Normalize Z and F of China Region B and China Region C, and then separate their respective total Z and F values (Ex_Z, Ex_F) from exports (Ex).

[0130] ③ Based on the economic structure of the importing cities, China Region B and China Region C, it is estimated that China Region B and China Region C come from 313 regions Z and F.

[0131] ④Use As a sum constraint, adjust Z and F.

[0132] Modularize the results: Among them, Z12 is the intermediate use matrix of China region B for China region D; Z42 is the intermediate use matrix of China region B for China region A other than China region D; Z13 is the intermediate use matrix of China region C for China region D; Z43 is the intermediate use matrix of China region C for China region A other than China region D; F12 is the final use matrix of China region B for China region D; F42 is the final use matrix of China region B for China region A other than China region D; F13 is the final use matrix of China region C for China region D; F43 is the final use matrix of China region C for China region A other than China region D.

[0133] (6) Expand the intermediate use matrix Z and final use matrix F of all sectors in regions B and C of China region A:

[0134] The operations for the intermediate demand matrix Z are the same as those for (5), except that exports in (5) are replaced by imports, and Ratio 1 is used. Furthermore, for the final demand matrix F, Ratio 3 is used to separate the import statistics of each sector in each of the 313 regions into the import values of each type of final demand from the same sectors in Region B, Region C, and other overseas regions.

[0135] Modularize the results: Among them, Z21 is the intermediate use matrix of China region D for China region B; Z24 is the intermediate use matrix of China region A other than China region D for China region B; F21 is the final use matrix of China region D for China region B; F24 is the final use matrix of China region A other than China region D for China region B; Z31 is the intermediate use matrix of China region D for China region C; Z34 is the intermediate use matrix of China region A other than China region D for China region C; F31 is the final use matrix of China region D for China region C; F34 is the final use matrix of China region A other than China region D for China region C.

[0136] Adjust the import and export values of each region in China Region A, China Region B, and China Region C:

[0137]

[0138] Among them, Im1_ is the import from abroad for intermediate use belonging to Chinese region D in Guangdong Province; Im4_ is the import from abroad for intermediate use belonging to the remaining 304 Chinese regions except Chinese region D; Im5_ is the import from abroad for final use belonging to Chinese region D in Guangdong Province; Im8_ is the import from abroad for final use belonging to the remaining 304 Chinese regions except Chinese region D; Im2_ is the import from abroad for intermediate use belonging to Chinese region B; Im3_ is the import from abroad for intermediate use belonging to Chinese region C; Im6_ is the import from abroad for final use belonging to Chinese region B; Im7_ is the import from abroad for final use belonging to Chinese region C; Ex1_ is the export from abroad of products belonging to Chinese region D in Guangdong Province; Ex4_ is the export from abroad of products belonging to the remaining 304 Chinese regions except Chinese region D; Ex_HK _ is the export of products belonging to Chinese region B to foreign countries; _ is the export of products from region C in China to foreign countries.

[0139] By splicing all the modules together and adjusting the order of the research areas according to the form of coastal provinces (or cities) and non-coastal provinces (or cities), a standard MRIO table can be formed.

[0140] Step 4: Construct the bridge matrix:

[0141] Based on the known added value of the 13 marine industries in China's target regions, the added value of the 13 marine industries in China's target regions was allocated to each coastal city through downscaling based on the GDP ratios among coastal cities in China's target regions, by assuming that (1) the ratio between the marine sector and its marine-related sectors in each coastal city is the same as that in China's target regions; and (2) only coastal cities have marine economies, while coastal inland cities do not.

[0142] Thirteen major marine industries that can achieve technological decomposition in China's target areas have been identified: marine fisheries, marine oil and gas, marine mining, marine salt, marine shipbuilding, marine chemical, marine biomedicine, marine engineering and construction, marine power, seawater utilization, marine transportation, coastal tourism, and marine scientific research, education, management and services.

[0143] The construction process of the bridge matrix is as follows:

[0144]

[0145] Where C is the bridge matrix, is the sub-bridge matrix, i=1…k, is the number of coastal provinces (or cities), which in this embodiment is the number of cities in the target area of China.

[0146] Among them, the sub-bridge matrix is:

[0147]

[0148] in, is the identity matrix, is the number of marine sectors, is the number of national economic sectors, and is the sub-bridge matrix C i In the two cases, the corresponding forms, elements is the proportion of the added value of the pth marine sector in the added value of the national economic sector to which it belongs, q is the serial number of the national economic sector to which the pth marine sector belongs, is the proportion of non-marine sector value added in the value added of national economic sector q;

[0149] for:

[0150]

[0151] Among them, p is the serial number of the ocean department, is the added value of the pth marine sector, is the added value of the qth national economic sector related to the pth marine sector.

[0152] Step 5: Calibrate the data to update the data.

[0153] Improve the accuracy of MRIO tables and bridging matrices by updating the original database and refining underlying assumptions using the latest or calibrated MRIO tables, socio-economic statistics, and customs data.

[0154] Step 6: Split out the marine sector:

[0155] Using the value-added data of the marine sector and the national economic sector to which it belongs, the input-output information of the marine sector is split from the standard form of the MRIO table from the production side and the consumption side according to the bridge matrix.

[0156] Step 7: Balance the table.

[0157] The method of this embodiment is universal and is applicable not only to the compilation of MMRIO tables for target regions in China, but also to situations where input-output information for other domestic and foreign research regions comes from two or more MRIO tables.

[0158] Example 3:

[0159] like Figure 1 As shown, a system for compiling a high-precision multi-region marine economic input-output table is used to implement the method of any step in Examples 1 to 2, comprising: a data module, a matching module, a standardization module, a bridge matrix and sub-bridge matrix construction module, a verification module, a splitting module, and a balancing module;

[0160] The data module is used to collect the initial data of the study area and modularize it to obtain the database;

[0161] The matching module is used to obtain the initial MRIO table containing the study area based on the data in the database. If the input-output information of the study area is not in the same MRIO table, department matching is performed to build a department-consistent MRIO table. Otherwise, department matching is not performed.

[0162] The standardization module is used to adjust the order of regions in the department-consistent MRIO table. If the input-output information of the research area is not in the same MRIO table, it will first be modularized and re-modularized according to the standard structure of the multi-region input-output table. Then, the order of regions will be adjusted to obtain a standard MRIO table.

[0163] The bridge matrix and sub-bridge matrix construction module is used to construct the bridge matrix and sub-bridge matrix according to the proportion of the added value of the marine sector in each region in the added value of the national economic sector to which it belongs;

[0164] The verification module is used to verify and update the original bridge matrix and sub-bridge matrix based on the latest higher quality historical data provided by the marine department;

[0165] The splitting module is used to split the input-output information of the marine industry from the standard MRIO table according to the bridge matrix to obtain the multi-regional marine economic input-output MMRIO table;

[0166] The balancing module is used to perform balancing processing and obtain a balanced MMRIO table.

[0167] The embodiments described above are merely descriptions of preferred embodiments of the present invention and are not intended to limit the scope of the present invention. Without departing from the spirit of the present invention, various modifications and improvements made to the technical solutions of the present invention by persons skilled in the art should fall within the scope of protection defined by the claims of the present invention.

Claims

1. A method for compiling a high-precision multi-region marine economic input-output table, characterized by: include: Collect initial data of the study area and modularize it to obtain a database; Obtaining an initial MRIO table containing the study area based on the data in the database; if the input-output information of the study area is not in the same MRIO table, performing department matching to construct a department-consistent MRIO table; otherwise, no department matching is performed; Adjust the order of regions in the department-consistent MRIO table. If the input-output information of the study area is not in the same MRIO table, first perform modular processing and re-module splicing according to the standard structure of the multi-region input-output table. Then adjust the order of regions to obtain the standard MRIO table. According to the added value proportion of each region's marine industry in its own industry, a bridge matrix and a sub-bridge matrix are constructed; The bridge matrix includes: = ； Where C is the bridge matrix, is the sub-bridge matrix, i=1…k, is the number of study areas in the standardized MRIO table; Among them, the sub-bridge matrix is: ； in, is the identity matrix, is the number of marine sectors, is the number of national economic sectors, and is the sub-bridge matrix C i In the two cases, the corresponding forms, elements is the proportion of the added value of the pth marine sector in the added value of the national economic sector to which it belongs, q is the serial number of the national economic sector to which the pth marine sector belongs, is the proportion of non-marine sector value added in the value added of national economic sector q; for: ； Among them, p is the serial number of the ocean department, is the added value of the pth marine sector, is the added value of the qth national economic sector related to the pth marine sector; Verify and update the original bridge matrix and sub-bridge matrix based on the latest historical data provided by the marine department; According to the bridge matrix, the input-output information of the marine industry is separated from the standard MRIO table to obtain a multi-regional marine economic input-output MMRIO table; Separating marine industry input-output information from the standard MRIO table includes: Using the added value data of the marine industry and its national economic sectors in each region, the input-output information of the marine sector is separated from the standard MRIO table from the production side and the consumption side according to the bridge matrix. The method is as follows: ； ； ； ； ； in, is the bridge matrix, is the transpose of the bridge matrix, For the intermediate matrix after splitting, For the intermediate matrix before splitting, is the final usage matrix after splitting, is the final use matrix before splitting, is the export matrix after splitting, is the export matrix before splitting, is the added value matrix after splitting, is the added value matrix before splitting, is the import matrix after splitting, is the import matrix before splitting; The split intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix are spliced according to the structure of the standard MRIO table to form the multi-regional marine economic input-output MMRIO table; Separating marine industry input-output information from the standard MRIO tables also includes: The standard form MRIO table and the bridge matrix are divided into blocks, and the sub-bridge matrices of each region are extracted. The input-output information of the marine sector of each region is separated from the standard form MRIO table by: ； ； ； ； ； in, is the sub-bridge matrix of region a on the production side, is the transpose of the sub-bridge matrix of region b on the consumer side, is a modular intermediate matrix, For modularity the matrix is finally used, For modular export matrix, Adding value to the modular matrix, For modular import matrices, To separate the modular intermediate use matrix of the marine sector, To create a modular export matrix after separating the marine sector, To create a modular end-use matrix after separating the marine sector, For the modular value-added matrix after separating the marine sector, A modular import matrix after the separation of the marine sector; The modular intermediate use matrix, final use matrix, export matrix, import matrix, and value-added matrix after the marine sector is split out are spliced according to the structure of the standard MRIO table to form the multi-regional marine economic input-output MMRIO table; The multi-regional marine economic input-output (MMRIO) table is balanced to obtain a balanced multi-regional marine economic input-output (MMRIO) table.

2. The method for compiling a high-precision multi-regional marine economic input-output table according to claim 1 is characterized in that: Collecting initial data of the research area and modularizing it includes: collecting initial data including input-output tables, customs data, marine industry economic data, and macroeconomic data, and storing the initial data in the database according to a preset format.

3. The method for compiling a high-precision multi-regional marine economic input-output table according to claim 1 is characterized in that: Department matching includes: splitting, merging and reorganizing department data through the production end and consumption end in turn, and mapping the department data to a unified benchmark department.

4. The method for compiling a high-precision multi-regional marine economic input-output table according to claim 1 is characterized in that: Obtaining the standard form MRIO includes: If the input-output information of the study areas is in the same MRIO table, the data in the sector-consistent MRIO table will be adjusted according to the order of coastal and non-coastal regions. If the input-output information of the study areas is not in the same MRIO table, the sector-consistent MRIO table will be modularized according to its components, and the trade volume between the missing regions will be estimated using customs data and the global multi-regional input-output table. Then, the modularization will be spliced according to the standard structure of the MRIO table to construct a complete MRIO table including all the study areas. The study areas in the complete MRIO table will then be sorted according to the order of coastal and non-coastal regions to form the standard form of the MRIO table.

5. The method for compiling a high-precision multi-regional marine economic input-output table according to claim 1 is characterized in that: The balanced multi-regional marine economic input-output MRIO table includes: The dual-proportional scaling method RAS or the cross-entropy method CE is used to level the spliced multi-regional marine economic input-output MMRIO table to obtain a balanced multi-regional marine economic input-output MMRIO table.

6. A system for compiling a high-precision multi-regional marine economic input-output table for implementing the method described in any one of claims 1 to 5, characterized in that: include: Data module, matching module, standardization module, bridge matrix and sub-bridge matrix construction module, verification module, splitting module and balancing module; The data module is used to collect initial data of the research area and modularize it to obtain a database; The matching module is configured to obtain an initial MRIO table containing the study area based on the data in the database, and if the input-output information of the study area is not in the same MRIO table, perform department matching to construct a department-consistent MRIO table; otherwise, no department matching is performed; The standardization module is used to adjust the order of regions in the department-consistent MRIO table. If the input-output information of the research area is not in the same MRIO table, it is first modularized and re-modularized according to the standard structure of the multi-region input-output table. Then, the order of regions is adjusted to obtain the standard MRIO table. The bridge matrix and sub-bridge matrix construction module is used to construct the bridge matrix and sub-bridge matrix according to the added value proportion of the marine industry in each region in its own industry; The verification module is used to verify and update the original bridge matrix and sub-bridge matrix based on the latest historical data provided by the marine department; The splitting module is used to split the input-output information of the marine industry from the standard MRIO table according to the bridge matrix to obtain a multi-region marine economic input-output MMRIO table; The balancing module is used to balance the multi-regional marine economic input-output (MMRIO) table to obtain a balanced multi-regional marine economic input-output (MMRIO) table.

Images