[postgis-users] Need help on query to return boundary of polygon

Stephen Woodbridge woodbri at swoodbridge.com
Tue Sep 15 09:52:17 PDT 2015


On 9/15/2015 12:25 PM, Bistrais, Bob wrote:
> I would like to return the boundary of a selected polygon, and I can’t
> seem to get my syntax correct.  What I want to do is to select the
> boundary from a polygon table of towns, where the town name equals a
> selected town.  Something like this:
>
> Select ST_Boundary(geom) from (select * from towns where
> towns.townname=’Mytown’)

Does this work:

select st_boundary(geom) from towns where townname='Mytown';

-Steve

> -obviously this is not correct, but hopefully gives an idea of what I want.
>
> Any suggestions?
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list