Project

General

Profile

# Date Author Comment
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

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)

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.

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.

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)

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

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

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()

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

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

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

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

14311 07/22/2014 03:20 AM Aaron Marcuse-Kubitza

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

14304 07/22/2014 01:48 AM Aaron Marcuse-Kubitza

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

14303 07/22/2014 01:37 AM Aaron Marcuse-Kubitza

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

14294 07/21/2014 11:59 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem: synced to analytical_stem_view

14281 07/21/2014 05:13 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns scrubbed_*

14279 07/21/2014 04:34 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: put matched-taxon derived columns before accepted-taxon derived columns

14278 07/21/2014 04:25 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[matched_]species[_binomial]~(Accepted_)__@TNRS__@vegpath.org"

14277 07/21/2014 04:08 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _matched_has_accepted: renamed to matched_has_accepted because the leading _ did not create vertical alignment anyway, due to different quoting syntaxes

14269 07/21/2014 09:02 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column _matched_has_accepted

14267 07/21/2014 08:44 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"

14266 07/21/2014 08:29 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org"

14265 07/21/2014 08:26 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "__accepted_infraspecific_{rank,epithet}"

14264 07/21/2014 08:19 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column __accepted_infraspecific_label

14257 07/21/2014 06:54 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[accepted_]genus__@DwC__@vegpath.org", "[accepted_]specificEpithet__@DwC__@vegpath.org"

14254 07/21/2014 06:26 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: ran derived_cols_update()

14125 07/18/2014 11:40 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: cluster the table so the rows are always exported in the same order, even when an UPDATE statement is used to run triggers

14122 07/18/2014 03:18 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added _accepted{genus,specific_epithet} derived column, using the steps at wiki.vegpath.org/Postgres_queries#maintaining-derived-column-formulas-across-column-renames

14111 07/17/2014 04:13 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: added back * prefixes on TNRS-namespace column names

14098 07/16/2014 07:55 PM Aaron Marcuse-Kubitza

schemas/public_.sql: removed no longer used threatened_taxonlabel. use iucn_red_list instead.

14097 07/16/2014 07:39 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: analytical_stem_view: don't use threatened_taxonlabel, which was never populated correctly. instead, this can eventually be rewritten to use new iucn_red_list.

14084 07/16/2014 12:53 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added iucn_red_list_view_modify() and use it in iucn_red_list_view's "after updating this" instructions

13930 07/09/2014 06:22 AM Aaron Marcuse-Kubitza

schemas/public_.sql: iucn_red_list_view: documented how to regenerate iucn_red_list from this

13928 07/08/2014 03:23 PM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: fixed slowdown in materializing the view, which was caused by source__observation_type(), by replacing this with a LEFT JOIN as was done for is_threatened_iucn

13926 07/07/2014 07:26 AM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: is_threatened_iucn: generate this much faster by doing a LEFT JOIN, which can reuse the same in-memory hash index for every row

13925 07/07/2014 07:04 AM Aaron Marcuse-Kubitza

bugfix: schemas/public_.sql: wrapper functions can't use util-schema types because these will cause the wrapper function to be cascadingly dropped when the util schema is reinstalled

13920 07/07/2014 06:37 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added in_iucn_red_list()

13919 07/07/2014 06:36 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added iucn_red_list, materialized from iucn_red_list_view

13917 07/07/2014 06:17 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added iucn_red_list

13915 07/07/2014 06:02 AM Aaron Marcuse-Kubitza

schemas/public_.sql: iucn_red_list: renamed to iucn_red_list_view since this will be materialized

13914 07/07/2014 06:01 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added iucn_red_list

13912 07/07/2014 05:36 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added source__observation_type()

13910 07/07/2014 04:50 AM Aaron Marcuse-Kubitza

schemas/public_.sql: added subspecies() wrapper

13907 07/07/2014 03:55 AM Aaron Marcuse-Kubitza

schemas/util.sql: added south_america(), in_south_america()

13904 07/07/2014 03:30 AM Aaron Marcuse-Kubitza

schemas/util.sql: lat_long_in_new_world(): renamed to just in_new_world() because the lat/long is implied by the param type

13903 07/07/2014 03:08 AM Aaron Marcuse-Kubitza

schemas/util.sql: lat_long_in_new_world(): take a geocoord param instead of separate lat/long params

13879 07/03/2014 12:34 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: taxon_match__valid_match: replaced with taxon_best_match__valid_match, which also applies taxon_best_match's filters, since taxon_match is now accessed through taxon_best_match

13878 07/03/2014 12:17 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: MatchedTaxon: use taxon_best_match instead of taxon_match because this should provide only one match per taxon

13875 06/26/2014 06:30 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added taxon_best_match view

13874 06/26/2014 06:12 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added taxon_match__one_selected_match unique index

13869 06/26/2014 04:57 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: renamed related items to start with taxon_match__*

13868 06/26/2014 04:33 AM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: renamed related items to start with taxon_match__*

13866 06/26/2014 04:11 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: insert names via taxon_match_input auto-updatable view instead of directly into taxon_match, to allow the taxon_match columns to be renamed while still supporting inserts using the TNRS column names

13861 06/26/2014 02:14 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs_match: renamed to taxon_match to use the normalized VegCore name for this, and to avoid repeating the schema name

13850 06/25/2014 03:33 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: tnrs: renamed to tnrs_match to distinguish it from other TNRS-related tables

13845 06/25/2014 10:36 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: *_modify(): merged these into the "to modify" instructions in the corresponding views, because there is no need to create a separate *_modify() function for every view now that their definitions are all the same

13843 06/25/2014 05:15 AM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view and related views: updated COMMENTs from data dictionary spreadsheet, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#copy-data-dictionary-definitions-to-database

13842 06/25/2014 04:11 AM Aaron Marcuse-Kubitza

schemas/public_.sql: ran analytical_stem_view_modify(), which transfers the column COMMENTs from analytical_stem_view to analytical_stem

13836 06/24/2014 05:01 PM Aaron Marcuse-Kubitza

fix: schemas/public_.sql: analytical_stem_view derived and related views: applied data dictionary renamings, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#apply-data-dictionary-renamings-to-database but with the current columns of analytical_stem as the left-hand column

13834 06/24/2014 04:34 PM Aaron Marcuse-Kubitza

schemas/public_.sql: analytical_stem_view: applied data dictionary renamings, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#apply-data-dictionary-renamings-to-database

13832 06/20/2014 08:01 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added 2014-6-4.Iara_Lacher.reserve_prioritization

13818 06/18/2014 08:52 PM Aaron Marcuse-Kubitza

schemas/public_.sql: added lat_long_in_new_world() wrapper around util.lat_long_in_new_world()

13734 06/12/2014 03:53 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: added 2014-6-12.Jeff_Ott.climatic_range_determinants (wiki.vegpath.org/Data_requests)