MNDNR Tier One Metadata Record

Stockpile database - Stkpile.mdb

Field	Description
Main ID Information
Title	Mesabi Range Stockpile Inventory Database
Filename	stkpile.mdb
Abstract	The data contained in this database is for two study areas only. This database was created using a structured data modeling methodology, beginning with a Business Object Model. That was then converted into a Conceptual/Logical Data Model, which in turn was used to develop the Physical Data Model. Diagrams of the models can be found in the appendices section of the project report. Relationships between the tables may be viewed in Access 97 using the 'relationships' button or using the menu choice: tools, relationships. The resulting components of the database are listed below. TABLES The core of the database consists of 34 related tables and three domain tables for lookup values. Field Observation of Stockpile Stockpile Material Type Geoglot and Stockpile Info Stockpile Mine of Origin Information Source Stockpile Photo Location Legal Description Test Name and Sample Number Legal Entity Test Results-Abrasion Mined/Piled Stockpile Material Test Results-Chem Assays Natural Ore Mine Test Results-Clay Lumps Observation Test Results-Fine Agg Photo Test Results-FlatElong Property Ownership Test Results-LtWt Particles Sample Test Results-SGA-Coarse Sample Composition Test Results-SGA-Fine Stockpile Test Results-Sieve Stockpile Legal Description Test Results-Soundness Stockpile Material Info Source Test Type Stockpile Material Property Ownership Test Type Determination Stockpile Material Sample Acquisition X, Y Coordinates ColorLookup ExposureLookup Means of Ownership There are seven summary tables used for import into ArcView for mapping purposes. Mapping ownership Minerals Mapping points-Observation Mapping ownership PLS/Stockpile pieces Mapping points-Photo Mapping ownership Surface Mapping points-Sample Mapping ownership whole stockpiles There are two miscellaneous reference tables. Calumet Stockpiles Virginia Stockpiles FORMS There are five forms that can be used to browse the data, though the forms were originally designed for data entry. Note: Some of the fields on the forms contain numeric codes instead of words. Use the drop down arrow on the right side of the field to look up what the code means. For example, see the 'Material Type' field on the 'Browse Stockpile Composition' form. Browse Company Contact Info -View contact person's name and phone number for company, county, etc. when available Browse Sample Results -View all test results by sample number Browse Stockpile Composition -View information about stockpile material by Stockpile ID number (as referenced on plates III and IV) and stockpile name Browse Stockpile Ownership* -View ownership information for each piece of stockpile as divided up by Public Land Survey forty acre parcels or government lots. Browse Surface/Mineral Ownership* -View ownership information by forty, government lot or metes and bounds description * The forms showing ownership, particularly stockpile ownership, can be quite confusing. If there are specific questions about what the information means, please get in touch with a contact person. QUERIES AND REPORTS There are 12 queries and four reports in the database that serve as examples of commonly requested information that were created during the project. The queries should be especially helpful for those who would like a "road map" of how the relationships work between some of the tables. Queries: Reports: Check mineral own dataentry Check Stockpile Ownership dataentry Check Ownership dataentry CheckOwnership Check Stockpile Ownership dataentry Sieve/Gradations Results Check surface own dataentry Test Results-Chem Assays Example-get mineral ownership Example-get surface ownership Example-Single Samples and Test Name Example-Single Samples by Material Type Example-'State' owned stockpiles Example-Stockpile info (complex) Example-Stockpile with Material type The database was designed to mirror the real-world, complex relationships that exist in the world of stockpiles. Who owns it, what is there, where is it-these are all questions that have answers in the data and in the related ArcView shapefiles.
Place Keywords	Stockpile, Mesabi Iron Range, Virginia, Calumet, Minnesota
Theme Keywords	Stockpile Inventory, Surface Ownership, Mineral Ownership, Iron Content, Aggregate, Stockpile Composition, Stockpile Ownership
Time Period of Content	July 1, 1999 thru June 30, 2001
Parent Theme	none
Spatial Extent of the Data	Part of St. Louis County, in the area around the town of Virginia and part of Itasca county, in the area around the town of Calumet.
Contact Person	Jill Bornes for data structure questions. (Vicki Hubred for questions related to ownership or Heather Anderson for questions related to geology)
Contact Person Organization/Division	Minnesota Department of Natural Resources, Division of Lands and Minerals
Contact Person Position	Information Technology Specialist
Contact Address	500 Lafayette Road, Box 45
Contact City	St. Paul, MN
Contact Zip Code	55155-4045
Contact Voice Phone	651-296-4807 (same for all three contacts)
Contact Fax Phone	651-296-5939
Additional ID Information
Originator	Minnesota Department of Natural Resources, Division of Lands and Minerals
Purpose	This database was created as part of a Legislative Commission on Minnesota Resources (LCMR) project titled: Mesabi Iron Range Water and Mineral Resources Planning. This LCMR project initiates the effort to provide the people of the Range with technical data that will assist them in planning and developing this landscape. This portion of the project focuses on Stockpile Ownership, Composition, and Use. The project's purpose is to collect data on stockpile ownership and material composition within two study areas. The data may be used to determine the suitability of stockpile materials for future uses. The large volume of stockpiled material on the Mesabi Iron Range has great potential for re-use. Certain materials have the potential to be used as aggregate, while some materials have the potential to be mined for iron units with the development of new processing techniques. Helping to sustain the mining industry and local communities by utilizing stockpiles requires the development of information on stockpile ownership and composition. This is a first attempt to join and reconcile the complexity of ownership data on mining properties with data defining and categorizing stockpile material types. Because each data set has distinct geographic boundaries, the difficulty in combining them is compounded. Disparate data sets needed to be gathered, organized, linked, and then stored. To accomplish these tasks the project was broken down into five parts: •Ownership Research •Stockpile Inventory •Database Design •Stockpile Access •Potential Material Use Ownership involved title research to determine the mineral, surface, and stockpile ownership. The stockpile inventory was based upon pre-existing information gathered from various mining companies and field work. For the purposes of this project, a "stockpile" is defined as any earthen material piled during the process of mining. This includes tailing basins, overburden piles, and rock dumps. If the material had another intended use, such as material used for a dike, overpass, or road base, that material is not considered to be a stockpile for purposes of this project. The various aspects of ownership research and the stockpile inventory were organized and linked in a database designed in Microsoft Access 97. To further facilitate the use of stockpiled material, accessibility was examined by mapping vegetation and mining roads. The potential use of stockpiles was summarized by past leasing experience and through sampling analysis of different types of stockpiled material.
Progress	Complete
Currentness Reference	The LCMR project ran from July 1, 1999, through June 30, 2001. Most of the research/data gathering/testing was conducted from June 2000 through May 2001.
Maintenance Frequency	None planned
Access Constraints	N/A
Use Constraints	N/A
Associated Data Sets	ArcView shapefiles: Cstyarea, Vstyarea, Cstkpile, Vstkpile, Obsvsite, Photosit, and Sampsite
Data Quality
Attribute Accuracy	Integrity constraints are placed on most relationships in the database
Logical Consistency	Fully normalized model, denormalized to facilitate application development
Lineage	Raw data was collected and entered into the database. There are two exceptions to this statement. One, the public land survey data used in the creation of two tables 'Legal Description' and 'Stockpile Legal Description' is held by the Minnesota Department of Natural Resources, from the GIS Core Library in St. Paul. Two, the stockpile outlines were, in part, taken from a Mesabi Range Mining features coverage (still in progress at the Minnesota Department of Natural Resources, Division of Lands and Minerals, Hibbing).
Spatial Reference
Horizontal Coordinate Scheme	UTM
Ellipsoid	GRS80
Horizontal Datum	NAD83
Horizontal Units	meters
Altitude Datum	N/A
UTM Zone Number	15
Data Organization
Native Dataset Environment	Microsoft Access 97
Transfer Size	1.91 mb
Entities -- Attributes
Entity-Attribute Overview
Entity-Attribute Detailed Citation	Tables listed in alphabetical order below

