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 4200 over 12 years Aaron Marcuse-Kubitza backups/: svn:ignore: Also ignore .*, which inc...
  bin 4511 over 12 years Aaron Marcuse-Kubitza vegbien_dest: schemas: Added public explicitly,...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4539 over 12 years Aaron Marcuse-Kubitza inputs/VegBank/vegbank.~.utils.sql: plantconcep...
  lib 4509 over 12 years Aaron Marcuse-Kubitza sql.py: run_query(): DuplicateException: Also m...
  mappings 4507 over 12 years Aaron Marcuse-Kubitza mappings/: Removed no longer needed Veg+.cs-Veg...
  schemas 4532 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonrank: Added comment d...
  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 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 10.4 KB 4487 over 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
4539 09/10/2012 09:09 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.utils.sql: plantconcept_plantnames(): Use SQL SELECT query and WITH clause (http://www.postgresql.org/docs/8.4/static/queries-with.html) instead of temp table, because PostgreSQL does not support using temp tables inside functions that are called repeatedly (http://archives.postgresql.org/pgsql-general/2006-02/msg00516.php; it results in an "out of shared memory" error)

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

View all revisions | View revisions

Also available in: Atom