Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Method and system for accessing different spatial databases

A database and spatial technology, applied in the field of geographic information systems, can solve problems such as different interfaces, and achieve the effect of easy learning, low learning cost, and reduced development workload

Active Publication Date: 2018-01-12
DUOLUN TECH CO LTD
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to overcome the deficiencies in the prior art, the present invention provides a method and system for accessing different spatial databases to solve the problem that the interfaces for each spatial database in the prior art are different, and other developers need to target different spatial databases before using them. The problem of adapting the spatial database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for accessing different spatial databases
  • Method and system for accessing different spatial databases
  • Method and system for accessing different spatial databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0053] Embodiment 1: A method for accessing the PostGIS spatial database and performing spatial query is provided. The specific process is as follows:

[0054] 11) Understand the syntax and spatial functions of the PostGIS spatial database; among them, the primary key number of the layer stored in the PostGIS spatial database is gid, and the spatial field is geom;

[0055] 12) Obtain the IP address, port number, instance name, user name, and password of the PostGIS spatial database and save them in the configuration file corresponding to the PostGIS spatial database established in the data layer;

[0056] 13) Obtain the geographic coordinate system or projected coordinate system of the spatial data of the PostGIS spatial database, and save it to the configuration file corresponding to the PostGIS spatial database established in the data layer;

[0057] 14) According to the type of spatial database, read the configuration file corresponding to the parameters of the PostGIS spatial datab...

Embodiment 2

[0075] Embodiment 2: A method for accessing the SpatiaLite spatial database and performing surrounding queries is provided. The specific process is as follows:

[0076] 21) Understand the syntax and spatial functions of the SpatiaLite spatial database; among them, the layer primary key number stored in the Spatialite spatial database is pk_uid, and the spatial field is geometry;

[0077] 22) Get the storage path of the SpatiaLate spatial database and save it in the configuration file;

[0078] 23) Obtain the geographic coordinate system or projected coordinate system of the spatial data of the SpatiaLate spatial database and save it to the configuration file;

[0079] 24) According to the spatial database type, read the configuration file corresponding to the SpatiaLate spatial database parameters, and connect to the SpatiaLate spatial database;

[0080] 25) When the business system calls the vector data service, input the database type, query type, layer name, query field, filter condi...

Embodiment 3

[0097] Embodiment 3: A method for accessing WFS service and performing attribute query is provided. The specific process is as follows:

[0098] 31) Understand the WFS service definition specification; the specific definition is WFS refers to a Web element service. Web element service (WFS) returns element-level GML codes and provides transaction operations such as addition, modification, and deletion of elements. Further development of Web map service; OGC Web feature service allows clients to obtain geospatial data encoded with Geographic Markup Language (GML) from multiple web feature services. This Far East defines five operations: GetCapabilites returns the performance description of the web feature service Document (described in XML); DescribeFeatureType returns an XML document describing the structure of any feature that can provide services; GetFeature provides services for a request to obtain a feature instance; Transaction provides services for transaction requests; Lock...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention discloses a method and a system for accessing different spatial databases. The method comprises: obtaining parameters of different spatial databases; establishing corresponding configuration files according to types of the spatial databases so as to store obtained parameters of the spatial databases; receiving parameters introduced by a service system requiring for calling avector data service; according to the parameter information introduced by the service system, extracting relevant parameters in the corresponding configuration file and calling the corresponding spatial database syntax and spatial functions to query result information; and converting the result information to standard format data to output to the service system. According to the method and systemdisclosed by the present invention, the problems in the prior art that the interface for each spatial database is different and the other developers need to adapt to different spatial databases beforeusing are solved.

Description

Technical field [0001] The invention relates to a method and system for accessing different spatial databases, belonging to the technical field of geographic information systems. Background technique [0002] Geographic Information System (GIS, Geographic Information System) is a computer-based tool that can map and analyze things and events that occur on the earth. GIS technology integrates the unique visual effects of maps and geographic analysis functions with general database operations (such as query and statistical analysis). This ability distinguishes GIS from other information systems, and makes it practical in explaining events, predicting results, and planning strategies among a wide range of public and individual enterprises and institutions. [0003] With the development of geographic information technology, geographic information systems (GIS) have played an increasingly important role. Therefore, a variety of GIS-based spatial databases have emerged. At present, many...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 张辉刘兵向新胜林宝华
Owner DUOLUN TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com