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 5055 about 12 years Aaron Marcuse-Kubitza import_all: Added import of .TNRS datasource, w...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5063 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Renamed unscrubbedScienti...
  lib 5061 about 12 years Aaron Marcuse-Kubitza sql.py: pkey(): Get the table's actual primary ...
  mappings 5063 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Renamed unscrubbedScienti...
  schemas 5054 about 12 years Aaron Marcuse-Kubitza Moved tnrs table from public (schemas/vegbien.s...
  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
5063 09/27/2012 08:36 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Renamed unscrubbedScientificNameWithAuthorship to the more standard verbatimScientificNameWithAuthorship, which is available now that the original taxondetermination terms use the original* prefix

5062 09/27/2012 08:31 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Renamed verbatim* taxonomic terms to original* because in most datasources, they are in fact for the original taxon determination of the organism (which can be a completely different name than the primary determination), rather than merely unscrubbed versions of the primary taxonomic name elements. Note that SALVIAS's orig_* terms do appear to be merely unscrubbed versions, but it's not a problem to add an additional taxon determination for them.

5061 09/27/2012 08:14 AM Aaron Marcuse-Kubitza

sql.py: pkey(): Get the table's actual primary key column, rather than just using the first column in the table. Continue to return the first column in the table if the table has no primary key.

5060 09/27/2012 07:31 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/postprocess.sql: Use :table var instead of hardcoding the table name

5059 09/27/2012 07:30 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/postprocess.sql: Also add a primary key on Name_submitted, to prevent duplicate entries

5058 09/27/2012 07:27 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/: Added postprocess.sql which makes Name_submitted NOT NULL

5057 09/27/2012 07:25 AM Aaron Marcuse-Kubitza

sql.py: insert(): ignore mode: Also ignore NullValueException

5056 09/27/2012 07:24 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: %/install: Support custom postprocess.sql which specifies commands to run after the table is imported

5055 09/27/2012 07:10 AM Aaron Marcuse-Kubitza

import_all: Added import of .TNRS datasource, which happens synchronously before other datasources are imported

5054 09/27/2012 07:08 AM Aaron Marcuse-Kubitza

Moved tnrs table from public (schemas/vegbien.sql) to its own TNRS schema, which is created by a new .TNRS datasource. Note that .TNRS is included in the automated testing, but not yet in the import.

View all revisions | View revisions

Also available in: Atom