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 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 6084 about 12 years Aaron Marcuse-Kubitza Updated inputs/UNCC/Specimen/test.xml.ref inser...
  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 6086 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added reference_by_shortna...
  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.94 KB 6088 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
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

6084 11/08/2012 02:48 PM Aaron Marcuse-Kubitza

Updated inputs/UNCC/Specimen/test.xml.ref inserted row count

6083 11/08/2012 01:38 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Added threatened

6082 11/08/2012 01:21 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Remove private columns (plot.reallatitude, reallongitude) that should not be publicly visible

6081 11/08/2012 01:13 PM Aaron Marcuse-Kubitza

inputs/CVS/Organism/map.csv: Removed now-dropped realLatitude, realLongitude

6080 11/08/2012 01:12 PM Aaron Marcuse-Kubitza

inputs/CVS/Organism/map.csv: Removed now-dropped realLatitude, realLongitude

6079 11/08/2012 01:12 PM Aaron Marcuse-Kubitza

Added inputs/CVS/Organism/postprocess.sql to drop private realLatitude, realLongitude columns

View all revisions | View revisions

Also available in: Atom