[Mapserver-users] Help with ArcSDE Layer Connection/Data spec ification

Wed Oct 8 18:09:24 EDT 2003

UPDATE!

Please forgive me for sending so many messages to the list.  I have
truncated this one so as not to send so much redundant information but still
retain relevant context.

The problem appears to be in the CLASSITEM/CLASS definition.  The problem
goes away when I comment these definitions out of the demo.map file.  Of
course, I can not see the layer either but this might help those of you
trying to help me.

Tomorrow I will take a closer look at the CLASSITEM/CLASS specifications to
see if I can get them right in this map file.

Thanks again,

Clay Pryor

****************************************************************************
demo.map
****************************************************************************

#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 600 600
#TODO: LOOKUP EXTENT
#EXTENT 388107.634400379 5203120.88405952 500896.339019834 5310243.30613897
EXTENT -8574351.87399496 -8362643.00728895 9017834.16222906 9229543.02893507
UNITS METERS
# SHAPEPATH "data"
IMAGECOLOR 255 255 255

# you may need to change this to match your MapServer build
#IMAGETYPE PNG

#
# Projection definition, consult the PROJ.4 documentation for parameter
discussion
#
#PROJECTION
#  "proj=utm"
#  "ellps=GRS80"
#  "zone=15"
#  "north"
#  "no_defs"
#
#  OR: 
#
#  "init=epsg:26915"
#END

#
# Start of web interface definition (including WMS enabling metadata)
#
WEB
#  HEADER demo_header.html
  TEMPLATE demo.html
#  FOOTER demo_footer.html
  MINSCALE 1000
  MAXSCALE 1550000
#  IMAGEPATH "set in demo_init.html"
#  IMAGEURL "set in demo_init.html"
#  METADATA
#    WMS_TITLE "UMN MapServer SNL Demo"
#    WMS_ABSTRACT "This is the UMN MapServer demonstration application as
modified for SNL."
#    WMS_ACCESSCONSTRAINTS none

    # change this value to match your setup
#    WMS_ONLINERESOURCE "http://134.253.158.45/demoSNL/demo_init.html"

#    WMS_SRS "EPSG:26915"
#  END
END

QUERYMAP
  SIZE 200 200
  STATUS OFF
  STYLE HILITE
  COLOR 255 0 0
END

#
# Start of reference map
#
REFERENCE
  IMAGE graphics/reference.png  # todo: change this!
#  EXTENT 393234.393701263 5205405.16440722 495769.579718949
5307959.02579127
  EXTENT -8574351.87399496 -8362643.00728895 9017834.16222906
9229543.02893507
  SIZE 120 120
  STATUS OFF
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
END

#
# Start of legend
#
LEGEND
  KEYSIZE 18 12
  LABEL
    TYPE BITMAP
    SIZE MEDIUM
    COLOR 0 0 89
  END
  STATUS OFF
END

#
# Start of scalebar
#
SCALEBAR
  IMAGECOLOR 255 255 255
  LABEL
    COLOR 255 255 255
    SIZE tiny    
  END
  STYLE 1
  SIZE 80 2
  COLOR 255 255 255
  UNITS MILES
  INTERVALS 1
#  TRANSPARENT TRUE
#  STATUS TRUE
  STATUS OFF
END

#
# Start of symbol definitions (we're only using a few)
#
#SYMBOL
#  NAME 'circle'
#  TYPE ELLIPSE
#  POINTS 1 1 END
#  FILLED TRUE
#END

#
# Start of layer definitions
#

LAYER
  NAME nercsubrgnstatus
#  CONNECTION "sde_w-24,port:5151,INSISTDB,usrID,usrPwd"
#  CONNECTION "sde_w-24,port:5151,,usrID,usrPwd"
#  CONNECTION "ORCA-WKS-1,port:5151,INSISTDB,usrID,usrPwd"
#  CONNECTION "ORCA-WKS-1,port:5151,,usrID,usrPwd"
#  CONNECTION "ORCA-WKS-1,sde_w-24,SDE,usrID,usrPwd"
#  CONNECTION "ORCA-WKS-1,port:5151,SDE,usrID,usrPwd"
#  CONNECTION "ORCA-WKS-1,port:5151,null,usrID,usrPwd"
#  CONNECTION "orca-wks-1,port:5151,null,usrID,usrPwd"
#  CONNECTION "orca-wks-1,port:5151,insistdb,usrID,usrPwd"
  CONNECTION "orca-wks-1,esri_sde,insistdb,usrID,usrPwd"

  CONNECTIONTYPE sde
  TYPE POLYGON
  STATUS DEFAULT

  DATA "nercSubRegions,shape"
#  DATA "SDE.nercSubRegions,shape"
##  DATA "SDE.SDE.nercSubRegions,shape"
##  DATA "SDE.SDE.NorthAmerica.nercSubRegions,shape"
##  DATA "SDE.NorthAmerica.nercSubRegions,SHAPE"
##  DATA "insistdb.SDE.nercSubRegions,shape"
##  DATA "insistdb.SDE.NorthAmerica.SDE.nercSubRegions,shape"
##  DATA "insistdb.SDE.NorthAmerica.nercSubRegions,shape"
##  DATA "insistdb.NorthAmerica.nercSubRegions,shape"
##  DATA "insistdb.xx,shape"
##  DATA "SDE.xx,shape"
##  DATA "xx,shape"

  CLASSITEM 'NERC_SubRegions'
#  CLASS
#    EXPRESSION 'Itasca'
#    OUTLINECOLOR 128 128 128
#    COLOR 225 225 185
#  END
  CLASS # build classes by status later
    EXPRESSION /./ 
#    SIZE 2 # will this make the lines thicker?
    OUTLINECOLOR 128 128 128
    COLOR 0 255 0
  END
#  METADATA
#    WMS_TITLE "County Boundary"
#    WMS_ABSTRACT "Itasca County boundary shapefile. See
http://deli.dnr.state.mn.us/metadata/full/ctybdne2.html for more
information."
#    WMS_SRS "EPSG:26915"
#  END
END

#LAYER
#  NAME usstates
#  GROUP cities  # don't use here but good for Canada and Mexico
#  TYPE POLYGON
#  CONNECTION "ORCA-WKS-1,port:5151,SDE,usrID,usrPwd"
#  CONNECTIONTYPE sde
#  DATA "SDE.UNITEDSTATES,SHAPE"
#  DATA "UNITEDSTATES,SHAPE"
#  STATUS DEFAULT
#  CLASSITEM US_States_Outline
#  CLASS
#    NAME "US States Outlines"
#    EXPRESSION /./
#    OUTLINECOLOR 128 128 128
#    COLOR 255 255 255 # should be transparrent
#    TEMPLATE "mcd90py2.html"
#  END

#END # usstates

END # Map File