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 4751 about 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 4993 about 12 years Aaron Marcuse-Kubitza sql_io.py: cleanup_table(): Print 'Cleaning up ...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4988 about 12 years Aaron Marcuse-Kubitza inputs/VegBank/taxonimportance/map.csv: Documen...
  lib 4993 about 12 years Aaron Marcuse-Kubitza sql_io.py: cleanup_table(): Print 'Cleaning up ...
  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 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 9.99 KB 4752 about 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 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
4993 09/25/2012 08:44 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Print 'Cleaning up table' log message

4992 09/25/2012 08:41 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Also vacuum and reanalyze table

4991 09/25/2012 07:43 PM Aaron Marcuse-Kubitza

tnrs_client: Use new tnrs.tnrs_request()

4990 09/25/2012 07:43 PM Aaron Marcuse-Kubitza

Added tnrs.py

4989 09/25/2012 07:34 PM Aaron Marcuse-Kubitza

tnrs_client: Factored TNRS request code into separate function tnrs_request()

4988 09/25/2012 07:23 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonimportance/map.csv: Documented that taxonimportance is not 1:1 with taxonobservation

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

View all revisions | View revisions

Also available in: Atom