Hello, Wolfgang. 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:
http://forge.osor.eu/tracker/index.php?func=detail&aid=14863&group_id=89&atid=732 Thanks for checking. 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). Regards, Juan Lucas Domínguez Rubio --- Prodevelop SL, Valencia (España) Tlf.: 96.351.06.12 -- Fax: 96.351.09.68 http://www.prodevelop.es <http://www.prodevelop.es/> --- ________________________________ De: [email protected] en nombre de Wolfgang Qual Enviado el: mar 07/12/2010 16:38 Para: Users and Developers mailing list Asunto: [Gvsig_english] Oracle spatial,field length different after exporting to shapefile Dear list, when exporting layers from an oracle spatial database into shp-format, field definitions are also changed a bit. The field length of columns with type number seems to be converted to "REAL" (at least, this is what ogrinfo tells me). This is no problem. What is worrying me a bit, is that the field length is also modified: the attached screenshot shows that - for example - field length of the coloumn "LAND" was 2; the exported dataset has the length "18": INFO: Open of `./hausnr_punkt_2010_12.shp' using driver `ESRI Shapefile' successful. Layer name: hausnr_punkt_2010_12 Geometry: Point Feature Count: 149184 Extent: (4453141.512585, 5325338.174620) - (4478908.202025, 5345491.596355) Layer SRS WKT: (unknown) ROWID: String (1.0) OGR_FID: Real (18.0) OBJEKT_ID: String (7.0) NR: String (8.0) LAND: Real (18.0) REGIERUNGS: Real (18.0) KREIS: Real (18.0) GEMEINDE: Real (18.0) STRASSE: Real (18.0) STRANAM: String (254.0) HAUSNR: Real (18.0) ADR_ZUSATZ: String (1.0) LAUFENDE_N: Real (18.0) HOEHE: Real (18.6) WINKEL: Real (18.6) OGRFeature(hausnr_punkt_2010_12):0 ROWID (String) = A It seems as only numerical columns are modified in that way. Best, Wolfgang -- Wolfgang Qual Landeshauptstadt München Referat für Gesundheit und Umwelt Umweltschutz, Umweltvorsorge RGU-UW 11 Team Klimaschutz, Energie Bayerstraße 28a 80335 München Telefon: +49 - 89 - 233 - 4 77 17 Telefax: +49 - 89 - 233 - 4 77 05 E-Mail: [email protected] Internet: http://www.muenchen.de/rgu Bitte beachten Sie die Hinweise zur elektronischen Kommunikation mit der Landeshauptstadt München: http://www.muenchen.de/ekomm
_______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
