Null geometries for CREATE TABLE AS ... SELECT *

[Robert Hewlett]

Thanks, and my bad on that one. Was not expecting any null geometries in
the original data set.



"total_counts"

"Total with null geom: 3711"

"Total with geom: 147611"

"Total features: 151322"





SELECT 'Total features: ' || count(*) as total_counts

FROM index_demo.street_trees_indexed t

UNION

SELECT 'Total with null geom: ' ||  count(*)

FROM index_demo.street_trees_indexed t

WHERE t.geom is null

UNION

SELECT 'Total with geom: ' || count(*)

FROM index_demo.street_trees_indexed t

WHERE t.geom is not null





Rob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241023/bb6dea09/attachment.htm>