11/05/2013

11:49 AM BIEN 3 Revision 11563: Added an output CSV file option to geoscrub.sh.

Paul Sarando

11/04/2013

03:25 PM BIEN 3 Revision 11562: Added notes on running biengeo scripts to README.

Paul Sarando

10/31/2013

05:35 PM BIEN 3 Revision 11561: Added biengeo script options for data directories.

Added GADM and geonames.org data dir options to
update_validation_data.sh scripts.
Added geoscrub input data dir opti... Paul Sarando

05:35 PM BIEN 3 Revision 11560: Added update options to biengeo update_validation_data.sh

Added options to update only GADM data, only Geonames.org data, or
neither. In every case, the geonames-to-gadm scrip... Paul Sarando

05:35 PM BIEN 3 Revision 11559: Added cmd-line options to biengeo bash scripts.

All biengeo bash scripts now accept command line options to specify psql
user, host, and database values.
These optio... Paul Sarando

05:35 PM BIEN 3 Revision 11558: Fix biengeo script password prompt for postgres user.

Changed the DB_HOST variables in the biengeo bash scripts to a
DB_HOST_OPT variable that is blank by default.
Updated... Paul Sarando

05:35 PM BIEN 3 Revision 11557: Fixed TRUNCATE statement in truncate.geonames.sql.

Fixed the biengeo truncate.geonames.sql script to include all tables in
one TRUNCATE statement that have foreign-key ... Paul Sarando

05:35 PM BIEN 3 Revision 11556: Added more approx. runtimes to biengeo README.

Paul Sarando

05:35 PM BIEN 3 Revision 11555: Renamed biengeo install scripts to setup scripts.

It seems to make more sense to call these setup scripts, since they are
only setting up the database and tables, and ... Paul Sarando

10/30/2013

06:24 PM BIEN 3 Revision 11497: Updated biengeo README with new script workflow.

Paul Sarando

06:24 PM BIEN 3 Revision 11496: Split geovalidate.sh into install and update scripts.

Split geovalidate.sh into install.sh and update_gadm_data.sh scripts.
The install.sh script creates the databse and u... Paul Sarando

06:24 PM BIEN 3 Revision 11495: Refactored geonames.sh to update_geonames_data.sh

Renamed geonames.sh to update_geonames_data.sh and moved many of the SQL
statements from the bash script into support... Paul Sarando

06:24 PM BIEN 3 Revision 11494: Split up geonames-to-gadm.sql into 3 scripts.

Each script only operates on one table within a transaction.
These scripts now assume the tables have already been cr... Paul Sarando

06:24 PM BIEN 3 Revision 11493: Added geoscrub.sh script.

This script runs the load-geoscrub-input.sh, geonames.sql, and
geovalidate.sql scripts in order to load and scrub veg... Paul Sarando

01:53 PM BIEN 3 Revision 11479: Updated load-geoscrub script with configurable db.

load-geoscrub-input.sh now uses a variable with the db name defined at
the top of the script.
Updated the default db ... Paul Sarando

10/25/2013

06:15 PM BIEN 3 Revision 11450: Added db user and host to load-geoscrub-input.sh

The psql commands in load-geoscrub-input.sh will now connect with a
specific user on a specific host.
Updated the 'CO... Paul Sarando

04:22 PM BIEN 3 Revision 11448: Updated install instructions in the README.

Paul Sarando

02:04 PM BIEN 3 Revision 11443: Initial checkin of geoscrub install SQL files.

Added install.*.sql files that will do initial table creation for all
required tables.
Added a truncate.vegbien_geosc... Paul Sarando

02:04 PM BIEN 3 Revision 11442: Update load-geoscrub-input.sh to download from URL.

Removed logic to dump input data directly from the vegbien database and
to download the input from a URL provided by ... Paul Sarando

10/18/2013

05:23 PM BIEN 3 Revision 11347: Added instructions for dependencies in the README.

Paul Sarando

05:23 PM BIEN 3 Revision 11346: Added indexes to speed up geonames-to-gadm.sql.

Without these indexes, these queries could take hours to complete.
With them, the times more closely matched the time... Paul Sarando

05:23 PM BIEN 3 Revision 11345: Fixed a couple of syntax errors in geovalidate.sh.

Fixed a sql syntax error and a bash syntax error in the next line. Paul Sarando