X›ÿ x  À›~x˜ŠJ sh¸TMPDIR="${staging_fold}/temp/" UNZIPTOOL=unzip WGETTOOL="/usr/bin/wget" export PGBIN=/usr/lib/postgresql/10/bin export PGPORT=5432 export PGHOST=localhost export PGUSER=postgres export PGPASSWORD=yourpasswordhere export PGDATABASE=geocoder PSQL=${PGBIN}/psql SHP2PGSQL=shp2pgsql cd ${staging_fold}  wgetrm -f ${TMPDIR}/*.* ${PSQL} -c "DROP SCHEMA IF EXISTS ${staging_schema} CASCADE;" ${PSQL} -c "CREATE SCHEMA ${staging_schema};" for z in *.zip; do $UNZIPTOOL -o -d $TMPDIR $z; done cd $TMPDIR; ${PSQL}/${SHP2PGSQL}export Dfor z in *${table_name}*.dbf; do ${loader} -D -s 4269 -g the_geom -W "latin1" $z ${staging_schema}.${state_abbrev}_${table_name} | ${psql} ${PSQL} -c "SELECT loader_load_staged_data(lower('${state_abbrev}_${table_name}'), lower('${state_abbrev}_${lookup_name}'));" doneJ windowstset TMPDIR=${staging_fold}\temp\ set UNZIPTOOL="C:\Program Files\7-Zip\7z.exe" set WGETTOOL="C:\wget\wget.exe" set PGBIN=C:\Program Files\PostgreSQL\10\bin\ set PGPORT=5432 set PGHOST=localhost set PGUSER=postgres set PGPASSWORD=yourpasswordhere set PGDATABASE=geocoder set PSQL="%PGBIN%psql" set SHP2PGSQL="%PGBIN%shp2pgsql" cd ${staging_fold} %PGBIN%%WGETTOOL%del %TMPDIR%\*.* /Q %PSQL% -c "DROP SCHEMA IF EXISTS ${staging_schema} CASCADE;" %PSQL% -c "CREATE SCHEMA ${staging_schema};" %PSQL% -c "DO language 'plpgsql' $$ BEGIN IF NOT EXISTS (SELECT * FROM information_schema.schemata WHERE schema_name = '${data_schema}' ) THEN CREATE SCHEMA ${data_schema}; END IF; END $$" for /r %%z in (*.zip) do %UNZIPTOOL% e %%z -o%TMPDIR% cd %TMPDIR%%PSQL%\%SHP2PGSQL% set Lfor /r %%z in (*${table_name}*.dbf) do (${loader} -D -s 4269 -g the_geom -W "latin1" %%z tiger_staging.${state_abbrev}_${table_name} | ${psql} & ${psql} -c "SELECT loader_load_staged_data(lower('${state_abbrev}_${table_name}'), lower('${state_abbrev}_${lookup_name}'));")