A data analysis method, device and storage medium based on GIS map

By integrating GIS maps, multi-dimensional analysis and one-house tool, combining special indicators and massive point data, dynamically build display areas and intelligently recommend display levels, the shortcomings of traditional tools in data analysis and display are solved, and the macro to micro has been realized. The step by step penetration analysis improves user experience and efficiency.

CN114385627BActive Publication Date: 2024-11-22BEIJING DASHUYUAN TECH DEV CO LTD
View PDF 7 Cites 0 Cited by

Patent Information

Application Number
CN202111529890.1
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-08
Publication Date
2024-11-22
Estimated Expiration
2041-12-08

AI Technical Summary

Technical Problem

Traditional GIS map-based data analysis tools have shortcomings in interactive analysis and data display, especially in multi-dimensional analysis and intuitive display of massive point data. The operations are complex and not intuitive, making it difficult to achieve step by step from macro area to micro level. Penetration analysis.

Method used

Combining GIS maps, multi-dimensional analysis and one-house tool, dynamically build display areas by configuring special indicators and massive point data, using algorithms to intelligently recommend the best display levels, realize step-by-step penetration analysis from macro to micro, and improve user operations Experience.

Benefits of technology

It realizes detailed analysis from macro regional indicator analysis to micromassive massive points, solves the shortcomings of traditional tools in hierarchical penetration and data intuitiveness, and improves user operation experience and work efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114385627B_ABST
    Figure CN114385627B_ABST
Patent Text Reader

Abstract

The present invention discloses a data analysis method, device and storage medium based on GIS map. The method includes: configuring thematic indicators, defining core analysis indicators, assigning indicator codes and display names, constructing the relationship between thematic indicators and multidimensional analysis schemes, constructing data source identifiers corresponding to map themes, and setting data sources corresponding to themes to generate a thematic indicator information configuration table; configuring multidimensional analysis data, generating a multidimensional analysis data indicator table based on the thematic indicator information configuration table, and preparing map thematic area indicator data; establishing massive points for all location-related objects in a data center through a data preparation method based on pre-set massive point categories, and generating a massive point data table; dynamically constructing a display area based on user activation, wherein the bottom layer of the display area is a geographic information system GIS map, with a floating condition area on the left and a floating analysis icon area on the right.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of data analysis, and in particular to a data analysis method, device and storage medium based on a GIS map. Background Art

[0002] Traditional data analysis often relies on data analysis tools, each of which has its own advantages and disadvantages. Geographic Information System (GIS) maps are mature in applications such as navigation, but in the analysis field, GIS maps can intuitively display areas or massive points, but interactive analysis is difficult; single-family display is good, but the spatial sense of data listing is insufficient; multi-dimensional analysis has strong interactive analysis functions, but it is cumbersome for operators.

[0003] As data centers accumulate more and more data resources, traditional data analysis often limits users' analysis paths and exploration imagination, and has the disadvantage of being good-looking but not practical.

[0004] Existing data analysis based on GIS maps focuses more on data analysis results based on geographical location. Even if combined with charts such as heat maps, pie charts, and bar charts, they all focus on geographical location and reflect its intuitive situation. However, analysis tools that focus on analyzing the essence of data and tracing its causes, such as multidimensional analysis and single-household analysis, have relatively high requirements for operators or the displayed data is not intuitive.

[0005] In the regional positioning of GIS maps, the regional location is located step by step based on the defined map levels. However, the provincial regions in my country are different. For example, in Beijing, drilling to the next level can reach the specific located urban area. However, in vast areas such as Xinjiang and Tibet, drilling one level cannot intuitively see the corresponding area of ​​the next level, and it is necessary to drill multiple levels to see the specific urban area. Summary of the invention

[0006] The purpose of the present invention is to provide a data analysis method, device and storage medium based on GIS maps. The method integrates three types of tools: GIS maps, multidimensional analysis and one-household analysis, and can support the analysis of macro-regional indicators and one-household analysis of a large number of points. It integrates the relevant advantages of GIS maps and develops a set of algorithms based on the relevant advantages. The combination of the algorithm can further highlight the advantages of hierarchical regional positioning of data maps, and can better serve operators.

[0007] In view of this, the first aspect of the present invention provides a data analysis method based on a GIS map, characterized in that the method includes: step 110: configuring thematic indicators, defining core analysis indicators, assigning indicator codes and display names, constructing the relationship between the thematic indicators and the multidimensional analysis scheme, constructing the data source identifier corresponding to the map theme data, and setting the theme corresponding data source to generate a thematic indicator information configuration table; step 120: configuring multidimensional analysis data, generating a multidimensional analysis data indicator table based on the thematic indicator information configuration table, and preparing map theme area indicator data; step 130: based on the pre-set massive point categories, through the data preparation method, establishing massive points for all location-related objects in the data center, and generating a massive point data table; step 140: based on the user's startup, dynamically constructing a display area, wherein the bottom layer of the display area is a geographic information system GIS map, a left-side floating condition area, and a right-side floating analysis icon area, the left-side floating condition area is related to the multidimensional analysis data indicator table, and the right-side floating analysis icon area is related to the massive point data table.

[0008] Optionally, in combination with the first aspect, in a possible implementation, the method further includes: Step 150: when a user's first opening instruction is received, the focus area displayed is the area pre-set by the system parameters, and the display level is the optimal display level for locating the pre-set area in combination with the recommended focus algorithm; when the user receives at least one operation of dragging the map, zooming the level, or clicking on the map drawing surface, the optimal display area is recalculated by the recommended focus area algorithm and repositioned to the optimal display level.

[0009] Optionally, in combination with the first aspect, in a possible implementation, in step 110, the data source may be a data table or a view.

