| Maptitude GISDK Help |
Maptitude permits a seamless integration with PostgreSQL. Using dedicated GISDK functions, users can effortlessly connect to PostgreSQL databases and execute SQL queries directly within the Maptitude environment. This capability streamlines data access and analysis, enabling users to harness the power of spatial data stored in PostgreSQL databases without leaving the Maptitude interface.
Maptitude's GISDK provides a comprehensive set of functions tailored specifically for PostgreSQL integration. These functions encompass a wide range of operations, including data retrieval, manipulation, and analysis.
Below is a list of the relevant GISDK functions to interact with postgres
| Function | Summary |
|---|---|
| AddPGSQLLayer() | Add layer to map after exporting it to postgres spatial database |
| AddPGSQLLayerToWorkspace() | Add layer to current workspace after exporting it to postgres spatial database |
| ExportPGSQL() | Export map data to postgres spatial database |
| PGSQLClose() | Close the connection with postgres , if it exists |
| PGSQLConnect() | Establish a connection with postgres |
| PGSQLExportFromQuery() | Run an SQL query on the open postgres database connection and export results to a file |
| PGSQLGetDatabases() | Retrieve a list of postgres databases from the connected database server |
| PGSQLGetSchemas() | Retrieve a list of schemas from a postgres database |
| PGSQLGetSpatialDatabases() | Retrieve a list of postgres spatial databases from the connected database server |
| PGSQLGetTables() | Retrieve a list of tables from a postgres database |
| PGSQLGetUniqueFields() | Returns all unique fields from the postgres database table, as defined in the table constraints |
| PGSQLRunQuery() | Run an SQL query on the open postgres database connection |
| PGSQLSetDatabase() | Set database as the current selection in the “Open PostgreSQL Table” dialogue box |
| PGSQLSetSchema() | Set the name of the database schema to be displayed to the user in the “Open PostgreSQL Table” dialogue box |
| PGSQLSetTable() | Set the name of the table to be displayed to the user in the “Open PostgreSQL Table” dialogue box |
The following classes also provide methods to open a connection and run asynchronous queries
By leveraging these PostgreSQL functions within Maptitude's GISDK, users can harness the full potential of spatial data stored in PostgreSQL databases, integrating it seamlessly into their workflows for informed decision-making and analysis. Whether it's querying spatial data, performing complex geospatial analysis, or visualizing results, Maptitude's GISDK offers a versatile toolkit for unlocking the value of PostgreSQL data within the mapping software environment.
| ©2025 Caliper Corporation | www.caliper.com |