-- Name: 2013-7-10.Naia.range_limiting_factors; Type: VIEW; Schema: public; Owner: -

--

--

-- Name: 2013-7-10.Naia.range_limiting_factors; Type: ACL; Schema: public; Owner: -

--

--

-- Name: 2013-7-10.Naia.range_limiting_factors; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "2013-7-10.Naia.range_limiting_factors" AS

    SELECT analytical_stem.taxon_occurrence__pkey AS occurrence_id, analytical_stem."speciesBinomialWithMorphospecies" AS species, analytical_stem."decimalLatitude" AS latitude__deg, analytical_stem."decimalLongitude" AS longitude__deg, analytical_stem."coordinateUncertaintyInMeters" AS coords__uncertainty__m FROM analytical_stem WHERE ((((NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false)) AND COALESCE((analytical_stem.geovalid_bien)::boolean, true)) AND (analytical_stem."decimalLatitude" IS NOT NULL)) AND (analytical_stem."decimalLongitude" IS NOT NULL)) ORDER BY analytical_stem.taxon_occurrence__pkey;

--

-- Name: 2013-7-10.Naia.range_limiting_factors; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "2013-7-10.Naia.range_limiting_factors" FROM PUBLIC;

REVOKE ALL ON TABLE "2013-7-10.Naia.range_limiting_factors" FROM bien;

GRANT ALL ON TABLE "2013-7-10.Naia.range_limiting_factors" TO bien;

GRANT SELECT ON TABLE "2013-7-10.Naia.range_limiting_factors" TO bien_read;

--