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 6965 over 11 years Aaron Marcuse-Kubitza backups/Makefile: Factored $(isMac) out into li...
  bin 6981 over 11 years Aaron Marcuse-Kubitza make_analytical_db: Automatically call export_a...
  config 6321 over 11 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7014 over 11 years Aaron Marcuse-Kubitza inputs/NVS/Plot/map.csv: Corrected Plot ID mapp...
  lib 7008 over 11 years Aaron Marcuse-Kubitza xml_func.py: Simplifying functions: Logic: _and...
  mappings 7009 over 11 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: locationID/locati...
  schemas 7016 over 11 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: elev...
  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 11.4 KB 6916 over 11 years Aaron Marcuse-Kubitza Moved schemas-related commands from root Makefi...
README.TXT 16.3 KB 7003 over 11 years Aaron Marcuse-Kubitza README.TXT: Schema changes: Update graphical ER...
map 1001 Bytes 6949 over 11 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
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
7016 12/21/2012 01:26 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: elevationInMeters: Use parent_location.elevation_m when location.elevation_m not provided

7015 12/21/2012 01:17 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: scientificName: Fixed bug where need to use accepted_taxon*label*.taxonomicname instead of accepted_taxonverbatim.taxonomicname, because taxonverbatim's name component fields aren't populated if the name doesn't match a scrubbed name. The datasource's own taxonverbatim can't be used for this because the canon_label_id refers to the concatenated taxonomic name owned by the TNRS datasource.

7014 12/21/2012 01:00 PM Aaron Marcuse-Kubitza

inputs/NVS/Plot/map.csv: Corrected Plot ID mapping to go to subplotID instead of locationID, because each subplot gets its own ID in this field

7013 12/21/2012 12:50 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: location_unique_within_parent: Also apply this constraint when sourceaccessioncode is provided, because it may be a concatenated value populated for use by the analytical DB but which is not used as an fkey by the datasource itself

7012 12/21/2012 12:30 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: locationID: Concatenate parent location's and subplot's IDs using '; ' instead of ' '

7011 12/21/2012 12:22 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_*: Renamed locationName to locationID because it's now globally unique (within the datasource) and can be used as a sourceaccessioncode

7010 12/21/2012 12:19 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: locationName: For subplots without their own sourceaccessioncode (globally unique ID), prepend the parent location's unique ID so that locationName is globally unique

7009 12/21/2012 12:07 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: locationID/locationName + subplot -> location.sourceaccessioncode mapping: Fixed bug where subplot was incorrectly being mapped to this field even when there was no location*. (This field can only be populated if both location* and subplot are specified.) Also only map locationID for this, to avoid inconsistencies where one table supplies locationID+subplot, while another table supplies locationName+subplot, but they both get mapped to the same field, preventing plots from being matched up with their observations when creating the analytical_stem.

7008 12/21/2012 11:31 AM Aaron Marcuse-Kubitza

xml_func.py: Simplifying functions: Logic: _and(), _or(): Evaluate an expression of only constant values

7007 12/21/2012 11:30 AM Aaron Marcuse-Kubitza

lists.py: Added and_(), or_()

View all revisions | View revisions

Also available in: Atom