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 4200 over 12 years Aaron Marcuse-Kubitza backups/: svn:ignore: Also ignore .*, which inc...
  bin 4696 about 12 years Aaron Marcuse-Kubitza Removed no longer used ucase_first
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4687 about 12 years Aaron Marcuse-Kubitza input.Makefile: Existing maps discovery: Substi...
  lib 4614 about 12 years Aaron Marcuse-Kubitza lib/mappings.Makefile: missing_mappings: Displa...
  mappings 4692 about 12 years Aaron Marcuse-Kubitza mappings/Makefile: Inline $(review_) because it...
  schemas 4702 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: plantname: Added comment d...
  to_do 4524 about 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 about 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.91 KB 4613 about 12 years Aaron Marcuse-Kubitza root Makefile: Maps validation: Removed no long...
README.TXT 10.9 KB 4677 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Added steps to record ...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...
new_terms.csv 8.9 KB 4615 about 12 years Aaron Marcuse-Kubitza input.Makefile: Maps validation: %/new_terms.cs...
unmapped_terms.csv 2.3 KB 4608 about 12 years Aaron Marcuse-Kubitza Generated global unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
4702 09/14/2012 09:08 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantname: Added comment documenting how to include a taxon name at a rank with no explicit column, by using the plantname table as an ordered linked list linked together using parent_id. (This method of using a linked list is one way of storing an ordered list of user-defined data. It is similar to using locationevent.previous_id to link successive reobservations of the same location together.) Note that plantname can store both the official tree of life and the data provider's own custom tree of life (or a subset thereof), with the two being distinguished by whether the data provider's or TNRS's taxondeterminations point to them.

4701 09/14/2012 08:53 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantname: Added verbatimrank to store ranks of custom taxonomic levels, such as rosids. Note that even if you specify a custom verbatimrank, you must also specify a closest-match rank from the taxonrank closed list. This ensures that every taxonomic name is placed in the correct relative order in the taxonomic hierarchy.

4700 09/14/2012 08:38 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantconcept: Made plantname_id optional because the datasource's plantconcepts do not need to be placed in the recursive plantname hierarchy

4699 09/14/2012 08:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantconcept: Added datasource_id and appropriate unique indexes to enable scoping by datasource. Moved plantcode right after datasource_id because it will be used for the sourceaccessioncode (if any).

4698 09/14/2012 08:21 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Moved plantconcept.plantdescription to plantname and renamed it to description, so that a taxon of any rank can have a description

4697 09/14/2012 08:02 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: plantconcept: Added denormalized taxonomic ranks from <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegBIEN_taxonomic_schema#Primary> and concatenated scientific name fields

4696 09/14/2012 07:25 PM Aaron Marcuse-Kubitza

Removed no longer used ucase_first

4695 09/14/2012 07:23 PM Aaron Marcuse-Kubitza

Removed no longer used bin/union

4694 09/14/2012 07:22 PM Aaron Marcuse-Kubitza

Removed no longer used join_union_sort

4693 09/14/2012 07:21 PM Aaron Marcuse-Kubitza

Removed no longer used ci_map, because all relevant mapping scripts are now case-insensitive

View all revisions | View revisions

Also available in: Atom