[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