CODEWITHSUNDEEP
sqldistancegeographymeasurementunits-of-measurement
user358089
user358089

Reputation:

SQL Server 2008 Geography .STBuffer() distance measurement units

I'm working with a geographic point using lat/long and need to find other points in our database within a 5 mile radius of that point. However, I can't seem to find out what the "units" are for STBuffer, it doesn't seem to conform to feet, miles, meters, kilometers, etc. The documentation only refers to them as "units", any suggestions? Thanks

[...] from geography::STGeomFromText('POINT(x y)', 4326).STBuffer(z).STIntersects(geography::STGeomFromText('POINT(' + CAST(v.Longitude as varchar(max)) + ' ' + CAST(v.Latitude as varchar(max)) + ')', 4326)) = 1

Upvotes: 9

Views: 12177

Answers (3)

Colonel_Old
Colonel_Old

Reputation: 932

For anyone visiting this page who is confused by why their buffer distances may not be appearing in meters, it may be because you are using the geometry data type versus the geography data type. In my case, it was clear that geography operates with meters, while geometry does not (degrees it appears?) even if the spatial reference system is set correctly for geometry.

To convert latitude and longitude to a geography point:

geography::Point(latitude, longitude, 4326) -- 4326 is WGS-84 EPSG Projection

Upvotes: 1

Chris
Chris

Reputation: 91

The unit of measurement depends on the spatial reference system in use. See this system view for details:

SELECT * FROM sys.spatial_reference_systems;

Upvotes: 9

Mark Bowytz
Mark Bowytz

Reputation: 1362

STBuffer is in meters. More info here.

To convert, miles to meters, divide the number of miles by 0.0006213712

(i.e. 5 miles / 0.0006213712 = 8,046.72 meters)

Upvotes: 6

Related Questions