Project

General

Profile

Statistics
| Revision:

root @ 7848

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 about 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 7564 over 11 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 over 11 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 over 11 years Aaron Marcuse-Kubitza Added planning/use_cases/rare_species.png
  schemas 7848 over 11 years Aaron Marcuse-Kubitza *.sql: concat_ws() calls: Fixed bug where need ...
  validation 5971 over 11 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 19 KB 7804 over 11 years Aaron Marcuse-Kubitza README.TXT: Full database import: To view progr...
fix_perms 97 Bytes 7560 over 11 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 over 11 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 over 11 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 over 11 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
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
7841 03/05/2013 09:07 PM Aaron Marcuse-Kubitza

mappings/VegCore.htm: Regenerated from wiki. Renamed specimenHolders to specimenHolderInstitutions to make it obvious that this is a list of institutions, such as would be in institutionCode in a DwC export.
7840 03/05/2013 09:06 PM Aaron Marcuse-Kubitza

inputs/SpeciesLink/Specimen/map.csv: Fixed embedded line endings
7839 03/05/2013 08:28 PM Aaron Marcuse-Kubitza

inputs/NY/Ecatalog_all/map.csv: PlantFungDescription->occurrenceRemarks: Removed "plant fungus" label because this field actually contains the specimenDescription

View all revisions | View revisions

Also available in: Atom