How would I go about getting this to work?
I have a table with location data (lat, long, homevalue) in sql server 2008. Given a lat long say (32.113, -81.3225), I want to draw a 50 mile radius circle and get the number of locations and total home value within the circle buffer.
If I understand @Mapoholic correctly, they are using the "shape" as an attribute to perform stintersect and stbuffer on the location table. My limitations are that, i have the location table which has just the lat, long, homevalue in dollars. I need to independently draw a cirlce based on the given lat long, which if i am doing it right would be like this
DECLARE @Result geography SELECT @Result = geography::Point(32.113, -81.3225,4326); select @Result.STBuffer(10000);
and then I need to JOIN or use some method to check if the lat longs in the location table are within the @Result.STBuffer(10000).