Adding GeoJSON and KML Files

Note: This functionality is available to admins and sub-admins only.

You can not directly upload .GeoJSON or .kml file.

Spectrum Spatial Analyst does not allow you to directly upload .GeoJSON or .kml file. However, you can add .GeoJSON or .kml file to the map as a vector layer. You can then upload the data to the Spectrum Spatial repository.

To add a GeoJSON or KML file:

  1. Click or touch the Add icon on the upper right corner of the map to open the Add panel.
  2. Click or touch the Add layer icon.
  3. Choose Add files to map temporarily (csv, xls, GeoJSON, kml)
    The Add a file panel opens.
  4. Browse your computer to select your data file.
    If the selected .GeoJASON or .kml file has missing data, then an error message will appear. You can download the .csv file to see the missing data.
  5. Click on the Add button to see selected data plotted on the map and it is also added to the Map Legend panel with default file name. You can click at any point on the plotted data to see the underlying information in the left hand panel.
  6. Click or touch the Overflow icon and click Upload table to Spectrum Spatial to add the data to Spectrum Spatial repository.
    The name of the vector layer that you have added on the map is displayed and the Upload table panel opens. Next you need to provide the table details.
  7. Choose Create new table or Replace existing table to specify whether you want to create a new table or replace an existing table on the spatial repository. Based on your selection, follow the sub-steps given in the table.
    Options Sub-steps
    Create new table

    If you choose Create new table, follow these steps.

    1. From the Named Connection drop-down list select a named connection type. There are two types of named connections, file-based and database.

      • Choose the file-based connection for uploading data as TAB files.
      • Choose the SQL-based connection for uploading data as SQL table.

    2. Click to specify the File system path.

      • For file-based connection Spectrum Spatial Analyst displays the root folder. By default, Spectrum Spatial Analyst displays the name of first folder in the list on which the user has the write-access.
      • For SQL-based connection, it shows the list of schemas. For more information see, Browsing the Spatial Repository.
    3. In the Datasource table name field, displays the name of the data source. If the name already exists, you can edit the table name.
    4. In the Named table name field, the name of selected table displays. If the table name already exists, you can edit the name.

    5. Click to specify the path of the repository folder on the Spatial Spectrum server. Your table will be saved in this folder.

      Note: While browsing the repository folder, if you cannot locate a folder, check with your administrator to determine if restrictions have been placed at the file-server level. You must have Write permission to the folder that you select.

    6. Click Upload. You get a message that the files have been uploaded. If you wish, you can view the new named table by clicking the hyperlink in the message.

      After the file is uploaded, you can choose to create layer and save it to repository with the default layer style or with your custom styles.

      • The Add layer to project checkbox enables you to add the layer to your map project. By default, it is checked.
      • If required, click to browse the Spatial Spectrum repository and select another folder.
    7. (Optional) Select Define style override, to modify the style for the layer.
    8. Click or touch the Create Layer button to add the layer to the current map. When you save map project, the new layer is also saved.
    Replace existing table

    If you choose Replace table, follow these steps.

    1. In the Named Connection field, click to browse the Spatial Spectrum repository and select the named table that you want to overwrite.

      The selected named table should have the same column structure as the table being uploaded.

    2. Spectrum Spatial Analyst detects the Datasource name to which the table belongs and populates the Named connection and Datasource table name fields.
    3. Click Upload. You get a message that the files have been uploaded and the selected named table is updated. If you wish, you can view the updated named table by clicking the hyperlink in the message.
    4. Click Done to return to the Map legend panel. If a layer in your current map is based on the updated table, the map gets refreshed.