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

---