Adding data

DataInsights provides rich data access capabilities. You can add data through the following ways.

Upload files

The following data type files are supported:

• Excel files (*.xls and *.xlsx)
• CSV file with comma delimiter (*.csv)
• GeoJSON file
• Zip package compressed from Shapefile data

To add data via uploading, in the "Add Data" tab, select "Upload File", click "Select File" button, select a file, then click "Upload" to finish adding.

If you upload an Excel or CSV file that contains geographic coordinates, you need to specify the X and Y coordinates with the corresponding fields from data.

If you upload an Excel or CSV file that contains administrative division information, you can select the administrative type ( province or city ) and the corresponding administrative division field in the table. DataInsights will parse the administrative division boundaries automatically and add the data as polygon features.

If you upload an Excel or CSV file that only contains attribute information but without spatial information, you can choose "No coordinate" and add it to DataInsights directly, or you can associate the data with a SuperMap REST data service with location information before visulizing data on map and accessing analysis capabilities. In "Spatial Location" dialog box, select "Code", finish the following settings:

• Original value: The unique identifier in uploaded table used to associate the data service.
• Associated table: The SuperMap REST data service name that has been published in iPortal to be associated.
• Associated field: The corresponding identifier field from the published REST data service. Associated field and original field must correspond one-to-one.

After completing the settings, click the "OK" button to complete the association process.

The uploaded data files are automatically saved to My Data . You can share data files with other iPortal users and use in other apps.

Sample data

DataInsights provides sample data which can be used for testing. In the "Add Data" tab, select "Sample Data", check any data you want to test and click the "Add" button.

Existing data and services in iPortal

DataInsights supports following ways to access existing data and services in iPortal:

• My Data: Includes data files in "My Data" tab in the iPortal, data files shared by others with "Download" permission, and user-managed data stores (such as HDFS, Hadoop Distributed File System). In the "Add Data" tab, select "My Data", check any data you want to add and click the "Add" button.
• My service: Includes registered services and hosted services in "My Services" tab in the iPortal. The service types support SuperMap REST map services and data services. In the "Add Data" tab, select "My Services" and select any service you want to choose. The right side will list all the layers of the service, check one or more layers and click the "Add" button.

After adding the data, you can preview the data in the data page, click the field of the table to sort the data, move the mouse to the field, click on the right side to change the name and type of the field.

Next is to create view operation.