Project

General

Profile

Statistics
| Revision:
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 5985 about 12 years Aaron Marcuse-Kubitza import_times: Use $'' quoting to expand tab, in...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6006 about 12 years Aaron Marcuse-Kubitza inputs/.geoscrub/geoscrub_cleaned_unique/map.cs...
  lib 6005 about 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Removed assertion that ...
  mappings 6003 about 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Added samplingProtocolID
  schemas 6009 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.ERD.mwb: Added analytical_stem,...
  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 9.87 KB 5679 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: Schemas: schemas/rot...
README.TXT 12.5 KB 5966 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: After import, removed ...
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
6009 11/05/2012 11:14 PM Aaron Marcuse-Kubitza

schemas/vegbien.ERD.mwb: Added analytical_stem, analytical_aggregate to ERD

6008 11/05/2012 10:49 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_*: Added georeferenceValid, distanceToCountry_km, distanceToStateProvince_km

6007 11/05/2012 10:34 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added _m_to_km()

6006 11/05/2012 10:06 PM Aaron Marcuse-Kubitza

inputs/.geoscrub/geoscrub_cleaned_unique/map.csv: Removed geoscrubID->locationID mapping because it allowed multiple occurrences of the same placename/coordinates combination, which was causing problems when datasources try to link up to the geoscrub places (and end up matching multiple output rows for each input row)

6005 11/05/2012 09:54 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Removed assertion that into's row count be at least full_in_table's row count, because now that DISTINCT ON is used to satisfy the into table pkey, this is no longer necessarily true

6004 11/05/2012 09:15 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: method: method_unique: Added reference_id to make method unique within the datasource instead of globally unique within VegBIEN

6003 11/05/2012 09:12 PM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Added samplingProtocolID

6002 11/05/2012 08:48 PM Aaron Marcuse-Kubitza

mappings/VegCore-VegBIEN.csv: subplot locationevent: Only populate parent locationevent's location unique IDs if a subplot #/subplotID is actually specified. (The lack of a location unique ID will cause the parent locationevent's location to be removed, as well as the parent locationevent itself if there is no parent locationevent unique ID.) This fixes a bug where top-level plots in datasources that provide a nullable subplot #/subplotID were incorrectly getting connected to parent locationevents.

6001 11/05/2012 08:34 PM Aaron Marcuse-Kubitza

mappings/verify.plots.sql: Added # locations, # location events, which also include subplots

6000 11/05/2012 08:17 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/verify/plots.ref.sql: Standardized line wrapping to put ; on its own line in multi-line queries and at the end of the line in one-line queries

View all revisions | View revisions

Also available in: Atom