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 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 4979 about 12 years Aaron Marcuse-Kubitza inputs/*/*/map.csv: Prefix a * to every term th...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4987 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed unnecessa...
  lib 4984 about 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Warn if inserting empty...
  mappings 4987 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Removed unnecessa...
  schemas 4986 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: taxonoccurrence: taxonoccu...
  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 9.99 KB 4752 over 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 11.5 KB 4985 about 12 years Aaron Marcuse-Kubitza README.TXT: Documented that if the row-based an...
map 1.28 KB 4981 about 12 years Aaron Marcuse-Kubitza root map: Fixed custom public schema override t...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
4987 09/25/2012 07:22 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Removed unnecessary /_first/# suffix for multiple terms in the same _exists expression, because _exists() only checks whether its node is non-empty, and it does not matter how many child nodes it contains

4986 09/25/2012 06:57 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxonoccurrence: taxonoccurrence_unique_within_locationevent unique index: Fixed bug where locationevent_id needed to be enclosed in COALESCE so that the unique constraint also applies to rows with NULL locationevent_ids (there is no other unique constraint handling these rows)

4985 09/25/2012 06:52 PM Aaron Marcuse-Kubitza

README.TXT: Documented that if the row-based and column-based imports produce different inserted row counts, this usually means that a table is underconstrained (the unique indexes don't cover all possible rows). The inserted row count difference occurs because column-based import collapses empty table rows into one insert, while row-based import performs an insert of the empty row for each input row. Without a unique index to combine multiple row-based inserts, extra rows will be added.

4984 09/25/2012 06:48 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Warn if inserting empty table rows

4983 09/25/2012 06:13 PM Aaron Marcuse-Kubitza

schemas/py_functions.sql: _namePart(): Fixed bug where it was returning the empty string instead of NULL

4982 09/25/2012 05:57 PM Aaron Marcuse-Kubitza

schemas/functions.sql, py_functions.sql: Added schema comment that functions must always return NULL in place of the empty string, to ensure that empty strings do not find their way into VegBIEN. Note that row-based import automatically removes empty strings because the intermediate values are stored in XML and our XML DOM traversing code auto-replaces the empty string with NULL. Column-based import, on the other hand, does not, because the intermediate data is stored in database temp tables instead of a DOM tree.

4981 09/25/2012 05:31 PM Aaron Marcuse-Kubitza

root map: Fixed custom public schema override to work with schemas lists that include public, by replacing public with the new public schema instead of just appending it

4980 09/25/2012 04:53 PM Aaron Marcuse-Kubitza

inputs/*/*/map.csv: Prefix a * to every term that's not in Veg+ for easy identification of unmapped terms when editing map.csv. Note that canon will remove the * when it finds a matching Veg+ term.

4979 09/25/2012 04:52 PM Aaron Marcuse-Kubitza

inputs/*/*/map.csv: Prefix a * to every term that's not in Veg+ for easy identification of unmapped terms when editing map.csv. Note that canon will remove the * when it finds a matching Veg+ term.

4978 09/25/2012 04:36 PM Aaron Marcuse-Kubitza

ins_col: Added column fill value param

View all revisions | View revisions

Also available in: Atom