[postgis-users] identifying blank geometry fields

Bob Hume bobh at lbblawyers.com
Mon Nov 23 21:34:53 PST 2009


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.