Functions / Geometry Aggregation Functions |

Returns a MultiPolygon geometry object which represents a buffered distance around the aggregated geometry objects.

MI_AggregateBuffer ( geometry, dist, unit, calculationType, res )

`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.

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')

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 |