Natural resource entity change information processing and message subscription method and system

Abstract

The invention discloses a natural resource entity change information processing and message subscription method, and relates to the field of data processing. According to the specific implementation scheme, an entity change processing and message subscribing device is used for monitoring natural resource changes of a natural resource entity library in real time; the natural resource entity library synchronizes and gathers the natural resource entities and the business entities obtained from the business unit; judging whether the natural resource entity is changed or not, and pushing change information to an entity change processing and message subscribing device; the service unit subscribes natural resource entity change information to the entity change processing and message subscribing device, and the entity change processing and message subscribing device pushes the natural resource entity change information to the service module according to the subscribing information of the service unit; and the service unit develops a service according to the subscribed message type and the received natural resource entity change information. According to the invention, the processing efficiency of the natural resource land approval business can be improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method and system for natural resource entity change information processing and message subscription. Background Art

[0002] The natural resource land approval business includes pre-examination, application, land acquisition, land supply, registration and other stages. At the same time, each stage is interspersed with small business links. Each stage and business link is both independent and interrelated, and each approval process generally establishes its own approval workflow and system, which are independent of each other. In order to promote the circulation of business, the results of approvals at each stage are currently unified and aggregated, and a search and query interface is provided to the outside world, so that downstream businesses can discover changes in upstream businesses, or a unified platform containing the circulation functions of all business lines is built to achieve the connection and circulation between businesses. However, by aggregating data and providing queries, downstream businesses are required to passively query (inquire) whether upstream businesses have changed. Upstream businesses cannot promptly notify downstream businesses when their businesses change, resulting in low efficiency in the processing of natural resource land approval business. Summary of the invention

[0003] Based on this, the present invention provides a method for natural resource entity change information processing and message subscription to solve the problem of low efficiency in natural resource land approval business processing.

[0004] The first aspect of the present invention provides a method for processing natural resource entity change information and subscribing to messages, comprising:

[0005] Using entity change processing and message subscription devices to monitor the changes of natural resources in the natural resource entity library in real time;

[0006] The natural resource entity library synchronizes and aggregates the natural resource entities and business entities obtained from the business units;

[0007] Determine whether the natural resource entity has changed, and push the change information to the entity change processing and message subscription device;

[0008] The business unit subscribes to the natural resource entity change information from the entity change processing and message subscription device, and the entity change processing and message subscription device pushes the natural resource entity change information to the business module according to the subscription information of the business unit;

[0009] The business unit performs business according to the subscribed message type and the received natural resource entity change information.

[0010] The natural resource entity library is a spatial database, which uses a postgresql database combined with a postgis extension to manage natural resource entities and business entities.

[0011] The sub-modules of the business unit respectively establish a natural resource entity library, extract the required natural resource entity and business entity types and fields from the sub-modules through kettle, and convert the data extracted from the sub-modules according to the rules to obtain the converted data, and synchronize all the converted data to the local database in real time and summarize the natural resource entities.

[0012] In the process of real-time monitoring of natural resource changes in the natural resource entity library, the change information is filtered through the entity library change information filter, and only the natural resource changes whose information subject is the natural resource entity are retained.

[0013] The operation of pushing the natural resource entity change information to the entity change processing and message subscription device includes:

[0014] The natural resource entities in the natural resource entity library are screened and it is determined whether it is defined change information. If so, the change information is assembled according to the entity type, and the change information is synchronized with the entity change processing and message subscription device through the message queue for subscription by the business unit.

[0015] The data format of the change message pushed by the entity change processing and message subscription device to the business unit includes entity type, entity identification code, change status, and change entity content.

[0016] The change status includes adding, modifying, and deleting. When the change status is adding or modifying, the change entity content is all the information of the entity. When the change status is modifying, the change entity content is the field information of the entity change.

[0017] A second aspect of the present invention provides a system for processing natural resource entity change information and message subscription, comprising:

