inputs/bien2_traits/run: documented `make inputs/bien2_traits/validate` runtime (9 min)

schemas/vegbien.sql: public_validations: specimens queries: added autogenerated ~type tables

inputs/NY/run: `make inputs/NY/validate`: updated runtime (5 min)

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed DDL statements, using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#remove-DDL-statements

schemas/vegbien.sql: public_validations: added specimens queries to pipeline

validation/aggregating/specimens/qualitative_validations_specimens.sql: parameterize queries by datasource

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()

fix: schemas/vegbien.sql: public_validations.rematerialize_out_view(text, regclass): run with join_collapse_limit = 1 to fix query planner issues. this option has been tested on the queries that do not yet use the standard join sequence (plots #11,12,13,14,16,17,18), and all of these queries also work fine with join_collapse_limit = 1. (the standard join sequence is used to ensure both correctness of the query and compatibility with join_collapse_limit = 1, but in some cases is not needed for join_collapse_limit.)

validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: turn off join_collapse_limit instead of enable_mergejoin/enable_hashjoin, because join_collapse_limit is something that we will eventually want to turn off for all queries, which would avoid this query needing special handling. (on the other hand, enable_mergejoin/enable_hashjoin may be necessary for some queries and we probably won't turn them off for all queries.)

bugfix: lib/runscripts/table.run: table_make_install(): need to ignore skip_table() errexit