For various reasons, I can’t attend today’s inaugural FedGeoDay at the Woolly Mammoth Theatre in Washington, DC, though I’ll be watching the hashtag with great interest. Jack Flood of Arc2Earth, however, has already posted his slides to SlideShare:
While neither ArcMap nor Arc2Earth are open-source themselves, Jack points out that Arc2Earth acts as a bridge between ArcMap and several geospatial hosting platforms that are built on open-source technology but, also just as important, are successful at making data more openly available. These platforms include CartoDB and MapBox, among many others.
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.
It’s rather fitting that the second plenary talk on Wednesday had to do with “firehose” applications since the FOSS4G North America (FOSS4GNA) conference was something of a firehose in itself. Despite the fact that the event was smaller than the worldwide event in Denver back in October, I came away with the same “full brain” feeling.
Of course, given the recent production release of PostGIS 2.0, that was kind of the big story for this event. I attended a number of PostGIS/PostgreSQL-related sessions and came away with lots of new information. I especially enjoyed Paul Ramsey’s “what’s new” talk on Wednesday. One thing I enjoy about his talks (here and in Denver) is that he’s not afraid to throw sample SQL up on the screen. It’s one thing to hear about a new feature but it’s another thing entirely to see a concrete example. Some may find the idea of raw SQL in a presentation abhorrent but it worked for me.
Over on Google+ (and also on Twitter), Brian Flood announced the impending availability of Arc2Earth Sync Beta to existing Arc2Earth users. This has been brewing for for a while and Brian says it best:
“What makes Sync really cool is the live edit synchronization and the ability to publish online to different formats. It’s a great way to provide integration between ArcGIS desktops/online and the other Cloud database providers like Google.”
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.
I had the distinct pleasure of attending my first FOSS4G conference in Denver last week. Having not attended one previously, I can only rely on the opinions of others that this has been the best FOSS4G yet. For me, this was best geospatial conference I have attended. I’ll probably blog in more detail about some of the things I saw but here are my high-level observations: