For GIS professionals! How to use PostGIS data with SuperMap iDesktopX [Practical Guide]

“Do I need to learn SQL to fully use PostGIS?”

You might have heard that introducing PostGIS can greatly accelerate data analysis, but also worry that it requires specialized SQL knowledge. With SuperMap iDesktopX, even non-experts can take full advantage of PostGIS and unlock the true value of their spatial data.

In this article, we'll show how iDesktopX seamlessly works with PostGIS, along with practical examples of its operations.

Effortless Data Migration with a GUI

The first step is to store your existing data in PostGIS. SuperMap iDesktopX provides intuitive, user-friendly tools for this task.

1. File-based data (e.g., Shapefiles)

Use the Data Import function to migrate datasets simply by specifying a PostGIS data source. You can also enable options such as spatial index creation with one click.

2. Enterprise databases

The Data Migration module supports complex enterprise environments, allowing you to smoothly transfer existing GIS assets into a PostGIS backend.

Edit Data Directly in the Database — Just Like Editing Files

Once connected to PostGIS, the database appears in the iDesktopX Workspace Manager and can be operated just like file data. You can display layers on a map and perform direct editing—adding or deleting features, modifying vertices, and more.
Because the data is centrally stored, multiple users can collaborate efficiently without duplicate data or synchronization issues.

No SQL Required: Advanced Queries & Spatial Analysis via GUI

The real power of PostGIS lies in advanced querying and spatial analysis — and iDesktopX allows you to tap into it without writing a single line of SQL.

• The SQL Query dialog enables you to visually build complex conditions by selecting fields and operators. iDesktopX automatically recognizes PostGIS and generates optimized SQL internally, so you don't need to worry about syntax or database differences.

• For spatial analysis, tools such as buffers, overlays, and other geoprocessing operations automatically convert internally into native PostGIS functions (like ST_Buffer). This query pushdown executes calculations directly on the database server, enabling extremely fast analysis without transferring large datasets to the local machine.

Unlock the Power of PostGIS — No SQL Needed

With SuperMap iDesktopX, you can take full advantage of PostGIS's high-performance analysis and data processing, all through an intuitive GUI.

Whether you are a database beginner or a GIS professional, this combination provides both ease of use and enterprise-level performance.

Source: SuperMap Japan 

https://supermap-japan.blogspot.com/2025/10/gissupermap-idesktopxpostgis.html