Project

General

Profile

Statistics
| Revision:

root @ 4936

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 4927 over 12 years Aaron Marcuse-Kubitza csv2db: COPY FROM mode: Removed no longer neede...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4931 over 12 years Aaron Marcuse-Kubitza inputs/ARIZ/Specimen/test.xml.ref: Updated afte...
  lib 4936 over 12 years Aaron Marcuse-Kubitza sql.py: DbConn.col_info(): Moved parsing of use...
  mappings 4922 over 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Added and mapped aggregat...
  schemas 4934 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Scope taxonpath instead of...
  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.1 KB 4793 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Added note that `make ...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...
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
4936 09/24/2012 11:06 AM Aaron Marcuse-Kubitza

sql.py: DbConn.col_info(): Moved parsing of user-defined datatypes to Python code, so that parsing for other composite types which also requires both data_type and udt_name can easily be added
4935 09/24/2012 11:03 AM Aaron Marcuse-Kubitza

sql_gen.py: Added ArrayType
4934 09/24/2012 10:29 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Scope taxonpath instead of taxon with taxonscope, because a morphospecies name is specific to a datasource entity, so it should go in the datasource-specific taxonpath table instead of the datasource-general taxon table
4933 09/24/2012 10:14 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonpath: Added otherranks array column to store ranked names without a named column. Documented that ranks with no named column should be stored in this new field instead of in a chain of taxons pointed to by taxon_id. This ensures that only the tree of life uses the taxon table.
4932 09/24/2012 09:47 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Removed no longer used table stemtag, which has been replaced by stemobservation.tag, stemobservation.tags
4931 09/21/2012 04:28 PM Aaron Marcuse-Kubitza

inputs/ARIZ/Specimen/test.xml.ref: Updated after reinstalling staging table with new sql_io.null_strs
4930 09/21/2012 04:22 PM Aaron Marcuse-Kubitza

inputs/VegBank/: Added stemlocation/
4929 09/21/2012 04:17 PM Aaron Marcuse-Kubitza

inputs/VegBank/: Added stemcount/
4928 09/21/2012 04:10 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Fixed bug where couldn't run any update statement when no columns are text
4927 09/21/2012 03:57 PM Aaron Marcuse-Kubitza

csv2db: COPY FROM mode: Removed no longer needed explicit column list, now that the initial table has the exact width of the CSV (the row_num is added later)

View all revisions | View revisions

Also available in: Atom