[postgis-users] Convert lines to polygon

[Vera Schulze]

Michael Fuhr schrieb:
> On Wed, Aug 16, 2006 at 04:56:15PM +0200, Vera Schulze wrote:
>> Sorry, I was wrong saying datasets. The geometry of the lines are stored 
>> in the same table but in different records and I'm looking for a way to 
>> join these lines into a polygon.
>>
>> I tried what you suggested but the resultset is empty if the linestring 
>> doesn't contain end- and startpoint in one record.
> 
> What do you mean by "doesn't contain end- and startpoint in one
> record"?  Could you post an example of what the data looks like and
> what query you ran?
> 
Hi Michael,

thanks for your help!

this is the query:
SELECT oid, ogc_fid, astext(polygonize(the_geom)) FROM 
countries_dcw_test WHERE cntry_code = 'QT' GROUP BY oid, ogc_fid

And I attached the data as csv-file.

There are 27 records and originally they are of type line. Some of the 
records contain start and endpoint, the others doesn't.

Thank you for any hint.

-- 

Mit freundlichen Grüßen

Vera Schulze

----------------------------------

  Vera Schulze
  CCGIS GbR
  Siemensstraße 8
  53121 Bonn
  Germany

----------------------------------
   v.schulze at ccgis.de
         www.ccgis.de
----------------------------------
  Tel.:      ++49 (0) 228 90826 28
  Fax.:      ++49 (0) 228 90826 11
  Zentrale:  ++49 (0) 228 90826 0
----------------------------------
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: quatar.csv
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060821/a79635a7/attachment.ksh>