The state’s new data site is here, and from my initial test drive, it’s pretty good.
The data portal is something that I called for in a post last year, so it’s nice to see it come to fruition. With the launch, Oklahoma joins dozens of other states and countries with a central data archive.
The site was made possible by legislation that came out of the 2010 Legislature. Senate Bill 1759, by Sen. Anthony Sykes, R-Moore, and Rep. Jason Murphey, R-Guthrie, set up the framework and requirements for the data site.
Oklahoma’s site uses the Socrata data engine, which allows for customizable data visualizations, maps and data downloads.
For example, this morning I downloaded the state’s 4th Quarter payroll. I wanted to take a look at overtime payments, so after downloading a type of file called a .csv (for comma-separated value), I was able to import the data into Microsoft Access. That task took fewer than 10 minutes.
The 28.5 MB payroll file has more than 266,000 records from the 4th quarter. You could also import the information to the new versions of Microsoft Excel spreadsheet, which allow for up to 1 million records (the older versions of Excel limit you to 65,000 records in a worksheet).
Just browsing the data sets on the site works well, too. Here’s a Google Map of fire stations in Oklahoma:
I’ll have more on the site in future posts, but it’s looking good so far. Take the site for a spin yourself and let me know what you think in the comments section below.
- A call for data.ok.gov
- Open data legislation fails in the Oklahoma House
- Government 2.0 conference in OKC
Written by Paul Monies