RE: makepolygon with geom info

Try

Are each of your the_geom single point geometries?
If so I think you can do something of the form

SELECT Max(f.gid) as newgid, ST_MakePolygon(ST_MakeLine(f.the_geom)) As
newgeom, f.name
FROM (SELECT gid, the_geom FROM foll ORDER BY name, gid) As f
WHERE f.name = 'abc'
GROUP BY  f.name

Although the above assumes that your gid field controls the order of the
points along the line string and that your beginning and ending point
are the same.

If your beginning and ending are not the same - but your order is still
right, then you can do

SELECT Max(f.gid) as newgid, f.name,
ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom
FROM (SELECT name, 0 as psort, gid as newsort, the_geom
                FROM foll
        UNION ALL
                SELECT fs.*
                FROM
                (SELECT DISTINCT ON(name) name, 1 As psort, gid ,
the_geom
                        FROM foll
                ORDER BY name, gid) fs
        ORDER BY 1,2,3) As f
WHERE f.name = 'abc'
GROUP BY  f.name


If you leave the WHERE clause out, it will give you a Polygon record for
each unique abc.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of
S.Reena
Sent: Tuesday, July 01, 2008 7:33 AM
To: postgis-users@...
Subject: [postgis-users] makepolygon with geom info


I have a table with foll fields( the_geom, name, latlon, ....)...i
wanted to
make a polygon by using those points whose name like 'abc' and put it in
the
map...

how to do dis?
--
View this message in context:
http://www.nabble.com/makepolygon-with-geom-info-tp18214128p18214128.htm
l
Sent from the PostGIS - User mailing list archive at Nabble.com.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
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.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users