Project

General

Profile

Statistics
| Revision:

# Date Author Comment
12162 02/13/2014 07:58 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use current_schema instead of a hardcoded datasource name or psql variable

12161 02/13/2014 07:49 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: search_path: added public

12160 02/13/2014 07:45 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use the new type-specific validation schema names

12159 02/13/2014 07:41 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: removed type-specific prefix from the view name, which is now part of the validation schema

12069 02/06/2014 04:48 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/bien3_validations_traits_bien3.sql: include only records from the bien2_traits datasource, to ensure that the scope of all queries is limited to the datasource

12068 02/06/2014 04:16 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql (the output queries): added `SET search_path TO validation`

12067 02/06/2014 04:12 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12066 02/06/2014 04:11 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/bien3_validations_traits_bien3.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12065 02/06/2014 04:03 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12064 02/06/2014 03:47 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: added CREATE VIEW prefixes using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#prepend-CREATE-VIEW

12063 02/06/2014 02:48 PM Aaron Marcuse-Kubitza

added validation/aggregating/specimens/qualitative_validations_specimens.sql template, with query descriptions from NY/qualitative_validations_source_db_NYBG.sql

12062 02/06/2014 02:08 PM Aaron Marcuse-Kubitza

validation/**: removed old versions of by=-tagged files. these were not renamed in the last commit because there were newer versions that they collided with. note that because , sorts before . , the newer version (with more ",name@inst" tags) was correctly renamed instead of the older version.

12061 02/06/2014 01:56 PM Aaron Marcuse-Kubitza

validation/**: removed by=... indicators so that we don't have to add an author name every time a file is changed. the author indicator is not needed now that both Brad's and my edits are open-source.

12059 02/06/2014 12:33 PM Aaron Marcuse-Kubitza

added validation/aggregating/pipeline/aggregating_validations_pipeline.odg with .png export

12058 02/06/2014 11:09 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/FIA/bien3_validations_fia_input.sql.eml.txt. note that a .url file is not needed because this information is in the .eml.txt file.

12057 02/06/2014 10:57 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=: renamed to indicate that this is actually not Brad's original file, as the filename would seem to indicate

12056 02/06/2014 10:49 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/FIA/

12055 02/06/2014 03:46 AM Aaron Marcuse-Kubitza

validation/aggregating/*.by=Brad@iPlant*: placed under version control, since these are now open-source

12054 02/06/2014 03:41 AM Aaron Marcuse-Kubitza

validation/**: removed svn:ignore exclusion of iPlant-owned files, since these are now open-source

12037 02/04/2014 04:21 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant,Aaron@UCSB,: added missing .url extension

12036 02/03/2014 05:50 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=Brad@iPlant,Aaron@UCSB,

12035 02/03/2014 05:37 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original_mysql.by=Brad@iPlant,Aaron@UCSB,: renamed to indicate that it's just by Brad (it was the other file, the output queries, that were created by both of us)

12034 02/03/2014 05:32 PM Aaron Marcuse-Kubitza

added validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original_mysql.by=Brad@iPlant,Aaron@UCSB,

12033 02/03/2014 01:54 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/_archive/bien3_validations_salvias_vegbien.by=: removed trailing @

12032 02/03/2014 01:53 AM Aaron Marcuse-Kubitza

deleted validation/aggregating/traits/_archive/bien3_validations_traits_bien3.by=@, since there is already a version without the trailing @

12031 02/03/2014 01:48 AM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/_archive/bien3_validations_traits_original.by=: removed trailing (apparently, the escape for paths containing @ should only be used on the input path)

12021 02/02/2014 05:30 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.by=: moved to _archive/ so only the most recent version would be in the main plots/ directory

12017 02/01/2014 11:57 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/bien3_validations_traits_bien3.by=*: moved to _archive/

12016 02/01/2014 11:57 PM Aaron Marcuse-Kubitza

validation/aggregating/traits/BIEN2_traits/bien3_validations_traits_original.by=*: moved to _archive/

12009 01/24/2014 11:22 PM Aaron Marcuse-Kubitza

added validation/aggregating/, containing folders for Brad's scripts (the scripts themselves cannot be in the repository because they are not UCSB-owned)