[postgis-devel] area between selected points

Obe, Regina robe.dnd at cityofboston.gov
Tue Jul 1 03:25:14 PDT 2008

This is the wrong news group to ask this question.  You should use
Postgis Users instead
Anyrate to answer your question
SELECT the_geom, name, latlon, ST_Area(the_geom)
FROM sometable
WHERE name LIKE 'ABC%'   
should do it.
Hope that helps,


From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
Reena Singh
Sent: Tuesday, July 01, 2008 2:20 AM
To: postgis-devel at postgis.refractions.net
Subject: [postgis-devel] area between selected points

I have a postgres table which I want to represent in map...the
attributes being ( the_geom, name, latlon etc..) I want to calculate the
area of all the points (using the_geom) having name LIKE ' ABC' ...[A
single tuple having the_geom , area and name field is required ) so that
I can represent it using a polygon in map.

How to do that.......


Be Yourself @ mail.com!
Choose From 200+ Email Addresses
Get a Free Account at www.mail.com <http://www.mail.com/Product.aspx> !

The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20080701/3160da1c/attachment.html>

More information about the postgis-devel mailing list