Structured data configuration

For structured data stored in CSV, Excel, and GeoJSON formats, SuperMap iPortal provides the ability to upload data, download data, import data to PostgreSQL database, obtain field statistics, and obtain mvt tiles of data. Currently, MapStudio WebAPP supports docking with structured data. Before using it, the iPortal administrator needs to configure the connection information of the PostgreSQL database that the structured data depends on.

Using PostgreSQL Database as Structured Data Store

The structured data uploaded in the MapStudio WebAPP needs to be stored in the PostgreSQL spatial database. Therefore, you need to install and configure the PostgreSQL database, and then install and configure the corresponding version of PostGIS to expand the ability to store and manage spatial data.

After completing the installation and configuration of the database, log in to the portal home page as an administrator, and click Management> Site Configuration> Data storage to enter the Structured data storage page:

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

When finished, click the "Save" button.