Project

General

Profile

« Previous | Next » 

Revision 13913

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added collection_type (using source__observation_type())

View differences:

trunk/schemas/public_.sql
6123 6123 
    analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS "decimalLatitude",
6124 6124 
    analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS "decimalLongitude",
6125 6125 
    analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" AS "dateCollected",
6126 
    source__observation_type(analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS collection_type,
6126 6127 
    COALESCE(analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org", analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS orig_datasource,
6127 6128 
    analytical_stem.scrubbed_family AS accepted_family,
6128 6129 
    analytical_stem.scrubbed_genus AS accepted_genus,
trunk/schemas/vegbien.sql
6123 6123 
    analytical_stem."decimalLatitude__@DwC__@vegpath.org" AS "decimalLatitude",
6124 6124 
    analytical_stem."decimalLongitude__@DwC__@vegpath.org" AS "decimalLongitude",
6125 6125 
    analytical_stem."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" AS "dateCollected",
6126 
    source__observation_type(analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS collection_type,
6126 6127 
    COALESCE(analytical_stem."[custodial_]institutionCode[s]__@DwC__@vegpath.org", analytical_stem."datasource__@Brad__.identifier_examples@vegpath.org") AS orig_datasource,
6127 6128 
    analytical_stem.scrubbed_family AS accepted_family,
6128 6129 
    analytical_stem.scrubbed_genus AS accepted_genus,

Also available in: Unified diff