Name
ESRI ArcSDE Database (SDE)
Synopsis
ArcSDE is ESRI's spatial plug-in for SQL Server, Oracle, and DB2 databases. It is also known as Spatial Database Engine, but most commonly as simply SDE.
SDE support
SDE is supported directly by MapServer.
MapServer 4.4 supports SDE 9, 8, and SDE for coverages on Linux, Windows, and Solaris platforms.
Recent developments in MapServer (v4.4) have added support for SDE raster layers. Using raster layers is beyond the scope of this guide.
Connecting to SDE
Install the SDE client libraries from the SDE CDs.
Compile MapServer with SDE support.
Define the layer in the map file.
Map file example
Specify
CONNECTIONTYPE SDE
Define the
CONNECTION
as:hostname
,instancename
,databasename
,username
,password
Define the
DATA
as:tablename
,geometrycolumn
For example:
LAYER NAME test TYPE POLYGON CONNECTION "sde.dms.ca,port:5151,sde,user,password" CONNECTIONTYPE SDE DATA "NTDB.WATER,SHAPE" CLASS ... END END
For more about SDE and MapServer, see the MapServer documentation page at http://mapserver.gis.umn.edu/doc, or search the reference documentation.
Get Web Mapping Illustrated now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.