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 November, 2007

Creating a Symbol That Can be Used in GeoMedia – Part 2

Posted by jeffhobbs on November 20, 2007

Now that you have the symbol file created (.sym), you can place it into a GeoMedia Feature Symbol File (.fsm). To do this:

1) Launch the Define Symbol File Utility in Start > Programs > GeoMedia Professional > Utilities

2) Here you can either open up an existing .fsm or you can create a new .fsm. For organization sake, I would recommend storing all of your .sym files in one .fsm. If you don’t already have a .fsm for your organization, then create a new .fsm at this step. If you have an existing .fsm for your organization, use the Open button and navigate to the existing .fsm. In my case, I’ll open up our .fsm.

3) I would now recommend playing with the different buttons to get a better fell for what they do. Most are pretty self-explanatory, but spend a few minutes getting accustomed to the utility.

4) In this tutorial, I’ll just show you how to add the .sym you create in Part 1 to your existing .fsm.

5) Push the “Add” button. This will launch the Add From File dialog box

6) You will notice that if you push the drop-down for the “Files of type” section (see screen shot above), you can insert four different types of symbols into a .fsm file

a) GeoMedia Feature Symbol File – This mean you can select a symbol from a single symbol from an existing .fsm and bring that symbol into your new .fsm. (Reference #2 above for additional feedback on that option). It should also be noted that you can create a “master” .fsm by copying .sym files from the different .fsm files delivered with the GeoMedia product and placing them into your organization’s .fsm.

b) GeoMedia Layout Symbol File – This is what we’ll use to import the symbol file we create in the layout window in part 1 and exported to .sym. Note: This is the option that you’re most likely to use if you need to create symbols from scratch.

c) Microstation Cell Library – This allows you to import individual cells from a cell library.

d) AutoCAD Drawing File – Although I have never used this one, I believe this allows you to import individual symbols from a AutoCAD block file.

It’s important to note that the only type of symbol that can actually be edited in GeoMedia is a GeoMedia Layout Symbol File (.sym). I mention this because you’ll need the source applications (AutoCAD or Microstation) if you want to edit a block or cell library. This is important because often times the cells and blocks don’t import into a .fsm all that well. So it might take a lot of tweaking in the native application before you’re happy with the results. Alternatively, if I recall correctly, the Intergraph product SmartSketch can actually create .sym files from any .fsm file. So, if you import all of your blocks or cells into a .fsm, you should theoretically be able to have SmartSketch translate all of the different symbols in the .fsm into individual .sym files. These individual .sym files can then be imported into the GeoMedia layout window and modified one at a time. You can then re-export the graphics in the layout window back to individual .sym files. Yes, the workflow is a bit painful. But, to be honest, it’s probably a better option over drawing the symbols from scratch in the GeoMedia layout window.

7) To import the .sym created in Part 1, select GeoMedia Layout Symbol file from the file type section, and then navigate to the .sym file you create in Part 1.

8 ) Select the .sym file and hit the Open button. This will bring up the following dialog box

9) Here you can push the Insert button and it will insert the symbol you created into your active .fsm file.

10) Finally, you can use the Edit button to rename and provide comments about the symbol. This can be very useful if you have many symbols that look similar or only differ by color or other very minute details.

11) After you’re through, save your new .fsm. Your new .fsm can then be used in GeoMedia to symbolize any point feature.

It should also be noted that you can convert your .fsm file to .svg using the Save As button. SVG does have its benefits over an .fsm file. You can search the “Working with GeoMedia Professional” book if you’d like additional information on SVG symbols.

I bring it up here because you can theoretically create .svg symbols using a free product like Inkscape. Although I’ve never done it myself, I’ve heard of a few people that have tried this method of symbology creation. The biggest benefit I can see is that you have a much more robust editing tool to create your symbols. Not to mention SVG is an open standard as opposed to the proprietary .fsm file format. This, with time, could prove to be an advantage if you’re ever looking to share your symbol files among different applications (all of which support the open standard).

If anybody is looking to work with SVG symbols and decides to try a product like Inkscape, please let me know as I’d be interested to hear about your findings.

Posted in GeoMedia, Intergraph | 9 Comments »

Very Cool Web Site

Posted by jeffhobbs on November 19, 2007

A colleague pointed me to a web site today named "Vector Magic". This site will convert many different types of of bitmap images to vectors…for free. Although I can’t see anybody using it every day, I can see it coming in handy in those rare occasions. I ran the San Jose Water Company logo through the application and it completed it in a few minutes. Granted, the SJWC logo is fairly simplistic, but it worked really well. You can go to the comparison site to see how this (free) site’s output compares to paid-for products like Adobe Live Trace  (part of Adobe Illustrator CS2) and Corel PowerTRACE. Furthermore, if you pan down the page you can see a side by side comparison between the output from the cost-based programs and Vector Magic. The output appears to be very comparable if not even better in every case.