Table Name	Field Name	Key	Definition	Valid Values	Description
Field Observation of Stockpile					This table ties an observation comment to a particular stockpile and an x, y coordinate.
	ObsID	primary key	number (long), 4	7, 8, 9, 10, ...97	Unique identification number associated with every observation.
	ObsFeat		text, 15		The type of feature that is being observed.
				"geologic"	Observation about the geology (i.e., a stockpile, the grain size, a concentration of boulders).
				"physical"	Observation about the physical geography. Mostly things made by humans (i.e., roads, abandoned railroad tracks, bridges).
				"other"	Other features that are not geology or physical (i.e., vegetation).
	ExpsrTyp		text, 30		Further defines the type of exposures. This is the same list of values in the 'ExposureLookup' table.
				"surface"	Any exposure along the surface of a stockpile.
				"cut exposure"	Exposures that are the result of a stockpile being "cut" into by a bulldozer or backhoe.
				"dig"	Exposures from digging into a stockpile.
				"road cut"	Exposures along sides of roads.
				"anthill"	Exposure of stockpile material by observing ant hills.
				"road"	Exposure along a road or noting that a road exists at a location.
	ObservTx		text, 200		Observation comments
	ObsWypt	foreign key (links to 'Observation')	number (long), 4	1, 15, 16, 20, ...195	The GPS waypoint number associated with a geographic location.
	StudyArea	foreign key (links to 'Observation')	text, 10	"Calumet" or "Virginia"	Project study area where observation was made.
	StkplID	foreign key (links to 'Mined/Piled Stockpile Material')	number (long), 4		Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	XYIDNm	foreign key (links to 'X, Y Coordinates')	number (long), 4	10, 11, 13, ...308	Unique identification number for each x, y coordinate.
Geoglot and Stockpile Info					Reference/summary table used to enable data entry for stockpile ownership. Contains list of all stockpiles on a given forty acre parcel or government lot.
	Stkp_Uniq	foreign key (links to "StkplID" in 'Mined/Piled Stockpile Material' table)	number (long), 4	113, 114, 302, 305, ...	Unique identification number for each stockpile. (Used interchangeably with "StkplID")
	StkName		text, 50	"1009", "Cretaceous Ore Dump No. 2", "Columbia Fine Tailings", ...	Local name for stockpile. Usually named by mining company/builder of stockpile. (See 'Stockpile' table)
	MatTyp		text, 35	"Glacial Overburden", "Taconite Rock (boulders)", ...	Stockpile material type as defined for this project. (See 'Stockpile Material Type' table for definitions)
	STKPLSID	primary key	number (double), 8		Unique identification number for each piece of stockpile per forty acre parcel or government lot. (E.g. For the part of stockpile 353(stkp_uniq) in the SWNW of section 15, stkplsid = 7132. For one part stockpile 347 (stkp_uniq) in the SWNW of section 15, stkplsid = 7126 and the other part of stockpile 347 in the SWNW of section 15, stkplsid = 7123.)
	GEOGLOT		number (double), 8		A 14-digit composite identifier that uniquely defines a portion of land to the government lot level. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, GLOT from 'Legal Description' table)
	Entered		yes/no		Indicator that ownership information was entered for this stockpile piece into 'Stockpile Material Property Ownership' table.
Information Source					Table contains information sources used in the course of the project.
	InfoSrcID	primary key	number (long), 4	1-9	Unique identification number for the nine different information sources.
	InfoSrc		text, 30		Information sources used to make determinations about stockpile characteristics or material type.
				"Field Check"	In the field observations.
				"1997 color infrared air photo"	1997 and 1995 color infrared air photos, 1:15,840 scale. The following photos were used in Virginia: 1997 SLS-18-9, SLS-19-9 SLS-18-10, SLS-19-10 SLS-18-11, SLS-19-11 The following air photos were used in Calumet: 1995 ITA-34-45, ITA-34-46, ITA-34-47, ITA-35-48, ITA-35-49, ITA-35-50, ITA-35-51, ITA-36-45, ITA-36-46, ITA-36-47, ITA-36-48, ITA-37-47, and ITA-37-48.
				"1961 black & white air photo"	1961 black and white aerial photography. This set was acquired only for the Virginia study area, 1:15,840 scale. CIR-34A-1, CIR-34A-2, CIR-34A-3, CIR-34A-4, CIR-34A-5, CIR-11A-152, CIR-11A-153, CIR-11A-154, and CIR-11A-155,
				"USX Plates"	These plates were used in both study areas. They were produced by the United States Steel Corporation and published in 1967. The plates gave some indication about the material type of stockpiles and the name of some stockpiles. Plates 5, 6, 24 and 25 were used.
				"GNIOP Plates"	These plates were used for both study areas. They were produced by Great Northern Iron Ore Properties in 1955 and 1959. The plates give some indication about stockpile material type and stockpile names.
				"company"	Information gathered directly from mining companies and/or stockpile owners.
				"MN-DNR records"	All information about state owned stockpiles, from the Minnesota Department of Natural Resources, Division of Lands and Minerals.
				"1947 black & white air photo"	1947 black and white aerial photography. This set was acquired only for the Virginia study area, 1:15,840 scale. 8-53, 8-54, 8-55,7-137, 7-138, and 7-139.
				"1966 black & white air photo"	1966 black and white aerial photography. This set was only acquired for the Calumet study area, 1:15,840 scale. ITA-5-53-94, ITA-5-53-95, ITA-5-53-96, ITA-5-53-97, ITA-5-36-41, ITA-5-36-42, ITA-5-36-43, ITA-5-36-44, ITA-5-36-45, ITA-4-37-139 ITA-4-37-140, ITA-4-37-141, ITA-4-37-142, and ITA-4-37-143.
