Tuesday, December 6, 2016

Geospatial viewer in SQL Anywhere 17

Following globalization and opening of data centers all over the world, visualizing spatial data has become urgent and is supported by applications as well as databases.

SQL Anywhere 17 does have a spatial data viewer and you will have to invoke it in the Interactive. The procedure is as follows:

There is table called SpatialShapes in the 'demo' database which has several geometric shapes in each row of it's SpatialShapes table.

After connecting to the 'demo' database right click the SpatialShapes(GROUPO) table to reveal a drop-down list as shown.


In the above drop-down pick the first option, View data in Interactive SQL. The Interactive SQL windows appears as shown with a Select query.


Click Tools to display the drop-down list.


Click Spatial Viewer in the list to open the Spatial Viewer1 window as shown.


 Click Execute at the bottom of the above window to display the graphic view of the data which consists of a variety of geometrical shapes as shown.


Get the March 2018 Power BI update

The update is out and you can get it from here : You can also get it from Windows Store if you are running Windows 10. Well what is n...