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

You may find these related resources helpful:

High-contrast-document-save.svg Dataset Imports    High-contrast-view-refresh.svg Why import data into Wikidata.    Light-Bulb by Till Teenck.svg Learn how to import data    Noun project 1248.svg Bot requests    Question Noun project 2185.svg Ask a data import question


Guidelines for using this pageEdit

Documenting the importEdit

  • 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 datasetEdit

GNIS ID (P590)
GNIS ID (Q19832959)

Getting helpEdit

  • 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.

OverviewEdit

Dataset nameEdit

Geographic Names Information System (GNIS) Domestic

SourceEdit

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

LinkEdit

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

Dataset descriptionEdit

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.

Additional informationEdit

Progress of importEdit

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:

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 historyEdit

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!

DateDescriptionMethodPropertyQualifiersReferencesStatements addedStatements removedLink to import sheet
22 March 2020Import 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.QuickStatementsGNIS ID (P590)
  • stated in (P248)
  • 2500

    Discussion of importEdit

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

    Wikidata item for datasetEdit

    Import data into spreadsheetEdit

    Format the spreadsheet to import the dataEdit

    Structure of data within WikidataEdit

    Field nameWikidata propertyNotes
    Name1Property1Notes1
    Name2Property2Notes2
    Name3Property3Notes3

    Match the dataset to WikidataEdit

    Importing data into WikidataEdit

    • 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.

    Import completion notesEdit

    VisualisationsEdit

    Maintainance queries and expected resultsEdit

    Query linkDescriptionExpected results
    Link1Property1Notes1
    Link2Property2Notes2
    Link3Property3Notes3