USGS GEOGRAPHIC NAMES INFORMATION SYSTEM (GNIS)
FOR TENNESSEE


Charles A. Reeves, Jr.

As some may already know, the USGS’ Geographic Names Information System (GNIS) has undergone major changes, which they call an “upgrade.”  The user interface system has definitely changed, but unfortunately searches on historical features many of us have done in the past are no longer supported.  These include:Airport, Bridge, Building, Cemetery, Church, Dam, Forest, Harbor, Hospital, Mine, Oilfield, Park, Post Office, Reserve, School, Tower, Trail, Tunnel, and Well.

The new system is here:  https://edits.nationalmap.gov/apps/gaz-domestic/public/search/names

But all is not lost, because they have made the previous GNIS database available by states as comma-delimited text files, available here:

https://www.usgs.gov/u.s.-board-on-geographic-names/download-gnis-data

I downloaded the Tennessee file and have created a spreadsheet for it in LibreOffice. The very large spreadsheet (6 MB), sorted first by county, then by feature name is here:

TN_Features_20210825_sorted.ods

I have also created individual file for each county from this spreadsheet, available from the following links.

Anderson
Bedfdord
Benton
Bledsoe
Blount
Bradley
Campbell
Cannon
Carroll
Carter
Cheatham
Chester
Claiborne
Clay
Cocke
Coffee
Crockett
Cumberland
Davidson
Decatur
DeKalb
Dickson
Dyer
Fayette
Fentress
Franklin
Gibson
Giles
Grainger
Greene
Grundy
Hamblen
Hamilton
Hancock
Hardeman
Hardin
Hawkins
Haywood
Henderson
Henry
Hickman
Houston
Humphreys
Jackson
Jefferson
Johnson
Knox
Lake
Lauderdale
Lawrence
Lewis
Lincoln
Loudon
Macon
Madison
Marion
Marshall
Maury
McMinn
McNairy
Meigs
Monroe
Montgomery
Moore Morgan
Obion Overton Perry Pickett Polk
Putnam Rhea Roane Robertson Rutherford
Scott
Sequatchie
Sevier Shelby Smith
Stewart Sullivan Sumner Tipton Trousdale
Unicoi Union Van Buren Warren Washington
Wayne Weakley White Williamson Wilson


My old Excel 2011 (Version 14.6.1) will not open or import .ods files, but later versions will do so.  I expect any version of Excel should be able to open the original text-delimited file, which I did in LibreOffice to create these files, although it did take a bit of work to get them to the current forms.

If you would like to try LibreOffice, it is free, although donations are appreciated, and is available in both Windows and Mac versions:

https://www.libreoffice.org/download/download/



This page created 13 Feb 2022 by Charles A. Reeves, Jr.