Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

SQL Data Bind display options in Info Panel??

  • 1.  SQL Data Bind display options in Info Panel??

    Posted 10-01-2018 03:54

    Hi guys,

    I've successfully added a live SQL Databind into SSA. (MSSQL Corporate Aspatial data)

    I've noticed I can only display the data bind information relating to a selected object/layer by clicking the dots near the layer heading in the Info Bar. (With the export to CSV option)

    Can this data be displayed as a separate feature line and section within the Info bar?? (In the same way native tables are displayed)

    Thank you.

    Tim

     



  • 2.  RE: SQL Data Bind display options in Info Panel??

    Posted 3 days ago
    I dont think you can, You can incorporate information in SQL view as a column  and then present it in SSA template

    ------------------------------
    Noman Sajjad
    Campaspe Shire Council
    Echuca
    ------------------------------



  • 3.  RE: SQL Data Bind display options in Info Panel??

    Posted 2 days ago
    Edited by Duri Bradshaw 2 days ago
    Hi Tim,

    As Noman says the best way to achieve this is to merge the aspatial data with your spatial data, this can either be done using a view in SQL or if this it too slow or impossible you may need to merge the data off-line and save it as a merged table.

    ------------------------------
    Duri Bradshaw
    Spatial IT Consultant
    Insight GIS
    ------------------------------