Department of Agriculture

http://www.usda.gov/wps/portal/usda/usdahome

Enterprise Data Inventory - Volume and composition over time

M-13-13 Milestone 6 - February 28th 2015

OMB Review Complete: OMB has completed the agency review for this milestone. Agencies should contact their OMB desk officer if anything looks incorrect.

Selected: M-13-13 Milestone 6 - February 28th 2015

Leading Indicators

These indicators are reviewed by the Office of Management and Budget

Review Status	complete
Reviewer	Jamie Berryhill
Last Updated	July 13, 2015, 10:54 pm EDT by Rebecca Williams

Assessment Summary

EDI: 651 datasets, but a the Google search for .csv, .xml, .json, and similar formats produces 128,000 results.

Public Engagement: BEST PRACTICE: USDA provides several transparent methods for 2-way customer feedback and communication, as described at http://www.usda.gov/wps/portal/usda/usdahome?navid=DIGITALSTRATEGY, including a GitHub site.

Note: The doughnut charts for Inventory Composition, Public Dataset Status, and Dataset Link Quality are new for this milestone, and they only appear is data are available. For detailed documentation on these charts, please see http://labs.data.gov/dashboard/docs#doughnut_charts. The "Other" category includes URLs that did not provide a response within 5 seconds of the automated crawl, which may indicate a server issue and not necessarily a completely non-working link.

Lasted edited on April 17, 2015, 1:16 pm EDT by Jamie Berryhill

Inventory Composition

Public Dataset Status

Dataset Link Quality

	Status	Indicator
	Overall Progress this Milestone
	Inventory Updated this Quarter
651	Number of Datasets
61	Number of APIs
	Schedule Delivered	Crawl details
18	Bureaus represented
28/60	Programs represented
503	Number of public datasets
3	Number of restricted public datasets
145	Number of non-public datasets
	Inventory > Public listing
0.9	Percentage growth in records since last quarter
128000	Spot Check - datasets listed by search engine
	Agency provides a public Enterprise Data Inventory on Data.gov
	License specified	Crawl details

	Status	Indicator
	Overall Progress this Milestone
505	Number of Datasets	Crawl details
	Number of Collections	Crawl details
496	Number of Public Datasets with File Downloads	Crawl details
	Number of APIs	Crawl details
630	Total number of access and download links	Crawl details
	Quality Check: Links are sufficiently working	Crawl details
527	Quality Check: Accessible links	Crawl details
64	Quality Check: Redirected links	Crawl details
8	Quality Check: Error links	Crawl details
	Quality Check: Broken links	Crawl details
1.2	Percentage growth in records since last quarter
100	Valid Metadata	Crawl details
	/data exists	Crawl details
	/data.json	Crawl details
	Harvested by data.gov
19,835	Views on data.gov for the quarter

Best Practice: Department of Agriculture has been highlighted for demonstrating a best practice on the Public Engagement indicator

	Status	Indicator
	Overall Progress this Milestone
	Description of feedback mechanism delivered	Crawl details
	Data release is prioritized through public engagement
	Feedback loop is closed, 2 way communication
See below	Link to or description of Feedback Mechanism
http://www.usda.gov/wps/portal/usda/usdahome?navid=DIGITALSTRATEGY

	Status	Indicator	Automated Metrics
	Overall Progress this Milestone
	Data Publication Process Delivered	Crawl details
	Information that should not to be made public is documented with agency's OGC

	Status	Indicator	Automated Metrics
	Overall Progress this Milestone
See below	Open Data Primary Point of Contact
bobby.jones@ocio.usda.gov
	POCs identified for required responsibilities

	Status	Indicator	Automated Metrics
	Overall Progress this Milestone
	Identified 5 data improvements for this quarter
See below	Primary Uses
USDA data has been used to give app developers and designers direct access to the wealth of farmer’s market information housed in the online database. It has also been used by exporters/importers, Foreign Agricultural Service (FAS) staff, and other government agencies to assess how competitive a product will be in a market as a result of applied import tariffs. In addition, it is used to detect climate variability and change information for cereal crop producers.
See below	Value or impact of data
The value of supplying USDA data has significantly reduced the time to research pertinent data for major projects and entrepreneur solutions. It has fostered a “build once use multiple times” atmosphere by eliminating the cost of reproducing data that already exist. It has helped to reduce the time-to-market on many products and services. It has provided researchers with the ability to partner with other federal agencies, industries and academia partners to produce maps, tables, charts and other useful artifacts to conduct predictive analysis on their crop yield and soil conditions.
See below	Primary data discovery channels
The value of supplying USDA data has significantly reduced the time to research pertinent data for major projects and entrepreneur solutions. It has fostered a “build once use multiple times” atmosphere by eliminating the cost of reproducing data that already exist. It has helped to reduce the time-to-market on many products and services. It has provided researchers with the ability to partner with other federal agencies, industries and academia partners to produce maps, tables, charts and other useful artifacts to conduct predictive analysis on their crop yield and soil conditions.
See below	User suggestions on improving data usability
The value of supplying USDA data has significantly reduced the time to research pertinent data for major projects and entrepreneur solutions. It has fostered a “build once use multiple times” atmosphere by eliminating the cost of reproducing data that already exist. It has helped to reduce the time-to-market on many products and services. It has provided researchers with the ability to partner with other federal agencies, industries and academia partners to produce maps, tables, charts and other useful artifacts to conduct predictive analysis on their crop yield and soil conditions.
See below	User suggestions on additional data releases
Key users have requested climate data and disaster relief data. USDA is also taking an aggressive approach in providing administrative data per OMB’s M-14-06. In addition, Farmers, Ranchers and Equipment Manufactures have requested a need for Common Land Unit Data to be more accessible.
	Digital Analytics Program on /data

