Recherche Images Maps Play YouTube Actualités Gmail Drive Plus »
Connexion
Les utilisateurs de lecteurs d'écran peuvent cliquer sur ce lien pour activer le mode d'accessibilité. Celui-ci propose les mêmes fonctionnalités principales, mais il est optimisé pour votre lecteur d'écran.

Brevets

  1. Recherche avancée dans les brevets
Numéro de publicationCN102402526 A
Type de publicationDemande
Numéro de demandeCN 201010280967
Date de publication4 avr. 2012
Date de dépôt13 sept. 2010
Date de priorité13 sept. 2010
Numéro de publication201010280967.1, CN 102402526 A, CN 102402526A, CN 201010280967, CN-A-102402526, CN102402526 A, CN102402526A, CN201010280967, CN201010280967.1
Inventeurs李强, 李欣, 毛定山, 王生
Déposant方正国际软件(北京)有限公司, 方正国际软件有限公司
Exporter la citationBiBTeX, EndNote, RefMan
Liens externes:  SIPO, Espacenet
Geographic information database management method and system
CN 102402526 A
Résumé
The invention discloses a geographic information data management method and a geographic information data management system. The geographic information data management system comprises spatial databases, geographic information system (GIS) platforms and driving devices, wherein the spatial databases are used for storing geographic information data of different GIS platforms; the GIS platforms are used for storing the geographic information data in the spatial databases or acquiring the geographic information data from the spatial databases; and the driving devices are arranged between the different GIS platforms and the spatial databases and used for receiving the geographic information data of the GIS platforms, performing format conversion and sending the geographic information data subjected to format conversion to the spatial databases, or acquiring the required geographic information data of the GIS platforms from the spatial databases, performing format conversion to obtain formats corresponding to the GIS platforms and forwarding the geographic information data subjected to format conversion to the GIS platforms. By the geographic information data management method and the geographic information data management system, the spatial databases in the different GIS platforms are subjected to unified and standardized management and are prevented from being repeatedly developed or maintained, the construction cost of the GIS platforms is reduced, and work efficiency is improved.
Revendications(10)  Langue du texte original : Chinois
1. 一种地理信息数据管理系统,其特征在于,包括: 空间数据库,用于存储不同GIS平台的地理信息数据;GIS平台,用于向所述空间数据库存储或获取地理信息数据;驱动装置,设于不同的GIS平台与空间数据库之间,用于接收所述GIS平台的地理信息数据,进行格式转换后发送到所述空间数据库;或从所述空间数据库获取GIS平台所需的地理信息数据,将其格式转换为所述GIS平台对应的格式后转发至所述GIS平台。 A geographical information management system comprising: spatial database for geographic information data stored in different GIS platforms; GIS platform for database storage to the space or obtain GIS data; driving means Send disposed between different GIS platforms and spatial database platform for receiving the GIS geographic information data format converted to the spatial database; or geographic information database to obtain the required data from the GIS platform space forwarded to the GIS platform, convert its format to a format corresponding to the GIS platform.
2.根据权利要求1所述的地理信息数据管理系统,其特征在于,还包括:插件接口,用于支持对用空间数据库的应用需求;所述插件接口包括:查询插件信息接口,具有自描述能力,通过查询插件的接口,可获得插件的名称、用途描述、环境依赖需求、行为方式信息;初始化接口,对于外界传入空间数据库连接对象及错误记录对象进行初始化; 显示界面接口,用于设置用户信息; 释放资源接口,用于在操作完成后释放内部资源。 The GIS data management system according to claim 1, characterized in that it further comprises: plug-in interface to support application requirements for use spatial database; the plug-in interface comprising: Query plug-in interfaces, self-description ability, through the interface query widget name available widget Descriptions, dependent on demand environment, behavior information; initialization interface for external incoming spatial database connection object and initialize the object error log; display interface interface for setting user information; the interface to release resources for the operation is completed to release internal resources.
3.根据权利要求1所述的地理信息数据管理系统,其特征在于, 所述驱动装置包括:连接接口:用于空间数据库的连接的分配、创建、释放; 和/或事务接口:用于空间数据库的事务启动、提交、以及回滚; 和/或空间参考系接口:用于空间参考系的枚举、创建;和/或表结构维护接口:属性表以及空间表的创建、删除、更新、表结构的查询、索引的维护;和/或记录操作接口:用于对记录的增加、删除、修改、查询的操作,特别注意查询提供按照空间范围查询的功能;和/或枚举表接口:枚举空间数据库中的属性表、图层、以及栅格图像; 和/或锁定接口:锁定对属性表、图层对象的读写操作。 3. The GIS data management system according to claim 1, wherein said drive means comprises: a connection interface: used to allocate space for a database connection, create, release; and / or Transaction Interface: For space transaction database to start, commit, and rollback; and / or spatial reference system interfaces: spatial reference system used to enumerate, create; and / or table structure maintenance interface: table and create a spatial table's properties, delete, update, table structure queries, index maintenance; and / or recording operator interface: Used to increase the record, delete, modify, query operations, with special attention queries according to spatial range query functions; and / or enumeration of interfaces: enumerate space database property sheet, layers, and raster images; and / or lock the connector: the lock on the property sheet, write the layer objects.
4.根据权利要求1所述的地理信息数据管理系统,其特征在于,还包括:日志记录装置,用于记录系统操作日志;所述日志包括:操作用户、详细描述信息、客户端操作的IP地址、客户主机名称、客户端Mac地址以及客户操作时间。 Geographic information according to claim 1, wherein the data management system, characterized by further comprising: logging means for recording system operation log; the log includes: operation of the user, a detailed description of IP information, client operations address, client host name, address and customer client Mac operating time.
5.根据权利要求1至4中任意一项所述的地理信息数据管理系统,其特征在于,还包括:升级装置,用于检测系统版本,当系统版本与预存的更新配置文件中的版本不一致时, 对系统进行升级。 5. according to any one of claims 1 to 4, GIS data management system according to claim, characterized by further comprising: upgrade means for detecting system version, when the system version update profiles stored in the inconsistent version when the system is upgraded.
6. 一种地理信息数据管理方法,其特征在于,包括: 对接收到的地理信息数据进行格式转换;将转换后的地理信息数据发送到空间数据库或GIS平台。 A geographic information data management method comprising: docking GIS data received format conversion; send geographic data converted to a spatial database or GIS platform.
7.根据权利要求6所述的地理信息数据管理方法,其特征在于,接收到GIS平台的地理信息数据后,确定图层代码的分段格式,按照预设的层次定义, 将所述代码转换为相应的格式。 7. GIS data management method according to claim 6, characterized in that, after receiving the GIS data GIS platforms, to determine the layer format code segment, defined according to a preset level, the transcoding to the appropriate format.
8.根据权利要求7所述的地理信息数据管理方法,其特征在于,为所述地理信息数据建立以下图层信息:图层中文名称、显示名称或英文名称、类型、描述、显示顺序、字段排序、复合主键、过滤条件、字段结构。 8. GIS data management method according to claim 7, characterized in that the following information and data to establish the geographic information layers: Layer Chinese name, display name or English name, type, description, display order field Sort, composite primary key, filters, field structure.
9.根据权利要求8所述的地理信息数据管理方法,其特征在于,按照预设的专题标准提取所述图层后,形成专题图层存储到所述空间数据库中。 9. GIS data management method according to claim 8, wherein after extracting the layers according to a preset standard themes, thematic layers form stored in the spatial database.
10.根据权利要求6至9中任意一项所述的地理信息数据管理方法,其特征在于,还包括:记录系统操作日志。 10. GIS data management method 6-9 according to any one of the preceding claims, characterized in that, further comprising: operation log recording system.
Description  Langue du texte original : Chinois

一种地理信息数据库管理方法及系统 A geographic-information database management method and system

技术领域 Technical Field

[0001] 本发明涉及一种数据库技术,尤其涉及一种地理信息数据库管理方法及系统。 [0001] The present invention relates to a database technology, particularly to a GIS database management method and system. 背景技术 Background

[0002] 空间数据库是地理信息系统在计算机物理存储介质上存储的、与应用相关的地理空间数据的总和,一般是以一系列特定结构的文件的形式组织在存储介质之上的。 [0002] is a geographic information system database space on the computer's physical storage medium, the sum related to the application of geospatial data, typically in the form of a series of specific organizational structure of the file on the storage medium. 空间数据库的研究始于20世纪70年代的地图制图与遥感图像处理领域,其目的是为了有效地利用卫星遥感资源迅速绘制出各种经济专题地图。 Spatial database began cartographic fields of remote sensing image processing in the 1970s with the aim of efficient use of satellite remote sensing to quickly map out the various economic resources thematic map. 由于传统的关系数据库在空间数据的表示、存储、管理、检索上存在许多缺陷,从而形成了空间数据库这一数据库研究领域。 Due to traditional relational database has many limitations in spatial data representation, storage, management, retrieval, thereby forming a spatial database This database research. 而传统数据库系统只针对简单对象,无法有效的支持复杂对象(如图形、图像)。 The traditional database systems only for simple objects, can not effectively support complex objects (such as graphics, images).

