First Look: data.ok.gov
The state’s new data site is here, and from my initial test drive, it’s pretty good.
The site, at http://data.ok.gov, was live last night, and although I’ve seen nothing official from the Office of State Finance or the governor’s office, the website Gov2.0 Radio reported the launch.
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.
–Paul
Related posts:
- A call for data.ok.gov
- Open data legislation fails in the Oklahoma House
- Government 2.0 conference in OKC
Written by Paul Monies
Follow @pmonies
Thank you for joining our conversation on Data Watch. We encourage your discussion but ask that you stay within the bounds of our commenting and posting policy.
Comments
I want information on government expenditures, but, putting payroll information is intrusive to the individuals
[...] Read more from the Data Watch blog at http://blog.newsok.com/datawatch/2011/02/09/first-look-data-ok-gov/. [...]
Thanks for getting this infomation out to the public. More Oklahoman’s need to pay attention where are tax dollars are going. We need more transparency in government at *all* levels.
I was wondering if you ever thought of changing the layout of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better? Thank you!
I’ve got a lots of bookmarked websites portion of Blogspot that I check daily for updates, however it is so annoying to click by way of a list. Only make an account perhaps there is some form of feature where I can tell new posts for the websites? (Type of like Subscriptions on Xanga)?.
It’s exhausting to seek out educated people on this subject, however you sound like you already know what you’re speaking about! Thanks
We’re a group of volunteers and opening a brand new scheme in our community. Your website offered us with valuable information to work on. You have performed an impressive task and our entire community can be thankful to you.
We’re a group of volunteers and starting a new scheme in our community. Your website provided us with valuable info to work on. You’ve done an impressive job and our whole community will be thankful to you.
Hmm is anyone else encountering problems with the pictures on this weblog loading? I’m trying to figure out if its a problem on my finish or if it is the blog. Any responses would be greatly appreciated.
Your article really spurred my interest and it’s also not an easy task to do. I enjoy the method that you made your distinct points. It’s persuasive content.
I used to be more than happy to seek out this net-site.I wished to thanks on your time for this glorious read!! I definitely enjoying every little little bit of it and I have you bookmarked to take a look at new stuff you weblog post.
It’s as if you read my mind! You appear to know much in regards to this, while you wrote the publication there something like that. I do believe you can apply with a bit of pictures to operate what it’s all about a little bit, but yet it’s this magnificent blog. A terrific read. I will definitely come back.
I used to be very happy to find this net-site.I wished to thanks on your time for this excellent learn!! I definitely enjoying every little bit of it and I’ve you bookmarked to check out new stuff you blog post.
My wife and i ended up being absolutely delighted that Raymond could do his web research using the ideas he gained in your web site. It’s not at all simplistic to simply continually be handing out information and facts that many people have been making money from. And now we do know we’ve got the website owner to appreciate for that. The main illustrations you’ve made, the easy site menu, the relationships you can make it possible to create – it is many wonderful, and it is leading our son in addition to our family reckon that this content is enjoyable, which is certainly unbelievably vital. Many thanks for everything!
Get Laid in Chicago
You can certainly see your skills in the work you write. The world hopes for more passionate writers such as you who are not afraid to say how they believe. At all times go after your heart.
Savings issues can occur to anybody and no-one is really safe and sound from them. They can be crisis bills like health bills or individuals with playing problems. It can be purchasing for your wife or occurring a holiday vacation. Individuals can practically never reside around there would mean and if they do they are certain to slip every couple many weeks.
Hi, I intended to create you the very little remark to help say thanks a lot the moment again for all the incredible suggestions you’ve provided above. It is simply shockingly open-handed with you to make unhampered precisely what many people would’ve advertised as an ebook to make some cash for their own end, certainly since you could possibly have tried it in the event you decided. The guidelines likewise served like a good way to be aware that some people have similar interest really like my very own to learn a lot more on the subject of this matter. Certainly there are a lot more enjoyable periods in the future for many who browse through your blog. Awesome, Cheers..
Hi, real appreciation for the great article and the information, it is really goodand helpful.Thankyou
10. Definitely believe that which you said. Your favorite reason appeared to be on the internet the easiest thing to be aware of. I say to you, I definitely get annoyed while people think about worries that they just do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks
Very good job on this article! I really like how you presented your facts and how you produced it fascinating and simple to comprehend. Thank you.
I was wondering if you ever considered changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?
Have you ever considered about including a little bit more than just your articles? I mean, what you say is valuable and all. Nevertheless imagine if you added some great visuals or videos to give your posts more, “pop”! Your content is excellent but with images and video clips, this site could definitely be one of the best in its niche. Awesome blog!
Have you ever considered creating an ebook or guest authoring on other blogs? I have a blog centered on the same subjects you discuss and would love to have you share some stories/information. I know my visitors would enjoy your work. If you are even remotely interested, feel free to shoot me an email.
Please let me know if you’re looking for a author for your weblog. You have some really good posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Cheers!
One thing I’d prefer to say is that before obtaining more laptop memory, check out the machine into which it is installed. In case the machine is definitely running Windows XP, for instance, the memory limit is 3.25GB. Putting in in excess of this would simply constitute any waste. Make sure one’s motherboard can handle the actual upgrade amount, as well. Interesting blog post.
I have observed that in video cameras, extraordinary sensors help to aim automatically. The sensors regarding some cams change in contrast, while others work with a beam associated with infra-red (IR) light, specifically in low lighting. Higher standards cameras often use a mixture of both models and will often have Face Priority AF where the video camera can ‘See’ some sort of face and concentrate only upon that. Thanks for sharing your notions on this blog.
The following time I learn a weblog, I hope that it doesnt disappoint me as much as this one. I imply, I do know it was my option to learn, but I really thought youd have something interesting to say. All I hear is a bunch of whining about one thing that you would repair should you werent too busy on the lookout for attention.
Excellent post, you have pointed out a bunch of good points, I likewise believe this is a very good website.
I am commenting to make you be aware of what a magnificent encounter my friend’s daughter encountered reading your site. She learned some pieces, which included what it is like to have an incredible teaching spirit to let a number of people smoothly know selected impossible issues. You really exceeded my expectations. Many thanks for producing those interesting, healthy, explanatory and in addition easy guidance on this topic to Ethel.
With havin so much content do you ever run into any problems of plagorism or copyright infringement? My site has a lot of unique content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all over the web without my authorization. Do you know any ways to help prevent content from being stolen? I’d truly appreciate it.
You should participate in a contest for the most effective blogs on the web. I will advocate this web site!Kind regards from Italy.
This is marvelous. Someone watch and this content articles so we are stupefied. We are most certainly fascinated by this sort of meals. Only one appreciate more opinion, and benefits your precious time with this. Please keep cutting. These are genuinely high-priced help and advice technique that will give your observer an incredibly clear out word.
This is very good. Human beings watch every comprise therefore we are taken aback. We’re curious about this sort of animals. Nutritionists appreciate your sexual effort, and number your precious time with this. Please keep enhancing. They are actually practical concepts session that could provide your gathering an extremely crystal clear report.
Hello there, just became alert to your blog through Google, and found that it’s truly informative. I am going to watch out for brussels. I’ll be grateful if you continue this in future. Lots of people will be benefited from your writing. Cheers!
Howdy I am so happy I found your site, I really found you by error, while I was looking on Askjeeve for something else, Nonetheless I am here now and would just like to say thanks a lot for a incredible post and a all round enjoyable blog (I also love the theme/design), I don’t have time to browse it all at the minute but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the excellent job.
Hi my loved one! I wish to say that this article is awesome, nice written and include approximately all vital infos. I would like to peer extra posts like this .
Thank you an incredible submit, may study one’s others content. thank you your thinking for this, I soon became somewhat made an impact to by this text. Many thanks again! You wanna make a terrific time. Got some fantastic info here. I do think that when a greater number of people thought about it like this, they’d have a very better moment in time receive the hold ofing the issue.
Awesome blog! Do you have any hints for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you advise starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally overwhelmed .. Any suggestions? Kudos!
magnificent issues altogether, you simply gained a emblem new reader. What could you recommend in regards to your put up that you simply made some days ago? Any certain? Rattling informative and good body structure of articles , now that’s user friendly (:.
good post about disaster recovery and i think there was some small things that you should pay attention on it 
The first line is made from raw materials from the Pacific Island of Mauritius in the Central Indian Ocean. The designs are unique, and elegant, and very “earthy”. They include necklaces, bracelets, and earrings.
[...] This post was mentioned on Twitter by NewsOK Politics, RR74 and Dustin Haisler, NewsOK.com–Watchdog. NewsOK.com–Watchdog said: First Look: data.ok.gov http://bit.ly/eWbboO #NewsOK #gov20 #transparency [...]