PostGIS

Export to PostGIS.

PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS). PostGIS follows the OpenGIS Simple Features Specification for SQL and has been certified as compliant with the "Types and Functions" profile.

SIS Desktop 9.1 supports exporting of OGC simple features directly into PostgreSQL databases. SIS Desktop 9.1 can also create new columns and index columns directly in the database.

This is a cursor dataset and supports PostGIS 2.0.

See http://postgis.refractions.net/

Arguments to Export API Method

  • clsExport$

    APostGISExporter
  • params$

    user=uid
    The ID with which to log in to PostGIS

    password=pwd
    Password for the uid

    host=n
    The name, or IP address, of the server hosting the database

    port=p
    The port to which the database listens, set during installation

    database=d
    The name of the database

    layer=l
    The spatial table in PostGIS to export to

    geometry=c
    The column in the PostGIS table which stores the geometry
     
VarcharLen=n
The maximum number of characters that can be stored in the column

overlay=o

Overlay position to export

dimension=n

2 - export two dimensional data

3 - export three dimensional data

srid=srid

Spatial reference identifier, use EPSG code 27700 for OSGB

action=n

0 - create a new table

1 - append to an existing table

createIndex=boolean

True - Create a spatial index

False - Don't create a spatial index

showerrors=boolean

True - Show errors encountered in the export

False - don't show errors

Compatibility:

  • Cadcorp SIS Desktop
  • Cadcorp SIS ActiveX Modeller
  • Cadcorp SIS ActiveX Manager
  • Cadcorp SIS ActiveX Viewer
  • Cadcorp GeognoSIS