[0003] 现在有很多GIS平台提供了空间数据建库管理功能,这些建库软件通常基于各厂家自己的GIS平台,其特点是: [0003] There are many GIS platform provides Spatial Data management functions, which are usually based on building a database software manufacturers own GIS platform, which is characterized by:

[0004] 1、绑定GIS平台:每一种建库工具基于厂家自己的GIS平台,如通常基于ArcGIS 平台,Oracle Spatial平台,或者国内一些GIS厂家的平台。 [0004] 1, bound GIS platform: building a database for each tool based on their own GIS platform, as is usually based on ArcGIS platform, Oracle Spatial platform, or some domestic manufacturers of GIS platform.

[0005] 2、存储形式固化:受到平台的限定,空间数据的存储形式通常固定不变 [0005] 2, the storage form of curing: by defining platform, storage space in the form of data is usually fixed

[0006] 3、功能设计松散,流程性体现不强,并且一般建库工具设计没有明确的针对性。 [0006] 3, functional design loose, processes embodied not strong, and generally building a database tool designed not explicitly targeted.

[0007] 现有的建库工具通常将精力集中在数据入库、查询、检索、输出、更新、分发、管理等功能上,而对建库之前的规范形成过程考虑及支持较少。 [0007] building a database of existing tools usually focus on data storage, query, retrieval, output, update, distribution, management and other functions, and specifications for the construction of the library before the formation of less consideration and support.

[0008] 随着海量地理信息数据的不断扩充以及空间数据库建设需求的日益增加,需要形成一定的数据建库标准和流程机制,以规范化空间数据库的存储和管理。 [0008] With the massive expansion of geographic information data and increasing spatial database building needs, it needs a certain data standards and processes mechanisms for building a database to store and manage standardized spatial database. 而现有的各种GIS 平台在数据库建设过程中,没有完全符合警用地理信息数据库建设标准,数据库管理机制未能实现统一,以致对平台应用产生制约。 The various existing GIS database platform in the construction process, the police did not fully comply with the standards of geographic information database construction, database management system failed to achieve unity, so that the generation of platform application constraints.

[0009] 现有的各种GIS平台在数据库建设过程中主要存在以下缺点: [0009] The various existing GIS platform in the process of building a database exists mainly in the following disadvantages:

[0010] 1、依赖特定的GIS平台:现有的建库工具通常只支持各自厂家自己的GIS平台,而警用系统应用环境复杂多样,不可能局限在单一的GIS平台。 [0010] 1, rely on specific GIS platform: building a database of existing tools usually support only their own GIS platform manufacturers, and police complex and diverse system environments, it can not be confined to a single GIS platform.

[0011] 2、空间数据存储形式单一、固定:警用系统的GIS数据保存形式多种多样,既有数据库形式的也有文件形式的,空间数据库类型既有国外厂商也有国内厂商,因此需要一个适应性很强的建库工具管理其数据。 [0011] 2, the spatial data in the form of a single, fixed: GIS data is stored in the form of a variety of police systems, both in the form of a database file is also in the form of foreign manufacturers of both types of spatial databases are also domestic manufacturers, requiring an adaptation highly building a database tool to manage their data.

[0012] 3、缺乏针对性:在图层标准、数据组织、管理等方面警用系统都具有自己的特点, 现有的空间数据建库软件难以完全适应其应用环境,导致在日常工作中难以发挥作用,无法为上层应用系统的开发提供支撑。 [0012] 3, the lack of targeted: in the layer standards, data organization, management and other aspects of police system has its own characteristics, the existing Spatial Data software is difficult to fully adapt to their environments, leading to difficulty in their daily work play a role, can not provide support for the development of upper layer application system.

[0013] 4、缺乏对标准的支持:现有的建库工具在数据入库之前的标准管理方面缺乏一套完整的支撑,导致其往往关注于数据本身的加载、管理。 [0013] 4, the lack of support for standards: building a database of existing lack of a complete set of tools to support the management of data storage in the standard before, resulting tend to focus on the data itself load management. 而在警用环境下数据来源复杂多样,如果缺乏一套标准化体系的支持,难以满足未来的各种应用需求。 While in the police complex and diverse environmental data sources, if the lack of a standardized system of support, it is difficult to meet the future needs of a variety of applications.

[0014] 以上这些缺点导致这些建库软件无法完全适用于警用地理信息数据库建设要求, 数据库管理机制未能实现统一,以致对警用平台基础之上的各种应用开发产生制约。 [0014] These shortcomings lead to those building a database software is not fully applicable to the police geographic information database construction requirements, database management system failed to achieve unity, so that the constraints on the police to produce a variety of application development platform foundation. 发明内容 DISCLOSURE

[0015] 本发明的目的在于,提供一种地理信息数据库管理方法及系统,降低了地理信息平台的建设成本,提高了工作效率。 Objective [0015] The present invention is to provide a GIS database management methods and systems to reduce the construction cost geographic information platform, improve work efficiency.

[0016] 为实现上述目的,根据本发明的一个方面,提供一种地理信息数据管理方法,包括: [0016] To achieve the above object, according to one aspect of the present invention, there is provided a GIS data management method, comprising:

[0017] 对接收到的地理信息数据进行格式转换; GIS data [0017] received format conversion;

[0018] 将转换后的地理信息数据发送到空间数据库或GIS平台。 [0018] to send the geographical information data converted to a spatial database or GIS platform.

[0019] 在接收到GIS平台的地理信息数据后,确定图层代码的分段格式,按照预设的层次定义,将所述代码转换为相应的格式。 [0019] After receiving the GIS data GIS platform layer code segment format determined in accordance with pre-defined level, the code is converted to the appropriate format.

[0020] 为所述地理信息数据建立以下图层信息:图层中文名称、显示名称或英文名称、类型、描述、显示顺序、字段排序、复合主键、过滤条件、字段结构。 [0020] To establish the following information to the GIS layer data: Layer Chinese name, display name or English name, type, description, display order, sort fields, composite primary keys, filters, field structure.

[0021] 按照预设的专题标准提取所述图层后,形成专题图层存储到所述空间数据库中。 After the [0021] according to a preset topic standardized extract of the layers to form a thematic layer to the storage space in the database.

[0022] 该方法还包括:记录系统操作日志。 [0022] The method further comprising: recording system operation logs.

[0023] 为实现上述目的,根据本发明的另一个方面,提供一种地理信息数据管理系统,包括: [0023] To achieve the above object, according to another aspect of the present invention, there is provided a GIS data management system, comprising:

[0024] 空间数据库,用于存储不同GIS平台的地理信息数据; [0024] The spatial database for geographic information data stored in different GIS platforms;

[0025] GIS平台,用于向所述空间数据库存储或获取地理信息数据; [0025] GIS platform used to obtain GIS data to the database storage or space;

[0026] 驱动装置,设于不同的GIS平台与空间数据库之间,用于接收所述GIS平台的地理信息数据,进行格式转换后发送到所述空间数据库;或从所述空间数据库获取GIS平台所需的地理信息数据,将其格式转换为所述GIS平台对应的格式后转发至所述GIS平台。 Send [0026] drive means provided between the different GIS platforms and spatial database for geographic information data receiving the GIS platform format converted to the spatial database; GIS platform or database to obtain from the space After forwarded to the GIS platform GIS data required to convert its format to a format corresponding to the GIS platform.

[0027] 该系统还包括:插件接口,用于支持对用空间数据库的应用需求; [0027] The system further comprising: a plug-in interface to support application requirements for use spatial database;

[0028] 所述插件接口包括:查询插件信息接口,具有自描述能力,通过查询插件的接口, 可获得插件的名称、用途描述、环境依赖需求、行为方式信息; [0028] The plug-in interface comprising: Query plug-in interfaces, the ability to self-describing, via the interface query widget name available widget Descriptions, dependent on demand environment, behavior information;

[0029] 初始化接口,对于外界传入空间数据库连接对象及错误记录对象进行初始化; [0029] The initialization interface for external incoming spatial database connection object and initialize the object error log;

[0030] 显示界面接口,用于设置用户信息; [0030] The display screen interface for setting user information;

[0031 ] 释放资源接口,用于在操作完成后释放内部资源。 [0031] interface to release resources for releasing internal resources after the operation is completed.

[0032] 其中,所述驱动装置包括: [0032] wherein said drive means comprises:

[0033] 连接接口:用于空间数据库的连接的分配、创建、释放; [0033] connections: for allocating space for the database connection, create, release;

