Project

General

Profile

Statistics
| Revision:

root @ 585

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 579 almost 13 years Aaron Marcuse-Kubitza Added inputs/TurboVeg
  lib 577 almost 13 years Aaron Marcuse-Kubitza PostgreSQL-MySQL.csv: Deal with MySQL assuming ...
  mappings 573 almost 13 years Aaron Marcuse-Kubitza NYBG mappings: Add mapping for CollectorNumber ...
  schemas 585 almost 13 years Aaron Marcuse-Kubitza vegbien.sql: Changed taxonbinmethod_keys to UNI...
  test 570 almost 13 years Aaron Marcuse-Kubitza VegBIEN: Renamed sourceid to author*code
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
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
577 01/23/2012 12:57 PM Aaron Marcuse-Kubitza

PostgreSQL-MySQL.csv: Deal with MySQL assuming that a timestamp field is NOT NULL
576 01/23/2012 12:53 PM Aaron Marcuse-Kubitza

vegbien.sql: Made specimen.taxonoccurrence_id required

View all revisions | View revisions

Also available in: Atom