Legal Description					Public land survey legal description for lands in the study areas. Used to describe surface and mineral ownership parcels.
	LDID	primary key	number (long), 4		Unique identification number for each forty acre parcel or government lot.
	COUN		number (double), 8		Two digit County Code
				31	Itasca
				69	St. Louis
	TOWN		number (double), 8	56 and 58	Three digit township number, townships extend east to west.
	RDIR		number (double), 8		Range direction, ranges extend north to south.
				0	West
	RANG		number (double), 8	23, 24, 17	Two digit range number
	SECT		number (double), 8	3, 4, 5, 7, 8, 9, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29	PLS section number
	FORT		number (double), 8		A combination of a code for the quarter section and a code for the quarter of the quarter section. The FORT_DESC field contains the corresponding text for the numeric values in the FORT field, as seen in the description column below.
				0	Meandered water body (used in combination with GLOT = 99 to identify meandered water bodies)
				11	NENE
				12	NWNE
				13	SWNE
				14	SENE
				21	NENW
				22	NWNW
				23	SWNW
				24	SENW
				31	NESW
				32	NWSW
				33	SWSW
				34	SESW
				41	NESE
				42	NWSE
				43	SWSE
				44	SESE
	GLOT		number (double), 8		Two-digit government lot ID, if applicable (unique only within a section)
				0-7	Government lot number
				99	Meandered water body (used in combination with FORT = 0 to identify meandered water bodies)
	PARC		number (double), 8	0-3	Entry number, if quarter-quarter section has more than one entry (used when the parcel's ownership is divided by partial description/metes and bounds)
	METEBNDS		text, 250		Partial description for a portion of the quarter-quarter section.
	FORT_DESC		text, 40	See above, under FORT description	This field contains the corresponding text for the numeric values in the FORT field. This IS NOT necessarily the legal description for the parcel, especially in the case of government lots, where the FORT and FORT_DESC are for locational reference only. See the 'Description' column of the FORT field.
	GEOPARC		number (double), 8		A 16-digit composite identifier uniquely identifying each ownership parcel. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, GLOT, PARC, given in this order.)
	GEOGLOT		number (double), 8		A 14-digit composite identifier that uniquely defines a portion of land to the government lot level. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, GLOT, given in this order.)
	GEOFORT		number (double), 8		A 12-digit composite identifier that uniquely defines a portion of land to the forty acre level (1/4-1/4 section). (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, given in this order.)
	GEOSECT		number (double), 8		A 10-digit composite identifier that uniquely defines a portion of land to the section level. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, given in this order.)
	GEORANG		number (double), 8		An eight-digit composite identifier that uniquely defines a portion of land to the township-range. (Consists of fields: COUN, TOWN, RDIR, RANG, given in this order.)
	RightofWay		text, 1	null or "y"	"y" indicates the parcel is a right-of-way
Legal Entity					List of owners and contact information
	LEID	primary key	number (long), 4	1 - 32	Unique identification number for each owner.
	LEName		text, 50	Some names need further explanation (not a complete list)	Name of owner.
				"Private"	One individual owner
				"Many private"	More than one individual owner
				"State-DNR"	State ownership, Department of Natural Resources administration
				"State-PCA"	State ownership, Pollution Control Agency administration
				"GNIOP"	Great Northern Iron Ore Properties
				"USX"	USX Corporation (formerly U.S. Steel Corporation)
				"Undetermined"	Parcel was not researched; or if mineral interest, nonregistered severed minerals when the State means of ownership is noted.
	rank		number (long), 4	1-32	Number used for data entry purposes, to move most common owners to top of a drop down list.
	ConFName		text, 15		First name of contact person
	ConLName		text, 20		Last name of contact person
	ConPhoneNm		text, 12		10-digit phone number of contact person
Mined/Piled Stockpile Material					Stockpile composition information. Table is not complete because a lot of information was unavailable.
	StkColorDS		text, 30	"red", "buff", "brown", and "red-brown"	Color of material observed only in glacial overburden stockpiles. This is the same list of values in the 'ColorLookup' table.
	StkComTx		text, 200		Various comments and observations made about an individual stockpile.
	MinGrnMod		text, 1		Modifiers used to approximate the minimum grain size (rock particle) observed within a stockpile
				"<"	Less than
				">"	Greater than
				"~"	Approximately
	MinGrnNm		number (double), 8	Ex: 1, 2, 3, 4, ...	Number used to quantify the diameter of the minimum grain size (rock particle) observed within a stockpile.
	MinGrnUt		text, 10		Unit of measurement used to describe the minimum grain size of a stockpile.
				"mm"	Millimeters
				"inches"	Inches
				"feet"	Feet
				"mesh"	Mesh is the size of a sieve's openings. This unit was used to quantify very small rock particles.
	MaxGrnMod		text, 1		Modifiers used to approximate the maximum grain size (rock particle) observed within a stockpile
				"<"	Less than
				">"	Greater than
				"~"	Approximately
	MaxGrnNm		number (double), 8	Ex: 1, 2, 3, 4, ...	Number used to quantify the diameter of the maximum grain size (rock particle) observed within a stockpile.
	MaxGrnUt		text, 10		Unit of measurement used to describe the maximum grain size of a stockpile.
				"mm"	Millimeters
				"inches"	Inches
				"feet"	Feet
				"mesh"	Mesh is the size of a sieve's openings. This unit was used to quantify very small rock particles
	AvgGrnMod		text, 1		Modifiers used to approximate the estimated average grain size (rock particle) observed within a stockpile
				"<"	Less than
				">"	Greater than
				"~"	Approximately
	AvgGrnNm		number (double), 8	Ex: 1, 2, 3, 4, ...	Number used to quantify the diameter of the average grain size (rock particle) observed within a stockpile.
	AvgGrnUt		text, 10		Unit of measurement used to describe the average grain size of a stockpile.
				"mm"	Millimeters
				"inches"	Inches
				"feet"	Feet
				"mesh"	Mesh is the size of a sieve's openings. This unit was used to quantify very small rock particles
	StkSortIn		text, 15	"poor", "moderately-poor", "moderate", "moderately-well", and "well"	Describes the degree of sorting of sediment grains. If a stockpile contains all the same sized sediment it is described as being well sorted. If a stockpile contains both large and small grains sizes, it is described as being poorly sorted.
	StkVolNm		number (long), 4	23450	Volume of a stockpile, this information was gathered through stockpile owners and/or mining companies.
	StkVolUt		text, 50	"tons" or "loose cubic yards"	Describes the unit of measurement for volume.
	StkEVolNm		number (long), 4	50000	Estimated volume of a stockpile calculated using Surfer® and the Mesabi Range Elevation dataset.
	StkEVolUt		text, 50	"tons" or "loose cubic yards"	Describes the unit of measurement for estimated volume of a stockpile.
	StkFePct		number (double), 8	42	Percentage of iron in a stockpile. All percentages are based on records kept by stockpile owners and/or mining companies.
	StkMagFePct		number (double), 8	42	Percentage of magnetic iron in a stockpile. All percentages are based on records kept by stockpile owners and/or mining companies.
	StkSilPct		number (double), 8	42	Percentage of silica in a stockpile. All percentages are based on records kept by stockpile owners and/or mining companies.
	StkAlPct		number (double), 8	42	Percentage of aluminum in a stockpile. All percentages are based on records kept by stockpile owners and/or mining companies.
	StkGravPct		number (double), 8		A gross estimation of the percent of gravel that may be present in a stockpile. All estimations are based on field observations.
	StkSandPct		number (double), 8		A gross estimation of the percent of sand that may be present in a stockpile. All estimations are based on field observations.
	AggPotIn		text, 50	"High", "Moderate", "Limited"	The overall rating a stockpile has for aggregate potential. This rating does not exclude any material from being used.
	StkplID	primary key	number (long), 4	113, 114, 302, 305, ...	Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	MatTypID	foreign key (links to 'Stockpile Material Type')	number (long), 4	1-11	Unique identification number for each stockpile material type. (See 'Stockpile Material Type' table for definitions)
