-- Name: analytical_stem_CVS; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW "analytical_stem_CVS" AS

 SELECT analytical_stem.datasource,

    analytical_stem.country,

    analytical_stem.state_province,

    analytical_stem.county,

    analytical_stem.locality,

    analytical_stem.latitude,

    analytical_stem.longitude,

    analytical_stem.coord_uncertainty_m,

    analytical_stem.georef_sources,

    analytical_stem.georef_protocol,

    analytical_stem.is_geovalid,

    analytical_stem.is_new_world,

    analytical_stem.project_id,

    analytical_stem.project_contributors,

    analytical_stem.location_id,

    analytical_stem.plot_name,

    analytical_stem.subplot,

    analytical_stem.is_location_cultivated,

    analytical_stem.locationevent_id,

    analytical_stem.event_date,

    analytical_stem.elevation_m,

    analytical_stem.slope_aspect_deg,

    analytical_stem.slope_gradient_deg,

    analytical_stem.plot_area_ha,

    analytical_stem.sampling_protocol,

    analytical_stem.temperature_c,

    analytical_stem.precip_mm,

    analytical_stem.stratum_name,

    analytical_stem.community_concept_name,

    analytical_stem.observation_contributors,

    analytical_stem.custodial_institution_codes,

    analytical_stem.collection_code,

    analytical_stem.catalog_number,

    analytical_stem.occurrence_id,

    analytical_stem.recorded_by,

    analytical_stem.record_number,

    analytical_stem.date_collected,

    analytical_stem.verbatim_family,

    analytical_stem.verbatim_scientific_name,

    analytical_stem.identified_by,

    analytical_stem.date_identified,

    analytical_stem.identification_remarks,

    analytical_stem.family_matched,

    analytical_stem.name_matched,

    analytical_stem.name_matched_author,

    analytical_stem.higher_plant_group,

    analytical_stem.taxonomic_status,

    analytical_stem.scrubbed_family,

    analytical_stem.scrubbed_genus,

    analytical_stem.scrubbed_specific_epithet,

    analytical_stem.scrubbed_species_binomial,

    analytical_stem.scrubbed_taxon_name_no_author,

    analytical_stem.scrubbed_author,

    analytical_stem.scrubbed_taxon_name_with_author,

    analytical_stem.scrubbed_species_binomial_with_morphospecies,

    analytical_stem.growth_form,

    analytical_stem.reproductive_condition,

    analytical_stem.is_cultivated,

    analytical_stem.is_cultivated_basis,

    analytical_stem.occurrence_remarks,

    analytical_stem.cover_percent,

    analytical_stem.taxon_observation_id,

    analytical_stem.taxon_name_usage_concept_author_code,

    analytical_stem.aggregate_organism_observation_id,

    analytical_stem.individual_organism_observation_id,

    analytical_stem.individual_id,

    analytical_stem.individual_count,

    analytical_stem.plantobservation_id,

    analytical_stem.taxonobservation_id

   FROM analytical_stem

  WHERE (analytical_stem.datasource = 'CVS'::text);

--

-- Name: analytical_stem_CVS; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE "analytical_stem_CVS" FROM PUBLIC;

REVOKE ALL ON TABLE "analytical_stem_CVS" FROM bien;

GRANT ALL ON TABLE "analytical_stem_CVS" TO bien;

GRANT SELECT ON TABLE "analytical_stem_CVS" TO bien_read;

--