[Gvsig_english] Accessing SDE binary geometry from gvSIG

Fri Feb 13 10:10:27 CET 2009

Hello,
Yes, I have heard it's not very fast. Out of curiosity, would you mind exporting that 50,000-record table to a shapefile (menu: layer - export - SHP) and tell me:

- what is the size of the resulting SHP file? (not the DBF or the SHX, just the SHP file)
- those features are points, multipoints, polylines or polygons?
- the database is in the same computer where gvSIG is installed or in a server in your local network?

As I said, if your geometries are stored in Oracle's SDO format, you can also use gvSIG's Oracle Spatial driver to access them directly.

Regards,

Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
0° 22' 49.62" W, 39° 28' 25.45" N
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Harvey Arnone
Enviado el: jue 12/02/2009 23:49
Para: gvsig_internacional at runas.cap.gva.es
Asunto: RE: [Gvsig_english] Accessing SDE binary geometry from gvSIG

Yes, that worked.  I was able to install it and now the gvSIG SDE Driver
appears on the data base connections drop down.  I setup up a few layers
to our SDE9.2 instance (Oracle 10g), but it is VERY slow.  feature
classes with only 50,000 records take about 30-40 seconds to draw. by
comparison they draw nearly instantaneously in ArcMap. 

Have you had any similar experience with this?  Thanks for the help
-harv

>>> "Juan Lucas Dominguez Rubio" <jldominguez at prodevelop.es> 2/12/2009
2:36 AM >>>
Hello, Harvey:

When the ArcSDE extension installer asks if you want to check the
prerequisites, say 'no', then it will ask you to locate a 'java.exe'
file. Choose any java.exe you have installed in your computer, from a
JVM higher or equal to 1.4.2. In my case:

C:\Program Files\Java\jdk1.6.0_07\jre\bin\java.exe

It will then say that 1.4.2 is recommended, but it's ok, a higher one
will do. Then go through the installation wizard and finally you only
have to copy the two JAR files mentioned in the installation
instructions to:

[GVSIG_FOLDER]\bin\gvSIG\extensiones\org.gvsig.sde\lib\

And that's it. The next time you start gvSIG, in the GeoBD connections
dialog you will see the 'gvSIG SDE driver' available in the drop-down
combo box.

I do not have an ArcSDE-managed database myself, so I cannot help you
further in this regard, sorry.

Cheers,

Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
0° 22' 49.62" W, 39° 28' 25.45" N
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/>  <http://www.prodevelop.es/>
---

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Harvey
Arnone
Enviado el: jue 12/02/2009 0:50
Para: gvsig_internacional at runas.cap.gva.es
Asunto: RE: [Gvsig_english] Accessing SDE binary geometry from gvSIG

Thanks Juan, looks pretty straight forward.  However, while installing
the gvSIG plugin, it checked for Java JRE 1.4.2 and asked to install
it.
 I received the error attached on this e-mail.

I've tried a bunch of different ways of resolving the problem
including
installing 1.4.2 from alternative sources.  I'm wondering if anyone
else
has encountered this problem and what I might do to overcome it.

Thanks -Harvey Arnone

>>> "Juan Lucas Dominguez Rubio" <jldominguez at prodevelop.es> 2/11/2009
3:43 AM >>>
Hello, Harvey:

- Regarding ArcSDE, there is a gvSIG plugin (or extension) to get
read-only access. You can read the installation instructions here:

http://www.gvsig.gva.es/index.php?id=1874&K=1&L=2

And download it from here (bottom of the page):

http://www.gvsig.gva.es/index.php?id=1873&L=0explotan&L=2

And read the user manual here:

ftp://downloads.gvsig.org/gva/descargas/ficheros/Extensiones/gvSIG-1_1_1-ArcSDE_Client-man-1_0-es.pdf

it's in Spanish, but with the screen-shots in pages 5 to 8 is enough,
I
think.

- Regarding the direct access to Oracle Spatial or Locator databases
(Oracle SDO), you need to download the Oracle JDBC driver from  the
Oracle website:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

Copy the 'ojdbc14.jar' file to this folder:

[GVSIG_FOLDER]\bin\gvSIG\extensiones\com.iver.cit.gvsig\lib\

and you will be able to access your tables with SDO objects in your
Oracle database with read-write access, so you can add and edit them
as
vector layers in your gvSIG project.

You can also check the Oracle Spatial section in the gvSIG English
manual:

ftp://downloads.gvsig.org/gva/descargas/manuales/gvSIG-1_1-man-v1-en.pdf

Regards,

Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
0° 22' 49.62" W, 39° 28' 25.45" N
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/>  <http://www.prodevelop.es/>
<http://www.prodevelop.es/>
---

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Harvey
Arnone
Enviado el: mié 11/02/2009 8:48
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Accessing SDE binary geometry from gvSIG

I understand that I should be able to connect to ArcSDE data stored in
Oracle from the gvSIG desktop application.  I cannot determine how to
do
this and hoped someone could direct me.

Alternatively, if this is not possible, how would I connect to Oracle
SDO datasets?

Thanks for your help.  I'm new to gvSIG.  -Harvey Arnone (Seattle
Public Utilities)

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20090213/17eb4c66/attachment.htm