Skip to main content
Solved

Cannot create linear geometry in SQL Spatial

  • March 19, 2015
  • 1 reply
  • 22 views
E
Hi Group,

 

 

I can easily create point geometry using the SQL Spatial Writer in FME however I can't create linear geometry or polygons (using shp or tab files as source).

 

 

I get "MS SQL Server (Spatial) Writer: Failed to get the SQL Server native binary form for column 'Geom'"

 

 

Any ideas?

 

 

Thanks.

Best answer by ken

Hi EB

 

This error is typically give by SQL Server itself when the geometry we send it from FME is somehow invalid.  A few common reasons:

 

- if your column is "geography" then the feature must be in lat long have geometry within the valid lat long range of numbers. You can use a Reprojector transformer

 

- self-intersecting features may also cause this error

 

 

You might try using the GeometryValidator to look for self-intersecting features or other invalid geometries. Failing that you could send a sample of this data to us in support (safe.com/support) and we can take a look.

 

Thanks

 

Ken
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

K
Forum|alt.badge.img
  • ken
  • Best Answer
  • April 1, 2015
Hi EB

 

This error is typically give by SQL Server itself when the geometry we send it from FME is somehow invalid.  A few common reasons:

 

- if your column is "geography" then the feature must be in lat long have geometry within the valid lat long range of numbers. You can use a Reprojector transformer

 

- self-intersecting features may also cause this error

 

 

You might try using the GeometryValidator to look for self-intersecting features or other invalid geometries. Failing that you could send a sample of this data to us in support (safe.com/support) and we can take a look.

 

Thanks

 

Ken

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.