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

HISTORIC ENVIRONMENT RECORD INFORMATION

Prepared by {wat_staff}, 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:

{criteria}

A search of the regional Historic Environment Record (HER) held by the Dyfed Archaeological Trust has identified the following investigative events that have been undertaken in the study area. These are listed and described below. Each event is allocated a Primary Record Number (PRN) that should be quoted in any correspondence. Cross references refer either to site or event PRNs.  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_event.prn,
ifnull(her_event.name,' ') as name,

her_event.eyear,
her_event.event_type,
ifnull(her_event.eventbyo,'-') as evo,
ifnull(her_event.eventbyp,'-') as evp,
ifnull(her_event.summary,'-') as s1,
ifnull(her_event.desc_1,'-') as d1,
ifnull(her_event.comments,'None') as com1,
geo_locations.ngr,
ifnull(geo_locations.community,'-')community,

ifnull(GROUP_CONCAT(DISTINCT concat('TYPE: ',ifnull(her_artefact.ftype,'None recorded'),' MATERIAL: ',ifnull(her_artefact.fmaterial,'-'),' PERIOD: ',ifnull(her_artefact.period1,'-'),' DESCRIPTION: ',ifnull(her_artefact.fnotes,'-')) SEPARATOR '[br]'),' ') as art,
 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_xrefs.xref,'-')) SEPARATOR ', '),', ') as xref,
 ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_event_link.watprn,'')) SEPARATOR ', '),' ') as core,

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

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

FROM her_event
JOIN her_enquiry_link_event on her_event.watprn=her_enquiry_link_event.watprn
LEFT JOIN geo_locations on geo_locations.watprn=her_event.watprn
LEFT JOIN her_core_event_link on her_core_event_link.ewatprn=her_event.watprn
LEFT JOIN her_xrefs on her_xrefs.watprn=her_event.watprn
LEFT JOIN her_artefact on her_artefact.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_enquiry_link_event.fileno=[rowid]

group by her_event.prn;
title:[b]PRN[/b] , [i],prn,[/i] , [b]NAME[/b] , [i],name,[/i] ,  [b]NGR[/b] , [i],ngr,[/i] , [b]COMMUNITY[/b] , [i],community,[/i],[br],[b]TYPE[/b] , [i],event_type,[/i], [b]YEAR[/b] , [i],eyear,[/i] ,[b]ORGANISATION[/b] , [i],evo,[/i] ,[b]PERSON[/b] , [i],evp,[/i] ,[br],[b]SUMMARY[/b] ,[i],s1,[/i][br][br],[b]DESCRIPTION[/b] ,[i],d1,[/i][br][br],[b]COMMENTS[/b] ,[i],com1,[/i][br],[b]ARTEFACTS[/b][br],[i],art,[/i][br][br],[b]CROSS REFERENCES[/b], [i],xref,[/i], [i],core,[/i][br][br], [b]SOURCES[/b][br],[i],bib,[/i] [br] ,[i],source2,[/i] }

AM - {date("m.d.y (H:m)")} - HTML file produced from DAT HER, DAT file number {rowid}.
 
Archaeological data, from the Regional Historic Environment Record, supplied by The Dyfed Archaeological Trust in partnership with Local Authorities, Cadw and the partners of ENDEX DAT, 2010.