[0010] Optionally, in combination with the first aspect, in a possible implementation, in step 120, the multidimensional analysis data indicator table is used for fast multidimensional analysis, and the multidimensional analysis data indicator table is a three-dimensional cube, wherein the dimensions of the three-dimensional cube include: topic, time, and region; in step 140, the user can select topic, time, and region conditions from the left floating condition area, and the user can select conditions from the right floating analysis icon area to dynamically construct a map area display and multidimensional analysis.

[0011] Optionally, in combination with the first aspect, in a possible implementation, the recommended focus area algorithm in step 150 specifically includes: Step 151: Obtaining basic page parameters, wherein the basic page parameters include: the maximum and minimum values ​​of longitude are C_GL and C_TL respectively, the maximum and minimum values ​​of latitude are C_GS and C_TS respectively, the center point of the screen is obtained as C, and the original map level F before the interactive page changes and the current map level R after the interactive page changes are obtained; Step 152: Obtaining a list of district codes for the selected area, the list of district codes for the selected area is related to a preset district level table, and determining whether the district corresponding to the list of district codes for the selected area is a recommended district based on the basic page parameters; Step 153: Calculating the score of the recommended administrative division of the selected area based on the list of district codes for the selected area.

[0012] Optionally, in combination with the first aspect, in a possible implementation, step 152 specifically includes: when the district code list of the to-be-selected area satisfies two conditions at the same time, determining that the district corresponding to the district code list of the to-be-selected area is a recommended district, and adding the recommended district into the to-be-selected area, the two conditions include: Condition 1: If the current map level R ≥ the original map level F, then the district level value range is the current map level plus or minus 1; or, if the current map level R < the original map level F, then the district level value range is the current map level to the current level minus 2; Condition 2: The maximum and minimum values ​​of the preset district level table district longitude are aL and aS respectively, the maximum and minimum values ​​of the preset district level table district longitude latitude are bL and bS respectively, the maximum and minimum values ​​of the preset district level table district longitude and longitude are displayed on the screen, and the maximum and minimum values ​​of the latitude are displayed on the screen.

[0013] Optionally, in combination with the first aspect, in a possible implementation method, step 153 specifically includes: taking the difference between the maximum longitude C_GL and the minimum longitude C_TL as the length, and taking the maximum latitude C_GS and the minimum latitude C_TS as the width, to obtain the area of ​​the screen display area; and calculating the score of the recommended administrative division of the selected area based on the area of ​​the screen display area.

[0014] Optionally, in combination with the first aspect, in a possible implementation,

[0015] The calculation of the score of the recommended administrative division of the selected area based on the area of ​​the screen display area specifically includes: judging whether the longitude of the coordinates of the center point of the screen is within the range of the maximum longitude and the minimum longitude of the region, and the latitude of the coordinates of the center point of the screen is within the range of the maximum latitude and the minimum latitude of the region, if satisfied, recording the value a as the set score; the area of ​​the selected division in the display area ÷ the area of ​​the display area × 10, the result is b, judging whether the value b is greater than the set threshold, if the value b is greater than the set threshold, assigning the result obtained by subtracting the value b from the set gradient score to b; obtaining the distance from the center point of all the selected divisions to the center point of the screen, and calculating the ranking score, sorting them in order from small to large by distance, and assigning the value of the division with the smallest distance to the center point downwards in descending order, and the obtained value is recorded as c; the obtained weighted score is recorded as a+b+c.

[0016] The second aspect of the present invention provides a data analysis device based on a GIS map, characterized in that the device includes: a memory and a processor, the memory stores code, the processor is configured to execute the code, and when the code is executed, the terminal executes the data analysis method based on the GIS map as described in any possible implementation method of the first aspect to the first aspect.

[0017] The third aspect of the present application provides a non-volatile computer-readable storage medium, characterized in that the non-volatile computer-readable storage medium stores computer-executable instructions, which, when executed by one or more processors, enable the one or more processors to execute any possible GIS map-based data analysis method from the first aspect to the first aspect of the present application.

[0018] The present invention discloses a data analysis method, device and storage medium based on GIS map. The method comprises: step 110: configuring thematic indicators, defining core analysis indicators, assigning indicator codes and display names, constructing the relationship between the thematic indicators and the multidimensional analysis scheme, constructing the data source identifier corresponding to the map theme, and setting the theme corresponding data source to generate the thematic indicator information configuration table; step 120: configuring multidimensional analysis data, generating a multidimensional analysis data indicator table based on the thematic indicator information configuration table, and preparing map theme area indicator data; step 130: establishing a massive point for all location-related objects in the data center through a data preparation method based on the pre-set massive point categories, and generating a massive point data table; step 140: dynamically constructing a display area based on the user's start-up, wherein the bottom layer of the display area is a geographic information system GIS map, a left floating condition area, and a right floating analysis icon area, wherein the left floating condition area is related to the multidimensional analysis data indicator table, and the right floating analysis icon area is related to the massive point data table.

[0019] Based on GIS maps, an integrated data analysis method is provided. GIS maps, multidimensional analysis and one-household analysis are combined together. From macro-regional indicator analysis to micro-massive point one-household analysis, the interactive operation of multidimensional analysis, the drag and zoom of GIS maps, and the detailed and intuitive features of one-household analysis are adopted. Users can complete the exploration and analysis of the data center by clicking and dragging. The combination of maps and multidimensional analysis expands users' spatial thinking. The combination of maps and one-household analysis changes the method of viewing one-household from a relatively abstract specific object to a method guided and explored by the massive points of the map, tracing back to the specific one-household information. This method is mainly to meet the "one-stop" penetrating monitoring of the business. Starting from the macro-thematic indicators, it realizes the step-by-step penetration of provinces, cities and counties to detailed massive points.