[0018] A monitoring and pushing unit, used to monitor the natural resource changes of the natural resource entity library in real time by using the entity change processing and message subscription device, and push the natural resource entity change information to the business module according to the subscription information of the business unit;

[0019] A business unit, used to synchronize and aggregate natural resource entities and business entities into the natural resource entity library and to conduct business according to subscribed message types and received natural resource entity change information;

[0020] The data aggregation unit is used for the natural resource entity library to synchronize and aggregate the natural resource entities and business entities obtained from the business unit, determine whether the natural resource entity has changed, and push the change information to the entity change processing and message subscription device.

[0021] A third aspect of the present invention provides a device, comprising:

[0022] processor;

[0023] a memory for storing processor-executable instructions;

[0024] The processor is configured to call the instructions stored in the memory to execute the above method.

[0025] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which computer program instructions are stored, and the computer program instructions implement the above method when executed by a processor.

[0026] Beneficial effect: The present invention establishes a subscription mechanism for natural resource entity change information. When entity information changes, it can immediately notify relevant business entities of specific change information, thereby solving the problem that upstream businesses are unable to promptly notify downstream businesses of business changes, leading to low efficiency in natural resource land approval business processing.

[0027] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] The accompanying drawings are used to better understand the present invention and do not constitute a limitation of the present invention.

[0029] Figure 1 It is a flow chart of natural resource entity change information monitoring and information feedback provided by the present invention. DETAILED DESCRIPTION

[0030] The following is a description of exemplary embodiments of the present invention in conjunction with the accompanying drawings, including various details of the embodiments of the present invention to facilitate understanding, which should be considered as merely exemplary. Therefore, it should be recognized by those of ordinary skill in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the present invention. Similarly, for clarity and conciseness, the description of well-known functions and structures is omitted in the following description.

[0031] Based on this, the present invention provides a method for natural resource entity change information processing and message subscription to solve the problem of low efficiency in natural resource land approval business processing.

[0032] like Figure 1 As shown, the first aspect of the present invention provides a method for natural resource entity change information processing and message subscription, comprising:

[0033] S1: Use the entity change processing and message subscription device to monitor the natural resource changes in the natural resource entity library in real time. It should be noted that:

[0034] Natural resource entities include current status entities, approval entities, land acquisition entities, land supply entities, plot entities, etc. The monitored entity information includes two types of changes: attribute information changes and spatial information changes.

[0035] The natural resource entity database is a spatial database that uses the postgresql (an open source relational database management system that supports the SQL query language and provides many advanced features) database combined with postgis (an open source spatial database extension module) to extend the management of natural resource entities and business entities. postgis adds support for geospatial data to the PostgreSQL database. Through postgis and PostgreSQL, geospatial data, such as geometric objects such as points, lines, and surfaces, and their attribute information, can be stored, managed, and queried.

[0036] For postgresql, entity changes can be obtained by CDC (data change capture) or Listen-Notify. By using Listen (listening) to the changes in the database data of postgresql, the change information is sent through Notify (notification). Therefore, the system can monitor the data changes at the database level. Through the Listen-Notify function, specific change messages can be broadcast to specific channels when different types of natural resource entity data change (including addition, modification, and deletion). The application can obtain changes in natural resource entity data by listening to specific channels. The message type is in json data format, including the changed entity space identity code, entity type, entity name, area, address and other related information. Taking land supply as an example, the data format includes entity space identity code, land supply plot identification, plot number, plot name, project name, city code, district and county code, township, land location, plot area, total land supply area, supply area, approval date, approval document number, investment subject nature, industry classification, etc.

[0037] S2: The natural resource entity library synchronizes and aggregates the natural resource entities and business entities obtained from the business units. It should be noted that:

[0038] The sub-modules of the business unit respectively establish natural resource entity libraries, extract the required natural resource entities and business entity types and fields from the sub-modules through kettle, and convert the data extracted from the sub-modules according to the rules to obtain the converted data. All the converted data are synchronized to the local database in real time and the natural resource entities are summarized.

