Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5672 about 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: Added opts env var to allow sp...
  config 272 about 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 5670 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: tnrs_input_name: Use DISTI...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.86 KB 5459 over 12 years Aaron Marcuse-Kubitza Makefile: Moved setting of $(root) before inclu...
README.TXT 13 KB 5671 about 12 years Aaron Marcuse-Kubitza README.TXT: Schema changes: files to update wit...
map 989 Bytes 5158 over 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5672 10/19/2012 03:45 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Added opts env var to allow specifying options to a Makefile command, which does not take positional arguments

5671 10/19/2012 03:37 PM Aaron Marcuse-Kubitza

README.TXT: Schema changes: files to update with any renamings: Removed tnrs_db because that is now abstracted from the schema through the tnrs_input_name view. Note that PostgreSQL will automatically update tnrs_input_name with any table or column renames, which is the significant advantage of using a view rather than a hardcoded query.

5670 10/19/2012 03:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: tnrs_input_name: Use DISTINCT instead of DISTINCT ON because there is only one column

5669 10/19/2012 03:34 PM Aaron Marcuse-Kubitza

tnrs_db: Use new tnrs_input_name view to avoid hardcoding changing schema information

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

View all revisions | View revisions

Also available in: Atom