Lab Sql

I want to find the shortest distance between two SqlGeography polygon. I know there is a method Sho… Read more Finding Shortest Distance Between Two Polygons(sqlgeography C# )

I'm trying to create a circle in a SQL Server based on a midpoint and a radius. This seems … Read more Sql Server Circle

I'm trying to populate my DB with geographical places of my country. One of my tables have 4 fi… Read more Mysql Insert/update On Point Column

I have written a stored procedure that, yesterday, typically completed in under a second. Today, it… Read more Sql Server - Stored Procedure Suddenly Become Slow

Is there a way to subtract a geometry from another? A kind of reverse STUnion.. The problem I am h… Read more Subtracting A Sql Server Geometry From Another

SQL Spatial Features: SQL geometry Point, Linestring working well but the Circular string is not wo… Read more Sql-server 2008 R2 Geospatial Query Error For Circular String

I have 2 tables one with points as geographies and other with polygons as geographies. I am able to… Read more Sql Spatial Join

When I apply STBuffer(1) to a Point in SQL Server Spatial, they show up as an oblong circle, instea… Read more Why Are My Buffered Points Oblong And Not Circle In Sql Server Management Studio - Spatial Results

SQL Server has a spatial type 'circularstring' that is collection of odd points. How can I … Read more How To Draw Sql Server "circularstring" In C#

I'm using SQL Server 2008 and the Geometry datatype to store a list of UK a roads, which I'… Read more How To Combine Multiple Linestring Rows Into A Single Row Collection

I've uploaded .SHP files to my table in sql and I got geometry column with data. I can see poin… Read more Converting Geometry(spatial) To Longitude And Latitude

Hello, i have the following code in SQL Server, why if i want to calculate the sTArea of @geog fa… Read more Convert Geography To Geometry Sql Server 2008r2

I want to be able to run a query like: select A.* from A join B on match(A.geom,B.wkt) usin… Read more Is It Possible To Issue A Spatial Join With Shapes From Two Tables?

The System.Data.Spatial.DbGeography.Intersects method seems to always return true for me. I'm n… Read more Dbgeography Intersects Method Not Working

I want to create trigger which after insert longitude and latitude to table Vehicle create point f… Read more How To Do Trigger Which Create A Point After Insert Longitude And Latitude?