[0039] S3: Determine whether the natural resource entity has changed, and push the change information to the entity change processing and message subscription device. It should be noted that:

[0040] In the process of real-time monitoring of natural resource changes in the natural resource entity library, the change information is filtered through the entity library change information filter, and only the natural resource changes whose information subject is the natural resource entity are retained.

[0041] The entity change processing and message subscription device includes an entity library change information listener, an entity library change information filter, a natural resource entity change information assembler, a natural resource entity change information subscriber and a natural resource entity change information pusher.

[0042] S4: The business unit subscribes to the natural resource entity change information from the entity change processing and message subscription device, and the entity change processing and message subscription device pushes the natural resource entity change information to the business module according to the subscription information of the business unit. It should be noted that:

[0043] The operation of pushing the natural resource entity change information to the entity change processing and message subscription device includes:

[0044] The natural resource entities in the natural resource entity library are screened and judged whether they are defined change information. If so, the change information is assembled according to the entity type, and the change information is synchronized with the entity change processing and message subscription device through the message queue for subscription by the business unit.

[0045] The natural resource entity change information assembler can be assembled according to the general natural resource format change format. Because the table structure and entity expression of each library are different, a general business format is predefined. The message queue is implemented through rabbitmq ("rabbit message queue", rabbitmq is an open source message broker software that implements the advanced message queue protocol for transmitting messages in distributed systems). The switch and queue are established through the topic mode, and messages are sent to the specified switch and queue.

[0046] The data format of the change message pushed by the entity change processing and message subscription device to the business unit includes entity type, entity identification code, change status, and change entity content.

[0047] The change status includes adding, modifying, and deleting. When the change status is adding or modifying, the change entity content is all the information of the entity. When the change status is modifying, the change entity content is the field information of the entity change. The spatial field name is GEOM, and the format is GeoJSON point, line, surface, multi-point, multi-line, multi-surface, and the coordinate system is CGCS 2000.

[0048] The complete entity change content reservation message format is shown in Tables 1 to 7.

[0049] Table 1: Current Entities

[0050] Serial number Column Name Data Types length illustrate 1 STBSM Text 50 Entity Identifier 2 KJSF Text 50 Spatial identity coding 3 STFL Text 50 Entity Classification 4 STFLM Text 50 Entity Classification Code 5 STMC Text 50 Entity Name 6 TBMJ double Patch area 7 BYZ Text 50 Standard Address 8 ZDTYB Text 50 Unified parcel coding 9 DLBM Text 50 Land type coding 10 DLMC Text 50 Land type name 11 QSDWDM Text 50 Ownership unit code 12 QSDWMC Text 50 Name of Ownership Unit 13 GEOM geometry Spatial fields

[0051] {"STBSM":"330402007019GB00167J00000001","KJSFBM":"MA1001NE105H2033320","STFL":"Class II Urban Residential Land","STFLM":"070102","STMC":"Wanghu Mingdu",

[0052] "TBMJ":210927.58,"BZDZ":"Wanghu Mingdu, No. 2505, Nanxi West Road, Yundong Community, Dongzha Street, Nanhu District, Jiaxing City, Zhejiang Province","ZDTYBM":"330402007019GB00167","DLBM":"0701","DLMC":"Urban Residential Land","QSDWDM":"3304020000000000000","QSDWMC":"Nanhu District",

[0053] "GEOM":"POLYGON((120.729072620000011 30.38881477700005,

[0054] 120.729019956000116 30.388830774000041,

[0055] 120.728944206000051 30.388461663000044,))"}

[0056] Table 2: Land use pre-examination entities

[0057]

[0058]

[0059] Example: {"XMMC":"Shuangfeng Village Cultural Service Center, Yuanhua Town","XZ":"Yuanhua Town","SQYDMJ":0.1314,"YT":"Rural Community Service Facility Land","ZH":"Usage No. 330481202102776","FZRQ":"2021 / 12 / 9","SQDW":"Shuangfeng Share Economic Cooperative, Yuanhua Town, Haining City","XMDM":"2111-330481-20-01-883221","MJ":1313.5,"GEOM":"POLYGON((120.729072620000011 30.38881477700005,120.729019956000116 30.388830774000041,120.72894420600005130.388461663000044,))"}

