<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Ednardo-<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I’m sure you’re aware of this, but just in case:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://www.gdal.org/ogr/drv_oci.html">http://www.gdal.org/ogr/drv_oci.html</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>and<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a href="http://www.gdal.org/ogr/drv_pg.html">http://www.gdal.org/ogr/drv_pg.html</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Since your data will be in one or the other you can continue to
use ogr2ogr to generate KML directly from the database.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Chris<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Ednardo Ferreira
[mailto:ednardof@yahoo.com] <br>
<b>Sent:</b> Wednesday, January 28, 2009 10:20 AM<br>
<b>To:</b> Christopher Condit<br>
<b>Subject:</b> Re: [gdal-dev] ogr2ogr: KML to any format - export fields<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hi!<br>
<br>
I really apreciate your attention.<br>
<br>
My database will be oracle or postgres. The information in this fields can be
found in other tables. Now, what we have is the same data in 2 places: database
and in .TAB files.<br>
<br>
As you mentioned, we intend to migrate everything, including the maps, to
postgis/oracle. Kml will be just to distribute maps for our customer. and this
kml will be generated from postgis.<br>
<br>
Thank you! <o:p></o:p></p>
<div>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Christopher Condit <condit@sdsc.edu><br>
<b>To:</b> Ednardo Ferreira <ednardof@yahoo.com>;
gdal-dev@lists.osgeo.org<br>
<b>Sent:</b> Wednesday, January 28, 2009 2:54:08 PM<br>
<b>Subject:</b> RE: [gdal-dev] ogr2ogr: KML to any format - export fields<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
Hi Ednardo-<br>
>Now, I'm testing options. I'd like to convert from .TAB to KML, <br>
>and then KML to .TAB because my enterprise is on transition <br>
>situation. We want to use KML files, not .TAB anymore. But for <br>
>a time, we have to use both formats. <br>
I'm not sure what your particular data looks like, but I would encourage you
not to use KML as a primary format. XML is not well suited to large datasets
and at this point doesn't translate well into other formats. I think PostGIS is
a better bet as a primary source for your vector data, and from there translate
into any other format you need (including KML). On the other hand, if your data
sets are small and you have little interest in producing them in other formats,
go with KML.<br>
<br>
In your transition situation I would maintain everything in .TAB for the time
being and write a script to generate KML from the .TAB.<br>
<br>
-Chris<br>
<br>
>I think that I'll kill the 7 fields that I mentioned. In fact, they are not
used. But if I could mantain them, I <br>
>would do it.<br>
><br>
>Thank you!<br>
> <br>
>Até mais!<br>
>Jesus te ama e Ele vai voltar! <br>
>Ednardo de Oliveira Ferreira<br>
>Analista de Sistemas e Mestre em Transportes<br>
>+55(61)8128-7950 <br>
>Blog: <a href="http://vilaperi.blogspot.com/" target="_blank">http://vilaperi.blogspot.com/</a><br>
><br>
>Desmascarando o panfleto Veja: <a
href="http://luis.nassif.googlepages.com/home" target="_blank">http://luis.nassif.googlepages.com/home</a><br>
>Caso Daniel Dantas:
ttp://www.cartacapital.com.br/app/materia.jsp?a=2&a2=6&i=1643<br>
><br>
>"Suspeitavam que eu vivia intensamente e num livre abandono à
felicidade; isto não se perdoa." (Albert Camus)<br>
><br>
>"Quem confia em traidores a si próprio atraiçoa." (Mariano da
Fonseca)<br>
><br>
>"Há o suficiente no mundo para todas as necessidades humanas, não há o
suficiente para a cobiça humana." (Mahatma Gandhi)<br>
><br>
<br>
________________________________________<br>
From: Christopher Condit <<a href="mailto:condit@sdsc.edu">condit@sdsc.edu</a>><br>
To: Ednardo Ferreira <<a href="mailto:ednardof@yahoo.com">ednardof@yahoo.com</a>>;
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
Sent: Tuesday, January 27, 2009 7:08:42 PM<br>
Subject: RE: [gdal-dev] ogr2ogr: KML to any format - export fields<br>
Hi Ednardo-<br>
Is there a particular reason that you don't want to go directly from the
original MapInfo to SHP? I would suggest that first, that way you don't lose
field information. At this point the KML reader is not aware of KML Schemas, so
you'll always get a big mashup of fields... This is being worked on.<br>
<br>
-Chris<br>
<br>
Christopher Condit<br>
<a href="mailto:condit@sdsc.edu">condit@sdsc.edu</a><br>
(858) 822-5483<br>
<br>
From: <a href="mailto:gdal-dev-bounces@lists.osgeo.org">gdal-dev-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:gdal-dev-bounces@lists.osgeo.org">gdal-dev-bounces@lists.osgeo.org</a>]
On Behalf Of Ednardo Ferreira<br>
Sent: Tuesday, January 27, 2009 11:42 AM<br>
To: <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
Subject: [gdal-dev] ogr2ogr: KML to any format - export fields<br>
<br>
Hello!<br>
<br>
I'm testing ogr2ogr solution. It's really great.<br>
<br>
But I have a problem. The situation is:<br>
<br>
1) I have a Map Info Line layer. It has 7 descripition fields. <br>
<br>
2) Using ogr2ogr tool, I generated a KML file from this Map Info layer. It's
ok. <br>
<br>
3) When I use this KML in google earth, the informations are all there.<br>
<br>
4) But, If I try to convert this KML to any other format (as SHP or TAB), the 7
fields are all put together in one single field. <br>
<br>
5) how can I convert from KML to, for example, SHP or TAB, keeping all fields?<br>
<br>
<br>
<br>
<br>
<br>
Até mais!<br>
Jesus te ama e Ele vai voltar! <br>
Ednardo de Oliveira Ferreira<br>
Analista de Sistemas e Mestre em Transportes<br>
+55(61)8128-7950 <br>
Blog: <a href="http://vilaperi.blogspot.com/" target="_blank">http://vilaperi.blogspot.com/</a><br>
<br>
Desmascarando o panfleto Veja: <a href="http://luis.nassif.googlepages.com/home"
target="_blank">http://luis.nassif.googlepages.com/home</a><br>
Caso Daniel Dantas:
ttp://www.cartacapital.com.br/app/materia.jsp?a=2&a2=6&i=1643<br>
<br>
"Suspeitavam que eu vivia intensamente e num livre abandono à felicidade;
isto não se perdoa." (Albert Camus)<br>
<br>
"Quem confia em traidores a si próprio atraiçoa." (Mariano da Fonseca)<br>
<br>
"Há o suficiente no mundo para todas as necessidades humanas, não há o
suficiente para a cobiça humana." (Mahatma Gandhi)<br>
<br>
<br>
<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</body>
</html>