Picking this topic up from the last post, I focused on enriching the data released. This will allow further exploration of this data.
Lets use our previous schema as our starting point. The previous post produced a good starting point for the task at hand. The records from the previous post were stored in a table as shown in Figure 1.
Figure 1 – License plate table readings.
Browsing Hacker News, I recently found out about the City of Oakland releasing almost 3 million records of license plate reader data. The conversation there is way better than any blurb I could come up with. However, this is a neat opportunity to mine this data as an academic exercise.
From the source, they are hosting a list of CSV files with various bits of information. Common to all files, and of critical importance is the date and time of the tag reading and the latitude and longitude of each reading. Supplemental information as the site of the reading and source of such is often given as well. Most worrisome is the fact that the data has not been cleansed and includes the actual license tag for each reading instead of some ID. This would be the first thing to go after for data to be re-shared and used here. Continue reading
This is good news. Windows Live Writer, my blog editor of choice, is now open source! Rechristened Open Live Writer, it has moved to the .NET Foundation briskly as a 0.5 version… I want to imagine this is to prevent its death in a closet at Microsoft but you can read all the details at the release instead.
It has been on life support for about 3 years and its still one of the very few Windows must installs for me. Some highlights include best offline post writing available and seamless integration with WordPress. It will be refreshing to see
Live Writer Open Live Writer be further developed after so long. Neat.
In search for public (and fast and low cost) geocoding services, I’ve run into Texas A&M GeoServices.
I have only tested their reverse geocoding service and it was all of the three above. It took no more than a cup of coffee to provide addresses given latitude and longitude and information added looks very promising.
They even have a partnering program that could minimize the expense of using said service. Neat! Expect upcoming posts to attribute all geo data to them as so:
Geo-stuff provided by Texas A&M University GeoServices
What a blast. Thanks to everyone single one of the volunteers and staff at the Orlando Science Center for pulling this off. Amazing.
As promised, here’s the Plantstation slides. That little gear on the lower left allows you to download a copy, enjoy. Feel free to contact with questions, if any, and I’ll do my best to help you out.
This is the third time Maker Faire is in Orlando and looks to be bigger and better and, best, my son and I have an exhibit on the third floor of the Orlando Science Center! We are doing our first arduino project, Plantstation. Come check us out!
Plantstation details coming soon after the show.
A side effect of setting up your own VMWare lab is that, after all is said and done, you end up with a little furnace in a closet. With Orlando weather, this is mostly unnecessary.
Having recently setup the ELK stack to monitor this VM, I searched for the string ‘temperature’ not knowing what I would find.
Bingo, the image above clearly shows temperature warnings from the three hard drives in VM.