<html>
<head>
<style type="text/css">
<!--
body.hmmessage { font-family: Tahoma; font-size: 10pt }
.hmmessage p { padding-bottom: 0px; padding-top: 0px; margin-top: 0px; margin-bottom: 0px; padding-right: 0px; margin-right: 0px; margin-left: 0px; padding-left: 0px }
-->
</style>
</head>
<body style="margin-top: 4px; line-height: normal; font-variant: normal; margin-bottom: 1px; margin-right: 4px; margin-left: 4px" class="hmmessage" content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">Gery,</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">here is a hint: INSERT INTO <SOMETABLE> (select . . . ) </font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">or something close to that . . .</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<br>
<br>
>>> "Gery ." <gamejihou@hotmail.com> wrote:<br> </p>
<table style="margin-top: 0; margin-bottom: 0; margin-right: 0; margin-left: 15px; font-size: 1em" border="0" bgcolor="#f3f3f3">
<tr>
<td>
<div style="padding-left: 7px; border-left: solid 1px #050505">
<div dir="ltr">
<p style="margin-top: 0; margin-bottom: 0">
<br>
I'm really amazed by such basic question, sorry for this but I don't find the answer, this is, I simplified a table like this:<br><br>select transform(simplify(transform(rawgeom,2249),50),4326) as smoothedgeom from rawnav_line_wgs84 ;<br><br>I suppose now it looks like I want, however no idea how to save this as another table, so I did:<br><br>select astext(transform(simplify(transform(rawgeom,2249),50),4326)) as smoothedgeom from rawnav_line_wgs84 ;<br><br>but this didn't help in the way I want.<br><br>What I'm looking for is to save the smoothedgeom as a new table, then put it as a shape and then kml. The shape/kml process is easy, I did it before, but put the smoothedgeom as a new table is new for me, how could I do this??<br><br>Thanks for any help,<br>
</p>
</div>
</div>
</td>
</tr>
</table>
</body>
</html>