<HTML><HEAD><TITLE>[Gvsig_english] Oracle spatial,field length different after exporting to shapefile</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17092" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText50939>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang.</FONT></DIV>
<DIV> </DIV>
<DIV>Yes, I have found a bug in the Oracle Spatial driver which causes numeric field width to be misunderstood. I have already added a bug report and will be fixed soon:</DIV>
<DIV> </DIV>
<DIV><A href="http://forge.osor.eu/tracker/index.php?func=detail&aid=14863&group_id=89&atid=732">http://forge.osor.eu/tracker/index.php?func=detail&aid=14863&group_id=89&atid=732</A></DIV>
<DIV> </DIV>
<DIV>Thanks for checking.</DIV>
<DIV> </DIV>
<DIV>As for the type change (integer to real), I think the problem is in the SHP generator (does not cover all field types found in the DBF format specification). </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature62917>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Wolfgang Qual<BR><B>Enviado el:</B> mar 07/12/2010 16:38<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> [Gvsig_english] Oracle spatial,field length different after exporting to shapefile<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Dear list,<BR><BR>when exporting layers from an oracle spatial database into shp-format,<BR>field definitions are also changed a bit.<BR>The field length of columns with type number seems to be converted to<BR>"REAL" (at least, this is what ogrinfo tells me). This is no problem.<BR>What is worrying me a bit, is that the field length is also modified:<BR>the attached screenshot shows that - for example - field length of the<BR>coloumn "LAND" was 2; the exported dataset has the length "18":<BR><BR>INFO: Open of `./hausnr_punkt_2010_12.shp'<BR> using driver `ESRI Shapefile' successful.<BR><BR>Layer name: hausnr_punkt_2010_12<BR>Geometry: Point<BR>Feature Count: 149184<BR>Extent: (4453141.512585, 5325338.174620) - (4478908.202025, 5345491.596355)<BR>Layer SRS WKT:<BR>(unknown)<BR>ROWID: String (1.0)<BR>OGR_FID: Real (18.0)<BR>OBJEKT_ID: String (7.0)<BR>NR: String (8.0)<BR>LAND: Real (18.0)<BR>REGIERUNGS: Real (18.0)<BR>KREIS: Real (18.0)<BR>GEMEINDE: Real (18.0)<BR>STRASSE: Real (18.0)<BR>STRANAM: String (254.0)<BR>HAUSNR: Real (18.0)<BR>ADR_ZUSATZ: String (1.0)<BR>LAUFENDE_N: Real (18.0)<BR>HOEHE: Real (18.6)<BR>WINKEL: Real (18.6)<BR>OGRFeature(hausnr_punkt_2010_12):0<BR> ROWID (String) = A<BR><BR>It seems as only numerical columns are modified in that way.<BR><BR>Best,<BR>Wolfgang<BR><BR>--<BR>Wolfgang Qual<BR><BR>Landeshauptstadt München<BR>Referat für Gesundheit und Umwelt<BR>Umweltschutz, Umweltvorsorge<BR>RGU-UW 11<BR>Team Klimaschutz, Energie<BR><BR>Bayerstraße 28a<BR>80335 München<BR><BR>Telefon: +49 - 89 - 233 - 4 77 17<BR>Telefax: +49 - 89 - 233 - 4 77 05<BR>E-Mail: wolfgang.qual@muenchen.de<BR>Internet: <A href="http://www.muenchen.de/rgu">http://www.muenchen.de/rgu</A><BR><BR>Bitte beachten Sie die Hinweise zur elektronischen<BR>Kommunikation mit der Landeshauptstadt München:<BR><A href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</A><BR><BR></FONT></P></DIV></BODY></HTML>