So I am trying to do a where clause on a select and my code is
ST_Within(shape::GEOMETRY, ST_Buffer(ST_GeogFromText('@Value(_location)'), 5, 'endcap=round join=round')I am trying to buffer the _location attribute by 5 meters so when the ST_Within is used it will help match better. This code is suppose to look for for input points and see if they match anything in the data set already. via spatial match. Just FYI both points for ST_within are points.
If anyone has any idea how i used ST_Bufffer wrong that would be great help.
أكثر...
ST_Within(shape::GEOMETRY, ST_Buffer(ST_GeogFromText('@Value(_location)'), 5, 'endcap=round join=round')I am trying to buffer the _location attribute by 5 meters so when the ST_Within is used it will help match better. This code is suppose to look for for input points and see if they match anything in the data set already. via spatial match. Just FYI both points for ST_within are points.
If anyone has any idea how i used ST_Bufffer wrong that would be great help.
أكثر...