CN112328724B

CN112328724B - Regional population association method and device, computer equipment and readable storage medium

Info

Publication number: CN112328724B
Application number: CN202011256291.2A
Authority: CN
Inventors: 孙怀峰; 张博; 王蕊秀
Original assignee: Smartsteps Data Technology Co ltd
Current assignee: Smartsteps Data Technology Co ltd
Priority date: 2020-11-11
Filing date: 2020-11-11
Publication date: 2021-10-22
Anticipated expiration: 2040-11-11
Also published as: CN112328724A

Abstract

The application provides a regional population association method, a device, computer equipment and a readable storage medium, which relate to the technical field of big data query, the regional population association method is applied to the computer equipment, the computer equipment stores a topological mode in advance, the topological mode is used for representing a polygonal relation based on a directed arc, and the regional population association method comprises the following steps: creating a topological space list to be tested according to the topological mode and the spatial data to be tested; and inputting population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the space data to be tested.

Description

Regional population association method and device, computer equipment and readable storage medium

Technical Field

The application relates to the technical field of big data query, in particular to a regional population association method, a regional population association device, computer equipment and a readable storage medium.

Background

With the continuous promotion of the urbanization process of China and the development of big data technology, the establishment of a more optimized population structure by using big data can play a good role in the layout and the development of urban space. In the prior art, a large amount of redundant data exists in a manner generally used for associating demographic data with a related area (for example, in a geojson data format, which is referred to as a geographic data structure coding format for short), so that a user occupies a large amount of computing memory when viewing data through, for example, a web end (a web page end), and needs a long transmission time to view the data.

In view of the above, how to provide a regional population association scheme with smaller data volume is needed to be solved by those skilled in the art.

Disclosure of Invention

The application provides a regional population association method, a regional population association device, a computer device and a readable storage medium.

The embodiment of the application can be realized as follows:

in a first aspect, the present application provides a regional population association method, which is applied to a computer device, where a topology pattern is stored in advance in the computer device, and the topology pattern is used to characterize a polygonal relation based on a directed arc, and the method includes:

creating a topological space list to be tested according to the topological mode and the spatial data to be tested;

and inputting the population data into the topological space list to be tested to obtain a target space population list so as to correlate the population data with the spatial data to be tested.

In an optional embodiment, the computer device further stores an original topological space list in advance, wherein the original topological space list comprises a spatial region data column, and the spatial region data column is used for storing topographic geometric type data;

the method comprises the following steps of establishing a topological space list to be tested according to a topological mode and spatial data to be tested, wherein the steps comprise:

inputting the spatial data to be detected into a spatial area data column;

processing the spatial region data column after the spatial data to be detected is input by using a topological mode to generate a topological spatial region data column, wherein the topological spatial region data column is used for storing topological geometric type data corresponding to topographic geometric type data;

and adding the data column of the topological space region into the original topological space list to obtain a to-be-detected topological space list.

In an optional embodiment, the step of generating a topological spatial region data column by processing the spatial region data column after the input of the spatial data to be detected by using the topological mode includes:

processing the spatial region data column by using a topological mode to generate a spatial region data column to be topological;

processing the spatial data to be detected by using a topological mode to generate topological spatial region data;

and inputting the data of the topological space region into the data column of the topological space region to be determined to obtain the data column of the topological space region.

In an optional embodiment, the topology space list to be tested includes a space area reference number column to be tested, the space area reference number column to be tested includes a space area reference number to be tested, and the population data includes a population area reference number and a population number;

inputting population data into a topological space list to be tested to obtain a target spatial population list, wherein the step comprises the following steps of:

generating a population data column under the condition that the population area label is consistent with the label of the space area to be detected;

adding the population data column into a to-be-tested topological space list;

and inputting the population number into a population data column of the topological space list to be tested to obtain a target space population list.

In a second aspect, the present application provides a regional population association apparatus, which is applied to a computer device, where a topology pattern is stored in advance in the computer device, and the topology pattern is used to characterize a polygonal relation based on a directional arc, and the apparatus includes:

the creating module is used for creating a topological space list to be tested according to the topological mode and the spatial data to be tested;

and the association module is used for inputting the population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the spatial data to be tested.

the creating module comprises:

the input module is used for inputting the spatial data to be detected into a spatial region data column;

the generating module is used for processing the spatial region data column after the spatial data to be detected is input by using a topological mode to generate a topological spatial region data column, and the topological spatial region data column is used for storing topological geometric type data corresponding to the topographic geometric type data; and adding the data column of the topological space region into the original topological space list to obtain a to-be-detected topological space list.

In an alternative embodiment, the generating module is specifically configured to:

