WO2020181711A1 - 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统 - Google Patents

一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统 Download PDF

Info

Publication number
WO2020181711A1
WO2020181711A1 PCT/CN2019/098761 CN2019098761W WO2020181711A1 WO 2020181711 A1 WO2020181711 A1 WO 2020181711A1 CN 2019098761 W CN2019098761 W CN 2019098761W WO 2020181711 A1 WO2020181711 A1 WO 2020181711A1
Authority
WO
WIPO (PCT)
Prior art keywords
vector data
openlayers
query
data storage
storage database
Prior art date
Application number
PCT/CN2019/098761
Other languages
English (en)
French (fr)
Inventor
柳孟成
史鑫明
王瑜慧
王旭
Original Assignee
紫光云数科技有限公司
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 紫光云数科技有限公司 filed Critical 紫光云数科技有限公司
Publication of WO2020181711A1 publication Critical patent/WO2020181711A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29—Geographical information databases

Definitions

  • the invention belongs to the technical field of geographic information system data processing, and more specifically, relates to a large-scale vector data display method and system based on MySQL 5.7 and OpenLayers.
  • Geographical information system is a computer system that collects, stores, manages, calculates, analyzes, displays and describes all or part of the data surface related to spatial and geographic distribution.
  • GIS began in Canada and the United States in the 1960s. Since then, many countries have invested a lot of research work, especially driven by the rapid development of computer technology, geographic information processing and analysis methods have become more advanced, and GIS technology has matured. At this time, the definition of GIS It is no longer confined to paper maps. It has become a new discipline that intersects computer technology with multiple disciplines. In layman's terms, GIS uses surveying and mapping to generate paper maps or aerial photography and satellite images.
  • the GIS system has rich spatial query, spatial analysis and attribute management functions.
  • WebGIS a new type of GIS system, namely WebGIS, is presented by the integration of GIS system and network technology.
  • the concept of this system is the product of Internet technology applied in the field of GIS.
  • Internet users can browse the spatial data of the WebGIS system site, make thematic maps, and perform various spatial retrieval and spatial analysis.
  • WebGIS The framework of WebGIS includes front-end, back-end programs and data.
  • WebGIS data can be roughly divided into three types, one is map and image data, one is spatial attribute data, and the other is business data.
  • Spatial attribute data includes spatial data and attribute data.
  • Spatial data is used to describe objects from reality and unify the data to indicate the shape, size, location and distribution characteristics of spatial entities.
  • Spatial data structure is the organization and coding form of spatial data in a computer. It is a logical structure suitable for computer storage, management and processing of spatial data. It is an abstract description of the spatial arrangement and interrelationship of geographic entities, namely geographic entities. The organization method of the data itself.
  • the structure types of spatial data are divided into raster data and vector data.
  • Raster data is a data organization method that represents the distribution of spatial features or phenomena in the form of a two-dimensional matrix. Each matrix unit is called a grid unit (Cell), and each data in the grid represents the attributes of features or phenomena. Data, so raster data has obvious attributes and implicit positioning.
  • Cell grid unit
  • Vector data uses points, lines, and planes to express the real world. It has obvious positioning and implicit attributes. Because vector data has the advantages of compact data structure, low redundancy, high expression accuracy, good graphics display quality, and is conducive to network and retrieval analysis, it has been widely used in WebGIS. However, with the advent of the big data era, high-precision, wide-coverage vector data has exploded, and how to effectively store and display large-scale vector data has become an urgent problem to be solved.
  • OpenLayers is a JavaScript class library package specially provided for Web GIS client development, used to realize the access to map data published in standard format.
  • PostGIS is an open source program that provides support for storing spatial geographic data for the object-relational database PostgreSQL, making PostgreSQL a spatial database capable of spatial data management, quantity measurement, and geometric topology analysis.
  • PostGIS implements the SQL implementation reference of the basic feature classes (point, line, polygon, multipoint, multiline, multisurface, etc.) proposed by the Open Geospatial Consortium.
  • PostgreSQL database is specially added to the software development project to support the storage and display of vector data, it will not only increase the cost of pre-development, but also Increasing the difficulty of market recognition and acceptance. Therefore, it is very necessary to propose a large-scale vector data storage and display method adapted to the current domestic mainstream databases.
  • the purpose of the present invention is to provide a large-scale vector data display method and system based on MySQL 5.7 and OpenLayers, so as to solve the domestic lack of a large-scale vector data storage and display method suitable for current domestic mainstream databases in the prior art.
  • the present invention provides a large-scale vector data display method based on MySQL 5.7 and OpenLayers, including:
  • the vector data in GeoJSON format of the query area returned from the vector data storage database through the Web service is dynamically rendered and displayed on the browser.
  • the MySQL database is popular in China and is the current mainstream database in China. Many existing domestic software use MySQL.
  • the database the technical solution provided by the present invention enables the display method of large-scale vector data to be seamlessly integrated with the existing software project, and reduces the difficulty of early development and the cost of later maintenance.
  • a spatial index is added to the spatial field of the vector data storage database.
  • the query area is the current display area of the OpenLayers map engine, and the query request for the query area is sent when the current display area of the OpenLayers map engine changes.
  • the vector data displayed by the OpenLayers map engine are all vector data in the current display area. Compared with all the vector data of the displayed map, it has a small buffer amount and a fast buffer speed, which greatly improves the browsing experience of the map.
  • the spatial query of the vector data storage database includes:
  • the format of the retrieved object is converted into GeoJSON format and returned to the OpenLayers map engine through the Web service.
  • the present invention also provides a large-scale vector data display system based on MySQL 5.7 and OpenLayers, including:
  • Vector data storage database It is constructed based on the geometry type of MySQL 5.7 to store vector data, and based on the received query request, spatial query is performed to output the vector data in GeoJSON format;
  • the OpenLayers map engine sends a query request using the current display area as the query area to the vector data storage database through a Web service, and dynamically renders the vector data returned from the vector data storage database;
  • the browser displays the vector data dynamically rendered by the OpenLayers map engine.
  • the geometry type provided by MySQL 5.7 and the OpenLayers map engine are integrated to realize the storage and display of vector data.
  • MySQL database is popular in China and is the current mainstream database in China.
  • Many existing domestic software use MySQL database.
  • the technical solution provided by the present invention enables the display method of large-scale vector data to be seamlessly integrated with existing software projects, and reduces the difficulty of early development and the cost of later maintenance.
  • the invention relates to a large-scale vector data display method based on MySQL 5.7 and OpenLayers, including: constructing a vector data storage database based on the geometry type of MySQL 5.7 and storing the vector data; and querying based on the query area sent by the OpenLayers map engine Request, do a spatial query on the vector data storage database; and dynamically render the vector data in GeoJSON format of the query area returned from the vector data storage database through the Web service, and display it on the browser.
  • the solution provided by the present invention integrates the geometry type provided by MySQL 5.7 and the OpenLayers map engine to realize the storage and display of vector data.
  • the MySQL database is popular in China and is the current mainstream database in China. Many existing domestic software use MySQL database.
  • the technical solution provided by the present invention enables the display method of large-scale vector data to be seamlessly integrated with existing software projects, and reduces the difficulty of early development and the cost of later maintenance.
  • Fig. 1 is a logic flow chart of a large-scale vector data display method based on MySQL 5.7 and OpenLayers provided by an embodiment of the present invention.
  • the invention relates to revealing a large-scale vector data display system based on MySQL5.7 and OpenLayers, including:
  • Vector data storage database It is constructed based on the geometry type of MySQL 5.7 to store vector data, and based on the received query request, spatial query is performed to output the vector data in GeoJSON format;
  • the OpenLayers map engine sends a query request using the current display area as the query area to the vector data storage database through a Web service, and dynamically renders the vector data returned from the vector data storage database;
  • the browser displays the vector data dynamically rendered by the OpenLayers map engine.
  • MySQL is a relational database management system. Relational databases store data in different tables. Compared with storing data in a large warehouse, it has the advantages of fast speed and flexibility. At the same time, MySQL is one of the preferred databases for software project development due to its open source, small size, and fast speed, and has a high market share. MySQL 5.7 is the MySQL version released in 2015. Compared with MySQL 5.6, the speed is 3 times faster, and at the same time it improves the usability, manageability and security. It adds a new GIS module and provides a geometry type.
  • the large-scale vector data display methods of the large-scale vector data display system based on MySQL5.7 and OpenLayers include:
  • a spatial index is added to the spatial field of the vector data storage database, which greatly improves the retrieval speed of the vector data storage database.
  • the OpenLayers map engine and the vector data storage database establish a connection through the Web service.
  • the query area sent by the OpenLayers map engine is the current display area of the OpenLayers map engine, and when the current display area of the OpenLayers map engine changes, such as in a browser When you drag the mouse upwards, the OpenLayers map engine sends a query request for the changed query area to the vector data storage database through the Web service. To put it simply, the OpenLayers map engine only displays the vector data in the current display area each time. Compared with displaying the vector data of all areas at once, it has the advantages of small data volume, low buffer pressure, and good browsing experience.
  • the vector data storage database After the vector data storage database receives the query request, it will perform a spatial query, including: retrieving objects in the vector data storage database that satisfy the query area;
  • the spatial query statement of the vector data storage database is:
  • GeoJSON is a format for encoding various geographic data structures, a geographic spatial information data exchange format based on Javascript object notation.
  • MySQL is an open source system for WebGIS projects.
  • the development of software has the advantage of reducing software development costs, and MySQL, as the mainstream domestic database system, also enhances the seamless integration of WebGIS projects with existing software projects, reducing the difficulty of software development.

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)
  • Instructional Devices (AREA)

