Wikidata:Dataset Imports/USDA Plant Hardiness Zones

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

• 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

• 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

USDA Plant Hardiness Zones

Source

United States Department of Agriculture

Link

https://planthardiness.ars.usda.gov/PHZMWeb/Default.aspx

Dataset description

I am putting together the claims for location “hardiness zone” (P8194) based on the zipcodes of US cities.

Additional information

I am happy to create a spreadsheet or any other format that is helpful. I will look at maybe a main claim of the location “hardiness zone” P8194, and maybe a zipcode qualifier, to help when there are multiple zones for a city.

Hm, it isn't clear to me how to format the spreadsheet. I have the QID of a city, and I used its zipcode claims to generate the planting zone QID. I see a main claim for the hardiness zone, and ideally there would be a qualifier for the zipcode, since many cities have more than one zipcode. For example, NYC has the QID Q60 and the zipcode 11004, which puts it in the hardiness zone 7b, whose QID is Q96279219.
Q60, P8194, Q96279219

P281, 11004

However, this usage doesn't fit the property constraints on postal code (P281).

Progress of import

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 dataset	Import data into spreadsheet	Format the spreadsheet to import the data	Structure of data within Wikidata	Match the dataset to Wikidata	Importing data into Wikidata	Visualisations	Maintainance queries and expected results
USDA Plant Hardiness Zone (Q93321771)	https://lite.framacalc.org/9j5d-usda-hardiness-zones-jdc	help needed: how to name columns for qualifiers?	Not done yet	Not done yet	Not done yet	Not done yet	Not done yet

Edit history

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.

Date	Description	Method	Properties	Qualifiers	References	Statements added	Statements removed	Link to import sheet
Date 1	Description 1	Method 1	Properties 1	Qualifiers 1	References 1	Added Count 1	Removed Count 1	Link 1
Date 2	Description 2	Method 2	Properties 2	Qualifiers 2	References 2	Added Count 2	Removed Count 2	Link 2
Date 3	Description 3	Method 3	Properties 3	Qualifiers 3	References 3	Added Count 3	Removed Count 3	Link 3

Discussion of import

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

Import data into spreadsheet

https://lite.framacalc.org/9j5d-usda-hardiness-zones-jdc

The spreadsheet I am currently trying to make conform to the import format

Structure of data within Wikidata

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

Maintenance

Queries and expected results

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