Posted in Web Site | Leave a Comment »

Creating a Symbol That Can be Used in GeoMedia – Part 1

Posted by jeffhobbs on November 15, 2007

,,

Saw a posting on the GeoMedia email list today inquiring on how to create a symbol that can be used for a point in the map window. I provided a brief answer on the list, but thought I’d run through a quick tutorial here as well.

1) Go to the layout window in GeoMedia.

2) Using the standard drawing tools available in the Draw toolbar, create your symbol.

In my case, I’ve drawn a symbol for a fire hydrant.

3) Select the symbol using the Select Tool

4) Group the symbol using the Draw toolbar

5) With the grouped graphic still selected, use the Create Symbol command in the Draw toolbar.

6) The command will then prompt you to define the symbol’s origin. The origin is the exact location where the point would appear if the symbol were removed and only the point remained. This origin is most often the center of the symbol.

7) As soon as you define the origin, you get a Save As dialog box prompting you for the location to save your new symbol. The symbol will have a .sym extension.

8 ) After you’ve created the symbol, you can place it in a GeoMedia symbol library or in an SVG file. I’ll go over those steps tomorrow.

Posted in GeoMedia, Intergraph | 2 Comments »

Inserting an Object into the Layout Window

Posted by jeffhobbs on November 13, 2007

I’ve run into this problem many, many times. In fact, I’ve filed a worksheet in the past and gotten mixed results as to the answer. Basically, I want to use the Insert > Object command in the Layout Window to insert my oh so fancy logo into my map. In the past I’ve been told that it’s an OLE association issue (or something that sounds like that) on my computer. However, to be honest, I’ve NEVER gotten it to work..and I’ve replaced my computer MANY times since that answer. So, how have I gotten around the issue for the last five years?

1) Launch Internet Explorer

2) File > Open and navigate to your logo (in my case a .gif). However it should work just fine for any "common" file format. Note, you can also drag the logo on top of a Internet Explorer window if you’d prefer.

3) Right-click on the image and select "Copy"

4) Open the Layout Window in GeoMedia

5) Select Edit > Paste

Voila! – your logo appears in the layout window. You then just need to shrink, move, etc. I’ve also noticed that by default, the pasted image has a box or neat line around it. This only makes sense as I’m sure most folks want an ugly box around their logo. Anyhow, just right click on the logo and select "Properties". Then go to the General tab and uncheck the "Display boundary" box.

After that, you’re all set.

On a side note, if you’re going to be using the same template time and time again, you might be better off saving your layout window sheet off to a GeoMedia Layout Template. This can be easily done by using the Sheets > Export Layout command. Just choose the GeoMedia Layout Template (*.glt) format before you export the sheet.

That way you can use the Sheets > Import Layout command to re-use the template whenever you’d like.

One more quick note. If you’re going to be using a template, Intergraph delivers quite a few nice scale bars that can be imported into a layout sheet and will be exported as part of a .glt. They are NOT dynamic so they assume you know your scale ahead of time (and are plotting the scale shown on the scale bar). They can be found in "C:\Program Files\GeoMedia Professional\Symbols\Layout\Scale Bars" folder. You will also see the north arrows in the folder next to the scale bars folder. All of the .sym files can be placed in the layout window using the "Set Active Symbol" command in the Draw toolbar.

