# No value in USA\_100\_NOFILL.txt file **URL:** \ **Category:** Spatial Allocator\ **Created:** [April 7, 2020, 8:12pm UTC](https://forum.cmascenter.org/t/no-value-in-usa-100-nofill-txt-file/1419 "2020-04-07T20:12:14Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![haohe.umcp](https://avatars.discourse-cdn.com/v4/letter/h/b19c9b/32.png) [@haohe.umcp](https://forum.cmascenter.org/u/haohe.umcp)\ **Post date:** [April 7, 2020, 8:12pm UTC](https://forum.cmascenter.org/t/no-value-in-usa-100-nofill-txt-file/1419/1 "2020-04-07T20:12:14Z")
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 ---
**Author:** ![lizadams](https://avatars.discourse-cdn.com/v4/letter/l/49beb7/32.png) [@lizadams](https://forum.cmascenter.org/u/lizadams)\ **Post date:** [May 12, 2020, 1:29am UTC](https://forum.cmascenter.org/t/no-value-in-usa-100-nofill-txt-file/1419/2 "2020-05-12T01:29:11Z")
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 ---
**Author:** ![dyang](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@dyang](https://forum.cmascenter.org/u/dyang)\ **Post date:** [May 12, 2020, 1:47am UTC](https://forum.cmascenter.org/t/no-value-in-usa-100-nofill-txt-file/1419/3 "2020-05-12T01:47:51Z")
> [@haohe.umcp](#): > > EUS4k 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.