I'm looking around for any answer which I could for my purpose but I'm not able to find it, so I've decided to submit a question.
I have several tables with geography type fields inside and i need to define a where clause for finding all the records within an ellipse.
My ellipse properties are: minoraxis, majoraxis, point and rotation. I already have the where clause which look for a geography inside a circle shape. It's something like this:
select *
from locations
where shape.STIntersects(geography::STPointFromText('POINT(32.113, -81.3225)', 4326).STBuffer(10)) = 1
How could I do it?
Thanks in advance.