Project

General

Profile

Statistics
| Revision:

root @ 6094

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 6087 about 12 years Aaron Marcuse-Kubitza vegbien_dest: $schemas: Don't include the , bef...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6094 about 12 years Aaron Marcuse-Kubitza inputs/SALVIAS/plotMetadata/: LEFT JOINed with ...
  lib 6027 about 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Remove SELECT pg_cata...
  mappings 6083 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Added threatened
  schemas 6093 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: threatened_taxonlabel_view...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 9.96 KB 6089 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: public: sch...
README.TXT 12.7 KB 6059 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Before starting import...
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 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
6094 11/08/2012 05:47 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/plotMetadata/: LEFT JOINed with lookup_MethodCode to create plotMetadata_
6093 11/08/2012 04:52 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: threatened_taxonlabel_view: Fixed bug where needed DISTINCT on resulting taxonlabel_id because some descendants apparently appear in multiple threatened taxonlabels' subtrees
6092 11/08/2012 04:42 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_*: Added threatened, using new threatened_taxonlabel lookup table
6091 11/08/2012 04:12 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: reference_by_shortname(): Fixed bug where need to use $-syntax to reference params in sql-language functions
6090 11/08/2012 04:07 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: threatened_taxonlabel_view: Use new reference_by_shortname()
6089 11/08/2012 03:45 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: public: schemas/public/uninstall: Fixed bug where need to run psql_vegbien without public in the search_path because it may have already been deleted
6088 11/08/2012 03:44 PM Aaron Marcuse-Kubitza

root Makefile: VegBIEN DB: Schemas: public: schemas/public/install: Fixed bug where need to run psql_vegbien without public in the search_path because it doesn't exist, by setting public to the empty string (deleting it)
6087 11/08/2012 03:42 PM Aaron Marcuse-Kubitza

vegbien_dest: $schemas: Don't include the , before $public if it has been set to the empty string (deleted)
6086 11/08/2012 03:27 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added reference_by_shortname(). Using this function instead of the manual query should force the query planner to evaluate this expression first, rather than complexly reordering joins to place this nested select as a filter condition.
6085 11/08/2012 03:00 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added threatened_taxonlabel derived table with generating view threatened_taxonlabel_view

View all revisions | View revisions

Also available in: Atom