Short version: In QGIS, use the Create grid layer function in the MMQGIS plugin to create the hexbins. Then import this layer into PostGIS and use the ST_Contains function to join your points spatially to the hexbins. Voilà.
Google Summer of Code 2015 is coming to an end today. I’ve been mentoring Deepak over the summer, who built an awesome prototype to bring the enviroCar data into the LOD cloud.
If you were always wondering how machine learning works, but didn’t dare to ask.
This protection is important for everyone. It’s easy to see how encryption protects journalists, human rights defenders, and political activists in authoritarian countries. But encryption protects the rest of us as well. It protects our data from criminals. It protects it from competitors, neighbors, and family members. It protects it from malicious attackers, and it protects it from accidents.
I’ll be mentoring Deepak Nair over the summer through Google’s Summer of Code program. He will finally add a full-fledged Linked Open Data layer to enviroCar, including a SPARQL endpoint and automatic interlinking with external data sources.
Very neat trick to execute SQL queries against a PostGreSQL (or PostGIS, as in my case) database directly from Sublime Text. Now I just need to figure out how to automatically refresh the results file in Sublime after a query.
So, you could imagine instead of leaving your phone to do nothing overnight you could instead leave it to record 8 hours of drift data. We’d anonymize it and record drift information just for the nearest 100 mile square or something so we don’t know where your house is. Then we could aggregate that data with other phones across the world and see if we get something that looks accurate out of it.