[0020] The size and boundaries of traditional maps vary greatly. In view of the weakness of traditional GIS map regional analysis that is difficult to penetrate layer by layer, an algorithm is used to intelligently obtain the focus area in the location of the map area by integrating scoring items, weight proportions, ranking scores, etc. This solves the weakness that traditional maps can only penetrate and find regions layer by layer according to defined levels during user interaction with maps. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0022] Figure 1 A flow chart of a data analysis method based on GIS map provided by the present invention;

[0023] Figure 2 A schematic diagram of a dynamically constructed regional layout provided by the present invention;

[0024] Figure 3 A flow chart of a recommended focus area algorithm provided by the present invention;

[0025] Figure 4 A schematic diagram of calculating the area display range provided by the present invention;

[0026] Figure 5 A display effect diagram of a large number of points provided by the present invention;

[0027] Figure 6 A schematic diagram showing an administrative division provided by the present invention;

[0028] Figure 7 A schematic diagram showing an administrative division provided by the present invention;

[0029] Figure 8 A schematic structural diagram of a GIS map-based data analysis device provided by the present invention. DETAILED DESCRIPTION

[0030] The technical solutions in the embodiments of the present application will be described below in conjunction with the accompanying drawings in the embodiments of the present application. In the present application, "at least one" refers to one or more, and "multiple" refers to two or more. "And / or" describes the association relationship of the associated objects, indicating that there may be three relationships, for example, A and / or B, which can represent: A exists alone, A and B exist at the same time, and B exists alone, where A and B can be singular or plural. The character " / " generally indicates that the associated objects before and after are in an "or" relationship. "At least one of the following" or its similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can represent: a, b, c, a and b, a and c, b and c or a and b and c, where a, b and c can be single or multiple. It is worth noting that "at least one" can also be interpreted as "one or more items".

[0031] It should be noted that, in this application, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in this application should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0032] The first, second, etc. descriptions appearing in the embodiments of the present application are only used for illustration and distinction of the description objects. There is no order, nor do they indicate any special limitation on the number of devices in the embodiments of the present application, and cannot constitute any limitation on the embodiments of the present application.

[0033] First, let's briefly introduce the technical terms involved in this application:

[0034] GIS: Geographic Information System (GIS) is a very important spatial information system. It is a technical system that collects, stores, manages, calculates, analyzes, displays and describes the geographical distribution data of the whole or part of the earth's surface (including the atmosphere) with the support of computer hardware and software systems.

[0035] Massive points: also known as coordinate points, a geographical location mark on the map, used to locate the specific spatial location of a certain enterprise or unit.

[0036] Massive point type: It is a classification method tailored for mass points in order to distinguish mass points with different attributes and properties. For example: poverty alleviation mass points.

[0037] Thematic indicators: also known as thematic statistical indicators, thematic statistical indicators are statistical indicators formulated for a certain economic or social issue, used to describe the overall basic situation and the comprehensive quantity of the distribution characteristics of each variable. For example, the basic situation of fiscal investment in poverty alleviation funds can use the amount of regional poverty alleviation funds as a thematic indicator.

[0038] Multidimensional analysis: It is one of the advanced statistical analysis methods. It puts a product or a market phenomenon on a spatial coordinate of more than two dimensions for analysis. The present invention includes three dimensions: thematic indicator dimension, zoning dimension and time dimension.

[0039] One-household type: It is a data presentation report component that can combine and display related elements of enterprises, units, departments and other similar organizations, and can also classify and count data according to different attributes.

[0040] The purpose of the present invention is to establish a data analysis method based on GIS map to provide an integrated experience. First, a map, multi-dimensional analysis, and one-household shared thematic indicator analysis system are defined. By combining the indicator system, GIS map thematic indicators are configured to prepare massive point data; secondly, when the user is roaming the map, the algorithm constructs the current regional thematic analysis based on parameters such as the user's area and the coordinates of the screen center point; finally, when the interactive parameter combination meets the preset conditions, it switches to dynamically constructing massive point analysis.

[0041] The content of the present invention is as follows: First, GIS map, multidimensional analysis, and household analysis are combined through a series of configuration methods to provide users with an analysis method based on GIS map. Second, in the analysis method, an algorithm is used to automatically recommend the best display level for the focus area, thereby improving the user operation experience.

[0042] For details, see Figure 1 The present invention provides a data analysis method based on a GIS map, the method comprising:

[0043] S110, configure thematic indicators, define core analysis indicators, assign indicator codes and display names, build the relationship between the thematic indicators and the multidimensional analysis scheme, build the data source identifier corresponding to the map theme data, and set the theme corresponding data source to generate a thematic indicator information configuration table.

[0044] Configure thematic indicators. Define core analysis indicators, assign indicator codes and display names, build the relationship between thematic indicators and multidimensional analysis solutions, build the data source identifier corresponding to the map theme, and set the data source corresponding to the theme. The data source can be a data table or view, which is stored in Table 1 Thematic Indicator Information Configuration Table.

[0045] Field Name Field Description ZBGUID Indicator Code ZBNAME Indicator name IS_BGT Whether to use multidimensional analysis indicators TABLE_NAME The name of the data table or view corresponding to the regional data SHOW_TEXT Data query display fields

[0046] Table 1 Thematic indicator information configuration table

[0047] S120, configuring multidimensional analysis data, generating a multidimensional analysis data indicator table based on the thematic indicator information configuration table, and preparing map thematic area indicator data.

[0048] Preparing the map thematic area indicator data can be divided into the following two steps:

