0

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

jhhwilliams
  • 2,297
  • 1
  • 22
  • 26

1 Answers1

2

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.

Ben Thul
  • 31,080
  • 4
  • 45
  • 68