Find ESRI Shapefiles for a SQL Server 2008 R2 Reporting Services Map (SSRS)
ESRI shapefiles contain data that complies with the Environmental Systems Research Institute, Inc. (ESRI) shapefile spatial data format. ESRI shapefiles are available on the Web from a variety of sites. The term "shapefile" applies to a set of related files. To add a map to a report, you must have both the .shp file that contains spatial data and the matching .dbf file that contains supporting information.
Note Spatial data and other data that is contained in ESRI shapefiles can be politically sensitive and possibly copyrighted. Check the terms of use and privacy statements for the ESRI shapefiles to understand how you can use spatial data in your report.
Finding ESRI Shapefiles from Public Domain Sites
You can download ESRI files from public domain data sources on the Web, including government and university sites. For example, the built-in map feature in SQL Server 2008 R2 Reporting Services uses data from TIGER/Line Shapefiles provided courtesy of the U.S. Census Bureau (http://www.census.gov/). TIGER/Line Shapefiles are an extract of selected geographic and cartographic information from the Census MAF/TIGER database. TIGER/Line Shapefiles are available without charge from the U.S. Census Bureau. To obtain more information about the TIGER/Line Shapefiles go to http://www.census.gov/geo/www/tiger. The boundary information in the TIGER/Line Shapefiles are for statistical data collection and tabulation purposes only; their depiction and designation for statistical purposes does not constitute a determination of jurisdictional authority or rights of ownership or entitlement and they are not legal land descriptions. Census TIGER and TIGER/Line are registered trademarks of the U.S. Bureau of the Census.
Finding Spatial or Other Commercial Data from Windows Azure™ Marketplace DataMarket
The DataMarket section of Windows Azure Marketplace, formerly known as Codename Dallas, includes data, imagery, and real-time web services from leading commercial data providers and authoritative public data sources. DataMarket includes datasets, imagery, and real-time web services from leading commercial data providers and authoritative public data sources into the Windows® Azure™ Platform. For more information, see http://www.microsoft.com/windowsazure/sqlazure and http://www.microsoft.com/windowsazure/marketplace/default.aspx.
Feedback or Questions?
If you have feedback about Reporting Services maps, please submit it at Microsoft SQL Server Connect Feedback Center.
For questions, please post your question to the Reporting Services Forum.