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

Historic Environment Feature

Management Report:

NAME AND SITE TYPE (if only one PRN in the HEF)

Customer Reference Number:

 UID:

This management plan has been produced by Dyfed Archaeological Trust Heritage Management 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.summary,' ') as s1,

ifnull(her_management_record.manspec,' ') 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, DAT file number {rowid}. 
Dyfed Archaeological Trust, Heritage Management, The Shire Hall, 8 Carmarthen Street, Llandeilo, Carmarthenshire SA19 6AF. 
tel (01558) 823131 , fax (01558) 823133, email info@dyfedarchaeology.org.uk , website www.dyfedarchaeology.org.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 The Dyfed Archaeological Trust in partnership with Local Authorities, Cadw and the partners of ENDEX DAT, 2011 (and in part Crown, 2011).