Natural Ore Mine					Table contains a list of all potential natural ore mine/property names that were the original setting for stockpiled materials in the two study areas. Determinations are based on records kept by stockpile owners and/or mining companies.
	MineID	primary key	number (long), 4	1 - 62	Unique identification number for each mine/property name.
	MineName		text, 50	Ex. "Draper", "Walker-Hill #6", ...	Mine/property names data maintained by DNR Lands and Minerals divsion, published in the 2000 Skillings Minnesota Mining Directory.
Observation					Table refers to locations where observations were made. Observations are usually, but not always, tied to a particular stockpile.
	ObsWypt	primary key (composite)	number (long), 4	1, 15, 16, 20, ...195	The GPS waypoint number associated with a geographic location. Provides link to actual coordinate in the 'X, Y Coordinate' table.
	StudyArea	primary key (composite)	text, 10	"Calumet" or "Virginia"	Project study area where observation was made.
	FeatType		text, 16	"Photo", "Observation" or "Sample"	Type of feature related to a waypoint. Sometimes a photo and observation or photo and sample share the same waypoint number.
Photo					Table refers to locations where photos were taken. Photos are usually, but not always, tied to a particular stockpile.
	PhotoNm	primary key	number (long), 4	Ex: 19, 20, 21, ...347	Unique identifier that corresponds to photographs taken of the stockpiles. These photographs (in .jpg format) are included as part of the data from this project.
	FeatType		text, 16	"Photo", "Observation" or "Sample"	Type of feature related to a waypoint. Sometimes a photo and observation or photo and sample share the same waypoint number.
	PhotoWypt		number (long), 4	1, 15, 16, 20, ...195	The GPS waypoint number associated with a geographic location. Provides link to actual coordinate in the 'X, Y Coordinate' table.
	StudyArea		text, 10	"Calumet" or "Virginia"	Project study area where photo was taken.
Property Ownership					Surface and Mineral Ownership information, including: interest fractions, acres, link to owner name and link to legal description.
	PropOwnID	primary key	number (long), 4		Unique identification number for each property ownership record.
	PropType		text, 20	"surface" or "mineral"	Ownership record is for one of two property types.
	IntNumer		number (long), 4	Ex. 1, 8, 46, ...	Numerator of the undivided, fractional interest owned by the particular owner.
	IntDenom		number (long), 4	Ex. 1, 2, 108, ...	Denominator of the undivided, fractional interest owned by the particular owner.
	AcresNm		number (double), 8	40, ...	Number of acres each owner owns.
	StMeanOwn		text, 50		If the State is the owner, the way in which ownership was acquired by the state is noted. This is the same list of values as in the 'Means of Ownership' lookup table.
				"Trust Fund"	State granted ownership by the U.S. government
				"Acquired"	State acquired the property by purchase or gift
				"Exchange"	State acquired private land in exchange for State land
				"Reversionary Deed"	State has ownership of the property only until a specified date or event occurs. Upon this date or event, the property goes back to the owner who deeded the property to the State.
				"Tax Forfeit"	The surface or minerals were forfeited to the State for nonpayment of taxes (real estate taxes or severed mineral interest taxes)
				"Nonregistered Severed Minerals"	State will have absolute ownership of all minerals upon the completion of a forfeiture action. Forfeiture action taken due to mineral owner's failure to timely file required statement of severed mineral interest. The owner will be listed as "Undetermined" since the State's ownership is not absolute.
	LEID	foreign key (links to 'Legal Entity')	number (long), 4		Unique identification number for each owner.
	LDID	foreign key (links to 'Legal Description')	number (long), 4		Unique identification number for each forty acre parcel or government lot.
Sample					Table refers to locations where samples were taken. Samples are usually, but not always, tied to a particular stockpile. (Ex. SampleNm 11, 12 and 13 are not tied to a stockpile)
	SampleNm	primary key (links to 'Stockpile Material Sample Acquisition')	text, 4		Unique identifier that corresponds to samples taken from the stockpiles.
				"1" - "82"	Single sample numbers
				"A1" - "A8", "B9", "C10" - "C19", "D20" - "D29", "E30" - "E32"	Composite samples of single samples. E.g., "A1" consists of single samples "53", "54", "55", "56" and "57". A's represent coarse tailings, B's represent Cretaceous ore, C's represent fine tailings, D's represent glacial overburden, E's represent natural ore and taconite mixed-sized rock.
				"ZZ1" - "ZZ10"	Composite samples of composite samples. E.g., "ZZ1" consists of composite samples "A1", "A2", "A3" and "A4".
	SampType		text, 10	"single" or "composite"	See descriptions above for "SampleNm" field
	SampleNumeric		number (long), 4	1 - 82	Numeric version of "SampleNm" field. Used for sorting purposes.
	FeatType		text, 16	"Photo", "Observation" or "Sample"	Type of feature related to a waypoint. Sometimes a photo and observation or photo and sample share the same waypoint number.
	SampWypt		number (long), 4	3, ...41, ...174	The GPS waypoint number associated with a geographic location. Provides link to actual coordinate in the 'X, Y Coordinate' table.
	StudyArea		text, 10	"Calumet" or "Virginia"	Project study area where photo was taken.
Sample Composition					This table lists the make up of composite samples. (Composite samples being one sample made up of several other samples)
	SampCompID	primary key	number (long), 4		Unique identifier for each sample composition record.
	ComSampNm		text, 4	"A1", ..."D21", ..."ZZ7", ...	Composite sample numbers from "SampleNm" field in 'Sample' table
	SampleNm	foreign key (links to 'Sample')	text, 4	"1" - "82" or "A1", ..."D21", ...	Single sample numbers that are in a particular composite sample (E.g., Single samples "53", "54", "55", "56" and "57" make up composite "A1".) or composite sample numbers that are in a particular composite of composite sample (E.g., Composite samples "A1", "A2", "A3" and "A4" make up composite "ZZ1").
