Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Create CNN-style Map in Reporting Services Expand / Collapse
Author
Message
Posted Sunday, March 6, 2011 11:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:56 AM
Points: 9, Visits: 102
Comments posted to this topic are about the item Create CNN-style Map in Reporting Services
Post #1073956
Posted Monday, March 7, 2011 1:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 5:51 AM
Points: 328, Visits: 2,001
Not had a chance to go through it properly but at first skim read that looks like a massively comprehensive article!
Thanks!
Post #1073974
Posted Monday, March 7, 2011 3:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
Really good article, thanks for putting this together...
Post #1074019
Posted Monday, March 7, 2011 5:10 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:49 AM
Points: 1,451, Visits: 1,855
I have not worked on maps, but this article will get me started!

I have just gone through it once, and it is indeed quite thorough - must have taken a lot of time and effort to put this together. Thank-you for the research!


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1074058
Posted Monday, March 7, 2011 5:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 18, 2011 6:09 AM
Points: 1, Visits: 3
I am not sure, but I supose these map tools are available only for USA.
could be great if it is available for Peru for example...

However this post is a great for me. congratulations

Post #1074071
Posted Monday, March 7, 2011 7:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 15, 2011 7:31 AM
Points: 29, Visits: 79
Thanks.

Is it just me or is Michigan wrong, though?
Post #1074163
Posted Monday, March 7, 2011 8:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 10:21 AM
Points: 36, Visits: 152
Question:
Does the database and SSRS have to be at R2 level or can the data be in SQL Server 2008 and then say a seperate instance of 2008 R2 running SSRS?
Post #1074193
Posted Monday, March 7, 2011 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:14 AM
Points: 8, Visits: 80
Very complete article, but there seems to be a lot of re-inventing the wheel here. We already have GIS (Geographic Information System) software that does automatically (in the background) much of what had to be coded. The article also doesn't mention using GIS data already stored in SQL Server, i.e. in an SDE (Spatial Database Engine) geodatabase. While this is specific to ESRI, a very large chunk of GIS data in many organizations is stored that way.

Another concern is turning database people untrained in cartographic principles loose on mapmaking. I have seen extremely misleading maps made by very well-intentioned folks. A good book about this issue is "How to Lie with Maps" by Matk Monmonier. It is very easy for those untrained in spatial thinking to apply the wrong processes to solve a problem, resulting in totally wrong conclusions.

Ray Montgomery
Post #1074202
Posted Monday, March 7, 2011 9:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:56 AM
Points: 9, Visits: 102
Hi,

Thanks for your comment. The Great Lakes shorelines were not carved out in the 2008 census shapefile. In our production environment, we use ESRI state shapefile. With the same parameters discussed in the article, the map looks much better (see attached screenshot). Alternatively, you can use county shapefile (countyp020.tar.gz) from National Atlas and edit out the shorelines yourself. I highly recommend a free tool called fGIS to do the editing. I created a short video (also attached) to show how the editing can be easily done in fGIS. Thanks,

Peichung

Mateo1041 (3/7/2011)
Thanks.

Is it just me or is Michigan wrong, though?


  Post Attachments 
EditOutShoreline.zip (11 views, 2.84 MB)
US.JPG (32 views, 100.30 KB)
Post #1074236
Posted Monday, March 7, 2011 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:56 AM
Points: 9, Visits: 102
Hi Kevin,

Thanks for your comment. Unfortunately, I don't have SQL Server 2008 in our environment to test this. However, I'd think it will work as long as your SSRS runs on R2. Please let us know if you find out otherwise. Thanks,

Peichung


Kevin Rathgeber (3/7/2011)
Question:
Does the database and SSRS have to be at R2 level or can the data be in SQL Server 2008 and then say a seperate instance of 2008 R2 running SSRS?
Post #1074254
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse