CREATE VIEW _plots_05_list_of_plot_codes_by_project AS

 SELECT p.project_name, 

   FROM (projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)));

CREATE VIEW _plots_06_list_of_plots_with_stem_measurements AS

 SELECT DISTINCT p.project_name, 

   FROM (((projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))

   JOIN "plotObservations" po ON ((pm."PlotID" = po."PlotID")))

CREATE VIEW _plots_07_list_of_plots_with_counts_of_individuals_per_species AS

 SELECT DISTINCT p.project_name, 

   FROM ((projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))

   JOIN "plotObservations" po ON (((pm."PlotID" = po."PlotID") AND (po."NoInd" > 1))))

CREATE VIEW _plots_08_list_of_plots_which_use_percent_cover AS

 SELECT DISTINCT p.project_name, 

   FROM ((projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))

   JOIN "plotObservations" po ON (((pm."PlotID" = po."PlotID") AND (po.cover_percent IS NOT NULL))))

CREATE VIEW _plots_09_list_of_plots_which_use_line_intercept AS

 SELECT DISTINCT p.project_name, 

   FROM ((projects p

   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))

   JOIN "plotObservations" po ON (((pm."PlotID" = po."PlotID") AND (po.intercept_cm IS NOT NULL))))