processing the spatial region data column by using a topological mode to generate a spatial region data column to be topological; processing the spatial data to be detected by using a topological mode to generate topological spatial region data; and inputting the data of the topological space region into the data column of the topological space region to be determined to obtain the data column of the topological space region.

the association module is specifically configured to:

generating a population data column under the condition that the population area label is consistent with the label of the space area to be detected; adding the population data column into a to-be-tested topological space list; and inputting the population number into a population data column of the topological space list to be tested to obtain a target space population list.

In a third aspect, the present application provides a computer device comprising a processor and a non-volatile memory storing computer instructions, wherein when the computer instructions are executed by the processor, the computer device performs the method of associating regional populations according to any of the preceding embodiments.

In a fourth aspect, the present application provides a readable storage medium comprising a computer program which, when executed, controls a computer device on which the readable storage medium resides to perform the regional population association method of any one of the preceding embodiments.

The beneficial effects of the embodiment of the application include, for example: by adopting the regional population association method, the regional population association device, the computer equipment and the readable storage medium, a topological space list to be tested is created according to the topological mode and the spatial data to be tested; and then, inputting the population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the space data to be tested.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.

FIG. 1 is a schematic flow chart illustrating a step of a method for regional demographic correlation according to an embodiment of the present disclosure;

FIG. 2 is a flow chart illustrating another step of a method for regional demographic associations according to an embodiment of the present disclosure;

FIG. 3 is a block diagram schematically illustrating a structure of a regional population association apparatus according to an embodiment of the present disclosure;

fig. 4 is a block diagram schematically illustrating a structure of a computer device according to an embodiment of the present disclosure.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations.

Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures.

Furthermore, the appearances of the terms "first," "second," and the like, if any, are used solely to distinguish one from another and are not to be construed as indicating or implying relative importance.

It should be noted that the features of the embodiments of the present application may be combined with each other without conflict.

At present, big data is adopted as common statistical population, in order to realize the big data association between each region and population, the geojson data format is generally adopted in the prior art, and the data redundancy condition is easy to occur by adopting the method.

In order to solve the aforementioned problems, please refer to fig. 1, and fig. 1 is a schematic flowchart illustrating a step flow of a regional population association method according to an embodiment of the present application, where the regional population association method is applied to a computer device, and a topological pattern is stored in the computer device in advance, and is used for characterizing a polygonal relation based on a directed arc. The area population association method is described in detail below.

Step 201, a topology space list to be tested is created according to the topology mode and the space data to be tested.

Step 202, inputting the population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the spatial data to be tested.

In the embodiment of the present invention, the data structure of the adopted topology model may be represented as:

it should be understood that, since the arcs in the data structure describe the spatial relationship of the directional arcs, the arcs are represented by a series of starting points and directional offset coordinates relative to the starting points, the topological relationship can be expressed based on the storage mode of the arcs, and meanwhile, because the arcs are recorded once and the geographic coordinates use integers instead of floating points, redundant data can be eliminated on the basis of the adoption of the topological mode, and the size of the related file is reduced by 80% in the actual operation process.

On this basis, please refer to fig. 2 in combination, the computer device further stores an original topology space list in advance, the original topology space list includes a space region data column, and the space region data column is used for storing topographic geometry type data.

In substep 201-1, the spatial data to be measured is input into the spatial region data column.

And a substep 201-2, processing the spatial region data column after the spatial data to be detected is input by using a topological mode, and generating a topological spatial region data column.

The topological space area data column is used for storing topological geometric type data corresponding to the topographic geometric type data.

And a substep 201-3, adding the topological space region data column into the original topological space list to obtain a to-be-detected topological space list.

In this embodiment of the present application, there may be a preset original topology space list, where the list has a space area data column, and corresponding data may be stored in the column in a binary form, and a topology mode may be used to process the space area data column after inputting the space data to be detected, so as to generate a topology space area data column.

On the basis of the foregoing, in order to express the scheme of the present application more clearly, the foregoing step 201-2 may be implemented by the following detailed steps.

(1) And processing the spatial region data column by using the topological mode to generate a spatial region data column to be topological determined.

(2) And processing the spatial data to be detected by using the topological mode to generate topological spatial region data.

(3) And inputting the data of the topological space region into the data column of the topological space region to be determined to obtain the data column of the topological space region.

In the embodiment of the present application, the spatial data to be detected is processed by using the topological model, and the following specific method may be adopted to generate the topological spatial region data:

