Project

General

Profile

Statistics
| Revision:

root/trunk/validation/aggregating/plots @ 13395

Name Size Revision Age Author Comment
  FIA 12678 over 10 years Aaron Marcuse-Kubitza validation/aggregating/plots/FIA/bien3_validati...
  SALVIAS 13103 over 10 years Aaron Marcuse-Kubitza removed old version validation/aggregating/plot...
  _archive 12061 almost 11 years Aaron Marcuse-Kubitza validation/**: removed by=... indicators so tha...
bien3_validations_salvias_vegbien.sql 19.8 KB 13395 over 10 years Aaron Marcuse-Kubitza validation/aggregating/plots/bien3_validations_...

Latest revisions

# Date Author Comment
13395 05/03/2014 12:47 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: removed no longer needed setting of join_collapse_limit (the column now used does not involve an additional join)
13394 05/02/2014 11:34 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _plots_21_tnrs_output_names: use scrubbed_unique_taxon_name (concatenated output name) because this is more similar to the concatenated name used in _plots_20_tnrs_input_names
13393 05/02/2014 11:22 PM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: needs to be run with `SET join_collapse_limit = DEFAULT; SET enable_hashjoin = off;` to produce the right query plan
13391 05/02/2014 10:42 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB
13103 04/10/2014 06:38 AM Aaron Marcuse-Kubitza

removed old version validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.sql. use validation/aggregating/plots/SALVIAS/_archive/bien3_validations_salvias_db_original.sql instead.
13061 04/07/2014 05:35 PM Aaron Marcuse-Kubitza

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()
12923 03/27/2014 03:57 AM Aaron Marcuse-Kubitza

validation/**.sql: replaced CREATE OR REPLACE VIEW with CREATE VIEW to match pg_dump output for diffing
12682 03/13/2014 05:14 PM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated to DB
12681 03/13/2014 05:13 PM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: removed `public.` qualifier
12678 03/13/2014 09:08 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/FIA/bien3_validations_fia_input.sql: _plots_19_count_of_inventories_per_plot_in_each_project: renamed to _plots_19_count_of_censuses_per_plot_in_each_project for clarity

View revisions

Also available in: Atom