Abstract

本发明涉及的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，包括：基于MySQL5.7的geometry类型构建矢量数据存储数据库并存入矢量数据；基于OpenLayers地图引擎发送的查询区域的查询请求，对矢量数据存储数据库做空间查询；以及，动态渲染通过Web服务自矢量数据存储数据库返回的所述查询区域的GeoJSON格式的矢量数据，并于浏览器显示。本发明提供的方案整合MySQL5.7提供的geometry类型和OpenLayers地图引擎实现矢量数据的存储和显示，MySQL数据库在国内普及度较高，为国内当前主流数据库，国内现有许多软件均是采用MySQL数据库，本发明提供的技术方案使得大规模矢量数据的展示方法可与现有的软件项目实现无缝集成，降低了前期开发难度和后期维护成本。

Description

一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统 技术领域
本发明属于地理信息系统数据处理技术领域，更具体地说，是涉及一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统。
背景技术
地理信息系统是以采集、存储、管理、运算、分析、显示和描述整个或部分数据表面与空间和地理分布有关的数据的计算机系统。GIS始于60年代的加拿大和美国，尔后各国相继投入大量的研究工作，特别是在计算机技术飞速发展的推动下，地理信息的处理、分析手段日趋先进，GIS技术日臻成熟，此时GIS的定义已不再是局限于纸上的地图了，它已成为一个计算机技术与多种学科相交叉的新型学科，通俗地讲，GIS是利用测绘生成纸质地图或者航拍以及卫星等生成影像后，将这些数据存储在计算机中，以地图或图片的形式表现出来，然后根据实际生产生活以及科研中的各种需求，进而提供具体的经过处理后的数据；目前GIS已经在环境、资源、石油、电力、土地、交通、公安、急救、航空、市政管理、城市规划、经济咨询、灾害损失预测、投资评价、政府管理和军事等与地理坐标相关的几乎所有领域获得了广泛的应用。
GIS系统具有丰富的空间查询、空间分析及属性管理功能。随着Internet技术的不断发展和人们对GIS系统的需求，把GIS系统与网络技术相融合，呈现了一种新型的GIS系统，即WebGIS，该系统的概念是Internet技术应用于GIS领域的产物。通过万维网的任意一个节点，Internet用户就可以浏览WebGIS系统站点的空间数据、制作专题图，以及进行各种空间检索和空间分析。
WebGIS的框架包括前端，后台程序和数据，其中WebGIS的数据大致可以 分为三种，一种是地图、影像数据，一种是空间属性数据，一种是业务数据。空间属性数据包括空间数据和属性数据，空间数据是用来描述来自于现实的目标，将数据统一化，借以表明空间实体的形状大小以及位置和分布特征。空间数据结构是空间数据在计算机内的组织和编码形式，它是一种适合于计算机存贮、管理和处理空间数据的逻辑结构，是地理实体的空间排列和相互关系的抽象描述，即地理实体的数据本身的组织方法。空间数据的结构类型分为栅格数据和矢量数据。
栅格数据是以二维矩阵的形式来表示空间地物或现象分布的数据组织方式，每个矩阵单元称为一个栅格单元(Cell)，栅格的每个数据表示地物或现象的属性数据，因此栅格数据有属性明显，定位隐含的特点。随着遥感技术的快速发展和广泛应用，以及数据压缩技术、计算机性能的提高，大规模栅格数据的显示已发展有较为成熟的金字塔分级显示方法。矢量数据是利用点，线，面的形式来表达现实世界，具有定位明显，属性隐含的特点。由于矢量数据具有数据结构紧凑，冗余度低，表达精度高，图形显示质量好，有利于网络和检索分析等优点，在WebGIS获得了广泛的应用。但是随着大数据时代的到来，高精度、广覆盖的矢量数据呈现爆炸式增长，如何有效存储和显示大规模矢量数据成为了迫切需要解决的难题。
对于大规模矢量数据的存储和显示，目前国际上采用较多且较为成熟的开源解决方案是通过整合OpenLayers和PostgreSQL的PostGIS插件来实现。OpenLayers是一个专为Web GIS客户端开发提供的JavaScript类库包，用于实现标准格式发布的地图数据访问。PostGIS是一个开源程序，它为对象－关系型数据库PostgreSQL提供了存储空间地理数据的支持，使PostgreSQL成为了一个空间数据库，能够进行空间数据管理、数量测量与几何拓扑分析。PostGIS实现了Open Geospatial Consortium所提出的基本要素类(点、线、面、多点、多线、多面等)的SQL实现参考。
但是在国内，相对而言，PostgreSQL数据库在市场上的普及度较低，若为支持矢量数据的存储和显示而特意在软件开发项目中新增PostgreSQL数据库，不仅提高了前期开发的成本，而且也加大了市场认可和接受的难度。因此，提出一种适应于当前国内主流数据库的大规模矢量数据存储和显示方法是十分必要的。
发明内容
本发明的目的在于提供一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统，以解决现有技术中存在的国内缺乏适应于当前国内主流数据库的大规模矢量数据的存储和显示方法的技术问题。
为实现上述目的，第一方面，本发明提供一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，包括：
基于MySQL5.7的geometry类型构建矢量数据存储数据库并存入矢量数据；
基于OpenLayers地图引擎发送的查询区域的查询请求，对矢量数据存储数据库做空间查询；
以及，
动态渲染通过Web服务自矢量数据存储数据库返回的所述查询区域的GeoJSON格式的矢量数据，并于浏览器显示。
通过实施上述技术方案，整合MySQL5.7提供的geometry类型和OpenLayers地图引擎实现矢量数据的存储和显示，MySQL数据库在国内普及度较高，为国内当前主流数据库，国内现有许多软件均是采用MySQL数据库，本发明提供的技术方案使得大规模矢量数据的展示方法可与现有的软件项目实现无缝集成，降低了前期开发难度和后期维护成本。
作为优选的，矢量数据存储数据库的空间字段添加有空间索引。
通过实施上述技术方案，提高了矢量数据存储数据库的检索速度。
作为优选的，所述查询区域为OpenLayers地图引擎的当前显示区域，且OpenLayers地图引擎当前显示区域发生变化时即发送所述查询区域的所述查询请求。
通过实施上述技术方案，OpenLayers地图引擎显示的矢量数据均为当前显示区域内的矢量数据，相比于显示地图所有矢量数据，具有缓冲量小，缓冲速度快，大大提升了地图的浏览体验。
作为优选的，矢量数据存储数据库的空间查询包括：
检索矢量数据存储数据库内满足所述查询区域的对象；
转换检索出的所述对象格式为GeoJSON格式并通过Web服务返回至OpenLayers地图引擎。
另一方面，本发明还提供一种基于MySQL5.7和OpenLayers的大规模矢量数据展示系统，包括：
矢量数据存储数据库：基于MySQL5.7的geometry类型构建以用于存储矢量数据，且基于接收到的查询请求做空间查询以输出GeoJSON格式的矢量数据；
OpenLayers地图引擎，通过Web服务向所述矢量数据存储数据库发送以当前显示区域为查询区域的查询请求，动态渲染自所述所述矢量数据存储数据库返回的矢量数据；以及，
浏览器，显示经OpenLayers地图引擎动态渲染后的矢量数据。
通过实施上述方案，整合MySQL5.7提供的geometry类型和OpenLayers地图引擎实现矢量数据的存储和显示，MySQL数据库在国内普及度较高，为国内当前主流数据库，国内现有许多软件均是采用MySQL数据库，本发明提供的技术方案使得大规模矢量数据的展示方法可与现有的软件项目实现无缝集成，降低了前期开发难度和后期维护成本。
本发明提供的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统的有益效果在于：
本发明涉及的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，包括：基于MySQL5.7的geometry类型构建矢量数据存储数据库并存入矢量数据；基于OpenLayers地图引擎发送的查询区域的查询请求，对矢量数据存储数据库做空间查询；以及，动态渲染通过Web服务自矢量数据存储数据库返回的所述查询区域的GeoJSON格式的矢量数据，并于浏览器显示。本发明提供的方案整合MySQL5.7提供的geometry类型和OpenLayers地图引擎实现矢量数据的存储和显示，MySQL数据库在国内普及度较高，为国内当前主流数据库，国内现有许多软件均是采用MySQL数据库，本发明提供的技术方案使得大规模矢量数据的展示方法可与现有的软件项目实现无缝集成，降低了前期开发难度和后期维护成本。
附图说明
为了更清楚地说明本发明实施例中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动性的前提下，还可以根据这些附图获得其他的附图。
图1为本发明实施例提供的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法实现的逻辑流程图。
具体实施方式
在下面的详细描述中，提出了许多具体细节，以便于对本发明的全面理解。但是，对于本领域技术人员来说很明显的是，本发明可以在不需要这些具体细节中的一些细节的情况下实施。下面对实施例的描述仅仅是为了通过示出本发明的示例来提供对本发明的更好地理解。
下面将结合附图，对本发明实施例的技术方案进行描述。
本发明涉及揭示一种基于MySQL5.7和OpenLayers的大规模矢量数据展示系统，包括：
矢量数据存储数据库：基于MySQL5.7的geometry类型构建以用于存储矢量数据，且基于接收到的查询请求做空间查询以输出GeoJSON格式的矢量数据；
OpenLayers地图引擎，通过Web服务向所述矢量数据存储数据库发送以当前显示区域为查询区域的查询请求，动态渲染自矢量数据存储数据库返回的矢量数据；以及，
浏览器，显示经OpenLayers地图引擎动态渲染后的矢量数据。
MySQL是一个关系型数据库管理系统，关系型数据库是将数据保存在不同的表中，相比于将数据都存储在一个大仓库中，具有速度快灵活性好的优点。同时因MySQL开放源码，体积小，速度快等特点，使其成为软件项目开发的优选采用的数据库之一，市场占有率高。MySQL5.7是2015年发布的MySQL版本，相比于MySQL5.6速度提高了3倍，并且同时提高了可用性，可管理性和安全性，增加了全新的GIS模块，提供了geometry类型。
如图1所示，基于MySQL5.7和OpenLayers的大规模矢量数据展示系统的大规模矢量数据展示方法包括：
基于MySQL5.7的geometry类型构建矢量数据存储数据库并存入矢量数据；
值得说明的是，该矢量数据存储数据库的空间字段添加了空间索引，这大大提高了矢量数据存储数据库的检索速度。
基于OpenLayers地图引擎发送的查询区域的查询请求，对矢量数据存储数据库做空间查询；
具体的，OpenLayers地图引擎与矢量数据存储数据库通过Web服务建立连接，OpenLayers地图引擎发送的查询区域为OpenLayers地图引擎的当前显示 区域，并且在OpenLayers地图引擎的当前显示区域发生变化时，如在浏览器上拖动鼠标时，OpenLayers地图引擎即通过Web服务向矢量数据存储数据库发送改变了的查询区域的查询请求。简单来说，OpenLayers地图引擎每次仅显示当前显示区域内的矢量数据，相比于一次性显示所有区域的矢量数据，具有数据量小，缓冲压力小，浏览体验度良好的优点。
具体的，矢量数据存储数据库接收到查询请求后，即进行空间查询，包括：检索矢量数据存储数据库内满足查询区域的对象；
转换检索出的对象格式为GeoJSON格式并通过Web服务返回至OpenLayers地图引擎。
在本发明至少一个实施例中，矢量数据存储数据库的空间查询语句为：
select*,concat(ST_AsGeoJON(geom,6),”)as gison from dltb where ST_Intersects(ST_Geom FromText(extent),geom)
动态渲染通过Web服务自矢量数据存储数据库返回的查询区域的GeoJSON格式的矢量数据，并于浏览器显示。
GeoJSON是一种对各种地理数据结构进行编码的格式，基于Javascript对象表示法的地理空间信息数据交换格式。
以上即实现了基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，该方法通过整合MySQL5.7的GIS模块和OpenLayers地图引擎实现了大规模矢量数据的快速显示，MySQL作为开源系统，对于WebGIS项目的开发，具有降低软件开发成本的优点，并且MySQL作为国内的主流数据库系统，也增强了WebGIS项目与现有软件项目的无缝集成，降低了软件开发难度。
以上实施例仅用以说明本发明的技术方案，而非对发明的保护范围进行限制。显然，所描述的实施例仅仅是本发明部分实施例，而不是全部实施例。基于这些实施例，本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例，都属于本发明所要保护的范围。尽管参照上述实施例对本发明 进行了详细的说明，本领域普通技术人员依然可以在不冲突的情况下，不作出创造性劳动对本发明各实施例中的特征根据情况相互组合、增删或作其他调整，从而得到不同的、本质未脱离本发明的构思的其他技术方案，这些技术方案也同样属于本发明所要保护的范围。
以上所述仅为本发明的较佳实施例而已，并不用以限制本发明，凡在本发明的精神和原则之内所作的任何修改、等同替换和改进等，均应包含在本发明的保护范围之内。

