The Guide to What Was Important at FOSS4G for People Who Didn’t Go to FOSS4G 2011

So FOSS4G has come and gone, in fact it came and went over a week ago. My day job kept me from posting about what happened last week, but the weekend always gives you time to write [ref]Especially while watching Arizona State demolish Southern Cal[/ref]. The near 1000 of us who attended saw all the great new initiatives around the open source geospatial community, but you probably didn’t. So here is what I see as where you should be looking in the next year before FOSS4G happens again.

  • Mapnik is King — It seems every session had at least some Mapnik component to it. Mapnik is becoming the cartography engine of GIS. I saw cartography during FOSS4G 2011 that just blew my socks off. Innovation in this space is moving so fast and Mapnik is the choice for anyone who is making beautiful, useful maps.
  • PostGISPostGIS 2.0 will come out early next year and you will have zero excuse to use any other spatial database. Much like Mapnik, most sessions had some sort of PostGIS component to them. If you don’t want to be left behind, get the book and start changing how you manage your location data.
  • Designers — One thing that has always been a knock against “traditional GIS” is that it is designed by scientists for scientists. Totally unusable for ordinary users. What I noticed at FOSS4G 2011 was how many companies are employing designers to make sure their apps and maps are usable for everyone. Vizzuality and Development Seed[ref]Tell me that Dev Seed’s homepage isn’t awesome, I dare you.[/ref] have jump to the lead of pushing design in front of classic geospatial front ends. Vizzuality’s CartoSet is giving users tools that they can easily design beautiful mapping applications with little or no coding. Development Seed’s MapBox suite makes it easy to leverage the powerful Mapnik engine to produce tile caches that work out of the box without any need of expensive servers software. Awesome stuff.
  • QGIS — At least in North America, QGIS is the desktop application of choice. I don’t recall seeing any gvSIG or uDIG[ref]Is uDig dead?[/ref] presentations, but QGIS was used by almost everyone. Over the last year it has morphed into a desktop GIS tool that is now my primary choice when working with GIS data. Combining QGIS with Mapnik gives me the ability to make beautiful cartography I cannot create anywhere else. It is completely liberating!
  • JavaScript not Flex/Silverlight — Yea, it isn’t much of a surprise, open source users aren’t big Flex or Silverlight users, but JavaScript HTML5 web apps are everywhere and doing everything Flex/Silverlight can do, but work everywhere[ref]When I refer to everywhere, I choose to ignore IE 6, 7, 8. If you’re stuck on those, find a new job[/ref]. At this point it is safe to call every Flex/Silverlight location app as legacy as nobody in their right mind would be coding with those tools in 2012.

FOSS4G 2011 was probably the best Geospatial/Location Conference I’ve been to. Paul Ramsey put it best when he said:

I told some folks at FOSS4G 2011 that I thought this year’s event was the “best FOSS4G ever” (HT, Juan Antonio Samaranch) but that wasn’t just tongue in cheek. 2011 was the biggest ever, but only a few attendees more than Barcelona in 2010. Yet somehow I felt more energized, more connected, like I had more conversations, than in 2010.

That was pretty much exactly how I felt. I was connect to the attendees, I was energized by the talks and left feeling like at least a portion of the geospatial community has a future in front of it. What is best about this community it is free to join. Just bring your experiences and get started.

The Tragic Prelude

Post GIS 2.0, FOSS4G 2011 Was Off the Hook, Sponsorships Don’t Matter and Go Giants

Monday’s after a good conference are always a load of fun. Hitting all that work you put aside to get involved with the future of GIS. But until I can get up my thoughts on the 2011 Edition of FOSS4G here are some things you probably should know.

PostGIS 2.0 is on the horizon. If you were unable to get to the session, check out the slides.

Paul Ramsey says FOSS4G 2011 was the best and tells you why. Hopefully 2011 is a blueprint for the future of FOSS4G.

Why all the focus on sponsorships as a metric to success? As far as I can tell, FOSS4G 2011 was a huge success and gave back lots of money to OSGeo. Anyone who wants FOSS4G to be more like GeoInt is freaking nuts.

Lastly the World Champs are teasing me with thoughts that they might actually make the playoffs. FOSS4G 2011 was all about the Giants putting the hurt on the Colorado Rockies. Glad I could be there to witness it.

