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 10873 about 11 years Aaron Marcuse-Kubitza added backups/vegbien.r10848.backup.md5
  bin 10871 about 11 years Aaron Marcuse-Kubitza bugfix: bin/import_all: use reimport_scrub inst...
  config 7801 over 11 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: mk_db: Added command...
  derived 10897 about 11 years Aaron Marcuse-Kubitza added derived/biengeo/Geovalidation_and_geoscru...
  exports 10853 about 11 years Aaron Marcuse-Kubitza exports/: svn:ignore *.zip
  inputs 11107 about 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: nest all ...
  lib 11033 about 11 years Aaron Marcuse-Kubitza lib/sql_io.py: put_table(): added link to new I...
  mappings 11107 about 11 years Aaron Marcuse-Kubitza bugfix: mappings/VegCore-VegBIEN.csv: nest all ...
  planning 11091 about 11 years Aaron Marcuse-Kubitza planning/timeline/timeline.2013.xls: updated fo...
  schemas 11148 about 11 years Aaron Marcuse-Kubitza bugfix: schemas/vegbien.sql: analytical_stem_vi...
  web 11092 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.6 KB 10539 over 11 years Aaron Marcuse-Kubitza bugfix: /Makefile: postgres-Linux: phppgadmin.c...
README.TXT 24.1 KB 11090 about 11 years Aaron Marcuse-Kubitza /README.TXT: Datasource setup: added link to Ex...
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
11148 09/30/2013 07:38 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: analytical_stem_view: plot__collectors: to include plot__collectors for nested stratum events, need to calculate the locationevent__contributors__array() for the locationevent and parent_event separately, and then COALESCE those, instead of just running locationevent__contributors__array() once on the COALESCE of the two IDs

11147 09/30/2013 07:34 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql: locationevent: added pull-forward trigger to populate location_id from the parent event. a pull-forward trigger must be used for this (not a COALESCE in analytical_stem_view) because the locationevent cannot even be found by analytical_stem_view if it does not have an associated location.

11146 09/30/2013 06:37 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: source: added required url field, which points to the source data and uniquely identifies the source. note that this differs from the id, which is a self-refential pkey (as described at wiki.vegpath.org/Web_interface#Clickable-fkeys).

11145 09/30/2013 05:47 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: fixed lines

11144 09/30/2013 05:38 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: regenerated exports and udpated image map

11143 09/30/2013 05:32 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: source: removed canon, because this would create too much complexity as a result of having multiple copies of the same source with different names. instead, source names will be scrubbed upon insert so that the row always contains the most accurate data, and there is only one copy of each source. this scrubbing may use the assistance of a thesaurus table w/ standard abbreviations, etc.

11142 09/30/2013 05:07 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: plot.name: merged with inherited name field

11141 09/30/2013 04:43 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: regenerated exports and udpated image map

11140 09/30/2013 04:40 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: source: added canon field. when there are multiple names for a source, this points to the canonically-named source. by default, points recursively to itself.

11139 09/30/2013 04:04 AM Aaron Marcuse-Kubitza

schemas/VegCore/ERD/VegCore.ERD.mwb: taxon_observation.taxon_occurrence: documented that when not provided (and not fillable from another field), a taxon_occurrence will be created with the same id as the taxon_observation. this operation should eventually be perfomed by a trigger.

View all revisions | View revisions

Also available in: Atom