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 7127 almost 12 years Aaron Marcuse-Kubitza import_all: Reinstall tnrs+accepted, for eventu...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7126 almost 12 years Aaron Marcuse-Kubitza Added inputs/.TNRS/tnrs+accepted/, which self-j...
  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 7122 almost 12 years Aaron Marcuse-Kubitza bin/map: Made $redo flag default to off, becaus...
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
7127 01/09/2013 02:23 AM Aaron Marcuse-Kubitza

import_all: Reinstall tnrs+accepted, for eventual use by unscrubbed_taxondetermination_view

7126 01/09/2013 02:20 AM Aaron Marcuse-Kubitza

Added inputs/.TNRS/tnrs+accepted/, which self-joins the TNRS results to their parsed accepted names

7125 01/09/2013 02:02 AM Aaron Marcuse-Kubitza

import_all: Directly import just the TNRS tables that should be imported, because some TNRS tables are included in import_order.txt so that they are part of the automated testing, but should not be imported at the same time as tnrs_accepted/tnrs_other

7124 01/09/2013 12:45 AM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated import times

7123 01/08/2013 11:24 PM Aaron Marcuse-Kubitza

with_all: $all mode: Fixed bug where need " " before # for it to be interpreted as a comment (unlike in a Makefile, where the " " often needs to be left out to avoid it being treated as part of a variable value)

7122 01/08/2013 10:55 PM Aaron Marcuse-Kubitza

bin/map: Made $redo flag default to off, because redo mode is slow (all tables have to be truncated) and is only needed when running tests on a public schema with data in it, which would not be the case on a development machine where tests are usually run

7121 01/08/2013 10:19 PM Aaron Marcuse-Kubitza

import_all: Made temporary vars local, so they wouldn't affect the calling shell

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.

View all revisions | View revisions

Also available in: Atom