[0049] Step 2.1 configures multidimensional analysis data, which generates a multidimensional analysis data indicator table based on the thematic indicator information configuration table for fast multidimensional analysis. The indicator data table is a three-dimensional cube with the dimensions of: topic, time, and region, and measurement: indicator value. Prepare corresponding data based on the association between multidimensional analysis and indicators, and store them in Table 2's dimensional analysis data indicator table. The ZBGUID field in the table is an associated field with the ZBGUID field in Table 1.

[0050] Field Name Field Description DQ Regional division code RQ Date and Time ZBGUID Indicator Code ZBVALUE Index value

[0051] Table 2 Multidimensional analysis data indicators

[0052] Step 2.2 Prepare the data table or view corresponding to the thematic data source. The structure of the table or view corresponding to the data must include the requirements of Table 3. After preparation, add the corresponding data table name and data query display fields to Table 1.

[0053]

[0054] Table 3 The data source structure template corresponding to the topic

[0055] By agreeing on the structure of the data source, it is convenient to quickly add or adjust topics. After completing the configuration, the topic identifiers in Table 3 can be maintained in the corresponding fields in Table 1.

[0056] S130. Based on the preset massive point categories, all location-related objects in the data center are established into massive points through data preparation methods to generate a massive point data table.

[0057] Prepare the indicator mass point data. Based on the pre-set mass point categories and the data preparation method, all location-related objects (such as poverty alleviation points, budget units, etc.) in the data center are established as mass points, and a mass point data table is generated. The structure of the mass point data table is shown in Table 4.

[0058] Field Name Field Description AD_CODE District Code ZBGUID Indicator Code MC Massive point names LAT latitude LNG longitude MSXX Descriptive information, massive point display information URL One-household analysis link

[0059] Table 4 Structure of the massive point data table

[0060] S140. Based on the user's initiation, a display area is dynamically constructed, wherein the bottom layer of the display area is a geographic information system GIS map, a floating condition area on the left, and a floating analysis icon area on the right. The floating condition area on the left is related to the multidimensional analysis data indicator table, and the floating analysis icon area on the right is related to the massive point data table.

[0061] Dynamically build the display area. After the above three steps are configured, the area layout will be displayed after the user opens the map. Figure 2 The bottom layer is a GIS map. On the left is a floating condition area where you can select thematic indicators, select areas, select time and other conditions; on the right is a floating analysis chart area. Dynamically build map area display and multi-dimensional analysis based on the selection conditions. Among them, area selection can be interactively operated on the map to obtain recommended focus areas based on the algorithm. For details, please refer to Figure 2 Dynamically construct the regional layout for understanding, which will not be repeated here.

[0062] Recommended focus areas. After the user drags the map, zooms in and out, clicks through, etc., a dedicated algorithm will automatically identify the user's focus area at the regional level.

[0063] The algorithm is divided into the following steps:

[0064] 1. Get the basic parameters of the page. According to the coordinates of the four extreme values ​​of the current screen, get the maximum and minimum values ​​of longitude C_GL, C_TL, the maximum and minimum values ​​of latitude C_GS, C_TS, get the center point of the screen as C, and get the original map level F before the interactive page changes and the current map level R after the interactive page changes.

[0065] 2. Obtain the district code list of the selected area. This step relies on the district level table pre-made by the system, see Table 5.

[0066]

[0067]

[0068] Table 5 Prefabricated zoning level table

[0069] When the corresponding division in the table meets both of the following conditions:

[0070] Condition 1:

[0071] If the current map level R ≥ the original map level F, the division level value range is the current level plus or minus 1. Or,

[0072] If the current map level R is less than the original map level F, the zoning level value range is from the current map level to the current level minus 2.

[0073] The formula is as follows:

[0074] IF(R≥F){(MAP_LVL IN(R-1~R+1)}ELSE IF(R <F){(MAP_LVL IN(R-2~R)}。

[0075] It should be noted that condition 1 is a result obtained based on the user's operation behavior. When R is greater than F, it is a reduction operation, and when R is less than F, it is an expansion operation. The two value ranges are value ranges defined according to the user's specific operation behavior. The selection range can be optimized based on the user's behavior.

[0076] Condition 2:

[0077] The system pre-made zoning level table zoning longitude maximum and minimum values ​​aL, aS, latitude maximum and minimum values ​​bL, bS. The maximum longitude value or the minimum longitude value is on the display screen, and the maximum and minimum latitude values ​​are on the display screen. The formula is as follows:

[0078] (C_GL>aL>C_GS||C_GL>aS>C_GS)&&(C_TL>bL>C_TS||C_TL>bS>C_TS).

[0079] Then the district is the recommended district and is added to the candidate district.

[0080] 3. Algorithm calculation area. Calculate the score of the recommended administrative division of the candidate area.

[0081] See also Figure 3 , the specific calculation process is as follows:

[0082] First, obtain the area of ​​the screen display area, and use the difference between the maximum and minimum longitudes of the extreme coordinates of the display area as the length and the difference between the maximum and minimum latitudes as the width to obtain the display area area C_MJ. The formula is as follows: C_MJ = (C_GL-C_GS)*(C_TL-C_TS).

[0083] Score calculation indicators:

[0084] 3.1) Scoring method: whether the center point of the screen is within the selected area to be calculated. That is, the selected area needs to meet the following conditions: the longitude of the coordinates of the center point of the screen is within the maximum and minimum longitudes of the region, and the latitude of the coordinates of the center point of the screen is within the maximum and minimum latitudes of the region. If so, the value of a is recorded as the set score, otherwise the value of a is recorded as 0 points. Exemplarily, the set score can be 3 points. The set score can be determined according to actual needs, and the value of 3 points is only used as an example of this application, and the example cannot be used as a limitation of this application.

[0085] The formula is: a=IF(bL>C>bS&&aL>C>aS){3}ELSE{0}

[0086] 3.2) Weighting method: The area of ​​the selected area in the display area ÷ the area of ​​the display area × 10. If the result is greater than the set threshold, the result is reduced by a fixed gradient score.

