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 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5079 about 12 years Aaron Marcuse-Kubitza Added tnrs_db to scrub the taxonpaths in VegBIE...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5080 about 12 years Aaron Marcuse-Kubitza Added inputs/.TNRS/tnrs/tnrs.make to run tnrs_d...
  lib 5075 about 12 years Aaron Marcuse-Kubitza db_xml.py: put(): Added _alt optimization that ...
  mappings 5072 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: taxonomic terms: ...
  schemas 5078 about 12 years Aaron Marcuse-Kubitza Regenerated vegbien.ERD exports
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.99 KB 4752 over 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 11.3 KB 5040 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Starting column-based ...
map 1.28 KB 4981 about 12 years Aaron Marcuse-Kubitza root map: Fixed custom public schema override t...
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
5080 09/27/2012 11:25 AM Aaron Marcuse-Kubitza

Added inputs/.TNRS/tnrs/tnrs.make to run tnrs_db on VegBIEN

5079 09/27/2012 11:25 AM Aaron Marcuse-Kubitza

Added tnrs_db to scrub the taxonpaths in VegBIEN using TNRS

5078 09/27/2012 11:19 AM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

5077 09/27/2012 11:17 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath: Made it datasource-general and uniquely identified only by its taxonomicnamewithauthor so that the taxonpaths imported by the TNRS datasource will be matched and used directly when the other datasources are imported

5076 09/27/2012 11:10 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath: taxonpath_unique_within_datasource_by_name unique index: Just do duplicate elimination on the taxonomicnamewithauthor, since that is now a required field and is generated by concatenating all the other fields. Note that the inserted row counts change slightly because the concatenation makes some names equal that are split among the fields differently, such as when the genus is included in the species field.

5075 09/27/2012 10:51 AM Aaron Marcuse-Kubitza

db_xml.py: put(): Added _alt optimization that just returns the first arg if it's non-NULL

5074 09/27/2012 10:49 AM Aaron Marcuse-Kubitza

sql_gen.py: Added is_nullable()

5073 09/27/2012 10:49 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath.taxonomicnamewithauthor: Made it NOT NULL, so that all taxonpaths would have a concatenated name to feed to TNRS

5072 09/27/2012 10:37 AM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: taxonomic terms: Changed _first to _alt because some datasources have NULL values in scientificNameWithAuthorship or scientificName, so it can't just be used in place of the joined-together taxonomic ranks

5071 09/27/2012 10:19 AM Aaron Marcuse-Kubitza

db_xml.py: put(): Parse input columns and process values in separate loops, so that structural XML function optimization code can be inserted between them

View all revisions | View revisions

Also available in: Atom