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 5172 about 12 years Aaron Marcuse-Kubitza import_all: Use new dedicated cleanup make targ...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5187 about 12 years Aaron Marcuse-Kubitza Added inputs/.TNRS/tnrs/cleanup.sql to cluster ...
  lib 5171 about 12 years Aaron Marcuse-Kubitza tnrs.py: encode_map: Added hidden minus sign, w...
  mappings 5180 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Added acceptedBinomial, o...
  schemas 5188 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added set_canon_taxonpath(...
  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 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Starting column-based ...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
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
5188 10/03/2012 03:02 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added set_canon_taxonpath() to set a taxonpath's canon_taxonpath_id after it has been created

5187 10/03/2012 02:48 AM Aaron Marcuse-Kubitza

Added inputs/.TNRS/tnrs/cleanup.sql to cluster TNRS.tnrs on tnrs_accepted_names. This keeps TNRS.tnrs sorted with the accepted names first.

5186 10/03/2012 02:46 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: %/cleanup: Also run any custom cleanup.sql provided in the subdir. %/install: Removed processing of postprocess.sql because no datasources are using it and because cleanup.sql can now be used for this purpose.

5185 10/03/2012 02:39 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: Added tnrs_accepted_names index, which sorts accepted names first, and cluster the table on this index. This ensures that the component-parsed entries for accepted names are created before any verbatim names that point to them.

5184 10/03/2012 02:37 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: %/cleanup: Documented that this removes any index comments, due to a PostgreSQL bug. (This occurs because ALTER TABLE recreates the index but not its comment.)

5183 10/03/2012 01:55 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: Removed hardcoded schema name

5182 10/03/2012 01:18 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/map.csv: Changed Name_matched_accepted_family comment to match analogous Name_matched_author comment

5181 10/03/2012 01:17 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/map.csv: Remapped Author_matched as the scientificNameAuthorship instead of Name_matched_author, because Name_matched_author contains the author based on the matched name, not the author in the original string, so it's not strictly from the original name

5180 10/03/2012 12:33 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Added acceptedBinomial, originalBinomial

5179 10/03/2012 12:29 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Added binomial

View all revisions | View revisions

Also available in: Atom