Create CNN-style Map in Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Peichung Shih » Create CNN-style Map in Reporting Services

25 posts, Page 1 of 3

1 2 3 »»»

Create CNN-style Map in Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Peichung Shih

Posted Sunday, March 06, 2011 11:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:18 PM
Points: 9, Visits: 71

Comments posted to this topic are about the item Create CNN-style Map in Reporting Services

Post #1073956

Samuel Vella

Posted Monday, March 07, 2011 1:02 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329, Visits: 1,869

Not had a chance to go through it properly but at first skim read that looks like a massively comprehensive article!
Thanks! w00t

Post #1073974

steveb.

Posted Monday, March 07, 2011 3:28 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 8:56 AM
Points: 2,802, Visits: 7,110

Really good article, thanks for putting this together...

Post #1074019

Nakul Vachhrajani

Posted Monday, March 07, 2011 5:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282, Visits: 1,613

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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1074058

lbarrueto

Posted Monday, March 07, 2011 5:38 AM

Forum 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

Mateo1041

Posted Monday, March 07, 2011 7:38 AM

SSC 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

Kevin Rathgeber

Posted Monday, March 07, 2011 8:16 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 2:31 PM
Points: 36, Visits: 151

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

rmontgom

Posted Monday, March 07, 2011 8:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 06, 2012 1:37 PM
Points: 5, Visits: 62

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

Peichung Shih

Posted Monday, March 07, 2011 9:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:18 PM
Points: 9, Visits: 71

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 (10 views, 2.84 MB)

US.JPG (30 views, 100.30 KB)

Post #1074236

Peichung Shih

Posted Monday, March 07, 2011 9:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:18 PM
Points: 9, Visits: 71

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 »

25 posts, Page 1 of 3

1 2 3 »»»

Permissions