[postgis-users] makepolygon with geom info

[S.Reena]

Hi Regina,
I have made a new table with the query data as you suggested and added entry
in  geometry_columns ... I am able to see the polygon as postgis layer in
Quantum GIS...but somehow its not getting displayed in map...Can you suggest
something?

Cheers,
Reena.





Obe, Regina     DND\MIS wrote:
> 
> 
>  Typo again should be
> 
> 
>  DATA "newgeom FROM (SELECT Max(f.gid) as newgid, f.name,
> ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom
> FROM (SELECT name, 0 as psort, gid, 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) As foo USING UNIQUE newgid USING SRID=4326"   (change
> 4326 with your SRID).
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe,
> Regina
> Sent: Wednesday, July 02, 2008 11:55 AM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] makepolygon with geom info
> 
> I've never tried doing that complicated of a query in Mapserver so not
> sure it will fly.   Well I did try once, but it was too slow so I just
> created a table out of the statement
> 
> If you wanted to try the complex query
> 
> 
>  DATA "newgeom FROM (SELECT Max(f.gid) as newgid, f.name,
> ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom
> FROM (SELECT name, 0 as psort, gid, 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) As foo USING UNIQUE newid USING SRID=4326"   (change
> 4326 with your SRID).
> 
> 
> 
> Alternatively just create a new table
> 
> SELECT * INTO follpoly
> 	FROM 
>  (SELECT Max(f.gid) as newgid, f.name,
> ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom
> FROM (SELECT name, 0 as psort, gid, 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) As foo;
> 
> ALTER TABLE follpoly
>   ADD CONSTRAINT follpoly_pkey PRIMARY KEY(newgid);
> 
> then your mapserver data part would just be
> 
> DATA "newgeom FROM follpoly USING UNIQUE newid USING SRID=4326"
> 
> You might also want to manually put in an entry in geometry_columns
> table since some GIS apps require it.
> 
> 
> Hope that helps,
> Regina
> 
> 
> 
> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> S.Reena
> Sent: Wednesday, July 02, 2008 9:39 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] makepolygon with geom info
> 
> 
> Yupp that is done... now im trying to include that newgeom in DATA
> section of
> my map file to make a polygon ....bt it isnt wrking....this newgeom can
> be
> used for this or not....
> 
> 
> 
> S.Reena wrote:
>> 
>> 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-tp18214128p18237679.htm
> l
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/makepolygon-with-geom-info-tp18214128p18646914.html
Sent from the PostGIS - User mailing list archive at Nabble.com.