1. Home
  2. Forum
  3. Dashboard Platform
  4. How to connect a bubblemap to a SQL stored procedure

How to connect a bubblemap to a SQL stored procedure

Hello,

I have a stored procedure that selects the active workers by site(different cities).  I would like to have a bubble for each city that has active workers.  Of course the bubble will be bigger as more active workers are in a city.  How do I do that?  I looked around but I could not make it work.  Thank you

1 Reply
SP Surya Panchanathan Syncfusion Team January 11, 2018 12:15 PM UTC

Hi Nicola,  
 
We don’t have shape files to bind the cities in our built-in Map Widgets in Dashboard Designer. We canload any custom map shape file (as JSON format) to visualize the data in map widget by enable ‘Custom’ option as in the below image:  
  
   
 
  
 
Or,  
  
we can achieve your requirement by using Google Map Custom widget. Please follow the below steps to use the Google Map Custom widget in Dashboard Designer Application.   


 
Step 1 : Need to generate the google map key through the link  
Step 2:  Get the custom widget (GoogleMap.sycw) from the below link.  
 
 
Step 3: Manually need to unzip the GoogleMap.sycw package (need to change the extension as .zip to unzip the package) to replace it with the Key generated from their google account in thewidgetconfig.json file.  



 
  
 
Step 4 : After replacing the key in the widgetconfig.json, they need to zip all the below folder and then change extension as .sycw as in the below screen shots.  
   


 
   
Step 5: After converting it in to .sycw extension, Google Map widget can be imported in the Dashboard Designer and used like the built-in widgets. For information refer the link.  


 
After importing the Google Map Custom widget we can change the icon type either to bubble or markers. By using below option under properties tab.  
 
   




 
Regards,  
Surya  
 
 


Loader.
Up arrow icon