[ka-Map-users] Searching on Oracle Spatial and hilite query
gupteshwar.joshi at gmail.com
Thu Feb 1 23:18:32 EST 2007
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
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.
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:
> 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"
> Name "Provcoupe"
> MAXSCALE 50001
> OUTLINECOLOR 0 0 0
> COLOR 0 128 128
> ANTIALIAS TRUE
> 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
> TEMPLATE "query_template.html"
> opacity "65"
> queryable "true"
> searchfield "Provcoupe"
> fields "Provcoupe:Provcoupe"
> 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
> 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
> Any pointers or tips would be much appreciated.
> Bryn Roberts
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
| Gupteshwar D Joshi |
| | | |
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the ka-Map-users