Project

General

Profile

Statistics
| Revision:

root @ 7854

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 7564 almost 12 years Aaron Marcuse-Kubitza lib/common.Makefile: remote server: Use jupiter...
  bin 7802 over 11 years Aaron Marcuse-Kubitza my2pg.data: Replace \0 (with the backslash) wit...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  inputs 7848 over 11 years Aaron Marcuse-Kubitza *.sql: concat_ws() calls: Fixed bug where need ...
  lib 7728 over 11 years Aaron Marcuse-Kubitza lib/common.Makefile: rsync: $(rsync): Also excl...
  mappings 7841 over 11 years Aaron Marcuse-Kubitza mappings/VegCore.htm: Regenerated from wiki. Re...
  planning 7786 over 11 years Aaron Marcuse-Kubitza Added planning/use_cases/rare_species.png
  schemas 7854 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: tnrs_input_name: taxonlabe...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 12.1 KB 7836 over 11 years Aaron Marcuse-Kubitza root Makefile: Datasources: scrub: Removed no l...
README.TXT 18.9 KB 7850 over 11 years Aaron Marcuse-Kubitza README.TXT: Full database import: Added instruc...
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
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
7854 03/06/2013 01:59 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: tnrs_input_name: taxonlabel.taxonomicname subquery: Don't exclude taxonlabels with a matched_label_id, because matched_label_id is no longer used to indicate that a name has a scrubbed name (this was used when all of TNRS was imported at the beginning of the import)
7853 03/06/2013 01:56 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: tnrs_input_name: accepted_name subquery: Renamed to the VegCore table name AcceptedTaxon
7852 03/06/2013 01:54 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: tnrs_input_name: taxonlabel.taxonomicname subquery: Use new MatchedTaxon view, which use VegCore column names where possible
7851 03/06/2013 01:46 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: tnrs_input_name: accepted_name subquery: Use new MatchedTaxon, AcceptedTaxon views, which use VegCore column names where possible
7850 03/06/2013 01:22 PM Aaron Marcuse-Kubitza

README.TXT: Full database import: Added instructions to run TNRS and view the TNRS log
7849 03/06/2013 10:21 AM Aaron Marcuse-Kubitza

README.TXT: Full database import: Removed no longer necessary command to scrub unscrubbed taxondeterminations
7848 03/05/2013 11:07 PM Aaron Marcuse-Kubitza

*.sql: concat_ws() calls: Fixed bug where need to surround it with NULLIF because concat_ws() returns '' instead of the required NULL when supplied with only NULL args
7847 03/05/2013 10:22 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: concat_ws() calls: Fixed bug where arguments were still enclosed in ARRAY[], because the name had been changed from concat_delim() but PostgreSQL removed the VARIADIC keyword without also removing the ARRAY[] wrapper
7846 03/05/2013 10:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Removed no longer needed unscrubbed_taxondetermination_view. Use taxonlabel joined to ScrubbedTaxon instead.
7845 03/05/2013 10:05 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: ScrubbedTaxon: Include only matches with a match score of at least 0.8 (score_ok())

View all revisions | View revisions

Also available in: Atom