[Gvsig_english] Oracle spatial, field length different after exporting to shapefile

[Juan Lucas Dominguez Rubio]

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: gvsig_internacional-bounces at listserv.gva.es 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:   wolfgang.qual at muenchen.de
Internet: http://www.muenchen.de/rgu

Bitte beachten Sie die Hinweise zur elektronischen
Kommunikation mit der Landeshauptstadt München:
http://www.muenchen.de/ekomm



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20101209/b343c66a/attachment.htm