Project

General

Profile

Statistics
| Revision:

root @ 9828

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 9496 over 11 years Aaron Marcuse-Kubitza added backups/*.md5
  bin 9785 over 11 years Aaron Marcuse-Kubitza bin/repl: added unescape_html() filter function...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  exports 8798 over 11 years Aaron Marcuse-Kubitza exports/: svn:ignore *.csv
  inputs 9828 over 11 years Aaron Marcuse-Kubitza bugfix: inputs/GBIF/raw_occurrence_record_plant...
  lib 9827 over 11 years Aaron Marcuse-Kubitza lib/sh/local.sh: psql(): don't put util in the ...
  mappings 9459 over 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: place.geo...
  planning 9671 over 11 years Aaron Marcuse-Kubitza *.url: mailto URLs: use the standard e-mail dot...
  schemas 9825 over 11 years Aaron Marcuse-Kubitza schemas/util.sql: added search_path_append()
  web 9786 over 11 years Aaron Marcuse-Kubitza lib/Firefox_bookmarks.reformat.csv: unescape HT...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
Makefile 12.4 KB 9742 over 11 years Aaron Marcuse-Kubitza /Makefile: new config target (part of install):...
README.TXT 22.8 KB 9532 over 11 years Aaron Marcuse-Kubitza bugfix: README.TXT: Full database import: scree...
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 450 Bytes 9074 over 11 years Aaron Marcuse-Kubitza *{.sh,run}: removed extra space between functio...
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
9828 06/11/2013 03:29 PM Aaron Marcuse-Kubitza

bugfix: inputs/GBIF/raw_occurrence_record_plants/postprocess.sql: institution_code index: create it idempotently using create_if_not_exists() and an explicit index name, so that a duplicate index doesn't get added each time postprocess.sql is run
9827 06/11/2013 03:27 PM Aaron Marcuse-Kubitza

lib/sh/local.sh: psql(): don't put util in the search_path because psql scripts now add it themselves if they need it, using `SELECT util.search_path_append(util);`
9826 06/11/2013 03:22 PM Aaron Marcuse-Kubitza

inputs/GBIF/raw_occurrence_record_plants/postprocess.sql: add util to the search_path so that postprocess.sql will also work when run by inputs/input.Makefile, which only puts the datasource (GBIF) in the search_path
9825 06/11/2013 03:18 PM Aaron Marcuse-Kubitza

schemas/util.sql: added search_path_append()
9824 06/11/2013 03:12 PM Aaron Marcuse-Kubitza

schemas/util.sql: added eval() to allow running EXECUTE outside of a function (and to echo the command that is run)
9823 06/11/2013 09:04 AM Aaron Marcuse-Kubitza

inputs/GBIF/raw_occurrence_record_plants/run: added import() runtime (5 h)
9822 06/10/2013 11:58 PM Aaron Marcuse-Kubitza

inputs/GBIF/raw_occurrence_record_plants/run: table.tsv.gz/make() runtime: noted that this excludes the upload time
9821 06/10/2013 11:58 PM Aaron Marcuse-Kubitza

inputs/GBIF/raw_occurrence_record_plants/run: added table.tsv.gz/upload() runtime (15 min)
9820 06/10/2013 11:48 PM Aaron Marcuse-Kubitza

added lib/runscripts/mysql.table.run (general to all MySQL datasources) and use it in inputs/GBIF/table.run
9819 06/10/2013 11:13 PM Aaron Marcuse-Kubitza

inputs/GBIF/raw_occurrence_record_plants/run: table.tsv/make(): to view runtime when using `screen`: keys used to scroll: added Ctrl-B/Ctrl-F for page-at-a-time scrolling (there are a lot of pages of output for the import() target!)

View all revisions | View revisions

Also available in: Atom