Details
Grid Coordinate System Name: Universal Transverse Mercator
UTM Zone Number: 13
Transverse Mercator Projection
Scale Factor at Central Meridian: 0.999600
Longitude of Central Meridian: -105.000000
Latitude of Projection Origin: 0.000000
False Easting: 500000.000000
False Northing: 0.000000
Planar Coordinate Information
Planar Distance Units: meters
Coordinate Encoding Method: coordinate pair
Coordinate Representation
Abscissa Resolution: 0.000000
Ordinate Resolution: 0.000000
Geodetic Model
Horizontal Datum Name: North American Datum of 1983
Ellipsoid Name: Geodetic Reference System 80
Semi-major Axis: 6378137.000000
Denominator of Flattening Ratio: 298.257222
Process step 1
Process description: The USFS Abandoned Mine Land Inventory - Colorado was originally created using database software and early versions of ArcGIS (e.g. dBase IV, Lotus 1,2,3, Excel versions, ArcView 3.2 and following versions). To update the project and merge these various data types into a single package in ArcGIS 9.3 a number of issues had to be resolved.
First, in these publications the comment fields were stored in a separate file that linked to the features in Arc. In order to migrate the comment fields from the tables in which they resided to ArcGIS the UniqueID field was created through a concatenation of REGION, STATE, FOREST, RGR_DIST, XUTM, YUTM, AREAID, and the feature number (either HID, PID, WID). After removing various artifact characters (line breaks, carriage returns, ect.) from the comment files the resulting "cleaned" tables were joined to their corresponding feature classes using the UniqueID field. (The comments for the 300-series water test sites were not previously integrated and were merged from 20+ Excel spreadsheets before they could be migrated into ArcGIS.)
Second, the null values had been lost from fields in each feature class having been replaced with zeros. In order to restore these values the original tables containing these nulls (store as excel spreadsheets) were joined to the feature classes and the fields missing nulls in Arc were replaced with the fields from the spreadsheet.
Third, the original publication utilized a code system that required the user to look up codes in order to interpret the data stored in each field. For instance, access to a mine opening was denoted as N= no trail, T= Trail, or J= jeep road. This code system was replaced with each field being populated with full definitions.
Fourth, the 300-series water test sites for the early 1991-1992 initial pilot project were not plotted and had to be digitized. These 200 or so points were plotted by first assigning them the centroid of the inventory area to which they were tied and then moving them to their correct position by using the sketch maps of the inventory areas provided in the original data sheets.
Fifth, the photos of each feature were integrated into the current ArcGIS geodatabase. A Lotus 1,2,3 file that catalogued each photo and associated it to the corresponding feature(s) was used to create a feature class that provided the photos with a geographic location. The Lotus 1,2,3 file was opened in Access, and then exported into Excel. A UniqueID composed of XUTM, YUTM, and AREAID was created for each photo and then used to give the photos the location of the centroid of each inventory area. The table was then brought into ArcGIS where the inventory areas feature class were spatially joined to each photo creating a polygon, photo feature class.
The result of this work flow is a consolidated geodatabase that contains all of the data found on the original field forms as well as the photo of each feature. The features present in the geodatabase retain the location accuracy of the original digitization.
Source used: \\CGS-JQY21D1-WXP\C$\USFS_AMLI\Final Versions\Copy of USFS Abandoned Mine Land Inventory.mdb
Process date: 20110330
at time 10030600