Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BIEN2 10896 about 11 years Aaron Marcuse-Kubitza added BIEN2/traits_observation_counts.xls
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  backups 11355 about 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 11456 about 11 years Aaron Marcuse-Kubitza bugfix: bin/with_all: @inputs default value: us...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 11479 about 11 years Paul Sarando Updated load-geoscrub script with configurable ...
  exports 11457 about 11 years Aaron Marcuse-Kubitza exports/2013-10-18.Brian_Enquist.Canadensys.csv...
  inputs 11440 about 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: added %/import_temp alia...
  lib 11462 about 11 years Aaron Marcuse-Kubitza lib/runscripts/import_subset.run: $version: use...
  mappings 11107 about 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: nest all ...
  planning 11464 about 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: add global...
  schemas 11482 about 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: sync_analytical_stem_to_vi...
  web 11403 about 11 years Aaron Marcuse-Kubitza web/links/index.htm: updated to Firefox bookmar...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
.rsync_filter.upload 33 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
.rsync_ignore 12 Bytes 10042 over 11 years Aaron Marcuse-Kubitza /.rsync_ignore: temp files: hide them on upload...
Makefile 12.7 KB 11150 about 11 years Aaron Marcuse-Kubitza /Makefile: mk_db: config/users.sql: unset ON_ER...
README.TXT 24.2 KB 11263 about 11 years Aaron Marcuse-Kubitza /README.TXT: Single datasource import: added po...
fix_perms 97 Bytes 7560 almost 12 years Aaron Marcuse-Kubitza Added root fix_perms
map 1001 Bytes 6949 almost 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
run 661 Bytes 10881 about 11 years Aaron Marcuse-Kubitza /run: geoscrub_input/make(): updated runtime (2...
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
11482 10/30/2013 02:45 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: sync_analytical_stem_to_view(): row_num: renamed to taxon_occurrence__pkey because previous taxon determinations have been removed, so each row is in fact a taxon_occurrence (~= VegCore.vegpath.org?ERD.taxon_occurrence)

11481 10/30/2013 02:20 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: analytical_stem_view: don't ORDER BY datasource, because this requires a slow full-table sort after the hash joins. (when selecting a subset of analytical_stem_view, nested loops are used automatically without needing an ORDER BY to force this.) to get the datasource-sorted order (plus a sort-order guarantee), you can still add a manual `ORDER BY datasource`, which will use a fast index scan on one of the datasource indexes.

11480 10/30/2013 01:58 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem: added row_num, which can serve as the taxon_observation ID (DwC occurrenceID)

11479 10/30/2013 01:53 PM Paul Sarando

Updated load-geoscrub script with configurable db.

load-geoscrub-input.sh now uses a variable with the db name defined at
the top of the script.
Updated the default db host to 'localhost' for this script.

11478 10/30/2013 12:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem: locationID... index: use eventDate instead of dateCollected since it's now eventDate that identifies the locationevent

11477 10/30/2013 12:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem: locationID... index: use eventDate instead of dateCollected since it's now eventDate that identifies the locationevent

11476 10/30/2013 04:41 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: use plot.** to obtain plot-related fields, so that the same code does not need to be maintained in both analytical_stem_view and plot.**

11475 10/30/2013 04:32 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: moved specimen-specific fields to occurrence section

11474 10/30/2013 03:50 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view, plot.**: added separate location__cultivated__bien

11473 10/30/2013 03:11 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added separate eventDate, in addition to dateCollected

View all revisions | View revisions

Also available in: Atom