Project

General

Profile

Statistics
| Revision:
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 11824 almost 11 years Aaron Marcuse-Kubitza backups/TNRS.backup: saved copy backups/TNRS.20...
  bin 11823 almost 11 years Aaron Marcuse-Kubitza bugfix: bin/import_all: run in errexit mode, so...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 11783 almost 11 years Aaron Marcuse-Kubitza derived/biengeo/README.txt: updated geoscrub.sh...
  exports 11599 almost 11 years Aaron Marcuse-Kubitza exports/2013-7-10.Naia.range_limiting_factors.c...
  inputs 11820 almost 11 years Aaron Marcuse-Kubitza inputs/CVS/^taxon_observation.**.sample/create....
  lib 11784 almost 11 years Aaron Marcuse-Kubitza lib/sh/util.sh: import_vars: don't overwrite va...
  mappings 11513 about 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped taxon_dete...
  planning 11791 almost 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: updated fo...
  schemas 11829 almost 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonlabel_update_ancestor...
  web 11798 almost 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 13.2 KB 11675 almost 11 years Aaron Marcuse-Kubitza fix: /Makefile: $(macPostgresLibs): added libpq...
README.TXT 25.1 KB 11800 almost 11 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: To r...
fix_perms 97 Bytes 7560 over 11 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 80.2 KB 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...
run 511 Bytes 11590 almost 11 years Aaron Marcuse-Kubitza /run: use new exports/geoscrub_input.csv.run
unmapped_terms.csv 33 KB 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...

Latest revisions

# Date Author Comment
11829 12/05/2013 01:31 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonlabel_update_ancestors(): don't create a performance-intensive nested transaction (EXCEPTION block) for each INSERT, because there should no longer be duplicate ancestors, so it's OK to abort the whole transaction if this assertion fails

11828 12/05/2013 01:03 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: taxonlabel_update_ancestors_on_{insert,update}(): only use either the matched taxon's ancestors or the parent's ancestors, to avoid issues related to duplication between these two ancestors lists. this also fixes a bug where the 2nd taxonlabel_update_ancestors() call assumes that the existing ancestors are for the old parent, when in fact they have actually just been set to those for the new matched taxon (which horribly confuses taxonlabel_update_ancestors()).

11827 12/04/2013 10:06 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _taxonlabel_set_parent_id(): just use a plain UPDATE statement, to avoid the significant parsing and stringification overhead of EXECUTE and quote_nullable(). it is not clear that EXECUTE is actually necessary to avoid caching the query plan, because the cache should be invalidated automatically when the table's ANALYZE statistics are regenerated.

11826 12/04/2013 10:00 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: removed unused function _taxonlabel_set_matched_label_id(), which refers to obsolete fields

11825 12/04/2013 09:58 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: synced to DB (the view renderer apparently changed the text of a view)

11824 12/04/2013 09:44 PM Aaron Marcuse-Kubitza

backups/TNRS.backup: saved copy backups/TNRS.2013-11-18.backup

11823 12/04/2013 07:26 PM Aaron Marcuse-Kubitza

bugfix: bin/import_all: run in errexit mode, so that if the user cancels reinstalling of the import schema, the script will then abort instead of continuing and using the wrong schema

11822 12/04/2013 06:56 PM Aaron Marcuse-Kubitza

bugfix: schemas/Makefile: %/uninstall: always confirm before removing an existing schema, not just for public and r*, because an auxiliary schema might also be used as $version and reinstalled by bin/import_all

11821 12/04/2013 06:04 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scrubbed_author: removed empty COALESCE around value (left over from when multiple values needed to be combined for many TNRS fields)

11820 12/04/2013 04:57 PM Aaron Marcuse-Kubitza

inputs/CVS/^taxon_observation.**.sample/create.sql: uncommented identifiedBy since this is now part of taxonObservation_

View all revisions | View revisions

Also available in: Atom