CN106874415B - Environmental sensitive area database construction method and server based on generalized information system - Google Patents

Environmental sensitive area database construction method and server based on generalized information system Download PDF

Info

Publication number
CN106874415B
CN106874415B CN201710050030.7A CN201710050030A CN106874415B CN 106874415 B CN106874415 B CN 106874415B CN 201710050030 A CN201710050030 A CN 201710050030A CN 106874415 B CN106874415 B CN 106874415B
Authority
CN
China
Prior art keywords
sensitive area
environmental sensitive
geographical location
information
location information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201710050030.7A
Other languages
Chinese (zh)
Other versions
CN106874415A (en
Inventor
张永
赵岩
谢连科
臧玉魏
白晓春
张国英
马新刚
刘辉
陈素红
王飞
李勇
尹建光
徐桂彬
李华峰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
Electric Power Research Institute of State Grid Shandong Electric Power Co Ltd
Electric Power Research Institute of State Grid Shaanxi Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
Electric Power Research Institute of State Grid Shandong Electric Power Co Ltd
Electric Power Research Institute of State Grid Shaanxi Electric Power Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, Electric Power Research Institute of State Grid Shandong Electric Power Co Ltd, Electric Power Research Institute of State Grid Shaanxi Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201710050030.7A priority Critical patent/CN106874415B/en
Publication of CN106874415A publication Critical patent/CN106874415A/en
Application granted granted Critical
Publication of CN106874415B publication Critical patent/CN106874415B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29Geographical information databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Remote Sensing (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Processing Or Creating Images (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention discloses environmental sensitive area database construction method and server based on generalized information system, and wherein this method is completed in server, comprising: obtains environmental sensitive area thematic data and stores to ground chart;A unique ID is distributed in each environmental sensitive area in chart over the ground, and respective environment sensitizing range thematic data is associated with ID;Ground chart is divided into the map layer table of identical quantity number according to the quantity of environmental sensitive area, environmental sensitive area database is finally constructed in each map layer table environmental sensitive area associated and corresponding with an ID;The essential attribute information and geographical location information of corresponding environmental sensitive area are stored in each map layer table, and data are used to show the cartographic information of respective environment sensitizing range in every map layer table after client call.The environmental sensitive area database that the present invention constructs cover environmentally sensitive areas distribution can real-time update and expansion.

Description

Environmental sensitive area database construction method and server based on generalized information system
Technical field
The invention belongs to substation sensitizing range data processing field more particularly to a kind of environment based on generalized information system Sensitizing range database construction method and server.
Background technique
With the development of China's power industry, the capacity of power grid is increasing, and the distance of conveying is more and more remoter, transmission line of electricity Voltage class be also continuously improved, the construction scale of high voltage substation and overhead transmission line constantly expands.Along with economy The influence of the social factors such as development and population growth, newly-built project of transmitting and converting electricity, which is gradually approached to densely populated area, to be had become greatly Gesture is become.Many cities are powered the reorganization and expansion of power network in recent years, and substation is gradually built to urban district, high pressure by city suburbs Overhead transmission line spreads all over the place in Urban Public playground and residential block, substation and the issuable environment of transmission line of electricity It influences to be increasingly subject to the concern of people, to the environmental protection work of project of transmitting and converting electricity, more stringent requirements are proposed.
In project of transmitting and converting electricity environmental impact assessment and design phase, related data are distributed due to lacking environmentally sensitive areas, In project of transmitting and converting electricity addressing route selection and process of construction, measure and pipe that part engineering is taken in terms of environmentally sensitive areas evacuation It is insufficient to manage supporting method;Project of transmitting and converting electricity environmental impact prediction technology is not high in terms of automation, the level of informatization, selects in addressing Line stage and path can not quickly, timely and accurately assess the influence of the environmentally sensitive point of project of transmitting and converting electricity when adjusting.
In conclusion need to establish renewable, the database expanded for covering environmentally sensitive areas distribution, be used to for based on The automatic identification of the project of transmitting and converting electricity environment sensitive spot of existing power network GIS platform, sorting technique and project of transmitting and converting electricity electromagnetism, noise It influences automatic Prediction and analyzes the basis that offers precise data, the informationization of Lai Tigao State Grid Corporation of China power grid environmental protection management, essence Benefitization, intelligent level.
Summary of the invention
In order to solve the disadvantage that the prior art, it is quick that the first object of the present invention is to provide a kind of environment based on generalized information system Sensillary area data base management system.
A kind of environmental sensitive area database construction method based on generalized information system of the invention, this method are complete in server At specifically including:
Step 1: obtaining environmental sensitive area thematic data and store to ground chart;The environmental sensitive area thematic data packet Include the essential attribute information of environmental sensitive area and the geographical location information of the environmental sensitive area detected by generalized information system;Wherein, The essential attribute information of environmental sensitive area includes the rank of environmental sensitive area, membership settling time and protected object information;
Step 2: a unique ID is distributed in each environmental sensitive area in chart over the ground, and respective environment sensitizing range is special Topic data are associated with ID;
Step 3: ground chart being divided into the map layer table of identical quantity number according to the quantity of environmental sensitive area, each A map layer table environmental sensitive area associated and corresponding with an ID, finally constructs environmental sensitive area database;Eachly The essential attribute information and geographical location information of corresponding environmental sensitive area, and data quilt in every map layer table are stored in figure layer table It is used to show the cartographic information of respective environment sensitizing range after client call.
Further, this method further includes: according to the essential attribute information and geographical location information of environmental sensitive area, to every A map layer table establishes a corresponding spatial index table, spatial analysis is carried out for assisting, to accelerate spatial analysis Speed.
Further, this method further includes: environmental sensitive area thematic data is inputted in the way of raster data vector quantization To server or it is manually inputted into server.
Environmental sensitive area thematic data of the invention using raster data vector inputting, be manually entered two ways carry out Processing.The case where papery data all for environmental sensitive area thematic data, this papery data can not be used directly, it is necessary to First carry out rasterizing operation, convert number format for papery data, by development platform by the geographical location of all kinds of sensitizing ranges, In the data entry systems such as boundary.But in rasterizing operation, the problem of due to scanning accuracy, there is no coordinates on map in addition Parameter, therefore, the data after rasterizing often will appear boundary and are not inconsistent, do not match with digital topography map in input system A series of problems is needed by artificial means, to the sensitizing range thematic map after rasterizing, determines several positioning first on boundary Point is corrected sensitizing range boundary stationary point according to the thematic information collected, the sensitizing range information in final realization system with Data in thematic information can reach identical precision on same ratio ruler.Meanwhile the relevant information to sensitizing range into Typing also is carried out to the attribute data of each sensitizing range during pedestrian's work is modified, be finally completed the construction of sensitizing range database with Correction work.
Further, according to the map in type of ground objects, by the ground of the correspondence environmental sensitive area stored in each map layer table Reason location information is divided into node class geographical location information, segmental arc class geographical location information and polygon class geographical location information; Node class geographical location information is corresponding with punctual geo-objects, and segmental arc class geographical location information is corresponding with linear ground object, polygon Class geographical location information is corresponding with area feature.It in this way can be by type of ground objects and the progress of corresponding geographical location information Match, corresponding atural object can be more accurately shown on map.
Further, the spatial index table uses BSP tree, R tree or R+ tree construction.
BSP tree, R tree or R+ tree construction are the spatial indexes for dividing space from up to down, step by step.
BSP tree (Binary Space Partitioning Tree, two-dimensional space partition tree) is one kind step by step by space The binary tree being divided into two, it can be adapted with the distribution situation of spatial object well.And BSP tree depth is generally all very big, Influence the efficiency of various operations.
R tree is another form that B-tree develops to hyperspace, it is divided spatial object by range, each node pair A region and a disk page are answered, the regional scope of its all child node, non-leaf node are stored in the disk page of non-leaf node The regions of all child nodes all fall within its regional scope;It is stored within its regional scope in the disk page of leaf node The boundary rectangle of all spatial objects.The child node number that each node can possess has upper and lower limit, and lower limit guarantees to disk sky Between effective use, the upper limit guarantees the corresponding disk page of each node, but is inserted into the sky that new node makes certain node requirement Between be greater than a disk page when, which is divided into two.R tree is a kind of dynamic indexing structure, it may be assumed that its inquiry can with insertion or It deletes while carrying out, and do not need regularly to reorganize tree construction.
R+ tree is similar with R tree, and the main distinction is in R+ tree that the corresponding area of space of sibling is non-overlapping, divides in this way Space eliminates " dead zone " that R tree generates because allowing the overlapping between node, and (node is in that without this node data White space), invalid inquiry number is reduced, the efficiency of spatial index, but the behaviour for being inserted into, deleting spatial object are provided significantly Make, then to guarantee that area of space is non-overlapping and efficiency reduces by operation.R+ tree stores trans-regional space object data simultaneously Have a redundancy, and in database data increase, redundancy constantly increases.
The second object of the present invention is to provide a kind of server for constructing the environmental sensitive area database based on generalized information system.
A kind of server of the environmental sensitive area database of building of the invention based on generalized information system, comprising:
Data memory module is used to obtain environmental sensitive area thematic data and stores to ground chart;The environment is quick Sensillary area thematic data includes the essential attribute information of environmental sensitive area and the geography of the environmental sensitive area detected by generalized information system Location information;Wherein, the essential attribute information of environmental sensitive area include the rank of environmental sensitive area, membership settling time and Protected object information;
ID distribution module is used for each environmental sensitive area in chart over the ground and distributes a unique ID, and will be corresponding Environmental sensitive area thematic data is associated with ID;
Map layer table constructs module, is used to that ground chart to be divided into identical quantity according to the quantity of environmental sensitive area Several map layer table, each map layer table environmental sensitive area associated and corresponding with an ID, it is quick finally to construct environment Sensillary area database;The essential attribute information and geographical location information of corresponding environmental sensitive area are stored in each map layer table, and Data are used to show the cartographic information of respective environment sensitizing range in every map layer table after client call.
Further, the server further include: spatial index table establishes module, is used for the base according to environmental sensitive area This attribute information and geographical location information establish a corresponding spatial index table to each map layer table, for assisting Spatial analysis is carried out, to accelerate the speed of spatial analysis.
Further, the server further include: data input module is used to utilize environmental sensitive area thematic data Raster data vector quantization mode is input to server or is manually inputted into server.
Environmental sensitive area thematic data of the invention using raster data vector inputting, be manually entered two ways carry out Processing.The case where papery data all for environmental sensitive area thematic data, this papery data can not be used directly, it is necessary to First carry out rasterizing operation, convert number format for papery data, by development platform by the geographical location of all kinds of sensitizing ranges, In the data entry systems such as boundary.But in rasterizing operation, the problem of due to scanning accuracy, there is no coordinates on map in addition Parameter, therefore, the data after rasterizing often will appear boundary and are not inconsistent, do not match with digital topography map in input system A series of problems is needed by artificial means, to the sensitizing range thematic map after rasterizing, determines several positioning first on boundary Point is corrected sensitizing range boundary stationary point according to the thematic information collected, the sensitizing range information in final realization system with Data in thematic information can reach identical precision on same ratio ruler.Meanwhile the relevant information to sensitizing range into Typing also is carried out to the attribute data of each sensitizing range during pedestrian's work is modified, be finally completed the construction of sensitizing range database with Correction work.
Further, the server further include: geographical location information categorization module is used for ground species according to the map The geographical location information of the correspondence environmental sensitive area stored in each map layer table is divided into node class geographical location letter by type Breath, segmental arc class geographical location information and polygon class geographical location information;Node class geographical location information is opposite with punctual geo-objects It answers, segmental arc class geographical location information is corresponding with linear ground object, and polygon class geographical location information is corresponding with area feature.This Sample can match type of ground objects with corresponding geographical location information, can more accurately show on map accordingly Object.
Further, the spatial index table establishes the spatial index table in module using BSP tree, R tree or R+ tree construction.
BSP tree, R tree or R+ tree construction are the spatial indexes for dividing space from up to down, step by step.
BSP tree (Binary Space Partitioning Tree, two-dimensional space partition tree) is one kind step by step by space The binary tree being divided into two, it can be adapted with the distribution situation of spatial object well.And BSP tree depth is generally all very big, Influence the efficiency of various operations.
R tree is another form that B-tree develops to hyperspace, it is divided spatial object by range, each node pair A region and a disk page are answered, the regional scope of its all child node, non-leaf node are stored in the disk page of non-leaf node The regions of all child nodes all fall within its regional scope;It is stored within its regional scope in the disk page of leaf node The boundary rectangle of all spatial objects.The child node number that each node can possess has upper and lower limit, and lower limit guarantees to disk sky Between effective use, the upper limit guarantees the corresponding disk page of each node, but is inserted into the sky that new node makes certain node requirement Between be greater than a disk page when, which is divided into two.R tree is a kind of dynamic indexing structure, it may be assumed that its inquiry can with insertion or It deletes while carrying out, and do not need regularly to reorganize tree construction.
R+ tree is similar with R tree, and the main distinction is in R+ tree that the corresponding area of space of sibling is non-overlapping, divides in this way Space eliminates " dead zone " that R tree generates because allowing the overlapping between node, and (node is in that without this node data White space), invalid inquiry number is reduced, the efficiency of spatial index, but the behaviour for being inserted into, deleting spatial object are provided significantly Make, then to guarantee that area of space is non-overlapping and efficiency reduces by operation.R+ tree stores trans-regional space object data simultaneously Have a redundancy, and in database data increase, redundancy constantly increases.
The invention has the benefit that
(1) it the environmental sensitive area thematic data that will acquire of the present invention and stores to ground chart;It is every in chart over the ground again A unique ID is distributed in a environmental sensitive area, and respective environment sensitizing range thematic data is associated with ID;According to environment Ground chart is divided into the map layer table of identical quantity number by the quantity of sensitizing range, and each map layer table is associated with an ID And a corresponding environmental sensitive area, finally construct environmental sensitive area database;Corresponding environment is stored in each map layer table The essential attribute information and geographical location information of sensitizing range, and data are used to show phase after client call in every map layer table Answer the cartographic information of environmental sensitive area;The environmental sensitive area database of building cover environmentally sensitive areas distribution can real-time update And it expands;By the consistency operation of system, can all geography information, environmental sensitive area data be edited, be increased and decreased etc. with behaviour Make, by establishing multistage auditing mechanism, database data can be made to be timely updated, reflects Around actual conditions in time, It is preferably engineering feasibility study, planning evaluation service.
(2) the essential attribute information and geographical location information of the invention also according to environmental sensitive area, to each map layer table Establish a corresponding spatial index table, for assist carry out spatial analysis, to accelerate the speed of spatial analysis, for based on The automatic identification of the project of transmitting and converting electricity environment sensitive spot of existing power network GIS platform, sorting technique provide accurate dynamic change Data basis finally realizes informationization, the lean, intelligent level of State Grid Corporation of China's power grid environmental protection management.
Detailed description of the invention
Fig. 1 is a kind of environmental sensitive area database construction method flow chart based on generalized information system of the invention.
Fig. 2 is a kind of server architecture figure of the environmental sensitive area database of building of the invention based on generalized information system.
Specific embodiment
The present invention will be further described with embodiment with reference to the accompanying drawing:
Environmental sensitive area according to the present invention, it is with referring to all types nature, the culture protection of constituted by law and right The especially sensitive region of certain class pollution factor or the ecology influence factor of construction project.
Environmental sensitive area includes:
(1) nature reserve area, scenic spot, Place of world cultural and natural heritage, drinking water source protection zone;
(2) Basic Farmland Conservation Zones, basic grassland, Forest Park, geological park, Important Wetland, wildwood, rare be on the point of The natural areal concentration of danger wild animals and plants, the natural spawning field of important aquatile, feeding ground, wintering ground and migration channel, Natural fishing ground, resources water shortage area, soil erosion keypoint control area, sandy land close protection zone, closing and semi-enclosed sea Domain, eutrophic water;
It (three) is the region of major function, historical relic's protection with inhabitation, health care, culture and education, scientific research, administrative office etc. Unit, the protecting field with special history, culture, science, national meaning.
According to " Environmental Impact Assessment of Construction Items Classification Management register " (2015 editions), the environment that project of transmitting and converting electricity is related to is quick Sensillary area is mainly (one) class and (three) class.Practical in conjunction with company's power network construction project environmental impact assessment, checking and accepting, this project is by the (1) the related content in class and (three) class is merged, and nature reserve area, scenic spot, drinking water source are protected The environmental sensitive area that the engineerings such as area, cultural relics and historic sites are paid close attention to individually sets class, due to the project of transmitting and converting electricity in environmental impact assessment is evaluated The sensitive targets such as Forest Park are often also related to, therefore, although the environment sensitive that Forest Park is not related in project of transmitting and converting electricity In area's type, but also the relevant information of Forest Park is collected and arranged when searching money and exploitation, is incorporated into nature guarantor It protects in area.In view of data volume and sensitive zone properties, cultural relics and historic sites, Place of world cultural and natural heritage are merged into cultural relics and historic sites Figure layer, meanwhile, the inquiry and management in historic site linear for ancient Great Wall etc., combining environmental sensitizing range database are built for convenience If increasing linear historic site class figure layer.As for resident residential area, hospital, school, Office Area paid close attention in engineering construction etc. with people Sensitizing range based on group, relevant location information, boundary information are mainly to show in topographic map after vector quantization, therefore, In database design, such sensitizing range information is included into the map vector data library of stratum, and the data of the part sensitizing range are by state's net The GIS unified platform provides.
Fig. 1 is a kind of environmental sensitive area database construction method flow chart based on generalized information system of the invention.
The environmental sensitive area database construction method based on generalized information system, this method are completed in server as shown in Figure 1, It is specifically included:
Step 1: obtaining environmental sensitive area thematic data and store to ground chart;The environmental sensitive area thematic data packet Include the essential attribute information of environmental sensitive area and the geographical location information of the environmental sensitive area detected by generalized information system;Wherein, The essential attribute information of environmental sensitive area includes the rank of environmental sensitive area, membership settling time and protected object information.
Step 2: a unique ID is distributed in each environmental sensitive area in chart over the ground, and respective environment sensitizing range is special Topic data are associated with ID.
Step 3: ground chart being divided into the map layer table of identical quantity number according to the quantity of environmental sensitive area, each A map layer table environmental sensitive area associated and corresponding with an ID, finally constructs environmental sensitive area database;Eachly The essential attribute information and geographical location information of corresponding environmental sensitive area, and data quilt in every map layer table are stored in figure layer table It is used to show the cartographic information of respective environment sensitizing range after client call.
Wherein:
A. atlas table: the table that whole system has, it can be used as the highest level table in an atlas, in reality It can be used as the overall planning table of multiple databases on now.Itself has the reference and description information of each map.
B. chart: the table that each map has, it can be used as the highest table of map in one engineering of management, It is realized with the overall planning forms mode of a database.The table has each layer reference, description and reference information.
C. map layer table: each map layer has such a table, its table as one figure layer of management.Table tool There are the spatial object of basic figure layer and the corresponding description information of each spatial object.
D. spatial index table: the corresponding spatial index table of each map layer, it carries out spatial analysis for assisting, to add The speed of fast spatial analysis.
In another embodiment, this method further include: believed according to the essential attribute information of environmental sensitive area and geographical location Breath, establishes a corresponding spatial index table to each map layer table, spatial analysis is carried out for assisting, to accelerate space The speed of analysis.
Wherein, spatial index table uses BSP tree, R tree or R+ tree construction.
BSP tree, R tree or R+ tree construction are the spatial indexes for dividing space from up to down, step by step.
BSP tree (Binary Space Partitioning Tree, two-dimensional space partition tree) is one kind step by step by space The binary tree being divided into two, it can be adapted with the distribution situation of spatial object well.And BSP tree depth is generally all very big, Influence the efficiency of various operations.
R tree is another form that B-tree develops to hyperspace, it is divided spatial object by range, each node pair A region and a disk page are answered, the regional scope of its all child node, non-leaf node are stored in the disk page of non-leaf node The regions of all child nodes all fall within its regional scope;It is stored within its regional scope in the disk page of leaf node The boundary rectangle of all spatial objects.The child node number that each node can possess has upper and lower limit, and lower limit guarantees to disk sky Between effective use, the upper limit guarantees the corresponding disk page of each node, but is inserted into the sky that new node makes certain node requirement Between be greater than a disk page when, which is divided into two.R tree is a kind of dynamic indexing structure, it may be assumed that its inquiry can with insertion or It deletes while carrying out, and do not need regularly to reorganize tree construction.
R+ tree is similar with R tree, and the main distinction is in R+ tree that the corresponding area of space of sibling is non-overlapping, divides in this way Space eliminates " dead zone " that R tree generates because allowing the overlapping between node, and (node is in that without this node data White space), invalid inquiry number is reduced, the efficiency of spatial index, but the behaviour for being inserted into, deleting spatial object are provided significantly Make, then to guarantee that area of space is non-overlapping and efficiency reduces by operation.R+ tree stores trans-regional space object data simultaneously Have a redundancy, and in database data increase, redundancy constantly increases.
In another embodiment, this method further include: environmental sensitive area thematic data is utilized into raster data vector quantization side Formula is input to server or is manually inputted into server.
Environmental sensitive area thematic data of the invention using raster data vector inputting, be manually entered two ways carry out Processing.The case where papery data all for environmental sensitive area thematic data, this papery data can not be used directly, it is necessary to First carry out rasterizing operation, convert number format for papery data, by development platform by the geographical location of all kinds of sensitizing ranges, In the data entry systems such as boundary.But in rasterizing operation, the problem of due to scanning accuracy, there is no coordinates on map in addition Parameter, therefore, the data after rasterizing often will appear boundary and are not inconsistent, do not match with digital topography map in input system A series of problems is needed by artificial means, to the sensitizing range thematic map after rasterizing, determines several positioning first on boundary Point is corrected sensitizing range boundary stationary point according to the thematic information collected, the sensitizing range information in final realization system with Data in thematic information can reach identical precision on same ratio ruler.Meanwhile the relevant information to sensitizing range into Typing also is carried out to the attribute data of each sensitizing range during pedestrian's work is modified, be finally completed the construction of sensitizing range database with Correction work.
In another embodiment, according to the map in type of ground objects, the correspondence environment sensitive that will be stored in each map layer table The geographical location information in area is divided into node class geographical location information, segmental arc class geographical location information and polygon class geographical location Information;Node class geographical location information is corresponding with punctual geo-objects, and segmental arc class geographical location information is corresponding with linear ground object, more Side shape class geographical location information is corresponding with area feature.Type of ground objects can be carried out with corresponding geographical location information in this way Matching, can more accurately show corresponding atural object on map.
The Object-relational Database model of environmental sensitive area data of the invention:
A. the atural object feature model of object-oriented
The various atural objects for dividing map from geometric aspects can be abstracted are as follows: punctual geo-objects, linear ground object, area feature and mixed Close the complicated atural object constituted.Then map M can simply be expressed as node class, segmental arc class, polygon class with the mode of object-oriented.
B. the attribute data model of object-oriented
On the basis of relationship DBMS, increase the functions such as encapsulation, succession and the information propagation of object oriented data model.
C. topological relation and object oriented programming model
Adjacent, incidence relation between usual atural object can be implied by the data sharing of common node, public segmental arc Expression.
In traditional map making system, generally store figure and attribute data are completely separable hereof, but As graph data amount is increasingly huge, the especially requirement of map data sets management and service has made this separation management It is not able to satisfy the needs of current map data management.
Compared with file system management, database of the invention has the advantage that retrieval capability height, data easy to accomplish Safety management, data integrity inspection, con current control, data sharing, the integrated management of figure and attribute data, additionally it is possible to Operating system is closely integrated.
Environmental sensitive area thematic data that the present embodiment will acquire simultaneously is stored to ground chart;Again over the ground each of in chart A unique ID is distributed in environmental sensitive area, and respective environment sensitizing range thematic data is associated with ID;It is quick according to environment Ground chart is divided into the map layer table of identical quantity number by the quantity of sensillary area, each map layer table it is associated with an ID and A corresponding environmental sensitive area, finally constructs environmental sensitive area database;It is quick that corresponding environment is stored in each map layer table The essential attribute information and geographical location information of sensillary area, and data are used to show after client call accordingly in every map layer table The cartographic information of environmental sensitive area;The environmental sensitive area database of building cover environmentally sensitive areas distribution can real-time update with And it expands;By the consistency operation of system, can all geography information, environmental sensitive area data be edited, be increased and decreased etc. with operation, By establishing multistage auditing mechanism, database data can be made to be timely updated, reflect Around actual conditions in time, more preferably It is engineering feasibility study, planning evaluation service.
Fig. 2 is a kind of server architecture figure of the environmental sensitive area database of building of the invention based on generalized information system.
The server of environmental sensitive area database of the building based on generalized information system as shown in Figure 2, comprising:
Data memory module is used to obtain environmental sensitive area thematic data and stores to ground chart;The environment is quick Sensillary area thematic data includes the essential attribute information of environmental sensitive area and the geography of the environmental sensitive area detected by generalized information system Location information;Wherein, the essential attribute information of environmental sensitive area include the rank of environmental sensitive area, membership settling time and Protected object information;
ID distribution module is used for each environmental sensitive area in chart over the ground and distributes a unique ID, and will be corresponding Environmental sensitive area thematic data is associated with ID;
Map layer table constructs module, is used to that ground chart to be divided into identical quantity according to the quantity of environmental sensitive area Several map layer table, each map layer table environmental sensitive area associated and corresponding with an ID, it is quick finally to construct environment Sensillary area database;The essential attribute information and geographical location information of corresponding environmental sensitive area are stored in each map layer table, and Data are used to show the cartographic information of respective environment sensitizing range in every map layer table after client call.
In one embodiment, the server further include: spatial index table establishes module, is used for according to environment sensitive The essential attribute information and geographical location information in area establish a corresponding spatial index table to each map layer table, use In assisting progress spatial analysis, to accelerate the speed of spatial analysis.
Wherein, spatial index table establishes the spatial index table in module using BSP tree, R tree or R+ tree construction.
BSP tree, R tree or R+ tree construction are the spatial indexes for dividing space from up to down, step by step.
BSP tree (Binary Space Partitioning Tree, two-dimensional space partition tree) is one kind step by step by space The binary tree being divided into two, it can be adapted with the distribution situation of spatial object well.And BSP tree depth is generally all very big, Influence the efficiency of various operations.
R tree is another form that B-tree develops to hyperspace, it is divided spatial object by range, each node pair A region and a disk page are answered, the regional scope of its all child node, non-leaf node are stored in the disk page of non-leaf node The regions of all child nodes all fall within its regional scope;It is stored within its regional scope in the disk page of leaf node The boundary rectangle of all spatial objects.The child node number that each node can possess has upper and lower limit, and lower limit guarantees to disk sky Between effective use, the upper limit guarantees the corresponding disk page of each node, but is inserted into the sky that new node makes certain node requirement Between be greater than a disk page when, which is divided into two.R tree is a kind of dynamic indexing structure, it may be assumed that its inquiry can with insertion or It deletes while carrying out, and do not need regularly to reorganize tree construction.
R+ tree is similar with R tree, and the main distinction is in R+ tree that the corresponding area of space of sibling is non-overlapping, divides in this way Space eliminates " dead zone " that R tree generates because allowing the overlapping between node, and (node is in that without this node data White space), invalid inquiry number is reduced, the efficiency of spatial index, but the behaviour for being inserted into, deleting spatial object are provided significantly Make, then to guarantee that area of space is non-overlapping and efficiency reduces by operation.R+ tree stores trans-regional space object data simultaneously Have a redundancy, and in database data increase, redundancy constantly increases.
In one embodiment, the server further include: data input module is used for environmental sensitive area special topic number According to being input to server in the way of raster data vector quantization or be manually inputted into server.
Environmental sensitive area thematic data of the invention using raster data vector inputting, be manually entered two ways carry out Processing.The case where papery data all for environmental sensitive area thematic data, this papery data can not be used directly, it is necessary to First carry out rasterizing operation, convert number format for papery data, by development platform by the geographical location of all kinds of sensitizing ranges, In the data entry systems such as boundary.But in rasterizing operation, the problem of due to scanning accuracy, there is no coordinates on map in addition Parameter, therefore, the data after rasterizing often will appear boundary and are not inconsistent, do not match with digital topography map in input system A series of problems is needed by artificial means, to the sensitizing range thematic map after rasterizing, determines several positioning first on boundary Point is corrected sensitizing range boundary stationary point according to the thematic information collected, the sensitizing range information in final realization system with Data in thematic information can reach identical precision on same ratio ruler.Meanwhile the relevant information to sensitizing range into Typing also is carried out to the attribute data of each sensitizing range during pedestrian's work is modified, be finally completed the construction of sensitizing range database with Correction work.
In one embodiment, the server further include: geographical location information categorization module is used according to the map The geographical location information of the correspondence environmental sensitive area stored in each map layer table is divided into node class geography position by type of ground objects Confidence breath, segmental arc class geographical location information and polygon class geographical location information;Node class geographical location information and punctual geo-objects Corresponding, segmental arc class geographical location information is corresponding with linear ground object, and polygon class geographical location information is opposite with area feature It answers.Type of ground objects can be matched in this way with corresponding geographical location information, phase can be more accurately shown on map The atural object answered.
Above-mentioned, although the foregoing specific embodiments of the present invention is described with reference to the accompanying drawings, not protects model to the present invention The limitation enclosed, those skilled in the art should understand that, based on the technical solutions of the present invention, those skilled in the art are not Need to make the creative labor the various modifications or changes that can be made still within protection scope of the present invention.

Claims (10)

1. a kind of environmental sensitive area database construction method based on generalized information system, which is characterized in that this method is complete in server At specifically including:
Step 1: obtaining environmental sensitive area thematic data and store to ground chart;The environmental sensitive area thematic data includes ring The essential attribute information of border sensitizing range and the geographical location information of the environmental sensitive area detected by generalized information system;Wherein, environment The essential attribute information of sensitizing range includes the rank of environmental sensitive area, membership settling time and protected object information;
Step 2: a unique ID is distributed in each environmental sensitive area in chart over the ground, and by respective environment sensitizing range special topic number It is associated according to ID;
Step 3: ground chart is divided into the map layer table of identical quantity number, each map according to the quantity of environmental sensitive area A layer table environmental sensitive area associated and corresponding with an ID, finally constructs environmental sensitive area database;Each map layer The essential attribute information and geographical location information of corresponding environmental sensitive area are stored in table, and in every map layer table data by client End is used to show the cartographic information of respective environment sensitizing range after calling.
2. a kind of environmental sensitive area database construction method based on generalized information system as described in claim 1, which is characterized in that This method further include: according to the essential attribute information and geographical location information of environmental sensitive area, one is established to each map layer table A corresponding spatial index table carries out spatial analysis for assisting, to accelerate the speed of spatial analysis.
3. a kind of environmental sensitive area database construction method based on generalized information system as described in claim 1, which is characterized in that Environmental sensitive area thematic data is input to server in the way of raster data vector quantization or is manually inputted into server.
4. a kind of environmental sensitive area database construction method based on generalized information system as described in claim 1, which is characterized in that The geographical location information of the correspondence environmental sensitive area stored in each map layer table is divided into section by middle type of ground objects according to the map Point class geographical location information, segmental arc class geographical location information and polygon class geographical location information;Node class geographical location information Corresponding with punctual geo-objects, segmental arc class geographical location information is corresponding with linear ground object, polygon class geographical location information and face Shape atural object is corresponding.
5. a kind of environmental sensitive area database construction method based on generalized information system as claimed in claim 2, which is characterized in that The spatial index table is using any one in BSP tree or R tree or R+ tree construction.
6. a kind of server for constructing the environmental sensitive area database based on generalized information system characterized by comprising
Data memory module is used to obtain environmental sensitive area thematic data and stores to ground chart;The environmental sensitive area Thematic data includes the essential attribute information of environmental sensitive area and the geographical location of the environmental sensitive area detected by generalized information system Information;Wherein, the essential attribute information of environmental sensitive area includes the rank of environmental sensitive area, membership settling time and protection Object information;
ID distribution module is used for each environmental sensitive area in chart over the ground and distributes a unique ID, and by respective environment Sensitizing range thematic data is associated with ID;
Map layer table constructs module, is used to that ground chart to be divided into identical quantity number according to the quantity of environmental sensitive area Map layer table, each map layer table environmental sensitive area associated and corresponding with an ID, finally constructs environmental sensitive area Database;It is stored with the essential attribute information and geographical location information of corresponding environmental sensitive area in each map layer table, and every Data are used to show the cartographic information of respective environment sensitizing range in figure layer table after client call.
7. server as claimed in claim 6, which is characterized in that the server further include: spatial index table establishes module, It is used for essential attribute information and geographical location information according to environmental sensitive area, to each map layer table establish one it is right with it The spatial index table answered carries out spatial analysis for assisting, to accelerate the speed of spatial analysis.
8. server as claimed in claim 6, which is characterized in that the server further include: data input module is used for Environmental sensitive area thematic data is input to server in the way of raster data vector quantization or is manually inputted into server.
9. server as claimed in claim 6, which is characterized in that the server further include: geographical location information classification mould Block is used for type of ground objects according to the map, and the geographical location of the correspondence environmental sensitive area stored in each map layer table is believed Breath is divided into node class geographical location information, segmental arc class geographical location information and polygon class geographical location information;Node class Reason location information is corresponding with punctual geo-objects, and segmental arc class geographical location information is corresponding with linear ground object, polygon class geography position Confidence breath is corresponding with area feature.
10. server as claimed in claim 7, which is characterized in that the spatial index table establishes the spatial index in module Table is using any one in BSP tree or R tree or R+ tree construction.
CN201710050030.7A 2017-01-23 2017-01-23 Environmental sensitive area database construction method and server based on generalized information system Active CN106874415B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710050030.7A CN106874415B (en) 2017-01-23 2017-01-23 Environmental sensitive area database construction method and server based on generalized information system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710050030.7A CN106874415B (en) 2017-01-23 2017-01-23 Environmental sensitive area database construction method and server based on generalized information system

Publications (2)

Publication Number Publication Date
CN106874415A CN106874415A (en) 2017-06-20
CN106874415B true CN106874415B (en) 2019-08-06

Family

ID=59158955

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710050030.7A Active CN106874415B (en) 2017-01-23 2017-01-23 Environmental sensitive area database construction method and server based on generalized information system

Country Status (1)

Country Link
CN (1) CN106874415B (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108334564B (en) * 2018-01-12 2021-10-22 南京海兴电网技术有限公司 Multi-theme chart display method based on space object
CN108829703A (en) * 2018-04-28 2018-11-16 尚谷科技(天津)有限公司 A kind of processing method of the remote sensing elevation data based on multi-source tree graph structure
WO2020031924A1 (en) * 2018-08-10 2020-02-13 ソニーセミコンダクタソリューションズ株式会社 Information processing device, terminal device, information processing method, and information processing program
CN112463804B (en) * 2021-02-02 2021-06-15 湖南大学 KDTree-based image database data processing method
CN113806423A (en) * 2021-09-18 2021-12-17 武汉朗迈科技有限公司 GIS-based power transmission and transformation project environment-friendly detection system and method
CN114218215B (en) * 2021-12-15 2023-04-14 中国民用航空飞行学院 Optimized rendering method for large-scale GIS data
CN116991964B (en) * 2023-09-25 2023-12-26 浙江电力交易中心有限公司 Method, system and storage medium for processing green electricity data of regional users

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976248A (en) * 2010-10-15 2011-02-16 陕西电力科学研究院 Method for rapidly identifying environmental risk of power transmission and transformation project
CN102708518A (en) * 2012-05-03 2012-10-03 山东电力研究院 Transmission and transformation project environment sensitive area comprehensive management system based on geographic information technology
CN103971208A (en) * 2014-05-23 2014-08-06 深圳市环境监测中心站 System and method for classifying construction projects of transmission and transformation project
CN104680330A (en) * 2015-03-18 2015-06-03 北京师范大学 System and testing method based on resource environmental bearing capacity evaluation indexes

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976248A (en) * 2010-10-15 2011-02-16 陕西电力科学研究院 Method for rapidly identifying environmental risk of power transmission and transformation project
CN102708518A (en) * 2012-05-03 2012-10-03 山东电力研究院 Transmission and transformation project environment sensitive area comprehensive management system based on geographic information technology
CN103971208A (en) * 2014-05-23 2014-08-06 深圳市环境监测中心站 System and method for classifying construction projects of transmission and transformation project
CN104680330A (en) * 2015-03-18 2015-06-03 北京师范大学 System and testing method based on resource environmental bearing capacity evaluation indexes

Also Published As

Publication number Publication date
CN106874415A (en) 2017-06-20

Similar Documents

Publication Publication Date Title
CN106874415B (en) Environmental sensitive area database construction method and server based on generalized information system
CN104008162B (en) A kind of one-touch thematic maps automatic mapping method and system based on template
CN104252489A (en) Method for fast obtaining position character description information according to latitude and longitude data
CN112988946B (en) Geographic entity database user customization method
CN101685465B (en) Integrated three-dimensional data modeling method for comprehensive pipe network geographic information system
Choe et al. Omnidirectional connectivity of urban open spaces provides context for local government redevelopment plans
Guo et al. Large‐Scale and Refined Green Space Identification‐Based Sustainable Urban Renewal Mode Assessment
Belka Multicriteria analysis and GIS application in the selection of sustainable motorway corridor
Sheppard From site to territory
CN208014001U (en) A kind of environmental sensitive area intelligent recognition and management system
Raffa The strada litoranea. Mapping colonial rural landscape along the Libyan coastal road.
Shih et al. The morphology of evolved urban fabric around farm ponds
Wang Spatial analysis of the Great Wall Ji Town military settlements in the Ming Dynasty: Research and conservation
Cialdea Planning activities in coastal areas Italian and cross-border approaches along the Adriatic Sea
CN113191472B (en) Construction and identification method of village and town community space development code pattern, scanning module and storage medium
Dong et al. A topographically preserved road‐network tile model and optimal routing method for virtual globes
Guan et al. The Research on the Site Selection of Tourist Resort Based on GIS
Zhao Spatial allocation model of ecological land in the urban fringe of Xi’an City based on geosynclinal fold belt structure
Manca et al. Waiting to know the future: A SLEUTH model forecast of urban growth with real data
Guizhi The design and product of national 1∶ 10 00000 cartographic data of topographic map
Zeng et al. Architectural design methods for mountainous environments
Wang From fragments to system: a research on the mesoscale structure of vernacular landscapes in the Hang-Jia-Hu area, China
Batuev et al. Formation of the academic direction in Atlas mapping of the regions of Siberia (50 th anniversary of the publication of the Atlas of Transbaikalia)
Yamashkin et al. Formation of Spatial Databases within the Spatial Data Infrastructure
Kirca et al. Landscape continuity analysis as a tool for landscape planning: A case study in istanbul

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant