[postgis-users] Re: Re: Errors in geometry. (TECHER David)

[TECHER David]

Hi Jennehag

A other solution - surely not the best - is to use OpenJum with the 
tools what it has to analyze with geometry and the error.

Few years ago, I've use it in order to corect it geometrical data. It 
took me less then one day to do that. So if you have times!

If somebody could give you more informations about that, I think it 
could help you.

OpenJump could help you to SEE the point  with problems.


Jennehag Åke a écrit :
>
> Hi!
>
> Thanks for the reply. But it wont help me. I want to get the type off 
> error as it is printed out in the message window. isvalid(geom) 
> function only reports back true or false (true if the geom is ok and 
> false if it has any problem.) I want to know what the problem is with 
> the geometry. Apparently there is some way to report this, otherwise I 
> don't know there the messages (see below) comes from. I'm actually 
> looking for the function that prints out the error. I have search the 
> documentation for this but I have not found anything.
>
>
> ....
> NOTICE:  Too few points in geometry component
> NOTICE:  Self-intersection
> NOTICE:  Self-intersection
> ....
>
> It seams that each error that are reported back with the isvalid(geom) 
> function has an description in the message window, but I'm not sure.
>
> If I try this query:
>
> SELECT gid , asgml(geom) FROM bishkekeni WHERE gid < 500;
>
> Then I don't get any 'NOTICE: [error]' in the message window, so it 
> must be connected with the isvalid() function. But as I wrote before, 
> I'm interested in knowing what is wrong with a particular geometry, is 
> it self-intersecting or ....
>
> Regards
>
> Åke Jennehag
>
>  
>
> >Date: Mon, 16 Apr 2007 20:17:33 +0200
>
> >From: TECHER David <davidtecher at yahoo.fr>
>
> >Subject: Re: [postgis-users] Errors in geometry.
>
> >To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>
> >Message-ID: <4623BDBD.3020708 at yahoo.fr>
>
> >Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> >Perhaps by adding a column
>
> >ALTER TABLE .. ADD COLUMN is_valid boolean;
>
> >UPDATE ... SET is_valid=isvalid(the_geom)
>
> >then
>
> >SELECT gid, asgml(geom) FROM bishkekeni WHERE NOT is_valid = ...
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com