Then use the "Symbol" tool in the same Draw toolbar to place the active symbol (the .sym file you just selected using the "Set Active Symbol" command.

Posted in GeoMedia, Intergraph | 11 Comments »

Correction to a Previous Post — Good News

Posted by jeffhobbs on November 9, 2007

I wrote in a post a few months ago about Oracle XE and the fact that it doesn’t come with Oracle Workspace Manager. I was talking to Intergraph a few days ago and was corrected on that issue. Apparently, although Workspace Manager does NOT come pre-installed with Oracle XE, you can use Oracle Workspace Manager with XE. You just need to install it manually. For example, you can download the Oracle Workspace Manager 10.2.0.3.1 kit off of the Oracle Metalink web site, connect to XE as SYS/ AS SYSDA, and run the OWMINST.plb script. This will install OWM in the Oracle XE database and you’ll be able to use GeoMedia Transaction Manager with Oracle XE. Very cool.

Posted in GeoMedia, Intergraph, Oracle Database | 1 Comment »

Intergraph’s Updated Web Site for Support

Posted by jeffhobbs on November 6, 2007

I went to the Intergraph web site to obtain a URL for the GeoRaster expansion pack. While looking for the URL, I just found out that Intergraph has put all of their expansion packs, hotfixes, etc. behind a secure login. Not sure what the thinking was in doing this. But, thought I’d pass along the information.

My old support login allowed me to access the downloads section. So, if you have a login to file worksheets with Intergraph, you should be able to access the support section very easily. If you don’t have a login, the site provides an email address you can use to request a login and password.

Thought I’d pass along the information. So, if you don’t have a login, you might want to make the request from Intergraph now so that you can download the next hotfix or expansion pack when its released.

Posted in Intergraph | 5 Comments »

Answer to a Question

Posted by jeffhobbs on November 6, 2007

A reader by the name of
Panos Elias contacted me recently asking a question about Oracle 11g support with GeoMedia. I replied to the email but the email bounced. So, I thought I’d post the reply here. The basic question was "do GeoMedia 6.0 and/or 6.0 read Oracle 11g data"? So, I talked to a contact of mine at Intergraph, and received the following answer:

11g released too late to be certified but I have been testing with the 6.1 beta for a few months. Oracle broke the ANYINTERACT spatial operator in the released version of 11g but they did fix some spatial filter problems.

So, although 6.1 will NOT be certified against 11g, it has, and will continue to be tested against 11g. I would have to guess that an upcoming 6.1 hotfix will actually be certified against 11g.

For those that are unaware, one of the biggest additions to 11g was the native support for text in the Oracle database. What does this mean? Basically, if you store your text as an Oracle text object (not sure of the proper terminology), you should be able to see that text in ANY client that will read the standard Oracle text object. GREAT for those multi-GIS/CADD client agencies that need to look at GIS data in multiple applications like Bentley Microstation and Intergraph GeoMedia.

Unfortunately, 6.1 is not taking advantage of this new functionality. However, I’m hoping that we’ll see the support for Oracle native text before the release of 6.2.

On a side note, Intergraph did recently release an expansion pack to support Oracle’s GeoRaster datatype. For those that aren’t aware, with the release of Oracle 10g, you can now store imagery (think orthophotos) in the database. Very cool if you have the storage space and Oracle Spatial. The expansion pack can be downloaded from the Intergraph web site (requires a login).

Posted in GeoMedia 6.1 Beta, Oracle Database | Leave a Comment »

General Update – SQL Tuning

Posted by jeffhobbs on November 5, 2007

Welcome back! Sorry it’s been so long since I updated the blog. Two weeks ago I attended an Oracle SQL Tuning class at the Oracle Training Center in Belmont, CA. I had taken a number of Oracle 8i classes four or five years ago. However I never took the SQL Tuning class. Over the past couple of years I’ve found myself having to do more and more at the database level as opposed to the application level (like GeoMedia), so I thought it was about time to take the class and try and get my queries faster.

For those that aren’t aware, SQL tuning is basically the idea of writing your SQL queries in ways that will run most efficienty in the database. So in other words, look at the following two SQL queries – both will return the same results but are written in different ways:

SELECT cust_city, avg(cust_credit_limit)
FROM customers
WHERE cust_city = ‘Paris’
GROUP BY cust_city

vs

SELECT cust_city, avg(cust_credit_limit)
FROM customers
GROUP BY cust_city
having cust_city = ‘Paris’

In the two queries the WHERE clause will be evaluated before the HAVING clause. Therefore, by using WHERE as opposed to HAVING, you’re able to reduce the number of records returned faster in Query A as opposed to Query B. As a whole, this can be VERY important – especially when dealing with hundreds of thousands of records.

Anyhow, as a whole, the class covered A LOT of information and really went back into the core of Oracle and how it operates for many things. Very interesting (I think)…but also very detailed. However, if I had to outline what I learned in a single thought, it would be the following:

"Oracle 10g wants to use the cost-based optimizer. So, it’s going to do it; and most often the cost-based optimizer is correct. So, the idea of including 8i and 9i SQL hints for the most part has been elimianted. In fact, unless the complete query is written using hints, Oracle will simply IGNORE the hints you put into an SQL query."

This was very good for me to understand as I was constantly playing with SQL hints trying (for the most part unsuccessfuly) to get my SQL queries to run faster.

All in all, I did find the class to be very useful and really helped me answer a number of questions I’ve had over the years. I’m looking to test some of the Oracle SQL tuning tools against a spatial query in the near future…. Should be interesting to see how much faster I can make it.

Posted in Oracle Database | Leave a Comment »