Summary and Statistics for DMP

[p-a-s-c-a-l]

Query the CKAN Database and extract some summary and overview tables from inclusion in the DMP deliverable document. See also clarity-h2020/docker-pgadmin#3

[p-a-s-c-a-l]

Find datasets without assignment to one of the 4 groups:

SELECT "Dataset Name", Organisation[1] FROM 
  (SELECT package.title as "Dataset Name", array_agg(g.title) as Organisation FROM package 
     JOIN MEMBER m ON m.table_id = package.id AND m.state = 'active'
     LEFT JOIN "group" as g ON g.id = m.group_id AND g.state = 'active'  
        --and g.is_organization = true
     GROUP BY package.title HAVING COUNT(g.id) = 1) as foo

Dataset Name	organisation
Spanish Transport Network layers	DC4 - Spain
SWICCA (temperature, precipitation, hydrological variables)	DC2 - Sweden
Urban land-use and physiography over Stockholm	DC2 - Sweden
Urban SIS (meteorological, air-quality and hydrological variables)	DC2 - Sweden
Local datasets for Sweden	DC2 - Sweden
Open Swedish data	DC2 - Sweden
Heat scenarios over Stockholm	DC2 - Sweden

[p-a-s-c-a-l]

Dataset Name	organisation
"Outdoor Heat wave local effect map (baseline)"	"DC1 - Italy"
"DC3 -Trees in Linz (2015)"	"CLARITY"
"Water"	"Open Data produced by CLARITY"
"Administrative Boundaries"	"DC3 - Austria"
"DC3 Linz Buildings (2018)"	"DC3 - Austria"
"Adaptation scenarios on city level"	"DC3 - Austria"
"Baseline - Altstadt"	"DC3 - Austria"
"Heat scenarios over Stockholm"	"DC2 - Sweden"
"Ice days (ID)"	"CLARITY"

[p-a-s-c-a-l]

See clarity-h2020/docker-pgadmin#3 (comment)

[p-a-s-c-a-l]

Check Integrity for #32 and clarity-h2020/data-management-plan#1