Project

General

Profile

# Date Author Comment
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).

11523 10/31/2013 02:34 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: also join party_id to get the identifiedBy (not mapped yet). note that the inserted row count changes, because taxonobservation_ does not yet have a pkey to do a stable ordering with.

11520 10/31/2013 01:52 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: join taxonobservation to taxoninterpretation (as in CVS) instead of vice versa, since taxonobservation is the primary, operative table. having VegBank and CVS do things the same way helps ensure that fixes in one can transfer easily to the other.

11223 10/09/2013 06:16 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: updated runtime (20 s)

10998 09/16/2013 07:48 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: join starting with taxoninterpretation so that we can use the taxoninterpretation_id as the row_num (text strings, formed from concatenated #s cannot be used as a row_num). there is only 1 taxonobservation without a taxoninterpretation, so we can just include one row for each taxoninterpretation.

10688 08/19/2013 05:48 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: also join to plantname, since plantconcept.plantname may not always be populated when plantname.plantname is

10683 08/19/2013 01:53 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/map.csv: collector_id: remapped to UNUSED. removed LEFT JOIN collector_id->party since this field is never populated.

6175 11/14/2012 05:54 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: Also join to collector_id's party to include collector name

5698 10/23/2012 12:24 AM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: Removed dropping of row_num column, which is no longer added on non-CSV tables

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

inputs/VegBank/: Added taxonobservation_/