I was afraid there would be 361 vertices per circle. Should the circles with similar attributes
overlap, or are you making multi-part features?
You can estimate the worst-case vertex count by doing a:
CREATE TABLE tmp_union_driver AS
SELECT transtech,maxaddown,maxadup,hoconum,hoconame,count(*) num_rows
FROM address_extract_fc_buffer_ri
GROUP BY transtech,maxaddown,maxadup,hoconum,hoconame
ORDER BY transtech,maxaddown,maxadup,hoconum,hoconame;
then
SELECT min(num_rows)*37 min_verts, avg(num_rows)*37 avg_verts, max(num_rows)*37 max_verts
FROM tmp_union_driver;
- V