Answered by:
Looking for accurate North American Map for SSRS

-
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
Question
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.
- Proposed as answer by Simon_HouMicrosoft contingent staff, Moderator Friday, September 05, 2014 12:34 PM
- Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Monday, September 15, 2014 2:22 AM
All replies
-
-
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.
- Proposed as answer by Simon_HouMicrosoft contingent staff, Moderator Friday, September 05, 2014 12:34 PM
- Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Monday, September 15, 2014 2:22 AM
-
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
-
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?
- Edited by Patrick Hurst Monday, September 29, 2014 5:28 PM