Project

General

Profile

Statistics
| Revision:

root @ 5682

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 5681 about 12 years Aaron Marcuse-Kubitza inputs/test_taxonomic_names/test_scrub: Remove ...
  lib 5642 about 12 years Aaron Marcuse-Kubitza sql.py: mk_select(): Don't add table0 to order_...
  mappings 5677 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed filter pr...
  schemas 5682 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_db_view: Fixed ...
  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.87 KB 5679 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: schemas/rot...
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
5682 10/19/2012 05:28 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Fixed bug where needed to join to taxonverbatim on taxonverbatim_id (the pkey) instead of taxonlabel_id, which used to be the pkey but is now an fkey
5681 10/19/2012 05:22 PM Aaron Marcuse-Kubitza

inputs/test_taxonomic_names/test_scrub: Remove any previous version of public.test_taxonomic_names before renaming public to it
5680 10/19/2012 05:19 PM Aaron Marcuse-Kubitza

inputs/test_taxonomic_names/test_scrub: Fixed bug where public.sql export did not include the "CREATE SCHEMA public" statement, because pg_dump doesn't add it to backups, by using new schemas/rename/% make target to first rename the public schema and then exporting it
5679 10/19/2012 05:12 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: schemas/rotate: Use new schemas/rename/%
5678 10/19/2012 05:12 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: Added schemas/rename/% to rename the public schema
5677 10/19/2012 04:54 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Removed filter preventing taxonomicStatus from being placed in taxonlabel if a morphospecies was provided, because the morphospecies actually never goes in the matched taxonlabel, only the verbatim taxonlabel
5676 10/19/2012 04:50 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: morphospecies: Also place it in the verbatim (input name's) taxonlabel. Note that it does not go in the matched name's taxonlabel, because that contains only fields from the matched name. The verbatim taxonlabel is thus a synonym of the matched taxonlabel where there is no morphospecies, or a child of it if there is a morphospecies.
5675 10/19/2012 04:36 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Do not place taxonomicStatus in taxonlabel if a morphospecies was provided, to prevent it from being incorrectly marked as accepted
5674 10/19/2012 04:25 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: morphospecies -> taxonverbatim.morphospecies: Fixed bug where needed suffix with _if statement then clause
5673 10/19/2012 04:23 PM Aaron Marcuse-Kubitza

inputs/test_taxonomic_names/_scrub/public.sql, TNRS.sql: Regenerated with schema changes

View all revisions | View revisions

Also available in: Atom