Questions tagged [sqlserver.types]
The sqlserver.types tag has no usage guidance.
6
questions
2
votes
1answer
467 views
Can't convert a WKT with a Z value into a SQL Geometry value
I'm using nettopologysuite in c# to build a nettopology geometry object, and then save it as a geometry object in SQL. Generally this works fine, except i recent came up with (from a shapefile) the ...
4
votes
1answer
1k views
Creating C# SqlGeography point with Z value? [closed]
In C#, there appears to be only one method to create a SqlGeography Point object. It takes a lat/lon and SRID. But it can also have a Z and M value.
How are these created?
The Point class is ...
5
votes
1answer
3k views
Is it possible to get coordinate system name from SQL Server geometry type?
I need to get the name of the coordinate system of a geometry type field in SQL Server 2008 R2 (for example NAD_1983_UTM_Zone_14N or GCS_WGS_1984 or other). Is this possible?
1
vote
1answer
2k views
Insert XY table data into SQL Spatial column
ArcGIS Server 10.1.1 SQL Server Standard 2012
Current workflow is user submits a table (text file) containing lat-long data (same spatial reference each time); SQL Server Integration services pushes ...
5
votes
1answer
2k views
STGeomFromText not working on large polygons
I'm using Microsoft.SqlServer.Types to do intersections on polygons.
SqlChars scFullSwath = new SqlChars(new SqlString(fullSwath));
SqlGeography fullSwathGeom = SqlGeography.STGeomFromText(...
6
votes
2answers
2k views
A bug in ESRI Line Geometry WKB that adds needless, trailing 0's behind otherwise valid WKB?
[Update 7.13.2012]
My coworker noticed the the ESRI Line WKB is malformed contains unspecified trailing data, and since he's not active on GIS.SE, I posted his remarks as an answer. I'll wait a few ...
