-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2014-6-4.Iara_Lacher.reserve_prioritization" AS

 SELECT analytical_stem.country,

    analytical_stem."decimalLatitude",

    analytical_stem."decimalLongitude",

    analytical_stem."dateCollected",

    COALESCE(analytical_stem."specimenHolderInstitutions", analytical_stem.datasource) AS orig_datasource,

    analytical_stem.scrubbed_family AS accepted_family,

    analytical_stem.scrubbed_genus AS accepted_genus,

    analytical_stem.scrubbed_species_binomial AS accepted_species_binomial,

    analytical_stem.scrubbed_taxon_name_with_author AS accepted_taxon_name_with_author,

    analytical_stem."growthForm" AS lifeform

   FROM analytical_stem

  WHERE ((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem.taxonomic_status = 'accepted'::text), false));

--

-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM PUBLIC;

REVOKE ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" FROM bien;

GRANT ALL ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien;

GRANT SELECT ON TABLE "2014-6-4.Iara_Lacher.reserve_prioritization" TO bien_read;

--