[postgis-users] Shapes to PG

Nicolas Ribot nicky666 at gmail.com
Mon Jan 26 10:56:22 PST 2009

> The first returns 0 of 5204 records.

Meaning you don't have null geometries in your table.

> The output of the latter I don't understand (see screenshot)

the result of st_isvalid is a boolean value: t for true, f for false.
meaning some geometries are invalid.

select <some attributes> from onb where not st_isvalid(the_geom);
will allow you to identify invalid objects.


More information about the postgis-users mailing list