[0087] Exemplarily, the set threshold value may be 7, and the fixed gradient score may be 4. The set threshold value and the fixed gradient value may be set according to actual needs. This application only takes the set threshold value of 7 and the fixed gradient score of 4 as an example, and this example cannot be used as a limitation of this application.

[0088] The area of ​​the selected area in the display area = length × width.

[0089] Among them, the long value methods include:

[0090] 1.1) Calculate the result of [(if the maximum longitude of the region is greater than C_GL, use C_GL, otherwise use bL) minus (if the minimum longitude of the region is less than C_GS, use C_GS, otherwise use bS)];

[0091] 1.2) If the calculation result is a non-negative number, the result is used as the value of the long;

[0092] 1.3) If the result is a negative number, the value of the length is 0.

[0093] The wide value methods include:

[0094] 2.1) Calculate the result of [(if the maximum latitude of the region is greater than C_TL, use C_TL, otherwise use aL) minus (if the minimum latitude of the region is less than C_TS, use C_TS, otherwise use aS)];

[0095] 2.2) If the calculation result is a non-negative number, the result is used as the value of the width;

[0096] 2.3) If the calculated result is a negative number, the width is 0.

[0097] After calculating the area of ​​the selected region in the display area, calculate the value of b:

[0098] 3.1) b = the area of ​​the selected zone within the display area / the area of ​​the display area × 10;

[0099] 3.2) Determine whether the value of b is greater than 7. If the value of b is greater than 7, assign the result of subtracting 4 from the value of b to b.

[0100] The specific calculation formula for the above calculation steps is as follows:

[0101] Long=(IF(bL>C_GL){C_GL}ELSE{bL}-IF(bS <C_GS){C_GS}ELSE{bS})

[0102] Width=(IF(aL>C_TL){C_TL}ELSE{aL}-IF(aS <C_TS){C_TS}ELSE{aS})

[0103] b=IF(length<0){0}ELSE{length}*IF(width<0){0}ELSE{width} / C_MJ*10

[0104] b=IF(b>7){b-4}

[0105] 3.3) Ranking method: Find the distance from the center point of all candidate regions to the center point of the screen and calculate the ranking score. Sort by distance from small to large, and assign the value of the region with the smallest distance to the center point downwards in descending order, and the resulting value is recorded as c.

[0106] For example, if the value of the area with the smallest distance from the center point is (5), the values ​​are assigned in sequence, decreasing by 5 ÷ the number of areas to be selected multiplied by 2, and the result is c. Among them, the value of the area with the smallest distance from the center point is 5 only for example and is not a limitation of this application. It can be other natural numbers. The specific formula is:

[0107] Let the number of regions to be selected be list.length;

[0108] Sort the list internally, according to The values ​​are sorted from small to large, list[0] gets c=5, list[1] gets c=5-(5 / list.length*1), list[2] gets c=5-(5 / list.length*2), and list[n] gets c=5-(5 / list.length*n). Among them, QH_C longitude is the longitude of the center point of the region, QH_C latitude is the latitude of the center point of the region; C longitude is the longitude of the center point of the screen, and C latitude is the latitude of the center point of the screen.

[0109] 3.4) The weight score is equal to a+b+c.

[0110] 4. Data return. The administrative division with the highest score after weight sorting is the recommended administrative division, and the administrative division code of the area is returned to the front desk.

[0111] The calculation process is shown in Figure 3 , screen area and selected area refer to Figure 4 For example, the simplest example is that the algorithm calculation process is: first, for the 3,000 or so provinces, cities and counties in the country, the longitude and latitude coordinates of the center point of each region and the optimal map level are pre-set; secondly, the map level of each region is obtained to meet the level within the map display level range of the screen, and the longitude and latitude of the center point of each region is within the coordinate range of the four vertices of the screen. The above-mentioned algorithm weight calculation rules are used to filter the regional divisions and locate the central division. After the divisions are obtained, the corresponding appropriate display level set in the table is combined and returned.

[0112] S150. When a user opens the application for the first time, the focus area displayed is the area pre-set by the system parameters, and the display level is the optimal display level for locating the pre-set area in combination with the recommended focus algorithm; when the user performs at least one operation of dragging the map, zooming the levels, or clicking on the map drawing surface, the optimal display area is recalculated by the recommended focus area algorithm and relocated to the optimal display level.

[0113] Smart switching. When the device is turned on for the first time, the focus area is the area set by the system parameters, and the algorithm is used to locate the area and the best display level; in the initialization, the device will use the regional thematic display as the entrance, and display the area in step 4. Figure 2 The regional themes and multidimensional analysis data in the figure, the map drawing content is based on the relevant configuration in step 1 as the data basis, and the multidimensional analysis part on the right is based on the relevant configuration in step 2.1 as the display basis. The linkage between the two can be switched between different indicator data through the indicator list on the left map.

[0114] Secondly, when the user is operating, by dragging the map, zooming the level, clicking on the map drawing surface, etc., the device will recalculate and locate the best display area under the level according to the algorithm content of step 4, and relocate to the optimal display level of the best division. For example, when the user operates to a new area, the device will call the algorithm to obtain the current area and the best level, draw the regional information, and then adjust the area to the best display level.

