Project

General

Profile

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

Latest revisions

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

6170 11/14/2012 05:32 PM Aaron Marcuse-Kubitza

input.Makefile: Existing maps discovery: $(allTables): Fixed bug where need to remove extra whitespace before $(tables) when there are no $(joinedTables)

View all revisions | View revisions

Also available in: Atom