Arthur Lakes Library

Map Room -- Introduction to Index and Inventory of USGS Maps Using Microsoft Access, Version 2.1
Assistance Available: 8:00 am - 5:00 pm, Monday - Friday Phone: (303) 273-3697 Fax: (303) 273-3199 Email:
Files Available for Downloading
INTRODUCTION TO INDEX AND INVENTORY OF USGS MAPS USING MICROSOFT ACCESS Version 2.1 Arthur Lakes Library, Colorado School of Mines April 1998 Introduction 1:24,000 (1:20,000 Puerto Rico and 1:63,000 Alaska) Tables 1:25,000 Tables 1:50,000 Table 1:100,000 Topographic, Mineral Management, Surface Management Tables 1:250,000 Table 1:100,000 & 1:50,000 County Table Misc. Tables United States 1:100,000 Land Use/Land Cover, United States 1:250,000 Land Use/Land Cover, and United States National Atlas Tables How to Update Tables Creating Other Tables Which scale maps are available for which state Map Type Descriptions
Introduction
This database was created using Microsoft Access 2.0 in Windows 3.11, with data issued by the United States Geological Survey (USGS) in February 1998. The database contains information about the topographic maps sold by USGS of the United States and its territories. The following scales are included in this database: 1:20,000 (Puerto Rico), 1:24,000, 1:25,000 (USGS & DMA or NIMA), 1:50,000 (DMA or NIMA), 1:63,000 (Alaska), 1:100,000 (USGS and BLM), 1:250,000, 1:500,000 (state base map). Each map listed contains the following information: Map name, State Scale Year Southeastern Latitude of the map Southeastern Longitude of the map Map type (see final pages for definitions) USGS file number ISBN (International Standard Book Number) The scale field has been removed from all but the "Counties" and "Misc" tables. There are no ISBNs for the 1:50,000 and 1:25,000 issued by the Defense Mapping Agency (DMA, now NIMA). The columns "Date received," and "Call number" in certain scales, have been added. The database was designed to help libraries keep an inventory of their holdings of USGS maps. It assumes that most libraries keep their 1:24,000 (7.5') topos segregated by state. Libraries differ on how they separate the other maps. Therefore, the database makes it possible to keep track of maps, such as the 1:100,000 or 1:250,000, by scale, by state, or both. Each state, including Washington, DC, has a "1:24,000" and "Misc" table. Puerto Rico does not have a "1:24,000" table, but does have a "1:20,000" table. In addition, Alaska has a "1:63,000" table. "American Samoa," "Guam," "Virgin Islands" and "World" do NOT have "Misc" tables.
All Tables
Each table has been encoded with a Primary Key. This key tells the computer which column in the table should be used for putting it in order. Most Primary Keys are the "Map name, State" column; this ensures that the data will be alphabetized by the map name. However, some tables ("1:25,000," "1:100,000 & 1:50,000 County," "1:50,000," "1:250,000" and all "Misc" tables) are in "USGS #" order. Orthophoto and satellite maps may be found in their appropriate tables. Within each state list you will NOT find maps of overlapping states-these have been removed. The overlapping maps can only be found in the state tables, when that particular state comes first in the name. For example, Ashaway, R.I.--Conn. can only be found in the "Rhode Island 1:24,000" table, NOT the "Connecticut 1:24,000," while Voluntown, Conn.-R.I. can only be found in the "Connecticut 1:24,000" NOT the "Rhode Island 1:24,000" table.
1:24,000 (1:20,000 Puerto Rico and 1:63,000 Alaska) Tables
These maps have their own individual tables for their respective states. There is no "Master" listing of all the 1:24,000 topos of the United States (Access is limited to 30,000 items per table). All the "Shaded Relief" and "National Park" maps have been removed and put into the appropriate "Misc" tables.
1:25,000 Table
A majority of the maps in this list have been produced by USGS; the rest by DMA. Most libraries shelve the DMA set by series and sheet number (i.e., Series V877 Sheet 4961 II NE) rather than sheet name (Big Bull Mountain). The series and sheet numbers are NOT given in this database--they were not included by USGS.
1:50,000 Table
The 1:50,000 maps have been produced by DMA. Most do NOT have ISBNs. Like the 1:25,000, these maps are usually shelved by set by series and sheet number (i.e., Series V777 Sheet 4762 IV) rather than sheet name (Holy Cross). The series and sheet numbers are NOT given in this database--they were not included by USGS.
1:100,000: Topographic, Mineral Management Status, Surface Management Status Tables
These three are separated into distinct sets. All types of maps are included with each set-topographic metric (TM), topobathymetric (TB) and planimetric (PL). Most of the Eastern states do not have Mineral or Surface Management maps.
1:250,000 Table
This table contains data on all types (topographic, topobathymetric, radar image, boundary, ecological, and shaded relief) of 1:250,000 maps, except National Park maps, which have been placed in their appropriate "Misc" tables.
1:100,000 & 1:50,000 County Table
The "County" Table contains data pertaining to the maps of the counties of the US. The scale column was not stripped out of this set, since the scale can be either 1:50,000 or 1:100,000.
Misc Tables
These tables contain lists of maps that do not fall into any other category. These lists include Basemaps, National Park Maps, Shaded Relief maps and State Indexes. Orthophoto and Satellite maps may be found with their respective scales (1:24,000, 1:25,000, 1:50,000, and 1:250,000).
United States 1:100,000 Land Use/Land Cover, United States 1:250,000 Land Use/Land Cover, and United States National Atlas
These sets have been placed in their own tables.
How to Update Your Database using Microsoft Access
Let's assume you have received the 1990 Alamosa, Colorado version of the 1:100,000 Mineral Management Status map. You wish to update your database to reflect this acquisition. Once in Access, select "File--Open Database" and select "topos.mdb." Once this is open, double click on the "1:100,000 Mineral Management Status" table. Now you are ready to update the table. Move your cursor down to "Year" field of the "Alamosa, CO" row. Highlight the field. Type in "1990." Next move to the "ISBN" field, and type in the new number. The "ISBN" changes with each edition of the map; the "USGS #" remains constant. Now move over to the "Date received" field and type in today's date. You may also use the shortcut key for adding the date-- ";" will add today's date. The "1:100,000 Mineral Management Status" table is updated. Close the table. Access saves the changes automatically.
Creating Other Tables
You may wish to create a table of a particular state of a particular scale (other than 1:24,000). Let's assume you want to create a table of all the 1:100,000 Topographic maps of Missouri. First, check the list on the following page to make sure that there are maps of Missouri at that scale. Once you have confirmed this, click on the "Query" sidebar. You will see a list of queries. Each is set up to use a particular table. Click once on the "100 Topographic" query. Click the "design" bar. A new window will appear. At the bottom of the window, you will see a table in which the first row is labeled "Field." Move across that table until you come to the "USGS #" column. Currently, the "Criteria" field should read "Like "T"". After the "T" in that field, add the 2 letter postal code of the state (a list of the codes may be found on the following page). Be sure to use capital letters. In this case, Missouri would be "MO." Your new field should now look like this: Like "TMO". To run the query and see the new list, click on the "!" button at the top of the screen. A new table should appear with only the 1:100,000 Topographic maps of Missouri in it. If you wish to save the table, you may use the "Query -- Make Table..." command. Once you are done examining this new table, close out of the query. It will ask you if you want "Save changes," click "NO."
STATE STATE 25 50 100 100 100 250 COUNTY SURFACE MINERAL Alabama AL Y Y Y Y Alaska AK Y NA Y Arizona AZ Y Y Y Y Y Y Arkansas AR Y Y Y Y Y California CA Y Y Y Y Y Y Y Colorado CO Y Y Y Y Y Y Connecticut CT Y Y Y Y Y Delaware DE Y Y Washington, DC DC Y Y Florida FL Y Y Y Y Y Georgia GA Y Y Y Y Hawaii HI Y Y NA Y Y Idaho ID Y Y Y Y Y Illinois IL Y Y Y Y Indiana IN Y Y Y Iowa IA Y Y Y Kansas KS Y Y Y Y Kentucky KY Y Y Y Y Y Y Louisiana LA Y Y Y Maine ME Y Y Y Maryland MD Y Y Y Massachusetts MA Y Y Y Y Michigan MI Y Y Y Y Y Y Y Minnesota MN Y Y Y Y Y Mississippi MS Y Y Y Missouri MO Y Y Y Y Y Y Montana MT Y Y Y Y Nebraska NE Y Y Nevada NV Y Y Y Y Y Y New Hampshire NH Y Y Y NA New Jersey NJ Y Y Y New Mexico NM Y Y Y Y Y Y Y New York NY Y Y Y Y North Carolina NC Y Y Y North Dakota ND Y Y Y Y Ohio OH Y Y Y Y Oklahoma OK Y Y Y Y Y Oregon OR Y Y Y Y Y Pennsylvania PA Y Y Y Y Puerto Rico PR Y NA NA Rhode Island RI Y Y Y Y South Carolina SC Y Y Y South Dakota SD Y Y Y Y Y Tennessee TN Y Y Y Texas TX Y Y Y Y Y Y Utah UT Y Y Y Y Y Vermont VT Y Y NA Virginia VA Y Y Y Y Y Washington WA Y Y Y Y Y Y Y West Virginia WV Y Y Y Y Y Wisconsin WI Y Y Y Y Y Y Wyoming WY Y Y Y Y Y American Samoa, Guam, Virgin Islands, World, United States 1:100,000 Land Use/Land Cover, United States 1:250,000 Land Use/Land Cover, and United States National Atlas do NOT have maps in any of these categories.
MAP TYPE MAP TYPE DESCRIPTION "SHORT NAME" AB ALASKA BOUNDARY SERIES - INDX ABS INDX AF ALASKA BOUNDARY SERIES - NFS ABS NFS AI ANTARCTICA SATELLITE IMAGERY ANT SATEL AL ALASKA BOUNDARY SERIES - BLM ANT BLM AP ALASKA BOUNDARY SERIES - NPS ABS NPS AW ALASKA BOUNDARY SERIES - NWR ABS NWR CF COUNTY FEET CNTY FEET CM COUNTY METRIC CNTY METRIC CPT COUNTY PLANIMETRIC CNTY PLANI EI ECOLOGICAL INVENTORY FWS ECO INV EM RADAR IMAGE MOSAIC RADARMOSAIC ES RADAR STEREO IMAGE RADAR STEREO ID INDEX TO DIGITAL CARTO DATA DIGI INDEX IG INDICES GENERAL GEN INDEX IH INDEX TO SET OF 100 MAPS SCHOOL SET IL INDEX TO LAND USE/LAND COVER LULC INDEX IM INDEX TO DMA MAPPING DMA INDEX IO INDEX TO ORTHOPHOTOQUAD OQ INDEX IP INDEX TO NATIONAL PARK MAPS NP INDEX IQ INDEX TO 7.5 AND 15 MIN TOPO STATE INDEX IS INDEX TO SMALL SCALE MAPS SMALL INDEX IW INTERNATIONAL MAP OF THE WORLD IMW IX INDEX TO LANDSAT WRS WRS INDEX L LAND USE/LAND COVER LULC LB LAND USE/LAND COVER - BASE LULC BASE LI LANDSAT IMAGERY LS IMAGERY LM LAND USE/LAND COVER - MULTI LULC COLOR LR LINE MAP W/RADAR LINE/RADAR LS LINE MAP W/SATELLITE LINE/SATELL MC STATE MAP CATALOG CATALOG MI STATE MAP INDEX INDEX MMP MINERALS MANAGEMENT - PLANI MM PLANI MMT MINERALS MANAGEMENT - TOPO MM TOPO NA NATIONAL ATLAS SEPARATES NTL ATL OMT ORTHOPHOTOMAP ORTHOPHOTO OQ ORTHOPHOTOQUAD OQ PF NATL PARK - FEET NP FEET PL PLANIMETRIC PLANI PM NATL PARK - METRIC NP METR PR NATL PARK - SHADED NP SR RA RADAR - AIRBORNE RAD AIR RF REGIONAL - FEET REG FEET RM REGIONAL - METRIC REG METR RP REGIONAL - PLANIMETRIC REG PL RS RADAR SATELLITE RAD SAT RT REGIONAL - TOPOGRAPHIC REGTOPO SI SATELLITE IMAGERY SATE IMAG SL SLOPE MAP SLOPE MAP SMP SURFACE MANAGEMENT - PLANI SM PLANI SMT SURFACE MANAGEMENT - TOPO SM TOPO SP STATE BASE - PLANIMETRIC STATE PL SR SHADED RELIEF MAP SHD RLF ST STATE BASE - TOPOGRAPHIC STATE TOPO TB TOPOBATHYMETRIC TOPOBATHY TF TOPOGRAPHICAL FEET TOPO FEET TI TOPOGRAPHIC INDEX TOPO INDEX TM TOPOGRAPHICAL METRIC TOPO METRIC UB UNITED STATES BASE US BASE UC UNITED STATES CONTOUR US CONTOUR UF UNITED STATES FEDERAL US FED UG UNITED STATES GENERAL US GEN UH UNITED STATES PUB LND SURVEY US PLS UM UNITED STATES MAGNETIC US MAGN UO UNITED STATES OUTLINE US OUTLINE UP UNITED STATES POLITICAL US POL UR UNITED STATES SHADED US SHADED UT UNITED STATES TRANSPORTATION US TRANSP VF PROVISIONAL FEET PRV FEET VM PROVISIONAL METRIC PRV METR
Comments, additions and corrections are appreciated. Please send them to .
Return to Map Room Home