Polygon shading

Question

How are polygons shaded using values from other columns in table?  For example, there are 4788 polygons representing census block groups, where each polygon will have a color, pattern or gradient based on one of four nominal catagories.

Thanks in advance

Answer 1

In what application?
 - If you're building a report in Reporting Services (SQL Server 2008 R2), then you can do this using a Polygon Color Rule.
 - If you're plotting your data on Bing Maps, you can use the VEShape.SetFillColor() method
 - If you're talking about Management Studio Spatial Results Tab, then you can't adjust the appearance of shapes.

---

Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290

Answer 2

Ok, I downloaded the Reporting Services R2.  It is an adequate thematic mapping tool and easy to use.
BUT, I still cannot display a full dataset either as a linked ESRI shape file or using SQL server spatial view referred to earlier.

Now, when I use a county file w/159 rows either as a spatial table or linked to ESRI shape file all is well!!
However when attempting to view block groups w/4788 rows, I get  a message that the "number of map point elements exceeds the maximum limit for the map.  The remaining points do not appear in the map.", but nothing is displayed.

Answer 3

Hi,

In RS You can increase the maximum number of points. Please follow these steps:

1. Select the Map report item (the topmost map element, not the viewport or any of the internal map elements).
2. Go to the property grid on the side and change the MaximumTotalPointCount from 1,000,000 to let's say 100,000,000.
3. Run your report.

(There is a bug in the August CTP of SQL Server 2008 R2 causing nothing to be shown if either the MaximumTotalPointCount or the MaximumSpatialElementCount limits are hit. This is why you see nothing then you hit the MaximumTotalPointCount limt. The fix for this bug will be available in the next CTP.)

Answer 4

Thank you Ivor,

Your solution works for census tracts, about 1600 rows of data. Before adjusting the total point count to 100M, only about half wer displayed.  However, census block groups, 4788 rows of data, are too much for the report builder to handle --- message: maximum number of points exceeded.

The political geography hierarchy is: state-> county -> census tract -> block group.  So, I will explore building a spatial corresponding spatial hierarchy in SQL server that allows drilling down into counties to show only those census tracts and block groups within a selected county.

Answer 5

Hi Frank,

Can you try setting both the MaximumTotalPointCount and the MaximumSpatialElementCount to 2,000,000,000?

Answer 6

Ivor,


That worked!!!

Thanks
Frank

Answer 7

how do you get to the proprty grid to change the point limit. please send a screen shot.