boring_locations_in_drill_core_libraryField Name | Valid Values | Definition | Definition Source |
---|
OBJECTID | - | | |
SHAPE | - | | |
DhName | - | Drill Hole name, DNR's best interpretation from driller's or other source documents | |
DhAlias | - | List of known drill hole alii, including those reported in MDH forms and written on core boxes | |
DrillDate | - | Date drilling was completed | |
DrillFor | - | Name of company, agency, or entity sponsor of drill hole. Not necessarily same as Driller. | |
TotDep | - | Total depth reached, feet. | |
County | - | County where collar is located | |
Azimuth | - | Azimuth, best available as determined by DNR | |
Dip | - | Dip, best available as determined by DNR | |
X_UTM8315 | - | X coordinate in UTM NAD83 Zone 15 meters, best available as determined by DNR | |
Y_UTM8315 | - | Y coordinate in UTM NAD83 Zone 15 meters, best available as determined by DNR | |
Z_ElevFt | - | Z coordinate in NAVD88 feet, best available as determined by DNR | |
DNRNum | - | DNR inventory number, unique ID per core or sample | |
MDHNum | - | MDH exploratory boring sealing report number, also represents CWI number without leading zeros | |
DrillMthd | enumerated | List of known drill methods used for drill hole | |
| Air | | |
| Auger | | |
| Diamond Core | | |
| Diamond Core, Auger | | |
| Diamond Core, Churn | | |
| Diamond Core, Reverse | | |
| Diamond Core, Rotary | | |
| Diamond Core, Sonic | | |
| Reverse | | |
| Rotary | | |
| Rotary, Auger, Split tube | | |
| Sonic | | |
| Undeterminable | | |
DrlPurpose | enumerated | List of known reasons for drilling. Exploration refers to pre-1980, Exploratory Boring is later and defined by statute. | |
| Engineering | | |
| Exploration | | |
| Exploration, Scientific | | |
| Exploration, Water well | | |
| Exploratory Boring | | |
| Exploratory Boring, Water well | | |
| Monitoring Well | | |
| Scientific | | |
| Scientific, Engineering | | |
| Scientific, Engineering, Monitoring | | |
| Scientific, Environmental | | |
| Scientific, Monitoring | | |
| Undeterminable | | |
Project | - | Name of project or effort associated with drilling | |
CoreLoc | - | Physical location of drill core or samples. May be located in the DNR DCL, held be a sponsor or other agency, unrecovered or destroyed, or unknown | |
GlobalID | - | | |
created_user | - | | |
created_date | - | | |
last_edited_user | - | | |
last_edited_date | - | | |
dcl_lineageField Name | Valid Values | Definition | Definition Source |
---|
OBJECTID | - | | |
DhName | - | Drill Hole name, DNR's best interpretation from driller's or other source documents | |
DNRNum | - | DNR inventory number, unique ID per core or sample | |
MDHNum | - | MDH exploratory boring sealing report number, also represents CWI number without leading zeros | |
DrForAlias | - | Common name of drilling sponsor provided for companies etc. with mergers/name changes/etc. | |
DrillBy | - | Entity including contractors completing physical drilling | |
AltEndDate | - | End date where full date is unknown - month/year only | |
DataPublic | - | Public status of core, yes or no | |
BdrkLitho | - | Bedrock description of ledge; could include rock type or stratigraphic unit | |
DepToBdrk | - | Depth to bedrock as drilled, in units of feet. Angled drill holes will not give a true depth. | |
ScndLitho | - | Additional significant reference horizon (such as PreCambrian, to Giant's Range, to Pokegama Quartzite, etc.) in units of feet. | |
DepToScnd | - | Depth in feet of 2nd litho horizon | |
Locality | - | Focus area within a project, as designated by sponsor | |
Terrane | - | Subprovince or other large geologic terrane feature in which the borehole was drilled. | |
InitMthd | - | Starting hole Drilling Method with bit size if known. | |
InitDia | - | Diameter of hole, or of core if drilled, in millimeters. | |
InitStart | - | Depth at which initial method began (in feet) | |
SecMthd | - | Second drilling method with bit size if known. | |
SecDia | - | Diameter of second boring, or of core if drilled, in millimeters. | |
SecStart | - | Depth at which second method began (in feet) | |
ThrdMthd | - | Third drilling method with bit size if known. | |
ThrdDia | - | Diameter of third boring, or of core if drilled, in millimeters. | |
ThrdStart | - | Depth at which third method began (in feet) | |
CWINum | - | This number uses the MDH number though adds zeros in front of it. Carryover from previous versions. | |
MDHStatus | - | Borehole status, typically Temporarily Sealed, Permanently Sealed, or Active. | |
CWILogs | - | Indicates whether CWI logs exist | |
MDHformDNR | - | Link to original scanned MDH exploratory sealing report sent to DNR. This includes a map where the company has generally sited the location of the drill hole. | |
MDHformWeb | - | Link to MDH online repository of digital exploratory sealing report. This is not the scanned original document. It is based on the original document, inputted by MDH and MGS. | |
CMT_MDH | - | General comment field to insert compiler comments about MDH form for drill hole. | |
GeolLogs | - | Indicates whether Geologic Logs exist on file with DNR | |
GeopLogs | - | Indicates whether Geophysical Logs exist on file with DNR | |
OtherLogs | - | Indicates whether logs of any other type exist on file with DNR | |
DhDocs | - | Link to DNR or online repository of any other documents related to drill hole | |
DhFolder | - | DNR internal folder name containing documents related to drill hole | |
CMT_Hstry | - | Compiler comments related to the history of the drill hole and project | |
CMT_MetaD | - | Compiler comments related to the collection of data to complete this table | |
TgtCmmdty | - | Original commodity target at time of drilling | |
CMT_Loc | - | Compiler comments related to the spatial information about the drill hole | |
XY_Source | - | Source and reason for using these X and Y Coordinates for DNR Library Official values | |
Z_Source | - | Source and reason for using this Z value for DNR Library Official values | |
Township | - | Township location of collar | |
Range | - | Range location of collar | |
Section | - | Section location of collar | |
Forty | - | Forty location of collar | |
GovtLot | - | Government lot # of forty collar location | |
ArchvElev | - | Elevation value from alternative/archival source | |
X_DNRInsp | - | X UTM collar coordinate from DNR first site visit, NAD83 Zone 15 meters | |
Y_DNRInsp | - | Y UTM collar coordinate from DNR first site visit, NAD83 Zone 15 meters | |
Z_DNRInsp | - | Z coordinate in NAVD88 meters. Extracted from statewide LiDAR-based elevation at time of inspection. | |
Azi_DNRIns | - | Azimuth taken during the DNR's inspection. | |
Dip_DNRIns | - | Dip taken during the DNR's inspection. -90 value for vertical. | |
Method_DNR | - | DNR's location method during inspection, typically the GPS model ID. | |
CMT_DNR | - | Comments associated with the DNR inspection | |
X_UTMMDH | - | from MDH exploratory boring sealing report | |
Y_UTMMDH | - | from MDH exploratory boring sealing report | |
X_LonMDH | - | from MDH exploratory boring sealing report | |
Y_LatMDH | - | from MDH exploratory boring sealing report | |
Z_MDH | - | from MDH exploratory boring sealing report, often provided by the borehole sponsor from a 1:24,000 topographic map. | |
Azi_MDH | - | from MDH exploratory boring sealing report | |
Dip_MDH | - | from MDH exploratory boring sealing report | |
CMT_Ref | - | Description of additional "Reference" spatial data source, such as another database, a report, or sponsor/driller provided info | |
Mthd_Ref | - | Instrumentation and/or methods used for Reference source | |
X_Ref | - | Reference source X coordinate | |
Y_Ref | - | Reference source Y coordinate | |
Z_Ref | - | Reference source Z coordinate | |
Azi_Ref | - | Reference source Azi value | |
Dip_Ref | - | Reference source Dip value | |
Proj_Ref | - | Reference source XY coordinate system | |
Datum_Ref | - | Reference source vertical datum | |
Link_Ref | - | Reference source direct link | |
GPSErr_DNR | - | DNR's GPS estimated error with units included (vary with device). | |
created_user | - | | |
created_date | - | | |
last_edited_user | - | | |
last_edited_date | - | | |