No value in USA_100_NOFILL.txt file

Spatial Allocator
1

I have successfully finished the test run and benchmark of pg_srgtools and plan to generate a surrogate for my own 4-km domain in eastern US.

I changed the projections parameters ‘xorig’,‘yorig’,‘xcellsize’, ‘ycellsize’, ‘cols’, and ‘rows’ in the ‘generate_modeling_grid.sh’ and some variables in ‘control_variables_pg.csv’. All the ‘postgres’ run scripts runs and no data were written to the NOFILL file.

I found some warning in the LOG file as below. What else I need to correctly set up the software. Thanks!

Run PostgreSQL/PostgreGIS to generate surrogate ratios for USA_100
PGSRGCREATE script_OUTPUT>public.cb_2014_us_county_500k_poly
PGSRGCREATE script_OUTPUT>Cutting by data shapefile boundaries
PGSRGCREATE script_ERROR>psql: warning: extra command-line argument “password=sepia6#vibes” ignored
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT> addgeometrycolumn
PGSRGCREATE script_OUTPUT>---------------------------------------------------------------------
PGSRGCREATE script_OUTPUT> public.wp_cty_100.geom_900921 SRID:900921 TYPE:MultiPolygon DIMS:2
PGSRGCREATE script_OUTPUT>(1 row)
PGSRGCREATE script_OUTPUT>
PGSRGCREATE script_OUTPUT>INSERT 0 279869
PGSRGCREATE script_OUTPUT>UPDATE 279869
PGSRGCREATE script_OUTPUT>UPDATE 279869
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_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:1: NOTICE: table “wp_cty_cell_100_eus4k” does not exist, skipping
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:9: ERROR: relation “public.wp_cty_cell_100_EUS4k” does not exist

Run PostgreSQL/PostgreGIS to generate surrogate ratios for USA_100
PGSRGCREATE script_OUTPUT>public.cb_2014_us_county_500k_poly
PGSRGCREATE script_OUTPUT>Cutting by data shapefile boundaries
PGSRGCREATE script_ERROR>psql: warning: extra command-line argument “password=sepia6#vibes” ignored
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT> addgeometrycolumn
PGSRGCREATE script_OUTPUT>---------------------------------------------------------------------
PGSRGCREATE script_OUTPUT> public.wp_cty_100.geom_900921 SRID:900921 TYPE:MultiPolygon DIMS:2
PGSRGCREATE script_OUTPUT>(1 row)
PGSRGCREATE script_OUTPUT>
PGSRGCREATE script_OUTPUT>INSERT 0 279869
PGSRGCREATE script_OUTPUT>UPDATE 279869
PGSRGCREATE script_OUTPUT>UPDATE 279869
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_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:1: NOTICE: table “wp_cty_cell_100_eus4k” does not exist, skipping
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:9: ERROR: relation “public.wp_cty_cell_100_EUS4k” does not exist

PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_denom.sql:4: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "denom_100_eus4k_pk$
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT>INSERT 0 0
PGSRGCREATE script_OUTPUT>CREATE TABLE public.surg_100_EUS4k; add primary key
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_surg.sql:1: NOTICE: table “surg_100_eus4k” does not exist, skipping
PGSRGCREATE script_OUTPUT>DROP TABLE
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_surg.sql:9: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "surg_100_eus4k_pkey$
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_OUTPUT>INSERT 0 0
PGSRGCREATE script_OUTPUT>Exporting surrogates public.surg_100_EUS4k;
PGSRGCREATE script_ERROR>psql: warning: extra command-line argument “surrogates” ignored
SUCCESS IN RUNNING THE EXECUTABLE: PGSRGCREATE script

            Surrogate Generation Summary

USA_100 Population PGSRGCREATE Success

End Date: Tue Apr 07 15:44:06 EDT 2020
Elapsed time in minutes: 10.953733333333334

SUCCESS – The Program Run Completed

2

I am a bit unsure about the meaning of NOTICE versus ERROR versus warning. The end of the script says success. Do you have an output file called public.surg_100_EUS4k or is this not the name of the output file that is generated?

PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:1: NOTICE: table “wp_cty_cell_100_eus4k” does not exist, skipping
PGSRGCREATE script_OUTPUT>CREATE TABLE
PGSRGCREATE script_ERROR>psql:./outputs/EUS4k_502x418/temp_files/100_create_wp_cty_cell.sql:9: ERROR: relation “public.wp_cty_cell_100_EUS4k” does not exist

3

Try to use “eus4k”, lower case, in GRIDDESC file and control file to see what happens. If a database table name in “”, it will not be transferred to lowercase.