[postgis-users] Collect problem - 2

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Daniel
> Sent: 02 May 2006 11:55
> To: PostGIS Users Discussion
> Subject: [postgis-users] Collect problem - 2
> 
> In addition to my previous post: error remain when all self-intersecting
> polygons are removed. Why the tests in the query  fails to filter only
> valid geometries ? (with the right dimension:2) ???
> 
> Hello,
> 
> I've used to proceed queries like:
> SELECT collect(lga_geom) as buffer FROM lg_annee
> WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 GROUP BY
> lga_annee;
> 
> With last versions of Postgis, such queries failed, even if I add tests
> like:
> 
> SELECT collect(lga_geom) as buffer FROM lg_annee
> WHERE lga_annee='2005' and lga_nat_cdn=2 and lga_var>-1 and lga_geom is
> not null
> and isvalid(lga_geom) and dimension(lga_geom)=2 GROUP BY lga_annee;
> 
> Errors reported are:
> 
> NOTICE:  Self-intersection
> [....]
> NOTICE:  Self-intersection
> NOTICE:  Self-intersection
> 
> ERROR:  lwcollection_construct: mixed dimension geometries
> 
> Table lg_annee contain 2-dimension polygon geometries. The query worked
> fine with older versions.
> 
> What can I do ?
> 
> Any idea ?
> 
> dF


Hi Daniel,

You'll need to try and provide the following: 

	the output of SELECT postgis_full_version() for the old version
	the output of SELECT postgis_full_version() for your new version
	an example of one of your polygons which raises the NOTICE

This information is needed for someone to be able to try and replicate the
error....


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.