Project

General

Profile

Statistics
| Revision:

root @ 7238

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 7037 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: Synchronization: %/download: ...
  bin 7233 almost 12 years Aaron Marcuse-Kubitza psql_script_vegbien: Added no_query_results opt...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7237 almost 12 years Aaron Marcuse-Kubitza inputs/.TNRS/public.unscrubbed_taxondeterminati...
  lib 7212 almost 12 years Aaron Marcuse-Kubitza csvs.py: sniff(): TSVs: Don't turn off quoting,...
  mappings 7215 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: fieldNumber (auth...
  schemas 7238 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: unscrubbed_taxondeterminat...
  to_do 7207 almost 12 years Aaron Marcuse-Kubitza Added to_do/timeline.2013.xls (from Brad, conve...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 11.7 KB 7231 almost 12 years Aaron Marcuse-Kubitza root Makefile: python-Darwin: Added instruction...
README.TXT 16.9 KB 7224 almost 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Checking free disk spa...
map 1001 Bytes 6949 about 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 38.1 KB 7222 almost 12 years Aaron Marcuse-Kubitza new_terms.csv: Regenerated
unmapped_terms.csv 13.1 KB 7201 almost 12 years Aaron Marcuse-Kubitza **/new_terms.csv, **/unmapped_terms.csv: Regene...

Latest revisions

# Date Author Comment
7238 01/16/2013 06:09 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: unscrubbed_taxondetermination_view: Do the tnrs_canon joins manually instead of using tnrs_canon, to allow PostgreSQL to use a nested loop join on just the needed tnrs rows instead of a hash self-join of all tnrs rows. The query planner is not yet advanced enough to automatically integrate the select on the view into the top-level joins list, which would make this change automatically.
7237 01/16/2013 05:52 AM Aaron Marcuse-Kubitza

inputs/.TNRS/public.unscrubbed_taxondetermination_view/scrub.make: rowsAdded(): Look at last 100 rows instead of last 10, because rows are added to the log file each time the script waits and the Inserted # new rows message must be in the tailed rows
7236 01/16/2013 05:48 AM Aaron Marcuse-Kubitza

inputs/.TNRS/public.unscrubbed_taxondetermination_view/scrub.make: rowsAdded(): Fixed bug where need to test if log file exists before using it in tail, because if tail fails and causes rowsAdded to return false, this error exit status will be indistinguishable from false for no rows added and the script will keep going
7235 01/16/2013 05:40 AM Aaron Marcuse-Kubitza

inputs/.TNRS/public.unscrubbed_taxondetermination_view/scrub.make: Fixed bug where need special handling to support being run as a .make script
7234 01/16/2013 03:35 AM Aaron Marcuse-Kubitza

input.Makefile: Editing import: Added unscrub to remove TNRS taxondeterminations
7233 01/16/2013 03:34 AM Aaron Marcuse-Kubitza

psql_script_vegbien: Added no_query_results option to hide results of calls to void functions
7232 01/16/2013 03:33 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added delete_scrubbed_taxondeterminations()
7231 01/16/2013 01:43 AM Aaron Marcuse-Kubitza

root Makefile: python-Darwin: Added instructions to install dateutil for Python 3 as well as Python 2, for use in PL/Python functions
7230 01/16/2013 01:42 AM Aaron Marcuse-Kubitza

root Makefile: python-Darwin: Added note that Python 2 comes preinstalled
7229 01/16/2013 01:15 AM Aaron Marcuse-Kubitza

Added inputs/GBIF/Specimen/postprocess.sql to remove institutions that we have direct data for

View all revisions | View revisions

Also available in: Atom