Sql Spatial

I always find it difficult to remember all of the spatial functions and properties. One that I always forget is the STSrid. This is an integer representing the spatial reference identifier of the instance. In order for spatial queries to work between features this number must be the same between the instances.

Example:

SELECT TOP 10 geom.STSrid FROM parcels

Another issue that I often run into is having geometry that is not valid (which prevents spatial queries from working). I solve this by making all of the geomtry valid:

UPDATE Parcels SET shape = shape.MakeValid() WHERE shape.STIsValid() = 0;

Change STSrid

UPDATE tbm.locationproperty SET location = geometry::STGeomFromWKB(location.STAsBinary(), 3857);

Here is some other helpful information:

1. Calculate distance for Geography Points

2. Point in Polygon