boring_locations_in_drill_core_library| Field 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_lineage| Field 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 | - | | |