heritage_site

201 rows


Description

Heritages sites including their location and a description

Columns

Column Type Size Nulls Auto Default Children Parents Comments
heritage_site_id INT 10 null
construction.heritage_site_id construction_ibfk_1 R
material_use.heritage_site_id material_use_ibfk_1 R

Primary key, autoincrementing ID

heritage_site_name VARCHAR 250 null

Name of the heritage site. Not NULL, unique. If multiple sites exist with the same name, include additional identifying information as appropriate (e.g. town, city, county). Church of Ireland = CoI. Roman catholic = RC.

heritage_site_type_id INT 10 NULL
dic_heritage_site_type.heritage_site_type_id heritage_site_ibfk_2 R

FK. Link to dictionary of site types

is_public TINYINT 3 null

Whether the site is public or not. Used to control appearance on website.

address_locality VARCHAR 500 NULL

Street address if available, general name/locality if street address is not available

town_city VARCHAR 500 NULL

Town/City/Village name

lat_dec DECIMAL 8,6 NULL

Latitude as a decimal type (usually from google maps)

long_dec DECIMAL 9,6 NULL

Longitude as a decimal type (usually from google maps)

datum VARCHAR 250 NULL

Geodetic datum (usually WGS84 from google maps)

uncertainty_m DECIMAL 10,2 NULL

DarwinCore: The horizontal distance in meters from the given decimalLatitude and decimalLongitude that describes the smallest enclosing circle that contains the whole of the location. Leave the value empty if the uncertainty is unknown, cannot be estimated, or is not applicable (because there are no coordinates). Zero is not a valid value for this term. This term corresponds with the geographic radial of the final georeference.

georef_remarks TEXT 65535 NULL

DarwinCore: Notes or comments out of the ordinary about the georeference, explaining assumptions made in addition or opposition to those formalized in the method referred to in georeferenceProtocol. e.g. assumed distance by road (Hwy. 101)

location_remarks TEXT 65535 NULL

DarwinCore: Notes or comments of interest about the location (not the georeference of the location, which go in georeferenceRemarks). e.g. Villa Epecuen was inundated in November 1985 and ceased to be inhabited until 2009

georef_date DATE 10 NULL

Date georeferenced

georef_by VARCHAR 250 NULL

DarwinCore: the individual(s) who last modified the georeference and when that happened. These correspond to the final authority on the georeference in its current state, regardless of who might have worked on previous versions of the georeference.

georef_sources TEXT 65535 NULL

DarwinCore: A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the location, described specifically enough to allow anyone in the future to use the same resources.

georef_protocol_id INT 10 NULL
dic_georef_protocol.georef_protocol_id heritage_site_ibfk_5 R

FK. Link to dic_georef_protocol

osi_six_last TINYINT 3 NULL

Presence or absence on OSI 6-inch historical map, last edition (1910s-1950s)

osi_six_first TINYINT 3 NULL

Presence or absence on OSI 6-inch historical map, first edition (1829-41)

osi_twentyfive TINYINT 3 NULL

Presence or absence on OSI 25-inch historical map (1897-1913)

townland_verbatim VARCHAR 250 NULL

Verbatim townland name. For use especially for areas without formal townland designation (e.g. in Dublin)

townland_id INT 10 NULL
dic_townland.townland_id heritage_site_ibfk_3 R

FK. Link to townlands.ie dictionary

county_id INT 10 NULL
dic_county.county_id heritage_site_ibfk_1 R

FK. Link to dictionary of counties

country_code CHAR 3 'IE'

Country code, ISO standard. Default: IE

heritage_site_desc TEXT 65535 NULL

Details of the heritage site, which will appear on the website. HTML tags are included for formatting.

harbison_id VARCHAR 100 NULL

Identifier from Harbison, P. (1970). Guide to the National Monuments in the Republic of Ireland. 1st Ed. Gill and Macmillan, M.H. Gill & Co. U. C.

nat_mon_id INT 10 NULL

National Monument Number. Description from National Monuments Service: When a monument is taken into State ownership or guardianship its details are added to a National Monuments Register. In the earlier years, when a number of monuments were taken in State care at the same time, they were all given the same register number e.g. the monuments on the Dingle peninsula are all registered under number 221. Similarly, groups of monument such as the passage tombs at Lough Crew will have the same registration number. The register is not entirely up-to-date with the result that some of the more recent acquisitions have yet to be assigned numbers."

opw_monuments_ID INT 10 NULL

ID from spreadsheet from OPW of monuments in state care.

rmp_id VARCHAR 250 NULL

Description from National Monuments Service: Each monument is entered in the Record of Monuments and Places (RMP) as established under Section 12 of the National Monuments (Amendment) Act 1994. A unique identifying number is assigned to each monument and place in the record. The RMP number provides the link to the records of the Archaeological Survey of Ireland (ASI) which contains further information on the monument in question.

dia_id MEDIUMINT 7 NULL

ID from the Dictionary of Irish Architects.

niah_reg_no INT 10 NULL

Registration number from the National Inventory of Architectural Heritage (NIAH)

gsi_code VARCHAR 100 NULL

GSI Heritage Code

is_in_irelithos TINYINT 3 NULL

Whether or not the site was in the Irelithos database

is_opw_site TINYINT 3 NULL

Whether or not the heritage site is run by the Office of Public Works (OPW)

opw_url VARCHAR 3000 NULL

Url for the Office of Public Works website (OPW)

century_id INT 10 NULL
dic_century.century_id heritage_site_ibfk_4 R

FK. Link to dictionary of centuries

entered_by VARCHAR 250 NULL

Person who originally entered the record

entered_date DATETIME 19 current_timestamp()

Date of original entry

modified_by VARCHAR 250 NULL

Person who made the latest modification

modified_date DATETIME 19 NULL

Date of latest modification - auto updates on modification

irish_grid_easting INT 10 NULL

Irish grid easting

irish_grid_northing INT 10 NULL

Irish grid northing

itm_easting INT 10 NULL

ITM easting

itm_northing INT 10 NULL

ITM northing

site_visit TINYINT 3 NULL

Whether or not the site was visited in person

site_visit_by VARCHAR 500 NULL

Who visited the site

site_visit_date DATE 10 NULL

Date of the last site visit

site_visit_notes TEXT 65535 NULL

Notes about the visit

notes TEXT 65535 NULL

General additional notes, not for public website

geom POINT 0 NULL

Point data type generated from decimal lat and long

heritage_site_tag VARCHAR 255 NULL

Autogenerated unique tag for heritage sites, used to link heritage sites to references in Zotero and images in the WP image library. Created by taking the heritage site name and removing all special characters/punctuation, replacing spaces and slashes with underscores.

Indexes

Constraint Name Type Sort Column(s)
heritage_site_s_pk Primary key Asc heritage_site_id
century_id Performance Asc century_id
county_id Performance Asc county_id
georef_protocol_id Performance Asc georef_protocol_id
heritage_site_name Performance Asc heritage_site_name
heritage_site_type_id Performance Asc heritage_site_type_id
PRIMARY Must be unique Asc heritage_site_id
townland_id Performance Asc townland_id

Relationships