[Geomedia-l] Geomedia to Google Earth

Thu Mar 1 18:01:35 CST 2007

Hello List,

I'm placing an unsupported GeoMedia command that exports to KML on our
ftp site.  It is very intuitive: It displays a list of features from the
legend to export to KML:

1.) Place a check by the features you want to export, 2.) name the
output KML file, 3.) press the Next button, 4.) select an attribute to
display (more on this in a minute), and 5.) press Finish.  The KML looks
great in Google Earth.  (Double click on the KML file to bring it up
Google Earth.)

Here are my comments:  1.) The command doesn't work with compound
features.  2.) Don't set a line weight for your features.  For some
reason, line weights seem to make the color of the features go to white
in Google Earth (as opposed to the color set in the Legend like it
normally will.)  I just use the default weight when an element is first
placed on the legend.  3.) Remember that the angle of the images in
Google Earth is skewed.  So if you have GPS readings for a building
footprint, and you bring the building footprint into Google Earth, it
won't necessarily line up with the image like you expect.  If you look
at something like curb lines, however, they will line up as you would
expect because they are closer to the ground.

Finally, I mentioned you need to select an attribute for each feature
before pressing the Finish button.  This is required but can be a
nuisance - basically, you'll get a bunch of tooltips in Google Earth
with the attributes from the features.  If you just want the graphics,
create a non-populated field for your features and use that.  For
example, I added a field called "BLANK" defined as Small Integer.  

ftp://ftp.ingr.com/outgoing/KML.zip

Enjoy!

-Sean

Sean T. Davies
Security, Government & Infrastructure (SG&I) Division
Intergraph Corporation
5424 Eastwych Court
Charlotte, NC  28226
P 1.704.366.2381  C 1.704.779.5696
sean.davies at intergraph.com, www.intergraph.com

-----Original Message-----
From: geomedia-l-bounces at directionsmedia.net
[mailto:geomedia-l-bounces at directionsmedia.net] On Behalf Of Amit
Kulkarni
Sent: Wednesday, February 28, 2007 2:39 PM
To: Kris Nackaerts; Dave.Blackstone at dot.state.oh.us
Cc: geomedia-l at directionsmedia.net
Subject: Re: [Geomedia-l] Geomedia to Google Earth

Hi Kris/Dave,

I had requested this as far back as December 2005 i.e just after 6.0 was
released (Postgres 8.0, PostGIS 1.0 just released?). But I think I was
told that this needs to be substantiated by a whole lot of customers for
the GM product development team to justify the time + effort.

Since I am currently enjoying access to Geomedia through a free LSU
academic license (Farrell Jones @LSU is my boss), I figure it would be
better if paying customers ask for this feature. Can you or other paying
customers support this CR by filing it with your local reps?

Postgresql has a Point in time recovery (PITR) which would do exactly
what Oracle Flashback does. PITR is mature, and with the advent of 8.2
of Postgres it is fully as good as Oracle in many things. My view is
that PostGIS is also stable since 1.2, not too many changes is good.
Geomedia Transaction Manager would need to be modified such that it
makes use of Postgresql's MVCC locking, and does a Oracle like
optimistic concurrent locking, i.e it will have to implement a small
functionality of Oracle Workspace Manager.

Only thing Postgres lacks is to highlight exactly what changes you need
to make a DML statement go faster i.e automatic query optimization
suggestions. Oracle does it (semi)automatically but Postgres forces you
to look at its 'Explain plan', which is quite powerful but somewhat
overwhelming to a newbie.

Postgres has arrived, even on Windows!

Thanks in advance

--- Kris Nackaerts <knackaerts at gmx.net> wrote:

> For those interested in PostGIS: since the last version of GeoMedia 
> WFS data server, it's 'compatible' with GeoServer (opensource 
> dataserver).
> 
> I've tested the following setup and it worked as expected. Not a 
> really thorough test, only see if it works.
> 
> Postgis <-> Geoserver <-> WFS <-> GeoMedia WFS data server
> 
> (I remember you 've to be carefull with the mode you set in 
> GeoServer). i can check it if someone is interested.
> 
> GeoServer is setup in a few minutes time and it comes with demo data.
> 
> (I filed a worksheet recently to support WFST to allow write
> operations.)
> 
> Note that the best way to convince Intergraph for specific needs is to