Stockpile					Basic stockpile information, including: stockpile ID (used extensively throughout database and on the project report plates), stockpile name (if applicable) and estimated exposed surface acreage.
	StkplID	primary key	number (long), 4	113, 114, 302, 305, ...	Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	StkName		text, 55	"1009", "Cretaceous Ore Dump No. 2", "Columbia Fine Tailings", ...	Local name for stockpile. Usually named by mining company/builder of stockpile.
	StkPhotoIn		yes/no	yes or no	Yes means the stockpile has been photographed. No means the stockpile has not been photographed.
	StkSampIn		yes/no	yes or no	Yes means the stockpile has been sampled. No means the stockpile has not been sampled.
	StkPitIn		yes/no	yes or no	Yes means the stockpile is in a pit. No means the stockpile is not in a pit.
	StkEAcre		number	5420	The estimated exposed surface acreage of a stockpile. If part of a stockpile is covered by another stockpile, the covered acreage is not included in this number.
Stockpile Legal Description					Public land survey legal description for lands in the study areas. Similar to the 'Legal Description' table used to define parcels for surface and mineral ownership purposes, except the legal description for stockpiles stops at the forty acre parcel or government lot level.
	GEOGLOT	primary key	number (double), 8		A 14-digit composite identifier that uniquely defines a portion of land to the government lot level. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, GLOT, given in this order, from 'Legal Description' table)
	COUN		number (double), 8		Two digit County Code
				31	Itasca
				69	St. Louis
	TOWN		number (double), 8	56 and 58	Three digit township number, townships extend east to west.
	RDIR		number (double), 8		Range direction, ranges extend north to south.
				0	West
	RANG		number (double), 8	23, 24, 17	Two digit range number
	SECT		number (double), 8	3, 4, 5, 7, 8, 9, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29	PLS section number
	FORT_DESC		text, 40	See below, under FORT description	This field contains the corresponding text for the numeric values in the FORT field. This IS NOT necessarily the legal description for the parcel, especially in the case of government lots, where the FORT and FORT_DESC are for locational reference only. See the 'Description' column of the FORT field.
	FORT		number (double), 8		A combination of a code for the quarter section and a code for the quarter of the quarter section. The FORT_DESC field contains the corresponding text for the numeric values in the FORT field, as seen in the description column below.
				0	Meandered water body (used in combination with GLOT = 99 to identify meandered water bodies)
				11	NENE
				12	NWNE
				13	SWNE
				14	SENE
				21	NENW
				22	NWNW
				23	SWNW
				24	SENW
				31	NESW
				32	NWSW
				33	SWSW
				34	SESW
				41	NESE
				42	NWSE
				43	SWSE
				44	SESE
	GLOT		number (double), 8		Two-digit government lot ID, if applicable (unique only within a section)
				0-7	Government lot number
				99	Meandered water body (used in combination with FORT = 0 to identify meandered water bodies)
Stockpile Material Information Source					Table that relates each stockpile with one or more information sources for the purpose of tracking how or why certain determinations about a stockpile were made.
	SMISID	primary key	number (long), 4		Unique identification number for each stockpile material information source record.
	InfoSrcID	foreign key (links to 'Information Source')	number (long), 4	1-9	Unique identification number for the nine different information sources.
	StkplID	foreign key (links to 'Mined/Piled Stockpile Material')	number (long), 4	113, 114, 302, 305, ...	Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
Stockpile Material Property Ownership					Table contains ownership information for each piece of stockpile as intersected (or "chopped" up) by Public Land Survey (PLS) forty acre parcels or government lots. The PLS features are contained the 'Stockpile Legal Description' table.
	SMPOID	primary key	number (long), 4		Unique identification number for each stockpile material property ownership record.
	LEID	foreign key (links to 'Legal Entity')	number (long), 4		Unique identification number for each owner.
	SSTMeanOwn		text, 50	"Trust Fund", "Acquired", "Exchange", or "Tax Forfeit". (See valid values described in further detail under "STMeanOwn" in the 'Property Ownership' table)	If the State is the owner, the way in which ownership was acquired by the state is noted. This is the same list of values in the 'Means of Ownership' lookup table.
	StkPLSID	foreign key (links to 'Geoglot and Stockpile Info')	number (double), 8		Unique identification number for each piece of stockpile per forty acre parcel or government lot.
	StkOwnTx		text, 100	"Owner of stockpile in N1/2 of forty", "Ownership through agreement...", etc.	Comments regarding the stockpile ownership
	WithSurIn		yes/no	yes or no	"Yes" means the stockpile ownership is tied to the underlying surface ownership (generally, stockpiles containing overburden materials are tied to the surface owner of the parcel). "No" means the stockpile ownership is not the same as the surface ownership.
	WholeStkIn		yes/no	yes or no	"Yes" means the entire stockpile has the same ownership, regardless of varied underlying surface ownership across many parcels. "No" means the stockpile ownership may vary across many parcels.
	Geoglot	foreign key (links to 'Stockpile Legal Description')	number (double), 8		A 14-digit composite identifier that uniquely defines a portion of land to the government lot level. (Consists of fields: COUN, TOWN, RDIR, RANG, SECT, FORT, GLOT, given in this order, from 'Legal Description' table)
Stockpile Material Sample Acquisition					Table relates a single sample to a specific stockpile and an x, y coordinate.
	SampleNm	primary key (links to 'Sample')	text, 4		Unique identifier that corresponds to samples taken from the stockpiles.
				"1" - "82"	Single sample numbers
	StkplID	foreign key (links to 'Mined/Piled Stockpile Material')	number (long), 4	113, 114, 302, 305, ...	Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	XYIDNm	foreign key (links to 'X, Y Coordinates')	number (long), 4	10, 11, 13, ...308	Unique identification number for each x, y coordinate.
