[postgis-users] Errors in geometry.
TECHER David
davidtecher at yahoo.fr
Mon Apr 16 11:17:33 PDT 2007
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 = ...
Jennehag Åke a écrit :
> Hi!
>
> I'm using PostGIS 1.2.0 and PostgreSQL 8.2. Then I run a query like
> (I'm using the SQL client in PgAdmin III):
>
> SELECT gid, asgml(geom) FROM bishkekeni WHERE NOT st_isvalid(geom)
>
> I get a lot of text in the message window. It looks like this:
>
> ....
> NOTICE: Self-intersection
> NOTICE: Self-intersection
> NOTICE: Ring Self-intersection
> NOTICE: Self-intersection
> ...
>
> I understand that this is the same errors that st_isvalid(geom)
> function is printing out. But I would like to have the text like
> 'Self-intersection' on each row for the objects that are not valid. Is
> there a function to print out these errors (must be I can see
> them!!)? How do I use it?
>
> Something like this??
>
> SELECT gid, asgml(geom), magicfunction(geom) FROM bishkekeni WHERE NOT
> st_isvalid(geom)
>
> Regards
> Åke Jennehag
> National Land Survey of Sweden
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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
More information about the postgis-users
mailing list