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

GWYNEDD ARCHAEOLOGICAL TRUST

HISTORIC ENVIRONMENT RECORD

ENQUIRY REPORT - CORE RECORDS

Enquiry reference number: {enq_no}

Prepared by: {wat_staff}, Gwynedd Archaeological Trust

Produced for: {name}, {organisation}

The following information has been provided under the terms and conditions of access as detailed on the GAT HER Enquiry and Conditions of Access form and/or the GAT HER data licence agreement produced for this enquiry.

Copyright is reserved on all data supplied by the GAT HER. All output resulting from the use of the data must acknowledge the source as follows: Derived from information held by the GAT HER Copyright.

If you wish to use information derived from material held by the GAT HER for publication in printed or multimedia form, or to compile resources for commercial use (with the exception of grey literature reports), prior permission must be obtained in writing.

Search Criteria:

{criteria}

{subtable:
SELECT her_core.prn,
ifnull(her_core.name,' ') as name,

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

ifnull(her_core.desc_1,' ') as d1,
ifnull(geo_locations.community,'-')community,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_site_type.period,''),', ',ifnull(her_core_site_type.type,''),', Sitetype ranking: ',ifnull(her_core_site_type.rank,'-')) SEPARATOR '[br] '),'') as t1,
ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_condition.evidence,' ')) SEPARATOR '[Br]'),'') as evidence,

ifnull(GROUP_CONCAT(DISTINCT concat('CONDITION: ',ifnull(her_condition.condition,'None Recorded'),' CONDITION RATING: ',ifnull(her_condition.rating,'None Recorded'),' DESCRIPTION: ',ifnull(her_condition.condesc,'None Recorded'),' RELATED EVENT PRN: ',ifnull(her_condition.eventprn,' '),' YEAR: ',ifnull(her_condition.year,' ')) SEPARATOR '[Br]'),'') as c1,

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(geo_locations.ngr,'None Recorded')) SEPARATOR ', '),'') as ngr,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_source2.author,' '),' ',ifnull(her_source2.organisation,' '),' ',ifnull(her_source2.year,' '),' ',ifnull(her_source2.artcl_titl,' '),', ',ifnull(her_source2.title,' '),', ',ifnull(her_source2.other,' '),' ',ifnull(her_source2.gw_bibref,' ')) SEPARATOR '[br]' ),'') as bib2,

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

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_core_event_link.ewatprn,' '),' ',ifnull(her_event.name,' '),' ',ifnull(her_event.eyear,' ')) SEPARATOR '[br]' ),'') as event,

ifnull(GROUP_CONCAT(DISTINCT concat(' FIND: ',ifnull(her_artefact.quantity,'None recorded'),' ',ifnull(her_artefact.fmaterial,' '),' ',ifnull(her_artefact.ftype,' '),' COLLECTION: ' ,ifnull(her_artefact.flocation,'None recorded'),' DESCRIPTION: ' ,ifnull(her_artefact.fnotes,'None recorded'),' PAS REF: ' ,ifnull(her_artefact.pasref,' '),' URL: ',ifnull(her_artefact.pasurl,'')) SEPARATOR '[br]''[br]' ),' ') as artefact,

ifnull(GROUP_CONCAT(DISTINCT ifnull(geo_locations.url,'') SEPARATOR ', '),', ') as url,

ifnull(GROUP_CONCAT(DISTINCT concat(ifnull(her_c14.date_by,'None recorded'),' ',ifnull(her_c14.labnumber,' '),' MATERIAL: ',ifnull(her_c14.material,' '),' DATE: ',ifnull(her_c14.date,' '),' ',ifnull(her_c14.devqual,' '),' ',ifnull(her_c14.deviation,' '),' ',ifnull(her_c14.datequal,' '),' COMMENT: ',ifnull(her_c14.comment,' '),' EVENT PRN: ',ifnull(her_c14.eventprn,'')) SEPARATOR '[br]' ),' ') as radio

FROM her_core

JOIN her_enquiry_link_core on her_core.watprn=her_enquiry_link_core.watprn
LEFT JOIN geo_locations on geo_locations.watprn=her_core.watprn
LEFT 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  and her_status.status_typ not like "area"

LEFT JOIN her_core_event_link on her_core_event_link.watprn=her_core.watprn

LEFT JOIN her_artefact_link on her_artefact_link.watprn=her_core.watprn
LEFT JOIN her_artefact on her_artefact.rowid=her_artefact_link.artefact_id

LEFT JOIN her_event ON her_core_event_link.ewatprn = her_event.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

LEFT JOIN her_c14 on her_c14.watprn=her_core.watprn

WHERE her_enquiry_link_core.fileno=[rowid]

group by her_core.prn;

title:[b][i]PRN[/i][/b] , prn,[br][b][i]NAME[/i][/b] , name,[br][b][i]NGR[/i][/b] , ngr,[br][b][i]COMMUNITY[/i][/b]  , community,[br][b][i]PERIOD AND TYPE[/i][/b] , t1,[br],[br][b][i]SUMMARY[/i][/b] , s1,[br][br],[b][i]DESCRIPTION[/i][/b] , d1,[br][br],[b][i]EVIDENCE[/i][/b] , evidence,[br][br],[b][i]CONDITION INFORMATION[/i][/b][br],c1,[br][br],[b][i]STATUS[/i][/b] , status1,[br],[br],[b][i]RADIOCARBON DATES[/i][/b],[br],radio,[br][br],[b][i]ASSOCIATED EVENTS[/i][/b],[br],event,[br][br],[b][i]ASSOCIATED ARTEFACTS[/i][/b][br],artefact,[br][br],[b][i]SOURCES[/i][/b][br],bib,[br],[br],bib2,[br] [br],[b][i]ARCHWILIO URL[/i][/b][br], url, [br] ,  } 

Key to Abbreviations and Terms

GAT: Gwynedd Archaeological Trust; HER: Historic Environment Record; PRN: Primary Reference Number, each site and event is given a unique PRN; NAME: The common name given to the site; NGR: Ordnance Survey National Grid Reference; COMMUNITY: The community council in which the site is located; PERIOD: The period to which the site belongs; TYPE: Describes the site type e.g. CASTLE; SITE TYPE RANKING: Indicates the preferred site type interpretation, Rank 1 being the highest; SUMMARY: A short, unreferenced site summary written by HER staff; DESCRIPTION: Detailed site notes compiled from various sources; EVIDENCE: The physical remains of a site, or the means by which a site has been identified; CONDITION INFORMATION: The condition of the site at the time of assessment; STATUS: The legal status of the site, e.g. Scheduled Ancient Monument; RADIOCARBON DATES: Lists any radiocarbon dating associated with the site; ASSOCIATED EVENTS: The details of archaeological investigations relating to the site, e.g. EXCAVATION; ASSOCIATED ARTEFACTS: Describes any finds associated with the site; SOURCES: The bibliographic references relating to the site

Printed {date("m.d.y (H:m)")} - HTML file produced from GAT HER, GAT file number {rowid}. 
Gwynedd Archaeological Trust, Craig Beuno, Garth Road, Bangor LL57 2RT. 
tel (01248) 352535, fax (01248) 370925, email her@heneb.co.uk, website www.heneb.co.uk
Archaeological data from the Gwynedd Historic Environment Record, supplied by Gwynedd Archaeological Trust in partnership with Local Authorities, Cadw and partners of HEDS, GAT, 2021.