geoserver的ECQL查询

ECQL Reference — GeoServer 2.24.x User Manual

CQL and ECQL — GeoServer 2.24.x User Manual

ECQL是CQL的扩展，类似sql查询，比ogc的xml格式简单，可以应用在wfs和wms查询上。

通过可视化页面查看过滤效果，默认视图

主键不会出现在properties中，因此不能使用属性查询的方式

主键查询多个

主键查询多个

属性查询

属性模糊查询

数字字段的between范围查询

or

空间查询，要注意空间字段

&cql_filter=BBOX(geom,120.26924,31.90386,120.32910,31.92824,'EPSG:4326')

给定的多边形完全包含哪些，与CONTAINS语义相反

&cql_filter=WITHIN(geom, POLYGON(( 120.271837299803238 31.89261367615611 , 120.234190022869583 31.872563976946228,120.280059118903694 31.824387001866363 ,120.315687001672345 31.878045189679863, 120.271837299803238 31.89261367615611 )))

给定的多边形与哪些相交，包含完全含在里面的，与DISJOINT数据相反

&cql_filter=INTERSECTS(geom, POLYGON(( 120.271837299803238 31.89261367615611 , 120.234190022869583 31.872563976946228,120.280059118903694 31.824387001866363 ,120.315687001672345 31.878045189679863, 120.271837299803238 31.89261367615611 )))

与给定的多边形不相交的，与INTERSECTS数据相反

&cql_filter=DISJOINT(geom, POLYGON(( 120.271837299803238 31.89261367615611 , 120.234190022869583 31.872563976946228,120.280059118903694 31.824387001866363 ,120.315687001672345 31.878045189679863, 120.271837299803238 31.89261367615611 )))

与给定的多边形相交的，不包含完全含在里面的

&cql_filter=OVERLAPS(geom, POLYGON(( 120.271837299803238 31.89261367615611 , 120.234190022869583 31.872563976946228,120.280059118903694 31.824387001866363 ,120.315687001672345 31.878045189679863, 120.271837299803238 31.89261367615611 )))

哪些包含给定的多边形，与WITHIN语义相反

&cql_filter=CONTAINS(geom, POLYGON((120.277606997417578 31.876170037955209 , 120.270683360280358 31.867515491533677 , 120.284963361875882 31.857274278268196 ,120.277606997417578 31.876170037955209)))