[postgis-users] bounday or convex hull of a bunch of points

Paul Ramsey pramsey at cleverelephant.ca
Sat Apr 5 14:59:43 PDT 2008


st_extent for a minimal bounding box
st_convexhull for a hull

On Sat, Apr 5, 2008 at 1:08 PM, Paul Tomblin <ptomblin at xcski.com> wrote:
> I have a table with a point column.  Is there a way to find the boundary or
> convex hull of some of the entries in that table?  For instance, if I want
> to find the extents of each country in the table, can I say
>         insert into country_extents (country, geom) values (select country,
> ST_XXX(point) from waypoint group by country));
>
>  --
>  Paul Tomblin <ptomblin at xcski.com> http://blog.xcski.com/
>  "I'm cruising down the Information Superhighway in high gear, surfing the
>  waves of the Digital Ocean, exploring the uncharted regions of Cyberspace.
>  Actually I'm sitting on my butt staring at a computer screen."
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list