Project

General

Profile

Statistics
| Revision:
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 4751 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5661 about 12 years Aaron Marcuse-Kubitza tnrs_db: Updated with schema changes
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5668 about 12 years Aaron Marcuse-Kubitza inputs/test_taxonomic_names/test_scrub, README....
  lib 5642 about 12 years Aaron Marcuse-Kubitza sql.py: mk_select(): Don't add table0 to order_...
  mappings 5657 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Link taxondetermination to...
  schemas 5667 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added tnrs_input_name view...
  to_do 4524 about 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 about 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.86 KB 5459 about 12 years Aaron Marcuse-Kubitza Makefile: Moved setting of $(root) before inclu...
README.TXT 13 KB 5668 about 12 years Aaron Marcuse-Kubitza inputs/test_taxonomic_names/test_scrub, README....
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5668 10/19/2012 03:25 PM Aaron Marcuse-Kubitza

inputs/test_taxonomic_names/test_scrub, README.TXT: Documented that `make schemas/public/reinstall` must come after TNRS restore to recreate the tnrs_input_name view, which has a dependency on the TNRS schema

5667 10/19/2012 03:23 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added tnrs_input_name view for use by tnrs_db

5666 10/19/2012 12:53 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonlabel, taxonverbatim: Updated comments for new taxonlabel/taxonverbatim split

5665 10/19/2012 12:42 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonlabel_update_ancestors(): Use aliased types (http://www.postgresql.org/docs/8.3/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-TYPE) where possible

5664 10/19/2012 12:37 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonlabel_update_ancestors(): Adding new parent's ancestors: Change unique_violations to warnings so they don't abort the import. unique_violations should never happen unless there are cycles of two or mode nodes, but they seem to be happening nevertheless, so this will provide a workaround to that problem.

5663 10/19/2012 12:18 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated import times

5662 10/18/2012 04:58 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

5661 10/18/2012 04:55 PM Aaron Marcuse-Kubitza

tnrs_db: Updated with schema changes

5660 10/18/2012 04:54 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonverbatim: Removed subclass relationship to taxonlabel in order to allow multiple taxonverbatims to point to the same taxonlabel. This involves adding a taxonverbatim_id serial column and pointing all fkeys to taxonverbatim to that column.

5659 10/18/2012 04:43 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Fixed bug where needed to join on taxonverbatim before joining on taxonlabel, now that taxondetermination is linked directly to taxonverbatim. Interestingly, PostgreSQL did not flag this error when the schema was changed, but only when the schema was reloaded from the DDL.

View all revisions | View revisions

Also available in: Atom