[0034] 和/或事务接口:用于空间数据库的事务启动、提交、以及回滚; [0034] and / or Transaction Interface: Transaction for spatial database start, commit, and rollback;

[0035] 和/或空间参考系接口:用于空间参考系的枚举、创建; [0035] and / or spatial reference system interfaces: spatial reference system used to enumerate, create;

[0036] 和/或表结构维护接口:属性表以及空间表的创建、删除、更新、表结构的查询、索引的维护; [0036] and / or table structure maintenance interface: the attribute table and create a spatial table, delete, update, query the table structure, index maintenance;

[0037] 和/或记录操作接口:用于对记录的增加、删除、修改、查询的操作,特别注意查询提供按照空间范围查询的功能; [0037] and / or recording operator interface: Used to increase the record, delete, modify, query operations, with special attention queries according to spatial range query functions;

[0038] 和/或枚举表接口:枚举空间数据库中的属性表、图层、以及栅格图像; [0038] and / or enumeration of interfaces: enumeration attribute table space in the database, layers, and raster images;

[0039] 和/或锁定接口:锁定对属性表、图层对象的读写操作。 [0039] and / or lock the connector: the lock on the property sheet layer objects read and write operations.

[0040] 该系统还包括:日志记录装置,用于记录系统操作日志; [0040] The system further comprises: a log recording means for recording system operation logs;

[0041] 所述日志包括:操作用户、详细描述信息、客户端操作的IP地址、客户主机名称、客户端Mac地址以及客户操作时间。 [0041] The log includes: operation of the user, IP address, client operations, client host name, address and customer client Mac operating time described in detail.

[0042] 该系统还包括:升级装置,用于检测系统版本,当系统版本与预存的更新配置文件中的版本不一致时,对系统进行升级。 [0042] The system also includes: upgrade means for detecting system version, when the system version update stored in the configuration file versions are different, the system is upgraded.

[0043] 本发明的地理信息数据管理方法及系统,对不同GIS平台空间数据库的统一规范化管理,避免了不同GIS平台下空间数据库的重复开发和维护,降低了地理信息平台的建设成本,提高了工作效率。 [0043] The present invention geographic information data management method and system, different GIS platform for unified standardized spatial database management, to avoid duplication of development and maintenance of different GIS spatial database platform, reducing the construction cost geographic information platform, to improve the work efficiency. 为上层的应用系统开发提供了良好的支撑,为空间数据库的不断维护升级带来了很大的便利。 For the upper application development provides a good support, it has brought great convenience to the continued maintenance and upgrade spatial database.

[0044] 另外,本发明建立一套可扩充的标准体系,针对地理信息数据的具体情况,定义一套具有良好扩充性的代码规范及图层标准,以保证未来能够将更多数据纳入到数据体系中。 [0044] In addition, the present invention can be expanded to establish a standard system, the specific situation of GIS data, the definition of a good code extensibility layer specification and standards to ensure the future be able to incorporate more data into the data system. 通过标准管理相关功能的设计为上层应用系统开发提供了极大的方便性和可扩展性, 具有很强的配置能力。 Management-related functions through a standard designed to provide application development for the upper great convenience and scalability, with strong configuration capabilities. 实现从标准建立、数据入库、质量检查、数据接边、数据提取到数据发布的完整流程,满足系统对数据共享和交换的需求。 From a standard is established, data storage, quality inspection, data access side, data extraction to the data released by the complete processes to meet the needs of the system for data sharing and exchange.

附图说明 [0045] 图 1是本发明地理信息数据管理系统实施例的结构图;[0046] 图 2是本发明地理信息数据管理系统中驱动装置接口的示意图[0047] 图 3是本发明实施例中代码规范的示意图;[0048] 图 4是本发明实施例中代码定义的示意图;[0049] 图 5是本发明实施例中对图层定义的示意图;[0050] 图 6是本发明实施例中专题与图层对应的示意图;[0051] 图 7是本发明实施例中专题定义的示意图;[0052] 图 8是本发明实施例中样式配置库的示意图;[0053] 图 9是本发明实施例中日志信息显示及查询的示意图;[0054] 图 10是本发明实施例中空间数据库升级的流程图;[0055] 图 11是本发明地理信息数据管理方法实施例的流程图;[0056] 图 12是本发明地理信息数据管理方法另一实施例的流程图。 BRIEF DESCRIPTION [0045] FIG. 1, the present invention GIS data management system configuration diagram of an embodiment; [0046] FIG. 2 is a schematic diagram of the present invention GIS data management system interface drives [0047] FIG. 3 is a embodiment of the present invention Codes of schematic diagrams; [0048] FIG. 4 is a schematic view of the code defines the embodiment of the present invention; [0049] FIG. 5 is a schematic diagram of the embodiment of the present invention as defined layers; [0050] FIG. 6 is a embodiment of the present invention Examples thematic layers corresponding with the schematic; [0051] FIG. 7 is a schematic diagram of the embodiment of the present invention is defined topics; [0052] FIG. 8 is a schematic embodiment of the present invention, the configuration repository style; [0053] FIG. 9 is present embodiments of the invention in a schematic view the log information display and query; [0054] FIG. 10 is a flowchart illustrating a spatial database upgrade embodiment of the present invention; [0055] FIG. 11 is a flowchart of GIS data management method of the present invention; [ 0056] FIG. 12 is a GIS data management method of the present invention, a flow chart of another embodiment.

具体实施方式 DETAILED DESCRIPTION

[0057] 以下结合附图对本发明进行详细说明。 [0057] DRAWINGS The present invention will be described in detail.

[0058] 如图1所示,本发明地理信息数据管理系统实施例包括: [0058] As shown in Figure 1, the present invention GIS data management system embodiment includes:

[0059] 空间数据库,用于存储不同GIS平台的地理信息数据; [0059] spatial database for geographic information data stored in different GIS platforms;

[0060] GIS平台,用于向所述空间数据库存储或获取地理信息数据,例如AuperMap、 MapGis, ArcSDE 及OracleSptial 平台等等; [0060] GIS platform for the spatial database to store or retrieve geographic information data, such as AuperMap, MapGis, ArcSDE and OracleSptial platform and so on;

[0061] 驱动装置,设于不同的GIS平台与空间数据库之间,用于接收所述GIS平台的地理信息数据,进行格式转换后发送到所述空间数据库;或从所述空间数据库获取GIS平台所需的地理信息数据,将其格式转换为所述GIS平台对应的格式后转发至所述GIS平台,例如针对上述GIS平台的SuperMap驱动、MapGis驱动、ArcSDE驱动及OracleSptial驱动。 Send [0061] drive means provided between the different GIS platforms and spatial database for geographic information data receiving the GIS platform format converted to the spatial database; GIS platform or database to obtain from the space After forwarding GIS data required to convert the format of the GIS platform format corresponding to the GIS platform, for example for the above SuperMap GIS platform drive, MapGis drive, ArcSDE drive and OracleSptial drive.

[0062] 驱动装置包括多个接口,如图2所示下面对每一个类别的主要接口给出其简要描述(idl形式):[0063] ■连接接口:用于空间数据库的连接的分配、创建、释放。 [0062] The drive means comprises a plurality of interfaces, as shown in Figure 2 below for the primary interface for each category is given a summary description (idl form): [0063] ■ connections: allocate space for the database connection, create, release.

[0064] //方法:建立一个连接资源,但是不真正连接 [0064] @ method: Establish a connection resource, but does not actually connect

[0065] HRESULT CreateConnection(Iong^DBCnn); [0065] HRESULT CreateConnection (Iong ^ DBCnn);

[0066] //方法:设置连接属性 [0066] //: Set the connection properties

[0067] // 参数: [0067] // parameters:

[0068] //name :属性名称 [0068] // name: attribute name

[0069] //value :属性值 [0069] // value: Property Value

[0070] HRESULT SetConnectionProperty(long DBCnn,BSTR name, BSTR value); [0070] HRESULT SetConnectionProperty (long DBCnn, BSTR name, BSTR value);

[0071] //方法:建立连接 [0071] @ method: to establish a connection

[0072] HRESULT Connect(long DBCnn); [0072] HRESULT Connect (long DBCnn);

[0073] //方法:断开连接 [0073] @ method: Disconnect

[0074] HRESULT Disconnect (long DBCnn); [0074] HRESULT Disconnect (long DBCnn);

[0075] ■事务接口:用于空间数据库的事务启动、提交、以及回滚。 [0075] ■ Transaction Interface: spatial database for the transaction to start, commit, and rollback.

[0076] //方法:开始事务 [0076] @ method: Start Services

[0077] HRESULT BeginTransaction(long DBCnn); [0077] HRESULT BeginTransaction (long DBCnn);

[0078] //方法:结束事务(Commit or Rollback) [0078] @ method: End Transaction (Commit or Rollback)

