existing surrogate tables didn't get deleted

[cseppan]

Run PostgreSQL/PostgreGIS to generate surrogate ratios for USA_300
PGSRGCREATE script_OUTPUT>public.cb_2017_us_county_500k
PGSRGCREATE script_OUTPUT>Cutting by data shapefile boundaries
PGSRGCREATE script_ERROR>psql:./outputs/bos_1_126x141/temp_files/300_create_wp_cty.sql:3: ERROR: relation "wp_cty_300_900921" already exists
PGSRGCREATE script_ERROR>psql:./outputs/bos_1_126x141/temp_files/300_create_wp_cty.sql:4: ERROR: column "geom_900921" of relation "wp_cty_300_900921" already exists
PGSRGCREATE script_ERROR>CONTEXT: SQL statement "ALTER TABLE public.wp_cty_300_900921 ADD COLUMN geom_900921 geometry(MultiPolygon, 900921)"
PGSRGCREATE script_ERROR>PL/pgSQL function addgeometrycolumn(character varying,character varying,character varying,character varying,integer,character varying,integer,boolean) line 106 at EXECUTE
PGSRGCREATE script_ERROR>SQL statement "SELECT public.AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)"
PGSRGCREATE script_ERROR>PL/pgSQL function addgeometrycolumn(character varying,character varying,character varying,integer,character varying,integer,boolean) line 5 at SQL statement
PGSRGCREATE script_OUTPUT>INSERT 0 195419
PGSRGCREATE script_OUTPUT>UPDATE 0
PGSRGCREATE script_OUTPUT>UPDATE 781676
PGSRGCREATE script_OUTPUT>CREATE INDEX
PGSRGCREATE script_OUTPUT>VACUUM
PGSRGCREATE script_OUTPUT>Gridding weight data to modeling domain
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT> addgeometrycolumn
PGSRGCREATE script_OUTPUT>----------------------------------------------------------------------------------------
PGSRGCREATE script_OUTPUT> public.wp_cty_cell_300_bos_1_126x141.geom_900921 SRID:900921 TYPE:MultiPolygon DIMS:2
PGSRGCREATE script_OUTPUT>(1 row)
PGSRGCREATE script_OUTPUT>
PGSRGCREATE script_OUTPUT>INSERT 0 36780
PGSRGCREATE script_OUTPUT>UPDATE 0
PGSRGCREATE script_OUTPUT>UPDATE 36780
PGSRGCREATE script_OUTPUT>CREATE INDEX
PGSRGCREATE script_OUTPUT>VACUUM
PGSRGCREATE script_OUTPUT>CREATE TABLE public.numer_300_bos_1_126x141
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT>INSERT 0 5959
PGSRGCREATE script_OUTPUT>CREATE TABLE public.denom_300_bos_1_126x141; create primary key
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT>INSERT 0 3127
PGSRGCREATE script_OUTPUT>CREATE TABLE public.surg_300_bos_1_126x141; add primary key
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT>INSERT 0 5959
PGSRGCREATE script_OUTPUT>Exporting surrogates public.surg_300_bos_1_126x141;
SUCCESS IN RUNNING THE EXECUTABLE: PGSRGCREATE script