CODEWITHSUNDEEP
t-sqlgeometrylatitude-longitude
ZafarYousafi
ZafarYousafi

Reputation: 10880

TSQL Geometry:Get records which either havea given point(lat,long)(Point is in the shape) or is near the shape

I have zillow neighborhood data and is successfully imported to DB(thanx to http://shapefilesource.codeplex.com). Now i want to write an SP which will take lat,long and will return all record in which given point lies or is near to them. How can I achieve this in TSQL or do I need to use CLR.

Upvotes: 0

Views: 335

Answers (1)

bubblez
bubblez

Reputation: 814

I think that should be able using the function STBuffer and STIntersects. Maybe these pages may help:

http://blogs.msdn.com/b/davidlean/archive/2008/10/24/sql-2008-spatial-samples-part-n-1-of-n-stbuffer.aspx

http://msdn.microsoft.com/en-us/library/ff929109.aspx

Upvotes: 1

Related Questions