Project

General

Profile

Statistics
| Revision:

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

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

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

PostgreSQL-MySQL.csv: Deal with PostgreSQL-style :: casts

573 01/23/2012 12:14 PM Aaron Marcuse-Kubitza

NYBG mappings: Add mapping for CollectorNumber to specimen.collectornumber_dwc

572 01/23/2012 12:08 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.collectornumber_dwc

571 01/23/2012 12:03 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed sourceid to author*code

570 01/23/2012 12:01 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed sourceid to author*code

569 01/23/2012 11:44 AM Aaron Marcuse-Kubitza

mappings: Map ScientificNameAuthor to plantconcept with rank author

568 01/23/2012 10:53 AM Aaron Marcuse-Kubitza

vegbien.sql: Removed sizeclass.*precision fields

567 01/23/2012 10:50 AM Aaron Marcuse-Kubitza

vegbien.sql: Added count field to taxonBin

566 01/23/2012 10:47 AM Aaron Marcuse-Kubitza

VegBIEN: Renamed place to locationplace

565 01/23/2012 10:40 AM Aaron Marcuse-Kubitza

vegbien.sql.make: Exclude 'CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql' to avoid restore errors

564 01/23/2012 10:20 AM Aaron Marcuse-Kubitza

repl: When matching words, treat _ as word boundary and ignore case.

563 01/20/2012 05:09 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed individualplant.height to overallheight

562 01/20/2012 02:34 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

561 01/20/2012 02:32 PM Aaron Marcuse-Kubitza

