This Just In — Excel Is The World’s Most Used “Database”

I’m sure none of us make it though a day without running into one of these wonderful Excel databases people create. Personally I also like using Excel to plan my garden. Is there nothing this thing can’t do?

Take a look at this sweet map I made in Excel of the oil spill in the gulf. I’d upload it to GeoCommons if they just supported Excel.

Wut? I got it all mapped!


A Moment of Silence for MapObjects

Come July 1st, 2010, you won’t be able to buy more licenses for MapObjects 2.4. MapObjects used to be a big part of my geo-coding, though I’ve not be using it for a couple years because it hasn’t supported the latest geospatial technology. I know lots of people still rely on MO for their applications (some mission critical), but the writing is on the wall, MapObjects is not a choice anymore. That said I still need to give ESRI some lovin for MapObjects. MO, you won’t be missed but thanks for being there when I needed you.


ESRI Clarifies Relationships

Thanks to Adena, we’ve got some more details on ESRI’s work with and

An article entitled White House to tie together mapping and data sites? recently appeared in NextGov magazine. Some of the information included in the article was either incorrect or not entirely clear. The information below is intended to help clarify some of the information that appeared in the article.

Read the whole statement over at All Points Blog. My two cents is that this is still a smart play by ESRI. is about “apps” and if you can develop apps on government data easily, it should be successful. Closed or not, ESRI is center stage on creating apps with federal data.

As far as the sole-sourced contract and those details, I’m not sure if anything has been addressed on that. This clarification almost causes more questions to be asked than answered.


Submit a GeoDesign Lightning Talk at the 2010 ESRI User Conference

As expected, there is going to be a GeoDesign Track at the 2010 ESRI UC. ESRI is going to be doing some more lightning talks like we did at the Developer Summit. They were well attended and the presentations were a blast. If you think you’d like to give the world you spin on GeoDesign, a 5 minute lightning talk is a perfect opportunity.

You can submit an abstract for your Lightning Talk by emailing it to


ESRI Binding and

Bring in a Middle Man

Late last week, the following news came out.

The White House has contracted with a major developer of mapping software to merge a federal website that publishes geospatial information with, the government’s depot for downloadable data sets, the company’s president said on Thursday. California-based ESRI began last summer tying to, the geospatial information gateway, said company President Jack Dangermond in an interview with Nextgov.

So lets get the “bottom line” out of the way first. Clearly ESRI is doing this at practically zero cost for the feds. When I first read this I couldn’t help but chuckle. Competing against Google, who is more than happy to give products away, forces companies to make hard decisions such as this. I can see Mr. Kundra sitting in his office laughing uncontrollably because he can play Google, Microsoft and ESRI off each other to get what he wants for practically free. There are very few geospatial companies that can pull this off at that price and honestly ESRI might be the only one.

The GeoMonkey enjoys geo-content only one way….

Visitors to the Feds or Visitors to ESRI?

The NextGov article is somewhat vague, but leaves a bad taste in my mouth.

The site [] already allows anyone to search for graphic layers of information from data sets ESRI retrieved from federal GIS databases. Visitors then can add the layers to a base map, or a background map, to complete the picture. ESRI, which makes money by licensing software for managing and publishing geographic information, is offering the site free of advertisements and does not claim ownership of any content that people and agencies contribute, Dangermond said.

How am I to read that? Does this mean that because I consume “open” federal data in ArcGIS, I can access it for free without advertisements (take that Google BTW)? Must I use ESRI APIs to access geospatial data in It sure reads that way doesn’t it?

You’ll use! Now leave before I am forced to taunt you a second time!

Ah, but the scuttlebutt is that this was a quick sole-sourced contract that is meant to drive content to I guess if someone came up to me and said they’d do millions of dollars of work for free, wouldn’t you take them up on that? So that makes this about people going to and not going to the EPA, or DHS or whatever 3 letter agency you enjoy working with. ESRI won’t give away something unless they get something in return. That would be being the middle man.

Open vs. Open

The other big issue I see here is the question, “Is open data?”. Do “open” ArcGIS Web Services make this data open to all? Does data in ESRI Layer Packages or Layer Files equate to open data? Hard to say. I asked that question on Twitter last week and got 100 different responses. To be honest, I have trouble answering the question as well. I just got back from the NYS Geospatial Summit where I said that I get very nervous when government data is passed to me through proprietary APIs, but as long as I can get at the raw data in an open standard I’m OK with it. Thus I think as long as is there for web services and I’ll still be able to get at the data through agencies websites (e.g. and not there isn’t anything to worry about. But I don’t think that is the case at it appears to me that everything will be run through ESRI’s servers and the data will be available on ESRI support platforms.

The Playing Field

As I said above, we’ve gotten into a vicious marketing cycle here. ESRI can afford to do this because they can sell their licenses to the Federal government to produce the services. Could anyone else in our space do that? Nope, not a one. But what does this mean for consumers of federal data? Does it mean that we all need to buy ESRI licenses to work with their data? Possibly, “open” RESTful services or not, the bottom line is that those with ArcGIS Server or Desktop in their pocket will be able to get up and running quicker than those who have Autodesk or Intergraph licenses. It puts pressure on users to come up with ETL solutions (like Safe’s FME) to do the conversion for them, from ESRI formats and services to OGC formats and services.

A Funny Thing…

What this is all building to though is actually a pretty usable system. Can you imagine, assuming Jack can pull this off and get all governments (local, state and federal) to load their data into ESRI’s, how valuable this might be? Ignoring the “open data” question for a moment, if I can overlay data from my (well maybe not Tempe,AZ) local city, my state and federal government agencies all in one place; doesn’t that give us the tool we all want? Funny how we get right up to the door and all we have to do is walk through. We’d then enjoy access to thousands of geospatial datasets. Maybe my problem is that there are locks on that door and I’m just afraid that I won’t always have a key to open it or get back out.

The ESRI UC is shaping up to be quite interesting, isn’t it?