-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -

--

--

-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -

--

--

-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2014-3-11.Jeff_Ott.climatic_range_determinants" AS

 SELECT analytical_stem.datasource, 

    analytical_stem."decimalLatitude", 

    analytical_stem."decimalLongitude", 

    analytical_stem."higherPlantGroup_bien" AS "higherPlantGroup", 

    analytical_stem.scrubbed_family AS family, 

    analytical_stem.scrubbed_genus AS genus, 

    analytical_stem.scrubbed_species_binomial AS "speciesBinomial", 

    analytical_stem.scrubbed_taxon_name_with_author AS "scientificName"

   FROM analytical_stem

  WHERE (((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_taxon_name_with_author IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL));

--

-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" FROM PUBLIC;

REVOKE ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" FROM bien;

GRANT ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" TO bien;

GRANT SELECT ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" TO bien_read;

--

-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2014-3-11.Jeff_Ott.climatic_range_determinants" AS

 SELECT analytical_stem.datasource, 

    analytical_stem."decimalLatitude", 

    analytical_stem."decimalLongitude", 

    analytical_stem."higherPlantGroup_bien" AS "higherPlantGroup", 

    analytical_stem.scrubbed_family AS family, 

    analytical_stem.scrubbed_genus AS genus, 

    analytical_stem.scrubbed_species_binomial AS "speciesBinomial", 

    analytical_stem.scrubbed_taxon_name_with_author AS "scientificName"

   FROM analytical_stem

  WHERE (((((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND COALESCE((analytical_stem."isNewWorld_bien")::boolean, false)) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND (analytical_stem.scrubbed_taxon_name_with_author IS NOT NULL)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL));

--

-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" FROM PUBLIC;

REVOKE ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" FROM bien;

GRANT ALL ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" TO bien;

GRANT SELECT ON TABLE "2014-3-11.Jeff_Ott.climatic_range_determinants" TO bien_read;

--