[0115] Again, when the algorithm is called after the user's operation to obtain the last-level division, and the current level is greater than the optimal display level by more than 2 levels, for example, in a specific township, district or county and you want to zoom in, the device will automatically switch the display mode according to the current area, current indicator and the data in step 3, so that the user can see the massive point data in the area and indicator, and when the user selects a specific massive point, the one-household link (URL) of the point is displayed, such as Figure 5 .

[0116] Finally, when the user operates again, and the algorithm is called to obtain that the division is not the last division or is less than the last division display level plus 2, the device will automatically switch to the corresponding thematic display module, and can dynamically switch between the two.

[0117] The present invention provides a data analysis method, device and storage medium based on GIS map. The method includes: step 110: configuring thematic indicators, defining core analysis indicators, assigning indicator codes and display names, constructing the relationship between the thematic indicators and the multidimensional analysis scheme, constructing the data source identifier corresponding to the map theme, and setting the theme corresponding data source to generate the thematic indicator information configuration table; step 120: configuring multidimensional analysis data, generating a multidimensional analysis data indicator table based on the thematic indicator information configuration table, and preparing map theme area indicator data; step 130: establishing a massive point for all location-related objects in the data center through a data preparation method based on the pre-set massive point categories, and generating a massive point data table; step 140: dynamically constructing a display area based on the user's startup, wherein the bottom layer of the display area is a geographic information system GIS map, a left floating condition area, and a right floating analysis icon area, wherein the left floating condition area is related to the multidimensional analysis data indicator table, and the right floating analysis icon area is related to the massive point data table.

[0118] Furthermore, the present application provides a specific embodiment taking poverty alleviation analysis in the financial field as an example. The method may specifically include:

[0119] Step 1: Configure the thematic indicators and map codes, assign unique identifiers, indicator codes and display names, and establish the indicator as a multidimensional analysis scheme indicator, as shown in Table 6.

[0120]

[0121] Table 6

[0122] Step 2: Prepare map thematic area indicator data.

[0123] Step 2.1 configures the multidimensional analysis data, as shown in Table 7.

[0124] Regional division code Date and Time Indicator Code Index value 4201 2020 101 1000 4202 2020 101 2000 4203 2020 101 3000 …… …… …… ……

[0125] Table 7

[0126] Step 2.2 Prepare the data table corresponding to the thematic data source, prepare the corresponding data table Bda_t_map_ztt_fp and meet the data table field requirements as shown in Table 8.

[0127] District Code Date and Time Zoning level Field 1 Field 2 42 2020 2 1000 1000 4202 2020 3 2000 2000 420201 2020 4 3000 3000 …… …… …… …… ……

[0128] Table 8

[0129] Step 3: Prepare the massive point data of the indicator, as shown in Table 9.

[0130] District Code Indicator Code Massive point names longitude latitude Descriptive information, massive point display information 4201 101 Enterprise One 136.00000 27.12300 Company name: 123; Poverty alleviation amount: 456 4201 101 Unit 2 136.12300 27.00000 Unit name: 456; Poverty alleviation amount: 123 …… …… …… …… …… ……

[0131] Table 9

[0132] Step 4: Dynamically build the display area. After completing the configuration steps of steps 1-3, open the operation interface of this device, and the device will use the user's login authority as the initialization area position and start to dynamically build the area display.

[0133] When the user performs roaming operations, the algorithm starts calculating the next step.

[0134] 1. Get the basic parameters of the page. Get the coordinates of the four extreme values: the maximum and minimum latitude values ​​are 45.5 and 42.5, the maximum and minimum longitude values ​​are 132.333 and 129.667, the center of the screen is [44.000, 131.000], the level before the change is 6, and the level after the change is 7

[0135] 2. Get the list of district codes to be selected. Query the pre-made table data content to meet the following Where conditions MAP_LVLIN(6,7,8)AND(45.5>aL>42.5OR 45.5>aS>42.5)AND(132.333>bL>129.667OR 132.333>bS>129.667)

[0136] Assume that the list of all the districts to be selected that meet the conditions contains 3 elements as follows:

[0137]

[0138] 3. Algorithm calculation area. Calculate the score of the recommended administrative division of the candidate area. Take the calculation process of BJ City when the level after the change is 7 as an example:

[0139] Calculate and obtain the screen display area C_MJ = (45.5-42.5)*(132.333-129.667) = 7.998

[0140] Score calculation indicators:

[0141] 3.1) Scoring method: whether the center point of the screen is within the area to be selected.

[0142] a=IF(43.111>44.000>43.100&&130.111>131.000>130.100){3}ELSE{0}=0

[0143] 3.2) Weighting method: The area ratio of the selected area in the display area:

[0144] Long=

(IF(43.111&gt;45.5){45.5}ELSE{43.111})-(IF(41.000&lt;42.5){42.5}ELSE{43.100})

[0145] width = [(IF(130.111>132.333){132.333}ELSE{130.111})-

[0146] (IF(130.100<129.667){129.667}ELSE{130.100})】=0.011

[0147] b=IF(0.611<0){0}ELSE{0.611}*IF(0.011<0){0}ELSE{0.011} / 7.998*10≈0.008

[0148] b=IF(b>7){b-4}=0.008

[0149] 3.3) Ranking method: Obtain the distance from the center point of all candidate regions to the center point of the screen and calculate the ranking score.

[0150] Take the first element in the list and find the distance to the center of the element:

[0151]

[0152] Similarly, calculate the distance between the center points of all three elements and sort the list from small to large according to the value. Figure 6 As an example, the following ranking and weight score list is obtained.

[0153] Ranking area Ranking score 1 BJ City 5 2 TJ City 5-(5 / 3*1)=3.333 3 HB Province 5-(5 / 3*2)=1.666

