No subject

Thu Dec 9 17:23:40 CET 2010

If i shorten the Varchar2 to 255 byte, the problem does not exists....

Greetings
Kornel Kiss

-----
Kornel Kiss

Referat f=FCr Gesundheit und Umwelt
Anforderungsmanagement Fachanwendungen
Bayerstr. 28a
80335 M=FCnchen
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-=
spatial-field-length-different-after-exporting-to-shapefile-tp5812040p583443=
4.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional

------_=_NextPart_001_01CB9C52.53E693E4
Content-Type: text/html;charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-EC0D2A8E-5CB7-4969-9C36-46D859D137BE-PartID: 48867E78-4061-498A-83D5-B8C50A6681A8

<HTML><HEAD><TITLE>Re: [Gvsig_english] Oracle spatial, field length differen=
t after exporting to shapefile</TITLE>=0A<META http-equiv=3DContent-Type con=
tent=3D"text/html; charset=3Dunicode">=0A<META content=3D"MSHTML 6.00.6000.1=
7092" name=3DGENERATOR></HEAD>=0A<BODY>=0A<DIV id=3DidOWAReplyText74320>=0A<=
DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Hello, Kornel an=
d Wolfgang:</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New =
Roman" color=3D#000000 size=3D3>These are the parameters of an Oracle Spatia=
l database (actually Oracle Locator) which is publicly available for reading=
 and writing. This DB is not maintained by gvSIG or any company, so it's ver=
y unreliable, but maybe we can use it to easily reproduce and fix Oracle-rel=
ated issues:</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New=
 Roman" color=3D#000000 size=3D3>URL: lucasdom.homelinux.org</FONT></DIV>=0A=
<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Port: 1521</FON=
T></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>DB n=
ame: xe</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 s=
ize=3D3>User: gvsig</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=
=3D#000000 size=3D3>Password: gvsig</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV>=
<FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Obviously, it's extr=
emely slow, so we can only play with tiny layers. Let me know if you have is=
sues with it.</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times Ne=
w Roman" color=3D#000000 size=3D3>In that DB, the fields of the table MINI_R=
OAD_4326&nbsp;are very similar to Wolfgang's table:</FONT></DIV>=0A<DIV>&nbs=
p;</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3><A h=
ref=3D"http://listserv.gva.es/pipermail/gvsig_internacional/attachments/2010=
1207/718a9d3d/attachment.jpg">http://listserv.gva.es/pipermail/gvsig_interna=
cional/attachments/20101207/718a9d3d/attachment.jpg</A></FONT></DIV>=0A<DIV>=
&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=
Also, the size of the STRAXLON field is 4000, and if I export it to SHP with=
 gvSIG 1.10, the resulting fields are like this, according to ogrinfo:</FONT=
