Wikidata

Wikidata:Dataset Imports/A list of all 2020 Census Urban Areas for the U.S., Puerto Rico, and Island Areas sorted by Urban Area Census (UACE) code

< Wikidata:Dataset Imports

You may find these related resources helpful:


Guidelines for using this page

edit

Documenting the import

edit
  • 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.
  • It is strongly recommended to use Visual Editor when making changes to this page, particularly for editing any of the tables.

Creating a Wikidata item for the dataset

edit
  • Please create a Wikidata item for the dataset, this will allow us to improve the coverage of datasets on Wikidata and understand what datasets are available on that topic and which of them have been added to Wikidata.
  • If you are working with very large dataset you can break it into smaller Mix n' Match catalogues, but only create one Wikidata item.
  • Link the dataset Wikidata item to this page using Wikidata Dataset Imports URL (P5195)

Getting help

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

edit

Dataset name

edit

A list of all 2020 Census Urban Areas for the U.S., Puerto Rico, and Island Areas sorted by Urban Area Census (UACE) code

Source

edit

United States Census Bureau

edit

https://www.census.gov/programs-surveys/geography/guidance/geo-areas/urban-rural.html

Dataset description

edit

A spreadsheet of all the urban area (Q5951278) in the 2000 United States census

Additional information

edit

Source is represented by List of 2020 Census Urban Areas (Q125694883). The UACE codes currently lack a dedicated property; this proposal would create one.

Progress of import

edit

The table below is used to track the progress of importing this dataset. The suggested column headings are most applicable to data being imported from a spreadsheet - you can change some column headings or add new columns as required to best describe the progress of this import.

Wikidata item for the datasetImport data into spreadsheetFormat the spreadsheet to import the dataStructure of data within WikidataMatch the dataset to WikidataImporting data into WikidataVisualisationsMaintainance queries and expected results
List of 2020 Census Urban Areas (Q125694883)DoneDoneDone DoneUnderwayNot done yetNot done yet

Edit history

edit

Use the table below 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.

DateDescriptionMethodItems addedStatements addedStatements removed
2024-05-06Abbeville to Crescent CityOpen Refine + QuickStatements559
2024-05-06Cresson to IrvineOpen Refine + QuickStatements562
2024-05-06Isanti to New Philadelphia–DoverOpen Refine + QuickStatements557
2024-05-06Newport to Olympia–LaceyOpen Refine + QuickStatements56
2024-05-06Omaha to SuffolkOpen Refine + QuickStatements558
2024-05-06Sugarmill Woods to ZimmermanOpen Refine + QuickStatements350
2024-05-06Links from places and CBSAsOpen Refine + QuickStatements03342
2024-05-06Coordinates of urban areasOpen Refine + QuickStatements02643

Discussion of import

edit

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

Format the spreadsheet to import the data

edit

Structure of data within Wikidata

edit
Field nameWikidata propertyNotes
UACEurban area census code
NAMEofficial name (P1448)

located in the administrative territorial entity (P131) territory overlaps (P3179) named after (P138)

POPpopulation (P1082)
HOUSINGnumber of housing units (P10814)
AREALANDarea (P2046)Add AREAWATER
AREAWATERwater area (P8887)

Match the dataset to Wikidata

edit

Importing data into Wikidata

edit

Import completion notes

edit

Visualisations

edit

Maintenance

edit

Queries and expected results

edit
Query linkDescriptionExpected results
Link1Property1Notes1
Link2Property2Notes2
Link3Property3Notes3

Schedule of new data released

edit
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:Dataset_Imports/A_list_of_all_2020_Census_Urban_Areas_for_the_U.S.,_Puerto_Rico,_and_Island_Areas_sorted_by_Urban_Area_Census_(UACE)_code&oldid=2147416070"