create_bounds.sql

create table chief_loop_bounds_out as
    with world as (
    select st_makeenvelope(-180, -90, 180, 90, 4326) geom
),
env as (
    select st_transform(st_minimumboundingcircle(st_collect(t.geom)), 4326) geom from dbt.chief_three_peaks_loop t
)
select st_makepolygon(st_exteriorring(w.geom), Array[st_exteriorring(t.geom)]) geom from world w, env t;

create table chief_loop_bounds_in as
     select st_transform(st_minimumboundingcircle(st_collect(t.geom)), 4326) geom from dbt.chief_three_peaks_loop t;