Common Query Language (CQL) Tutorial

http://geoserver.org/display/GEOSDOC/Common+Query+Language+%28CQL%29+Tutorial+%28unfinished%29

point in random road

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=roads&CQL_FILTER=INTERSECT(gen_full,%20POINT%20(-89.397024%2031.065245))

point in washington square park:

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=poly_landmarks&CQL_FILTER=INTERSECT(the_geom,POINT(-73.99738%2040.73109))

Streets that cross a line near my office.

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=roads&CQL_FILTER=INTERSECT(gen_full,LINESTRING(-74.00747%2040.73971,-74.00775%2040.73454))

populations over 8 million

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=gnis_pop&CQL_FILTER=population%3E8000000

landmarks in a bbox near my apartment

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=poly_landmarks&CQL_FILTER=BBOX(the_geom,-73.99051,40.4039,-73.96132,40.67060)

This seems to be a well formed filter, it shows up fine in GeoServer, but it’s getting the same complaint as when we don’t have the name right:

http://sigma.openplans.org:8080/geoserver/wfs?service=WFS&request=GetFeature&typename=poly_landmarks&CQL_FILTER=cfcc+=+’D85’+AND+NOT+DISJOINT(the_geom,LINESTRING(-73.99051%2040.4039,-73.96132%2040.67060))
转载自：https://blog.csdn.net/nlslzf/article/details/83291902