none
Looking for accurate North American Map for SSRS

    Question

  • Hi everyone,

    I'm trying to create a report with bubbled North American map which shows the rate of accidents happened on highways. However

    The original maps in ssrs are only American maps, and shapefiles I find from random websites are not accurate enough. Is

    there a source  I can find some professional maps even though it requires to purchase?

    thanks,

    MING

    Thursday, September 04, 2014 12:49 PM

Answers

  • SSRS integrates with BING.

    Create a new map object. Select SQL Server Spatial Query, Choose your Dataset, Select the column containing the geographic co-ordinates (which can be easily converted using SQL Servers spatial functions) and at the bottom of this window, select Add a Bing Maps layer.

    And there you have it. Your points mapped to anywhere in the world.

    Depending on the data you have, you can convert it to spatial data by using Geography:Point(lat,long,4326) (4326 is rather arbitrary as it is the standard used world wide for mapping).

    I have used this technique to do all sorts of geolocation data reporting.

    Thursday, September 04, 2014 2:18 PM

All replies

  • Hi Ming,

    Did you try Microsoft MapPoint?

    Thanks.


    Remember to mark as an answer if this post has helped you.

    Thursday, September 04, 2014 1:37 PM
  • SSRS integrates with BING.

    Create a new map object. Select SQL Server Spatial Query, Choose your Dataset, Select the column containing the geographic co-ordinates (which can be easily converted using SQL Servers spatial functions) and at the bottom of this window, select Add a Bing Maps layer.

    And there you have it. Your points mapped to anywhere in the world.

    Depending on the data you have, you can convert it to spatial data by using Geography:Point(lat,long,4326) (4326 is rather arbitrary as it is the standard used world wide for mapping).

    I have used this technique to do all sorts of geolocation data reporting.

    Thursday, September 04, 2014 2:18 PM
  • thank you for the answer, I gave a try on your suggestion.

    But there are 2 problems that I don't know how to deal with.

    1, I can zoom in/out on design mode, but it's just a screen shot on preview mode. Since I'm making a bubble map, users need to access the map as they wish.

    2, there will be a connection error pop out while query is depend on parameters, and the error stops any further steps.

    Please shoot me with any answers, ty

    Monday, September 29, 2014 3:42 PM
  • SSRS's Map object is not interactive. It does, however, dynamically size the viewport based on the data it's going to display. If you plot co-ordinates in Canada, and Australia, for example, the viewport will display a world map. If you plot co-ordinates for Birmingham and Southampton it will show you just the southern area of England. The solution to your problem would be to allow the user to specify how much data they want. The map will then 'zoom' to just that area.

    Your second question doesn't make sense to me, can you clarify?


    Monday, September 29, 2014 5:28 PM