CODEWITHSUNDEEP
rsql-servert-sqlsqlgeographydotspatial
jhhwilliams
jhhwilliams

Reputation: 2582

Scale a SQL geography polygon

Is it possible to scale a SQL geography polygon like what is being done here?

Ideally I'd like to add a buffer of x meters either to the inside or outside of the original geography in SQL.

I also have DotSpatial and R available if a SQL option is not possible.

example of what I'm trying to do

Upvotes: 0

Views: 296

Answers (1)

Ben Thul
Ben Thul

Reputation: 32687

I believe the STBuffer() method does what you want. Like so:

select geo.STBuffer(5)
from dbo.myTable;

Where the input to the method will be in units that are specific to the SRID of the geography instance being operated on. If you're not sure, consult sys.spatial_reference_systems with the SRID of your data.

Upvotes: 2

Related Questions