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:[email protected]] On Behalf Of Pradeep Kanth G Sent: Sunday, April 15, 2018 11:47 PM To: 'PostGIS Users Discussion' <[email protected]> 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.
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
