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.
Using Yukon Database as Structured Data Storage
Yukon database, based on openGauss database, extends geospatial data storage and management capabilities, provides professional GIS functions, and empowers traditional relational databases.
SuperMap iPortal is adapted to Yukon version 1.0.1. Structured data uploaded in MapStudio WebApp can be stored in Yukon's spatial database. Before that, you need to complete the installation and configuration of Yukon database.
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 Yukon, such as: 127.0.0.1:5432/yukon.
- 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 you are done, click Save.