Jeff Hobbs’ Intergraph and GIS Technology Blog

“A picture is only worth a thousand words. A map may be worth a thousand numbers. But a GIS is worth a thousand tables.”

Archive for July, 2008

Intergraph Schema Remodeler

Posted by jeffhobbs on July 1, 2008

With the last blog post on Safe Software’s FME suite, I would be remiss to not discuss Intergraph’s own Schema Remodeler utility. The Schema Remodeler utility comes as part of GeoMedia Fusion.

[RANT]On a complete side note…IF Intergraph would NOT hide their marketing information behind a login and password, then I’d have links to the products. The last I heard, David Holmes had said that he hoped to have at least the splash pages out from login/password shortly after the end of the conference. We’re going on almost a month now…anytime soon would certainly be nice. Actually, I found what I think is a hidden link to a bit of literature on the software.[/RANT]

Anyhow, GeoMedia Fusion is a great tool for doing data cleanup, attribute validation,  and conflation. The schema remodeler utility comes with GeoMedia Fusion and is a stand alone utility that provides you with the ability to migrate data from one source to another and to bulk export from the GeoMedia environment. For those that have heard of Intergraph’s Data Warehousing Tools, the schema remodeler utility is the re-branded (and enhanced) Data Warehousing Tools. Schema Remodeler is one of my favorite Intergraph tools and I almost always use it at least once a week.. As of late I’ve set it up to take my Trimble GPS text files and load them into my Oracle Locator database. In the schema remodeler utility, you can do a number of things including re-mapping and reordering columns from one source to another (think migrating a database from Access to Oracle or SQL Server); exporting a seamless Access feature class into a gridded Bentley Microstation V7 environment; and updating columns using functional attributes, creating a subset of the the data using temporal and attribute queries, and modifying the source geometry using an analytical merge so you can export the Oracle data to create a shapefile (all in one transaction).

When you look at the functionality of Schema Remodeler, it’s really pretty amazing at how much you can do with the utility. Now, how do I compare it to FME? It’s hard to say as I’ve used Schema Remodeler off and on for the last five years and I’ve only use FME a handful of times. In my eyes, they both attempt to do similar things. The biggest difference in my eyes has to do with the number of file formats supported (Schema Remodeler only supports the standard GM data server while FME supports at least 150 different GIS data types) and how detailed you need to get. Schema Remodeler is great for many things, however it’s only a utility. FME on the other hand is a complete software solution. Its so goal is “spatial ETL (Extract, Transform, and Load”. It should also be mentioned that since you can’t buy Schema Remodeler by itself (it only comes with GeoMedia Fusion), FME is actually quite a bit cheaper than Schema Remodeler. So, if you’re looking exclusively for “spatial ETL” functionality, I personally would go with FME. However if you need to do some pretty advanced conflation, a lot of automated data cleanup, and attribute validation, you really should be looking at GeoMedia Fusion. If you do that, it’s really nice to know that Schema Remodeler comes as part of Fusion and may answer many of your ETL needs.

Posted in GeoMedia, Intergraph | 4 Comments »

Safe Software’s FME Suite for GeoMedia

Posted by jeffhobbs on July 1, 2008

I attended a very good presentation at the Intergraph 2008 user’s conference given by Dale Lutz on FME – Intergraph Edition. I have it on my list to discuss the presentation. However, in the last GISCafe.com weekly newsletter, Susan Smith had a great write-up of Dale’s presentation.

For those that haven’t heard of FME, in short (very short), it’s a spatial ETL tool. In other words, it’s designed to Extract data from one (or many) sources, Transform the data (this can include adding columns, modifying geometry, calculating values, renaming columns, etc), and then Loading the data (or exporting it) into another source. Long story short, for everybody that needs to move data from one source or data type to another, this is the industry leading tool on the market.

With that said, Safe has many different editions of their product. The edition they were demonstrating at Intergraph 2008 (strangely enough) was the Intergraph edition. This basically allows you to load data into an Intergraph SQL Server warehouse. It should be noted that Safe also has a version that will load data into Oracle Locator/Spatial. This is (logically enough) named FME – Oracle Edition.

As part of the Intergraph edition, FME installs a data server into GeoMedia. This data server is named “FME”. When you load this data server you are given access to read any of what must be 200 different GIS data types right inside of GeoMedia…and you thought GeoMedia natively supported a lot of different types of data. And yes, before you ask, if you have the FME data server, you CAN read that ESRI personal geodatabase…with one caveat. You must have ArcGIS installed on the same machine as I believe FME uses the ESRI ArcObjects to read the proprietary personal geodatabase. However, nonetheless, it can be done. Furthermore, if you have an ESRI ArcSDE controlled database, the FME data server will allow you to EDIT the data in the database…with a few caveats. Namely, the ArcSDE database must not be using any of the proprietary functionality like versioning, network routing, etc. However for a simple ArcSDE database, it works very well. In fact, you can watch a video showing the functionality on Safe web site.

In the end, if you find yourself doing a lot of importing, exporting, and data migration, FME is a fantastic tool which will save you a lot of time and energy.

Posted in Intergraph 2008 Conference | Leave a Comment »