| Required Groups
|Groups shall include PROJ, LOCA or HOLE, ABBR, TYPE, UNIT
| Required BGS Groups
|Groups may include GEOL - required for BGS submission
| Spatial Referencing
|Spatial referencing system defined in LOCA_GREF, LOCA_LREF or LOCA_LLZ. Example: LOCA_GREF:OSGB, LOCA_LREF:London Grid 1, LOCA_LLZ:WGS84
| Easting/Northing present.
|LOCA_NATE and LOCA_NATN are populated. Zeros or null do not pass
| Easting/Northing values fall within reasonable range
|LOCA_NATE values inside 100,000 to 800,000 range. LOCA_NATN values inside 100,000 to 1,400,000 range
| Drill Depth (HDPH) present
|HDPH_TOP does not contain null values. HDPH_BASE does not contain zero or null values.
| Drill depths (HDPH) have corresponding records in GEOL table
|Checking HDPH LOCA_IDs are in GEOL group AND GEOL LOCA_IDs are in HDPH group
| Locations are onshore Great Britain or Northern Ireland
|Note: If using Irish grid and GREF not entered, tool cannot currently differentiate from EPSG:27700 (OSGB)
| Any duplication between NATE/NATN, LOCX/LOCY and LON/LAT
|Duplication presumes error in these columns which should be checked
| LOCA_ID references are valid
|Checks all groups which have LOCA_ID are populated with a valid record present in the LOCA Group.
| SAMP_ID or LOCA_ID, SAMP_TOP, SAMP_TYPE, SAMP_REF references are valid
|LOCA_ID, SAMP_TOP, SAMP_TYPE, SAMP_REF are all populated, not null, and unique in combination within SAMP group AND all LOCA_ID values are present in the LOCA group. Also all groups that reference the SAMP group as a parent, use either the SAMP_ID field or the combination of LOCA_ID, SAMP_TOP, SAMP_TYPE, SAMP_REF and that the parent exists in the SAMP group.