So I’ve been playing with Leaflet a lot lately. It’s become my lightweight mapping library of choice. There’s a lot it doesn’t do so I keep OpenLayers and others in the rotation as well but Leaflet is direct and to the point so I use it when I can.
A while back, I posted about some experimentation I did with Leaflet and CartoDB in the wake of FOSS4G in Denver. I recently had the chance to go back and update that sample with some spatial queries. At the time of the original post, CartoDB was still in beta and spatial queries didn’t seem to work, despite the fact that the back-end was driven by PostGIS.
One of the biggest sources of buzz at FOSS4G was CartoDB. It is a hosted solution from Vizzuality that uses PostGIS to allow you to store your spatial data online. I got a beta account a couple of weeks ago but life (i.e. paying work) kept getting in the way but I finally got to play with it recently.
One of the things that intrigued me is that, similar to Google Fusion Tables, CartoDB exposes a SQL interface through a RESTful API (I’m still not sure if the term “API” applies to REST but it’s a convenient shorthand). Essentially, CartoDB exposes PostgreSQL SQL and the spatial SQL extensions of PostGIS. Once your data is loaded, you can query it and return the results as either CartoDB’s JSON syntax, KML or GeoJSON.
Note: The application described in this post is running here. It requires Silverlight 4.
I was perusing my LinkedIn connections and noticed that quite a few had PMP certifications. I also noticed that most of those who did seemed to be in the Washington, DC area. Of course, given that I live in that region, my sample could be a bit skewed but then I started thinking out loud (via Twitter):
I would love to see a heat map showing concentrations of PMPs. I bet the DC area would be white-hot. I suspect others not so much.
Overview of StatCounter.com “Recent Visitor Map” feature.
This probably old news but I’m pretty impressed by it. I’m referring to the recent visitor map on StatCounter.com. We do a lot of web development where I work (both GIS and not) and I like to keep an eye on tools that may be useful in that area. StatCounter provides a free service that keeps track of who’s visiting a site. It can track IP, referring links, etc. It’s pretty standard stuff but their reporting tools are nice so I thought I’d check it out.
As for the web bug version I set up on my blog, I’ve been able to figure out that a couple of big system integrators (who act as their own ISP) are interested in SharpMap.
I find this tool to be an ideal application of the push-pin mapping concept.
Update: Here’s another example showing some of the specific interest generated by the “Death of ESRI” post (the IP address and host name have been blurred to protect the innocent):