[postgis-users] Query for Footprint

Regina Obe lr at pcorp.us
Mon Apr 16 09:27:14 PDT 2018

Are you looking for an area or a perimeter.


ST_ExteriorRing would give you the outer boundary of the a single polygon.
If you want it as a linestring, you want ST_Boundary(geom).


Sounds though if you are getting all geometries that you are doing something


SELECT ST_ExterionRing(geom)

FROM parcels


Which will give you all values.


For footprint of a specifc parcel, should be something like



FROM parcels WHERE pid = 'parcel id you are interested in';


If the above doesn't answer your question, provide more detail about your
table structure and SQL query you are writing.


Hope that helps,



From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Pradeep Kanth G
Sent: Sunday, April 15, 2018 11:47 PM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
Subject: [postgis-users] Query for Footprint


Dear All,


Can you please tell us, how to retrieve the footprint from polygon feature

Already, I have tried like ST_ExteriorRing but here we are getting all the
geometries not getting the single geometry.




Pradeep Kanth




Disclaimer | The information contained in this electronic message (including
any attachments) is intended for the exclusive use of the addressee(s) and
may contain confidential or privileged information.If you have received this
in error, please notify the sender immediately and delete the material from
your machine. Any  action including review, retransmission, dissemination of
this email or the attachments present along with the email by persons or
entities other than the intended recipient is prohibited.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180416/5434bd68/attachment.html>

More information about the postgis-users mailing list