[0079] HRESULT EndTransaction(long DBCnn,VARIANT_B00L Commit); [0079] HRESULT EndTransaction (long DBCnn, VARIANT_B00L Commit);

[0080] ■空间参考系接口:用于空间参考系的枚举、创建等功能。 [0080] ■ Spatial Reference System Interface: spatial reference system used to enumerate, create, and other functions.

[0081] H方法:枚举database中所有coordref信息 [0081] H method: enumerate all coordref information database

[0082] HRESULT EnumCoordReference(long DBCnn, ICoordReflnfoArra声ppCoordRefA rray); [0082] HRESULT EnumCoordReference (long DBCnn, ICoordReflnfoArra sound ppCoordRefA rray);

[0083] Il方法:增加一个新的coordref [0083] Il methods: add a new coordref

[0084] HRESULT AddCoordReference (long DBCnn, ICoordRef Info^pInfo); [0084] HRESULT AddCoordReference (long DBCnn, ICoordRef Info ^ pInfo);

[0085] H方法:获取图层参考系ID [0085] H method: Get Layers of reference ID

[0086] HRESULT GetLayerCoordRef(long DBCnn,BSTR tabIeName,long*SRID); [0086] HRESULT GetLayerCoordRef (long DBCnn, BSTR tabIeName, long * SRID);

[0087] H方法:通过参考系ID查询详细信息 [0087] H method: Query detailed information reference system ID

[0088] HRESULT GetCoordRefInfo(long DBCnn, long SRID, ICoordRefInfo**ppInfo); [0088] HRESULT GetCoordRefInfo (long DBCnn, long SRID, ICoordRefInfo ** ppInfo);

[0089] ■表结构维护接口:属性表以及空间表的创建、删除、更新、表结构的 [0089] ■ table structure maintenance interface: table and create a spatial table's properties, delete, update, table structure

[0090] 查询、索引的维护等等。 [0090] query, index maintenance, and so on.

[0091] //方法:获取数据表的ObjectID字段(唯一字段) [0091] @ method: a data sheet of the ObjectID field (the only field)

[0092] HRESULT GetOIDField(long DBCnn,BSTR tabIeName, BSTR^OIDField); [0092] HRESULT GetOIDField (long DBCnn, BSTR tabIeName, BSTR ^ OIDField);

[0093] //方法:获取表结构 [0093] @ method: Get Table Structure

[0094] HRESULT GetTableFields(long DBCnn,BSTR tabIeName, IFields**pFields); [0094] HRESULT GetTableFields (long DBCnn, BSTR tabIeName, IFields ** pFields);

[0095] //方法:建立普通Tab 1 e [0095] // Methods: Normal Tab 1 e

[0096] HRESULT CreateTable(long DBCnn, BSTR tableName, IFields^pFields); [0096] HRESULT CreateTable (long DBCnn, BSTR tableName, IFields ^ pFields);

[0097] H方法:删除普通属性表(或者图层) [0097] H: Remove common attribute table (or layers)

[0098] HRESULT DeleteTable(long DBCnn,BSTR tableName); [0098] HRESULT DeleteTable (long DBCnn, BSTR tableName);

[0099] H方法:从普通属性表升级为图层 [0099] H method: upgrade from ordinary property sheet layers

[0100] HRESULT CreateLayer(long DBCnn, BSTR tableName, BSTR shapeField,EnumDBLayerType type,double GridSize, ICoordRefInfo^pSrid, long AllocCount); [0100] HRESULT CreateLayer (long DBCnn, BSTR tableName, BSTR shapeField, EnumDBLayerType type, double GridSize, ICoordRefInfo ^ pSrid, long AllocCount);

[0101] Il方法:删除普通属性表(或者图层) [0101] Il: Remove common attribute table (or layers)

[0102] HRESULT DeleteLayer(long DBCnn,BSTR tabIeName); [0102] HRESULT DeleteLayer (long DBCnn, BSTR tabIeName);

[0103] //方法:获取图层范围 [0103] @ method: Get Layers range

