Microsoft SQL spatial database
Questions tagged [sql-server-spatial]
151 questions
2
votes
0 answers
SQL Server Routing or options
We are looking for a way using SQL Server spatial queries (or spatial library if needed) to do the following:
We have our own set of spatial data for custom roads (single line) and many point along that road. Some are checkpoints and some are just…
Jase
- 21
- 1
1
vote
0 answers
Loading geometry point tables in SQL Server Spatial
I need to load point data in SQL Server Spatial.
Similar to this post but I really don't know how to get XY data to be accessible by SQL
I want to do what was done in the initial part of this post (Identify points that plot inside the polygon):
How…
Tom
- 33
- 5
1
vote
1 answer
SQL Server Spatial Enable Spatial column and Analysis
I have:
a table called ABC with columns (ID, County_Name, Lat, Long) in SQL
server pre-filled with the values under its respective columns,
except for County_Name column which is currently null.
an ArcGIS SDE feature class - called US_County with…
vic
- 43
- 4
0
votes
0 answers
Microsoft SQL Server "There is already an object named 'geometry_columns' in the database"
Same question Maciej_Szypulski asked, every time I try adding new layers to a new MS SQL server database i get the following error message. [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'geometry_columns' in the…
0
votes
1 answer
Geog vs. Geom - not same results
I have these two SQL Server 2008 R2 queries:
SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geog.STIntersects(geography::Point(35.25934, -120.64432, 4326))=1;
SELECT COUNT(*) FROM OIS_NOA_Buffers WHERE geom.STIntersects(geometry::Point(35.25934,…
rheitzman
- 147
- 5