Spectrum Spatial (SSA/LIM)

Is it possible to create an "on the fly" field for the info panel that displays the area of the selected polygon, or does this data need to be added as part of the data preparation?

Hi Tim,

I've done this as part of the data preparation myself, but have you tried creating a "View Table" in Spatial Manager?

Instructions within Spatial Manager say: "Create a view table using either the Simple or Advanced tab. Simple allows you to select a subset of columns from a single named table. Advanced allows you to use MI SQL to create complex views."

Hi @Tim Warfe? ,

I would suggest to use a View of the table as @James Nolet? wrote. You might create a view of the table in SSM (Spectrum Spatial Manager). Using the Advanced tab you can put your MISQL syntax. For getting the area you can put "MI_AREA(obj, 'sq mi', 'Spherical') as Area" int the select. For example,

SELECT Obj, MI_Style, Name, Population, MI_AREA(obj, 'sq mi', 'Spherical') as Area FROM "/Demo_SSA/Regions/"

MISQL (MapInfo SQL) details can be found here

http://support.pb.com/help/spectrum/12.2.1/en/webhelp/Spatial/index.html#Spatial/source/misql/misqlapiguide/introduction/introduction.html

Thank you @James Nolet? and @Monica Di Martino? , Perfect!!!!!! Is there any way to add my thematic back to this layer/map after the view is created??

Hi @Tim Warfe? ,

Yes, it is - even if Spatial Map Uploader doesn't upload a View for creating a Named View and a Named Layer of the View. I would suggest to

• create the View in SSM as A
• go to MapInfo Pro using a table B that has the same structure of A prepare your thematic layer in to the map. Upload the map with the thematic layer of B using Map Uploader
• after these steps you will have the View Table A, View Table B, Layer of B and a map with B, You need to rename Table A with the name of the table B - before of this rename B without deleting Layer and Map of B

if A and B they have the same name columns - it should be work. I have already used this procedure in the past. Don't hesitate to ask us for supporting if you need more.