Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 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 7037 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7103 almost 12 years Aaron Marcuse-Kubitza import_all: Make $dump_opts, $public_import loc...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7111 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Regenerated from wiki
  lib 7117 almost 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): ensure_cond(): Fixed bu...
  mappings 7102 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: identificationTyp...
  schemas 7120 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: unscrubbed_taxondeterminat...
  to_do 4524 about 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 11.3 KB 7082 almost 12 years Aaron Marcuse-Kubitza root Makefile: Removed $(subMake), which is now...
README.TXT 16.5 KB 7114 almost 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Fixed bug where `make ...
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 30.4 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
7120 01/08/2013 09:45 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Sort by taxondetermination.taxonoccurrence_id instead of taxondetermination_id to allow scanning the taxondetermination_single_current_determination index, which includes only current determinations and avoids needing to scan past many non-current determinations. Note that using taxonoccurrence_id does not create sort order ambiguity between taxondeterminations with the same taxonoccurrence_id, because there is only one current determination per taxonoccurrence.

7119 01/08/2013 09:32 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Inner-join to taxonverbatim and taxonlabel instead of LEFT JOINing, because only taxondeterminations with a taxonlabel can have accepted taxondeterminations (otherwise there would be no name to scrub)

7118 01/08/2013 09:30 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Inner-join to tnrs instead of LEFT JOINing, because only taxondeterminations whose taxonlabels have already been scrubbed by TNRS should have accepted taxondeterminations added. Removed now-unneeded filter by tnrs.Name_submitted IS NOT NULL, which is replaced by the inner join.

7117 01/08/2013 08:46 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): ensure_cond(): Fixed bug where need to wrap strings used in the tracked error message in strings.ustr()

7116 01/08/2013 08:33 PM Aaron Marcuse-Kubitza

xml_dom.py: replace_with_text(): Fixed bug where need to use scalar.is_nonnull_scalar() instead of is_scalar() to avoid converting None values to the string 'None'

7115 01/08/2013 08:32 PM Aaron Marcuse-Kubitza

scalar.py: Added is_nonnull_scalar()

7114 01/07/2013 08:17 PM Aaron Marcuse-Kubitza

README.TXT: Data import: Fixed bug where `make inputs/upload` needs to be run on local machine, not vegbiendev

7113 01/07/2013 08:16 PM Aaron Marcuse-Kubitza

sql.py: create_table(): Support creating a table like a view

7112 01/07/2013 08:04 PM Aaron Marcuse-Kubitza

sql.py: Added InvalidTypeException and parse it in parse_exception()

7111 01/07/2013 07:39 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Regenerated from wiki

View all revisions | View revisions

Also available in: Atom