<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=674592822-23052006>David,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=674592822-23052006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=674592822-23052006>I saw this press release from cubeworx although I
haven't researched or used the product personally.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=674592822-23052006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><A
href="http://www.cubewerx.com/main/about_us/news/Google.html">http://www.cubewerx.com/main/about_us/news/Google.html</A></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=674592822-23052006><FONT face=Arial
color=#0000ff size=2>--Craig</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=674592822-23052006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>TECHER David<BR><B>Sent:</B> Tuesday, May 23, 2006 1:56 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Google
Earth/PostGIS integration<BR></FONT><BR></DIV>
<DIV></DIV>Hi<BR><BR>Did U have some interesting URL ( WMS->GE gateways) to
give us for that.<BR><BR>Thanks<BR><BR>--david;<BR><BR>Craig Miller a
écrit :
<BLOCKQUOTE cite=mid004601c67e8d$e6374c30$0401a8c0@vaio type="cite"><PRE wrap="">There are a couple of WMS->GE gateways. You could use one of those to load
the GE basemap as a WMS layer, then put the PostGIS data on top of it.
--Craig
-----Original Message-----
From: <A class=moz-txt-link-abbreviated href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>
[<A class=moz-txt-link-freetext href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</A>] On Behalf Of Ezequias
Rodrigues da Rocha
Sent: Tuesday, May 23, 2006 10:20 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Google Earth/PostGIS integration
Sure it is nice. I just thought it could be more easy do a postgis
connection with Google Maps. But how to connect (or just see) this bases ?
I have a desktopGIS with me and would like how to load a layer on Google.
Regards
Ezequias
Brian Timoney escreveu:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">Jim:
With time a little short these days, I'll simply sketch out a few key
points--
1) The viewbox parameters for Google Earth (bbox, tilt, heading,
range, etc.) can be read by a server script (PHP, ASP, CFM, etc.) via
a Network Links layer in GE.
2) Now that you have a handle on where the viewer is looking, how far
they're zoomed in, etc., you can craft SQL queries to do perform
geoprocessing operations (e.g. clipping), etc. Again, using
server-side scripting, you can then query your PostGIS db on the back-end.
3) The Geometry specifications for Googles KML (Keyhole Markup
Language) are very similar to the OGC's GML standard. So pulling
geometry out of PostGIS using the 'AsGML(the_geom)' function gets you
90% home in terms of converting query responses back into KML.
4) Applying the appropriate MIME types to the KML you send out from
the server will ensure that the receiving browser knows to shuttle the
response to the GE interface.
5) Using GE's internal web browser (Windows only), is a handy way of
keeping the user in the general "environment" even though technically
the bulk of the data transaction is taking place between web browser and
</PRE></BLOCKQUOTE><PRE wrap=""><!---->server.
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">Hope this is helpful,
Brian
-----------------------
The Timoney Group
518 17th Street
Suite 430
Denver, CO 80206
Ph: (303) 929-3722
Fax: (303) 571-4304
<A class=moz-txt-link-abbreviated href="http://www.thetimoneygroup.com">www.thetimoneygroup.com</A>
-----------------------
-----------------------
The Timoney Group
518 17th Street
Suite 430
Denver, CO 80206
Ph: (303) 929-3722
Fax: (303) 571-4304
<A class=moz-txt-link-abbreviated href="http://www.thetimoneygroup.com">www.thetimoneygroup.com</A>
-----------------------
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
--
Ezequias Rodrigues da Rocha
<A class=moz-txt-link-freetext href="http://ezequiasrocha.blogspot.com">http://ezequiasrocha.blogspot.com</A>
<A class=moz-txt-link-abbreviated href="mailto:msn:ezequias@hotmail.com">msn:ezequias@hotmail.com</A>
"the worst of democracies is still better than the best of dictatorship"
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
_______________________________________________
postgis-users mailing list
<A class=moz-txt-link-abbreviated href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE><BR></BODY></HTML>