Stack Overflow
Stack Overflow

Questions tagged [sqlgeometry]

The SqlGeometry class in MSSQL Server API representing data in a Euclidean (flat) coordinate system.

68 questions
0
votes
1 answer

ST_GeomFromText in PDO returns error (php)

I am currently coding the backend service for my android apps, and since it is not my specialty, I am confused as to why i got this error. The purpose is to save a list of location coordinate into geometry data in my database from my apps. At first,…
user3576118
  • 375
  • 1
  • 5
  • 24
0
votes
0 answers

Create geography polyline(s) from points for many features in same table in T-SQL

A similar question has been asked here: Create geography polyline from points in T-SQL I have a table schema that looks like this: CREATE TABLE [dbo].[LongAndLats]( [Longitude] [float] NULL, [Latitude] [float] NULL, [SortOrder] [bigint]…
user3799279
  • 143
  • 1
  • 11
0
votes
0 answers

SQL Spatial: STIntersection radius

my database contains different objects like Polygons and Points. Each point is stored with a individual radius and index. I retrieve all objects within a point radius with following sql query. declare @g geometry select @g = Geom from obj where…
Jacks
  • 67
  • 5
0
votes
1 answer

SqlServer spatial index/filtering

I have an interesting problem. I have a select statement generated by GeoServer on a de-normalized table. The structure of the query is this select "the_geom".STAsBinary() as "the_geom" from TABLE where [a bunch of ands and ors condition] …
Perfa
  • 81
  • 4
0
votes
1 answer

Proper format to request sde.st_intersects with a Well Known Binary input from C#

I am using ArcSDE and Oracle with the ST_GEOMETRY spatial type. I'm writing C# code using SqlGeoemtry types. What i want is to be able to request an intersect but use wkb instead of wkt. I know it works with wkt but if my feature has many vertices I…
VBAHole
  • 1,508
  • 2
  • 24
  • 38
0
votes
1 answer

Looking for the opposite of SqlGeometryBuilder: How can I decompose a SqlGeometry?

I know how to compose a SqlGeometry using SqlGeometryBuilder, for example: // using Microsoft.SqlServer.Types; SqlGeometryBuilder geometryBuilder = new…
stakx - no longer contributing
  • 83,039
  • 20
  • 168
  • 268
0
votes
1 answer

SqlGeometry in C++ Application?

I've used Microsoft's SqlGeometry from Microsoft.SqlServer.Types in a C# application and was quite happy with the performance. I saw that it's actual functionality is contained in a native library, SqlServerSpatial110.dll (or another number,…
Matz
  • 583
  • 1
  • 6
  • 21
0
votes
0 answers

C# SqlGeometry DataTable.WriteXml

I have a table in SQL Server with a column of type SqlGeometry. I am loading the DataTable, then I'm executing DataTable.WriteXml. Unfortunately, the data from the column of type SqlGeometry is not written out. DataTable dt = new…
promwand
  • 11
  • 2
0
votes
0 answers

SQL Server geometry STIntersects Area

I have some shapes in my db stored as geometry polygon and I want to check: 1- They don't overlap eachother. 2- No problem if having a shared edge or corner. I tried STIntersects and it works fine for rule 1 but it returns true for neighbor shapes…
Hosein
  • 581
  • 1
  • 7
  • 29
0
votes
1 answer

Issue with SQLGeography STUnion & inner rings for drawing polygons on Bing Maps WPF control

I am writing an app using Bing API Spatial Data services to take of list of zip codes and combine them into one region. I have it mostly working but it seems to have issues with inner rings. Instead of a) deeming the inner region too small and…
Hershizer33
  • 1,206
  • 2
  • 23
  • 46
0
votes
1 answer

SQL Server Geography Query works but Geometry Query Does Not - Different Tables, Similar Schemas

I am trying to get a Geometry query to work. A similar Geography query works fine but I must work with a table that uses a Geometry type. Although the Geography version returns lots of records as expected, I cannot get the Geometry version to return…
ChrisCurrie
  • 1,589
  • 6
  • 15
  • 36
0
votes
1 answer

Verify a lat/long coordinate is in a SQL spatial table on geography column

We have a spatial table (dbo.Map) with eleven polygons representing eleven regions. This table has unique IDs, names, and other meta data associated with it, as well as a geography data-type column called geo. We also have a separate table…
MatthewHoza
  • 1
  • 2
0
votes
1 answer

All shapes with X miles or meters using SqlGeometery

My table uses a SqlGeometery in SRID 3857. Given a point, how would I find all shapes within a X miles or meters radius?
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
0
votes
1 answer

Convert coordinate systems using SQLGeometery

One of my shape files looks like this: POLYGON ( -91.513078999999991 36.970298, -87.01993499999999 36.970298, -87.01993499999999 42.508337999999995, -91.513078999999991 42.508337999999995, -91.513078999999991 36.970298) Another file…
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
0
votes
2 answers

Corners from a SQLGeometry

I used the envelope function on my geometry shape to get this: POLYGON ((-179.231086 51.175092, 179.859681 51.175092, 179.859681 71.441059, -179.231086 71.441059, -179.231086 51.175092)) Is there a built-in function that will allow me to get the…
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
1 2 3
4
5