Skip to Content
Web Mapping Illustrated
book

Web Mapping Illustrated

by Tyler Mitchell
June 2005
Beginner to intermediate
372 pages
10h 1m
English
O'Reilly Media, Inc.
Content preview from Web Mapping Illustrated

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

  1. Install the SDE client libraries from the SDE CDs.

  2. Compile MapServer with SDE support.

  3. Define the layer in the map file.

Map file example

  1. Specify CONNECTIONTYPE SDE

  2. Define the CONNECTION as: hostname,instancename,databasename,username,password

  3. 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Flask Web Development, 2nd Edition

Flask Web Development, 2nd Edition

Miguel Grinberg

Publisher Resources

ISBN: 0596008651Supplemental ContentErrata Page