Filtering records

[hgriesbauer]

Hi there, wondering if you could please help with an issue filtering records. I'm trying to filter VRI polygons that contain a specific tree species. The tree species is ponderosa pine, with a species code of "Py". I want to collect all VRI polygons where the 'LINE_3_TREE_SPECIES' column contains the substring "Py".

This fails:
bcdc_query_geodata("2ebb35d8-c82f-4a17-9c96-612ac3532d55") %>%
filter(grepl("Py",LINE_3_TREE_SPECIES,fixed=T))

As does this:
bcdc_query_geodata("2ebb35d8-c82f-4a17-9c96-612ac3532d55") %>%
filter(str_detect(LINE_3_TREE_SPECIES,"Py"))

I get the following error message: "There was an issue sending this WFS request", and a warning message "Named arguments ignored for SQL grepl".

How should I be coding this? Thanks!

[boshek]

@hgriesbauer it's not currently possible with bcdata mostly because it hasn't been implemented yet. You can see an open issue here: #227

[ateucher]

@hgriesbauer it's not implemented directly, but you can supply raw CQL and use the like keyword:

qry <- bcdc_query_geodata("2ebb35d8-c82f-4a17-9c96-612ac3532d55") %>%
  filter(CQL("LINE_3_TREE_SPECIES like '%Py%'"))