<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>This is the wrong news group to ask this question.
You should use Postgis Users instead</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>Anyrate to answer your question</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>SELECT the_geom, name, latlon,
ST_Area(the_geom)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>FROM sometable</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>WHERE name LIKE 'ABC%' </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>should do it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=029202310-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <B>On Behalf Of </B>Reena
Singh<BR><B>Sent:</B> Tuesday, July 01, 2008 2:20 AM<BR><B>To:</B>
postgis-devel@postgis.refractions.net<BR><B>Subject:</B> [postgis-devel] area
between selected points<BR></FONT><BR></DIV>
<DIV></DIV>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.<BR><BR>How to do that.......<BR><BR>S.Reena<BR><BR>
<DIV></DIV><BR>--
<DIV>Be Yourself @ mail.com!<BR>Choose From 200+ Email Addresses<BR>Get a
<B>Free</B> Account at <A href="http://www.mail.com/Product.aspx"
target=_blank>www.mail.com</A>!</DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>