AW: [mapserver-users] Problem querying SDE layer

Wed Oct 23 03:07:40 PDT 2002

Hi Debbie,

all I can say, is that querying an SDE layer is not different from
querying anything else. I have query and itemquery requests working on
SDE-Layers. But I had a hell of a time getting it done. SDE-Support is
declared as alpha on the Website. Not without any reason.

What mapserver-release do you use? We recently made some changes to the
sourcecode regarding SDE-Support and afaik the changes will be reflected
in 3.7. But I can send you our mapsde.c. I don't know if it solves your
problem, but you can give it a shot. A least it solves some problems you
will be facing as soon as you get the query-modes working.

And here's another adice when working with SDE: don't panic.

greetings
Oliver

> -----Ursprüngliche Nachricht-----
> Von: owner-mapserver-users at lists.gis.umn.edu 
> [mailto:owner-mapserver-users at lists.gis.umn.edu] Im Auftrag 
> von Debbie Pagurek
> Gesendet: Dienstag, 22. Oktober 2002 15:57
> An: mapserver-users at lists.gis.umn.edu
> Betreff: [mapserver-users] Problem querying SDE layer
> 
> 
> I have an application that is displaying, zooming etc and SDE 
> layer and that's all working fine, but whenever I try to 
> query I'm getting:
> 
> Content-type: text/html msSDELayerGetShape(): SDE error. 
> SE_stream_fetch(): Shape or row not found. (-22) 
> 
> Can anyone suggest what might be wrong?  Is querying an SDE 
> layer with Mapserver different in some way from querying 
> anything else (shapefile)?
> 
> Below is my mapfile and template file (test.html)
> 
> Thanks,
> D. Pagurek
> 
> #
> # Start of map file
> #
> NAME META
> SIZE 500 434
> EXTENT -2647393 5656194 2892379 10462762
> UNITS METERS
> 
> IMAGECOLOR 255 255 255
> 
> # Start of web interface definition
> #
> WEB
> TEMPLATE 'meta.html'
>   IMAGEPATH '/usr/www/httpd/htdocs/mapdata/tmp/'
>   IMAGEURL '/mapdata/tmp/'
> END
> 
> #
> # Start of legend
> #
> LEGEND
>   STATUS ON
>    OUTLINECOLOR 0 0 0
>    KEYSIZE 18 12
>    LABEL
>      TYPE BITMAP
>      SIZE SMALL
>      COLOR 0 0 0
>     END
>   END   #LEGEND
> 
> #
> # Start of scalebar
> #
> SCALEBAR
>   IMAGECOLOR 255 255 255
>   LABEL
>     COLOR 255 0 0
>     SIZE tiny
>   END  #LABEL
>   STYLE 1
>   SIZE 100 4
>   COLOR 153 153 153
>   UNITS meters
>   INTERVALS 3
> END   #SCALEBAR
> 
> #
> # Start of layer definitions
> LAYER
>   NAME surveys
>   TYPE polygon
>   STATUS DEFAULT
>   CONNECTIONTYPE sde
>   CONNECTION "myserver.gis.agr.ca,esri_sde,ORACLE,meta,mapper"
>   DATA "SURVEYINDEX,shape"
> TEMPLATE "test.html"
>   CLASSITEM 'STATUS'
>       CLASS
>         EXPRESSION 'NOT SURVEYED'
>         NAME 'Not Surveyed'
>         COLOR 153 153 153
>         OUTLINECOLOR 0 0 0
>       END
>       CLASS
>         EXPRESSION 'NOT DIGITAL'
>         NAME 'Not Digital'
>         COLOR 153 0 51
>         OUTLINECOLOR 0 0 0
>       END
>       CLASS
>         EXPRESSION 'NOT ONLINE'
>         NAME 'Not Online'
>         COLOR 255 0 0
>         OUTLINECOLOR 0 0 0
>       END
>       CLASS
>         EXPRESSION 'INCOMPLETE'
>         NAME 'Incomplete'
>         COLOR 255 255 0
>         OUTLINECOLOR 0 0 0
>       END
>       CLASS
>         EXPRESSION 'COMPLETE'
>         NAME 'Complete'
>         COLOR 51 255 0
>         OUTLINECOLOR 0 0 0
>       END
>       CLASS
>         EXPRESSION 'WATER'
>         NAME 'Water'
>         COLOR 0 0 255
>         OUTLINECOLOR 0 0 0
>       END
>  TOLERANCEUNITS METERS
>  TOLERANCE 3
> 
> END  # LAYER
> 
> END  # MAPFILE
> 
> 
> 
> My template file isn't coming up at all, instead I get the 
> above error message. But here's what it looks like:
> 
> <html>
> <body>
> <b>SEARCH WINDOW</b>: [imgext]<br>
> <b>QUERY POINT</b>: ([img.x], [img.y]) image coordinates or 
> ([mapx], [mapy]) map coordinates<br> <p>
> 
> INDEX_ID=[INDEX_ID]<br>
> STATUS=[STATUS]<br>
> 
> </body>
> </html>
> 
> 
> 
> 
> 
> 
> 