[postgis-users] identifying blank geometry fields

Stephen Woodbridge woodbri at swoodbridge.com
Mon Nov 23 21:46:51 PST 2009

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);


More information about the postgis-users mailing list