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 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 3701 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Added synchronization of back...
  bin 3924 over 12 years Aaron Marcuse-Kubitza join: Added map_1_core_only option that uses on...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 3999 over 12 years Aaron Marcuse-Kubitza mappings/VegCSV-VegBIEN.specimens.csv: plotName...
  lib 3940 over 12 years Aaron Marcuse-Kubitza xml_func.py: _if(): Changed documentation about...
  mappings 3999 over 12 years Aaron Marcuse-Kubitza mappings/VegCSV-VegBIEN.specimens.csv: plotName...
  schemas 3998 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: locationevent: locationeve...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 9.03 KB 3845 over 12 years Aaron Marcuse-Kubitza README.TXT: After a new import: Added steps to ...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...

Latest revisions

# Date Author Comment
3999 08/14/2012 09:04 PM Aaron Marcuse-Kubitza

mappings/VegCSV-VegBIEN.specimens.csv: plotName: Removed authoreventcode mapping because plotName relates to the plot, not the plot event. (The locationevent is scoped by the location when the authoreventcode is not specified, so duplicate elimination will still occur correctly.) Instead map only authoreventcode-related fields (currently CVS's authorObsCode) to authoreventcode, via DwC's (confusingly-named) fieldNumber ("An identifier given to the event in the field").

3998 08/14/2012 08:40 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: locationevent: locationevent_unique_within_location: Added authoreventcode to index. It was already in the locationevent_unique_within_*parent*_by_authoreventcode index, but also needed to be in the no-parent (non-subplot) index. This fixes locationevent duplicate elimination when a locationevent sourceaccessioncode is not specified.

3997 08/14/2012 08:27 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: location_unique_within_datasource unique index: Added COALESCE and `WHERE sourceaccessioncode IS NOT NULL` now that sourceaccessioncode is nullable. Renamed location_unique_within_datasource and location_unique_authorlocationcode to location_unique_within_datasource_by_... to show that both are alternatives for globally unique keys. schemas/vegbien.ERD.mwb: Moved elements slightly to reduce the number of lines that need to be repositioned after syncing with the schema.

3996 08/14/2012 07:35 PM Aaron Marcuse-Kubitza

mappings/DwC2-VegBIEN.specimens.csv: Mapped verbatimElevation and samplingProtocol, for mergability with VegCSV

3995 08/14/2012 07:12 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with stats from latest import

3994 08/13/2012 06:12 PM Aaron Marcuse-Kubitza

mappings/VegCSV-VegBIEN.specimens.csv: location unique keys: Map to a new parent location for the location, instead of a parent locationevent for the locationevent. This much simpler mapping (which does not require _alt or _merge) is possible now that the necessary unique indexes have been set up.

3993 08/13/2012 05:52 PM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports, now including both pages in vegbien.ERD.core.pdf. Renamed schemas/vegbien.ERD.core.pdf to vegbien.ERD.pdf because it now includes the full schema.

3992 08/13/2012 05:48 PM Aaron Marcuse-Kubitza

schemas/filter_ERD.csv: Removed extraneous lines to improve readability. schemas/vegbien.ERD.mwb: Reconfigured elements to put only the most important ones in the core subset (the top page).

3991 08/13/2012 03:59 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: Made sourceaccessioncode optional if authorlocationcode is specified, since either of these fields can now serve as the unique key

3990 08/13/2012 03:39 PM Aaron Marcuse-Kubitza

mappings/VegCSV-VegBIEN.specimens.csv: Map to new location.authorlocationcode

View all revisions | View revisions

Also available in: Atom