CN102402526A - Geographic information database management method and system - Google Patents
Geographic information database management method and system Download PDFInfo
- Publication number
- CN102402526A CN102402526A CN2010102809671A CN201010280967A CN102402526A CN 102402526 A CN102402526 A CN 102402526A CN 2010102809671 A CN2010102809671 A CN 2010102809671A CN 201010280967 A CN201010280967 A CN 201010280967A CN 102402526 A CN102402526 A CN 102402526A
- Authority
- CN
- China
- Prior art keywords
- geographic information
- information data
- layer
- spatial
- interface
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
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.
Description
Technical field
The present invention relates to a kind of database technology, relate in particular to a kind of geographic information database management method and system.
Background technology
Spatial database be GIS-Geographic Information System on the computer physics storage medium, store, with the summation of using relevant geographical spatial data, generally be that the form with the file of a series of ad hoc structures is organized on the storage medium.The research of spatial database starts from map making and the remote sensing image processing field of the seventies in 20th century, its objective is in order to effectively utilize the satellite remote sensing resource to draw out various economic thematic mapss rapidly.Because there are many defectives in traditional relational database in the expression of spatial data, storage, management, retrieval, thereby has formed this database research field of spatial database.And conventional database systems can't effectively be supported complex object (like figure, image) only to simple object.
Have a lot of GIS platforms to provide spatial data to build the library management function now, these build library software usually based on the GIS platform of each producer oneself, are characterized in:
1, bind the GIS platform: each Library Construction Kit [Microsoft FoxPro] is based on the GIS platform of producer oneself, as usually based on the ArcGIS platform, Oracle Spatial platform, the platform of perhaps domestic GIS producers.
2, file layout is solidified: receive the qualification of platform, the file layout of spatial data immobilizes usually
3, the function design is loose, and the flow process gonosome is not strong at present, and general Library Construction Kit [Microsoft FoxPro] design does not have clear and definite specific aim.
Existing Library Construction Kit [Microsoft FoxPro] concentrates on energy on the functions such as data loading, inquiry, retrieval, output, renewal, distribution, management usually, and considers and support less building standard forming process before the storehouse.
Along with the continuous expansion of magnanimity geographic information data and the increase day by day of Spatial Database demand, need to form certain data and build library standard and flow process mechanism, with the storage and the management of normalized space database.And existing various GIS platform does not meet the alert geographic information database construction criteria, data base administration mechanism used to fail to realize unification in the database establishment process fully, so that platform application is produced restriction.
Mainly there is following shortcoming in existing various GIS platform in the database establishment process:
1, rely on specific GIS platform: existing Library Construction Kit [Microsoft FoxPro] is only supported the GIS platform of producer oneself separately usually, and alert various with the system applies circumstance complication, can not be confined to single GIS platform.
2, the spatial data file layout is single, fixing: alert GIS data preservation form with system is varied; Existing database form document form also arranged; Also there are domestic manufacturers in the existing foreign vendor of spatial database type, therefore needs its data of Library Construction Kit [Microsoft FoxPro] management that adaptability is very strong.
3, lack specific aim: all have the characteristics of oneself with system in aspect polices such as figure layer standard, data organization, management; The existing space data are built library software and are difficult to adapt to fully its applied environment; Cause being difficult in routine duties play a role, can't provide support for the exploitation of upper layer application system.
4, lack support: lack the complete support of a cover aspect the standard management of existing Library Construction Kit [Microsoft FoxPro] before data loading, cause its loading of often paying close attention to data itself, management to standard.And,, be difficult to satisfy following various application demands if lack the support of a cover Standardization System alert various with Data Source complicacy under the environment.
More than these shortcomings cause these to build library software can't being applicable to fully that the alert geographic information database construction requirements, data base administration mechanism use fail to realize unified, so that restricting with the various application and developments generations on the platform base to alert.
Summary of the invention
The objective of the invention is to, a kind of geographic information database management method and system are provided, reduced the construction cost of geographical information platform, improved work efficiency.
For realizing above-mentioned purpose, according to an aspect of the present invention, a kind of geographic information data management method is provided, comprising:
Geographic information data to receiving carries out format conversion;
Geographic information data after the conversion is sent to spatial database or GIS platform.
Behind the geographic information data that receives the GIS platform, confirm the zoned format of figure layer identification code, according to preset level definition, be corresponding form with said code conversion.
For said geographic information data is set up with figure below layer information: figure layer Chinese, display Name or English name, type, description, DISPLAY ORDER, field ordering, compound primary key, filtercondition, field structure.
Behind the preset said figure layer of thematic standard extraction, form special layer and store in the said spatial database.
This method also comprises: the register system Operation Log.
For realizing above-mentioned purpose, according to another aspect of the present invention, a kind of geographic information data management system is provided, comprising:
Spatial database is used to store the geographic information data of different GIS platforms;
The GIS platform is used for to said spatial data library storage or obtains geographic information data;
Drive unit is located between different the GIS platform and spatial database, is used to receive the geographic information data of said GIS platform, carries out sending to said spatial database after the format conversion; Or obtain the required geographic information data of GIS platform from said spatial database, be to be forwarded to said GIS platform behind the corresponding form of said GIS platform with its format conversion.
This system also comprises: card i/f is used to support the application demand to spatial database;
Said card i/f comprises: the query plugin information interface, have the self-described ability, and through the interface of query plugin, can obtain title, purposes description, environment dependency need, the behavior information of plug-in unit;
Initialization interface is for importing the spatial database connecting object into and the error logging object carries out initialization in the external world;
The display interface interface is used to set user information;
Discharge resource interface, be used for after operation is accomplished, discharging internal resource.
Wherein, said drive unit comprises:
Connecting interface: be used for distribution, establishment, the release of the connection of spatial database;
And/or transaction interface: the affairs that are used for spatial database start, submit to and rollback;
And/or spatial frame of reference interface: be used for enumerating, creating of spatial frame of reference;
And/or list structure maintenance interface: the inquiry of the establishment of attribute list and spatial table, deletion, renewal, list structure, the maintenance of index;
And/or recording operation interface: be used for increase, deletion, the modification to record, the operation of inquiry, pay special attention to inquire about the function that provides according to the spatial dimension inquiry;
And/or enumerated table interface: enumerate attribute list, figure layer and grating image in the spatial database;
And/or lock port: locking is to the read-write operation of attribute list, figure layer object.
This system also comprises: log recording apparatus is used for the register system Operation Log;
Said daily record comprises: IP address, user rs host title, client Mac address and client's running time of operation user, detailed description information, client operation.
This system also comprises: update device, be used for the detection system version, and when system version and the version in the more new configuration file that prestores are inconsistent, system is upgraded.
Geographic information data management method of the present invention and system; Unified standardized management to different GIS platform space databases; Avoid the overlapping development and the maintenance of spatial database under the different GIS platforms, reduced the construction cost of geographical information platform, improved work efficiency.For the application system development on upper strata provides good supporting, for the continuous maintenance upgrade of spatial database brings great convenience.
In addition, the present invention sets up the open-ended standards system of a cover, and to the concrete condition of geographic information data, definition one cover has the code specification and the figure layer standard of good extendibility, can multidata more be brought in the data system to guarantee future.The upper layer application system development that is designed to through the standard management correlation function provides great convenience property and extensibility, has very strong allocative abilities.The entire flow of realization from standard foundation, data loading, quality check, data edge fit, data extract to data issuing satisfies that system is shared data and the demand of exchange.
Description of drawings
Fig. 1 is the structural drawing of geographic information data management system embodiment of the present invention;
Fig. 2 is the synoptic diagram of drive unit interface in the geographic information data management system of the present invention;
Fig. 3 is the synoptic diagram of code specification in the embodiment of the invention;
Fig. 4 is the synoptic diagram of code definition in the embodiment of the invention;
Fig. 5 is the synoptic diagram that in the embodiment of the invention figure layer is defined;
Fig. 6 is a special topic and the corresponding synoptic diagram of figure layer in the embodiment of the invention;
Fig. 7 is the synoptic diagram of special topic definition in the embodiment of the invention;
Fig. 8 is the synoptic diagram in style configuration storehouse in the embodiment of the invention;
Fig. 9 is the synoptic diagram that log information shows and inquires about in the embodiment of the invention;
Figure 10 is the process flow diagram of spatial database upgrading in the embodiment of the invention;
Figure 11 is the process flow diagram of geographic information data management method embodiment of the present invention;
Figure 12 is the process flow diagram of another embodiment of geographic information data management method of the present invention.
Embodiment
Below in conjunction with accompanying drawing the present invention is elaborated.
As shown in Figure 1, geographic information data management system embodiment of the present invention comprises:
Spatial database is used to store the geographic information data of different GIS platforms;
The GIS platform is used for to said spatial data library storage or obtains geographic information data, for example: SuperMap, MapGis, ArcSDE and OracleSptial platform or the like;
Drive unit is located between different the GIS platform and spatial database, is used to receive the geographic information data of said GIS platform, carries out sending to said spatial database after the format conversion; Or obtain the required geographic information data of GIS platform from said spatial database; With its format conversion is to be forwarded to said GIS platform behind the corresponding form of said GIS platform, and for example the SuperMap to above-mentioned GIS platform drives, MapGis drives, ArcSDE drives and OracleSptial drives.
Drive unit comprises a plurality of interfaces, and the main interface of facing each classification down as shown in Figure 2 provides its concise and to the point describe (idl form):
■ connecting interface: be used for distribution, establishment, the release of the connection of spatial database.
// method: set up a connection resource, but really do not connect
HRESULT?CreateConnection(long*DBCnn)；
// method: connection attribute is set
// parameter:
//name: Property Name
//value: property value
HRESULT?SetConnectionProperty(long?DBCnn，BSTR?name，BSTR?value)；
// method: connect
HRESULT?Connect(long?DBCnn)；
// method: break off connection
HRESULT?Disconnect(long?DBCnn)；
The ■ transaction interface: the affairs that are used for spatial database start, submit to and rollback.
// method: beginning affairs
HRESULT?BeginTransaction(long?DBCnn)；
// method: end transaction (Commit or Rollback)
HRESULT?EndTransaction(long?DBCnn，VARIANT_BOOL?Commit)；
■ spatial frame of reference interface: be used for functions such as the enumerating of spatial frame of reference, establishment.
// method: enumerate all coordref information among the database
HRESULT?EnumCoordReference(long?DBCnn，ICoordReflnfoArray**ppCoordRefArray)；
// method: increase a new coordref
HRESULT?AddCoordReference(long?DBCnn，ICoordRefInfo*pInfo)；
// method: obtain figure layer reference frame ID
HRESULT?GetLayerCoordRef(long?DBCnn，BSTR?tableName，long*SRID)；
// method: through reference frame ID inquiry details
HRESULT?GetCoordRefInfo(long?DBCnn，long?SRID，ICoordRefInfo**ppInfo)；
■ list structure maintenance interface: the establishment of attribute list and spatial table, deletion, renewal, list structure
Maintenance of inquiry, index or the like.
// method: the ObjectID field (unique field) of obtaining tables of data
HRESULT?GetOIDField(long?DBCnn，BSTR?tableName，BSTR*OIDField)；
// method: obtain list structure
HRESULT?GetTableFields(long?DBCnn，BSTR?tableName，IFields**pFields)；
// method: set up general T able
HRESULT?CreateTable(long?DBCnn，BSTR?tableName，IFields*pFields)；
// method: deletion common property table (perhaps figure layer)
HRESULT?DeleteTable(long?DBCnn，BSTR?tableName)；
// method: upgrade to the figure layer from the common property table
HRESULT?CreateLayer(long?DBCnn，BSTR?tableName，BSTR?shapeField，EnumDBLayerType?type，double?GridSize，ICoordRefInfo*pSrid，long?AllocCount)；
// method: deletion common property table (perhaps figure layer)
HRESULT?DeleteLayer(long?DBCnn，BSTR?tableName)；
// method: obtain figure layer scope
HRESULT?GetLayerExtent(long?DBCnn，BSTR?tableName，IRect**pRect)；
// method: figure layer scope is set
HRESULT?SetLayerExtent(long?DBCnn，BSTR?tableName，IRect*pRect)；
// method: return layer type (point, line, face)
HRESULT?GetLayerType(long?DBCnn，BSTR?tableName，EnumDBLayerType**Type)；
// method: increase field
HRESULT?AddField(long?DBCnn，BSTR?TableName，IField*pField)；
// method: deletion field
HRESULT?DeleteField(long?DBCnn，BSTR?TableName，BSTR?FieldName)；
// method: change table name
HRESULT?RenameTable(long?DBCnn，BSTR?OldName，BSTR?NewName)；
// method: create index
HRESULT?CreateIndex(long?DBCnn，ITableIndex*pIndex)；
// method: obtain all index informations of tables of data
HRESULT?GetTableIndexes(long?DBCnn，BSTR?TableName，double*GridSize，ITableIndexes**ppIndexes)；
// method: deletion index
HRESULT?DeleteIndex(long?DBCnn，BSTR?TableName，BSTR?IndexName)；
// method: will compose to certain user to the authority of data table access
HRESULT?GrantTableAccess(long?DBCnn，BSTR?TableName，BSTR?User，long?Access)；
// method: will cancel to the authority of data table access
HRESULT?RevokeTableAccess(long?DBCnn，BSTR?TableName，BSTR?User，long?Access)；
// method: the access rights of inquiry active user his-and-hers watches
HRESULT?GetTableAccess(long?DBCnn，BSTRTableName，long*Access)；
■ recording operation interface: be used for operations such as increase, deletion, modification, inquiry to record, special
Notice that inquiry provides the function according to the spatial dimension inquiry.
// method: common inquiry
// parameter:
//tablename：query?table?name
//pFields: inquire about which field
//whereClause:where statement (can be " ")
//OrderByClause:order statement (can be " ")
//Recordset: the recordset that returns
HRESULT?Query(long?DBCnn，BSTR?tablename，IFields*pFields，BSTR?whereClause，BSTR?OrderByClause，long*Recordset)；
// method: all recordset that obtain need discharge through this function
HRESULT?FreeRecordset(long?Recordset)；
// method: take off a record through this function
HRESULT?FetchRecord(long?Recordset)；
// method: after the FetchRecord, get the pel of certain position through this function
HRESULT?GetField_Shape(long?Recordset，long?FieldPos，IBaseObject**Shape)；
// method: the inquiry that carrying space limits
// parameter:
//tablename：query?table?name
//pFields: inquire about which field
//whereClause:where statement (can be " ")
//pRect: space encloses frame
//method: intersect type, with reference to SDE
//Pass: return pel that satisfies condition or the pel that does not satisfy condition
//OptimizeForSmallArea: the inquiry of pocket then is set to VARIANT_TRUE
//Recordset: the recordset that returns
HRESULT?SearchByRect(long?DBCnn，BSTR?tablename，IFields*pFields，BSTR?whereClause，IRect*pRect，EnumDBSpatialSearchMethod?method，VARIANT_BOOL?Pass，VARIANT_BOOL?OptimizeForSmallArea，long*Recordset)；
// method: after the FetchReco rd, get the field value of certain position through this function
HRESULT?GetField_Int32(long?Recordset，long?FieldPos，long*value)；
HRESULT?GetField_Int16(long?Recordset，long?FieldPos，short*value)；
HRESULT?GetField_Float(long?Recordset，long?FieldPos，float*value)；
HRESULT?GetField_Double(long?Recordset，long?FieldPos，double*value)；
HRESULT?GetField_String(long?Recordset，long?FieldPos，BSTR*value)；
HRESULT?GetField_Shape(long?Recordset，long?FieldPos，IBaseObject**Shape)；
HRESULT?GetField_Date(long?Recordset，long?FieldPos，long*Year，long*Month，long*Day，long*Hour，long*Minute，long*Second)；
HRESULT?GetField_Blob(long?Recordset，long?FieldPos，VARIANT*Value)；
HRESULT?GetField_Clob(long?Recordset，long?FieldPos，VARIANT*Value)；
// method: prepare to upgrade table
HRESULT?PrepareUpdate(long?DBCnn，BSTR?tableName，IFields*pFields，long*Recordset)；
// method: through sql deletion row
HRESULT?DeleteBySQL(long?DBCnn，BSTR?tableName，BSTR?sql)；
// method: prepare to insert row
HRESULT?PrepareInsert(long?DBCnn，BSTR?tableName，IFields*pFields，long*Recordset)；
// method: after the SetField_*, upgrade certain row through this function
HRESULT?UpdateRow(long?Recordset)；
// method: PrepareInsert after the SetField_*, inserts row through this function
HRESULT?Insert(long?Recordset)；
// method: Insert is during update, through the field value of this certain position of function setup
HRESULT?SetField_Double(long?Recordset，long?FieldPos，double?value，VARIANT_BOOL?NullValue)；
HRESULT?SetField_Float(long?Recordset，long?FieldPos，float?value，VARIANT_BOOL?NullValue)；
HRESULT?SetField_Int16(long?Recordset，long?FieldPos，short?value，VARIANT_BOOL?NullValue)；
HRESULT?SetField_Int32(long?Recordset，long?FieldPos，long?value，VARIANT_BOOL?NullValue)；
HRESULT?SetField_Shape(long?Recordset，long?FieldPos，IBaseObject*Shape)；
HRESULT?SetField_String(long?Recordset，long?FieldPos，BSTR?value)；
HRESULT?SetField_Date(long?Recordset，long?FieldPos，long?Year，longMonth，long?Day，long?Hour，long?Minute，long?Second，VARIANT_BOOLNullValue)；
HRESULT?SetField_Blob(long?Recordset，long?FieldPos，VARIANT?Value)；
HRESULT?SetField_Clob(long?Recordset，long?FieldPos，VARIANT?Value)；
■ enumerated table interface: enumerate attribute list, figure layer and grating image in the spatial database.
// method: return all table (the layer+raster table among the general T ABLE+layer+Dataset)
HRESULT?EnumAllTables(long?DBCnn，EnumPrivilege?Privilege，ITableInfo**ppTableInfo)；
// method: return all layer (free layer in layer+Dataset) but do not comprise raster layer
HRESULT?EnumAllLayers(long?DBCnn，ITableInfo**ppTableInfo)；
The ■ lock port: locking is to the read-write operation of objects such as attribute list, figure layer.
// method: locking Table definition does not allow to revise
HRESULT?LockTableSchema(long?DBCnn，BSTR?tableName，BSTRuser，VARIANT_BOOL?Exclusive)；
// method: unlocked Table definition
HRESULT?UnlockTableSchema(long?DBCnn，BSTR?tableName，BSTR?user)；
// method: all row of locking Table do not allow to revise
HRESULT?LockTable(long?DBCnn，BSTR?tableName，BSTRuser，VARIANT_BOOL?Exclusive)；
// method: unlocked
HRESULT?UnlockTable(long?DBCnn，BSTR?tableName，BSTR?user)；
Other interfaces of ■.
Be better service in alert demand of building the storehouse with geographical information space database, system according to warn provide with data database work flow process set up code specification, foundation figure layer standard, set up thematic standard, set up style specifications, data upload, warehouse-in, edge fit, extraction, backup maintenance, a series of function of data issuing.Particularly:
1, code specification is confirmed figure layer code segmentation form, and is as shown in Figure 3 to satisfy following expandability requirement, and the number of fragments of code has determined the tree-shaped hierachy number of figure layer standard.
Code specification comprises following content:
● code specification storehouse: a plurality of code specifications are belonged in the same standard storehouse, be convenient in the standard storehouse, carry out administering and maintaining of code standard classification.
● code specification definition: the many levels definitions section is made into the standard code standard, with regulation spatial database geography information index system Sort Code and index item explanation.As shown in Figure 4; Classification code all adopts coding structure to distinguish geography information (" class ", " big type ", " middle type ", " group ") different classes of and level; Can be used for the contact means between sterogram layer, pattern, also can be used for the Sort Code of pel in the sterogram layer.
● the definition of code level: different classes of and geography information level is classified as a level respectively, thus the naming rule of code designation level definition.Each layer has attributes such as its title, width, whether zero padding, span.
● title: show the explanation of level implication.
● width: the character figure place of level.
● whether zero padding: can not come pad name with the mode of zero padding when reaching width.
● span: the span of the character of level is described, span is: " numeral ", " letter ", " numeral+letter ", " all characters ".
● tree structure: according to the naming rule of the level definition code of setting up, add, deletion, revise code, so that the geography information of different classes of and level is with the formal classification management of tree.
2, a figure layer standard confirmed the tree-shaped taxonomic organization form of figure layer, has following configuration information at each figure layer of standard hollow spatial database:
(1) figure layer Chinese or display Name.
(2) figure layer English name.
(3) layer type.
(4) the figure layer is described.
(5) figure layer DISPLAY ORDER.
(6) ordering of figure layer field is provided with: in application and development, can show the record in this figure layer in view of the above according to the order of sequence.
(7) compound primary key of figure layer: the unique identification that in application and development, can confirm figure layer record in view of the above.
(8) filtercondition of figure layer: the partial record that in application and development, is used for filtering figure layer.
(9) field structure of figure layer: comprise the Chinese, English name, field type, length, decimal digits, permission null value, default value, descriptor, major key constraint, unique constraint, value rule, field contents type, field grouping information of field, whether identification field, whether can look into field, the demonstration rank of display field and field whether.Wherein, as shown in Figure 5: through whether identification field, whether can look into field, whether display field, show that these inquiry systems that are set to the upper strata of rank provide powerful allocative abilities.
3, thematic standard is as shown in Figure 6, on the basis of figure layer standard, provides and sets up thematic standard to support the reorganization classification of data.In various application and development, realized forming the thematic standard of various structure like this, for various special topic application provide support based on same set of data standard.As shown in Figure 7, thematic normal structure structure is following:
● thematic java standard library: a plurality of thematic standard definitions are belonged in the same thematic java standard library, be convenient in thematic java standard library, carry out the classification and the maintenance of thematic standard.
● thematic standard definition: the data set of creating in the spatial database is need be flexible and changeable, and such demand can realize in the thematic classification management.Through defining title, the code of special topic, from scheming layer figure layer that the java standard library extraction has defined to the special layer classification, to form the thematic content of data.
● the special layer definition: special layer is the figure layer identification code by the standard drawing layer, figure layer Map Names, and figure layer table name, the figure layer is described, and the filtercondition definition is formed.
● figure layer identification code: the figure layer identification code that from the standard layer properties, reads according to the code specification definition.
● figure layer Map Names: the figure layer Map Names that from the standard layer properties, reads, can revise definition figure layer Map Names once more.
● figure layer table name: the figure layer table name that from the standard layer properties, reads.
● the figure layer is described: the figure layer descriptor that from the standard layer properties, reads.
● filtercondition: the record that screening meets filtercondition from the standard drawing layer is as special layer information.
4, style specifications provides based on pattern management and configuration feature on figure layer standard and the thematic standard, uses for data issuing, demonstration.As shown in Figure 8, style library comprises following information:
(1) style configuration storehouse: the style configuration scheme of standard drawing layer, special layer is saved in the style configuration storehouse.So that in the style configuration storehouse, carry out the increase of style configuration scheme, deletion such as checks at operation.
(2) style configuration scheme: the configuration style message block of a plurality of figure layers (standard drawing layer or special layer) is made into an allocation plan.When the figure layer data loads, adopt this scheme show layers data.
(3) layer style: the corresponding pattern expressing information of standard code through the figure layer data generates the map datum with this style information.Layer style comprises the visible visual field, dimension style, the Symbol Style, style type etc.
A) the visible visual field: through maximum is set, minimum scale chi control chart layer shows that in view the figure layer just can show when greater than the minimum scale chi and less than the maximum ratio chi.
B) dimension style: can be provided with whether show the mark field information, and to the position, XY side-play amount of mark field, mark visual field maximal value, mark visual field minimum value, whether with information setting such as map convergent-divergent, font style.
C) the Symbol Style: the Symbol Style information comprises: whether the sideline style information of figure layer, figure layer internal symbol with contents such as high width of filling a type, filling symbol ID, filling symbol SubID, filling symbol spacing XY, filling symbol in map convergent-divergent, the figure layer, through to the setting of these information with symbolism figure layer.
D) style type: the type of playing up to the figure layer has simple pattern, single value pattern, grade separation pattern.
5, data upload warehouse-in provides the batch warehouse-in of multiple common external data forms such as Shp, CAD, GeoDB and goes out library facility.
6, data edge fit, provide the edge fit of line, face to merge and in advance edge fit browse ability, the edge fit support is based on the attribute edge fit with based on spatial relationship edge fit dual mode, and the merging mode of field can be set.
7, data extract provides the library facility that extracts of data, and can be according to any range extracted region data.
8, data backup restoration provides the function that imports and exports to information such as figure layer standard, vector datas, and the backup restore funcitons of various ways is provided.
9, the management of 4D data set; To spatial data 4D data set way to manage is provided; Carry out importing, renewal, the edge fit operations such as (comprising the preview of edge fit) of data according to map sheet, system supports multiple framing modes such as rectangle, trapezoidal, standard map sheet and self-defined map sheet.
10, the issue of data provides the one-touch issuing function of data based on style configuration, is used for spatial data is published to Map Services fast, simplifies alert process with data issuing under the environment greatly.
11, present embodiment also comprises card i/f, is used to support the application demand to spatial database.The particular demands (for example data being carried out the relation of various statistics, analysis space data, various data processing demands) of data on the space being built the storehouse to all parts of the country has designed card i/f; And this card i/f is positioned on the spatial database driving interface; Thereby guaranteed the independence of plug-in unit and GIS platform, had good extendability.Card i/f mainly comprises following 4 interfaces:
(1) query plugin information interface-plug-in unit has the self-described ability, builds the interface of storehouse platform through query plugin, can obtain the information such as title, purposes description, environment dependency need, behavior of plug-in unit.
(2) spatial database connecting object and error logging object are imported in initialization interface-external world, and plug-in unit can carry out initialization here.
(3) display interface-access plug-in unit the interface is set, the user can be provided with various information therein, and clicks and confirm to handle.
(4) discharge internal resource after the release resource interface-plug-in unit operation is accomplished.
11, present embodiment also comprises log recording apparatus, is used for the register system Operation Log.Perfect log recording function is provided, and the log record of native system has following characteristics:
(1) log information is detailed: system journal is divided into the classification of three levels so that the inquiry of daily record and demonstration, and in addition, daily record also comprises: the operation user; Detailed description information; The IP address of client operation, user rs host title, client Mac address; Information such as client's running time, the operation user that can search spatial database through these information easily.
(2) be illustrated in fig. 9 shown below, the daily record classification shows and the inquiry design: show and inquiry log information according to the tertiary level structure, make the daily record tissue become tree structure.
12, to system's installation deployment and upgrade maintenance process the automation tools support is provided: alert at present rapid with business development; Various application demands constantly propose; To spatial data build the storehouse and management is had higher requirement, the whole software system often needs constantly upgrading to improve.
For this reason, propose the spatial database system deployment and should accomplish when using: can create system's table automatically, whether point out that program and system table produces the inconsistent upgrading that needs, can carry out system's table automatically and upgrade thereby can detect automatically and provide.For satisfying this requirement, system provides two automation tools, comprises that spatial database initial creation instrument and spatial database system table detect upgrading tool.
(1) spatial database Library Construction Kit [Microsoft FoxPro]: each GIS platform is built the required database script in storehouse deposit in the different nodes of xml file; A wizard-like instrument is provided; Create table space in order successively, create the user, for subscriber authorisation, carry out all scripts among the xml successively at last, thereby the system of completion table is created.
(2) spatial database system table detects upgrading tool: during the each released version of spatial database Library Construction Kit [Microsoft FoxPro]; Form the more new configuration file of an xml form, this document has write down spatial database system table upgrade corresponding table version number of system and a series of sql statements of the required execution of upgrading at every turn.When whether detection need upgrade, can compare according to the version number of configuration file record in this configuration file and the current database, thereby need to judge whether upgrading.And when carrying out escalation process, begin from the next version of the version number of current database record, carry out more each sql statement in the new configuration file of xml successively, thereby accomplish upgrade function automatically.
Preferably, the geographic information data management system also comprises: update device, be used for the detection system version, and when system version and the version in the more new configuration file that prestores are inconsistent, system is upgraded.
Shown in figure 10, the upgrading idiographic flow is following: the spatial data library software is after login, and the table version number of required system that writes according to system's table version number information and current collector inside compares, and under both inconsistent situation, provides information:
(1), then points out user's usage space Database Systems table to detect upgrading tool and carry out the upgrading of system's table if table version number of the required system of program is higher than the table version number of system that writes down in the current database.
(2) if table version number of the required system of program is lower than the table version number of system that writes down in the current database, the spatial database software package of then pointing out the user to obtain redaction carries out the installation upgrading of program.
Shown in figure 11, geographic information data management method embodiment of the present invention comprises:
Geographic information data to receiving carries out format conversion;
Geographic information data after the conversion is sent to spatial database or GIS platform.
Shown in figure 12, the geographic information data management method of present embodiment is confirmed the zoned format of figure layer identification code behind the geographic information data that receives the GIS platform, according to preset level definition, is corresponding form with said code conversion.
After code conversion, also be that said geographic information data is set up with figure below layer information: figure layer Chinese, display Name or English name, type, description, DISPLAY ORDER, field ordering, compound primary key, filtercondition, field structure.
In addition, also, form special layer and store in the said spatial database according to behind the preset said figure layer of thematic standard extraction.
Geographic information data management method of the present invention and system; Unified standardized management to different GIS platform space databases; Avoid the overlapping development and the maintenance of spatial database under the different GIS platforms, reduced the construction cost of geographical information platform, improved work efficiency.For the application system development on upper strata provides good supporting, for the continuous maintenance upgrade of spatial database brings great convenience.
In addition, the present invention sets up the open-ended standards system of a cover, and to the concrete condition of geographic information data, definition one cover has the code specification and the figure layer standard of good extendibility, can multidata more be brought in the data system to guarantee future.The upper layer application system development that is designed to through the standard management correlation function provides great convenience property and extensibility, has very strong allocative abilities.The entire flow of realization from standard foundation, data loading, quality check, data edge fit, data extract to data issuing satisfies that system is shared data and the demand of exchange.
What should explain is: above embodiment is only unrestricted in order to explanation the present invention, and the present invention also is not limited in above-mentioned giving an example, and all do not break away from the technical scheme and the improvement thereof of the spirit and scope of the present invention, and it all should be encompassed in the claim scope of the present invention.
Claims (10)
1. a geographic information data management system is characterized in that, comprising:
Spatial database is used to store the geographic information data of different GIS platforms;
The GIS platform is used for to said spatial data library storage or obtains geographic information data;
Drive unit is located between different the GIS platform and spatial database, is used to receive the geographic information data of said GIS platform, carries out sending to said spatial database after the format conversion; Or obtain the required geographic information data of GIS platform from said spatial database, be to be forwarded to said GIS platform behind the corresponding form of said GIS platform with its format conversion.
2. geographic information data management system according to claim 1 is characterized in that, also comprises: card i/f is used to support the application demand to spatial database;
Said card i/f comprises: the query plugin information interface, have the self-described ability, and through the interface of query plugin, can obtain title, purposes description, environment dependency need, the behavior information of plug-in unit;
Initialization interface is for importing the spatial database connecting object into and the error logging object carries out initialization in the external world;
The display interface interface is used to set user information;
Discharge resource interface, be used for after operation is accomplished, discharging internal resource.
3. geographic information data management system according to claim 1 is characterized in that,
Said drive unit comprises:
Connecting interface: be used for distribution, establishment, the release of the connection of spatial database;
And/or transaction interface: the affairs that are used for spatial database start, submit to and rollback;
And/or spatial frame of reference interface: be used for enumerating, creating of spatial frame of reference;
And/or list structure maintenance interface: the inquiry of the establishment of attribute list and spatial table, deletion, renewal, list structure, the maintenance of index;
And/or recording operation interface: be used for increase, deletion, the modification to record, the operation of inquiry, pay special attention to inquire about the function that provides according to the spatial dimension inquiry;
And/or enumerated table interface: enumerate attribute list, figure layer and grating image in the spatial database;
And/or lock port: locking is to the read-write operation of attribute list, figure layer object.
4. geographic information data management system according to claim 1 is characterized in that, also comprises: log recording apparatus is used for the register system Operation Log;
Said daily record comprises: IP address, user rs host title, client Mac address and client's running time of operation user, detailed description information, client operation.
5. according to any described geographic information data management system in the claim 1 to 4, it is characterized in that, also comprise:
Update device is used for the detection system version, when system version and the version in the more new configuration file that prestores are inconsistent, system is upgraded.
6. a geographic information data management method is characterized in that, comprising:
Geographic information data to receiving carries out format conversion;
Geographic information data after the conversion is sent to spatial database or GIS platform.
7. geographic information data management method according to claim 6 is characterized in that,
After receiving the geographic information data of GIS platform, confirming the zoned format of figure layer identification code, according to preset level definition, is corresponding form with said code conversion.
8. geographic information data management method according to claim 7 is characterized in that, for said geographic information data is set up with figure below layer information:
Figure layer Chinese, display Name or English name, type, description, DISPLAY ORDER, field ordering, compound primary key, filtercondition, field structure.
9. geographic information data management method according to claim 8 is characterized in that,
Behind the preset said figure layer of thematic standard extraction, form special layer and store in the said spatial database.
10. according to any described geographic information data management method in the claim 6 to 9, it is characterized in that, also comprise: the register system Operation Log.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102809671A CN102402526A (en) | 2010-09-13 | 2010-09-13 | Geographic information database management method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102809671A CN102402526A (en) | 2010-09-13 | 2010-09-13 | Geographic information database management method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102402526A true CN102402526A (en) | 2012-04-04 |
Family
ID=45884741
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102809671A Pending CN102402526A (en) | 2010-09-13 | 2010-09-13 | Geographic information database management method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102402526A (en) |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102841927A (en) * | 2012-07-18 | 2012-12-26 | 福建省新泽尔资讯科技有限公司 | Method and device for data interaction among a plurality of databases and distributed data interaction system |
| CN103198115A (en) * | 2013-03-29 | 2013-07-10 | 中国科学院对地观测与数字地球科学中心 | Target ground object data processing device |
| WO2016043969A1 (en) * | 2014-09-18 | 2016-03-24 | Enki Technology, Inc. | Glass coating specification library |
| CN105631915A (en) * | 2015-12-28 | 2016-06-01 | 中国石油天然气股份有限公司 | Conversion method and device of geological static map |
| CN106383831A (en) * | 2016-08-26 | 2017-02-08 | 王立刚 | DLG update method |
| CN106777001A (en) * | 2016-12-06 | 2017-05-31 | 中国人民公安大学 | The construction method of public security remote sensing monitoring application standards system database |
| CN107577731A (en) * | 2017-08-24 | 2018-01-12 | 南京多伦科技股份有限公司 | A kind of method and system for accessing different spaces database |
| CN107729511A (en) * | 2017-10-24 | 2018-02-23 | 南京市测绘勘察研究院股份有限公司 | A kind of customizable geographic information data rectangular mapsubdivision method |
| CN108182717A (en) * | 2017-12-15 | 2018-06-19 | 北京金风科创风电设备有限公司 | Geographic information image generation method and device |
| CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronous method |
| CN108681813A (en) * | 2018-05-09 | 2018-10-19 | 平安普惠企业管理有限公司 | A kind of blacklist processing method and terminal device |
| CN108764678A (en) * | 2018-05-18 | 2018-11-06 | 天津科技大学 | Industrial and mining enterprises' management information system based on Arcgis |
| CN109284952A (en) * | 2017-07-21 | 2019-01-29 | 菜鸟智能物流控股有限公司 | Method and device for positioning home region |
| CN109522386A (en) * | 2018-12-25 | 2019-03-26 | 武汉众智鸿图科技有限公司 | A kind of spatial Information Service generation method and system across GIS platform |
| CN109710704A (en) * | 2018-11-30 | 2019-05-03 | 武汉烽火众智智慧之星科技有限公司 | A kind of display method for electronic map and device |
| CN110515612A (en) * | 2019-08-22 | 2019-11-29 | 象辑知源（武汉）科技有限公司 | The quick development library of backstage drawing based on Cartopy |
| CN110727897A (en) * | 2019-10-15 | 2020-01-24 | 中国地质调查局发展研究中心 | Geological survey information service rapid publishing method and system supporting multi-terminal operation |
| CN111124288A (en) * | 2019-12-06 | 2020-05-08 | 苏州浪潮智能科技有限公司 | VPD storage management method, device, equipment and readable storage medium |
| CN113760834A (en) * | 2021-09-22 | 2021-12-07 | 北京字跳网络技术有限公司 | File classification method, device, equipment and medium |
| CN115424511A (en) * | 2022-11-04 | 2022-12-02 | 广州市城市规划勘测设计研究院 | Method, device and equipment for territorial space planning and drawing and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1734449A (en) * | 2004-08-09 | 2006-02-15 | 英业达股份有限公司 | Vector computer graphics service method and system |
| US20060282215A1 (en) * | 2005-06-10 | 2006-12-14 | Ling-Yan Bao | Global positioning system with real-time updating |
| CN101275853A (en) * | 2007-03-29 | 2008-10-01 | 三洋电机株式会社 | Navigation apparatus |
| CN101493825A (en) * | 2008-12-17 | 2009-07-29 | 武汉中地数码科技有限公司 | GIS middleware collocation and management method |
-
2010
- 2010-09-13 CN CN2010102809671A patent/CN102402526A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1734449A (en) * | 2004-08-09 | 2006-02-15 | 英业达股份有限公司 | Vector computer graphics service method and system |
| US20060282215A1 (en) * | 2005-06-10 | 2006-12-14 | Ling-Yan Bao | Global positioning system with real-time updating |
| CN101275853A (en) * | 2007-03-29 | 2008-10-01 | 三洋电机株式会社 | Navigation apparatus |
| CN101493825A (en) * | 2008-12-17 | 2009-07-29 | 武汉中地数码科技有限公司 | GIS middleware collocation and management method |
Non-Patent Citations (1)
| Title |
|---|
| 韩双旺: "一种基于XML的WebGIS多源异构数据集成方案", 《中央民族大学学报（自然科学版）》 * |
Cited By (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102841927A (en) * | 2012-07-18 | 2012-12-26 | 福建省新泽尔资讯科技有限公司 | Method and device for data interaction among a plurality of databases and distributed data interaction system |
| CN102841927B (en) * | 2012-07-18 | 2015-04-01 | 福建省新泽尔资讯科技有限公司 | Method and device for data interaction among a plurality of databases and distributed data interaction system |
| CN103198115A (en) * | 2013-03-29 | 2013-07-10 | 中国科学院对地观测与数字地球科学中心 | Target ground object data processing device |
| CN103198115B (en) * | 2013-03-29 | 2016-12-28 | 中国科学院对地观测与数字地球科学中心 | A kind of Target scalar data processing equipment |
| WO2016043969A1 (en) * | 2014-09-18 | 2016-03-24 | Enki Technology, Inc. | Glass coating specification library |
| CN105631915A (en) * | 2015-12-28 | 2016-06-01 | 中国石油天然气股份有限公司 | Conversion method and device of geological static map |
| CN105631915B (en) * | 2015-12-28 | 2019-06-11 | 中国石油天然气股份有限公司 | A kind of conversion method and device of geology static state graph |
| CN106383831A (en) * | 2016-08-26 | 2017-02-08 | 王立刚 | DLG update method |
| CN106777001A (en) * | 2016-12-06 | 2017-05-31 | 中国人民公安大学 | The construction method of public security remote sensing monitoring application standards system database |
| CN106777001B (en) * | 2016-12-06 | 2019-11-15 | 中国人民公安大学 | The construction method of public security remote sensing monitoring application standards system database |
| CN109284952A (en) * | 2017-07-21 | 2019-01-29 | 菜鸟智能物流控股有限公司 | Method and device for positioning home region |
| CN107577731B (en) * | 2017-08-24 | 2020-06-16 | 多伦科技股份有限公司 | Method and system for accessing different spatial databases |
| CN107577731A (en) * | 2017-08-24 | 2018-01-12 | 南京多伦科技股份有限公司 | A kind of method and system for accessing different spaces database |
| CN107729511B (en) * | 2017-10-24 | 2020-12-01 | 南京市测绘勘察研究院股份有限公司 | Customizable geographic information data rectangular framing method |
| CN107729511A (en) * | 2017-10-24 | 2018-02-23 | 南京市测绘勘察研究院股份有限公司 | A kind of customizable geographic information data rectangular mapsubdivision method |
| CN108182717A (en) * | 2017-12-15 | 2018-06-19 | 北京金风科创风电设备有限公司 | Geographic information image generation method and device |
| CN108416043A (en) * | 2018-03-14 | 2018-08-17 | 中煤科工集团重庆研究院有限公司 | Multi-platform spatial data fusion and synchronous method |
| CN108681813A (en) * | 2018-05-09 | 2018-10-19 | 平安普惠企业管理有限公司 | A kind of blacklist processing method and terminal device |
| CN108764678A (en) * | 2018-05-18 | 2018-11-06 | 天津科技大学 | Industrial and mining enterprises' management information system based on Arcgis |
| CN109710704A (en) * | 2018-11-30 | 2019-05-03 | 武汉烽火众智智慧之星科技有限公司 | A kind of display method for electronic map and device |
| CN109522386B (en) * | 2018-12-25 | 2020-10-20 | 武汉众智鸿图科技有限公司 | Method and system for generating spatial information service across GIS platform |
| CN109522386A (en) * | 2018-12-25 | 2019-03-26 | 武汉众智鸿图科技有限公司 | A kind of spatial Information Service generation method and system across GIS platform |
| CN110515612A (en) * | 2019-08-22 | 2019-11-29 | 象辑知源（武汉）科技有限公司 | The quick development library of backstage drawing based on Cartopy |
| CN110727897A (en) * | 2019-10-15 | 2020-01-24 | 中国地质调查局发展研究中心 | Geological survey information service rapid publishing method and system supporting multi-terminal operation |
| CN110727897B (en) * | 2019-10-15 | 2022-12-02 | 中国地质调查局发展研究中心 | Geological survey information service rapid publishing method and system supporting multi-terminal operation |
| CN111124288A (en) * | 2019-12-06 | 2020-05-08 | 苏州浪潮智能科技有限公司 | VPD storage management method, device, equipment and readable storage medium |
| CN111124288B (en) * | 2019-12-06 | 2022-08-12 | 苏州浪潮智能科技有限公司 | VPD storage management method, device, equipment and readable storage medium |
| CN113760834A (en) * | 2021-09-22 | 2021-12-07 | 北京字跳网络技术有限公司 | File classification method, device, equipment and medium |
| CN113760834B (en) * | 2021-09-22 | 2024-04-09 | 北京字跳网络技术有限公司 | File classification method, device, equipment and medium |
| CN115424511A (en) * | 2022-11-04 | 2022-12-02 | 广州市城市规划勘测设计研究院 | Method, device and equipment for territorial space planning and drawing and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102402526A (en) | Geographic information database management method and system | |
| CN100458793C (en) | Mapping conversion method between data access level Xml format data and relational data | |
| US6502088B1 (en) | Method and system for improved access to non-relational databases | |
| CN100445998C (en) | Transactional file system | |
| CN102054025B (en) | Traffic information resource integration processing method and system | |
| US8954480B2 (en) | End-to-end interoperability and workflows from building architecture design to one or more simulations | |
| US20060288014A1 (en) | Method and software for mobile data collection having managed workflow | |
| RU50695U1 (en) | DATA STORAGE AND PROCESSING SYSTEM | |
| CN100579153C (en) | Information management system and information management method | |
| CN100359482C (en) | Dynamic monitoring system and method for data base list update | |
| CN101908165A (en) | Geographic information system (GIS)-based industrial cluster information integration service system and method | |
| CN102279953A (en) | Method for constructing electronic government information resource sharing platform | |
| CN101853305A (en) | Method for establishing comprehensive agricultural environmental information database | |
| CA2412318A1 (en) | Method and apparatus for efficient management of xml documents | |
| CN101388904A (en) | GIS service aggregating method, device and system | |
| CN107679125A (en) | A kind of configuration management Database Systems for cloud computing | |
| CN102722769A (en) | Experimental data processing system and method | |
| US7421450B1 (en) | Database extensible application development environment | |
| CN102842072A (en) | Town cadastre management method and system | |
| CN110990620A (en) | Intelligent transformer substation drawing and document data management method based on intelligent technology application | |
| CN105824905A (en) | Method and device for establishing and operating electronic map aggregated layer | |
| US20030200220A1 (en) | Method, system, and program product for the implementation of an attributegroup to aggregate the predefined attributes for an information entity within a content management system | |
| CN103198140A (en) | Database storage system and data storage method | |
| Kalantari et al. | An interoperability toolkit for e-Land administration | |
| KR100873807B1 (en) | How to Build an Object-Oriented Metadata Repository for Enterprise Data Systems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120404 |