SELECT topology.ST_CreateTopoGeo('ri_topo',

ST_GeomFromText('MULTILINESTRING((384744 236928,384750 236923,384769 236911,384799 236895,384811 236890,384833 236884,

384844 236882,384866 236881,384879 236883,384954 236898,385087 236932,385117 236938,

385167 236938,385203 236941,385224 236946,385233 236950,385241 236956,385254 236971,

385260 236979,385268 236999,385273 237018,385273 237037,385271 237047,385267 237057,

385225 237125,385210 237144,385192 237161,385167 237192,385162 237202,385159 237214,

385159 237227,385162 237241,385166 237256,385196 237324,385209 237345,385234 237375,

385237 237383,385238 237399,385236 237407,385227 237419,385213 237430,385193 237439,

385174 237451,385170 237455,385169 237460,385171 237475,385181 237503,385190 237521,

385200 237533,385206 237538,385213 237541,385221 237542,385235 237540,385242 237541,

385249 237544,385260 237555,385270 237570,385289 237584,385292 237589,385291 237596,385284 237630))',3438)

)；

st_createtopogeo

----------------------------

Topology ri_topo populated

--create tables and topo geometries--

CREATE TABLE ri.roads(gid serial PRIMARY KEY,road_name text)；

SELECT topology.AddTopoGeometryColumn('ri_topo','ri','roads','topo','LINE')；

through the steps, the acquired space data to be measured can be converted into topological space region data.

On the basis of the foregoing, the to-be-tested topological space list includes a to-be-tested space area label column, the to-be-tested space area label column includes a to-be-tested space area label, and the population data includes a population area label and a population number.

In sub-step 202-1, a population data column is generated when the population area reference number and the spatial area reference number to be measured are identical.

Substep 202-2, add the population data column to the list of topology spaces to be tested.

And a substep 202-3, inputting the population quantity into a population data column of the topological space list to be tested to obtain a target space population list.

It should be understood that in the embodiment of the present application, there may be a plurality of areas involved, and in order to distinguish between the areas to ensure the accuracy of the population data matched with the respective areas, the spatial area number to be measured and the population area number may be configured to achieve the above purpose. Specifically, prior to the population data being added, the following topologically structured data has been obtained:

based on this, the population data can be input according to the scheme, and the specific process can be as follows:

through the steps, the combination of the population data and the spatial data to be detected based on a topological data structure (TopoJson) can be realized, redundant data do not exist, and a more optimized population structure is realized for population statistics in the region.

In order to more clearly describe the above solution, the following discusses the overall solution of the embodiments of the present application, and reference may be made to table one.

Watch 1

PAC	geom
		110105	F0CB175D40062D24…

The PAC is a space area number column to be measured, the corresponding 110105 is a space area number to be measured, the geom is a space area data column, and the corresponding "F0 CB175D40062D24 …" is space data to be measured stored in a binary form.

On this basis, table two may be further referred to.

Watch two

PAC	geom	geom_topo
			110105	F0CB175D40062D24…	0217B87D768F6433…

Wherein, the geom _ topo is a topological spatial region data column formed by the spatial region data column geom based on a topological mode, and the "0217B 87D768F6433 …" is the topological spatial region data which is obtained by the spatial data to be measured "F0 CB175D40062D24 …" based on a topological mode and is also obtained in a binary manner as described above.

On this basis, please refer to table three.

Watch III

PAC	geom	geom_topo	value
				110105	F0CB175D40062D24…	0217B87D768F6433…	2389

In the embodiment of the present application, the determined demographic data may be a specific population, for example, in an area with a spatial area reference number to be measured and a population area reference number of "110105", the number of people in occupation of a student is "2389", a corresponding relationship between a specific population and the area under a topological data structure can be established through the above process, the specific population and the area can be used as the target spatial population list in table three, the obtained target spatial population list can be converted into an effect graph for display, and the whole process does not have a data redundancy condition because of the above topological structure.

An embodiment of the present application further provides a regional population association apparatus 110, which is applied to a computer device, where a topology mode is stored in advance in the computer device, and the topology mode is used to characterize a polygonal relation based on a directed arc, as shown in fig. 3, the regional population association apparatus 110 includes:

a creating module 1101, configured to create a to-be-tested topological space list according to the topological mode and the to-be-tested spatial data.

The associating module 1102 is configured to input the population data into the to-be-tested topological space list to obtain a target spatial population list, so as to associate the population data with the to-be-tested spatial data.

Further, the computer device also stores an original topological space list in advance, wherein the original topological space list comprises a spatial region data column, and the spatial region data column is used for storing topographic geometric type data.

The creation module 1101 includes:

and the input module is used for inputting the spatial data to be detected into the spatial region data column.

Further, the generation module is specifically configured to:

Further, the topological space list to be tested comprises a space area reference number column to be tested, the space area reference number column to be tested comprises a space area reference number to be tested, and the population data comprises a population area reference number and population number. The association module 1102 is specifically configured to:

