Project

General

Profile

Statistics
| Revision:

root @ 11355

Name Size Revision Age Author Comment
  BIEN2 10896 about 11 years Aaron Marcuse-Kubitza added BIEN2/traits_observation_counts.xls
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  backups 11355 about 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 11286 about 11 years Aaron Marcuse-Kubitza bin/import_all: use just import_scrub, not reim...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 11347 about 11 years Paul Sarando Added instructions for dependencies in the README.
  exports 10853 about 11 years Aaron Marcuse-Kubitza exports/: svn:ignore *.zip
  inputs 11354 about 11 years Aaron Marcuse-Kubitza bugfix: inputs/.geoscrub/geoscrub_output/geoscr...
  lib 11353 about 11 years Aaron Marcuse-Kubitza bugfix: lib/sh/local.sh: pg_as_root(): need to ...
  mappings 11107 about 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: nest all ...
  planning 11344 about 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: "geoscrubb...
  schemas 11281 about 11 years Aaron Marcuse-Kubitza schemas/VegBIEN/attribution/BIEN 3 data use and...
  web 11246 about 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 12.7 KB 11150 about 11 years Aaron Marcuse-Kubitza /Makefile: mk_db: config/users.sql: unset ON_ER...
README.TXT 24.2 KB 11263 about 11 years Aaron Marcuse-Kubitza /README.TXT: Single datasource import: added po...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
run 661 Bytes 10881 about 11 years Aaron Marcuse-Kubitza /run: geoscrub_input/make(): updated runtime (2...
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
11355 10/18/2013 06:27 PM Aaron Marcuse-Kubitza

backups/TNRS.backup.md5: updated
11354 10/18/2013 06:13 PM Aaron Marcuse-Kubitza

bugfix: inputs/.geoscrub/geoscrub_output/geoscrub.csv.run: need to set $local_pg_database instead of $database because use_local (in psql()) does not currently avoid clobbering already-set versions of the applicable env vars
11353 10/18/2013 06:11 PM Aaron Marcuse-Kubitza

bugfix: lib/sh/local.sh: pg_as_root(): need to use -E (preserve environment) option to sudo, so that $schema, $table get passed through
11352 10/18/2013 06:05 PM Aaron Marcuse-Kubitza

bugfix: lib/sh/local.sh: psql(): only \set schema, table if $schema, $table are non-empty, because otherwise, you will get a "zero-length delimited identifier" error
11351 10/18/2013 05:30 PM Aaron Marcuse-Kubitza

added inputs/.geoscrub/geoscrub_output/geoscrub.csv.run to export the geoscrub table (must be run on vegbiendev)
11350 10/18/2013 05:29 PM Aaron Marcuse-Kubitza

lib/sh/local.sh: added require_remote()
11349 10/18/2013 05:29 PM Aaron Marcuse-Kubitza

lib/sh/db.sh: added pg_as_root()
11348 10/18/2013 05:28 PM Aaron Marcuse-Kubitza

lib/runscripts/util.run: added $wrap_fn to run any function via sudo, etc.
11347 10/18/2013 05:23 PM Paul Sarando

Added instructions for dependencies in the README.
11346 10/18/2013 05:23 PM Paul Sarando

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 times Jim noted in the sql
comments.

View all revisions | View revisions

Also available in: Atom