[Qgis-user] ArcSDE

[Andrea Peri 2007]

There almost 2 types of arcsde layers.

The single Layers 
and the geodatabases's layers.

The first is quite simple because every dataset (table) is isolated from others datasets (tables).
The second is more complex because use all the GDB tables to understand the GIS 
constraints between all the tables (datasets).

(ps: the geodatabase is not a relational DB so it don't know and don't use foreign-key and so on.)

-
This second format is supported only from arceditor and arcinfo level of arcgis family products (about 20K$)
-

After this there is another physical level of difference.
ArcSDE can use the esri-native format .
I don't remenber how it is called, but remenber is some like a binary archived 
in a blob field.
Or it can use DB native formats like Oracle SDO_Geometry and so on.

I don't know is gvsig can support all this differences perhaps it support 
the single-layers structure when used with some DB format like 
oracle sdo-geometry ?


Andrea.

>UDig is the only open source Desktop GIS that can do this. I've done this,
>and can confirm that it works for viewing/editing (normally $10k of ESRI
>software is required to do just this). It just takes some setting up and
>getting the correct versions and JARs together.
>
>I've had less luck with OGR ArcSDE, since it has a lack of community support
>to properly build and QAQC the libraries (e.g.,
>http://trac.osgeo.org/osgeo4w/ticket/42) and only works with ArcSDE 9.1 and
>9.2 (not 9.3 or 10.0).
>
>-Mike