{"id":68,"date":"2007-07-10T17:04:41","date_gmt":"2007-07-11T00:04:41","guid":{"rendered":"http:\/\/jeffhobbs.net\/2007\/07\/10\/creating-a-hyperlink-from-a-point-in-geomedia-to-google-maps\/"},"modified":"2007-07-10T17:04:41","modified_gmt":"2007-07-11T00:04:41","slug":"creating-a-hyperlink-from-a-point-in-geomedia-to-google-maps","status":"publish","type":"post","link":"https:\/\/jeffhobbs.com\/?p=68","title":{"rendered":"Creating a Hyperlink from a Point in GeoMedia to Google Maps"},"content":{"rendered":"

After spending much of yesterday moving text around, I decided to look at something different today. We have an application showing a myriad of GPS points along with other information. I thought it might be good to provide a hyperlink for each point to Google Maps to provide additional information and functionality like driving directions, routing, etc.<\/p>\n

So…time for functional attributes. For those that have used them, they are tremendously powerful. Additionally, there’s quite a few samples in the GeoMedia documentation…that is, if you can find them :-(. I found a number of them in the GeoMedia Professional Help (the .chm). Initially I found an example to calculate latitude and longitude which turned out to be quite the overkill – but cool nonetheless. From the help:<\/p>\n

\n
\n

The following example does the same as the previous one except the values are loaded to the same attribute field (that is, Long_Lat) where the longitude and latitude are separated by a comma (Example: -86:41:17.214,34:41:58.884)<\/p>\n

FORMATMEAS(X(Input.Geometry, TrueMeas, Radian), FormatType.Angle, DegreesMinutesSeconds, 3)+’,’+FORMATMEAS(Y(Input.Geometry, TrueMeas, Radian), FormatType.Angle, DegreesMinutesSeconds, 3)<\/p>\n<\/blockquote>\n

This looked cool, but didn’t return lat\/long in a format that Google liked. So, I figured before I went and further, I’d need to figure out just what Google Maps DID want. After doing some research, it turns out what it wants is VERY simple. It wants degrees<\/strong>, rounded to six digits after the decimal. <\/p>\n

This is the equivalent of going to Tools<\/strong> > Geoworkspace Coordinate System<\/strong> > Units and Formats<\/strong> > Geographic<\/strong> (under Type) and changing the Unit<\/strong> to deg<\/strong> and changing the precision<\/strong> to six digits (.123456).<\/p>\n

Then in your precision coordinates bar, make sure Lon, Lat (deg)<\/strong> is selected <\/p>\n

<\/p>\n

After that, I just needed to create the functional attribute. That turned out to be fairly easy (now that I knew what it wanted):<\/p>\n

Y(input.gdo_geometry, TrueMeas, Degree)<\/strong> for the longitude and X(input.gdo_geometry, TrueMeas, Degree)<\/strong> for the latitude<\/p>\n

After that I just need to added the ROUND()<\/strong> function into the mix to round to six numbers after the decimal:<\/p>\n

ROUND(Y(input.gdo_geometry, TrueMeas, Degree), 6)<\/strong><\/p>\n

ROUND(X(input.gdo_geometry, TrueMeas, Degree), 6)<\/strong><\/p>\n

Finally, a wrapped it all into one long string and added the supporting URL specific information:<\/p>\n

‘http:\/\/maps.google.com\/maps?q=’+ROUND(Y(input.gdo_geometry, TrueMeas, Degree), 6)+’,+’+ROUND(X(input.gdo_geometry, TrueMeas, Degree), 6)<\/strong><\/p>\n

You can also add a one line descriptor of the point that will get pass with the URL. So, my VERY END functional attribute looks like:<\/p>\n

‘http:\/\/maps.google.com\/maps?q=’+ROUND(Y(input.gdo_geometry, TrueMeas, Degree), 6)+’,+’+ROUND(X(input.gdo_geometry, TrueMeas, Degree), 6)+’+(SIO + Number+’+Input.SIO_NUMBER+’)’ <\/strong><\/p>\n

If you make sure to set the functional attribute to output Hypertext<\/strong> as opposed to standard text, the Properties Dialog will have your functional attribute as a hyperlink that can be clicked on and will launch Google Maps in your default browser. The end Properties Dialog will look like this (I’ve erased some of the private information)<\/p>\n

<\/p>\n

When I click on the hyperlink, I get the following in Google Maps:<\/p>\n

<\/p>\n

Try it for yourself: http:\/\/maps.google.com\/maps?q=37.157914,+-121.9852+(SIO + Number+322879)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

After spending much of yesterday moving text around, I decided to look at something different today. We have an application…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[10,3,4],"tags":[],"acf":[],"yoast_head":"\nCreating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jeffhobbs.com\/?p=68\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com\" \/>\n<meta property=\"og:description\" content=\"After spending much of yesterday moving text around, I decided to look at something different today. We have an application...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jeffhobbs.com\/?p=68\" \/>\n<meta property=\"og:site_name\" content=\"jeffhobbs.com\" \/>\n<meta property=\"article:published_time\" content=\"2007-07-11T00:04:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/jeffhobbs.net\/files\/2007\/07\/fa1.gif\" \/>\n<meta name=\"author\" content=\"Jeff Hobbs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Hobbs\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=68\",\"url\":\"https:\/\/jeffhobbs.com\/?p=68\",\"name\":\"Creating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com\",\"isPartOf\":{\"@id\":\"https:\/\/jeffhobbs.com\/#website\"},\"datePublished\":\"2007-07-11T00:04:41+00:00\",\"dateModified\":\"2007-07-11T00:04:41+00:00\",\"author\":{\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7\"},\"breadcrumb\":{\"@id\":\"https:\/\/jeffhobbs.com\/?p=68#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jeffhobbs.com\/?p=68\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=68#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jeffhobbs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a Hyperlink from a Point in GeoMedia to Google Maps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jeffhobbs.com\/#website\",\"url\":\"https:\/\/jeffhobbs.com\/\",\"name\":\"jeffhobbs.com\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jeffhobbs.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7\",\"name\":\"Jeff Hobbs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g\",\"caption\":\"Jeff Hobbs\"},\"sameAs\":[\"http:\/\/jeffhobbs.com\"],\"url\":\"https:\/\/jeffhobbs.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jeffhobbs.com\/?p=68","og_locale":"en_US","og_type":"article","og_title":"Creating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com","og_description":"After spending much of yesterday moving text around, I decided to look at something different today. We have an application...","og_url":"https:\/\/jeffhobbs.com\/?p=68","og_site_name":"jeffhobbs.com","article_published_time":"2007-07-11T00:04:41+00:00","og_image":[{"url":"http:\/\/jeffhobbs.net\/files\/2007\/07\/fa1.gif"}],"author":"Jeff Hobbs","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jeff Hobbs","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jeffhobbs.com\/?p=68","url":"https:\/\/jeffhobbs.com\/?p=68","name":"Creating a Hyperlink from a Point in GeoMedia to Google Maps - jeffhobbs.com","isPartOf":{"@id":"https:\/\/jeffhobbs.com\/#website"},"datePublished":"2007-07-11T00:04:41+00:00","dateModified":"2007-07-11T00:04:41+00:00","author":{"@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7"},"breadcrumb":{"@id":"https:\/\/jeffhobbs.com\/?p=68#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jeffhobbs.com\/?p=68"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jeffhobbs.com\/?p=68#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jeffhobbs.com\/"},{"@type":"ListItem","position":2,"name":"Creating a Hyperlink from a Point in GeoMedia to Google Maps"}]},{"@type":"WebSite","@id":"https:\/\/jeffhobbs.com\/#website","url":"https:\/\/jeffhobbs.com\/","name":"jeffhobbs.com","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jeffhobbs.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7","name":"Jeff Hobbs","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bafb9a6abd79509b50a190d399dea779?s=96&d=mm&r=g","caption":"Jeff Hobbs"},"sameAs":["http:\/\/jeffhobbs.com"],"url":"https:\/\/jeffhobbs.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts\/68"}],"collection":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68"}],"version-history":[{"count":0,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}