Archive for the FME Category
Conference fee: $500
Float Plane: $120
Hotel: $240
Value gained at FME UC: Priceless
OK, OK, sorry for the cheezy intro. It’s true though. Let me tell you why.
Starting with the important stuff: Safe Software really know how to do swag and marketing in general. This is hands-down the best bag that I’ve ever got at a conference, though the Research in Motion WES conference came close. Inside the bag was the regular paperwork, but also a great water bottle, an organiser and a T-Shirt (they actually asked my size). Nice going conference team!
OK, that’s not really where the value lies, but it was definitely a nice way to start off the day.
I’ve been active in the FME community for a bit over three years now, and know a lot of folks (staff and users) solely through email. This has been a great opportunity to meet these people and others that I have never seen before, and compare notes on how FME is enriching our lives. The conference is intimate enough (around 100 people I think) that it’s possible to at least say hi to everyone, and there are many staff and expert users here to help out with your problems and discuss any ideas you might have in helping FME evolve to be an even better product. Everyone that is here is extremely accessible, and all seemed to be having fun, from the co-founders through the developers and other staff. It can not be emphasised enough how much value can be obtained solely from the networking available at this kind of conference.
The official kick-off featured a couple sessions about the history of Safe Software and FME, and I personally found these very interesting. Don Murray and Dale Lutz, Safe’s co-founders, showed how a great idea and hard work have grown Safe Software from a two-person operation into the strong organisation it is today, with over 70 employees. This was inspirational if nothing else. The second presentation was by Mark Sondheim and Peter Friesen from the BC Goverment. They recounted first hand the wild west of spatial interchange formats in the 90’s, and how the history of Safe Software was closely linked to the initial implimentation of the SAIF (Spatial Archive Interchange Format) standard. I’m ashamed to admit that I was nowhere near as visionary as Mark and Peter, and wondered at the time why we needed another format that I couldn’t even read from Arc/Info. If you haven’t heard of SAIF, take a minute to look it up. You’ll find that it shares a lot of concepts with GML. If you combine this precursor to GML with pioneering roles in PostGIS and the Java Topology Suite (I had similar unenlightened thoughts about JTS when I saw the RFP…) the effect that these folks have had on our industry and open source geospatial in general is amazing. Now if only they could do something about providing publicly funded base mapping data in BC for free 
The afternoon consisted of two workshop sections, with two streams each. In the first section I co-presented a session on the use of FME in my workplace in the same time slot with two other municipal-related sessions. For the next section, I chose to go to the Scripting stream, where there were sessions talking about using TCL within FME, using FME functions in Python, and some of the new Python-related enhancements in the FME betas. All very cool stuff. The slides will be available after the conference at the FME User Conference 2006 site, as is the agenda if you want to see if I’ve missed anything.
After the educational sessions, it was time for some fun and games. Three other FME MVPs (Hans, Peter, and SRG) competed along with me for the coveted FME Idol award. As we were working, Ulf Mansson took the opportunity to showcase some of his latest FME Art, which was very cool, and a bit distracting. Even with the distractions, I am happy to say that after some stiff competition I walked away with some serious hardware… er… glassware 
To wrap this up, I should talk about some other important features of any conference: food, entertainment, and venue. Here, the conference team came through for us again. The food at the conference center was reasonable, and the dinner and entertainment at Storeum were excellent. The conference is being held at the Morris J. Wosk Centre for Dialogue, a rather unique space that is very condusive to communication. This was also the location of the GeoWeb conference earlier this year. I’m not sure how well it would do with a larger group, but it worked well for us today.
Anyway, let me know if you have any questions, and I’ll do my best to answer them. I am really looking forward to tomorrow.
-J
P.S. If anyone from Autodesk is reading this post: Please, Please, Please work with Safe Software to give use a better solution for reading DWG with Object Data!
Related posts
I admit it: I use SQL Server 2000 at work. It acts as my job scheduler, and it has handled my daily spatial and tabular data transformations for over three years. Most of the work is done by Data Transformation Services (DTS) packages and a vbs script that calls FME.
Those of you who have used Safe Software’s FME Workbench know that it is a great tool for performing spatial extract/transform/load (ETL) operations. It’s a unique way of setting up extremely powerful location data transformations without having to write a single line of code (but you can… in TCL and, more recently, Python). Workbench is an environment similar to DTS and ESRI’s Model Builder; FME’s implementation just happens to be more user-friendly and powerful:
Two recent developments in this field have made me into one extremely happy camper.
The first of these developments is the new version of DTS packaged with SQL Server 2005, which contains enough upgrades that it warrants a fancy new name: SQL Server Integration Services (SSIS). With this release, Microsoft has introduced a two-plane design paradigm, with the outer plane controlling process flow, and the inner plane controlling data flow. I can’t cover much here; suffice to say that it’s extremely powerful, easy to use, and that this feature alone makes the upgrade from 2000 worthwhile. The Microsoft SQL Server Developer Center is a good place to start learning more about SSIS if you’re interested.
The second of the recent developments ties into the first. Safe Software has done a soft launch on a beta FME SSIS plugin that encapsulates all of the cool Spatial ETL capabilities of FME inside SQL Server! Now I can set up a central SSIS workflow that manages all of my spatial transformations. I can also (and this is a big plus) make use of SQL Server’s native data transformation capabilities. This means that I can join disparate tabular data mid-transform to various spatial data sources before outputting a final product. I can also set up rollback routines without resorting to complicated scripting.
The Safe engineers have done a great job on this integration. Apart from some very FME-ish property and data source dialogs (which is a good thing™) it works seamlessly within the context of SSIS. I am happy to see that they managed to get the visualiser to work from within SSIS as well.
Here are some example shots from their web page:
Opening an ArcSDE data source
Setting the properties of a LengthCalculator transformer
Running the SSIS package (ohhh pretty colours… would like to see this in Workbench)
Viewing spatial results in FME Viewer
Viewing CSV results in text editor
Incidentally, this is not the only integration project that Safe has done. If you use Informatica they have also set up a beta program for FME integration with PowerCenter. If you’re an ArcGIS user, the Data Interoperability Extension gives you the same kind of integration with Model Builder (along with native data access to dozens of formats not supported directly by ESRI) and the 9.2 edition will come with a refresh to the FME 2006 GB code base.
I am amazed at Safe’s dedication to the leading edge. First there was Google Earth KML support, next came support for the SDF+ data format (an open format used for MapGuide Open Source and by Autodesk in its geospatial applications) and now this. What’s next? GeoRSS support?
-J
P.S. If you haven’t signed up for the First Annual FME User Conference, do it now. Vancouver is a great city, and I’m sure we’re going to have lots of fun learn lots of useful stuff there.
