October 2019 Data Snapshot
In the October 2019 data snapshot, you will find news, updates, tips and other relevant information to Iowa's data program including:
- What is Data Sharing?
- The Powerful Case Statement
- Getting Data
- Scheduling Data Updates
- Story Templates
- Data Asset Summary
- Data Resources Available
- State Data Plan
News, Updates & Tips
What is Data Sharing?
Data sharing is the act of preparing your agency data for use by someone else (i.e., another agency, citizen, researcher), and transmitting those data. Reuse happens when someone else uses the data collected and prepared by your agency.
Benefits of data sharing:
- New explorations of data can support wider conversations, provide new insights and generate new conclusions.
- Allows others to replicate and confirm existing findings - builds trust.
- Reduces data collection costs, and minimizes duplication of effort.
Constraints of data sharing:
- Privacy and confidentiality - deidentification or anonymization is not fool proof, and data use agreements can be time consuming.
- Cultural - data sharing can feel like giving your work away, and give rise to concerns regarding misuse.
We have the infrastructure in place to make data discoverable and accessible, which are key to data sharing. However, do your data assets support reuse? More on that next month.
The Powerful Case Statement
Many times, datasets contain values that are not very meaningful to individuals outside of government and the agency publishing the data needs it changed to something more friendly to users accessing the data. Other times, you may want to derive a new column based on values in an existing column within your dataset. Having the ability to run data transforms on a dataset gives you the tools you need, but where to start? Enter the case statement. A case statement evaluates a series of values and will return a new value if it is true (e.g, if 9, return Ninth Grade). Got it? If not, don't worry - we have you covered. We have a tool that will create a case statement for you. You only need to supply the values. You can access this tool via the link below, or among our other playbooks.
Ever wanted to add text or numeric data published in another dataset or filtered view into your own dataset? Is there another asset that provides reference information you need, or are you using the assest to help support datat integrity? To get started, just add a column in your dataset, and use this tool to create a transform that will search the data asset for records containing matching values and will return the data value you are interested in. You can access this tool via link below, or among our other playbooks.
Scheduling Data Updates
The Socrata Data Management Experience provides the ability to schedule data updates for datasets that were created by importing from a URL and datasets that are connected through Socrata Gateway. With recent improvements, users can now manually run schedules that have been created via the UI rather than waiting until the next scheduled run time. Read the following help article to learn more.
It is now possible to create new Stories based on new templates designed to meet your needs for Dashboards, Reporting, and more! Templates pre-populate your new Story page with organized content blocks and headers, helping you ensure consistent and professional presentation as you create new Story pages for your domain. Once you choose a template, its content can be interacted with just as flexibly as a normal custom Story layout. Read the following support article to learn more.
The table below reports the number data assets published on the state data portal by asset type and pulic status for the portal as a whole.
|Data Asset Type||Public Assets||Private Assets||Total|
Access data assets available to you.
Total User Accounts: 136
Active Users: 24 (17.6% of total)
Note: Active Users have logged in the data portal at least once in the past month.
Questions or Issues?
Please complete the Data Portal Question & Issue Form
How do you like this Month's Snapshot?
|love it||meh||hate it|
Follow Us on Twitter
|Program Area|| |
|Fiscal Year|| |