Updated: You Can’t Edit Spatial RDBMS with ArcGIS for Desktop without SDS

So the answer is… No.

[via Bill Dollins](http://blog.geomusings.com/2011/08/17/so-which-is-it/#more-1950)

From the Esri Support Forums: [Edit spatial data with "ArcGIS for Desktop 10.1" in non-SDE RDBMS systems?](http://forums.arcgis.com/threads/35676-Edit-spatial-data-with-quot-ArcGIS-for-Desktop-10.1-quot-in-non-SDE-RDBMS-systems)

>ArcGIS Server 10.1 will include a new technology component called Spatial Data Server (SDS). It is a separate installation from ArcGIS Server and will be included with all editions of ArcGIS Server. SDS is a low-memory footprint application that enables you to publish feature services of your vector data stored in a database or geodatabase. SDS will allow you to edit spatial data in a standard database and does not require ArcSDE technology. Editing for SDS is done via the REST API only which ArcMap does not support at this time [editors note: see below].

Oh snap, not only can you not edit spatial data in other RDBMS without Esri’s Spatial Data Server, you can’t even do it via ArcGIS for Desktop. [editors note: see below] To be fair though, Esri’s business model is built on being the middle man to everything.

>`I don’t know how this whole business started
Of me thinkin’ that I could edit PostGIS
But if you think that we’d be better parted
It’s gonna hurt me but I’ll break away from you`

The latest:

Craig Williams clarifies a [key point](http://forums.arcgis.com/threads/35676-Edit-spatial-data-with-quot-ArcGIS-for-Desktop-10.1-quot-in-non-SDE-RDBMS-systems?p=127134&viewfull=1#post127134):

>Derek’s comments about ArcGIS for Desktop 10.1 not being able to edit SDS are incorrect. ArcGIS for Desktop 10.1 can edit SDS and all other types of ArcGIS feature services. These edits are performed via the REST API for SDS and hosted feature services.

So what does that mean? [Says Craig](https://twitter.com/williamscraigm/status/104240198744940545)

> you connect to SDS, drag the service into the map and it draws via REST calls. To edit you check out / check in

So the final word on this is that you still need middleware to get this done, but you don’t need ArcSDE anymore. Esri views editing spatial databases differently that many of us do, I don’t fault their thinking too much on this, but 99.9% of the time in the real world no one cares about deltas. So to fix my thoughts from above:

Oh snap, you can’t edit spatial data in other RDBMSs without Esri’s Spatial Data Server.

Oh Boy, Maybe You Can’t Edit Spatial Databases Without ArcGIS for SDE

So the [Esri UC Q&A](http://www.spatiallyadjusted.com/2011/06/30/the-esri-uc-qa/) seemed to show that you could not only direct connect to just about any spatial RDBMS, but edit as well. In that spirit, we started to think tools such as [zigGIS](http://www.spatiallyadjusted.com/2011/08/11/pgmap-and-qmap-direct-connect-to-postgis-and-sql-server-spatial/) were no longer needed. Well [Bill Dollins asks Esri](http://blog.geomusings.com/2011/08/17/so-which-is-it/) for some clarification on the matter because the scuttlebutt is that you may still need SDE for editing of spatial databases.

Look, there are times when organizations need SDE. But there are times when SDE is a middle man that has no purpose other than to drive revenues for a company. Let’s not screw this up Esri, let ArcGIS for Desktop and ArcGIS for Server 10.1 edit spatial RDBMSs directly. The proletariat is restless, you don’t need a revolution on your hands.

![Andrew Turner "Leading the People"](http://images.spatiallyadjusted.com/ajturner-neorevolution.png “Andrew Turner Leading the People”)

PgMap and QMap — Direct Connect to PostGIS and SQL Server Spatial

So the big news out of the Esri UC was direct connect to spatial databases at 10.1.  Sounds full of awesome.  Oh but wait, what about the 99.999999% of us not on 10.1?  How do we direct connect without SDE?  Bill Dollins looked at PgMap when ZigGIS was closed.  Says Bill:

I think PgMap is an impressive tool that should be able to support the needs of ArcGIS 9.x and 10.0 users going forward. It’s good to know that a tool is out there to continue meeting that demand.

Clearly those wanting to direct connect to spatial databases without SDE using today’s releases of ArcGIS need to use PgMap or QMap.  The fact they integrate directly into ArcGIS Desktop workflows means that you can use them and quickly get working on PostGIS or SQL Server Spatial quickly.  What are you afraid of?!?!!

PSA: PostGIS in Action to Arrive April 13th

Yep, the book we have all been waiting for is just about here.  Next Wednesday PostGIS in Action will hit the shelves.  I’ve been reviewing it over the last year or so and let me just say it is full of awesome.  I can’t say enough that everyone who uses or wants to use PostGIS needs to get this.

 

I’m totally all over the eBook next week…

Open Source Friday!

Basically I have no idea where the week went. As you can probably tell I’ve been very busy and thus there isn’t much time for blogging about how much I love the shapefile format. In the meantime there is some good open source news you probably need to be aware of.

  • OpenLayer 2.9 Released – Follow that link for the full details, but the take-away from the ESRI DevSummit was if you are doing cool stuff with the ESRI REST API, you are probably doing it in OpenLayers. Why code with something else?
  • zigGIS 3.0 – The defacto tool to access PostGIS from ArcGIS is now open source again. Well it is more complicated than that, but Abe Gillespie has the details on his blog. Basically the project is going to be moving forward with some very cool stuff planned. I’m excited as it makes zero sense to buy ArcSDE to access PostGIS.
  • The R Project – now this isn’t a specific news item, just a reminder that there is a kick ass statistical open source project screaming for you to use it. At the URISA conferences I was at the last two weeks, it appears many don’t know about all the cool stuff you can do with it. My favorite book on learning R (and other open source analytical tools) is Baseball Hacks. ESRI has been showcasing using R with their python tools so you should really want to get into it, just a freaking sweet project. Now if you want to see some geospatial use of R, check out Dylan Beaudette’s blog where he’s been showcasing some cool uses of R.

Anyway, have a great weekend folks. I’ll see some of you next week at GITA 2010. Play me out Joe Morello.

Follow-up to the Tempe GIS Data Request

You might recall the issue where I wanted some GIS data from the City of Tempe?  Well they finally told me to make a public information request and they’d evaluate my request.  Well I got back a response this week:

Dear Mr. Fee:

 

I have reviewed your public records request for the “complete city of Tempe landbase and utilities in digital DGN format,” and discussed it with our City Attorney, Andrew Ching. He has advised me that, under the state public records law and cases construing the law, cities are permitted to weigh the competing interests of the public’s right to receive records versus the countervailing concerns of privacy, confidentiality, and the best interests of the city. Under federal law, city utilities such as water and sewer lines are considered critical infrastructure, which means that cities may restrict access to such data for homeland security reasons. As such, we generally limit access to utility mapping except for very limited parcels or sections, and not for the entire city. Therefore, your request is denied in part; we will release the complete landbase, but not the utilities.

As an alternative, we would be willing to discuss with you further your proposed educational use of the information. It is my understanding you intend to use this for a class presentation to school children on the power of GIS. If that is still the case, we would be willing to discuss options for how you can present to the class while at the same time we can ensure that sensitive data is not disseminated. Please let me know if you would like to meet and discuss these options.

Wendy Springborn, MBA Engineering Services Administrator City of Tempe

So as you can imagine I took them up on their offer of the Landbase data and I now have the city landbase in Microstation DGN v7.  I’d of course love to have unrestricted use of this data, but at this moment I’m in the process of preparing it to be loaded into PostGIS via FME 2010 so that I can start using it.  There was no metadata with the CD they gave me, but it was easy enough to figure out the layering system.  The quicker I get it unlocked from DGN and into open PostGIS, the easier it will be to work with.    Now I just have to make sure I remembered to get my wife a Christmas present.

 

PostGIS in Action – The Book

Regina Obe and Leo Hsu have a great new book coming out called PostGIS in Action.  Looking at the table of contents reveals that this should be the book for learning how to use PostGIS in your GIS applications.  I’m really intersted in Chapter 13, “First look at WKT raster”.  Rasters seem to be pushing their way into my workflows so the more I can learn about it, the better I know I’ll be off.

Brian Timoney updates gulfimpact.com

Brian Timoney has updated his Gulf Coast Energy Impact website with Hurricane Ike information.  It also looks like Brian has gotten a sponsor for his work, IHS (who many might better know as the publisher of this).

Ikes impacts on gulf coast energy

Ike's impacts on Gulf Coast energy