{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 info@dyfedarchaeology.org.uk

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

www.dyfedarchaeology.org.uk


HISTORIC ENVIRONMENT FEATURES

Search criteria:

{HE1intro}

A search of the regional Historic Environment Record (HER) held by the Dyfed Archaeological Trust has identified the following archaeological investigations. These are listed and described below. Each eventis allocated a Primary Record Number (PRN) that should be quoted in any correspondence. If a field contains no information then it is either not known or not applicable for that record.

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_event.prn,

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

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

geo_locations.ngr,

geo_locations.community,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_event.event_type,' ')) SEPARATOR ', '),' ') as t1,

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_woodland
JOIN her_project_link on her_project_link.fileno=her_woodland.fileno
JOIN her_event on her_event.watprn=her_project_link.watprn
JOIN geo_locations on geo_locations.watprn=her_event.watprn

LEFT JOIN her_source2 on her_source2.watprn=her_event.watprn

left join her_source1_link on her_source1_link.watprn=her_event.watprn
left join her_source1 on her_source1.rowid=her_source1_link.source_id
WHERE her_project_link.fileno=[rowid] and isnull(her_core.flag)

group by her_event.prn;
title:[b]PRN[/b]   ,prn,   [b]NAME[/b]   , name ,    [br][b]TYPE[/b]     ,t1,    [br][b]NGR[/b]      , ngr ,     [b]COMMUNITY[/B]     ,community,    [br][br][b]SUMMARY[/b][br],s1 ,   [br][br][b]SOURCES[/B]      ,source2,  [br][b]OTHER SOURCES[/b][br]    ,source1,    }

- HTML file produced {date("d.m.y")} 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).