Claims (5)

  1. 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，其特征在于，包括：
    基于MySQL5.7的geometry类型构建矢量数据存储数据库并存入矢量数据；
    基于OpenLayers地图引擎发送的查询区域的查询请求，对矢量数据存储数据库做空间查询；
    以及，
    动态渲染通过Web服务自矢量数据存储数据库返回的所述查询区域的GeoJSON格式的矢量数据，并于浏览器显示。
  2. 如权利要求1所述的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，其特征在于，矢量数据存储数据库的空间字段添加有空间索引。
  3. 如权利要求2所述的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，其特征在于，所述查询区域为OpenLayers地图引擎的当前显示区域，且OpenLayers地图引擎当前显示区域发生变化时即发送所述查询区域的所述查询请求。
  4. 如权利要求3所述的一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法，其特征在于，矢量数据存储数据库的空间查询包括：
    检索矢量数据存储数据库内满足所述查询区域的对象；
    转换检索出的所述对象格式为GeoJSON格式并通过Web服务返回至OpenLayers地图引擎。
  5. 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示系统，其特征在于，包括：
    矢量数据存储数据库：基于MySQL5.7的geometry类型构建以用于存储矢量数据，且基于接收到的查询请求做空间查询以输出GeoJSON格式的矢量数据；
    OpenLayers地图引擎，通过Web服务向所述矢量数据存储数据库发送以当 前显示区域为查询区域的查询请求，动态渲染自所述所述矢量数据存储数据库返回的矢量数据；以及，
    浏览器，显示经OpenLayers地图引擎动态渲染后的矢量数据。
