Structured Data Configuration

For structured data stored in CSV, Excel, and GeoJSON formats, SuperMap Copilot provides the ability to upload, download, and import data into PostgreSQL/Yukon databases, obtain field statistics and generate MVT tiles.

Before use, the AI Assistant administrator must go to the SuperMap iPortal management page to configure PostgreSQL/Yukon as the structured data storage. After configuration, you can use the built-in sample data in Copilot, and upload structured data stored in CSV, Excel, and GeoJSON formats.

Using PostgreSQL as Structured Data Storage

You need to complete the installation and configuration of the PostgreSQL database and then proceed with the PostGIS Installation and Configuration to extend PostgreSQL's ability to store and manage spatial data.

After completing the database installation and configuration, log in to the SuperMap iPortal homepage as an administrator, go to "Management" > "Site Configuration" > "Data Storage," and select the "Structured Data Storage" tab to enter the structured data configuration page:

  • Service Address: Enter the address of the spatial database in PostgreSQL used to store structured data, such as 127.0.0.1:5432/postgis_24_sample.
  • Username: Enter the username used to log in to the database.
  • Password: Enter the password used to log in to the database.

After filling in the information, click Save.

Using Yukon as Structured Data Storage

Yukon (禹贡) database, based on openGauss, extends the ability to store and manage geospatial data, providing professional GIS functions and empowering traditional relational databases.

SuperMap iPortal is compatible with Yukon 1.0.1. Structured data uploaded in AI Assistant can be stored in Yukon's spatial database. Before this, you need to complete the installation and configuration of Yukon.

After completing the database installation and configuration, log in to the homepage as an administrator, go to "Management" > "Site Configuration" > "Data Storage," and select the "Structured Data Storage" tab to enter the structured data configuration page:

  • Service Address: Enter the address of the spatial database in Yukon used to store structured data, such as 127.0.0.1:5432/yukon.
  • Username: Enter the username used to log in to the database.
  • Password: Enter the password used to log in to the database.

After filling in the information, click Save.