The well-known Binary (WKB) not available when preview report

Question

Hi,

I have programmatically created my shapefiles. These shapefiles are to be import to my map report as a map layer. In design mode, I can see the map layers which I have cdreated. However, when i switch to preview mode, 'The well-known binary (WKB) is not valid message was displayed. May I know what could have gone wrong with my shapefiles?

Thank you.

---

Mai

Answer 1

Hi Mai,

I will involve someone more familiar with this topic for a further look at this issue.  Thanks for your understanding.

Best Regards,
Stephanie Lv

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hello Mai,

 

You can try the solution suggested in the following thread:

http://social.msdn.microsoft.com/Forums/en-AU/sqlreportingservices/thread/a5bb6d3c-6e4e-4b95-96ee-335c802b2cbf

When you specify a shape file as a spatial data source and it is located on your local computer, the spatial data is automatically embedded in the report. To use spatial data from an ESRI file dynamically, you must do the following:

Upload both the .shp file and the .dbf file to the same folder on a report server, and then link to the .shp file as the spatial data source.

For more information about the topic, please see the following article,
Maps (Report Builder 3.0 and SSRS): http://msdn.microsoft.com/en-us/library/ee240845(SQL.105).aspx 

 

FYI - SQL lets you store & retrieve any combination of points to make any geometry you like. But if you do create some convoluted shape which twists & turns over itself, it is often impossible to determine what you've described. So most of the methods will fail. A polygon that crosses over itself is really a multipolygon containing polygons which just touch each other. A Line which draws over itself is really a multilinestring i.e., A Shape is valid where it does NOT cross over itself. Be diligent, when you create shapes, ensure that you are forming them correctly, especially geography shapes which do not have a MakeValid Method. You can only perform calculations on Valid Shapes.

http://blogs.msdn.com/b/davidlean/archive/2008/11/01/sql-2008-spatial-samples-part-2-of-n-background-on-spatial-types-well-known-text-wkt.aspx

 

 

Regards,
Swetha

---

Microsoft Online Community Support
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

 

 

---

Swetha

Answer 3

Swetha - just to correct you on a few points:

It's perfectly valid to have a LineString geometry that crosses over itself. Take, for example:

DECLARE @l geometry = 'LINESTRING(0 2, 10 2, 10 0, 8 4, 6 0, 4 4, 2 0, 0 4, 0 2)';

SELECT
@l,
@l.STIsValid();  -- 1

 

In SQL Server 2008/R2 the MakeValid() method only exists for the geometry datatype. As of SQL Server 2012, this method can be applied to the geography datatype as well. See http://msdn.microsoft.com/en-us/library/ff929337%28v=SQL.110%29.aspx

---

twitter: @alastaira blog: http://alastaira.wordpress.com/