[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);
-Steve
More information about the postgis-users
mailing list