CartoDB Is Now CARTO

The company formerly known as CartoDB announced today that it is rebranding to the name CARTO. This change is intended to indicate a stronger focus on enabling location intelligence and analytics within its platform by adding new tool designed to allow data analysts to analyze, visualize, and publish without the in-depth knowledge of SQL, CSS, and Javascript that has been traditionally required to to perform such tasks.

Read moreCartoDB Is Now CARTO

Arc2Earth: Choose Your ‘Cloud’

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:

[slideshare id=16811994&w=427&h=356&sc=no]

 

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.

Read moreArc2Earth: Choose Your ‘Cloud’

CartoDB/Leaflet Sample Update

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.

Read moreCartoDB/Leaflet Sample Update

FOSS4G North America

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.

It feels like I never leave this place.

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.

Read moreFOSS4G North America

Arc2Earth Sync Beta Announced

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.”

Read moreArc2Earth Sync Beta Announced

CartoDB + Leaflet = Easy

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.

With this information, I set out to build a simple application to query property data and display the results on a map in a browser. In addition to CartoDB, I elected to use the Leaflet Javascript library to accomplish the mapping (although I also experimented with OpenLayers). Displaying and styling GeoJSON in Leaflet is very straightforward and this task gave me and excuse to get a little more comfortable with it.

Read moreCartoDB + Leaflet = Easy

FOSS4G Quick Hits

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:

It's time to refresh your thinking about open-source geospatial tools.

Read moreFOSS4G Quick Hits