Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Geoserver 2.2.4 to support WMS queries. All testing is done via the "Layer Preview" page.

If I send a request with no CQL a map full of points is returned as expected.

If I add a CQL filter the map that is returned has the wrong number of points. That is, I get about 50 points on the map when the underlying SQL query (pulled from the log and executed separately) returns over 1200 points.

In both cases the same style is used. The only difference is the use of a CQL filter.

How can I get all 1200 points displayed on the map?

share|improve this question
up vote 0 down vote accepted

This turned out to be user error. The layer information was being read from the production database while my execution of the generated SQL was against the test database. The databases were out of sync.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.