際際滷

際際滷Share a Scribd company logo
HACKING THE PAST 
Opening analogue government data sets
The State Records Office of WA 
is responsible for ensuring good 
recordkeeping across 
government, and for preserving, 
maintaining and making 
accessible State archives 
(records of continuing value)
Hacking the past: opening analogue government data sets
The GovHack experience
First Lesson  our data is not easy to find or use, even when it is on a platter.
Second lesson  some platters are better than others
GovHack 2014
GovHack 2015?
Hacking the past: opening analogue government data sets
Beyond GovHack

More Related Content

Recently uploaded (20)

ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptxONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
manisha220598
What is Rent Control? Stabilizing the Debate
What is Rent Control? Stabilizing the DebateWhat is Rent Control? Stabilizing the Debate
What is Rent Control? Stabilizing the Debate
mitch348117
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptxTrends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
papersubmitsirtoto
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Energy for One World
Output 9 - For BJMP Training Session.pptx
Output 9 - For BJMP Training Session.pptxOutput 9 - For BJMP Training Session.pptx
Output 9 - For BJMP Training Session.pptx
otthonrpolisis
PPT SPELLING BEE palabras para realizar concurso
PPT SPELLING BEE palabras para realizar concursoPPT SPELLING BEE palabras para realizar concurso
PPT SPELLING BEE palabras para realizar concurso
stfanooorigin
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoaThuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
thatlaquachan34
Meet Dr. Charles Chima from Sioux Falls, SD
Meet Dr. Charles Chima from Sioux Falls, SDMeet Dr. Charles Chima from Sioux Falls, SD
Meet Dr. Charles Chima from Sioux Falls, SD
Charles Chima
BCKIC Magazine 2024 _ Volume 1 for Linkedin
BCKIC Magazine 2024 _ Volume 1 for LinkedinBCKIC Magazine 2024 _ Volume 1 for Linkedin
BCKIC Magazine 2024 _ Volume 1 for Linkedin
someshkumar799029
15. Discussion Prompts - World Caf辿 on Just Transitions.pdf
15. Discussion Prompts - World Caf辿 on Just Transitions.pdf15. Discussion Prompts - World Caf辿 on Just Transitions.pdf
15. Discussion Prompts - World Caf辿 on Just Transitions.pdf
Just Energy Transition in Coal Regions Knowledge Hub
the_challenges_of_intraregional_migration_flow.pptx
the_challenges_of_intraregional_migration_flow.pptxthe_challenges_of_intraregional_migration_flow.pptx
the_challenges_of_intraregional_migration_flow.pptx
coolprasanna
Digital transformation of social support in Ukraine
Digital transformation of social support in UkraineDigital transformation of social support in Ukraine
Digital transformation of social support in Ukraine
Konstantin Koshelenko
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade BarriersTrump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Energy for One World
Plan India Children Literary Festival.pptx
Plan India Children Literary Festival.pptxPlan India Children Literary Festival.pptx
Plan India Children Literary Festival.pptx
planindia.org
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdf
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdfMinimalist Beauty Skin Care Ebook Product Guide PDF.pdf
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdf
desiexperiences3
TRICARER choice brief and introducation.pptx
TRICARER choice brief and introducation.pptxTRICARER choice brief and introducation.pptx
TRICARER choice brief and introducation.pptx
Serahuang2
AIHA Grand-Challenges-Overview_2025.pptx
AIHA Grand-Challenges-Overview_2025.pptxAIHA Grand-Challenges-Overview_2025.pptx
AIHA Grand-Challenges-Overview_2025.pptx
AIHA
Dr. Oetker ppt present ation of iar and no
Dr. Oetker ppt present ation of iar and noDr. Oetker ppt present ation of iar and no
Dr. Oetker ppt present ation of iar and no
dkyadav8271
Science Update - No 377 - April 2025.pdf
Science Update - No 377 - April 2025.pdfScience Update - No 377 - April 2025.pdf
Science Update - No 377 - April 2025.pdf
DOILibrary1151
PAS nature emergency event for councillors
PAS nature emergency event for councillorsPAS nature emergency event for councillors
PAS nature emergency event for councillors
PAS_Team
ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptxONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
ONE STATION ONE PRODUCT OSOP INDIAN RAILWATYS.pptx
manisha220598
What is Rent Control? Stabilizing the Debate
What is Rent Control? Stabilizing the DebateWhat is Rent Control? Stabilizing the Debate
What is Rent Control? Stabilizing the Debate
mitch348117
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptxTrends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
Trends-in-Rural-Development (1).pptx Trends-in-Rural-Development (1).pptx
papersubmitsirtoto
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Briefing Document Energy For One World (EFOW) and Mission Energy For One Worl...
Energy for One World
Output 9 - For BJMP Training Session.pptx
Output 9 - For BJMP Training Session.pptxOutput 9 - For BJMP Training Session.pptx
Output 9 - For BJMP Training Session.pptx
otthonrpolisis
PPT SPELLING BEE palabras para realizar concurso
PPT SPELLING BEE palabras para realizar concursoPPT SPELLING BEE palabras para realizar concurso
PPT SPELLING BEE palabras para realizar concurso
stfanooorigin
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoaThuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
Thuy畉t tr狸nh T動 t動畛ng H畛 CH MINH 畉i h畛c B叩ch khoa
thatlaquachan34
Meet Dr. Charles Chima from Sioux Falls, SD
Meet Dr. Charles Chima from Sioux Falls, SDMeet Dr. Charles Chima from Sioux Falls, SD
Meet Dr. Charles Chima from Sioux Falls, SD
Charles Chima
BCKIC Magazine 2024 _ Volume 1 for Linkedin
BCKIC Magazine 2024 _ Volume 1 for LinkedinBCKIC Magazine 2024 _ Volume 1 for Linkedin
BCKIC Magazine 2024 _ Volume 1 for Linkedin
someshkumar799029
the_challenges_of_intraregional_migration_flow.pptx
the_challenges_of_intraregional_migration_flow.pptxthe_challenges_of_intraregional_migration_flow.pptx
the_challenges_of_intraregional_migration_flow.pptx
coolprasanna
Digital transformation of social support in Ukraine
Digital transformation of social support in UkraineDigital transformation of social support in Ukraine
Digital transformation of social support in Ukraine
Konstantin Koshelenko
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade BarriersTrump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Trump 2.0 Liberation Day: Trade Tariffs, Report on Trade Barriers
Energy for One World
Plan India Children Literary Festival.pptx
Plan India Children Literary Festival.pptxPlan India Children Literary Festival.pptx
Plan India Children Literary Festival.pptx
planindia.org
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdf
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdfMinimalist Beauty Skin Care Ebook Product Guide PDF.pdf
Minimalist Beauty Skin Care Ebook Product Guide PDF.pdf
desiexperiences3
TRICARER choice brief and introducation.pptx
TRICARER choice brief and introducation.pptxTRICARER choice brief and introducation.pptx
TRICARER choice brief and introducation.pptx
Serahuang2
AIHA Grand-Challenges-Overview_2025.pptx
AIHA Grand-Challenges-Overview_2025.pptxAIHA Grand-Challenges-Overview_2025.pptx
AIHA Grand-Challenges-Overview_2025.pptx
AIHA
Dr. Oetker ppt present ation of iar and no
Dr. Oetker ppt present ation of iar and noDr. Oetker ppt present ation of iar and no
Dr. Oetker ppt present ation of iar and no
dkyadav8271
Science Update - No 377 - April 2025.pdf
Science Update - No 377 - April 2025.pdfScience Update - No 377 - April 2025.pdf
Science Update - No 377 - April 2025.pdf
DOILibrary1151
PAS nature emergency event for councillors
PAS nature emergency event for councillorsPAS nature emergency event for councillors
PAS nature emergency event for councillors
PAS_Team

