<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
The ogr2ogr tool worked great, and it even placed one of the text columns in an infowindow. It seemed very quick compared to the client-side parsing/displaying that I was doing in javascript. <BR>
<BR>
However, I need to have more customization in the way the text is displayed, using tabbed windows for spatial relationships,etc and colors for polygons based on column values. So, what do you recommend for that? I'm assuming I'll just have to create the total customized kml via perl, the language I'm most familiar with. Or does ogr2ogr allow some customization? Thanks for your help!<BR>
Shad<BR><BR><BR>
<DIV><EM><FONT face="Lucida Handwriting" color=#0000ff size=1></FONT></EM> </DIV><BR><BR>
<BLOCKQUOTE>
<HR>
Date: Thu, 3 Apr 2008 01:22:30 +0200<BR>From: sfkeller@gmail.com<BR>To: shadkeene@hotmail.com<BR>Subject: Re: [FWTools] convert postgis data to kml<BR>CC: fwtools@lists.maptools.org<BR><BR>
<DIV>You can either use pgsql2shp from directory pgsql/bin, and then use OGR (from GDAL/OGR/FWTools) to convert to KML<BR>or you try it in one step like this using FWTools:<BR>% ogr2ogr -f "KML" neighborhoods.kml PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "select gid, name, the_geom from neighborhoods"<BR>See <A href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet" target=_blank>http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet</A></DIV>
<DIV>-- Stefan<BR> </DIV>
<DIV><SPAN class=EC_gmail_quote>2008/4/2, Shad Keene <<A href="mailto:shadkeene@hotmail.com">shadkeene@hotmail.com</A>>:</SPAN>
<BLOCKQUOTE class=EC_gmail_quote style="PADDING-LEFT: 1ex; BORDER-LEFT: #ccc 1px solid">
<DIV>Hi,<BR>My goal is to display various shapes(polygons, points, linestring) on google maps by using data entered into a postgis database. I was looking for a way to do this that used the spatial structure already provided in postgis(already designating if shape is a linestring or polygon, etc) instead of parsing out the coordinates and then re-entering spatial structure in google maps. I saw that google maps api is now compatible with kml data formats. And then I read that FWTools can convert postgis data to kml format. <BR>I've done some reading in the forums about the actual process of converting postgis data to kml via FWTools, but didn't see anything that would help me. I'm new to kml but am familiar with postgis and perl language. Is there a tutorial for the process of converting postgis data to kml? Where can I get started? Thanks for any help,<BR>Shad<BR><BR>
<DIV><FONT style="COLOR: rgb(0,0,255)" size=1><SPAN style="FONT-STYLE: italic; FONT-FAMILY: Lucida Handwriting,Cursive"></SPAN></FONT><EM><FONT face="Lucida Handwriting" color=#0000ff size=1><BR></FONT></EM></DIV><BR>
<HR>
More immediate than e-mail? <A href="http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008" target=_blank>Get instant access with Windows Live Messenger.</A></DIV><BR>_______________________________________________<BR>FWTools mailing list<BR><A href="mailto:FWTools@lists.maptools.org">FWTools@lists.maptools.org</A><BR><A href="http://lists.maptools.org/mailman/listinfo/fwtools" target=_blank>http://lists.maptools.org/mailman/listinfo/fwtools</A><BR><A href="http://fwtools.maptools.org/" target=_blank>http://fwtools.maptools.org/</A><BR><BR></BLOCKQUOTE></DIV><BR></BLOCKQUOTE><br /><hr />More immediate than e-mail? <a href='http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008' target='_new'>Get instant access with Windows Live Messenger.</a></body>
</html>