[ka-Map-users] Searching on Oracle Spatial and hilite query features

Gupteshwar Joshi gupteshwar.joshi at gmail.com
Thu Feb 1 23:18:32 EST 2007


Hello Bryn,
I was also facing the same problem , but my side data is PostGIS .
So , when I tried to find the the problem ,I got that layer connectiontype
does
matter in this thing.
So, when I tried with the extra code as
if ($oLayer->connectiontype==6) (i.e. for postgis )
created some array of postgis layer and included that  in the
search code, now  I could  search in both shape file  and  postgis  data.
 If you could find that connection type for your data then it might work for

your side also.

Regards

On 2/2/07, bryn at brynr.ath.cx <bryn at brynr.ath.cx> wrote:
>
> Hi All,
>
> I have a question with regards to the ka-map search system.
> I have been able to successfully use it to search on a layer where the
> data source is a shapefile, however it doesn't seem to work on layers
> where the data source is an oracle database. I have no problems in
> actually showing the data with labels, I am just unable to search it!
>
> The relevant section of my map file is shown below in case it is something
> I'm not doing correctly here:
>
> LAYER
>         GROUP "Provcoupe"
>         NAME oracle_test
>         TYPE POLYGON
>         CONNECTIONTYPE oraclespatial
>         CONNECTION "*****/*****@*****"
>         DATA "SHAPE FROM PC_A USING UNIQUE FEATUREID"
>         DUMP TRUE
>         STATUS ON
>         TRANSPARENCY ALPHA
>         LABELITEM "Provcoupe"
>         PROJECTION
>                 "init=epsg:28355"
>         END
>         CLASS
>                 Name "Provcoupe"
>                 MAXSCALE 50001
>                 STYLE
>                         OUTLINECOLOR 0 0 0
>                         COLOR 0 128 128
>                         ANTIALIAS TRUE
>                 END
>                 LABEL
>                         ANTIALIAS TRUE
>                         COLOR 255 255 255
>                         SHADOWCOLOR 0 0 0
>                         SHADOWSIZE 1 1
>                         FONT "verdana"
>                         TYPE TRUETYPE
>                         POSITION AUTO
>                         PARTIALS FALSE
>                         SIZE 10
>                         BUFFER 1
>                 END
>         END
>         TEMPLATE "query_template.html"
>         METADATA
>                 opacity "65"
>                 queryable "true"
>                 searchfield "Provcoupe"
>                 fields "Provcoupe:Provcoupe"
>         END
> END
>
> Ultimately what I would like to be able to do is search for a feature,
> then by hitting the 'zoom to' button automatically highlight the selected
> feature.
> However, my attempts to highlight features only work with the query tool
> and then all I can get to (intermittently) work is having *only* the
> queried feature render on the QueryLayer (which is what I want), but the
> background colour is not transparent (ie I can't see the underlying
> layers).
>
> Any pointers or tips would be much appreciated.
>
> Regards,
> Bryn Roberts
>
> _______________________________________________
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ka-map-users
>



-- 
              (((())))
              (@ @)
                 (_)
+----oOO------------Ooo----------+
|      Gupteshwar D Joshi            |
|                                              |
+------------------------------------+
              |___|___|
                 | | | |
              ooO Ooo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ka-map-users/attachments/20070202/79a56477/attachment.html


More information about the ka-Map-users mailing list