PostgreSQL-MySQL.csv: Convert double quotes to backticks (`)

560 01/20/2012 02:10 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

559 01/20/2012 02:09 PM Aaron Marcuse-Kubitza

vegbien.for_ERD.sql: Fixed syntax error in stratum table

558 01/20/2012 02:00 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports

557 01/20/2012 01:39 PM Aaron Marcuse-Kubitza

vegbien.sql: Renamed sizeclass.*accuracy to *precision to reflect intended purpose

556 01/20/2012 01:33 PM Aaron Marcuse-Kubitza

vegbien.sql: Added stem.diameteraccuracy

555 01/20/2012 01:22 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed taxonoccurrence.currentdetermination_id and originaldetermination_id because it's not possible to create a two-way pointer when the child-to-parent pointer is required (chicken-and-egg problem)

554 01/20/2012 01:05 PM Aaron Marcuse-Kubitza

README.TXT: Added make empty_db

553 01/20/2012 12:52 PM Aaron Marcuse-Kubitza

vegbien.sql: Added taxonoccurrence.currentdetermination_id and originaldetermination_id

552 01/20/2012 12:41 PM Aaron Marcuse-Kubitza

vegbien.ERD.mwb: Added stratum and place tables

551 01/19/2012 05:28 PM Aaron Marcuse-Kubitza

Added vegbien.ERD.png

550 01/19/2012 05:24 PM Aaron Marcuse-Kubitza

Added vegbien.ERD.svg

549 01/19/2012 05:21 PM Aaron Marcuse-Kubitza

Added vegbien.ERD.pdf

548 01/19/2012 05:19 PM Aaron Marcuse-Kubitza

Added vegbien ERD

547 01/19/2012 05:19 PM Aaron Marcuse-Kubitza

Ignore *.bak in schemas

546 01/19/2012 05:07 PM Aaron Marcuse-Kubitza

VegBIEN: specimen links directly to taxonoccurrence rather than indirectly via individualplant

545 01/19/2012 04:43 PM Aaron Marcuse-Kubitza

vegbien.sql: Made voucher fields NOT NULL

544 01/19/2012 04:41 PM Aaron Marcuse-Kubitza

vegbien.sql: Added voucher table

543 01/19/2012 04:26 PM Aaron Marcuse-Kubitza

VegBIEN: specimen links directly to taxonoccurrence rather than indirectly via individualplant

542 01/19/2012 04:22 PM Aaron Marcuse-Kubitza

VegBIEN: specimen links directly to taxonoccurrence rather than indirectly via individualplant

541 01/19/2012 04:12 PM Aaron Marcuse-Kubitza

Create schemas/vegbien.for_wiki.sql from schemas/vegbien.for_ERD.sql

540 01/19/2012 04:11 PM Aaron Marcuse-Kubitza

Added lib/ERD-wiki.csv to convert ERD SQL to human-readable wiki format

539 01/19/2012 04:10 PM Aaron Marcuse-Kubitza

schemas/vegbien.for_ERD.sql: Removed VegBank-internal fields from taxonoccurrence

538 01/19/2012 03:51 PM Aaron Marcuse-Kubitza

Removed no longer needed schemas/vegbien.my.sql

537 01/19/2012 03:51 PM Aaron Marcuse-Kubitza

PostgreSQL-MySQL.csv: Use \g<0> instead of \0 in replacements because \0 not supported. Replace fulltext with fulltext__ (note fulltext_ doesn't work).

536 01/19/2012 01:34 PM Aaron Marcuse-Kubitza

Added schemas/vegbien.for_ERD.sql and generated MySQL

535 01/19/2012 01:34 PM Aaron Marcuse-Kubitza

Regenerated schemas/vegbien.for_ERD.sql

534 01/19/2012 01:33 PM Aaron Marcuse-Kubitza

PostgreSQL-MySQL.csv: Deal with serial NOT NULL fields

533 01/19/2012 01:22 PM Aaron Marcuse-Kubitza

Generate MySQL DDL schemas/vegbien.my.sql from vegbien.sql

532 01/19/2012 01:22 PM Aaron Marcuse-Kubitza

Added repl spreadsheet to map PostgreSQL DDL to MySQL

531 01/19/2012 12:56 PM Aaron Marcuse-Kubitza

Ignore src subdirectories in inputs

530 01/19/2012 12:46 PM Aaron Marcuse-Kubitza

VegBIEN: Use stem instead of individualplant to store diameter/dbh

529 01/18/2012 05:57 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed no longer needed taxondetermination.plantname_id

528 01/18/2012 05:53 PM Aaron Marcuse-Kubitza

VegBIEN: Made taxondetermination.plantconcept_id required and plantname_id optional

527 01/18/2012 04:28 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.taxonoccurrence_id fkey

526 01/18/2012 03:47 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed no longer needed taxondetermination.individualplant_id, specimen_id fields

525 01/18/2012 01:57 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed plot to location to reflect that a location can also be used for specimens

524 01/18/2012 01:29 PM Aaron Marcuse-Kubitza

vegbien.sql: Added individualplant.stemcount

523 01/18/2012 12:38 PM Aaron Marcuse-Kubitza

vegbien.sql: Added accessioncode fields to existing, modified tables

522 01/18/2012 12:21 PM Aaron Marcuse-Kubitza

vegbien.sql: Added accessioncode fields to new tables

521 01/17/2012 04:56 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed no longer needed individualplant.taxonarea

520 01/17/2012 04:40 PM Aaron Marcuse-Kubitza

VegBIEN: Moved taxondetermination.sourceaccessionnumber and museum_id to specimen

519 01/17/2012 03:32 PM Aaron Marcuse-Kubitza

vegbien.sql: Split taxondetermination UNIQUE CONSTRAINT into one constraint for each main key (taxonoccurrence_id, specimen_id, individualplant_id) to deal with Postgres treating a row with NULL in any of those columns as distinct. Added CHECK constraint to require one of taxonoccurrence_id, specimen_id, individualplant_id to be NOT NULL.

518 01/17/2012 02:47 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed museumaccessionnumber to sourceaccessionnumber

517 01/17/2012 02:42 PM Aaron Marcuse-Kubitza

VegBIEN: Renamed authorcode to sourceid

516 01/17/2012 02:33 PM Aaron Marcuse-Kubitza

vegbien.sql: Updated sizeclass to use ranges for parameters and remove taxonarea

515 01/13/2012 05:25 PM Aaron Marcuse-Kubitza

input.Makefile: Fixed verify by making %.out: % rule use %.make instead

514 01/13/2012 05:24 PM Aaron Marcuse-Kubitza

input.Makefile: Moved verifications into one set of verify.* files

513 01/13/2012 05:18 PM Aaron Marcuse-Kubitza

input.Makefile: All tests are run in the same transaction, with output to test.out

512 01/13/2012 05:04 PM Aaron Marcuse-Kubitza

bin/map: Added support for processing multiple map_paths at once in the same transaction

511 01/13/2012 04:50 PM Aaron Marcuse-Kubitza

SALVIAS organisms mapping: Removed redundant PlotCode mapping because the association to plotevent is done with PlotID

510 01/13/2012 04:49 PM Aaron Marcuse-Kubitza

bin/map: Started adding support for multiple map_paths, all run in the same db transaction

509 01/13/2012 04:35 PM Aaron Marcuse-Kubitza

Filled in SALVIAS stems mappings. make test2's stems test fails because we don't wrap the import transaction around all the tests so that organisms are already in the database when stems are imported.

508 01/13/2012 04:28 PM Aaron Marcuse-Kubitza

mappings/Makefile: Corrected stemobservation to stem

507 01/13/2012 03:46 PM Aaron Marcuse-Kubitza

Use baseDistance/complexUserDefined/method to distinguish between different dbhs in VegX

506 01/13/2012 03:41 PM Aaron Marcuse-Kubitza

VegX mappings: Use baseDistance/value instead of baseDistance so we can later use complexUserDefined to distinguish between different types of dbh

505 01/13/2012 03:07 PM Aaron Marcuse-Kubitza

VegX-VegBIEN.organisms.csv: Added initial stems mappings

504 01/13/2012 03:06 PM Aaron Marcuse-Kubitza

mappings/Makefile: Updated VegX-VegBIEN.stems.csv input/output roots

503 01/13/2012 03:05 PM Aaron Marcuse-Kubitza

ch_root: Deal with roots followed by something other than \b

502 01/13/2012 02:41 PM Aaron Marcuse-Kubitza

input.Makefile: Remove *.out in new verify and test subdirs

501 01/13/2012 02:38 PM Aaron Marcuse-Kubitza

Moved inputs files into subdirs for maps, verify, and test operations

500 01/13/2012 02:00 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed taxondetermination.collector_id because that's now in specimen

499 01/13/2012 01:58 PM Aaron Marcuse-Kubitza

VegBIEN: Map to specimen.collector_id instead of taxondetermination

498 01/13/2012 01:27 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.collector_id column

497 01/13/2012 01:20 PM Aaron Marcuse-Kubitza

vegbien.sql: Changed taxondetermination.stem_id to individualplant_id

496 01/13/2012 01:16 PM Aaron Marcuse-Kubitza

vegbien.sql: Removed taxondetermination columns that have been moved to specimen

495 01/13/2012 01:14 PM Aaron Marcuse-Kubitza

VegBIEN: Merged specimen.collectionnumber and catalognumber_dwc fields. Removed NOT NULL constraints on several specimen columns because not all specimens have all identifiers. Mapped to new specimen fields.

494 01/13/2012 12:59 PM Aaron Marcuse-Kubitza

VegX-VegBIEN mapping: Map collectiondate to specimen table

493 01/13/2012 12:55 PM Aaron Marcuse-Kubitza

vegbien.sql: Added specimen.collectionnumber and collectiondate fields

492 01/13/2012 12:50 PM Aaron Marcuse-Kubitza

Updated README.TXT to reflect new make targets

491 01/12/2012 01:18 PM Aaron Marcuse-Kubitza

vegbien.sql: Added sizeclass columns