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 3701 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Added synchronization of back...
  bin 3696 over 12 years Aaron Marcuse-Kubitza bin/map: Don't create unneeded /_ignore/inLabel...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3710 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: binomial (full...
  lib 3709 over 12 years Aaron Marcuse-Kubitza exc.py: e_msg(): Fixed bug where exceptions wit...
  mappings 3710 over 12 years Aaron Marcuse-Kubitza mappings/VegX-VegBIEN.stems.csv: binomial (full...
  schemas 3712 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: aggregateoccurrence: Added...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.4 KB 3393 over 12 years Aaron Marcuse-Kubitza Moved archived imports and make targets to main...
README.TXT 8.25 KB 3701 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Added synchronization of back...
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
3712 08/01/2012 03:18 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: aggregateoccurrence: Added UNIQUE INDEX that makes an aggregateoccurrence unique within a taxonoccurrence. When the sourceaccessioncode isn't specified (as for individual organisms data, where this goes in plantobservation and taxonoccurrence), this ensures a 1:1 relationship between aggregateoccurrence and taxonoccurrence.

3711 08/01/2012 03:08 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonoccurrence: Added UNIQUE INDEX that makes a taxonoccurrence unique within a locationevent. When the sourceaccessioncode isn't specified (as for specimens data), this ensures a 1:1 relationship between taxonoccurrence and locationevent.

3710 08/01/2012 03:05 AM Aaron Marcuse-Kubitza

mappings/VegX-VegBIEN.stems.csv: binomial (full) plantname: Also mapped to an alternative for taxonoccurrence.sourceaccessioncode, for aggregate plots data that distinguishes taxonoccurrences only by plantname (such as CVS)

3709 08/01/2012 02:23 AM Aaron Marcuse-Kubitza

exc.py: e_msg(): Fixed bug where exceptions with nothing in e.args (such as StopIteration) caused a failed assertion. Fixed bug where exceptions with multiple values in e.args (such as certain IOErrors) caused a failed assertion.

3708 08/01/2012 01:27 AM Aaron Marcuse-Kubitza

sql.py: flatten(): Documented that shouldn't cache query because the temp table will usually be truncated after use

3707 08/01/2012 01:05 AM Aaron Marcuse-Kubitza

sql_gen.py: merge_not_null(): For clarity, use to_text() to represent NULL as the string 'NULL' instead of as the null sentinel for the column's type

3706 08/01/2012 01:02 AM Aaron Marcuse-Kubitza

sql_gen.py: Added to_text() and helper value null_as_str

3705 08/01/2012 12:52 AM Aaron Marcuse-Kubitza

mappings/VegX-VegBIEN.stems.csv: plantobservation: sourceaccessioncode, authorplantcode: Removed no longer needed mapping to specimenreplicate.sourceaccessioncode, since specimenreplicate for plots data is now identified by its plantobservation fkey, without needing its own sourceaccessioncode

3704 07/31/2012 10:41 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): ignore_cond(): Fixed bug where if is_literals, need to return NULL, instead of trying to filter invalid rows out of a nonexistant input table

3703 07/31/2012 09:57 PM Aaron Marcuse-Kubitza

mappings/VegX-VegBIEN.stems.csv: Replaced "/}" (with unnecessary "/") with "}"

View all revisions | View revisions

Also available in: Atom