The embodiment of the present application provides a computer device 100, where the computer device 100 includes a processor and a non-volatile memory storing computer instructions, and when the computer instructions are executed by the processor, the computer device 100 executes the aforementioned regional population association method. As shown in fig. 4, fig. 4 is a block diagram of a computer device 100 according to an embodiment of the present disclosure. The computer device 100 includes a regional population association apparatus 110, a memory 111, a processor 112, and a communication unit 113.

To facilitate the transfer or interaction of data, the elements of the memory 111, the processor 112 and the communication unit 113 are electrically connected to each other, directly or indirectly. For example, the components may be electrically connected to each other via one or more communication buses or signal lines. The regional population association means 110 comprises at least one software functional module which can be stored in the memory 111 in the form of software or firmware (firmware) or solidified in an Operating System (OS) of the computer device 100. The processor 112 is used for executing executable modules stored in the memory 111, such as software functional modules and computer programs included in the regional population association device 110.

The embodiment of the present application provides a readable storage medium, which includes a computer program, and when the computer program runs, the computer apparatus 100 in which the readable storage medium is located is controlled to execute the foregoing regional population association method.

In summary, the embodiment of the present application provides a method, an apparatus, a computer device and a readable storage medium for associating regional population, which creates a to-be-tested topological space list according to a topological pattern and to-be-tested space data; and then, inputting the population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the space data to be tested.

The above description is only for the specific embodiments of the present application, but the scope of the present application is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present application should be covered within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims

1. A regional population association method is applied to a computer device, wherein the computer device stores a topological pattern in advance, and the topological pattern is used for characterizing a polygonal relation based on directional arcs, and the method comprises the following steps:

inputting population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the space data to be tested;

the computer equipment also stores an original topological space list in advance, wherein the original topological space list comprises a space area data column, and the space area data column is used for storing topographic geometric type data;

the step of creating a topology space list to be tested according to the topology mode and the space data to be tested comprises the following steps:

inputting the spatial data to be detected into the spatial area data column;

processing the spatial area data column after the spatial data to be detected is input by using the topological mode to generate a topological spatial area data column, wherein the topological spatial area data column is used for storing topological geometric type data corresponding to the topographic geometric type data;

adding the topological space area data column into the original topological space list to obtain the topological space list to be tested;

the step of processing the spatial region data column after the spatial data to be detected is input by using the topological mode to generate a topological spatial region data column includes:

processing the spatial region data array by using the topological mode to generate a spatial region data array to be topological;

processing the spatial data to be detected by using the topological mode to generate topological spatial region data;

and inputting the topological space region data into the data column of the to-be-determined topological space region to obtain the data column of the topological space region.

2. The method according to claim 1, wherein the topological space list under test comprises a space area number column under test, the space area number column under test comprises a space area number under test, and the population data comprises a population area number and a population number;

the step of inputting population data into the topology space list to be tested to obtain a target space population list comprises the following steps:

adding the population data column into the topological space list to be tested;

and inputting the population number into the population data column of the topological space list to be tested to obtain the target space population list.

3. An apparatus for associating regional population, applied to a computer device, wherein the computer device stores a topological pattern in advance, and the topological pattern is used for characterizing a polygonal relation based on a directed arc, the apparatus comprising:

the association module is used for inputting population data into the topological space list to be tested to obtain a target space population list so as to associate the population data with the space data to be tested;

the creation module comprises:

the input module is used for inputting the spatial data to be detected into the spatial area data column;

the generating module is used for processing the spatial area data column after the spatial data to be detected is input by using the topological mode to generate a topological spatial area data column, and the topological spatial area data column is used for storing topological geometric type data corresponding to the topographic geometric type data; adding the topological space area data column into the original topological space list to obtain the topological space list to be tested;

the generation module is specifically configured to:

processing the spatial region data array by using the topological mode to generate a spatial region data array to be topological; processing the spatial data to be detected by using the topological mode to generate topological spatial region data; and inputting the topological space region data into the data column of the to-be-determined topological space region to obtain the data column of the topological space region.

4. The apparatus according to claim 1, wherein the topological space list under test comprises a space area number column under test, the space area number column under test comprises a space area number under test, and the population data comprises a population area number and a population number;

the association module is specifically configured to:

generating a population data column under the condition that the population area label is consistent with the label of the space area to be detected; adding the population data column into the topological space list to be tested; and inputting the population number into the population data column of the topological space list to be tested to obtain the target space population list.

5. A computer device comprising a processor and a non-volatile memory having computer instructions stored thereon that, when executed by the processor, cause the computer device to perform the method of regional demographic association of any of claims 1-2.

6. A readable storage medium comprising a computer program that when executed controls a computer device on which the readable storage medium resides to perform the regional demographic association method of any of claims 1-2.