Description
Returns a MultiPolygon geometry object which represents a buffered distance around the aggregated geometry objects.
Syntax
MI_AggregateBuffer ( geometry, dist, unit, calculationType, res )
Arguments
geometry is an expression which returns a geometry,
dist is a number which represents the distance from the source geometry for the buffer,
unit is an area unit specification,
calculationType is a string that indicates whether to perform a Spherical or Cartesian calculation. There is no default, and
res is a number which specifies the minimum number of segments used in creating a circle from buffering a point.
Example
Returns a MultiPolygon geometry object which represents a buffered distance around the aggregated geometry objects.
select MI_AggregateBuffer([Geometry_Column],5,'km','Spherical',10) from countries where country in ('Canada','United States','Mexico')Remarks
Valid values for unit are the following distance units:
| Value | Description |
|---|---|
| mi | miles |
| km | kilometers |
| in | inches |
| ft | feet |
| yd | yards |
| mm | millimeters |
| cm | centimeters |
| m | meters |
| survey ft | US Survey feet |
| nmi | nautical miles |
| twip | twips |
| pt | points |
| pica | picas |
| degree | degrees |
| li | links |
| ch | chains |
| rd | rods |