Current location:

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 supports exporting of OGC simple features directly into PostgreSQL databases. SIS 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 Map Modeller
Cadcorp SIS Map Editor
Cadcorp SIS Map Manager
Cadcorp SIS ActiveX Modeller
Cadcorp SIS ActiveX Manager
Cadcorp SIS ActiveX Viewer
Cadcorp GeognoSIS

See full list of Export Formats

Send comments on this topic.

Click to return to www.cadcorp.com