Project

General

Profile

Statistics
| Revision:

root @ 9994

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 9926 over 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 9925 over 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: use new mk_table() inst...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  exports 9928 over 11 years Aaron Marcuse-Kubitza added exports/_archive/
  inputs 9994 over 11 years Aaron Marcuse-Kubitza inputs/.TNRS/schema.sql: tnrs: vegbiendev updat...
  lib 9967 over 11 years Aaron Marcuse-Kubitza bugfix: lib/runscripts/table.run: remake_VegBIE...
  mappings 9882 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: genus->taxonlabel...
  planning 9978 over 11 years Aaron Marcuse-Kubitza planning/workflow/bien3_architecture.pptx: stag...
  schemas 9991 over 11 years Aaron Marcuse-Kubitza schemas/VegBIEN/taxonomy/higherPlantGroup.xlsx....
  web 9854 over 11 years Aaron Marcuse-Kubitza *{.sh,run}: use simpler .rel() instead of `. "$...
.htaccess 326 Bytes 8771 over 11 years Aaron Marcuse-Kubitza /.htaccess: use canonical URL without symlinks
Makefile 12.5 KB 9917 over 11 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres-Linux: phpPgAdmin: ...
README.TXT 23.3 KB 9970 over 11 years Aaron Marcuse-Kubitza /README.TXT: Full database import: disk space c...
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 433 Bytes 9916 over 11 years Aaron Marcuse-Kubitza /run: geoscrub_input/make(): documented runtime...
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
9994 06/20/2013 06:10 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: vegbiendev update steps: added `make backups/TNRS.backup-remake` to back up TNRS before making changes to it. this provides a more recent restore point than the last import in case the changes mess things up. (however, the last import's backup is usually sufficient unless TNRS has been run since then.)
9993 06/20/2013 05:53 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs_populate_fields(): added VACUUM ANALYZE and runtime (50 s)
9992 06/20/2013 05:42 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs_populate_fields(): updated runtime (16 min)
9991 06/20/2013 05:09 PM Aaron Marcuse-Kubitza

schemas/VegBIEN/taxonomy/higherPlantGroup.xlsx.src.txt: added Brad's comment that there are some holes in the Embryophyte subclasses list, and we need to validate it
9990 06/20/2013 04:49 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: documented that when changing this table's schema, you must also make the same changes on vegbiendev. included sample util.set_col_types() call with runtime (4 min).
9989 06/20/2013 03:58 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs_populate_fields(): updated runtime (16 min)
9988 06/20/2013 03:32 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): need to schema-qualify invoked functions
9987 06/20/2013 03:29 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): Is_homonym: use the *_is_homonym flag for whichever of genus or family (in that order) is NOT NULL, rather than horizontal-ORing potentially NULL values together
9986 06/20/2013 03:22 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: family_is_homonym(), genus_is_homonym(): need to return NULL instead of false when input family/genus is NULL. EXISTS does not support this, so STRICT is used to provide this functionality automatically.
9985 06/20/2013 03:19 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added family_is_homonym(), genus_is_homonym() and use them in tnrs_populate_fields()

View all revisions | View revisions

Also available in: Atom