Browse by Tags

All Tags » SQL (RSS)

Check if Point is inside a Polygon using SQL by jhallal

Using the geospatial SQL functions you can check if a point (with a given X,Y) is included inside a polygon Example: Declare @point geometry Declare @polygon geometry SET @point = geometry::STGeomFromText('POINT (-88.22 41.50000001)', 4326) SET @polygon...
Filed under: ,

Geospatial Data in SQL Server 2008 by jhallal

Introduction The spatial data type in SQL server 2008 allow you to store geospatial data which deals with the location of a point, line polygon... in a three dimensional space. SQL Server 2008 supports two spatial data types: Geometry : Stores data in...
Filed under: ,
More Posts