I noticed that there's startdate and enddate properties in that query -
they're not in the SLD so I dont know where they're comming from.
This is the query I get in geoserver:
[NOT [ startdate > 1.146720145436E12 ] AND NOT [[ eventstatus = Closed ]
AND [ enddate < 1.145424145436E12 ]] AND NOT [ eventstatus = Deleted ]
AND NOT [ eventtype = Compliment ] AND NOT [ eventtype = Complaint ] AND
NOT [ eventtype = Damage Report ] AND [[ the_geom bbox POLYGON
((176.1039553337146 -40.512543813021594, 176.1039553337146
-40.2205693364445, 176.55869762498062 -40.2205693364445,
176.55869762498062 -40.512543813021594, 176.1039553337146
-40.512543813021594)) ] AND [[[[[[[[[[[[[[[[[[[[[[ eventtype = Road Work
] AND [ eventstatus = Active ]] OR [[ eventtype = Road Work ] AND [
eventstatus = Closed ]]] OR [[ eventtype = Road Work ] AND [ eventstatus
= Deleted ]]] OR [[ eventtype = Road Hazard ] AND [ official = true ]
AND [ eventstatus = Active ]]] OR [[ eventtype = Road Hazard ] AND [
official = true ] AND [ eventstatus = Closed ]]] OR [[ eventtype = Road
Hazard ] AND [ official = true ] AND [ eventstatus = Deleted ]]] OR [[
eventtype = Road Hazard ] AND [ official = false ] AND [ eventstatus =
Active ]]] OR [[ eventtype = Road Hazard ] AND [ official = false ] AND
[ eventstatus = Closed ]]] OR [[ eventtype = Road Hazard ] AND [
official = false ] AND [ eventstatus = Deleted ]]] OR [[ eventtype =
Area Warning ] AND [ eventstatus = Active ]]] OR [[ eventtype = Area
Warning ] AND [ eventstatus = Closed ]]] OR [[ eventtype = Area Warning
] AND [ eventstatus = Deleted ]]] OR [[ eventtype = Compliment ] AND [[
eventstatus = Received ] OR [ eventstatus = Escalated ]]]] OR [[
eventtype = Compliment ] AND [ eventstatus = Closed ]]] OR [[ eventtype
= Compliment ] AND [ eventstatus = Deleted ]]] OR [[ eventtype =
Complaint ] AND [[ eventstatus = Received ] OR [ eventstatus = Escalated
]]]] OR [[ eventtype = Complaint ] AND [ eventstatus = Closed ]]] OR [[
eventtype = Complaint ] AND [ eventstatus = Deleted ]]] OR [[ eventtype
= Damage Report ] AND [[ eventstatus = Received ] OR [ eventstatus =
Escalated ]]]] OR [[ eventtype = Damage Report ] AND [ eventstatus =
Closed ]]] OR [[ eventtype = Damage Report ] AND [ eventstatus = Deleted
]]]]]
and the sql:
149438 [FINE] org.geotools.data.jdbc.JDBC1DataStore - sql is SELECT
"eventtype", "eventstatus", "official",
encode(AsBinary(force_2d("the_geom"), 'XDR'),'base64') FROM
"public"."test_data" WHERE ( NOT ("startdate" > 1.146720145436E12) AND
NOT (("eventstatus" = 'Closed' AND "enddate" < 1.145424145436E12)) AND
NOT ("eventstatus" = 'Deleted') AND NOT ("eventtype" = 'Compliment')
AND NOT ("eventtype" = 'Complaint') AND NOT ("eventtype" = 'Damage
Report') AND ("the_geom" && GeometryFromText('POLYGON
((176.1039553337146 -40.512543813021594, 176.1039553337146
-40.2205693364445, 176.55869762498062 -40.2205693364445,
176.55869762498062 -40.512543813021594, 176.1039553337146
-40.512543813021594))', 1) AND ((((((((((((((((((((("eventtype" = 'Road
Work' AND "eventstatus" = 'Active') OR ("eventtype" = 'Road Work' AND
"eventstatus" = 'Closed')) OR ("eventtype" = 'Road Work' AND
"eventstatus" = 'Deleted')) OR ("eventtype" = 'Road Hazard' AND
"official" = 'true' AND "eventstatus" = 'Active')) OR ("eventtype" =
'Road Hazard' AND "official" = 'true' AND "eventstatus" = 'Closed')) OR
("eventtype" = 'Road Hazard' AND "official" = 'true' AND "eventstatus" =
'Deleted')) OR ("eventtype" = 'Road Hazard' AND "official" = 'false' AND
"eventstatus" = 'Active')) OR ("eventtype" = 'Road Hazard' AND
"official" = 'false' AND "eventstatus" = 'Closed')) OR ("eventtype" =
'Road Hazard' AND "official" = 'false' AND "eventstatus" = 'Deleted'))
OR ("eventtype" = 'Area Warning' AND "eventstatus" = 'Active')) OR
("eventtype" = 'Area Warning' AND "eventstatus" = 'Closed')) OR
("eventtype" = 'Area Warning' AND "eventstatus" = 'Deleted')) OR
("eventtype" = 'Compliment' AND ("eventstatus" = 'Received' OR
"eventstatus" = 'Escalated'))) OR ("eventtype" = 'Compliment' AND
"eventstatus" = 'Closed')) OR ("eventtype" = 'Compliment' AND
"eventstatus" = 'Deleted')) OR ("eventtype" = 'Complaint' AND
("eventstatus" = 'Received' OR "eventstatus" = 'Escalated'))) OR
("eventtype" = 'Complaint' AND "eventstatus" = 'Closed')) OR
("eventtype" = 'Complaint' AND "eventstatus" = 'Deleted')) OR
("eventtype" = 'Damage Report' AND ("eventstatus" = 'Received' OR
"eventstatus" = 'Escalated'))) OR ("eventtype" = 'Damage Report' AND
"eventstatus" = 'Closed')) OR ("eventtype" = 'Damage Report' AND
"eventstatus" = 'Deleted'))))
which looks correct.
This could be a problem in 2.1.x thats been fixed in geotools 2.2.x (and
available in the next geoserver - I'm running it now). What version of
java are you running the geosever in?
dave
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
