{"id":116,"date":"2007-08-15T18:30:53","date_gmt":"2007-08-16T01:30:53","guid":{"rendered":"http:\/\/jeffhobbs.net\/2007\/08\/15\/using-oracle-locator-data-in-google-earth\/"},"modified":"2007-08-15T18:30:53","modified_gmt":"2007-08-16T01:30:53","slug":"using-oracle-locator-data-in-google-earth","status":"publish","type":"post","link":"https:\/\/jeffhobbs.com\/?p=116","title":{"rendered":"Using Oracle Locator Data in Google Earth"},"content":{"rendered":"<p><!-- #BeginTags --><\/p>\n<p class=\"tags\"><a href=\"http:\/\/www.technorati.com\/tag\/Google Earth\" rel=\"tag\">Google Earth<\/a>,<a href=\"http:\/\/www.technorati.com\/tag\/GIS\" rel=\"tag\">GIS<\/a>,<a href=\"http:\/\/www.technorati.com\/tag\/Oracle Database\" rel=\"tag\">Oracle Database<\/a><\/p>\n<p><!-- #EndTags --><\/p>\n<p>I happened upon an interesting article titled &#8220;<a href=\"http:\/\/www.oracle.com\/technology\/pub\/articles\/lokitz-spatial-geoserver.html\">Integrating Oracle Spatial with Google Earth<\/a>&#8221; yesterday on the Oracle web site. The article is authored by Justin Lokitz of Leica Geosystems (formerly of Oracle Corporation and Acquis Inc.). It discusses using the open source software <a href=\"http:\/\/geoserver.org\/\">GeoServer<\/a>. The article has a very good discussion of using GeoServer to read the Oracle database and create KML that can be ingested dynamically (via a Network Link) by Google Earth. The entire process seems to be somewhat straightforward. It should also be noted that Justin has posted an addendum to the article on his <a href=\"http:\/\/www.orablogs.com\/oragis\/archives\/001977.html\">OraGIS blog<\/a>. Finally, the folks at GeoServer have also posted a six+ minute movie highlighting how the <a href=\"http:\/\/geoserver.codehaus.org\/tutorials\/videos\/google_earth\/google_earth.html\">data can be ingested by Google Earth<\/a>.<\/p>\n<p>After looking at GeoServer, the software looks very cool. It appears to be a data broker (for lack of a better term) that allow you to transform &#8220;typical&#8221; GIS data (shapefile, Oracle Locator, ArcSDE, etc.) to standards-based formats that can be used by today&#8217;s &#8220;main stream&#8221; applications like Google Earth (via KML\/KMZ), Google Maps\/Yahoo Maps\/Microsoft Virtual Earth (via GeoRSS),  Flex\/Flash (via WMS\/WFS), GIS applications (via WMS\/WFS), etc.<\/p>\n<p>However, do keep in mind that each of these applications has different licensing agreements. For instance, Google Earth is free <strong>for<br \/>\npersonal, non-commercial use only<\/strong>. Furthermore, there are some restrictions on the online mapping applications. In the end, just make sure to read the licensing agreements of the software that will be the client for your application &#8230;ideally <em>before<\/em> developing the application \ud83d\ude42 . \n\t\t        <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Earth,GIS,Oracle Database I happened upon an interesting article titled &#8220;Integrating Oracle Spatial with Google Earth&#8221; yesterday on the Oracle&#8230;<\/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":[11,6],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Oracle Locator Data in Google Earth - 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=116\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Oracle Locator Data in Google Earth - jeffhobbs.com\" \/>\n<meta property=\"og:description\" content=\"Google Earth,GIS,Oracle Database I happened upon an interesting article titled &#8220;Integrating Oracle Spatial with Google Earth&#8221; yesterday on the Oracle...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jeffhobbs.com\/?p=116\" \/>\n<meta property=\"og:site_name\" content=\"jeffhobbs.com\" \/>\n<meta property=\"article:published_time\" content=\"2007-08-16T01:30:53+00:00\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=116\",\"url\":\"https:\/\/jeffhobbs.com\/?p=116\",\"name\":\"Using Oracle Locator Data in Google Earth - jeffhobbs.com\",\"isPartOf\":{\"@id\":\"https:\/\/jeffhobbs.com\/#website\"},\"datePublished\":\"2007-08-16T01:30:53+00:00\",\"dateModified\":\"2007-08-16T01:30:53+00:00\",\"author\":{\"@id\":\"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7\"},\"breadcrumb\":{\"@id\":\"https:\/\/jeffhobbs.com\/?p=116#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jeffhobbs.com\/?p=116\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jeffhobbs.com\/?p=116#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jeffhobbs.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Oracle Locator Data in Google Earth\"}]},{\"@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":"Using Oracle Locator Data in Google Earth - 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=116","og_locale":"en_US","og_type":"article","og_title":"Using Oracle Locator Data in Google Earth - jeffhobbs.com","og_description":"Google Earth,GIS,Oracle Database I happened upon an interesting article titled &#8220;Integrating Oracle Spatial with Google Earth&#8221; yesterday on the Oracle...","og_url":"https:\/\/jeffhobbs.com\/?p=116","og_site_name":"jeffhobbs.com","article_published_time":"2007-08-16T01:30:53+00:00","author":"Jeff Hobbs","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jeff Hobbs","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jeffhobbs.com\/?p=116","url":"https:\/\/jeffhobbs.com\/?p=116","name":"Using Oracle Locator Data in Google Earth - jeffhobbs.com","isPartOf":{"@id":"https:\/\/jeffhobbs.com\/#website"},"datePublished":"2007-08-16T01:30:53+00:00","dateModified":"2007-08-16T01:30:53+00:00","author":{"@id":"https:\/\/jeffhobbs.com\/#\/schema\/person\/600c6cc6bd115876f071a9bfb5c934d7"},"breadcrumb":{"@id":"https:\/\/jeffhobbs.com\/?p=116#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jeffhobbs.com\/?p=116"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jeffhobbs.com\/?p=116#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jeffhobbs.com\/"},{"@type":"ListItem","position":2,"name":"Using Oracle Locator Data in Google Earth"}]},{"@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\/116"}],"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=116"}],"version-history":[{"count":0,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions"}],"wp:attachment":[{"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeffhobbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}