The SqlGeometry class in MSSQL Server API representing data in a Euclidean (flat) coordinate system.
Questions tagged [sqlgeometry]
68 questions
0
votes
2 answers
Is SqlGeometry.STUnion method thread safe?
Is SqlGeometry.STUnion method thread safe in .Net?
MSDN
Musketyr
- 745
- 1
- 16
- 37
0
votes
1 answer
Cast SqlDouble to double? type causes SqlDouble.Value to raise null value exception
I am trying to construct a linestring using SqlGeometryBuilder.
SqlGeometry point = line.STPointN(x)
gb.BeginFigure((double)point.X, (double)point.Y, (double?)point.Z, (double?)point.M);
The .Z and .M properties of the SqlGeometry return as type…
Maximus
- 1,244
- 10
- 12
0
votes
1 answer
is there is a way to direct convert dbgeometry or sqlgeometry to shape file?
I have a table that contains a SqlGeometry data field I want to export that table to shapefile on asp.net application. Is there is a way to convert the table directly to a shapefile?
If not, is there is an free SDK or tool for writing the shape…
Khalid Omar
- 2,353
- 5
- 35
- 46
0
votes
1 answer
Using SQLGeometry to display an item location on a floor plan in SSRS
Inventory items have a location field corresponding to a physical warehouse location i.e. item X location field states 'A01' corresponds to shelf location A01.
How can I leverage this data to display item locations on a floor plan of the…
user2867960
- 1
- 1
0
votes
0 answers
Valid SQLGeometry object causing "not valid" exception" when running STNumGeometries() on it
I'm using an SQL Server 2008 database which contains an Geometry column and I'm now having problems loading and manipulating that data in CSharp when it hasn't been a problem before.
I have an object which is of the…
Dave Alger
- 339
- 7
- 23
0
votes
1 answer
how can i get the center Point of sqlgeometry arc?
i have Mssql database i'm storing some geometry in database as sqlgeometry
i work in mvc4 project with EF5 i have arcs store in the databse
i can get it form database as dbgeometry then convert it to sqlgeometry for some reasons i want to get the…
Khalid Omar
- 2,353
- 5
- 35
- 46
0
votes
1 answer
Convert SQL Geography to SQL Geometry or otherwise improve lookup speed
THE NEED: I am looking for a SQL statement to convert content of SQL Geography field of a table to SQL Geometry field type, new table field I am going to add to existent table. Or a better solution, hence the post.
REASON: I am looking to speed up…
san_sani4
- 1
- 2
-1
votes
1 answer
How define triangle with SqlGeometry in SQL Server 2012
In SQL Server 2012 a polygon is consists of an exterior ring with zero or some interior rings. So every simple polygon (rectangle, square and ...) must have an exterior ring and
From MSDN:
The following criteria are needed for a ring to be…
Hossein Narimani Rad
- 31,361
- 18
- 86
- 116