[0154] 4. Data return. Finally, the total score between 3.1 and 3.3 is counted, and the administrative division with the highest score is taken as the recommended administrative division. The administrative division code and the best display level of the area are returned to the front desk.

[0155] Assume that BJ city and HB province are examples. Figure 6 , Figure 7 .exist Figure 6 In the display case, the map level is 8. Although the center point of BJ City is closer to the center point of the screen, this algorithm combines the center point position, area and distance with multiple weights to calculate the score. Finally, HB Province will be used as the best display area and returned with the default display level of HB Province. If the user triggers the algorithm by clicking on the drill-down button, this device will automatically locate the best display layer of the province, otherwise the display area will be switched.

[0156] The scene area scores are as follows:

[0157] Ranking area Total score 3.1 Step Scoring 3.2 Step Scoring 3.3 Step Scoring 1 HB Province 9.83 3 3.5 3.33 2 BJ City 9.3 3 1.3 5 3 TJ City 2.36 0 0.7 1.66

[0158] exist Figure 7 In the case of display, the map level is 9, then Figure 6 Instead, BJ City will be selected as the best display area and returned with the default display level.

[0159] The scene area scores are as follows:

[0160] Ranking area Total score 3.1 Step Scoring 3.2 Step Scoring 3.3 Step Scoring 1 HB Province 12.33 3 6 3.33 2 BJ City 12.5 3 4.5 5 3 TJ City 5.26 0 3.6 1.66

[0161] Step 5: Intelligent display switching of the device. Based on the above configuration and combined with the device algorithm, the user can locate the current area and the best display area through the system parameter preset area combined with the algorithm during initialization, and view the poverty alleviation thematic summary data content in the current area. The user can also switch the thematic display and the mass point display by himself on the left side of the map, if no manual switching is performed.

[0162] When the user drags the map, zooms in and out, clicks on the map drawing surface, etc., the device will recalculate and locate the best display area under the level according to the algorithm content of step 4, and relocate to the optimal display level of the best division. For example, when the user operates to a new area, the device will call the algorithm to obtain the current area and the best level, draw the area information, and then adjust the area to the best display level.

[0163] When the algorithm is called after the user's operation to obtain the final level of division, and the current level is more than 2 levels greater than the optimal display level, for example, a specific township, district or county and you want to zoom in, the device will automatically switch the display mode according to the current area, current indicators and the data in step 3, allowing the user to see the massive point data in the area and indicators, and when the user selects a specific massive point, the household link (URL) of the point will be displayed.

[0164] The effect of the present invention is to establish an analysis framework that integrates three types of analysis tools: GIS maps, multidimensional analysis, and household reports, to achieve step-by-step penetration analysis from macro to micro. It only requires configuring the data source of thematic indicators without code development, thereby improving work efficiency and satisfying the business requirement of "one-stop" penetration monitoring.

[0165] In terms of regional positioning on the map, an algorithm is used to intelligently obtain the focus area by combining scoring items, weight proportions, ranking scores, etc. This solves the weakness of traditional maps that can only penetrate and find regions step by step according to defined levels during user interaction with the map.

[0166] The data analysis method based on GIS map provided in this application has the following advantages:

[0167] 1. Integration. Multidimensional analysis and chart analysis are integrated on GIS maps, which greatly improves the map analysis method and content, making "one-stop" analysis possible.

[0168] 2. Configurability. New thematic indicators can be realized simply through configuration to meet the needs of business expansion.

[0169] 3. Efficiency: When searching for an area on a map, an algorithm is used to automatically obtain the focus area, thereby improving the user experience.

[0170] Figure 8 It is a structural schematic diagram of a GIS map-based data analysis device provided in an embodiment of the present application. The GIS map-based data analysis device 200 may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 210 (for example, one or more processors) and a memory 220, and one or more storage media 230 (for example, one or more mass storage devices) storing application programs 233 or data 232. Among them, the memory 220 and the storage medium 230 can be short-term storage or permanent storage. The program stored in the storage medium 230 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the GIS map-based data analysis device 200. Furthermore, the processor 210 can be configured to communicate with the storage medium 230 to execute a series of instruction operations in the storage medium 230 on the GIS map-based data analysis device 200.

[0171] The GIS map-based data analysis device 200 may also include one or more power supplies 240, one or more wired or wireless network interfaces 250, one or more input and output interfaces 260, and / or one or more operating systems 231, such as Windows Serve, Mac OS X, Unix, Linux, FreeBSD, etc. Those skilled in the art will appreciate that Figure 8 The GIS map-based data analysis device shown does not constitute a limitation on the data processing equipment, and may include more or fewer components than shown in the figure, or a combination of certain components, or a different arrangement of components.

[0172] The present application also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. Instructions are stored in the computer-readable storage medium. When the instructions are executed on a computer, the computer executes the steps of the GIS map-based data analysis method.

[0173] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0174] 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 computer-readable storage medium. Based on this understanding, the technical solution of the present application 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, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (RON), random access memory (RAM), disk or optical disk and other media that can store program code.

[0175] In the embodiments provided in this application, it should be understood that the disclosed methods can be implemented in other ways without exceeding the spirit and scope of this application. The current embodiment is only an illustrative example and should not be used as a limitation. The specific content given should not limit the purpose of this application. For example, some features can be ignored or not executed.

[0176] The technical means disclosed in the present application are not limited to the technical means disclosed in the above-mentioned implementation methods, but also include technical solutions composed of any combination of the above technical features. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of this application, and these improvements and modifications are also regarded as the protection scope of this application.