[0104] HRESULT GetLayerExtent (long DBCnn,BSTR tabIeName, IRect#pRect); [0104] HRESULT GetLayerExtent (long DBCnn, BSTR tabIeName, IRect # pRect);

[0105] //方法:设置图层范围 [0105] @ method: Set the layer range

[0106] HRESULT SetLayerExtent(long DBCnn,BSTR tabIeName,IRect*pRect); [0106] HRESULT SetLayerExtent (long DBCnn, BSTR tabIeName, IRect * pRect);

[0107] //方法:返回图层类型(点,线,面) [0107] @ method: Returns layer types (points, lines, polygons)

[0108] HRESULT GetLayerType (long DBCnn, BSTR tableName, EnumDBLayerType氺氺Type); [0108] HRESULT GetLayerType (long DBCnn, BSTR tableName, EnumDBLayerType Shui Shui Type);

[0109] //方法:增加字段 [0109] @: Increase the field

[0110] HRESULT AddField(long DBCnn, BSTR TableName, IField*pField); [0110] HRESULT AddField (long DBCnn, BSTR TableName, IField * pField);

[0111] //方法:删除字段 [0111] @: Remove field

[0112] HRESULT DeleteField(long DBCnn, BSTR TableName, BSTR FieldName); [0112] HRESULT DeleteField (long DBCnn, BSTR TableName, BSTR FieldName);

[0113] //方法:更改表名 [0113] @: Change the table name

[0114] HRESULT RenameTable(long DBCnn, BSTR OldName, BSTR NewName); [0114] HRESULT RenameTable (long DBCnn, BSTR OldName, BSTR NewName);

[0115] //方法:创建索引 [0115] // methods: Create an index

[0116] HRESULT CreateIndex(long DBCnn, ITableIndex^pIndex); [0116] HRESULT CreateIndex (long DBCnn, ITableIndex ^ pIndex);

[0117] H方法:得到数据表所有的索引信息 [0117] H methods: Data table all the index information

[0118] HRESULT GetTableIndexes(long DBCnn, BSTR TableName, double*GridSize, ITableIndexes氺氺pplndexes); [0118] HRESULT GetTableIndexes (long DBCnn, BSTR TableName, double * GridSize, ITableIndexes Shui Shui pplndexes);

[0119] //方法:删除索引 [0119] @ method: Delete Index

[0120] HRESULT DeleteIndex(long DBCnn, BSTR TableName, BSTR IndexName); [0120] HRESULT DeleteIndex (long DBCnn, BSTR TableName, BSTR IndexName);

[0121] H方法:将对数据表访问的权限赋给某个用户 [0121] H Methods: Data table access privileges will be assigned to a user

[0122] HRESULT GrantTableAccess(long DBCnn, BSTR TableName, BSTR User, long Access); [0122] HRESULT GrantTableAccess (long DBCnn, BSTR TableName, BSTR User, long Access);

[0123] H方法:将对数据表访问的权限撤销 [0123] H Methods: Data table access privileges will be revoked

[0124] HRESULT RevokeTableAccess(long DBCnn, BSTR TableName, BSTR User, long Access); [0124] HRESULT RevokeTableAccess (long DBCnn, BSTR TableName, BSTR User, long Access);

[0125] H方法:查询当前用户对表的访问权限 [0125] H methods: query the user access to the table

[0126] HRESULT GetTableAccess(long DBCnn, BSTRTableName, long氺Access); [0126] HRESULT GetTableAccess (long DBCnn, BSTRTableName, long Shui Access);

[0127] ■记录操作接口:用于对记录的增加、删除、修改、查询等操作,特别 [0127] ■ Record user interface: Used to increase the record, delete, modify, query and other operations, particularly

[0128] 注意查询提供按照空间范围查询的功能。 [0128] Note that the query provided in accordance with the spatial range queries.

[0129] //方法:普通查询 [0129] // Methods: General inquiry

[0130] //参数: [0130] // parameters:

[0131] //tabIename : query table name [0131] // tabIename: query table name

[0132] //pFields :查询哪些字段 [0132] // pFields: Discover what fields

[0133] //whereClause :where 语句(可以为〃'') [0133] // whereClause: where statement (for 〃 '')

[0134] //OrderByClause :order 语句(可以为〃“)[0135] //Recordset :返回的recordset [0134] // OrderByClause: order statements (for 〃 ") [0135] // Recordset: to return recordset

[0136] HRESULT Query(long DBCnn, BSTR tablename, IFields^pFields, BSTR whereClause, BSTR OrderByClause, long氺Recordset); [0136] HRESULT Query (long DBCnn, BSTR tablename, IFields ^ pFields, BSTR whereClause, BSTR OrderByClause, long Shui Recordset);

[0137] H方法:所有得到的recordset都需要通过此函数释放 [0137] H Method: All recordset obtained by this function requires the release

[0138] HRESULT FreeRecordset(long Recordset); [0138] HRESULT FreeRecordset (long Recordset);

[0139] H方法:通过此函数取下一条记录 [0139] H Methods: This function is to remove a record

[0140] HRESULT FetchRecord(long Recordset); [0140] HRESULT FetchRecord (long Recordset);

[0141] //方法=FetchRecord之后,通过此函数取某个位置的图元 [0141] // method = after FetchRecord, through this function takes a certain location element

[0142] HRESULT Ge tF ie 1 d_Shap e (long Recordset, long FieldPos, IBaseObject氺氺Shape); [0142] HRESULT Ge tF ie 1 d_Shap e (long Recordset, long FieldPos, IBaseObject Shui Shui Shape);

[0143] H方法:带空间限定的查询 [0143] H Method: With space limited inquiry

[0144] //参数: [0144] // parameters:

[0145] //tablename :query table name [0145] // tablename: query table name

[0146] //pFields :查询哪些字段 [0146] // pFields: Discover what fields

[0147] //whereClause :where 语句(可以为〃'') [0147] // whereClause: where statement (for 〃 '')

[0148] //pRect :空间包围框 [0148] // pRect: space enclosed box

[0149] //method :相交类型,参考SDE [0149] // method: intersection type, reference SDE

[0150] //Pass :返回满足条件的图元或者不满足条件的图元 [0150] // Pass: return to meet the conditions of primitive or does not meet the conditions of FIG yuan

[0151] //OptimizeForSmallArea :小块区域的查询则设置为VARIANT_TRUE [0151] // OptimizeForSmallArea: small area of inquiry is set to VARIANT_TRUE

[0152] //Recordset :返回的recordset [0152] // Recordset: to return recordset

[0153] HRESULT SearchByRect(long DBCnn, BSTR tablename, IFields氺pFields, BSTR whereClause, IRect^pRect, EnumDBSpatialSearchMethod method, VARIANT_B00L Pass, VARIANT_B00L OptimizeForSmallArea, long*Recordset); [0153] HRESULT SearchByRect (long DBCnn, BSTR tablename, IFields Shui pFields, BSTR whereClause, IRect ^ pRect, EnumDBSpatialSearchMethod method, VARIANT_B00L Pass, VARIANT_B00L OptimizeForSmallArea, long * Recordset);

[0154] //方法=FetchReco rd之后,通过此函数取某个位置的字段值 [0154] // method = FetchReco after rd, through this function takes the value of a field position

[0155] HRESULT GetField_Int32(long Recordset, long FieldPos, long氺value); [0155] HRESULT GetField_Int32 (long Recordset, long FieldPos, long Shui value);

[0156] HRESULT GetField_Intl6(long Recordset, long FieldPos, short氺value); [0156] HRESULT GetField_Intl6 (long Recordset, long FieldPos, short Shui value);

[0157] HRESULT GetField_Float(long Recordset, long FieldPos, float氺value); [0157] HRESULT GetField_Float (long Recordset, long FieldPos, float Shui value);

[0158] HRESULT GetField_DoubIe(long Recordset, long FieldPos, double*value); [0158] HRESULT GetField_DoubIe (long Recordset, long FieldPos, double * value);

[0159] HRESULT GetField_String(long Recordset, long FieldPos,BSTR氺value); [0159] HRESULT GetField_String (long Recordset, long FieldPos, BSTR Shui value);

[0160] HRESULT Ge tF ie 1 d_Shap e (long Recordset, long FieldPos, IBaseObject氺氺Shape); [0160] HRESULT Ge tF ie 1 d_Shap e (long Recordset, long FieldPos, IBaseObject Shui Shui Shape);

[0161] HRESULT GetField_Date(long Recordset, long FieldPos, long*Year, long氺Month, long氺Day, long氺Hour, long氺Minute, long氺Second); [0161] HRESULT GetField_Date (long Recordset, long FieldPos, long * Year, long Shui Month, long Shui Day, long Shui Hour, long Shui Minute, long Shui Second);

[0162] HRESULT GetField_Blob(long Recordset, long FieldPos, VARIANT*Value); [0162] HRESULT GetField_Blob (long Recordset, long FieldPos, VARIANT * Value);

[0163] HRESULT GetField_Clob(long Recordset, long FieldPos,VARIANT氺Value); [0163] HRESULT GetField_Clob (long Recordset, long FieldPos, VARIANT Shui Value);

[0164] //方法:准备更新table [0164] @: Prepare update table

[0165] HRESULT PrepareUpdate(long DBCnn, BSTR tableName, IFields^pFields, long氺Recordset); [0165] HRESULT PrepareUpdate (long DBCnn, BSTR tableName, IFields ^ pFields, long Shui Recordset);

[0166] //方法:通过sql删除行[0167] HRESULT DeleteBySQL(long DBCnn,BSTR tabIeName, BSTR sql); [0166] // Methods: sql deleting rows [0167] HRESULT DeleteBySQL (long DBCnn, BSTR tabIeName, BSTR sql);

[0168] //方法:准备插入行 [0168] @: Prepare to insert rows

[0169] HRESULT PrepareInsert(long DBCnn, BSTR tableName, IFields^pFields, long氺Recordset); [0169] HRESULT PrepareInsert (long DBCnn, BSTR tableName, IFields ^ pFields, long Shui Recordset);

[0170] //方法:SetField_*之后,通过此函数更新某行 [0170] @ method: SetField_ * After a row is updated by this function

[0171] HRESULT UpdateRow(long Recordset); [0171] HRESULT UpdateRow (long Recordset);

[0172] Il方法:Pr印arelnsert,SetField_*之后,通过此函数插入行 [0172] Il methods: Pr India arelnsert, SetField_ * After this function by inserting rows

[0173] HRESULT Insert(long Recordset); [0173] HRESULT Insert (long Recordset);

[0174] //方法:Insert,update时,通过此函数设置某个位置的字段值 [0174] @ method: Insert, when the update, set the value of a field position through this function

[0175] HRESULT SetField_Double(long Recordset, long FieldPos, double value, VARIANT_B00L NullValue); [0175] HRESULT SetField_Double (long Recordset, long FieldPos, double value, VARIANT_B00L NullValue);

[0176] HRESULT SetField_Float (long Recordset, long FieldPos, float value, VARIANT_B00L NullValue); [0176] HRESULT SetField_Float (long Recordset, long FieldPos, float value, VARIANT_B00L NullValue);

[0177] HRESULT SetField_Intl6 (long Recordset, long FieldPos, short value, VARIANT_B00L NullValue); [0177] HRESULT SetField_Intl6 (long Recordset, long FieldPos, short value, VARIANT_B00L NullValue);

[0178] HRESULT SetField_Int32 (long Recordset, long FieldPos, long value, VARIANT_B00L NullValue); [0178] HRESULT SetField_Int32 (long Recordset, long FieldPos, long value, VARIANT_B00L NullValue);

[0179] HRESULT S et F ie 1 d_Sh ap e (long Recordset, long FieldPos, IBaseObject氺Shape); [0179] HRESULT S et F ie 1 d_Sh ap e (long Recordset, long FieldPos, IBaseObject Shui Shape);

[0180] HRESULT SetField_String(long Recordset, long FieldPos, BSTR value); [0180] HRESULT SetField_String (long Recordset, long FieldPos, BSTR value);

[0181] HRESULT SetField_Date (long Recordset, long FieldPos, long Year, IongMonth, long Day, long Hour, long Minute, long Second, VARIANT_B00LNullValue); [0181] HRESULT SetField_Date (long Recordset, long FieldPos, long Year, IongMonth, long Day, long Hour, long Minute, long Second, VARIANT_B00LNullValue);

[0182] HRESULT SetField_Blob(long Recordset, long FieldPos, VARIANT Value); [0182] HRESULT SetField_Blob (long Recordset, long FieldPos, VARIANT Value);

[0183] HRESULT SetField_Clob(long Recordset, long FieldPos, VARIANT Value); [0183] HRESULT SetField_Clob (long Recordset, long FieldPos, VARIANT Value);

[0184] ■枚举表接口:枚举空间数据库中的属性表、图层、以及栅格图像。 [0184] ■ enumeration meter interface: enum attribute table space in the database, layers, and raster images.

[0185] // : 31 [Hi Iif WW table ( M TABLE+layer+Dataset 中的layer+raster table) [0185] //: 31 [Hi Iif WW table (M TABLE + layer + Dataset in layer + raster table)

[0186] HRESULT EnumAl ITables (long DBCnn, EnumPrivi lege Privilege, ITableInfo**ppTableInfo); [0186] HRESULT EnumAl ITables (long DBCnn, EnumPrivi lege Privilege, ITableInfo ** ppTableInfo);

[0187] //方法:返回所有的layer (游离layer+Dataset中的layer)但不包括raster layer [0187] @ method: return all the layer (free layer + Dataset in the layer) but does not include raster layer

[0188] HRESULT EnumAllLayers(long DBCnn, ITableInfo**ppTableInfo); [0188] HRESULT EnumAllLayers (long DBCnn, ITableInfo ** ppTableInfo);

[0189] ■锁定接口:锁定对属性表、图层等对象的读写操作。 [0189] ■ lock port: lock on the property sheet, layers and other objects of read and write operations.

[0190] Il方法:锁定Table定义,不允许修改 [0190] Il Method: Lock Table definition, can not be modified

[0191] HRESULT LockTableSchema(long DBCnn, BSTR tableName, BSTRuser, VARIANT, BOOL Exclusive); [0191] HRESULT LockTableSchema (long DBCnn, BSTR tableName, BSTRuser, VARIANT, BOOL Exclusive);

[0192] H方法:解开锁定Table定义 [0192] H method: Unlock Table definitions

[0193] HRESULT UnlockTableSchema(long DBCnn, BSTR tableName, BSTR user); [0193] HRESULT UnlockTableSchema (long DBCnn, BSTR tableName, BSTR user);

[0194] II方法:锁定Table所有行,不允许修改 [0194] II method: Table locks all the rows can not be modified

10[0195] HRESULT LockTable(long DBCnn, BSTR tabIeName, BSTRuser, VARIANT_B00L Exclusive); 10 [0195] HRESULT LockTable (long DBCnn, BSTR tabIeName, BSTRuser, VARIANT_B00L Exclusive);

[0196] //方法:解开锁定 [0196] @ method: Unlock

[0197] HRESULT UnlockTable(long DBCnn,BSTR tabIeName, BSTR user); [0197] HRESULT UnlockTable (long DBCnn, BSTR tabIeName, BSTR user);

[0198] ■其他接口。 [0198] ■ other interfaces.

[0199] 为更好的服务于警用地理信息空间数据库建库的需求,系统按照警用数据建库工作流程提供了建立代码规范、建立图层标准、建立专题标准、建立样式规范、数据上载、入库、接边、提取、备份维护、数据发布一系列的功能。 [0199] In order to better serve geographic information space database in police demands, the system according to the police database building workflow is provided Building Code standards and a layer standards, establishment of thematic standards, establish style specifications, upload data , storage, Edge, extract, backup maintenance, data publishing a series of functions. 具体而言: Specifically:

[0200] 1、代码规范,确定图层的代码分段格式,以满足未来的可扩充性要求,如图3所示,代码的分段数量决定了图层标准的树状层次数。 [0200] 1, code specifications to determine the format of the layer of code sections to meet future scalability requirements, as shown in the code segment determines the number of layers of the tree count level 3 standard.

[0201] 代码规范包含以下内容: [0201] Code specification contains the following:

[0202] •代码规范库:将多个代码规范归属到同一个规范库中,便于在规范库中进行代码标准类别的管理和维护。 [0202] • Codes of libraries: a plurality of code specifications attributed to the same specification library code standard categories for easy management and maintenance of the specification library.

[0203] •代码规范定义:将多个层次定义组织成标准代码规范,以规定空间数据库地理信息指标体系分类代码和指标项说明。 [0203] • Code specification defines: define multiple levels of the organization to the standard code specifications to define the spatial database of geographic information classification code indicator system and indicators Item Description. 如图4所示,分类码全部采用编码结构来区分不同类别和层次的地理信息(“门类”、“大类”、“中类”、“小类”),可用于实体图层、样式间的联系手段,还可用于实体图层中图元的分类代码。 , The classification code in all the coding structure to distinguish between different types and levels of geographic information ("category", "category", "class", "categories"), can be used for physical layer, as shown in Figure 4 between style contact means, but also for physical layer elements of classification codes.

[0204] •代码层次定义:不同类别和层次的地理信息分别归为一个层次,从而规定代码层次定义的命名规则。 [0204] • Code level definitions: different types and levels of geographic information were classified as a level, and thus the provisions of the code level defined naming rules. 每一层有其名称、宽度、是否补零、取值范围等属性。 Each layer has its own name, width, whether zeros in the range and other attributes.

[0205] •名称:表明层次含义的说明。 [0205] • Name: Indicate level instructions meaning.

[0206] •宽度:层次的字符位数。 [0206] • Width: level of character digits.

[0207] •是否补零:未达到宽度时可以用补零的方式来填充名称。 [0207] • Are zeros: zeros can be a way to fill the name does not meet the width.

[0208] •取值范围:说明层次的字符的取值范围,取值范围为:“数字”、“字母”、“数字+ 字母”、“所有字符”。 [0208] • Range: description of the range of the character level, ranging from: "Digital", "letters", "Digital + letters", "all the characters."

[0209] •代码树结构:根据建立的层次定义代码的命名规则,添加、删除、修改代码,以使不同类别和层次的地理信息以树的形式分类管理。 [0209] • code tree structure: hierarchical naming rules based on established custom code, add, delete, modify the code so that the different types and levels of geographic information in the form of a tree of category management.

[0210] 2、图层标准,确定图层的树状分类组织形式,在标准中空间数据库的每一个图层具有以下配置信息: [0210] 2, layer standards, determine the classification tree form tissue layers, each layer standard in spatial database has the following configuration information:

[0211] (1) 图层中文名称或显示名称。 [0211] (1) a layer Chinese name or display name. [0212] ⑵ 图层英文名称。 [0212] ⑵ layer English name. [0213] ⑶ 图层类型。 [0213] ⑶ layer type. [0214] ⑷ 图层描述。 [0214] ⑷ layer description. [0215] (5) 图层显示顺序。 [0215] (5) layers display order. [0216] (6) 图层字段排序设置:在应用开发中可据此按序显示该图层中的记录。 [0216] (6) layer field ordering settings: then be able to show that layer sequentially recorded in application development. [0217] (7) 图层的复合主键:在应用开发中可据此确定图层记录的唯一标识。 [0217] (7) layers of the composite primary key: can determine which uniquely identifies the layers recorded in application development. [0218] ⑶ 图层的过滤条件:在应用开发中用于滤除图层的部分记录。 [0218] ⑶ layer filter: to filter out portions of the recording layer in application development. [0219] (9) 图层的字段结构:包含字段的中文名称、英文名称、字段类型、长度、小数位 Field structure [0219] (9) layer: Contains field Chinese name, English name, field type, length, decimal places

数、允许空值、缺省值、描述信息、主键约束、唯一约束、取值规则、字段内容类型、字段分组信息、是否标识字段、是否可查字段、是否显示字段以及字段的显示级别。 Number, allows null values, default values, description, primary key constraints, unique constraints, ranging rules, field content type, field grouping information, whether the identification field, whether the field to be investigated, whether the level of the field and the field show. 其中,如图5所示:通过是否标识字段、是否可查字段、是否显示字段、显示级别这些设置为上层的查询系统提供了强大的配置能力。 Among them, shown in Figure 5: The field is identified, whether the field to be investigated whether the display field that displays the settings for the upper-level query system provides a powerful configuration capabilities.

[0220] 3、专题标准,如图6所示,在图层标准的基础之上,提供建立专题标准以支持数据的重新组织分类。 [0220] 3, thematic criteria, as shown in Figure 6, the layer standard basis, to provide a standard to support the re-establishment of thematic organization classified data. 这样在各种不同的应用开发中,实现了基于同一套数据标准形成不同的结构的专题标准,为各种专题应用提供支持。 So in a variety of application development, to achieve the same set of data standards based on the formation of a different structure of thematic standards, provide support for a variety of thematic applications. 如图7所示,专题标准组织结构如下: As shown in Figure 7, special standards organization structure is as follows:

[0221] •专题标准库:将多个专题标准定义归属到同一个专题标准库中,便于在专题标准库中进行专题标准的分类与维护。 [0221] • Thematic standard library: The standard definition of multiple themes attributed to the same topic in the standard library to facilitate thematic standard classification and maintenance of the standard library in the topic.

[0222] •专题标准定义:空间数据库中创建的数据集是需要灵活多变的,这样的需求可以在专题分类管理中实现。 [0222] • Thematic standard defines: dataset spatial database is the need to create flexible, so that demand can be achieved in the thematic classification management. 通过定义专题的名称、代码,从图层标准库提取已定义的图层到专题图层分类中,以组成数据专题内容。 By the definition of the topic name, code, extracted from the layer standard library layer has been defined to classify the thematic layers to compose data thematic elements.

[0223] •专题图层定义:专题图层是由标准图层的图层代码,图层映射名,图层表名,图层描述,过滤条件定义组成。 [0223] • definition of thematic layers: thematic layers, the layer mapping names, table names layer, layer layer layer described by the standard code, the filter criteria definition.

[0224] •图层代码:从标准图层属性中读取到的依据代码规范定义的图层代码。 [0224] • Layers Code: reads from the standard layer properties in the specification defines the basis for the code layer code.

[0225] •图层映射名:从标准图层属性中读取到的图层映射名,可以再次修改定义图层映射名。 [0225] • Layer Mapping name: read from standard layer to layer mapping attribute name, you can modify the definition of layer mapping name again.

[0226] •图层表名:从标准图层属性中读取到的图层表名。 [0226] • Layer table: read from standard layer to layer attributes table.

[0227] •图层描述:从标准图层属性中读取到的图层描述信息。 [0227] • Layer Descriptor: Reads from standard layer properties in the layer description.

[0228] •过滤条件:从标准图层中筛选符合过滤条件的记录作为专题图层信息。 [0228] • Filter: Filter records that meet the filter criteria from the standard layer as thematic layers of information.

[0229] 4、样式规范,提供基于图层标准和专题标准之上的样式管理和配置功能,以供数据发布、显示使用。 [0229] 4, style specifications, providing style management and configuration capabilities based on the layer standard and special standard for data publication, display use. 如图8所示,样式库包含以下信息: 8, the style library contains the following information:

[0230] (1)样式配置库:将标准图层、专题图层的样式配置方案保存到样式配置库中。 [0230] (1) Style configuration repository: Save the standard layer, thematic layers configuration style to style configuration repository. 以便在样式配置库中进行样式配置方案的增加,删除,查看等操作。 For increased style configuration in style configuration repository, delete, view and so on.

[0231] (2)样式配置方案:将多个图层(标准图层或专题图层)的配置样式信息组织成一个配置方案。 [0231] (2) style configuration: to organize more than one layer (standard layer or thematic layer) configuration information into a configuration style. 当图层数据加载时,采用此方案显示图层数据。 When the layer data is loaded, using this program shows the layer data.

[0232] (3)图层样式:通过图层数据的标准代码对应样式表达信息,生成具有该样式信息的地图数据。 [0232] (3) a layer style: via standard code data corresponding to the layer styles to present information to generate the map data with that style information. 图层样式包括可见视野、标注样式、符号样式、样式类型等。 Layer Styles include visible vision, dimension styles, symbols, patterns, styles types.

[0233] a)可见视野:通过设置最大,最小比例尺控制图层在视图中显示,当大于最小比例尺并且小于最大比例尺时图层才会显示。 [0233] a) Visible Vision: By setting the maximum and minimum scale control layer displayed in the view, when the scale is greater than the minimum and less than maximum scale layer will be displayed.

