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

HISTORIC ENVIRONMENT RECORD INFORMATION

Prepared by {wat_staff}, Heneb The Trust for Welsh Archaeology, Dyfed region

Produced for {name} from the Regional Historic Environment Record:
Heneb, The Trust for Welsh Archaeology, Dyfed region, Corner House, 6 Carmarthen Street, Llandeilo, Carmarthenshire, SA19 6AE
Tel (01558) 823131 , Email her@Heneb.org.uk

Pdf file produced - {date("d.m.y")} - from DA HER, DA enquiry number {rowid}.

Use of this information is subject to the terms and conditions of access to Welsh HER data published on Heneb's website

www.Heneb.org.uk

HISTORIC ENVIRONMENT FEATURES

Search criteria:
{criteria}

A search of the regional Historic Environment Record (HER) held by Dyfed Archaeology has identified the following historic environment features. These are listed and described below. Each feature is allocated a Primary Reference Number (PRN) that should be quoted in any correspondence. Where the identification of a site is not certain then all possible interpretations are given in the type field e.g.'enclosure, henge'. Possible date ranges are also shown in this way in the period field. If a field contains no information then it is either not recorded, not known or not applicable for that site.

Please contact the HER if you have any further questions regarding this information, if you would like any of the sources followed up or if you have information that could improve these records in any way.

Source prefixes:
Ph = Published, historic (pre-1900)
Mh = Unpublished, historic
Pm/Mm = Published/Unpublished modern (post-1899)
Desc Text = Descriptive text.
GP/AP = Ground photograph/Aerial photograph.

All other source types should be self-explanatory; please contact the HER if you require assistance with them.

{subtable:
SELECT her_core.prn,

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


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

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

ngr,

community,

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

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

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.condition,' ')) SEPARATOR ', '),' ') as c1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.evidence,' ')) SEPARATOR ', '),' ') as e1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_status.status,'None recorded '),' ',ifnull(her_status.reference,' '),' ',ifnull(her_status.grade,' ')) SEPARATOR ', '),' ') as status1,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source2.srcetype,' '),' ',ifnull(her_source2.author,' '),' ',ifnull(her_source2.year,' '),' ',ifnull(her_source2.title,' '),' ',ifnull(her_source2.other,' ')) SEPARATOR '[br]' ),' ') as source2,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source1.srcetype,' '),' ',ifnull(her_source1.author,' '),' ',ifnull(her_source1.year,' '),' ',ifnull(her_source1.title,' '),' ',ifnull(her_source1.other,' ')) SEPARATOR '[br]' ),' ') as source1

FROM her_core
JOIN her_enquiry_link_core on her_core.watprn=her_enquiry_link_core.watprn
JOIN geo_locations on geo_locations.watprn=her_core.watprn
JOIN her_core_site_type on her_core_site_type.watprn=her_core.watprn
LEFT JOIN her_condition on her_condition.watprn=her_core.watprn
LEFT JOIN her_status on her_status.watprn=her_core.watprn
left join her_source2 on her_source2.watprn=her_core.watprn
left join her_source1_link on her_source1_link.watprn=her_core.watprn
left join her_source1 on her_source1.rowid=her_source1_link.source_id

WHERE her_enquiry_link_core.fileno=[rowid]

group by her_core.prn
order by cast(her_core.prn as unsigned);
title:[b]PRN[/b] ,prn, [b]NAME[/b] , name , [br][b]TYPE[/b] ,t1, [b]PERIOD[/b] , p1, [br][b]NGR[/b] , ngr , [b]COMMUNITY[/B] ,community, [br][b]CONDITION[/b] ,c1, [b]STATUS[/b] [i],status1,[/i] [b]EVIDENCE[/b] ,e1, [br][br][b]SUMMARY[/b][br],s1 , [br][br][b]DESCRIPTION[/b][br],d1 , [br][br][b]SOURCES[/B] ,source2, [br][b]OTHER SOURCES[/b][br] ,source1, }

Archaeological data, from the Regional Historic Environment Record, supplied by Heneb the Trust for Welsh Archaeology in partnership with Local Authorities, Cadw and the partners of ENDEX DAT, 2011 (and in part Crown, 2011).