Hot answers tagged sqlserver.types
2
No offense, but, actually, the conclusions of your co-worker about how something he thinks should work doesn't make it the "official way" it should work. For that, we refer to the OGC specifications.
You can download the OpenGIS Simple Features Specification for SQL 1.1 from the OGC website (a bit older) or even better, the newer OpenGIS Implementation ...
1
This happens when the ring orientation is not correct. Geometry is more tolerant than Geography. I was doing bulk uploads in the database using ETLs and I was first updating my geometry from text and then using my populated geometry column to update the geography type.
This link helped me a lot and maybe of use to you too ...
1
Basically my co-worker answered my main questions, so I'm punching them in here for the sake of answering the thread. Hopefully a few people will up-vote it, giving it some added credibility.
Q1: Is the ESRI Line Geometry as WKB really invalid?
[Yes.] The wkb says there is 9 points in the line, and then the parser should read 9 points. MS (rightfully) ...
Only top voted, non community-wiki answers of a minimum length are eligible
