ArcSDE¶

Vector support¶

ArcSDE provides efficient access to vector layers, (“featureclasses” in ArcSDE jargon), over a number of relational databases. GeoServer can set up featuretypes for registered ArcSDE featureclasses and spatial views. For versioned ArcSDE featureclasses, GeoServer will work on the default database version, for both read and write access.

Transactional support is enabled for featureclasses with a properly set primary key, regardless if the featureclass is managed by a user or by ArcSDE. If a featureclass has no primary key set, it will be available as read-only.

Raster support¶

ArcSDE provides efficient access to multi-band rasters by storing the raw raster data as database blobs, dividing it into tiles and creating a pyramid. It also allows a compression method to be set for the tiled blob data and an interpolation method for the pyramid resampling.

All the bands comprising a single ArcSDE raster layer must have the same pixel depth, which can be one of 1, 4, 8, 16, and 32 bits per sample for integral data types. For 8, 16 and 32 bit bands, they may be signed or unsigned. 32 and 64 bit floating point sample types are also supported.

ArcSDE rasters may also be color mapped, as long as the raster has a single band of data typed 8 or 16 bit unsigned.

Finally, ArcSDE supports raster catalogs. A raster catalog is a mosaic of rasters with the same spectral properties but instead of the mosaic being precomputed, the rasters comprising the catalog are independent and the mosaic work performed by the application at runtime.

Installing the ArcSDE extension¶

Adding an ArcSDE vector data store¶

In order to serve vector data layers, it is first necessary to register the ArcSDE instance as a data store in GeoServer. Navigate to the New data source page, accessed from the Stores page in the Web Administration Interface. and an option for ArcSDE will be in the list of Vector Data Stores.

ArcSDE in the list of data sources

Configuring an ArcSDE vector data store¶

The next page contains configuration options for the ArcSDE vector data store. Fill out the form, then click Save.

Configuring a new ArcSDE data store

You may now add featuretypes as you would normally do, by navigating to the New Layer page, accessed from the Layers page in the Web Administration Interface.

Configuring an ArcSDE vector data store with Direct Connect¶

ESRI Direct Connect[ESRI DC] allows clients to directly connect to an SDE GEODB 9.2+ without a need of an SDE server instance, and is recommended for high availability environments, as it removes the ArcSDE gateway server as a single point of failure. ESRI DC needs additional platform dependent binary drivers and a working Oracle Client ENVIRONMENT (if connecting to an ORACLE DB). See Properties of a direct connection to an ArcSDE geodatabase in the ESRI ArcSDE documentation for more information on Direct Connect, and Setting up clients for a direct connection for information about connecting to the different databases supported by ArcSDE.

The GeoServer configuration parameters are the same as in the Configuring an ArcSDE vector data store section above, with a couple differences in how to format the parameters:

• server: In ESRI Direct Connect Mode a value must be given or the Direct Connect Driver will throw an error, so just put a ‘none’ there - any String will work!
• port: In ESRI Direct Connect Mode the port has a String representation: sde:oracle10g, sde:oracle11g:/:test, etc. For further information check ArcSDE connection syntax at the official ArcSDE documentation from ESRI.
• instance: In ESRI Direct Connect Mode a value must be given or the Direct Connect Driver will throw an error, so just put a ‘none’ there - any String will work!
• user: The username to authenticate with the geo database.
• password: The password associated with the above username for authentication with the geo database.

You may now add featuretypes as you would normally do, by navigating to the New Layer page, accessed from the Layers page in the Web Administration Interface.

Adding an ArcSDE vector data store with JNDI¶

Configuring an ArcSDE vector data store with JNDI¶

Adding an ArcSDE raster coveragestore¶

In order to serve raster layers (or coverages), it is first necessary to register the ArcSDE instance as a store in GeoServer. Navigate to the Add new store page, accessed from the Stores page in the Web Administration Interface and an option for ArcSDE Raster Format will be in list.

ArcSDE Raster in the list of data sources

Configuring an ArcSDE raster coveragestore¶

The next page contains configuration options for the ArcSDE instance. Fill out the form, then click Save.

Configuring a new ArcSDE coveragestore

You may now add coverages as you would normally do, by navigating to the Add new layer page, accessed from the Layers page in the Web Administration Interface.