[0060] Table 3: Construction land approval entities

[0061] Serial number Column Name Data Types length illustrate 1 XMMC Text 100 Project Name 2 DKMC Text 100 Plot Name 3 PZQ Text 100 Approval No. 4 YT Text 50 Land use 5 MJ Double Plot Area 6 BSM Text 50 Identification code 7 NZYXMBS Text 50 Agricultural conversion project logo 8 SFZS Text 10 Is it levied? 9 SFYS Text 10 Whether pre-examination 10 SFTDDJ Text 10 Is the land registered? 11 SFCC Text 10 Whether it is found 12 SFTDZZ Text 10 Whether land consolidation 13 GEOM geometry Spatial fields

[0062] Example: {"XMMC":"Implementation Plan for Linking Increase and Reduction of Urban and Rural Construction Land in Haining City in 2019 (III)","DKMC":"XC1908",

[0063] "PZWH":"Zhejiang Land and Resources Code (330481)

[2019] 0010",

[0064] "YT":"Industry","MJ":50054.29,"BSM":"8BA13798404750716FD301F1798BA39B1",

[0065] "NZYXMBS":"8BA13798404750716FD301F1798BA39B","SFZS":"Yes","SFYS":"Yes","SFTDDJ":"Yes","SFCC":"Yes","SFTDZZ":"Yes",

[0066] "GEOM":"POLYGON((120.362201592000019 30.469385532000047,

[0067] 120.362127867000027 30.469475226000043,

[0068] 120.361570713000106 30.469471362000036))"}

[0069] Table 4: Land Bank Entities

[0070] Serial number Column Name Data Types length illustrate 1 JZDSX_GUID Text 200 Identification code 2 ZD_ZL Text 200 Land location 3 CREATE_DAT Text 200 Creation Date 4 ZD_MJ Text 200 Land area 5 DW_MC Text 200 Unit Name 6 DZ_BA_BH Text 200 Electronic supervision number 7 ZD_BH Text 200 Parcel number 8 CREATE_USE Text 200 Creator 9 YGY_MJ Text 200 Area supplied 10 CB_GUID Text 200 Reserve plot number 11 SB_SJ Text 200 Reporting time 12 XZQ_DM Text 200 Administrative region code 13 GEOM geometry Spatial fields

[0071] {"JZDSX_GUID":"5b61e04d-6dec-4881-ab73-93dc8075b8f2","ZD_ZL":"South side of Tangnan Road, west side of Nongfeng Road","CREATE_DAT":"2021-04-19","ZD_MJ":"4.99","DW_MC":"Haining Land Acquisition and Storage Center","DZ_BA_BH":"3304812014R50380" ,"ZD_BH":"hntc2021004","CREATE_USE":"Haining Reserve Center","YGY_MJ":"5.11","CB_GUID":"28a69e5c-4b02-35ca-2439-b11a3250e99f","SB_SJ":"2021-08-11","XZQ_DM":"330481","GEOM":"POLYGON

[0072] ((120.71146817500005 30.525140016000023,120.71306800200011430.523684221000053,120.715335501000027 30.523661442000048))"}

[0073] Table 5: Land Supply Entities

[0074] Serial number Column Name Data Types length illustrate 1 SSX Text 50 County and town 2 TDZL Text 255 Land location 3 GDBS Text 200 Land supply mark 4 GDDKBS Text 200 Land lot identification 5 XMMC Text 200 Project Name 6 DKJ Double Plot Area 7 G JZ Text 200 Supply area 8 PFW Text 50 Approval number 9 HYFL Text 50 Industry Classification 10 TDJB Text 50 Land level 11 TDYT Text 50 Land Use 12 GYFS Text 50 Supply method 13 GEOM geometry Spatial fields

[0075] {"SSXZ":"Economic Development Zone","TDZL":"Economic Development Zone (Haichang Subdistrict) north side of Changshan River, west side of Caohejing Road","GDBS":"112c95a8-8ecd-4c39-bafe-56d616fed42e",

[0076] "GDDKBS":"06cf6283-f4fa-48b8-a3ec-dbdf822f5890","XMMC":"Haining Xinggu Electronic Technology Co., Ltd.","DKMJ":4.29,"GYMJ":"4.29","PFWH":"Haining Natural Word

[2020] No. 153","HYFL":"C35","TDJB":"dj10","TDYT":"Other industrial land",

[0077] "GYFS":"Listing for sale","GEOM":"POLYGON((120.65736195900001330.568884349000029,120.657939086000056 30.568164057000047,

[0078] 120.658224059000077 30.567634162000047))"}

