SELECT count(*) AS count

WHERE reference_id =

;

SELECT 'projects' AS ___;

SELECT projectname AS project

WHERE reference_id =

ORDER BY project

SELECT E'each project\'s # locations' AS ___;

FROM project

JOIN locationevent USING (project_id)

WHERE project.reference_id =

GROUP BY project

SELECT '# locations' AS ___;

SELECT count(DISTINCT location_id) AS count

FROM location

WHERE reference_id =

AND parent_id IS NULL -- no subplots

;

SELECT '# location events' AS ___;

SELECT count(*) AS count

WHERE reference_id =

AND parent_id IS NULL -- no subplots

;

    , method.name AS method

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.reference_id =

ORDER BY project, method

SELECT '1st observation measures' AS ___;

SELECT DISTINCT

    , method.observationmeasure AS observationmeasure

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.reference_id =

ORDER BY project, observationmeasure

LIMIT 10;