Featured (20)

Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
OECD Directorate for Financial and Enterprise Affairs
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
Skeleton Culture Code
Skeleton Culture CodeSkeleton Culture Code
Skeleton Culture Code
Skeleton Technologies
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray
How to have difficult conversations
How to have difficult conversations How to have difficult conversations
How to have difficult conversations
Rajiv Jayarajah, MAppComm, ACC
Introduction to Data Science
Introduction to Data ScienceIntroduction to Data Science
Introduction to Data Science
Christy Abraham Joy
Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray

Hacking the past: opening analogue government data sets

Editor's Notes

  • #4: We hold a range of information types and formats, from files and Executive Council minutes, to maps and plans, photographs, and local government ratebooks.
  • #5: We went to GovHack 2013, the first in Perth, simply because we thought that making our data available would be a useful thing for us to do, and to find out what the issues might be. We went armed with a 1TB hard drive on which we had added a range of digitised resources, and some excel spreadsheets
  • #6: We ran into format problems immediately pdfs of spreadsheets, spreadsheets that had been converted from Mac to word and then to excel, even the jpgs of plans werent that easy to import in bulk.
  • #7: In GovHack 2013, at least three teams used the TROVE api to find their datasets, including the team from Pixtory, who went to TROVE to find WA photos from the SLWA collections.
  • #8: This year, the information was sorted into folders, and where indexes existed, they were hyperlinked. Files were available in .csv format or .excel, and images were identified by information content in way that linked back to our main catalogue. The result? Some of our images were used for an app for school history, which was encouraging.
  • #9: What did we expect from GovHack not sure. However, something like geolocation of our maps or files would have been fantastic, or an app or game that used them more interactively. Some modelling or data visualisation, not just of the information on the website, but drawn from our catalogue? Or even a transcription of our fieldbooks. We also need to look at the datasets we manage, and are aware of government organisations are required to tell us what major data sets they hold.
  • #11: What did we expect from GovHack not sure. However, something like geolocation of our maps or files would have been fantastic, or an app or game that used them more interactively. Some modelling or data visualisation, not just of the information on the website, but drawn from our catalogue? Or even a transcription of our fieldbooks. We also need to look at the datasets we manage, and are aware of government organisations are required to tell us what major data sets they hold. Clearly, the projects shown here are much bigger than a single weekend, but they demonstrate the sort of work into which government data sets can be integrated. We hope that our new catalogue will also make it easier to extract and use data.