[0079] Table 6: Real estate parcel entity

[0080] Serial number Column Name Data Types length illustrate 1 BSM Double Identification code 2 YSDM Text 10 Feature Code 3 BDCD Text 28 Property Unit Number 4 ZDTYB Text 19 Parcel code 5 TDZL Text 200 Land location 6 SCMJ Double Measured area 7 TDYT Text 30 Land Use 8 QLL Text 32 Type of rights 9 QUR Text 32 Nature of rights 10 QLSDFS Text 2 Rights setting method 11 JZQ Double Building volume ratio 12 GEOM geometry Spatial fields

[0081] {"BSM":23247509,"YSDM":"2006010100","BDCDYH":"330481002032GB00319W00000000","ZDTYBM":"330481002032GB00319","TDZL":"Building 25, Kangqiaoyuan, Baihe New Town, Haizhou Street","SCMJ":1085.8,"TDYT":"07","QLLX":"3","QLXZ":"102","QLSDFS":"2","JZRJL":1,"GEO M":"POLYGON

[0082] ((120.67175493000002 30.499346139000068,120.67172080600005330.499247056000058,120.671653384000024 30.49903103500003))"}

[0083] Table 7: Real estate entities

[0084]

[0085]

[0086] {"STBSM":"330402008028GB00014J01120009","KJSFBM":"MA1001NE105H203304412","ZDTYBM":"330402008028GB00014","BSM":"1010630535","XMMC":"Jinshi Packaging (Jiaxing) Co., Ltd.","SCJZMJ":4360.84,"ZCS":1,"GHYT":"21","FWJG":"3",

[0087] "TSTYBM":"ZID20218651","FWBH":"330402008028GB00014F0006",

[0088] "GEOM":"POLYGON((120.67175493000002 30.499346139000068,120.67172080600005330.499247056000058,120.671653384000024 30.49903103500003))"}

[0089] S5: The business unit conducts business according to the subscribed message type and the received natural resource entity change information.

[0090] A second aspect of the present invention provides a system for processing natural resource entity change information and message subscription, comprising:

[0091] A monitoring and pushing unit, used to monitor the natural resource changes of the natural resource entity library in real time by using the entity change processing and message subscription device, and push the natural resource entity change information to the business module according to the subscription information of the business unit;

[0092] The business unit is used to synchronize and aggregate natural resource entities and business entities into the natural resource entity library and to conduct business according to the subscribed message types and received natural resource entity change information;

[0093] The data aggregation unit is used for the natural resource entity library to synchronize and aggregate the natural resource entities and business entities obtained from the business units, determine whether the natural resource entities have changed, and push the change information to the entity change processing and message subscription device.

[0094] A third aspect of the present invention provides a device, comprising:

[0095] processor;

[0096] a memory for storing processor-executable instructions;

[0097] The processor is configured to call the instructions stored in the memory to execute the above method.

[0098] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which computer program instructions are stored, and the computer program instructions implement the above method when executed by a processor.

[0099] In the several embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the modules or units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components can be combined or integrated into another device, or some features can be ignored or not executed.

[0100] The units may or may not be physically separated, and the components displayed as units may be one physical unit or multiple physical units, that is, they may be located in one place or distributed in multiple different places. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0101] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0102] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a readable storage medium. Based on this understanding, the technical solution of the embodiment of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions to enable a device (which can be a single-chip microcomputer, chip, etc.) or a processor (processor) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), disk or optical disk and other media that can store program codes.

