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

Historic Environment Feature

Management Report:

REPORT NAME

Customer Reference Number:

 UID:

This management plan has been produced by Gwynedd Archaeological Trust to inform the positive management of the identified Priority Historic Environment Feature. The identified management outcome will meet the objective for the Historic Environment Feature Targeted Layer as part of the Glastir Land Management Scheme.

{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 Management

Desired Management Outcome

Management Actions

Management Opportunities

Location Map

Map of Historic Ennvironment Feature Highlighting any Management Issues

Photographs

{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 

Maps based upon Ordnance Survey material with the permission of Ordnance Survey on behalf of the Controller of Her Majesty's Stationery Office Crown copyright. Unauthorised reproduction infringes Crown copyright and may lead to prosecution or civil proceedings. Welsh Assembly Government 100017916. {date("m.d.y")}

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).