[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.




More information about the postgis-users mailing list