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 7037 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7293 almost 12 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: Added Max_score ...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7309 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: unscrubbed_taxondeterminat...
  lib 7290 almost 12 years Aaron Marcuse-Kubitza csvs.py: ColInsertFilter: Support adding multip...
  mappings 7307 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Mapped accepted* ...
  schemas 7309 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: unscrubbed_taxondeterminat...
  to_do 7207 almost 12 years Aaron Marcuse-Kubitza Added to_do/timeline.2013.xls (from Brad, conve...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 11.8 KB 7268 almost 12 years Aaron Marcuse-Kubitza root Makefile: Datasources: import: Use new imp...
README.TXT 17.2 KB 7300 almost 12 years Aaron Marcuse-Kubitza README.TXT: Full database import: freeing disk ...
map 1001 Bytes 6949 about 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
7309 01/18/2013 12:32 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Include the accepted name's row next to the matched name's row instead of merging the two together into one TNRS row, to allow including separate taxondeterminations for the matched and accepted names. Added Max_score from TNRS.tnrs.

7308 01/18/2013 12:25 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxondetermination_set_iscurrent(): Added new determinationtype accepted to sort order

7307 01/18/2013 12:01 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Mapped accepted* taxonomic name, now to separate accepted taxondetermination

7306 01/18/2013 11:35 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Regenerated from wiki

7305 01/18/2013 11:20 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxondetermination_set_iscurrent(): Changed TNRS determinationtype from computer to matched, to allow for a separate accepted determinationtype

7304 01/18/2013 10:57 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonlabel: Removed creationdate, which duplicates taxondetermination.determinationdate

7303 01/18/2013 10:08 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: isNewWorld: Removed no longer needed COALESCE to false, because newWorldCountries now uses false where applicable instead of NULL. This also ensures that isNewWorld will be NULL if there is no country name to test, which was not the case in the previous workaround.

7302 01/18/2013 10:02 AM Aaron Marcuse-Kubitza

Added inputs/newWorld/newWorldCountries/ with postprocess.sql that sets isNewWorld to false wherever it's NULL. (The input table only marks New World countries as true, but doesn't mark non-New World countries as false.)

7301 01/18/2013 09:50 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: isNewWorld: Fixed bug where need to COALESCE "newWorldCountries"."isNewWorld" to false, because it is only set to a boolean for countries that are New World

7300 01/18/2013 09:19 AM Aaron Marcuse-Kubitza

README.TXT: Full database import: freeing disk space: Updated import schema size, which is smaller due to the removed CTFS staging tables, removed duplicate rows, and possibly fewer index holes

View all revisions | View revisions

Also available in: Atom