{sql:select * from her_woodland
 JOIN her_project on her_project.rowid=her_woodland.fileno
 WHERE her_project.rowid = @File Number@
}




HISTORIC ENVIRONMENT RECORD INFORMATION

Prepared by {cpofficer} , Dyfed Archaeological Trust

Produced for {name} from the regional Historic Environment Record:
Dyfed Archaeological Trust, The Shire Hall, 8 Carmarthen Street, Llandeilo, Carmarthenshire, SA19 6AF
Tel (01558) 823131 , Fax (01558) 823133 Email dyfedarchaeology.org.uk, website www.dyfedarchaeology.org.uk

This information is produced subject to the terms and conditions of access to Welsh HER data published on
DAT's website - www.dyfedarchaeology.org.uk



HISTORIC ENVIRONMENT FEATURES

A search of the regional Historic Environment Record (HER) held by the Dyfed Archaeological Trust has identified the following historic environment features. These are listed and described below. Each feature is allocated a Primary Record Number (PRN) that should be quoted in any correspondence.

{subtable:
SELECT her_core.prn,

her_core.name,

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

ngr,

community,

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

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

ifnull(manspec,' ') as ms,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_status.status,' '),'   ',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,' ')) SEPARATOR '/   '),' ') as source2

FROM her_woodland
JOIN her_project_link on her_project_link.fileno=her_woodland.fileno
JOIN her_core on her_core.watprn=her_project_link.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_management_record on her_management_record.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
WHERE her_project_link.fileno=[rowid] and isnull(her_core.flag) and
(her_woodland.fileno=her_management_record.fileno or isnull(her_management_record.fileno))

group by her_core.prn;
title: [b]PRN[/b]    , prn ,     [b]NAME[/b]    , name ,     [b]TYPE[/b]    ,t1 ,  [br][b]PERIOD[/b]    , p1 ,     [b]NGR[/b]    , ngr ,     [b]COMMUNITY[/B]    ,community,    [b]STATUS[/b]    [i],status1,[/i]   [br][b]SUMMARY[/b][br]    ,s1 ,[br][br][b]SOURCES[/B]    ,source2,    [b][i] , ms ,[/i][/b] }


- HTML file produced {date("d.m.y (H:m)")} , DAT file number {fileno}.


Archaeological data, from the Historic Environment Record, supplied by The Dyfed Archaeological Trust in partnership with Local Authorities, Cadw and the partners of ENDEX © DAT, 2009 (and in part © Crown, 2009).