PCT/CN2019/098761 2019-03-12 2019-08-01 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统 WO2020181711A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201910184322.9 2019-03-12
CN201910184322.9A CN110032610A (zh) 2019-03-12 2019-03-12 一种大规模矢量数据展示方法及系统

Publications (1)

Publication Number Publication Date
WO2020181711A1 true WO2020181711A1 (zh) 2020-09-17

Family

ID=67235903

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2019/098761 WO2020181711A1 (zh) 2019-03-12 2019-08-01 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统

Country Status (2)

Country Link
CN (1) CN110032610A (zh)
WO (1) WO2020181711A1 (zh)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110032610A (zh) * 2019-03-12 2019-07-19 紫光云数科技有限公司 一种大规模矢量数据展示方法及系统
CN110990508B (zh) * 2019-11-26 2022-03-25 浙江省环境科技有限公司 基于gis项目信息管理方法、装置、设备以及存储介质
CN110990612B (zh) * 2019-12-13 2022-08-02 特力惠信息科技股份有限公司 一种矢量大数据快速显示的方法及终端
CN113254808B (zh) * 2021-06-02 2021-11-16 江苏豪杰测绘科技有限公司 一种gis数据筛选方法及系统
CN115114356B (zh) * 2022-06-28 2023-03-21 河北平普数政科技有限公司 一种基于矢量数据前端展示的实时脱密化方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110022294A1 (en) * 2009-07-27 2011-01-27 Peck Labs, Inc. Methods and systems for displaying customized icons
CN102882951A (zh) * 2012-09-17 2013-01-16 中安永恒（北京）工程技术有限公司 一种人员定位远程无线多级联网系统及方法
CN105447101A (zh) * 2015-11-12 2016-03-30 北京锐安科技有限公司 一种地图引擎实现方法及装置
CN110032610A (zh) * 2019-03-12 2019-07-19 紫光云数科技有限公司 一种大规模矢量数据展示方法及系统

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105005571B (zh) * 2014-04-23 2018-12-21 国家电网公司 支持智能用电信息可视化展示的方法及装置
CN108073683A (zh) * 2017-11-15 2018-05-25 北京工业大学 基于无人机监控的海域信息管理系统
CN109408612A (zh) * 2019-01-16 2019-03-01 紫光云数科技有限公司 一种基于动态图例的地图交互方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110022294A1 (en) * 2009-07-27 2011-01-27 Peck Labs, Inc. Methods and systems for displaying customized icons
CN102882951A (zh) * 2012-09-17 2013-01-16 中安永恒（北京）工程技术有限公司 一种人员定位远程无线多级联网系统及方法
CN105447101A (zh) * 2015-11-12 2016-03-30 北京锐安科技有限公司 一种地图引擎实现方法及装置
CN110032610A (zh) * 2019-03-12 2019-07-19 紫光云数科技有限公司 一种大规模矢量数据展示方法及系统

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
CHEN, HAO: "Design and Implementation of Four Lakes Region Land-using Information System", CHINESE MASTER’S THESES FULL-TEXT DATABASE, ELECTRONIC TECHNOLOGY & INFORMATION SCIENCE, no. 1, 31 January 2013 (2013-01-31), DOI: 20191107085808X *

