SQL Spatial Merge Polygons

Question

SQL Spatial Merge Polygons

Andrew Ingall 80

Hello

I have the following code to buffer two polygons held in a spatial table, but what i am trying to do is merge them both into one polygon and write out the result to a new view.

Can this be done and if so how?

Andy

SELECT [Admin_Unit_ID]
      ,[GEOM].STBuffer (5000) as Geom
  FROM [Mapping].[dbo].[OS_BDL_district_borough_unitary2]
  WHERE [Admin_Unit_ID] IN ('17653','17486');

Accepted answer

0 additional answers

Your answer

Answer 1

Viorel 120.8K

Try something like this:

SELECT geometry::UnionAggregate([GEOM].STBuffer(5000)) as Geom
FROM [Mapping].[dbo].[OS_BDL_district_borough_unitary2]
WHERE [Admin_Unit_ID] IN ('17653','17486');

Andrew Ingall 80 Reputation points

2023-03-31T18:24:38.04+00:00

Brilliant, Thank you so much
Andrew Ingall 80 Reputation points

2023-03-31T19:23:42.3633333+00:00

One final question, is there a way to also export a unique identifier into the view. It doesn't really matter what it is, it could be one of the admin unit values...just needed to load into GIS.

So the view table would be Admin Unit | Geom

Thanks in advance
Viorel 120.8K Reputation points

2023-03-31T19:44:18.4866667+00:00
Probably you can add this column:

select max(Admin_Unit_ID) as Admin_Unit_ID, geometry::UnionAggregate...

Share via

SQL Spatial Merge Polygons

0 additional answers

Your answer