Stockpile Material Type					Table lists 11 stockpile material types, as defined for this project, that occur in the two study areas.
	MatTypID	primary key	number (long), 4	1-11	Unique identification number for each stockpile material type.
	MatTyp		text, 35	"Glacial Overburden"	This includes unconsolidated sediment deposited by glaciers that was removed to gain access to the iron ore. Material consists of sediments deposited during the Quaternary Period (10,000 to 2 million years ago). The sediments range from till (material deposited directly by glacial ice) to sand and gravel (material deposited from glacial meltwater). Till is an unsorted sediment with grain sizes ranging from clay to +5 foot boulders. Multiple glacial advances deposited several till units in the region. Between some of these till units are discrete lenses of sand and gravel. In several overburden stockpiles, many of these various units are mixed together. The stockpiles tend to be boulder-rich with a sandy, silt matrix. The color ranges from buff to reddish-brown. Rock particles are sub-angular to sub-rounded. A few stockpiles contain primarily outwash sand and gravel. The sand and gravel is moderately sorted, oxidized to a light brown color, contains little silt, and is cobble-rich. The rock particles are sub-rounded.
				"Cretaceous Overburden"	This includes unconsolidated sediment in the form of saprolitic clay and rock particles that forms from chemically weathered iron formation. Weathering events occurred during the Cretaceous period (65 to 146 million years ago). This material is dominantly clay with some rock particles. Within a given stockpile, cretaceous overburden may contain glacial till and other "overburden" type sediments.
				"Slate"	A local term used to described a fine-grained rock composed mostly of siliceous minerals. Slate is found above and within the iron formation and is approximately 1.9 billion years old. Although the slate is mostly fine grained, some clastic bedding is evident. Fracturing, or splitting, occurs along bedding planes. Within the pile, slate appears to have a dark gray appearance. Rock sizes range from 1/8 of an inch to +3 feet.
				"Paint Rock"	A highly decomposed, slate-like rock with a tacky, powdery texture on exposed surfaces. The decomposition of these rocks is attributed to weathering of altered slate and natural ore along fault or joint planes. The descriptor "paint" refers to the red to rust colored, colloidal particles that partially constitute the rock. Within the stockpiles, paint rock can vary from fine sand to +3 foot rocks. Similar to natural ore, paint rock fractures parallel to bedding planes.
				"Natural Ore Fine Tailings"	This includes a by-product of the natural iron ore mining processes. Fine tailings have been crushed and usually deposited into a "tailings" basin. This material is very well sorted with a rock size ranging from clay to 3/8 of an inch. Rock fragments are sub-angular.
				"Natural Ore Mixed-Sized Rock"	This includes soft, iron ore that has been altered and re-mineralized along faults and fractures. This material was originally deposited as taconite, which was then oxidized to create trough, fissure, or flat-lying natural iron ore bodies. The mineralogy consists of mostly hematite, goethite and limonite with minor amounts of magnetite and manganese oxides. There are a range of textures from compact to rubbly or friable. Bedding and other primary features are often evident. Within a stockpile, this material is unsorted. Rock sizes range from clay to +6 foot boulders, with an estimated average rock size being 3/8 of an inch to 5 inches. The amount of clay in natural ore piles is difficult to quantify; however, the clay seems to be a natural cement that stabilizes the stockpile. Natural ore rocks fracture, or part, parallel to bedding planes. Taconite boulders are frequently observed along the slopes of natural ore stockpiles and may have been placed there for slope and erosion control.
				"Natural Ore Coarse Tailings"	This includes a by-product of the natural iron ore mining processes. This by-product contains mostly siliceous rocks with some hematite banding. The stockpiles are moderately-well sorted, ranging in size from 3/8 to 4 inches in diameter, and has an angular particle shape. In the processing of coarse tailings, the material was washed; therefore, there is little to no silt within the pile.
				"Taconite rock (boulders)"	This includes magnetic and some non-magnetic iron-bearing boulders. Characterized by alternating bands of iron oxides (magnetite and/or hematite) with bands of silicates and carbonates. Bedding and other primary structures are evident. Most taconite stockpiles consists of boulder-sized rocks ranging from 2 feet to +9 feet in diameter with an estimated average of three feet. The boulders tend to have a blocky shape. Some glacial boulders may be incorporated into the pile.
				"Cretaceous Ore"	Semi-lithified conglomerate deposited during the Cretaceous period. The conglomerate contains sub-angular to rounded hematite cobbles and sands within an iron-rich, glauconitic, carbonate matrix. Cretaceous ore piles have moderately poor sorting and range in grain size from clay to +3 foot boulders. The boulders are highly cemented blocks of smaller rock particles.
				"Taconite Mixed Sized Rock"	Magnetic and non-magnetic iron ore, some of which may have been processed. The rock characterization is described in Taconite Rock Boulders above. This stockpile type is difficult to discern from "Natural ore mixed-sized rock" in the field and may contain other material within the stockpile; classification is based upon company records pertaining to individual stockpiles. These piles are poorly sorted with a rock size from 2mm to +6 feet. Taconite boulders frequently occur along the slope and edges of these piles.
