How best to split layer into groups based on search vector data queries?
Thousands of assessors parcels with many land use CAMA codes (MSLANDUSEC), but which can be broken into 9 basic groups. I've been doing this manually, but am now a volunteer on the Ellsworth Broadband Committee and receiving updated parcel files more frequently from the assessor, and would like to automate this process. I would also like to automate the styling of the new layers at the same time.
The manual approach that I've taken was to perform a Search Vector Data query, select all of the results, copy those results, place them on their own new layer, and then style. This would be done all all 9 major land use groups. For example, below is for the first group, 1000 - Residential, using the following query:
%MSLANDUSEC% >= 1000 and %MSLANDUSEC% < 2000
Before reaching out here on the forum for guidance, I tried and failed:
Thank you in advance for how best to split layer into groups based on search vector data queries.