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

Wolfgang Qual wolfgang.qual at muenchen.de
Tue Dec 7 16:38:22 CET 2010


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 --------------
A non-text attachment was scrubbed...
Name: oracle_metadata_original.jpg
Type: image/jpeg
Size: 76272 bytes
Desc: not available
Url : http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20101207/718a9d3d/attachment.jpg 


More information about the Gvsig_internacional mailing list