[postgis-users] identifying blank geometry fields

[Stephen Woodbridge]

Bob Hume wrote:
> select count(*) from dum where the_geom is null  gives a result of 0
> 
> select count(the_geom) from dum gives a result is 1676, which is the 
> total number of rows in the table
> 
> This is consistent with my previous description.  The apparently blank 
> the_geom fields apparently have some data, but the data doesn't 
> display.  This seems odd, and makes it difficult (impossible for me, so 
> far) to identify the blank fields.

Have you run:

select count(*) from dum where not isvalid(the_geom);

-Steve