topic How to use Multipolygon data for plotting on google Map API in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Multipolygon-data-for-plotting-on-google-Map-API/m-p/1141016#M917276 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have geography information in SQL DB in below format which needs to be rendered on top of google map. </P><P></P><P>MULTIPOLYGON(((-93.4443156774122 41.8773042774345,-93.4253813007502 41.8773042774345,-93.4254669766627 41.8633194907534,-93.4444013533247 41.863447103002,-93.4443156774122 41.8773042774345)))</P><P></P><P>I can render it in SQL Mgmt Studio as below</P><P></P><P>SELECT geometry::STMPolyFromText('MULTIPOLYGON(((-93.4443156774122 41.8773042774345,-93.4253813007502 41.8773042774345,-93.4254669766627 41.8633194907534,-93.4444013533247 41.863447103002,-93.4443156774122 41.8773042774345)))', 4326);</P><P></P><P><STRONG>But how can I draw it on top of Google Map used in Scatter plot chart? I am using Google Static Map API.</STRONG></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT manishchandra_j 2020-11-25T16:16:04Z How to use Multipolygon data for plotting on google Map API https://community.qlik.com/t5/QlikView/How-to-use-Multipolygon-data-for-plotting-on-google-Map-API/m-p/1141016#M917276 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have geography information in SQL DB in below format which needs to be rendered on top of google map. </P><P></P><P>MULTIPOLYGON(((-93.4443156774122 41.8773042774345,-93.4253813007502 41.8773042774345,-93.4254669766627 41.8633194907534,-93.4444013533247 41.863447103002,-93.4443156774122 41.8773042774345)))</P><P></P><P>I can render it in SQL Mgmt Studio as below</P><P></P><P>SELECT geometry::STMPolyFromText('MULTIPOLYGON(((-93.4443156774122 41.8773042774345,-93.4253813007502 41.8773042774345,-93.4254669766627 41.8633194907534,-93.4444013533247 41.863447103002,-93.4443156774122 41.8773042774345)))', 4326);</P><P></P><P><STRONG>But how can I draw it on top of Google Map used in Scatter plot chart? I am using Google Static Map API.</STRONG></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-Multipolygon-data-for-plotting-on-google-Map-API/m-p/1141016#M917276 manishchandra_j 2020-11-25T16:16:04Z