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 4547 about 12 years Aaron Marcuse-Kubitza inputs/VegBank/vegbank.~.clean_up.sql: Also ren...
  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 4542 about 12 years Aaron Marcuse-Kubitza schemas/py_functions.sql: Added pass-through _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
4547 09/10/2012 09:55 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Also rename taxonobservation.reference_id to taxonobservation_reference_id

4546 09/10/2012 09:51 PM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: $(logInstall*Add): Fixed bug where needed to only add -a flag for tee when tee was actually being used (in verbose mode), not when &> is used instead

4545 09/10/2012 09:49 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/header.csv: Updated for new renames in vegbank.~.clean_up.sql

4544 09/10/2012 09:34 PM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: `%/install: %/create.sql`: Also log the output of commands run after create.sql

4543 09/10/2012 09:30 PM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: Factored $(call logInstall,$*/) out into $(logInstall*)

4542 09/10/2012 09:25 PM Aaron Marcuse-Kubitza

schemas/py_functions.sql: Added pass-through _dateRangeStart(timestamp), _dateRangeEnd(timestamp) for datasource date columns that are already timestamps

4541 09/10/2012 09:23 PM Aaron Marcuse-Kubitza

inputs/VegBank/plantconcept_/header.csv: Updated for new renames in vegbank.~.clean_up.sql

4540 09/10/2012 09:11 PM Aaron Marcuse-Kubitza

inputs/VegBank/plantconcept_/create.sql: Use new plantconcept_plantnames()

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`

View all revisions | View revisions

Also available in: Atom