Project

General

Profile

Statistics
| Revision:

root @ 587

Name Size Revision Age Author Comment
  _archive 258 about 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 about 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 587 almost 13 years Aaron Marcuse-Kubitza Regenerated vegbien.ERD exports
  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 about 13 years Aaron Marcuse-Kubitza Renamed util to bin

Latest revisions

# Date Author Comment
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
581 01/23/2012 01:15 PM Aaron Marcuse-Kubitza

vegbien.sql: Require location to have either an authorlocationcode or a lat/long. Distinguish between regular and subplots in UNIQUE constraint.
580 01/23/2012 01:10 PM Aaron Marcuse-Kubitza

vegbien.sql: Renamed location.latitude and longitude to publiclatitude, publiclongitude to reflect that they are not the actual lat/long. Switched to requiring reallatitude/reallongitude.
579 01/23/2012 01:02 PM Aaron Marcuse-Kubitza

Added inputs/TurboVeg
578 01/23/2012 12:58 PM Aaron Marcuse-Kubitza

vegbien.ERD.mwb: Deal with MySQL assuming that a timestamp field is NOT NULL

View all revisions | View revisions

Also available in: Atom