Conditions of the program execution at connecting to the spatial databases, controlled by the DBMS

 Print Previous page Top page Next page

GIS Panorama supports a working with spatial databases under the control of PostgreSQL and Oracle DBMS, providing access to spatial data in accordance with the OGC 06-103r4 standard: «OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 1: Common architecture».

These DBMSs have the integrated support of technology of working with spatial data. In PostgreSQL DBMS this is achieved using the PostGIS extension, in Oracle DBMS - Oracle Spatial. Also GIS Panorama supports a work with spatial databases ArcSDE under control of Oracle DBMS, for this, the ArcSDE extension (st_shapelib.dll) must be installed in the Oracle DBMS.

To access spatial databases, an x64-bit set of client libraries of the corresponding DBMS is required. PostgreSQL client libraries are included into the GIS Panorama. To access the Oracle databases, you must additionally install Oracle Call Interface (OCI).

To provide the ability to track changes in tables of spatial data in the GIS Panorama, a change log table must additionally be created in the database, and also a set of functions and triggers required for its maintenance. The absence of a log table in the database is not an obstacle for working with this database, but it makes it impossible to update the cartographic representation in the GIS Panorama window in case of changes in the source dataset.

The user on whose behalf, a connecting to the database in GIS Panorama is performed must have certain powers:

-  to all tables with the data synchronised with a map, permissions to read and write (SELECT, INSERT, UPDATE and DELETE) are necessary;

-  to the table of the change log - for reading (SELECT).

 

The coordinate system and projection parameters of the spatial description of objects in the database must be properly registered in the database and must be able to be converted to the coordinate system of the cache map and back by means of the DBMS itself. The coordinate system of the cache map is set according to the settings of the DBM file using the EPSG code.

The following geometry types of OGC 06-103r4 standard are supported: «OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 1: Common architecture»:

-  Point;

-  Line;

-  Polygon;

-  Multipoint;

-  Multiline;

-  Multipolygon.

 

The primary key of data sets (or other field, which value is underlined as the unique identifier of record) cannot be compound and should consist of one field having INTEGER type (whole 4 byte).

In case of performing updates using the change log, the following restrictions are additionally imposed:

  1. Data sets (database tables) should not have fields with the following names (coinciding with the names of the log):

­-   schemaname;

-   tablename;

-   idrecord;

-   changestype;

-   userid;

-   stamp;

-   sessionident.

  1. It is not recommended to use field names that are DBMS reserved words or SQL terms.

 

Specifics of working with Oracle DBMS;

Specifics of working with PostgreSQL DBMS;

Specifics of working with ArcSDE geodatabases in Oracle databases.