Uploading a CSV File

You can upload data from .csv files to Spectrum spatial repository and then add the layer to the current map. You can upload a new file or replace an existing file on the repository. When adding CSV or XLS as spatial data, you need to specify coordinates (longitude and latitude).

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

Examine your data before uploading:

  • Make sure that column separator is comma. If the record delimiter is not comma, then you gets the option to choose decimal character. If you have French locale file, choose comma as delimiter. For English locale choose decimal.
  • While uploading a .csv file, whole column is dropped if column name is blank in the file.
  • In case of duplicate column name, the values from last column is picked only and duplicate columns will not be displayed in callout, query and download.
  • The first row (header) should contain column title and all other columns should have data. If a file does not contain any header then default column names are displayed, like column1, column2, column3 etc. in query, callout and downloaded file.

To upload a .CSV 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 Upload Files to Spectrum Spatial (.TAB, .shp, .csv, .xls)
    The Upload files panel opens. This panel will guide you through the upload process. Follow the instructions given under Checklist before Upload to avoid error.
  4. Click or touch the Choose file ... to browse your computer and select your data file.

    After you select the file, Spectrum Spatial Analyst verifies the selected files. In case of any validation error, you can click Choose different file... again to choose the correct files.

    The Upload files panel opens.
  5. Choose one of the following options and click Next.
    Option Description
    Coordinates

    Use this option if your source file contains X, Y or lon/lat columns. Spectrum Spatial Analyst automatically reads the correct column from the chosen source file and displays it. You can change Projection and X/Longitude or Y/Latitude from the drop-down list.

    If required, specify projection from the Projection drop-down list. After the layer is added, the points will be directly shown on the map as a business layer.

    Addresses

    Use this option if your source file contains an address column. The addresses will be geocoded and points will be shown on map as a business layer. Spectrum Spatial Analyst automatically reads the address column from the source file and displays it. The geocoded data is then uploaded to the named table on the Spectrum Spatial repository.

    If required, change the address column from the Select address column drop-down list.

    This option is available only when Global Geocoding or LI API geocoder module is selected as the Geocoder by the Administrator. For more information see, Geocoding the Address Data.

    Non-spatial

    Use this option if your source file does not contain data for geometry. In this case the table on the repository is updated, however, the data is not plotted on the map.

    With a non-spatial table, you do not get the option to add it to the map. Non-spatial tables will need to be joined to aspatial table in Spectrum Spatial Manager using a named view, and then a named layer can becreated, referencing the named view.

  6. 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

    Create a new table

    Replace existing table

    Replace an existing table