Project

General

Profile

Statistics
| Revision:
  • svn:ignore: *

# Date Author Comment
12783 03/20/2014 08:13 PM Aaron Marcuse-Kubitza

inputs/VegBank/plantconcept_/create.sql: updated runtime (25 min, ~same)

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11601 11/08/2013 10:28 PM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/: need to remove inter-datasource duplicates from plot instead of the left-joined plot_ table, because the fkeys needed to do the cascading deletes are all to the plot table. this requires doing the column-renaming and postprocessing on plot before it's left-joined.

11396 10/21/2013 07:14 PM Aaron Marcuse-Kubitza

fix: bin/map: put template: comment out the "Put template:" label so that the output is valid XML, and displays properly in a browser rather than showing a syntax error

11224 10/09/2013 06:25 PM Aaron Marcuse-Kubitza

inputs/VegBank/plantconcept_/: mapped columns, since this is now included in import_order.txt and therefore gets processed by the column-renaming runscripts. note that this means that in taxonobservation_/map.csv, the plantconcept_ input column names need to be changed to what they are mapped to.

11178 10/09/2013 08:54 AM Aaron Marcuse-Kubitza

inputs/VegBank/plantconcept_/create.sql: documented runtime (21 min)

11177 10/09/2013 08:28 AM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/plantconcept_/: added new-style import files

11176 10/09/2013 08:27 AM Aaron Marcuse-Kubitza

bugfix: inputs/VegBank/import_order.txt: added plantconcept_, because new-style import needs it to be explicitly listed in import_order.txt in order to run it

10811 08/30/2013 05:37 AM Aaron Marcuse-Kubitza

inputs/VegBank/*/postprocess.sql: added primary keys to derived tables

10168 07/06/2013 02:22 PM Aaron Marcuse-Kubitza

inputs/*/*/logs: updated svn:ignore

5031 09/27/2012 12:33 AM Aaron Marcuse-Kubitza

input.Makefile: Staging tables installation: `%/install: %/create.sql`: Don't add a row number column to the created table because it is now added automatically to the temp table by column-based import (row-based import now also does not require a pkey for DB inputs)

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()

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

inputs/VegBank/: Added plantconcept_/

4521 09/07/2012 12:54 PM Aaron Marcuse-Kubitza

inputs/VegBank/: Added plantconcept_/