[postgis-users] Query for Footprint

[Regina Obe]

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
like

 

SELECT ST_ExterionRing(geom)

FROM parcels

 

Which will give you all values.

 

For footprint of a specifc parcel, should be something like

 

SELECT geom

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,

Regina

 

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

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

 

 

Regards

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>