Project

General

Profile

# Date Author Comment
14935 10/31/2014 01:39 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: analytical_stem_CVS: need to reset columns list to *

14932 10/31/2014 01:28 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added analytical_stem_CVS view

14930 10/31/2014 10:03 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added 2014-10-18.Juergen_Dengler.sPlot view

14929 10/31/2014 09:49 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added public_datasources()

14870 10/24/2014 03:50 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: geoscrub_input_new: need to join on the ARRAY[] of each column, to compare NULLs properly

14861 10/23/2014 03:43 PM Aaron Marcuse-Kubitza

schemas/public_.sql: view_full_occurrence_individual_view: join to taxonoccurrence: can use a USING join for this because plot.** only exports one locationevent_id column

14797 10/03/2014 05:06 PM Aaron Marcuse-Kubitza

schemas/public_.sql: geoscrub_input_view_modify(): add unique constraint on the same columns as geoscrub.geoscrub_output, as a sanity check to assist future debugging

14771 09/26/2014 07:10 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: view_full_occurrence_individual_view: materialize time: updated revision

14770 09/26/2014 06:45 PM Aaron Marcuse-Kubitza

schemas/public_.sql: view_full_occurrence_individual_view: materialize time: updated (2 days)

14672 09/08/2014 04:01 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: view_full_occurrence_individual_view and related views: synced to data dictionary spreadsheet, which adds back the links to the definitions (which used to be part of the column name itself)

14671 09/08/2014 03:50 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: analytical_plot, analytical_specimen: updated column names to be the same as analytical_stem, which these are a subset of

14645 09/04/2014 07:44 AM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view: re-ran *_view_modify(), which use the new non-blocking rematerialize_view()

14643 09/04/2014 07:21 AM Aaron Marcuse-Kubitza

schemas/public_.sql: view_full_occurrence_individual: re-ran view_full_occurrence_individual_view_modify(), which uses the new non-blocking rematerialize_view()

14611 08/28/2014 06:00 PM Aaron Marcuse-Kubitza

schemas/public_.sql: views that use view_full_occurrence_individual_view: use the view_full_occurrence_individual table instead, now that this is materialized.

14525 08/19/2014 04:39 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: don't include rows with New World coordinates that don't also have New World country names, since the NSR only uses the country name

14524 08/19/2014 04:26 PM Aaron Marcuse-Kubitza

schemas/public_.sql: native_status_resolver: removed rows with is_geovalid NULL, at Brad's request. note that this removes valid rows with standardized country names.

14522 08/19/2014 03:28 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: added country IS NOT NULL filter requested by Brad

14521 08/19/2014 02:35 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: native_status_resolver: remove the id because this prevents SELECT DISTINCT from having the desired effect. instead, the results will be joined back using the other columns.

14513 08/19/2014 01:23 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added native_status_resolver view, requested by Brad (wiki.vegpath.org/Data_requests)

14492 08/18/2014 01:58 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_best_match_jerry_lu index to facilitate finding names affected by the match-picking bug (#943)

14488 08/16/2014 05:55 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_*: renamed to view_full_occurrence_* at Brian M's and Martha's request (e-mails from Martha on 2014-8-12 at 17:37PT, and from Brian M on 2014-8-13 at 16:21PT). note that this change has already been made on vegbiendev.

14487 08/16/2014 05:51 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added view_full_occurrence_individual_*GBIF, analytical_stem_*GBIF requested by Mark. note that this change has already been made on vegbiendev.

14484 08/16/2014 05:11 PM Aaron Marcuse-Kubitza

schemas/public_.sql: view_full_occurrence_individual, analytical_stem: renamed columns to shortened names at Brian M's request (e-mail from Martha on 2014-8-12 at 17:37PT). note that this change has already been made on vegbiendev.

14483 08/16/2014 02:58 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: renamed to analytical_stem since this replaces the materialized analytical_stem table. note that this change has already been made on vegbiendev.

14482 08/16/2014 02:35 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_*: renamed to view_full_occurrence_* at Brian M's request (e-mail from Martha on 2014-8-12 at 17:37PT). note that this change has already been made on vegbiendev.

14481 08/16/2014 01:20 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_individual: re-ran viewFullOccurrence_individual_view_modify() to udpate this

14478 08/16/2014 12:29 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_individual_view: CREATE INDEX runtime: documented 2-column runtime (~2 h)

14473 08/15/2014 04:13 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_individual_view: added "after updating this" instructions

14472 08/15/2014 04:01 PM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_individual_view: documented CREATE INDEX runtime (10 min - 1.5 h depending on the datatype and % populated)

14468 08/11/2014 07:48 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_name index

14467 08/11/2014 07:46 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_family index

14466 08/11/2014 07:10 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_species_binomial index

14465 08/11/2014 05:28 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: *_view_modify(): need to set the search_path so that tables are created in the same schema as the function, rather than whichever schema happens to be at the beginning of the search_path

14464 08/11/2014 05:19 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: analytical_stem_view_modify(): updated to support being used directly instead of via a materialized table

14463 08/11/2014 05:13 AM Aaron Marcuse-Kubitza

schemas/public_.sql: removed no longer used analytical_stem. use analytical_stem_view or viewFullOccurrence_individual instead.

14462 08/11/2014 05:08 AM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: viewfulloccurrence_individual_view_modify(): fixed capitalization in function name (needs "" to preserve case)

14461 08/11/2014 05:03 AM Aaron Marcuse-Kubitza

schemas/public_.sql: other derived views: use viewFullOccurrence_individual instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)

