December 2011 - Posts

0
Comments

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: ,
2
Comments

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: ,
0
Comments

jQuery Selectors by jhallal

jquery selectors are the most important aspects of the jquery Library. On top of standard CSS selectors jquery introduces some custom selectors that makes your code even more simpler and easier to read. Below is a summary table of the jquery selectors...
Filed under:
More Posts