Project

General

Profile

Statistics
| Revision:

root @ 6086

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 6085 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added threatened_taxonlabe...
  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.89 KB 6023 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: DB and bien user: db...
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
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
6078 11/08/2012 01:10 PM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: Added back postprocess.sql, which is now used for one-time dropping of private columns that should not be publicly visible
6077 11/08/2012 12:47 PM Aaron Marcuse-Kubitza

input.Makefile: Maps building: %/.map.csv.last_cleanup: $(dict) canon/translate: Use new $(translate?)

View all revisions | View revisions

Also available in: Atom