Export to Server (PostGIS)
Use File > Export > Export to Server to export a SIS data into a table in POSTgreSQL using the PostGIS Spatial Object-Relational Model.
Note: Ensure the target database has been correctly set up before exporting data to it.
To remember:
- Ensure the data you want to export is in an internal overlay.
- Check the names of the overlay and the schema column are compatible with PostGIS default naming conventions.
- Ensure the data conforms to the OpenGIS Simple Features Specification. Adjust the schema to suit your requirements. See Exporting to PostGIS for details of PostGIS naming conventions.
- Users should ensure that the overlay being exported is compatible with the existing PostGIS table. Cadcorp SIS Desktop 9.1 will not add new attributes if the table definitions do not match.
When appending large volumes of data, PostGIS recommend that indexes on the target table are dropped and recreated after the append process has completed. This allows for faster uploading, and ensures that the spatial index does not degrade. Contact your database administrator for details.
Option | Description | |
Host | The PostgreSQL database server host. | |
Port number | The PostgreSQL database server port. | |
Database | Specify the database name to connect to. | |
User name | The PostgreSQL database user name. | |
Password | The password for the specified PostgreSQL user name. |
Click Next to open the SIS Overlay dialog.
Select the required overlay to export to a PostGIS Spatial Layer and click Next.
The PostGIS Spatial Layer dialog will be displayed:
Select either:
- Create a new PostGIS Spatial Layer, or
- Append to an existing PostGIS Spatial Layer
If you selected Create a new PostGIS Spatial Layer, click Next and the PostGIS Spatial Layer Properties dialog will be displayed:
Click Close.
Click Finish.
If you selected Append to an existing PostGIS Spatial Layer select the existing layer from the list in the PostGIS Spatial Layer dialog and click Finish.