Project

General

Profile

Statistics
| Revision:

root @ 6180

Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6179 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Renamed reference -> sourc...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6179 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Renamed reference -> sourc...
  lib 6169 about 12 years Aaron Marcuse-Kubitza lib/mappings.Makefile: Checking if $(termsSubdi...
  mappings 6179 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Renamed reference -> sourc...
  schemas 6180 about 12 years Aaron Marcuse-Kubitza Regenerated vegbien.ERD exports
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 10.1 KB 6102 about 12 years Aaron Marcuse-Kubitza root Makefile: Installation: Fixed bug where sc...
README.TXT 12.8 KB 6105 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Instead of using `make...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6180 11/14/2012 06:37 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports
6179 11/14/2012 06:30 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Renamed reference -> source to make this table more broadly applicable, and because this now stores the datasource metadata
6178 11/14/2012 06:19 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: referencename: Scope it by top-level datasource, because institutionCodes (which map to this field) are not globally unique. This involves renaming the previous reference_id field, which was for the matched reference, to matched_reference_id, to allow a scoping reference_id field.
6177 11/14/2012 06:16 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Made taxonoccurrence.verbatimcollectorname an fkey to party, and renamed it to collector_id
6176 11/14/2012 05:57 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/map.csv: Mapped new givenname, surname (from collector_id's party) to recordedBy
6175 11/14/2012 05:54 PM Aaron Marcuse-Kubitza

inputs/VegBank/taxonobservation_/create.sql: Also join to collector_id's party to include collector name
6174 11/14/2012 05:53 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Rename taxoninterpretation.party_id to taxoninterpretation_party_id to make it globally unique when joining taxoninterpretation to other tables
6173 11/14/2012 05:48 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Rename party.d_obscount to party_d_obscount to make it globally unique when joining with other tables
6172 11/14/2012 05:43 PM Aaron Marcuse-Kubitza

inputs/VegBank/vegbank.~.clean_up.sql: Rename taxoninterpretation.party_id to taxoninterpretation_party_id to make it globally unique when joining taxoninterpretation to other tables
6171 11/14/2012 05:35 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: Made taxonoccurrence.verbatimcollectorname an fkey to party, and renamed it to collector_id

View all revisions | View revisions

Also available in: Atom