SELECT count(*) AS count

WHERE source_id =

;

SELECT 'projects' AS ___;

SELECT projectname

FROM project

WHERE source_id =

ORDER BY projectname

;

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

SELECT projectname, count(*) AS locations_count

FROM project

JOIN locationevent USING (project_id)

WHERE project.source_id =

GROUP BY projectname

;

SELECT '# top-level locations' AS ___;

SELECT count(DISTINCT location_id) AS count

FROM location

WHERE source_id =

AND parent_id IS NULL -- no subplots

;

SELECT '# top-level location events' AS ___;

SELECT count(*) AS count

WHERE source_id =

AND parent_id IS NULL -- no subplots

;

SELECT '# locations' AS ___;

WHERE source_id =

;

WHERE source_id =

;

SELECT '1st methods' AS ___;

    projectname

    , method.name AS method

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.source_id =

ORDER BY projectname, method

LIMIT 10;

SELECT '1st observation measures' AS ___;

SELECT DISTINCT

    projectname

    , method.observationmeasure AS observationmeasure

FROM project

JOIN locationevent USING (project_id)

JOIN method USING (method_id)

WHERE project.source_id =

ORDER BY projectname, observationmeasure

LIMIT 10;