></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#0=
00000 size=3D3>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" =
color=3D#000000 size=3D3>Geometry: Line String</FONT></DIV>=0A<DIV><FONT fac=
e=3D"Times New Roman" color=3D#000000 size=3D3>Feature Count: 95</FONT></DIV=
>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Extent: (14=
.762572, 55.029009) - (15.027142, 55.157857)</FONT></DIV>=0A<DIV><FONT face=3D=
"Times New Roman" color=3D#000000 size=3D3>Layer SRS WKT:</FONT></DIV>=0A<DI=
V><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>(unknown)</FONT></=
DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>ROWID: S=
tring (1.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#0000=
00 size=3D3>GID: Real (18.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Rom=
an" color=3D#000000 size=3D3>OGR_FID: Real (18.0)</FONT></DIV>=0A<DIV><FONT =
face=3D"Times New Roman" color=3D#000000 size=3D3>OBJ_ID: String (7.0)</FONT=
></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>NR: S=
tring (8.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#0000=
00 size=3D3>STRANAM: String (254.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times =
New Roman" color=3D#000000 size=3D3>ADR_ZUS: String (1.0)</FONT></DIV>=0A<DI=
V><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>LAND: Real (18.0)<=
/FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=
REG: Real (18.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D=
#000000 size=3D3>STRASSE: Real (18.0)</FONT></DIV>=0A<DIV><FONT face=3D"Time=
s New Roman" color=3D#000000 size=3D3>STRAXLON: String (254.0)</FONT></DIV>=0A=
<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>STRALON: String=
 (254.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 =
size=3D3>HOEHE: Real (18.6)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roma=
n" color=3D#000000 size=3D3>ADATE: Date (10.0)</FONT></DIV>=0A<DIV><FONT fac=
e=3D"Times New Roman" color=3D#000000 size=3D3>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=0A<DI=
V>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D=
3>As Wolfgang said, some field types and widths have changed.</FONT></DIV>=0A=
<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=
=3D3>After fixing that bug, I get this result, which I think is correct, as =
far as the Oracle driver is concerned. Fields of type String are cropped to =
254 characters. I'm not sure if this is a limitation of the DBF format or no=
t, but I have checked that the Oracle driver is providing the metadata corre=
ctly:</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman"=
 color=3D#000000 size=3D3>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></DIV>=0A<DIV><FONT face=3D"Times=
 New Roman" color=3D#000000 size=3D3>Geometry: Line String</FONT></DIV>=0A<D=
IV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Feature Count: 95=
</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3=
>Extent: (14.762572, 55.029009) - (15.027142, 55.157857)</FONT></DIV>=0A<DIV=
><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Layer SRS WKT:</FON=
T></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>(unk=
nown)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 siz=
e=3D3>ROWID: String (1.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman"=
 color=3D#000000 size=3D3>GID: Real (12.0)</FONT></DIV>=0A<DIV><FONT face=3D=
"Times New Roman" color=3D#000000 size=3D3>OGR_FID: Real (18.0)</FONT></DIV>=
=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>OBJ_ID: Stri=
ng (7.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 =
size=3D3>NR: String (8.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman"=
 color=3D#000000 size=3D3>STRANAM: String (254.0)</FONT></DIV>=0A<DIV><FONT =
face=3D"Times New Roman" color=3D#000000 size=3D3>ADR_ZUS: String (1.0)</FON=
T></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>LAND=
: Integer (2.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#=
000000 size=3D3>REG: Integer (1.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times N=
ew Roman" color=3D#000000 size=3D3>STRASSE: Integer (5.0)</FONT></DIV>=0A<DI=
V><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>STRAXLON: String (=
254.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 si=
ze=3D3>STRALON: String (254.0)</FONT></DIV>=0A<DIV><FONT face=3D"Times New R=
oman" color=3D#000000 size=3D3>HOEHE: Real (14.6)</FONT></DIV>=0A<DIV><FONT =
face=3D"Times New Roman" color=3D#000000 size=3D3>ADATE: Date (10.0)</FONT><=
/DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV><FONT face=3D"Times New Roman" colo=
r=3D#000000 size=3D3>So Kornel: I have not been able to reproduce your probl=
em. Can you somehow create a little table (many columns but very few rows) i=
n that DB exactly like the one that is causing your problems (using SQLDevel=
oper, gvSIG or other client)?</FONT></DIV>=0A<DIV>&nbsp;</DIV>=0A<DIV>&nbsp;=
</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Regard=
s,</FONT></DIV>=0A<DIV><FONT face=3D"Courier New" size=3D2><FONT face=3D"Tim=
es New Roman" size=3D3>Juan Lucas Dom=EDnguez Rubio<BR></FONT>---</FONT></DI=
V></DIV>=0A<DIV id=3DidSignature89338>=0A<DIV><FONT face=3D"Courier New" siz=
e=3D2><FONT face=3D"Courier New" size=3D2><FONT face=3D"Courier New" size=3D=
2>Prodevelop SL, Valencia (Espa=F1a)</FONT></DIV>=0A<DIV>=0A<DIV><FONT face=3D=
"Courier New" size=3D2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A =
href=3D"http://www.prodevelop.es/"><FONT face=3D"Courier New" size=3D2>http:=
//www.prodevelop.es</FONT></A><BR><FONT face=3D"Courier New" size=3D2>---</F=
ONT></DIV></FONT></DIV></FONT></DIV>=0A<DIV><BR>=0A<HR>=0A<FONT face=3DTahom=
a size=3D2><B>De:</B> gvsig_internacional-bounces at listserv.gva.es en nombre =
de K.Kiss<BR><B>Enviado el:</B> mar 14/12/2010 17:00<BR><B>Para:</B> gvsig_i=
nternacional at listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] Oracle sp=
atial, field length different after exporting to shapefile<BR></FONT><BR></D=
IV>=0A<DIV><BR>=0A<P><FONT size=3D2>Hello,<BR><BR>I have a similar problem. =
Briefly described:<BR>A Oracle View has originally a field of the type Varch=
ar2 with 4000 byte.<BR><BR>If I try into gvSIG (table is loaded and with X/Y=
 - coordinates provide) the<BR>table as Shape to export.<BR>The presentation=
 was ok.<BR>It comes to export errors. 0bytes written<BR><BR>From the memory=
 (the error-entry): "invalid field type 2 (DBF export)" !<BR>If i shorten th=
e Varchar2 to 255 byte, the problem does not exists....<BR><BR>Greetings<BR>=
Kornel Kiss<BR><BR>-----<BR>Kornel Kiss<BR><BR>Referat f=FCr Gesundheit und =
Umwelt<BR>Anforderungsmanagement Fachanwendungen<BR>Bayerstr. 28a<BR>80335 M=
=FCnchen<BR>--<BR>View this message in context: <A href=3D"http://osgeo-org.=
1803224.n2.nabble.com/Oracle-spatial-field-length-different-after-exporting-=
to-shapefile-tp5812040p5834434.html">http://osgeo-org.1803224.n2.nabble.com/=
Oracle-spatial-field-length-different-after-exporting-to-shapefile-tp5812040=
p5834434.html</A><BR>Sent from the gvSIG international mailing list archive =
at Nabble.com.<BR>_______________________________________________<BR>Gvsig_i=
nternacional mailing list<BR>Gvsig_internacional at listserv.gva.es<BR><A href=3D=
"http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http:/=
/listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT>=
</P></DIV></BODY></HTML>
------_=_NextPart_001_01CB9C52.53E693E4--