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_01CB9E21.C111C90E
Content-Type: text/html;charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-EC0D2A8E-5CB7-4969-9C36-46D859D137BE-PartID: 13C91E07-8C73-4D52-82F6-996BAA19E264
<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.2900.2=
180" name=3DGENERATOR></HEAD>=0A<BODY>=0A<DIV id=3DidOWAReplyText92074>=0A<D=
IV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>Hello, Kornel:</F=
ONT></DIV>=0A<DIV> </DIV>=0A<DIV>I thought you were talking about Oracl=
e Spatial, but now I see your table is an alphanumeric one. I do not know in=
detail how the gvSIG alphanumeric Oracle driver works, sorry.</DIV>=0A<DIV>=
</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=
However, I have succesfully exported the table to SHP after creating another=
view which leaves out the OBJEKT_ID field:</FONT></DIV>=0A<DIV> <=
/DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>CREATE =
VIEW TEST_AUS_VIEW_V ("NAME", "STRASSEHAUSNR", "PLZ", "ORT", "ANNOTATIONO", =
"Y", "X") AS SELECT "NAME", STRASSEHAUSNR, PLZ, ORT, ANNOTATIONO, Y, X =
FROM TEST_AUS_VIEW;</FONT></DIV>=0A<DIV> </DIV>=0A<DIV><FONT face=3D"Ti=
mes New Roman" color=3D#000000 size=3D3>Then repeat the same process you did=
, but using TEST_AUS_VIEW_V as the table name. I have obtained a 1.5-megabyt=
e DBF file. The string fields are cropped to 254 characters (possibly a DBF =
limitation)</FONT></DIV>=0A<DIV> </DIV>=0A<DIV><FONT face=3D"Times New =
Roman" color=3D#000000 size=3D3>If your database is an Oracle Spatial or Loc=
ator database, there might be other ways to do this without renouncing to th=
e OBJEKT_ID field, but I don't know if the 254-character limit in DBF files =
can be avoided. Is it an Oracle Spatial DB or a traditional alphanumeric Ora=
cle DB?</FONT></DIV>=0A<DIV> </DIV>=0A<DIV><FONT face=3D"Times New Roma=
n" color=3D#000000 size=3D3>***</FONT></DIV>=0A<DIV> </DIV>=0A<DIV><FON=
T face=3D"Times New Roman" color=3D#000000 size=3D3>Apart from that: the par=
ameters for the public Oracle Spatial DB have changed, now the port is 80, s=
o maybe you will be able to access it too from your restricted network:</FON=
T></DIV>=0A<DIV> </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: 80</FONT></DIV>=0A<DIV><FON=
T face=3D"Times New Roman" color=3D#000000 size=3D3>DB name: xe</FONT></DIV>=
=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>User: gvsig<=
/FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=
Password: gvsig</FONT></DIV>=0A<DIV> </DIV>=0A<DIV> </DIV>=0A<DIV>=
</DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 size=3D3>=
Regards,</FONT></DIV>=0A<DIV><FONT face=3D"Times New Roman" color=3D#000000 =
size=3D3></FONT> </DIV></DIV>=0A<DIV id=3DidSignature12010>=0A<DIV><FON=
T face=3D"Courier New" size=3D2><FONT face=3D"Times New Roman" size=3D3>Juan=
Lucas Dom=EDnguez Rubio<BR></FONT>---</FONT></DIV>=0A<DIV><FONT face=3D"Cou=
rier New" size=3D2><FONT face=3D"Courier New" size=3D2><FONT face=3D"Courier=
New" size=3D2>Prodevelop SL, Valencia (Espa=F1a)</FONT></DIV>=0A<DIV>=0A<DI=
V><FONT face=3D"Courier New" size=3D2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.6=
8<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>---</FONT></DIV></FONT></DIV></FONT></DIV>=0A<DIV><BR>=0A<HR>=0A<FO=
NT face=3DTahoma size=3D2><B>De:</B> gvsig_internacional-bounces at listserv.gv=
a.es en nombre de K.Kiss<BR><B>Enviado el:</B> mar 14/12/2010 17:00<BR><B>Pa=
ra:</B> gvsig_internacional at listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_eng=
lish] Oracle spatial, field length different after exporting to shapefile<BR=
></FONT><BR></DIV>=0A<DIV><BR>=0A<P><FONT size=3D2>Hello,<BR><BR>I have a si=
milar problem. Briefly described:<BR>A Oracle View has originally a field of=
the type Varchar2 with 4000 byte.<BR><BR>If I try into gvSIG (table is load=
ed and with X/Y - coordinates provide) the<BR>table as Shape to export.<BR>T=
he presentation was ok.<BR>It comes to export errors. 0bytes written<BR><BR>=
More information about the Gvsig_internacional
mailing list