Integrating Maptitude and PostgreSQL

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

- PostgreSQLCommand Class

- PostgreSQLConnect

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.