Also Published As

Publication number Publication date
CN110032610A (zh) 2019-07-19

Similar Documents

Publication Publication Date Title
WO2020181711A1 (zh) 一种基于MySQL5.7和OpenLayers的大规模矢量数据展示方法及系统
Lv et al. BIM big data storage in WebVRGIS
Coors 3D-GIS in networking environments
CN103412863B (zh) 面向嵌入式设备的大容量矢量地图快速可视化实现方法
CN112115198A (zh) 一种城市遥感智能服务平台
CN108572951B (zh) 一种基于地理信息的制图数据三维显示系统
CN115238015A (zh) 一种基于微服务的时空大数据平台
CN114820975A (zh) 基于全要素参数符号化的三维场景仿真重构系统及方法
She et al. 3D building model simplification method considering both model mesh and building structure
Zhu et al. CyberCity GIS (CCGIS): integration of DEMs, images, and 3D models
Chen et al. The typhoon disaster analysis emergency response system based on UAV remote sensing technology
Zhang et al. Visualization of large spatial data in networking environments
Dou et al. Construction of smart community based on GIS and tilt photogrammetry
Goncalves et al. A spatial column-store to triangulate the Netherlands on the fly.
Wu et al. a Management of Remote Sensing Big Data Base on Standard Metadata File and Database Management System
Dorninger et al. Technical push on 3d data standards for cultural heritage management
Xu et al. GeoMapViz: a framework for distributed management and geospatial data visualization based on massive spatiotemporal data streams
Chen et al. A fast scheduling method for massive oblique photography 3D models
Zhang et al. Research of vector tile construction technology based on apache sedona
Abdalla et al. A unified approach for spatial data query
Ma et al. Research on the management and expression of disaster data
Sun et al. Research on the Application of Computer Virtual Reality Technology in Urban-Rural Integration of Rural Revitalization Strategy
Li et al. The Research and Implementation of Urban Pollution Sources Information Management System Based on ArcGIS Server Web ADF
Zhu et al. A Spatial Information Platform for Urban and Rural Planning based on One Map
Zhang et al. A Spatial Database Management System for Urban and Rural Planning

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 19918897

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 19918897

Country of ref document: EP

Kind code of ref document: A1