Project

General

Profile

Statistics
| Revision:
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 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 584 almost 13 years Aaron Marcuse-Kubitza vegbien.sql: Renamed taxonbin to taxonbinmethod...
  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 almost 13 years Aaron Marcuse-Kubitza Renamed util to bin

Latest revisions

# Date Author Comment
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

575 01/23/2012 12:47 PM Aaron Marcuse-Kubitza

vegbien.sql: Made several fields optional, adding defaults where needed

View all revisions | View revisions

Also available in: Atom