Hi Ednardo- I'm sure you're aware of this, but just in case:
http://www.gdal.org/ogr/drv_oci.html and http://www.gdal.org/ogr/drv_pg.html Since your data will be in one or the other you can continue to use ogr2ogr to generate KML directly from the database. -Chris From: Ednardo Ferreira [mailto:[email protected]] Sent: Wednesday, January 28, 2009 10:20 AM To: Christopher Condit Subject: Re: [gdal-dev] ogr2ogr: KML to any format - export fields Hi! I really apreciate your attention. 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. 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. Thank you! From: Christopher Condit <[email protected]> To: Ednardo Ferreira <[email protected]>; [email protected] Sent: Wednesday, January 28, 2009 2:54:08 PM Subject: RE: [gdal-dev] ogr2ogr: KML to any format - export fields Hi Ednardo- >Now, I'm testing options. I'd like to convert from .TAB to KML, >and then KML to .TAB because my enterprise is on transition >situation. We want to use KML files, not .TAB anymore. But for >a time, we have to use both formats. 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. In your transition situation I would maintain everything in .TAB for the time being and write a script to generate KML from the .TAB. -Chris >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 >would do it. > >Thank you! > >Até mais! >Jesus te ama e Ele vai voltar! >Ednardo de Oliveira Ferreira >Analista de Sistemas e Mestre em Transportes >+55(61)8128-7950 >Blog: http://vilaperi.blogspot.com/ > >Desmascarando o panfleto Veja: http://luis.nassif.googlepages.com/home >Caso Daniel Dantas: >ttp://www.cartacapital.com.br/app/materia.jsp?a=2&a2=6&i=1643 > >"Suspeitavam que eu vivia intensamente e num livre abandono à felicidade; isto >não se perdoa." (Albert Camus) > >"Quem confia em traidores a si próprio atraiçoa." (Mariano da Fonseca) > >"Há o suficiente no mundo para todas as necessidades humanas, não há o >suficiente para a cobiça humana." (Mahatma Gandhi) > ________________________________________ From: Christopher Condit <[email protected]> To: Ednardo Ferreira <[email protected]>; [email protected] Sent: Tuesday, January 27, 2009 7:08:42 PM Subject: RE: [gdal-dev] ogr2ogr: KML to any format - export fields Hi Ednardo- 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. -Chris Christopher Condit [email protected] (858) 822-5483 From: [email protected] [mailto:[email protected]] On Behalf Of Ednardo Ferreira Sent: Tuesday, January 27, 2009 11:42 AM To: [email protected] Subject: [gdal-dev] ogr2ogr: KML to any format - export fields Hello! I'm testing ogr2ogr solution. It's really great. But I have a problem. The situation is: 1) I have a Map Info Line layer. It has 7 descripition fields. 2) Using ogr2ogr tool, I generated a KML file from this Map Info layer. It's ok. 3) When I use this KML in google earth, the informations are all there. 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. 5) how can I convert from KML to, for example, SHP or TAB, keeping all fields? Até mais! Jesus te ama e Ele vai voltar! Ednardo de Oliveira Ferreira Analista de Sistemas e Mestre em Transportes +55(61)8128-7950 Blog: http://vilaperi.blogspot.com/ Desmascarando o panfleto Veja: http://luis.nassif.googlepages.com/home Caso Daniel Dantas: ttp://www.cartacapital.com.br/app/materia.jsp?a=2&a2=6&i=1643 "Suspeitavam que eu vivia intensamente e num livre abandono à felicidade; isto não se perdoa." (Albert Camus) "Quem confia em traidores a si próprio atraiçoa." (Mariano da Fonseca) "Há o suficiente no mundo para todas as necessidades humanas, não há o suficiente para a cobiça humana." (Mahatma Gandhi)
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