[0103] The above is only a specific embodiment of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions within the technical scope disclosed by the present invention should be included in the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims

1. A method for natural resource entity change information processing and message subscription, characterized in that: include: Using entity change processing and message subscription devices to monitor the changes of natural resources in the natural resource entity library in real time; The natural resource entity library synchronizes and aggregates the natural resource entities and business entities obtained from the business units; Determine whether the natural resource entity has changed, and push the change information to the entity change processing and message subscription device; The business unit subscribes to the natural resource entity change information from the entity change processing and message subscription device, and the entity change processing and message subscription device pushes the natural resource entity change information to the business module according to the subscription information of the business unit; The business unit performs business according to the subscribed message type and the received natural resource entity change information.

2. A method for processing natural resource entity change information and subscribing to messages according to claim 1, characterized in that: The natural resource entity library is a spatial database, which uses a postgresql database combined with a postgis extension to manage natural resource entities and business entities.

3. A method for processing natural resource entity change information and subscribing to messages according to claim 2, characterized in that: The sub-modules of the business unit respectively establish a natural resource entity library, extract the required natural resource entity and business entity types and fields from the sub-modules through kettle, and convert the data extracted from the sub-modules according to the rules to obtain the converted data, and synchronize all the converted data to the local database in real time and summarize the natural resource entities.

4. A method for processing natural resource entity change information and subscribing to messages according to claim 3, characterized in that: In the process of real-time monitoring of natural resource changes in the natural resource entity library, the change information is filtered through the entity library change information filter, and only the natural resource changes whose information subject is the natural resource entity are retained.

5. A method for natural resource entity change information processing and message subscription according to claim 4, characterized in that: The operation of pushing the natural resource entity change information to the entity change processing and message subscription device includes: The natural resource entities in the natural resource entity library are screened and it is determined whether it is defined change information. If so, the change information is assembled according to the entity type, and the change information is synchronized with the entity change processing and message subscription device through the message queue for subscription by the business unit.

6. A method for natural resource entity change information processing and message subscription according to claim 5, characterized in that: The data format of the change message pushed by the entity change processing and message subscription device to the business unit includes entity type, entity identification code, change status, and change entity content.

7. A method for processing natural resource entity change information and subscribing to messages according to claim 6, characterized in that: The change status includes adding, modifying, and deleting. When the change status is adding or modifying, the change entity content is all the information of the entity. When the change status is modifying, the change entity content is the field information of the entity change.

8. A system using a method for processing natural resource entity change information and message subscription as described in any one of claims 1 to 7, characterized in that: include: A monitoring and pushing unit, used to monitor the natural resource changes of the natural resource entity library in real time by using the entity change processing and message subscription device, and push the natural resource entity change information to the business module according to the subscription information of the business unit; A business unit, used to synchronize and aggregate natural resource entities and business entities into the natural resource entity library and to conduct business according to subscribed message types and received natural resource entity change information; The data aggregation unit is used for the natural resource entity library to synchronize and aggregate the natural resource entities and business entities obtained from the business unit, determine whether the natural resource entity has changed, and push the change information to the entity change processing and message subscription device.

9. A device, characterized in that: include: processor; a memory for storing processor-executable instructions; The processor is configured to call the instructions stored in the memory to execute the method described in any one of claims 1 to 7.

10. A computer-readable storage medium having computer program instructions stored thereon, characterized in that: When the computer program instructions are executed by a processor, the method according to any one of claims 1 to 7 is implemented.

Images