14460 08/11/2014 05:01 AM Aaron Marcuse-Kubitza

schemas/public_.sql: validation views: use analytical_stem_view instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)

14459 08/11/2014 04:57 AM Aaron Marcuse-Kubitza

schemas/public_.sql: derived views: use analytical_stem_view instead of analytical_stem because analytical_stem is no longer materialized (viewFullOccurrence_individual_view is materialized instead)

14455 08/11/2014 04:05 AM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: analytical_stem_view: regenerated columns list for viewFullOccurrence_individual (instead of viewFullOccurrence_individual_view)

14450 08/11/2014 01:46 AM Aaron Marcuse-Kubitza

schemas/public_.sql: removed no longer used threatened_taxonlabel_view. use iucn_red_list_view instead.

14449 08/11/2014 01:35 AM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_individual_view: documented materialize time (22 h)

14448 08/10/2014 05:53 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: removed no longer used scrubbed_unique_taxon_name. the scrubbed name ranks are now generated from the other TNRS columns instead.

14444 08/10/2014 03:42 AM Aaron Marcuse-Kubitza

schemas/public_.sql: viewFullOccurrence_*: documented materialize time

14442 08/09/2014 10:17 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: use new materialized viewFullOccurrence_individual

14441 08/09/2014 10:08 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_individual by running viewFullOccurrence_individual_view_modify()

14440 08/09/2014 10:05 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_individual_view_modify(), analogous to analytical_stem_view_modify()

14436 08/09/2014 08:46 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: removed no longer used view ValidMatchedTaxon. use taxon_scrub instead.

14435 08/09/2014 08:44 PM Aaron Marcuse-Kubitza

schemas/public_.sql: iucn_red_list_view: use taxon_scrub instead of ValidMatchedTaxon since they are equivalent

14434 08/09/2014 08:42 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_scrub: use taxon_best_match directly, to avoid the need for a separate ValidMatchedTaxon view

14433 08/09/2014 08:25 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_scrub: merged synonymous columns

14432 08/09/2014 08:11 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: taxon_scrub: documented steps to merge synonymous columns

14431 08/09/2014 07:45 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: removed no longer used view MatchedTaxon. use taxon_best_match instead.

14430 08/09/2014 07:43 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: ValidMatchedTaxon: use taxon_best_match now that it's equivalent to MatchedTaxon

14429 08/09/2014 07:38 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: tnrs_input_name: use taxon_match instead of taxon_best_match because there is no index on taxon_match that includes just the filters used by taxon_best_match

14428 08/09/2014 07:37 PM Aaron Marcuse-Kubitza

schemas/public_.sql: tnrs_input_name: use taxon_best_match now that it's equivalent to MatchedTaxon

14426 08/09/2014 07:19 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: merged synonymous columns

14424 08/09/2014 06:52 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: removed no longer used taxon_scrub.scrubbed_unique_taxon_name.* . use taxon_scrub instead.

14423 08/09/2014 06:50 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_scrub: use taxon_match derived columns instead of the incorrect values in taxon_scrub.scrubbed_unique_taxon_name.* (which does not work with the multi-match strategy)

14422 08/09/2014 05:54 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: MatchedTaxon: use derived columns from taxon_match. this also incorporates the fixes in the new derived columns.

14421 08/09/2014 05:27 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_scrub: use derived columns from taxon_match. this also incorporates the fixes in the new derived columns.

14419 08/08/2014 07:13 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_{CVS,VegBank,NCU} for Bob

14417 08/05/2014 05:31 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to port derived column changes to vegbiendev: derived_cols_export() code: documented runtime (6 h)

14416 08/04/2014 06:25 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: removed no longer used derived column __accepted_infraspecific_label, which had a buggy formula that broke derived_cols_populate()

14414 08/04/2014 06:17 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: removed no longer used derived column __accepted_infraspecific_label, which had a buggy formula that broke derived_cols_populate()

