[Qgis-us-user] Capturing two records in a shape file
Rob Bacigalupi
rob at missionnorthmi.com
Mon Oct 5 09:27:59 PDT 2020
Keith:
Thanks again! Appreciate the help.
Best,
Rob
> On Oct 5, 2020, at 11:32 AM, Keith Jenkins <kgj2 at cornell.edu> wrote:
>
> Yes, I should have mentioned that you can also use this syntax, with
> as many values as you need:
>
> "ZTCA5CE10" IN ('zip code 1', 'zip code 2', 'zip code 3')
>
> Keith
>
> On Mon, Oct 5, 2020 at 11:13 AM Rob Bacigalupi <rob at missionnorthmi.com> wrote:
>>
>> Keith:
>>
>> Thank you! That worked. As a follow up, what if I wanted to identify 20 zip codes? There must be a more efficient way to do that with out going back and forth writing 20 different ‘OR’ statements.
>>
>> Best,
>> Rob
>>
>>> On Oct 5, 2020, at 11:05 AM, Keith Jenkins <kgj2 at cornell.edu> wrote:
>>>
>>> Hi, Rob.
>>>
>>> You'll want to phrase it like this:
>>> "ZTCA5CE10" = 'zip code 1' OR "ZTCA5CE10" = 'zip code 2'
>>>
>>> Also, note that it uses double quotes around the field name, and
>>> single quotes around the actual values.
>>>
>>> Cheers,
>>> Keith
>>>
>>> On Mon, Oct 5, 2020 at 10:58 AM Rob Bacigalupi <rob at missionnorthmi.com> wrote:
>>>>
>>>> Hi QGIS User Group:
>>>>
>>>> I am fairly new to QGIS and have what hopefully is a basic question. I’m using a zip code shape file from the US census for the entire US and would like to create a new layer with just two zip codes. When I go into properties/control feature symbology/add rule-based layer then go to create the filter, that’s where I run into trouble. I’ve tried creating an expression string as follows:
>>>>
>>>> “ZTCA5CE10 = “zip code 1” OR “zip code 2”
>>>>
>>>> but it only returns the first zip code.
>>>>
>>>> Any suggestions?
>>>>
>>>> Thanks,
>>>>
>>>> Rob
>>>> _______________________________________________
>>>> Qgis-us-user mailing list
>>>> Qgis-us-user at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/qgis-us-user
>>
More information about the Qgis-us-user
mailing list