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 6965 almost 12 years Aaron Marcuse-Kubitza backups/Makefile: Factored $(isMac) out into li...
  bin 7022 almost 12 years Aaron Marcuse-Kubitza pg_dump_vegbien: Renamed $opts env var to $dump...
  config 6321 about 12 years Aaron Marcuse-Kubitza Added config/bien_read_password
  inputs 7014 almost 12 years Aaron Marcuse-Kubitza inputs/NVS/Plot/map.csv: Corrected Plot ID mapp...
  lib 7008 almost 12 years Aaron Marcuse-Kubitza xml_func.py: Simplifying functions: Logic: _and...
  mappings 7021 almost 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Regenerated from wiki
  schemas 7019 almost 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: location: Removed location...
  to_do 4524 about 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 11.4 KB 6916 almost 12 years Aaron Marcuse-Kubitza Moved schemas-related commands from root Makefi...
README.TXT 16.3 KB 7003 almost 12 years Aaron Marcuse-Kubitza README.TXT: Schema changes: Update graphical ER...
map 1001 Bytes 6949 almost 12 years Aaron Marcuse-Kubitza vegbien_dest: Changed default $prefix to "", so...
new_terms.csv 30.4 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 about 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
7022 12/21/2012 03:33 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Renamed $opts env var to $dump_opts to avoid conflicting with other commands' vars of the same name

7021 12/21/2012 03:22 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Regenerated from wiki

7020 12/21/2012 03:20 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Regenerated from wiki

7019 12/21/2012 02:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: Removed location_unique_within_parent_by_sourceaccessioncode, which duplicates location_unique_within_creator_by_sourceaccessioncode because the sourceaccessioncode is globally unique

7018 12/21/2012 02:10 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: projectID: Use project.projectname if project.sourceaccessioncode isn't provided

7017 12/21/2012 02:02 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: location_unique_within_parent: Split into *_by_sourceaccessioncode and *_by_authorlocationcode_position, with each ID being matched separately. This way, if the initial import of a subplot's location provides both fields, but fkey references use only one field, the fkey references will still match the existing location because only one of the fields needs to match.

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

View all revisions | View revisions

Also available in: Atom