14413 08/04/2014 06:10 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: to remove a column: updated instructions

14388 07/28/2014 11:58 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views

14379 07/28/2014 04:45 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: derived_col_update(): also need steps to drop column, because DROP __ CASCADE doesn't work when there are dependent views

14378 07/28/2014 04:33 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _accepted_infraspecific{rank,epithet}: use array slice of new _accepted{genus,specific_epithet,infra_{rank,epithet}}, which is simpler than using remove_prefix() in __accepted_infraspecific_label

14377 07/28/2014 04:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: "[accepted_]genus__@DwC__@vegpath.org": don't need to use *Accepted_name anymore because _accepted{genus,specific_epithet,infra_{rank,epithet}} is now generated from *Accepted_name

14376 07/28/2014 04:02 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": renamed to "__accepted_{genus,specific_epithet,infra_{rank,epithet}}" since this now includes these other ranks as well

14375 07/28/2014 03:48 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": use "*Accepted_name" instead of "Accepted_species[_binomial]__@TNRS__@vegpath.org" (from "*Accepted_name_species") because Accepted_name_species apparently sometimes does not match the Accepted_name and uses malformed Unicode characters

14368 07/26/2014 10:16 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: `inputs/.TNRS/data.sql.run refresh`: documented runtime (1 min)

14367 07/26/2014 10:15 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use "Accepted_species[_binomial]__@TNRS__@vegpath.org" instead of "*Accepted_name_species". this fixes a bug in __accepted_infraspecific_label where Accepted_name_species with trailing whitespace could not be prefix-removed from names that contained just a species binomial.

14366 07/26/2014 09:57 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added derived column "Accepted_species[_binomial]__@TNRS__@vegpath.org", which removes trailing whitespace

14365 07/26/2014 08:58 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added steps to remove a column and to add a non-derived column

14364 07/26/2014 08:48 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: merged into "to add a new derived column"

14363 07/26/2014 08:44 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: to add columns in the middle: renamed to "to move a column to the middle" for clarity

14362 07/26/2014 08:38 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: to populate a new column: updated to use util.derived_col_update()

14361 07/26/2014 08:24 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns: also need to run util.recreate_view()

14360 07/26/2014 08:19 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns at the end: don't need to run `rm=1 inputs/.TNRS/data.sql.run` because this is now run by `make schemas/remake`

14359 07/26/2014 08:13 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views

14358 07/26/2014 07:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching

14357 07/26/2014 07:43 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match.__accepted_infraspecific_label: need to use case-insensitive matching of the removed prefix because TNRS lowercases part of the Accepted_name

14356 07/26/2014 07:40 PM Aaron Marcuse-Kubitza

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching

14351 07/26/2014 06:17 PM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view_modify(): added repopulate param, which is passed to rematerialize_view()

14347 07/26/2014 05:16 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: use wrapper for util.remove_prefix() so CHECK constraints that use it don't get dropped when the util schema is reinstalled

14346 07/26/2014 04:32 PM Aaron Marcuse-Kubitza

schemas/public_.sql: *_view_modify(): use util.rematerialize_view(), which now supports table mods

14338 07/25/2014 09:13 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: use viewFullOccurrence_individual_view to avoid duplicated code between the views. this moves the stem-related columns to the end of the view.

14337 07/25/2014 06:26 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added viewFullOccurrence_individual_view

14332 07/25/2014 02:21 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: COMMENT: added steps to port derived column changes to vegbiendev

14330 07/25/2014 12:41 PM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: taxon_match: derived columns: use new "matched~Name[_no_author]___@TNRS__@vegpath.org" instead of "*Name_matched" so that "No suitable matches found." is removed before concatenating with other fields

14329 07/25/2014 12:14 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "matched~Name[_no_author]___@TNRS__@vegpath.org", which removes the "No suitable matches found." string

14328 07/22/2014 06:50 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: reordered derived columns in dependency order

14327 07/22/2014 06:46 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org": need to use "[accepted_]genus__@DwC__@vegpath.org" rather than "*Accepted_name" for this for rank = genus

14326 07/22/2014 06:44 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"

14325 07/22/2014 06:41 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: "[accepted_]genus__@DwC__@vegpath.org": need to populate this for rank = genus

14324 07/22/2014 05:47 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"

14323 07/22/2014 05:30 AM Aaron Marcuse-Kubitza

bugfix: inputs/.TNRS/schema.sql: derived columns: use "Accepted_family__@TNRS__@vegpath.org" instead of "*Accepted_name_family" because "*Accepted_name_family" is sometimes missing

14318 07/22/2014 04:12 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added derived column "Accepted_family__@TNRS__@vegpath.org", which is needed because "*Accepted_name_family" isn't always populated