[0177] The above is a detailed introduction to a data analysis method, device and storage medium based on GIS maps provided in the embodiments of the present application. Specific examples are used in this article to illustrate the principles and implementation methods of the present application. The description of the above embodiments is only used to help understand the method of the present application and its core idea; at the same time, for those of ordinary skill in the art, according to the idea of ​​the present application, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as a limitation on the present application. Although the present application has been described in detail with reference to the aforementioned embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions recorded in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein; and these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A data analysis method based on GIS map, characterized in that: The method comprises: Step 110: configure thematic indicators, define core analysis indicators, assign indicator codes and display names, build relationships between thematic indicators and multidimensional analysis solutions, build data source identifiers corresponding to map themes, and set data sources corresponding to themes to generate a thematic indicator information configuration table; Step 120: configuring multidimensional analysis data, generating a multidimensional analysis data index table based on the thematic index information configuration table, and preparing map thematic area index data; Step 130: Based on the pre-set massive point categories, all location-related objects in the data center are established into massive points through a data preparation method to generate a massive point data table; Step 140: Based on the user's initiation, dynamically construct a display area, wherein the bottom layer of the display area is a geographic information system GIS map, a floating condition area on the left, and a floating analysis icon area on the right, wherein the floating condition area on the left is related to the multidimensional analysis data indicator table, and the floating analysis icon area on the right is related to the massive point data table; Step 150: When receiving the user's first opening instruction, the focus area displayed is the area preset by the system parameters, and the display level is the optimal display level for locating the preset area in combination with the recommended focus algorithm; when receiving at least one operation of the user dragging the map, zooming the level, or clicking the map drawing surface, the optimal display area is recalculated by the recommended focus area algorithm and relocated to the optimal display level; The algorithm for recommending focal areas in step 150 specifically includes: Step 151: Obtaining basic page parameters, wherein the basic page parameters include: the maximum and minimum values ​​of longitude are C_GL and C_TL respectively, the maximum and minimum values ​​of latitude are C_GS and C_TS respectively, obtaining the center point of the screen as C, and obtaining the original map level F before the interactive page changes and the current map level R after the interactive page changes; Step 152: obtaining a list of district codes for a candidate area, wherein the list of district codes for a candidate area is related to a preset district level table, and determining whether a district corresponding to the list of district codes for a candidate area is a recommended district according to the basic parameters of the page; Step 153: Calculate the score of the administrative division recommended for the candidate area according to the candidate area division code list; The step 152 specifically includes: When the district code list of the to-be-selected area satisfies two conditions at the same time, the district corresponding to the district code list of the to-be-selected area is determined as a recommended district, and the recommended district is added into the to-be-selected area, and the two conditions include: Condition 1: If the current map level R ≥ the original map level F, the division level value range is the current map level plus or minus 1; or, if the current map level R < the original map level F, the division level value range is the current map level to the current level minus 2; Condition 2: the maximum value and minimum value of the preset zone longitude in the zone level table are aL and aS respectively, the maximum value and minimum value of the preset zone longitude and latitude in the zone level table are bL and bS respectively, the maximum value and minimum value of the preset zone longitude in the zone level table are displayed on the screen, and the maximum value and minimum value of the latitude are displayed on the screen; The step 153 specifically includes: The difference between the maximum longitude C_GL and the minimum longitude C_TL is used as the length, and the maximum latitude C_GS and the minimum latitude C_TS are used as the width to obtain the screen display area. Calculating the score of the recommended administrative division of the selected area according to the area of ​​the screen display area; the calculating the score of the recommended administrative division of the selected area according to the area of ​​the screen display area specifically includes: Determine whether the coordinate longitude of the center point of the screen is within the range of the maximum longitude and the minimum longitude of the region, and whether the coordinate latitude of the center point of the screen is within the range of the maximum latitude and the minimum latitude of the region. If so, the value a is recorded as the set score; The area of ​​the selected area in the display area ÷ the area of ​​the display area × 10, the result is b, and it is determined whether the b value is greater than the set threshold. If the b value is greater than the set threshold, the result obtained by subtracting the set gradient score from the b value is assigned to b; Obtain the distance from the center point of all candidate regions to the center point of the screen, calculate the ranking score, and sort them in ascending order by distance. The value of the region with the smallest distance to the center point is assigned decreasingly downwards, and the obtained value is recorded as c; The obtained weighted score is recorded as a+b+c.

2. The data analysis method based on GIS map according to claim 1 is characterized in that: In step 110, the data source is a data table or a view.

3. The data analysis method based on GIS map according to claim 1 is characterized in that: In step 120, the multidimensional analysis data indicator table is used for fast multidimensional analysis, and the multidimensional analysis data indicator table is a three-dimensional cube, wherein the dimensions of the three-dimensional cube include: topic, time, and region; In the step 140, The user can select the topic, time and area conditions from the floating condition area on the left, and the user can select conditions from the floating analysis icon area on the right to dynamically construct map area display and multi-dimensional analysis.

4. A data analysis device based on GIS map, characterized in that: The device includes: a memory and a processor, wherein the memory stores codes, and the processor is configured to execute the codes. When the codes are executed, the device executes the GIS map-based data analysis method as described in any one of claims 1 to 3.

5. A non-volatile computer-readable storage medium, characterized in that: The non-volatile computer-readable storage medium stores computer-executable instructions, which, when executed by one or more processors, enable the one or more processors to execute the GIS map-based data analysis method described in any one of claims 1 to 3.

Citation Information

Patent Citations

  • Method for carrying out data analysis by combining map

    CN102819671A

  • Method and system for combined hierarchical display of multiple positioning points

    CN104699709A

  • A method and system for displaying operational command on a map

    CN109345610A

  • GIS-based regional power grid statistical professional index display method and system

    CN113553315A

  • Method and system for analyzing educational big data on basis of maps

    US20200125618A1