{sql:select * from her_project
 WHERE her_project.rowid = @File number@}

Historic Environment Feature (HEF) Monitoring Report

UiD:

This report has been produced by Gwynedd Archaeological Trust to inform the monitoring of the identified Historic Environment Feature.

{subtable:
SELECT her_core.prn,

ifnull(her_core.name,' ') as n1,

ngr,

ifnull(her_core.desc_1,' ') as s1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_management_record.manspec,' ')) SEPARATOR ', '),' ') as m1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_site_type.period,' ')) SEPARATOR ', '),' ') as p1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_site_type.type,' ')) SEPARATOR ', '),' ') as t1

FROM her_core
JOIN her_project_link on her_core.watprn=her_project_link.watprn
LEFT JOIN her_core_site_type on her_core_site_type.watprn=her_core.watprn

LEFT JOIN geo_locations on geo_locations.watprn=her_core.watprn

LEFT JOIN her_management_record on her_management_record.watprn=her_core.watprn

WHERE her_project_link.fileno=[rowid]

group by her_core.prn;
title:[b]PRN[/b] , prn , [b]Name[/b] , n1 , [br][b]Period[/b] , p1 , [b]Site Type[/b] , t1 , [br][b]NGR[/b] , ngr , [br][br][b]Site Description[/b][br] , s1 , [br][br][b]Management Issues[/b][br] , m1 , }

(Site descriptions extracted from the Historic Environment Record; bracketed numbers refer to bibliographic references. For further details please see www.archwilio.co.uk/ and www.coflein.gov.uk/)

{date("d.m.y")} - HTML file produced for Glastir management report, GAT file number {rowid}. 
Gwynedd Archaeological Trust, Craig Beuno, Ffordd Garth, Bangor LL57 2RT. 
tel (01248) 352535, fax (01248) 370925, email gat@heneb.co.uk, website www.heneb.co.uk
 

Archaeological data, from the Regional Sites and Monuments Record, supplied by Gwynedd Archaeological Trust in partnership with Local Authorities, Cadw and the partners of ENDEX GAT, 2013 (and in part Crown, 2013).