Project

General

Profile

Statistics
| Revision:

root @ 591

Name Size Revision Age Author Comment
  _archive 258 almost 13 years Aaron Marcuse-Kubitza Moved pre-BIEN 3 files into _archive folder
  bin 564 almost 13 years Aaron Marcuse-Kubitza repl: When matching words, treat _ as word boun...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 586 almost 13 years Aaron Marcuse-Kubitza VegBIEN: Renamed sourceaccessionnumber to sourc...
  lib 577 almost 13 years Aaron Marcuse-Kubitza PostgreSQL-MySQL.csv: Deal with MySQL assuming ...
  mappings 586 almost 13 years Aaron Marcuse-Kubitza VegBIEN: Renamed sourceaccessionnumber to sourc...
  schemas 591 almost 13 years Aaron Marcuse-Kubitza vegbien.sql: Made taxondetermination.determinat...
  test 586 almost 13 years Aaron Marcuse-Kubitza VegBIEN: Renamed sourceaccessionnumber to sourc...
Makefile 5.83 KB 418 almost 13 years Aaron Marcuse-Kubitza Makefiles: Added empty rules for targets withou...
README.TXT 392 Bytes 554 almost 13 years Aaron Marcuse-Kubitza README.TXT: Added make empty_db
map 723 Bytes 274 almost 13 years Aaron Marcuse-Kubitza Renamed util to bin

Latest revisions

# Date Author Comment
591 01/23/2012 03:04 PM Aaron Marcuse-Kubitza

vegbien.sql: Made taxondetermination.determinationdate optional because some determinations might not have a date
590 01/23/2012 02:47 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports
589 01/23/2012 02:46 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.authorspecimencode
588 01/23/2012 02:36 PM Aaron Marcuse-Kubitza

Adjusted vegbien.ERD.mwb
587 01/23/2012 02:34 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports
586 01/23/2012 02:33 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed sourceaccessionnumber to sourceaccessioncode to show that they are the data source's analog of accessioncode. Added sourceaccessioncode to all applicable tables because this is the database pkey, which is distinct from any author*code applied by the collector.
585 01/23/2012 01:56 PM Aaron Marcuse-Kubitza

vegbien.sql: Changed taxonbinmethod_keys to UNIQUE INDEX to take advantage of COALESCE for dealing with NULL values
584 01/23/2012 01:43 PM Aaron Marcuse-Kubitza

vegbien.sql: Renamed taxonbin to taxonbinmethod to reflect that it does not contain actual organisms (those go in aggregateoccurrence), but rather defined a method of aggregating organisms
583 01/23/2012 01:39 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed taxonbin.count because that belongs in aggregateoccurrence and taxonbin is more similar to a sampling method. Added taxonbin UNIQUE constraint.
582 01/23/2012 01:24 PM Aaron Marcuse-Kubitza

vegbien.sql: Do location duplicate elimination independently on code or lat/long, allowing duplicate entries with NULLs to exist when a location is incompletely specified

View all revisions | View revisions

Also available in: Atom