Stockpile Mine of Origin					Table relates a specific stockpile to one or many mines of origin. Determinations are based on records kept by stockpile owners and/or mining companies.
	STMOID	primary key	number (long), 4		Unique identification number for each stockpile mine of origin record.
	StkplID	foreign key (links to 'Mined/Piled Stockpile Material')	number (long), 4		Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	MineID	foreign key (links to 'Natural Ore Mine'	number (long), 4	1 - 62	Unique identification number for each mine/property name.
Stockpile Photo Location					Table relates a photo, and the comments about that photo, to a specific stockpile and an x, y coordinate.
	SPLID	primary key	number (long), 4	1 - 197	Unique identification number for each stockpile photo location record.
	PhotoNm	foreign key (links to 'Photo')	number (long), 4	Ex: 19, 20, 21, ...347	Unique identifier that corresponds to photographs taken of the stockpiles. These photographs (in .jpg format) are included as part of the data from this project.
	StkplID	foreign key (links to 'Mined/Piled Stockpile Material')	number (long), 4		Unique identification number for each stockpile. (Used interchangeably with "Stkp_Uniq")
	PhotoTx		text, 100	Ex: "Close up of material, pen for scale"	Comments about individual photographs. Comments may include if the picture is a close up or taken at a distance, the scale used, and other comments.
	XYIDNm	foreign key (links to 'X, Y Coordinates')	number (long), 4	Ex: 10, 11, 13, ...308	Unique identification number for each x, y coordinate.
Test Name and Sample Number					Table contains a list of all samples, the name of the test performed on the sample and the sample type, single or composite.
	TestName	(may be linked to 'Test Type')	text, 50		The name of tests performed on samples. (See 'Test Type' table for further definition)
	SampleNm	foreign key (links to 'Sample')	text, 4		Unique identifier that corresponds to samples taken from the stockpiles.
	SampType		text, 10	"single" or "composite"	See descriptions above for "SampleNm" field in 'Sample' table
Test Results- Abrasion					This test measures the breakdown of material by weight percent. This test was performed on glacial overburden, natural ore coarse tailings, natural ore fine tailings, natural ore and taconite mixed-sized rock, and cretaceous ore samples.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C131/C535"	These are the official call letters for the American Society Testing and Materials (ASTM) test for Los Angeles Abrasion.
	TR3ID	primary key (composite)	number (long), 4		Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	"ZZ1", "ZZ2", "ZZ3", "ZZ4", 'ZZ5", and "ZZ6"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composites of composite samples.
	AbrasVal		number (double), 8	Ex: 45.30	The test results for abrasions measured in weight percent.
Test Results- Chem Assays					This test measures major chemical oxides within a sample. The results are the percentage of the sample. Chemical assays were performed only on single samples that contain iron ore.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"IRON"	Call letters for this test.
	TR10ID	primary key (composite)	number (long), 4	Ex: 1, 2, 3, 4, ...51	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "14", "15", "16", ..."82"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, single samples taken from iron ore stockpiles.
	Fe		number (double), 8	Ex: 41.91	Percent total iron in a sample by weight.
	Hematite		number (double), 8	Ex: 59.38	Percent of hematite in the sample. This calculation was derived by: (Fe - Fe++) x 1.4297
	Fe++		number (double), 8	Ex: 0.90	Percent ferrous iron in a sample by weight.
	FeO		number (double), 8	Ex: 1.16	Percent iron oxide in a sample by weight.
	SiO2		number (double), 8	Ex: 22.16	Percent of silica in a sample by weight.
	Al2O3		number (double), 8	Ex: 2.685	Percent of aluminum oxide in a sample by weight.
	CaO		number (double), 8	Ex: 1.010	Percent of calcium oxide in a sample by weight.
	MgO		number (double), 8	Ex: 0.345	Percent of magnesium oxide in a sample by weight.
	Na2O		number (double), 8	Ex: 0.013	Percent of sodium oxide in a sample by weight.
	K2O		number (double), 8	Ex: 0.181	Percent of potassium oxide in a sample by weight.
	MnO		number (double), 8	Ex: 0.218	Percent of manganese in a sample by weight.
	FreeSiO2		number (double), 8	Ex: 17.26	Percent of free silica in a sample by weight.
	CO2		number (double), 8	Ex: 0.44	Percent of carbon dioxide in a sample by weight.
Test Results- Clay Lumps					A test to measure the amount of clay lumps and friable particles in a sample by weight percent. Tests were performed on glacial overburden, natural ore coarse tailings, Cretaceous ore, natural ore and taconite mixed-sized rock samples.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C142"	These are the official call letters for the American Society Testing and Materials (ASTM) test for clay lumps.
	TR1ID	primary key (composite)	number (long), 4		Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "A1", "B9"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composite samples of single samples.
	ClyLmpVal		number (double), 8	Ex: 0.62	Amount of clay lumps in a sample by the percent weight.
Test Results- Fine Agg					This test measures the angularity of the fine particles within a sample by weight percent. This test was only performed on natural ore fine tailing samples because of their small grain size.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"T304"	These are the official call letters for the American Society Testing and Materials (ASTM) test for fine aggregate particle shape.
	TR5ID	primary key (composite)	number (long), 4		Unique identification number for each 'test results...' record in this table.
	SampleNm	foreign key (links to 'Sample')	text, 4	Ex: "ZZ4", "ZZ5", "ZZ6"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composites of composite samples.
	FineAggVal		number (double), 8		Amount of fine aggregate angularity by percent weight.
Test Results- FlatElong					This test measures the weight percent of flat and elongated particles within a sample. This test was performed on glacial overburden samples.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"D4791"	These are the official call letters for the American Society Testing and Materials (ASTM) test for flatness and elongation.
	TR2ID	primary key (composite)	number (long), 4	1, 2, 3, ...21	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "A1", "B9"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composite samples of single samples.
	FlatElgVal		number (double), 8	Ex: 1.90	Amount of flat and elongated particles in a sample by weight percent.
Test Results- LtWt Particles					This tests measures the amount of deleterious material that is lightweight. This was performed only on glacial overburden samples.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C123"	Official call letters for the American Society Testing and Materials (ASTM)
	TR4ID	primary key (composite)	number (long), 4	1, 2, 3, ...21	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "D20", "D21", ..."D29"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composite samples of single samples.
	LtWtVal		number (double), 8	Ex: 1.90	Amount of lightweight particles in a sample by weight percent.
Test Results- SGA-Coarse					This test measures the specific gravity (weight/volume) and water absorption for aggregate particles larger than the number 4 sieve. This was performed on all samples except natural ore fine tailings. Fine tailings were not tested because they do not contain any coarse aggregate.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C127"	These are the official call letters for the American Society Testing and Materials (ASTM) test for specific gravity and absorption in coarse materials.
	TR6ID	primary key (composite)	number (long), 4	1, 2, 3, ...32	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "A1", "B9"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composite samples of single samples.
	CBulkOvDry		number (double), 8,	Ex: 2.574	Specific gravity when sample is oven dry and the weight is divided by the bulk volume.
	CBulkSSDry		number (double), 8,	Ex: 2.732	Specific gravity when sample has a saturated surface where the weight of the dry aggregate plus the weight of the water in pores are divided by the bulk volume.
	CApOvDry		number (double), 8	Ex: 3.057	Specific gravity when the sample is dry and the sample weight is divided by the volume of the solid aggregate.
	CAbsorpPc		number (double), 8	Ex: 6.130	Weight percent of the water absorbed in the pore space of the sample.
Test Results- SGA-Fine					This test measures the specific gravity (weight/volume) and water absorption for aggregate particles smaller than the number 4 sieve. This was performed on all samples.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C128"	These are the official call letters for the American Society Testing and Materials (ASTM) test for specific gravity and absorption in fine materials.
	TR7ID	primary key (composite)	number (long), 4	1, 2, 3, ...32	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "A1", "B9"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composite samples of single samples.
	FBulkOvDry		number (double), 8,	Ex: 2.574	Specific gravity when sample is oven dry and the weight is divided by the bulk volume.
	FBulkSSDry		number (double), 8,	Ex: 2.732	Specific gravity when sample has a saturated surface where the weight of the dry aggregate plus the weight of the water in pores are divided by the bulk volume.
	FApOvDry		number (double), 8	Ex: 3.057	Specific gravity when the sample is dry and the sample weight is divided by the volume of the solid aggregate.
	FAbsorpPc		number (double), 8	Ex: 6.130	Weight percent of the water absorbed in the pore space of the sample.
Test Results-Sieve					This test measures the various sized particles of a sample by percent passing each sieve by weight. This test was conducted on all samples except for 45 and 46 (too fine to dry sieve).
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"MNDNR"	Call letters for this test. (In this case, it specifies the laboratory where the analysis was conducted)
	TR8ID	primary key (composite)	number (long), 4	1, 2, 3, ...80	Unique identification number for each 'test results...' record in this table.
	SampleNM	foreign key (links to 'Sample')	text, 4	Ex: "1", "2", "3", "4", ...	Unique identifier that corresponds to samples taken from the stockpiles. In this case, single samples taken from stockpiles. All samples were sieve except samples 44 and 45.
	4in		number (double), 8	Ex: 100	Weight percent passing on the 4 inch sieve.
	3in		number (double), 8	Ex: 100	Weight percent passing on the 3 inch sieve.
	2,5in		number (double), 8	Ex:: 97	Weight percent passing on the 2.5 inch sieve.
	2in		number (double), 8	Ex:: 92	Weight percent passing on the 2 inch sieve.
	1,5in		number (double), 8	Ex: 88	Weight percent passing on the 1.5 inch sieve.
	1,25in		number (double), 8	Ex: 85	Weight percent passing on the 1.25 inch sieve.
	1in		number (double), 8	Ex: 75	Weight percent passing on the 1 inch sieve.
	3/4in		number (double), 8	Ex: 71	Weight percent passing on the 3/4 inch sieve.
	5/8in		number (double), 8	Ex: 69	Weight percent passing on the 5/8 inch sieve.
	num4		number (double), 8	Ex: 51	Weight percent passing on the Number 4 Sieve.
	num8		number (double), 8	Ex: 45	Weight percent passing on the Number 8 Sieve.
	num10		number (double), 8	Ex: 40	Weight percent passing on the Number 10 Sieve.
	num16		number (double), 8	Ex: 39	Weight percent passing on the Number 16 Sieve.
	num30		number (double), 8	Ex: 20	Weight percent passing on the Number 30 Sieve.
	num40		number (double), 8	Ex: 17	Weight percent passing on the Number 40 Sieve.
	num50		number (double), 8	Ex: 15	Weight percent passing on the Number 50 Sieve.
	num100		number (double), 8	Ex: 10	Weight percent passing on the Number 100 Sieve.
	num200		number (double), 8	Ex: 4	Weight percent passing on the Number 200 Sieve.
Test Results-Soundness					This test measures the ability of a material to withstand freeze/thaw cycles and is measured in weight percent. This test was performed on all sampled material types except for natural ore fine tailings.
	TestTypeID	primary key (composite) foreign key (links to 'Test Type')	text, 20	"C88"	These are the official call letters for the American Society Testing and Materials (ASTM) test for determining the results of magnesium sulfate or soundness tests.
	TR9ID	primary key (composite)	number (long), 4	1 - 7	Unique identification number for each 'test results...' record in this table.
	SampleNm	foreign key (links to 'Sample')	text, 4	Ex: "ZZ1", "ZZ7", "ZZ10"	Unique identifier that corresponds to samples taken from the stockpiles. In this case, composites of composite samples.
	11/2to1in		number (double), 8	Ex: 12.7	Percent by weight breakdown of material that is 11/2 to 1 inch in diameter.
	1to3/4in		number (double), 8	Ex: 20.6	Percent by weight breakdown of material that is 1 to 3/4 inch in diameter.
	3/4to1/2in		number (double), 8	Ex: 28.9	Percent by weight breakdown of material that is 3/4 to ½ inch in diameter.
	1/2to3/8in		number (double), 8	Ex: 41.0	Percent by weight breakdown of material that is ½ to 3/8 inch in diameter.
	3/8toNum4		number (double), 8	Ex: 41.5	Percent by weight breakdown of material that is 3/8 inch to number 4 mesh diameter.
	CompLoss		number (double), 8	Ex: 33.8	Composite percent by weight breakdown of material.
Test Type					Table lists all test types performed on samples.
	TestName		text, 50		Name of test performed on samples.
				"Lightweight Particles"	This tests measures the amount of deleterious material that are lightweight. This was performed only on glacial overburden samples.
				"Specific Gravity and Absorption-Coarse"	This test measures the specific gravity (weight/volume) and water absorption for aggregate particles larger than the number 4 sieve. This was performed on all samples except natural ore fine tailings.
				"Specific Gravity and Absorption-Fine"	This test measures the specific gravity (weight/volume) and water absorption for aggregate particles smaller than the number 4 sieve. This was performed on all samples.
				"Los Angeles Abrasion"	This test measures the breakdown of material by weight percent. This test was performed on glacial overburden, natural ore coarse tailings, natural ore fine tailings, natural ore and taconite mixed-sized rock, and cretaceous ore samples.
				"Clay Lumps and Friable Particles"	A test to measure the amount of clay lumps and friable particles in a sample by weight percent. Tests were performed on glacial overburden, natural ore coarse tailings, Cretaceous ore, natural ore and taconite mixed-sized rock samples.
				"Magnesium Sulfate Soundness"	This test measures the ability of a material to withstand freeze/thaw cycles and is measured in weight percent. This test was performed on all sampled material types except for natural ore fine tailings.
				"Flatness and Elongation"	This test measures the weight percent of flat and elongated particles within a sample. This test was performed on glacial overburden samples.
				"Chemical Assays"	This test measures major chemical oxides within a sample. The results are the percentage of the sample. Chemical assays were performed on only samples that contain iron ore.
				"Sieve Analysis (Gradations)"	This test measures the various sized particles of a sample by percent passing each sieve by weight. This test was conducted on all samples except for 45 and 46 (too fine to dry sieve).
				"Spall"	Spall is any deleterious material within a sample (i.e. shale, iron oxide, soft particles). This test measures the total spall within a sample by weight percent. This test was performed on glacial overburden samples.
				"Fine Aggregate Angularity"	This test measures the angularity of the fine particles within a sample by weight percent. This test was performed on natural ore fine tailing samples.
	TestTypeID	primary key	text, 20		These are the corresponding ASTM and other call letters for each test.
				"C123"	Lightweight Particles
				"C127"	Specific Gravity and Absorption-Coarse
				"C128"	Specific Gravity and Absorption-Fine
				"C131/C535"	Los Angeles Abrasion
				"C142"	Clay Lumps and Friable Particles
				"C88"	Magnesium Sulfate Soundness
				"D4791"	Flatness and Elongation
				"IRON"	Chemical Assays
				"MNDNR"	Sieve Analysis (Gradations)- performed by MNDNR
				"MNDOT"	Spall
				"T304"	Fine Aggregate Angularity
	TestAbbr		text, 20		This are the abbreviations used in the data base for each test.
				"LtWt Particles"	Lightweight Particles
				"SGA-Coarse"	Specific Gravity and Absorption-Coarse
				"SGA-Fine"	Specific Gravity and Absorption-Fine
				"Abrasion"	Los Angeles Abrasion
				"Clay Lumps"	Clay Lumps and Friable Particles
				"Soundness"	Magnesium Sulfate Soundness
				"FlatElong"	Flatness and Elongation
				"Chem Assays"	Chemical Assays
				"Sieve"	Sieve Analysis (Gradations)- performed by MNDNR
				"Spall"	Spall
				"Fine Agg"	Fine Aggregate Angularity
Test Type Determination					This table notes which tests are performed on which material types. For further explanation, refer to 'Test Type' table.
	TTDID	primary key	number (long), 4		Unique identification number for each test type determination record.
	TestTypeID	foreign key (links to 'Test Type')	text, 20	"C123", "C88", "C4791", "IRON", ...	This are the corresponding ASTM and other call letters for each test.
	MatTypID	foreign key (links to 'Stockpile Material Type')	number (long), 4	1-11	Unique identification number for each stockpile material type. (See 'Stockpile Material Type' table for definitions)
X, Y Coordinate					Table contains all possible point locations where observations, samples and photos were taken.
	XYID	primary key	number (long), 4	10, 11, 13, ...308	Unique identification number for each x, y coordinate.
	StudyArea		text, 10	"Calumet" or "Virginia"	Project study area where coordinate was collected.
	Descriptio		text, 40	"01-AUG-00 14:10"	Date and time that point was collected using GPS receiver. Coordinates not collected with a GPS receiver have a null value in this field.
	X_Coord		number (double), 8		UTM X coordinate in zone 15, meters
	Y_Coord		number (double), 8		UTM Y coordinate in zone 15, meters
	Method		text, 20		How the coordinate was obtained
				"GPS"	Garmin GPS receiver
				"Screen digitized"	Digitized on screen using ArcView