Project

General

Profile

Statistics
| Revision:

root @ 7851

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 almost 12 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 almost 12 years Aaron Marcuse-Kubitza Added planning/use_cases/rare_species.png
  schemas 7851 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: tnrs_input_name: accepted_...
  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
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())
7844 03/05/2013 09:59 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: Added back score_ok() and tnrs.tnrs_score_ok index
7843 03/05/2013 09:53 PM Aaron Marcuse-Kubitza

*.sql: Replaced concat_delim() with concat_ws(), which is built-in as of PostgreSQL 9.1 (http://stackoverflow.com/questions/1943433/postgresql-concat-ws-like-function)
7842 03/05/2013 09:08 PM Aaron Marcuse-Kubitza

inputs/U/Specimen/map.csv: Populated specimenHolderInstitutions

View all revisions | View revisions

Also available in: Atom