[Chameleon] Problems with query on postgis layer
Jeremy Palmer
jpalmer at paradise.net.nz
Sun May 30 07:04:58 EDT 2004
Hi everyone,
Two questions:
1) I have a postgis polygon layer that is taking a long time query using
the query widget. Layers in ESRI shape files seem very quick, however but
the postgis layer takes a couple of minutes to return an answer.
Here is my layer, it maps correctly:
LAYER
NAME "parcels"
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=xxxx dbname=xxx host=localhost"
DATA "shape from parcel"
STATUS DEFAULT
TYPE POLYGON
DUMP true
template "blank.html"
MAXSCALE 20000
CLASS
EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' ne 'ROAD' and '[parcel_intent]' ne 'HYDR' )
NAME "CURR Parcels"
OUTLINECOLOR 0 0 0
END
CLASS
EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' eq 'ROAD')
NAME "CURR Road Parcels"
OUTLINECOLOR 0 0 0
COLOR 255 222 140
END
CLASS
EXPRESSION ('[status]' eq 'CURR' and '[toc_code]' eq 'PRIM' and
'[parcel_intent]' eq 'HYDR')
NAME "CURR Hydro Parcels"
OUTLINECOLOR 0 0 0
COLOR 161 189 234
END
END
2) When items are queried using the query widget is it possible to
highlight the point/polygon on the map for the user?
Thanks heaps
More information about the Chameleon
mailing list