Oakland License Plate Readings Database

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.

image1

Figure 1 – License plate table readings.

Continue reading

City Of Oakland Plate Reader Data

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

Windows Live Writer Has Been Open Sourced!

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.

Texas A&M GeoServices Partner Program

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

PC Case Fan Effectiveness Analysis

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.

Steady Stream Of Temperature Warnings

Bingo, the image above clearly shows temperature warnings from the three hard drives in VM.

Continue reading