<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Perhaps this is not exactly what you mean, but the easiest way to
combine PostGIS with Google is via OpenLayers. See examples at:
<a class="moz-txt-link-freetext" href="http://gallery.openlayers.org/?tag=postgis">http://gallery.openlayers.org/?tag=postgis</a><br>
<br>
Jan<br>
<br>
On 14-1-2010 11:35, Chetna Parbhoo wrote:
<blockquote
cite="mid:90E6608C0B1E4849B9077B4250DE5954C0FA36@gcsbane.groundwaterconsulting.com"
type="cite">
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Times;
panose-1:2 2 6 3 5 4 5 2 3 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:Calibri;}
h1
{margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Trebuchet MS";
text-transform:uppercase;}
h2
{margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:11.0pt;
font-family:"Trebuchet MS";
color:#333333;}
h3
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:#646464;
font-weight:normal;
font-style:italic;}
h4
{margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:16.0pt;
font-family:"Trebuchet MS";
color:#747271;}
h5
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:17.85pt;
margin-bottom:.0001pt;
text-indent:-17.85pt;
mso-list:l0 level5 lfo1;
font-size:12.0pt;
font-family:Times;
font-weight:normal;
font-style:italic;}
h6
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:17.85pt;
text-indent:-17.85pt;
mso-list:l0 level6 lfo1;
font-size:12.0pt;
font-family:Times;
font-weight:normal;
text-decoration:underline;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:17.85pt;
text-indent:-17.85pt;
mso-list:l0 level7 lfo1;
font-size:12.0pt;
font-family:Times;
font-style:italic;
text-decoration:underline;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:12.0pt;
font-family:Times;
font-style:italic;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
font-size:9.0pt;
font-family:Times;
font-style:italic;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Trebuchet MS";
color:gray;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Times;}
p.MsoBlockText, li.MsoBlockText, div.MsoBlockText
{margin-top:0cm;
margin-right:72.0pt;
margin-bottom:6.0pt;
margin-left:72.0pt;
font-size:11.0pt;
font-family:Calibri;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:Tahoma;}
p.BodyCopy, li.BodyCopy, div.BodyCopy
{margin:0cm;
margin-bottom:.0001pt;
line-height:150%;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:#333333;}
p.Bulletcopy, li.Bulletcopy, div.Bulletcopy
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:gray;}
p.Confidential, li.Confidential, div.Confidential
{margin:0cm;
margin-bottom:.0001pt;
border:none;
padding:0cm;
font-size:7.0pt;
font-family:"Trebuchet MS";
color:#181412;}
p.Faxcopy, li.Faxcopy, div.Faxcopy
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:gray;}
p.Faxheader, li.Faxheader, div.Faxheader
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Trebuchet MS";
color:gray;
font-weight:bold;}
p.Faxsubjects, li.Faxsubjects, div.Faxsubjects
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
font-weight:bold;}
p.Fieldfillfax, li.Fieldfillfax, div.Fieldfillfax
{margin:0cm;
margin-bottom:.0001pt;
mso-element:frame;
font-size:10.0pt;
font-family:"Trebuchet MS";}
p.Refblock, li.Refblock, div.Refblock
{margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:8.0pt;
font-family:"Trebuchet MS";
color:#333333;
font-weight:bold;}
p.Refinsertcopy, li.Refinsertcopy, div.Refinsertcopy
{margin:0cm;
margin-bottom:.0001pt;
mso-element:frame;
font-size:8.0pt;
font-family:"Trebuchet MS";
color:#333333;}
p.Referencestylefax, li.Referencestylefax, div.Referencestylefax
{margin:0cm;
margin-bottom:.0001pt;
mso-element:frame;
font-size:8.0pt;
font-family:"Trebuchet MS";}
p.bodycopy0, li.bodycopy0, div.bodycopy0
{margin:0cm;
margin-bottom:.0001pt;
line-height:150%;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:#333333;}
p.bulletcopy0, li.bulletcopy0, div.bulletcopy0
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:gray;}
p.confidential0, li.confidential0, div.confidential0
{margin:0cm;
margin-bottom:.0001pt;
font-size:7.0pt;
font-family:"Trebuchet MS";
color:#181412;}
p.faxcopy0, li.faxcopy0, div.faxcopy0
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
color:gray;}
p.faxheader0, li.faxheader0, div.faxheader0
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Trebuchet MS";
color:gray;
font-weight:bold;}
p.faxsubjects0, li.faxsubjects0, div.faxsubjects0
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";
font-weight:bold;}
p.fieldfillfax0, li.fieldfillfax0, div.fieldfillfax0
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Trebuchet MS";}
p.refblock0, li.refblock0, div.refblock0
{margin:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:8.0pt;
font-family:"Trebuchet MS";
color:#333333;
font-weight:bold;}
p.refinsertcopy0, li.refinsertcopy0, div.refinsertcopy0
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Trebuchet MS";
color:#333333;}
p.referencestylefax0, li.referencestylefax0, div.referencestylefax0
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Trebuchet MS";}
span.EmailStyle41
{mso-style-type:personal;
font-family:Calibri;
color:windowtext;}
span.EmailStyle42
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle43
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:-5;
mso-list-template-ids:351404620;}
@list l0:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-text:"%1\.%2\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level3
{mso-level-text:"%1\.%2\.%3\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level4
{mso-level-text:"%1\.%2\.%3\.%4\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level5
{mso-level-style-link:"Heading 5";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level6
{mso-level-style-link:"Heading 6";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level7
{mso-level-style-link:"Heading 7";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.";
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
margin-left:17.85pt;
text-indent:-17.85pt;}
@list l0:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.";
mso-level-tab-stop:306.0pt;
mso-level-number-position:left;
margin-left:187.2pt;
text-indent:-61.2pt;}
@list l0:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9\.";
mso-level-tab-stop:342.0pt;
mso-level-number-position:left;
margin-left:216.0pt;
text-indent:-72.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt; font-family: "Times New Roman";">Hi<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt; font-family: "Times New Roman";"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt; font-family: "Times New Roman";">I want to
project my PostGIS data onto
google earth. I would like to do it using php to create the kml. Can
anyone
point me to any good references. Thanks.<o:p></o:p></span></font></p>
</div>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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>
</body>
</html>