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 4511 about 12 years Aaron Marcuse-Kubitza vegbien_dest: schemas: Added public explicitly,...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4538 about 12 years Aaron Marcuse-Kubitza inputs/VegBank/vegbank.~.utils.sql: Removed har...
  lib 4509 about 12 years Aaron Marcuse-Kubitza sql.py: run_query(): DuplicateException: Also m...
  mappings 4507 about 12 years Aaron Marcuse-Kubitza mappings/: Removed no longer needed Veg+.cs-Veg...
  schemas 4532 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonrank: 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 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 10.4 KB 4487 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Added testing steps to...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...

Latest revisions

# Date Author Comment
4538 09/10/2012 08:30 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.utils.sql: Removed hardcoded schema name, which is set dynamically by input.Makefile using `SET search_path`

4537 09/10/2012 08:26 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.utils.sql: Added plantconcept_plantnames()

4536 09/10/2012 07:28 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.utils.sql: plantconcept_ancestors(): Made function STABLE instead of IMMUTABLE because it accesses DB tables

4535 09/10/2012 07:21 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Fixed bug where the original plantconcept table's columns needed to be renamed, rather than the derived table plantconcept_'s. Note that this script runs before any derived tables are created, so this would be the wrong place for these statements if the derived table's columns did need to be renamed.

4534 09/10/2012 07:05 PM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: $(dbExports): Sort each group of .sql files in lexical order, since $(wildcard) apparently does not sort them that way automatically on vegbiendev

4533 09/10/2012 06:53 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with stats from latest import. Corrected input row count of CTFS.TaxonOccurrence, which had been set to the inserted row count (which is right above it in the log file).

4532 09/10/2012 06:35 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonrank: Added comment documenting source of values

4531 09/07/2012 04:57 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/map.csv: Mapped observation_id to eventID

4530 09/07/2012 04:49 PM Aaron Marcuse-Kubitza

inputs/TEAM/: Added VL

4529 09/07/2012 04:43 PM Aaron Marcuse-Kubitza

inputs/VegBank/: Added taxonobservation_/

View all revisions | View revisions

Also available in: Atom