Project

General

Profile

Actions

Task #908

open

generate the source-general derived columns directly on the denormalized staging table

Added by Aaron Marcuse-Kubitza over 10 years ago. Updated over 7 years ago.

Status:
New
Priority:
Normal
Start date:
04/29/2014
Due date:
% Done:

0%

Estimated time:
Activity type:

Description

  1. geoscrubbing
    1. re-code geoscrub_input_view to use denormalized full_occurrence view
  2. TNRS
    1. add the TNRS input name directly to the staging tables
      • requires writing a SQL expression (rather than XPaths) to produce it from the component columns (ranks, author, etc.) that it's formed from
    2. re-code tnrs_input_name to use denormalized full_occurrence view
Actions

Also available in: Atom PDF