[0234] b)标注样式:可设置是否显示标注字段信息,并对标注字段的位置、XY偏移量、标注视野最大值、标注视野最小值、是否随地图缩放、字体样式等信息设置。 [0234] b) dimension style: You can set whether to display the label field information, and label field position, XY offset tagging maximum field of vision, vision marked minimum, whether with the map zoom, font style and other information set.

[0235] c)符号样式:符号样式信息包括:图层的边线样式信息、图层内符号是否随地图缩放、图层内填充类型、填充符号ID、填充符号SubID、填充符号间距XY、填充符号的高宽度等内容,通过对这些信息的设置以符号化图层。 [0235] c) Symbol Style: Symbol style information includes: sideline style information layer, the inner layer with the map symbol is scaled in the layer fill type, fill symbols ID, fill symbol SubID, fill symbol distance XY, fill symbols High width, etc., by setting a symbol of the information layer.

[0236] d)样式类型:对图层的渲染类型有简单样式、单一值样式、等级分类样式。 [0236] d) style types: the type of layer rendering simple style, a single value style, pattern classification.

[0237] 5、数据上载入库,提供Sip、CAD、GeoDB等多种常见外部数据格式的批量入库及出库功能。 [0237] 5, the data is loaded library, provides bulk storage Sip, CAD, GeoDB other common external data formats and library functions.

