Wikidata:Dataset Imports/Geographic Names Information System (GNIS) Domestic

You may find these related resources helpful:

• Dataset Imports
• Why import data into Wikidata.
• Learn how to import data
• Bot requests
• Ask a data import question

Guidelines for using this page

Documenting the import

• Guidelines on how to import a dataset into Wikidata are available at Wikidata:Data Import Guide.
• Please include notes on all steps of the process.
• Once a dataset has been imported into Wikidata please edit the page to change the progress status from in progress to complete.

Wikidata item for the dataset

GNIS Feature ID (P590)
GNIS Feature ID (Q19832959)

Getting help

• If your dataset import runs into issues please edit the page to change the progress status from in progress to help needed.
• You can ask for help on Wikidata:Project chat.

Overview

Dataset name

Geographic Names Information System (GNIS) Domestic

Source

United States Geological Survey along with the United States Board on Geographic Names

Link

https://geonames.usgs.gov/domestic/

Dataset description

GNIS Domestic is a part of the larger GNIS database for the United States. The GNIS ID is the official identifier of federally recognized names of physical and cultural geographic features in the United States and associated areas, but does not including roads and highways. It also include names or spellings other than the official name, feature designations, feature classification, historical and descriptive information, and for some categories the geometric boundaries.

Progress of import

Wikidata item for dataset	Description of dataset	Create and import data into spreadsheet	Structure of data within Wikidata	Format the data to be imported	Match the data to existing data	Importing data into Wikidata	Date import complete and notes
??	Name: GNIS Domestic Source: United States Geological Survey along with the United States Board on Geographic Names Link: https://geonames.usgs.gov/domestic/ Description: Import the US Government ID's for physical and cultural geographic features in the United States and associated areas	Link: GNIS Domestic Import Done: To do: Notes: Spreadsheet is comment only	Structure: GNIS ID (P540) Example item: Lebanon (867976) Done: To do: Airport, Arch, Area, Arroyo, Bar, Basin, Bay, Beach, Bench, Bend, Bridge, Building, Canal, Cape, Cave, Cemetery, Census, Channel, Church, Civil, Cliff, Crater, Crossing, Dam, Falls, Flat, Forest, Gap, Glacier, Gut, Harbor, Hospital, Island, Isthmus, Lake, Lava, Levee, Locale, Military, Mine, Oilfield, Park, Pillar, Plain, Populated Place, Post Office, Range, Rapids, Reserve, Reservoir, Ridge, School, Sea, Slope, Spring, Stream, Summit, Swamp, Tower, Trail, Tunnel, Unknown, Valley, Well, Woods	Done: To do: Airport, Arch, Area, Arroyo, Bar, Basin, Bay, Beach, Bench, Bend, Bridge, Building, Canal, Cape, Cave, Cemetery, Census, Channel, Church, Civil, Cliff, Crater, Crossing, Dam, Falls, Flat, Forest, Gap, Glacier, Gut, Harbor, Hospital, Island, Isthmus, Lake, Lava, Levee, Locale, Military, Mine, Oilfield, Park, Pillar, Plain, Populated Place, Post Office, Range, Rapids, Reserve, Reservoir, Ridge, School, Sea, Slope, Spring, Stream, Summit, Swamp, Tower, Trail, Tunnel, Unknown, Valley, Well, Woods Notes:	Done: Lake To do: Airport, Arch, Area, Arroyo, Bar, Basin, Bay, Beach, Bench, Bend, Bridge, Building, Canal, Cape, Cave, Cemetery, Census, Channel, Church, Civil, Cliff, Crater, Crossing, Dam, Falls, Flat, Forest, Gap, Glacier, Gut, Harbor, Hospital, Island, Isthmus, Lava, Levee, Locale, Military, Mine, Oilfield, Park, Pillar, Plain, Populated Place, Post Office, Range, Rapids, Reserve, Reservoir, Ridge, School, Sea, Slope, Spring, Stream, Summit, Swamp, Tower, Trail, Tunnel, Unknown, Valley, Well, Woods Notes: Matching sets for earlier sets may exclude non 50 state items from the entire list. Lakes, Reservoirs, Dams, Cemetary, Streams, Falls, Craters, Rapids should be reviewed for completeness. Also these were based on June 2018 export and the latter were based on the October 2018 export.	Done: To do: Airport, Arch, Area, Arroyo, Bar, Basin, Bay, Beach, Bench, Bend, Bridge, Building, Canal, Cape, Cave, Cemetery, Census, Channel, Church, Civil, Cliff, Crater, Crossing, Dam, Falls, Flat, Forest, Gap, Glacier, Gut, Harbor, Hospital, Island, Isthmus, Lava, Levee, Locale, Military, Mine, Oilfield, Park, Pillar, Plain, Populated Place, Post Office, Range, Rapids, Reserve, Reservoir, Ridge, School, Sea, Slope, Spring, Stream, Summit, Swamp, Tower, Trail, Tunnel, Unknown, Valley, Well, Woods Notes:	Date complete: Notes:

Edit history

Use this section to list batches of edits that have been completed for this dataset. Ideally each entry should have all applicable columns filled out, but at a minimum please make to add a date and description to give an idea of what was added to Wikidata and when.
See the example entry in the table below for a good way to record an individual entry. Make sure you replace this entry when you record you're first edits!

Date	Description	Method	Property	Qualifiers	References	Statements added	Statements removed	Link to import sheet
22 Mar 2020	Import of 250 examples of Lakes not currently found after a manual curation of GNIS Lakes in Michigan for discussion before the remaining 4019 GNIS ID for Lakes are imported for Michigan.	QuickStatements	GNIS Feature ID (P590)		stated in (P248)	250	0
1 Jan 2021	Import lakes with matching names after manually examining all items whose coordinates are off by more than 100 meters.	wikibase-cli	GNIS Feature ID (P590)			1751	0	import sheet;

Discussion of import

These headings are generally useful, please change this section to suit your needs.

Structure of data within Wikidata

Field name	Wikidata property	Notes
Name1	Property1	Notes1
Name2	Property2	Notes2
Name3	Property3	Notes3

Importing data into Wikidata

• This is over 2 million entries and will be approached in subsets based on feature types as described by the GNIS feature class ie Airport, Bay, Lake, Falls, etc. This is to make one the import matching of existing entries more manageable.
• Entities that are historical are having their description lead with Historical [type] in... . For Example: Historical Airport in Mecklenburg County, North Carolina
• The spreadsheets linked may only be a subset of the larger dataset, manipulation will be conducted in Openrefine and exported as TSV for import to Mix'n'match due to the number of resolutions needed of existing Wikidata entries.

Maintainance queries and expected results

Query link	Description	Expected results
Link1	Property1	Notes1
Link2	Property2	Notes2
Link3	Property3	Notes3