Spectrum Spatial (SSA/LIM)

 View Only

How to add a dynamic numeric data column to a table and create a thematic layer with that column in Spectrum Spatial 2019.1

  • 1.  How to add a dynamic numeric data column to a table and create a thematic layer with that column in Spectrum Spatial 2019.1

    Posted 12-18-2019 05:01


    What If I would like to add a column that is s result of a numeric formula to a table and create a thematic layer with that column in Spectrum Spatial?   Like adding the Market Share value column and creating a thematic layer to see it in a Map Project in Spectrum Spatial (Analyst) application.

    Let's see how to add a numeric formula as a data column in a table, create a thematic Layer in Spectrum Spatial Manager, adding and seeing it in a project map of Spectrum Spatial (Analyst) application!


    Suppose I want to calculate the Market Share = 100 * Company Sales / Entire Market Sales, where "Company Sales" and "Entire Market Sales" are two existing columns of a Named Table (tab file, shape file, spatial database table…) and create a thematic layer with the Market Share here below there are the quick and easy steps procedure just using Spectrum Spatial 2019.1, or later!

     

    1.  In Spectrum Spatial Manager (any release), Create a Named View from the Named Table having the two columns above, select your formula from the table as showed in the screenshot Picture 1 below. The result preview is showed in the screenshot Picture 2.
    2.   In Spectrum Spatial Manager (release 2019.1), Create a Range thematic layer using the MarketShare added column in Spectrum Spatial Manager>Create Layer – see picture 3

     

    To see the created thematic layer in Spectrum Spatial (Analyst) application we can either just add the layer in maps using Spectrum Spatial Manager or add directly the layer or the map in Spectrum Spatial (Analyst) application and save the map project!

    We can give permissions on the named layer to a role or user that will let the end user(s) browse and add the layer themselves!

    Picture 1: set the selection with the formula in Spectrum Spatial Manager (any release)

    Picture 1: set the selection with the formula in Spectrum Spatial Manager

    Picture 2: Data Preview  in Spectrum Spatial Manager

    Picture 2: Data Preview

    Picture 3 – creation of the thematic layer in Spectrum Spatial Manager (release 2019.1)

    Picture 3 – creation of the thematic layer in Spectrum Spatial Manager


    ------------------------------
    Monica Di Martino
    EMEA LI/GIS Presales Engineer
    Pitney Bowes
    ------------------------------