[0238] 6、数据接边,提供线、面的接边合并和预接边浏览能力,接边支持基于属性接边和基于空间关系接边两种方式,并且可设置字段的合并方式。 [0238] 6, the data access side, offering a line, then the side surfaces and pre-merger Edge browsing capabilities, support for attribute-based Edge Edge and Edge based on the spatial relationship between the two methods, and can be set up and consolidated field.

[0239] 7、数据提取,提供数据的提取出库功能,并可按照任意范围区域提取数据。 [0239] 7, data extraction, extract the library to provide the data, you can extract the data range in any area. [0240] 8、数据备份恢复,提供针对图层标准、矢量数据等信息的导入导出功能,提供多种形式的备份恢复功能。 [0240] 8, data backup and recovery, provides import and export capabilities for Layer Standard, vector data and other information, to provide various forms of backup and recovery capabilities.

[0241] 9、4D数据集的管理,针对空间数据提供4D数据集管理方式,按照图幅进行数据的导入、更新、接边(包括接边的预览)等操作,系统支持矩形、梯形、标准图幅以及自定义图幅等多种分幅方式。 Management [0241] 9,4D data sets for spatial data management to provide 4D data sets, according to the map sheet import data update, then the edge (including a preview of Edge's) and other operations, the system supports rectangular, trapezoidal, standard Mapsheet and custom framing Mapsheet other ways.

[0242] 10、数据的发布,基于样式配置提供了数据的一键式发布功能,用于将空间数据快速发布到地图服务中,大大简化警用环境下数据发布的过程。 [0242] 10, the data release, configuration provides data based on the style of one-click publishing for spatial data quickly posted to the map service, greatly simplifying the process of police data released environments.

[0243] 11、本实施例还包括插件接口,用于支持对用空间数据库的应用需求。 [0243] 11, the present embodiment also includes a plug-in interface to support application requirements for space database. 针对全国各地对空间上数据建库的特定需求(例如对数据进行各种统计、分析空间数据的关系、各种的数据处理需求)设计了插件接口,并且该插件接口位于空间数据库驱动接口之上,从而保证了插件与GIS平台的无关性,具有良好的扩展性。 For the specific needs of the country for building a database on spatial data (eg statistical data, the relationship between spatial data analysis, a variety of data processing requirements) of the plug-in interface design, and the plug-in connector is located on the spatial database-driven interface , thus ensuring the independence plug-GIS platform, has good scalability. 插件接口主要包括以下4个接口: Plug-in interface includes the following four interfaces:

[0244] (1)查询插件信息接口-插件具有自描述能力,建库平台通过查询插件的接口,可获得插件的名称、用途描述、环境依赖需求、行为方式等信息。 [0244] (1) query widget interfaces - plug-in has the ability to self-description, database platform through the interface query widget name available widget Descriptions, dependent on demand environment, behavior and other information.

[0245] (2)初始化接口-外界传入空间数据库连接对象及错误记录对象,插件可在这里进行初始化。 [0245] (2) Initialization Interface - external incoming spatial database connection object and error log objects, plug-ins can be initialized here.

[0246] (3)显示界面-调出插件设置界面,用户可在其中设置各种信息,并点击确定进行处理。 [0246] (3) Display interface - bring up the plug-in settings interface, users can set a variety of information therein, and click OK to process.

[0247] (4)释放资源接口-插件操作完成后释放内部资源。 [0247] (4) to release resources Interface - plug-in operation is completed after the release of internal resources.

[0248] 11、本实施例还包括日志记录装置,用于记录系统操作日志。 [0248] 11, the present embodiment also includes a logging device for recording system operation logs. 提供完善的日志记录功能,本系统的日志记录具有以下特点: Provide comprehensive logging, logging of the system has the following characteristics:

[0249] (1)日志信息详尽:系统日志分为三个层次的类别以便于日志的查询和显示,除此之外,日志还包含:操作用户,详细描述信息,客户端操作的IP地址,客户主机名称,客户端Mac地址,客户操作时间等信息,通过这些信息可以很容易的查找空间数据库的操作用户。 [0249] (1) detailed log information: the system log is divided into three levels of categories in order to query and display the log, in addition, the log also includes: operation of the user, IP address, client operations detailed description, client host name, the client Mac address, the guest operating time and other information, this information can easily find the operation of the user space of the database.

[0250] (2)如下图9所示,日志分类显示及查询设计:按照三级层次结构显示及查询日志信息,使日志组织变为树状结构。 As shown in [0250] (2) Figure 9 below, the log classification display and query design: three-tier hierarchy according to display and query log information, so log into a tree structure organization.

[0251] 12、针对系统安装部署及升级维护过程提供自动化工具支持:目前警用业务发展迅速,各种应用需求不断提出,对空间数据的建库和管理提出了更高的要求,整个软件体系经常需要不断升级改进。 [0251] 12, installation and deployment for system maintenance and upgrades to provide automated tool support: Currently police rapid development of business applications demand made on building a database and management of spatial data put forward higher requirements, the entire software system often it requires constant upgrades.

[0252] 为此,提出空间数据库系统部署及使用时应做到:能够自动创建系统表,能够自动检测并给出提示是否程序与系统表产生不一致从而需要升级,能够自动进行系统表升级。 [0252] This paper presents spatial database system should be deployed and use to do: to create the system table automatically, to automatically detect and prompt procedures and system tables is inconsistent and thus need to be upgraded, the system can automatically update the table. 为满足此要求,系统提供了两个自动化工具,包括空间数据库初始创建工具和空间数据库系统表检测升级工具。 To meet this requirement, the system provides two automated tools including spatial database and spatial database initial creation tool detection system tables upgrade tool.

[0253] (1)空间数据库建库工具:将各GIS平台建库所需的数据库脚本存放于xml文件的不同节点中,提供一个向导式工具,按照顺序依次创建表空间、创建用户、为用户授权、最后依次执行xml中所有脚本,从而完成系统表创建。 [0253] (1) Spatial Database Tool: Needed for GIS database platform for building a database script xml files stored in different nodes, there is provided a wizard-style tools, create a table space sequentially in the order, create a user, for the user authorization, the last execution in order xml all scripts to complete the system tables created.

[0254] (2)空间数据库系统表检测升级工具:空间数据库建库工具每次发布版本时,形成一个xml格式的更新配置文件,该文件记录了空间数据库系统表每次升级对应的系统表版本号及升级所需执行的一系列sql语句。 [0254] (2) spatial database upgrade tool detection system tables: Spatial Database Tools version each time the release form an xml update the configuration file format, the file system records the spatial database tables corresponding to the system table each upgrade version a series of sql statement number and you need to perform the upgrade. 在检测是否需要升级时,可根据该配置文件与当前数据库中配置文件记录的版本号进行对比,从而判断是否需要升级。 When detect whether you need to upgrade, it can be compared with the current version number in the database configuration file records according to the profile, and to determine whether you need to upgrade. 而在进行升级过程时,从当前数据库记录的版本号的下一个版本开始,依次执行xml更新配置文件中的各sql语句,从而自动完成升级功能。 And during the upgrade process, from the next version of the current version number of database records began, followed by the implementation xml update the configuration file for each sql statement to automatically complete the upgrades.

[0255] 优选地,地理信息数据管理系统还包括:升级装置,用于检测系统版本,当系统版本与预存的更新配置文件中的版本不一致时,对系统进行升级。 [0255] Preferably, GIS data management system further comprising: upgrade means for detecting system version, when the system version update stored in the configuration file versions are different, the system is upgraded.

[0256] 如图10所示,升级具体流程如下:空间数据库软件在登录后,根据系统表版本号信息与当前编译模块内部写入的所需系统表版本号进行对比,在两者不一致的情况下给出提示信息: [0256] 10, the upgrade process is as follows: spatial database software after logging in, according to the system information table version number compared with the current version of the required system tables compiled written inside the module, in the case of inconsistencies between the two Under an alert message:

[0257] (1)如果程序所需系统表版本号高于当前数据库中记录的系统表版本号,则提示用户使用空间数据库系统表检测升级工具进行系统表的升级。 [0257] (1) If the application version number is higher than the required system tables in the database table records the current system version number, the system prompts the user to use the database system table space detection upgrade tool to upgrade system tables.

[0258] (2)如果程序所需系统表版本号低于当前数据库中记录的系统表版本号,则提示用户获取新版本的空间数据库软件包,进行程序的安装升级。 [0258] (2) If the application version number is lower than the required system tables in the database table records the current system version number, the system prompts the user to obtain a new version of the spatial database package to install the upgrade program.

[0259] 如图11所示,本发明地理信息数据管理方法实施例包括: [0259] As shown in Figure 11, GIS data management method embodiment of the invention comprises:

[0260] 对接收到的地理信息数据进行格式转换; GIS data [0260] received format conversion;

[0261] 将转换后的地理信息数据发送到空间数据库或GIS平台。 [0261] to send the geographical information data converted to a spatial database or GIS platform.

[0262] 如图12所示,本实施例的地理信息数据管理方法在接收到GIS平台的地理信息数据后,确定图层代码的分段格式,按照预设的层次定义,将所述代码转换为相应的格式。 [0262] 12, GIS data management method of the present embodiment, after receiving the GIS data GIS platform layer code segment format determined in accordance with pre-defined level, the transcoding to the appropriate format.

[0263] 在代码转换后,还为所述地理信息数据建立以下图层信息:图层中文名称、显示名称或英文名称、类型、描述、显示顺序、字段排序、复合主键、过滤条件、字段结构。 [0263] After transcoding, as well as the GIS data layers to establish the following information: Layer Chinese name, display name or English name, type, description, display order, sort fields, composite primary keys, filters, field structure .

[0264] 另外,还按照预设的专题标准提取所述图层后,形成专题图层存储到所述空间数据库中。 After the [0264] In addition, according to a preset topic standardized extract of the layers to form a thematic layer to the storage space in the database.

[0265] 本发明的地理信息数据管理方法及系统,对不同GIS平台空间数据库的统一规范化管理,避免了不同GIS平台下空间数据库的重复开发和维护,降低了地理信息平台的建设成本,提高了工作效率。 [0265] The present invention geographic information data management method and system, different GIS platform for unified standardized spatial database management, to avoid duplication of development and maintenance of different GIS spatial database platform, reducing the construction cost geographic information platform, to improve the work efficiency. 为上层的应用系统开发提供了良好的支撑,为空间数据库的不断维护升级带来了很大的便利。 For the upper application development provides a good support, it has brought great convenience to the continued maintenance and upgrade spatial database.

[0266] 另外,本发明建立一套可扩充的标准体系,针对地理信息数据的具体情况,定义一套具有良好扩充性的代码规范及图层标准,以保证未来能够将更多数据纳入到数据体系中。 [0266] In addition, the present invention can be expanded to establish a standard system, the specific situation of GIS data, the definition of a good code extensibility layer specification and standards to ensure the future be able to incorporate more data into the data system. 通过标准管理相关功能的设计为上层应用系统开发提供了极大的方便性和可扩展性, 具有很强的配置能力。 Management-related functions through a standard designed to provide application development for the upper great convenience and scalability, with strong configuration capabilities. 实现从标准建立、数据入库、质量检查、数据接边、数据提取到数据发布的完整流程,满足系统对数据共享和交换的需求。 From a standard is established, data storage, quality inspection, data access side, data extraction to the data released by the complete processes to meet the needs of the system for data sharing and exchange.

[0267] 应说明的是:以上实施例仅用以说明本发明而非限制,本发明也并不仅限于上述举例,一切不脱离本发明的精神和范围的技术方案及其改进,其均应涵盖在本发明的权利要求范围中。 [0267] It should be noted that: The above embodiments are merely illustrative of the invention rather than limit, the present invention is not limited to the above example, all without departing from the spirit and scope of the present invention, technical solutions and improvements, which should be covered In the claims of the present invention of claim scope.

Citations de brevets
Brevet cité Date de dépôt Date de publication Déposant Titre
CN1734449A *9 août 200415 févr. 2006英业达股份有限公司Vector computer graphics service method and system
CN101275853A *27 mars 20081 oct. 2008三洋电机株式会社Navigation apparatus
CN101493825A *17 déc. 200829 juil. 2009武汉中地数码科技有限公司;中国地质大学(武汉)GIS middleware collocation and management method
US20060282215 *9 juin 200614 déc. 2006Ling-Yan BaoGlobal positioning system with real-time updating
Citations hors brevets
Référence
1 *韩双旺: "一种基于XML的WebGIS多源异构数据集成方案", 《中央民族大学学报(自然科学版)》, vol. 19, no. 3, 31 August 2010 (2010-08-31)
Référencé par
Brevet citant Date de dépôt Date de publication Déposant Titre
CN102841927A *18 juil. 201226 déc. 2012福建省新泽尔资讯科技有限公司Method and device for data interaction among a plurality of databases and distributed data interaction system
CN102841927B *18 juil. 20121 avr. 2015福建省新泽尔资讯科技有限公司Method and device for data interaction among a plurality of databases and distributed data interaction system
CN103198115A *29 mars 201310 juil. 2013中国科学院对地观测与数字地球科学中心Target ground object data processing device
CN103198115B *29 mars 201328 déc. 2016中国科学院对地观测与数字地球科学中心一种目标地物数据处理装置
WO2016043969A1 *1 sept. 201524 mars 2016Enki Technology, Inc.Glass coating specification library
Classifications
Classification internationaleG06F17/30
Événements juridiques
DateCodeÉvénementDescription
4 avr. 2012C06Publication
13 juin 2012C10Entry into substantive examination
8 juil. 2015C12Rejection of a patent application after its publication