Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| material_source_id | INT | 10 | √ | null |
|
|
PK autoincrement id |
||||||||||
| parent_material_source_id | INT | 10 | √ | NULL |
|
|
Parent id - references material_id |
||||||||||
| material_source_name | VARCHAR | 100 | null |
|
|
Name of the quarry or brickfield |
|||||||||||
| is_public | TINYINT | 3 | null |
|
|
Whether the material source is public or not (will appear on website) |
|||||||||||
| material_source_type_id | INT | 10 | √ | NULL |
|
|
FK references dic_material_source_type - the type of site (quarry/brickfield) |
||||||||||
| start_date | VARCHAR | 250 | √ | NULL |
|
|
Date the site opened |
||||||||||
| end_date | VARCHAR | 250 | √ | NULL |
|
|
Date the site was closed |
||||||||||
| start_date_artificial | DATE | 10 | √ | NULL |
|
|
Start date to be used for sorting - over precise date. When only a year is known, January 1st is used. |
||||||||||
| end_date_artificial | DATE | 10 | √ | NULL |
|
|
End date to be used for sorting - over-precise date. When only a year is known, December 31st is used. |
||||||||||
| status_id | INT | 10 | √ | NULL |
|
|
FK references dic_status - whether the site is active, inactive or closed |
||||||||||
| material_source_desc | TEXT | 65535 | √ | NULL |
|
|
Description - version published on the website. |
||||||||||
| address_locality | VARCHAR | 500 | √ | NULL |
|
|
Street address if available, general name/locality if street address is not available e.g. 2km S of Athlone |
||||||||||
| town_city | VARCHAR | 500 | √ | NULL |
|
|
Town/City/Village name |
||||||||||
| townland_id | INT | 10 | √ | NULL |
|
|
FK Links to dictionary from townlands.ie |
||||||||||
| townland_verbatim | VARCHAR | 250 | √ | NULL |
|
|
Verbatim townland - may include parishes etc where townland is not available |
||||||||||
| county_id | INT | 10 | √ | NULL |
|
|
FK references dic_county |
||||||||||
| country_code | CHAR | 3 | √ | 'IE' |
|
|
Country code - default is IE |
||||||||||
| itm_easting | DECIMAL | 10,3 | √ | NULL |
|
|
Irish ITM easting |
||||||||||
| itm_northing | DECIMAL | 10,3 | √ | NULL |
|
|
Irish 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 |
||||||||||
| irish_grid_easting | INT | 10 | √ | NULL |
|
|
Irish grid easting |
||||||||||
| irish_grid_northing | INT | 10 | √ | NULL |
|
|
Irish grid northing |
||||||||||
| lat_dec | DECIMAL | 8,6 | √ | NULL |
|
|
Decimal latitude |
||||||||||
| long_dec | DECIMAL | 9,6 | √ | NULL |
|
|
Decimal longitude |
||||||||||
| datum | VARCHAR | 250 | √ | NULL |
|
|
Datum for decimal lat-long eg. WGS84 |
||||||||||
| 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_sources | TEXT | 65535 | √ | NULL |
|
|
|||||||||||
| 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_date | DATE | 10 | √ | NULL |
|
|
Date georeferenced |
||||||||||
| georef_protocol_id | INT | 10 | √ | NULL |
|
|
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) |
||||||||||
| material_type_id | INT | 10 | √ | NULL |
|
|
FK. Link to dic_material_type. Primary material type for this source. |
||||||||||
| notes | TEXT | 65535 | √ | NULL |
|
|
Additional notes - these will not be published on the website |
||||||||||
| nsd_url | VARCHAR | 3000 | √ | NULL |
|
|
Link to the URL of the Northern Ireland Natural Stone Database |
||||||||||
| active_quarry_id | INT | 10 | √ | NULL |
|
|
GSI active quarry and pit ID. |
||||||||||
| county_geo_code | VARCHAR | 250 | √ | NULL |
|
|
GSI county geological site code |
||||||||||
| unaudited_heritage_site_name | VARCHAR | 250 | √ | NULL |
|
|
The name if an unaudited GSI Heritage Site |
||||||||||
| gsi_quarry_no | VARCHAR | 100 | √ | NULL |
|
|
GSI Quarry No |
||||||||||
| gsi_minloc | VARCHAR | 100 | √ | NULL |
|
|
GSI Min Loc identifier |
||||||||||
| proposed_gsi_heritage | TINYINT | 3 | null |
|
|
Whether or not the site should be proposed to the GSI for audit as a Geological Heritage Site |
|||||||||||
| is_in_irelithos | TINYINT | 3 | √ | NULL |
|
|
Whether or not the site is in the Irelithos database |
||||||||||
| entered_by | VARCHAR | 250 | √ | NULL |
|
|
Person who entered the initial record |
||||||||||
| entered_date | DATETIME | 19 | √ | current_timestamp() |
|
|
Date of original entry. Autogenerated with current timestamp |
||||||||||
| modified_by | VARCHAR | 250 | √ | NULL |
|
|
Person who made the latest modification |
||||||||||
| modified_date | DATETIME | 19 | √ | NULL |
|
|
Date of latest modification. Autogenerated current timestamp on update |
||||||||||
| geom | POINT | 0 | √ | NULL |
|
|
Stored computed column. Creates geom point from lat_dec and long_dec |
||||||||||
| material_source_tag | VARCHAR | 255 | √ | NULL |
|
|
Autopopulated. Tag used for references and images. Created from material source name, punctuation and special characters removed and spaces and slashes replaced by underscores |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| material_source_s_pk | Primary key | Asc | material_source_id |
| county_id | Performance | Asc | county_id |
| georef_protocol_id | Performance | Asc | georef_protocol_id |
| material_source_name | Performance | Asc | material_source_name |
| material_source_type_id | Performance | Asc | material_source_type_id |
| material_type_id | Performance | Asc | material_type_id |
| parent_material_source_id | Performance | Asc | parent_material_source_id |
| PRIMARY | Must be unique | Asc | material_source_id |
| status_id | Performance | Asc | status_id |
| townland_id | Performance | Asc | townland_id |
Relationships
Close relationships within degrees of separation