Automated Metrics

These metrics are generated by an automated analysis that runs every 24 hours until the end of the quarter at which point they become a historical snapshot

data.json

Expected Data.json URL	http://www.usda.gov/data.json (From USA.gov Directory)
Resolved Data.json URL	http://www.usda.gov/data.json
Number of Redirects
HTTP Status	200
Content Type	text/plain
Valid JSON	Valid
Detected Data.json Schema	federal-v1.1
Datasets with Valid Metadata	100%(505 of 505)
Valid Schema	Valid
Datasets	505
Datasets with Distribution URLs	0.0% (0 of 505)
Total Distribution URLs	0
Public Datasets	502
Restricted Public Datasets	3
Non-public Datasets	0
Normally there would be a set of quality assurance fields here to verify that the download links included within the metadata are functioning properly, but the results of those tests are not currently available.
Bureaus Represented	18
Programs Represented	28
File Size	882.31KB
Last modified	Friday, 27-Feb-2015 10:09:35 EST
Last crawl	Friday, 27-Feb-2015 23:00:36 EST
Analyze archive copies	Analyze archive from 2015-02-28

/data page

Expected /data URL	http://www.usda.gov/data (From USA.gov Directory)
Resolved /data URL	http://www.usda.gov/wps/portal/usda/usdahome?navid=data
Redirects	1 redirects
HTTP Status	200
Content Type	text/html; charset=UTF-8
Last crawl	Friday, 27-Feb-2015 23:00:36 EST

/digitalstrategy.json

Expected /digitalstrategy.json URL	http://www.usda.gov/digitalstrategy.json (From USA.gov Directory)
Resolved /digitalstrategy.json URL	http://www.usda.gov/digitalstrategy.json
Redirects
HTTP Status	200
Content Type	text/plain
Valid JSON	Valid
Last modified	Thursday, 20-Feb-2014 14:57:02 EST
Last crawl	Friday, 27-Feb-2015 23:00:37 EST

Digital Strategy

Date specified: Wednesday, 11-Dec-2013 06:42:19 EST

Date of digitalstrategy.json file: Thursday, 20-Feb-2014 14:57:02 EST

1.2.4 Develop Data Inventory Schedule - Summary

Summarize the Inventory Schedule

Over the past several months, the USDA has focused its Open Data efforts on establishing a framework to enhance, enrich, and open, to the extent practicable, its Enterprise Data Inventory (EDI) and to ensure the Department and its component Agencies are prepared to identify,
correctly document, and submit to the Office of Management and Budget (OMB) on November 30, 2014 a comprehensive EDI. In so doing, the USDA has already achieved several internal milestones that lay the groundwork for the Department's future Open Data efforts and position the USDA to meet OMB's Open Data requirements. The following milestones are among the Department's recent Open Data achievements:

1.2.5 Develop Data Inventory Schedule - Milestones

Title	Milestone 1 - Expand and Open EDI
Description
Milestone Date	February 28, 2014
Description of how this milestone expands the Inventory	The USDA will initially focus on expanding and opening its Enterprise Data Inventory. To this end, the Open Data Council, in collaboration with Agency CIOs, Data Stewards, and the Open Data Working Group (ODWG), will continue to work with the USDA's Privacy Officers to identify, prioritize and submit additional public, non-public, and restricted-public datasets to the Department. In addition, the ODC and ODWG will continue the development of an Open Data process and guidance that expedite the publication of its datasets in the future. At the end of Q1, the USDA will submit an updated EDI to OMB.
Description of how this milestone enriches the Inventory
Description of how this milestone opens the Inventory

Title	Milestone 2 - Enrich EDI and Public Datasets
Description
Milestone Date	May 31, 2014
Description of how this milestone expands the Inventory	Over the second quarter, from February 28 to May 31, the USDA and its component agencies will continue to input into its EDI additional datasets. The Department will also continue to collaborate with its Data Stewards to update its customer feedback and outreach efforts. At the end of Q2, the USDA will submit an updated EDI to OMB.
Description of how this milestone enriches the Inventory
Description of how this milestone opens the Inventory

Title	Milestone 3 - Expand, Enrich, and Open EDI
Description
Milestone Date	August 30, 2014
Description of how this milestone expands the Inventory	In the third quarter of the Open Data effort, the USDA will review and analyze its current dataset inventory, publication process, and customer feedback mechanisms. The results of the analysis will inform whether the Department needs to adjust its Open Data strategy and will help the Department prioritize the submission and release of its datasets in Q4. At the end of Q3, the USDA will submit an updated EDI to OMB.
Description of how this milestone enriches the Inventory
Description of how this milestone opens the Inventory

Title	Milestone 4 - Perform Quality Assurance and Submit Complete EDI to OMB
Description
Milestone Date	November 1, 2014
Description of how this milestone expands the Inventory	Customer Feedback
Description of how this milestone enriches the Inventory
Description of how this milestone opens the Inventory

1.2.6 Develop Customer Feedback Process

Describe the agency's process to engage with customers

1.2.7 Develop Data Publication Process

Describe the agency's data publication process

The Department of Agriculture (USDA) implemented a four step data publication process.* This multi-step dataset review process involves multiple internal stakeholders such as Data Stewards, Chief Information Officers, Privacy Officers, agency legal staff, and Information Security System Program Managers, Records Managers, and Controlled Unclassified Information managers. The purpose of this multi-perspective approach is to ensure that datasets are adequately reviewed and approved prior to release.