> file worksheets via your local Intergraph contacts (the GeoServer 
> issue was filed this way, GeoServer specific, and solved in the next 
> release).
> 
> Kris
> 
> 
> -------- Original-Nachricht --------
> Datum: Wed, 28 Feb 2007 09:11:46 -0500
> Von: Dave.Blackstone at dot.state.oh.us
> An: Amit Kulkarni <amitkulz at yahoo.com>
> CC: geomedia-l at directionsmedia.net
> Betreff: Re: [Geomedia-l] Geomedia to Google Earth
> 
> > Second that opinion.
> > 
> > 
> > 
> > 
> > David L. Blackstone
> > GIS Manager
> > Office of Technical Services
> > Ohio Department of Transportation
> > 1980 West Broad Street
> > Columbus, Ohio 43223
> > 614-466-2594
> > Dave.Blackstone at dot.state.oh.us
> > 
> > 
> > 
> > Amit Kulkarni <amitkulz at yahoo.com>
> > Sent by: geomedia-l-bounces at directionsmedia.net
> > 02/27/2007 05:50 PM
> > 
> > To
> > geomedia-l at directionsmedia.net
> > cc
> > 
> > Subject
> > Re: [Geomedia-l] Geomedia to Google Earth
> > 
> > 
> > 
> > 
> > 
> > 
> > Hi,
> > 
> > I respectfully disagree! KML and PostGIS are fast becoming
> standards in
> > their respective spaces, and while its okay to delegate to FME
> (which
> > also does PostGIS), it is far better to have in the native product,
> the
> > same way a WMS and Oracle connection is provided.
> > 
> > A place which pays for a enterprise GIS software license sometimes
> also
> > wants to trim its cost of Oracle licenses, if all it does can be
> done
> > by PostGIS.
> > 
> > I hope somebody at Intergraph is considering about it.
> > 
> > Thanks
> > 
> > > Message: 1
> > > Date: Tue, 27 Feb 2007 14:51:58 +0700
> > > From: "TOM & TUN" <tomandtun at gmail.com>
> > > Subject: Re: [Geomedia-l] Geomedia to Google Earth
> > > To: "Kris Nackaerts" <knackaerts at gmx.net>
> > > Cc: geomedia-l at directionsmedia.net
> > > Message-ID:
> > > <5f035c990702262351t7e6fc5fama62d2f9f5078b30e at mail.gmail.com>
> > > Content-Type: text/plain; charset="utf-8"
> > > 
> > > You can use FME.
> > > 
> > > On 2/27/07, Kris Nackaerts <knackaerts at gmx.net> wrote:
> > > >
> > > > Dear,
> > > >
> > > > There does indeed circulate some experimental KML addon for
> > > GeoMedia
> > > > somewhere.
> > > >
> > > > Other options are: search the web for XSLT to convert standard
> GML
> > > export
> > > > to KML.
> > > >
> > > > Otherwise, I just experimented with a quick and dirty piece  of
> VBA
> > > code
> > > > that exports X,Y (you can add Z), name and description to a
> simple
> > > KML file.
> > > > Open the form and press the button :-). You could copy/paste
> this
> > > code into
> > > > a geomedia mdb file, adapt it slightly and export XY
> coordinates.
> > > Use FA and
> > > > export to feature class to create the necessary table.
> > > >
> > > > Hope this gives some first insights in how a KML is created.
> Google
> > > > provides excellent documentation on KML.
> > > >
> > > > Kris

________________________________________________________________________
____________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com
_______________________________________________
GeoMedia-l mailing list
GeoMedia-l at lists.directionsmedia.net
http://www.directionsmedia.net/mailman/listinfo/geomedia-l