<div dir="ltr"><p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">Thanks, and my bad on that one. Was not expecting any null
geometries in the original data set.</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif"> </p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">"total_counts"</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">"Total with null geom: 3711"</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">"Total with geom: 147611"</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">"Total features: 151322"</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif"> </p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif"> </p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">SELECT 'Total features: ' || count(*) as total_counts</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">FROM index_demo.street_trees_indexed t</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">UNION</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">SELECT 'Total with null geom: ' ||  count(*)</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">FROM index_demo.street_trees_indexed t</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">WHERE t.geom is null</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">UNION</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">SELECT 'Total with geom: ' || count(*)</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">FROM index_demo.street_trees_indexed t</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">WHERE t.geom is not null</p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif"> </p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif"> </p>

<p class="MsoNormal" style="margin:0cm;font-size:11pt;font-family:Aptos,sans-serif">Rob</p></div>