Create a New Table

If you choose Create new table, follow these steps:

  1. From the Named Connection drop-down list select one of the named connection. We support the following types of named connections.
    • Choose the file-based connection for uploading data as TAB files.
    • Choose the SQL-based connection for uploading data as SQL table.
    • Choose PostGIS for uploading data to PostGIS database.
  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. If you select SQL-based connection, the default database schema is dbo. If the dbo schema is not available it will show the first schema of the SQL connection. 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, which means a new table is created on the Spatial repository. 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 a new layer to the current map. When you save map project, the new layer is also saved.