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

--

--

-- Name: VIEW place_visit; Type: COMMENT; Schema: public; Owner: -

--

--

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

--

--

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

--

CREATE VIEW place_visit AS

 SELECT locationevent.locationevent_id, 

    locationevent.source_id, 

    locationevent.sourceaccessioncode, 

    locationevent.accesslevel, 

    locationevent.place_visit_id, 

    locationevent.parent_id, 

    locationevent.location_id, 

    locationevent.project_id, 

    locationevent.stratum_id, 

    locationevent.authoreventcode, 

    locationevent.previous_id, 

    locationevent.obsstartdate, 

    locationevent.obsenddate, 

    locationevent.dateaccuracy, 

    locationevent.method_id, 

    locationevent.temperature_c, 

    locationevent.precipitation_m, 

    locationevent.autotaxoncover, 

    locationevent.originaldata, 

    locationevent.effortlevel, 

    locationevent.floristicquality, 

    locationevent.bryophytequality, 

    locationevent.lichenquality, 

    locationevent.locationeventnarrative, 

    locationevent.landscapenarrative, 

    locationevent.homogeneity, 

    locationevent.phenologicaspect, 

    locationevent.representativeness, 

    locationevent.standmaturity, 

    locationevent.successionalstatus, 

    locationevent.basalarea, 

    locationevent.hydrologicregime, 

    locationevent.soilmoistureregime, 

    locationevent.soildrainage, 

    locationevent.watersalinity, 

    locationevent.waterdepth_m, 

    locationevent.shoredistance, 

    locationevent.soildepth, 

    locationevent.organicdepth, 

    locationevent.soiltaxon_id, 

    locationevent.soiltaxonsrc, 

    locationevent.percentbedrock, 

    locationevent.percentrockgravel, 

    locationevent.percentwood, 

    locationevent.percentlitter, 

    locationevent.percentbaresoil, 

    locationevent.percentwater, 

    locationevent.percentother, 

    locationevent.nameother, 

    locationevent.treeht, 

    locationevent.shrubht, 

    locationevent.fieldht, 

    locationevent.nonvascularht, 

    locationevent.submergedht, 

    locationevent.treecover, 

    locationevent.shrubcover, 

    locationevent.fieldcover, 

    locationevent.nonvascularcover, 

    locationevent.floatingcover, 

    locationevent.submergedcover, 

    locationevent.dominantstratum, 

    locationevent.growthform1type, 

    locationevent.growthform2type, 

    locationevent.growthform3type, 

    locationevent.growthform1cover, 

    locationevent.growthform2cover, 

    locationevent.growthform3cover, 

    locationevent.totalcover, 

    locationevent.notespublic, 

    locationevent.notesmgt, 

    locationevent.revisions, 

    locationevent.dateentered, 

    locationevent.toptaxon1name, 

    locationevent.toptaxon2name, 

    locationevent.toptaxon3name, 

    locationevent.toptaxon4name, 

    locationevent.toptaxon5name, 

    locationevent.numberoftaxa

   FROM locationevent

  WHERE (locationevent.parent_id IS NULL);

--

-- Name: VIEW place_visit; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON VIEW place_visit IS '

when updating, use * as the column list

';

--

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

--

REVOKE ALL ON TABLE place_visit FROM PUBLIC;

REVOKE ALL ON TABLE place_visit FROM bien;

GRANT ALL ON TABLE place_visit TO bien;

GRANT SELECT ON TABLE place_visit TO bien_read;

--