Sunday, 24 April 2016

arcgis desktop - How to Label Field With Multiple Selected Values?


I have a shape named "Subdistrict" and it shown on Attribut Table like this :
No | subd | village
1 | town1 | v1
2 | town1 | v2
3 | town1 | v3

4 | town2 | v4
5 | town2 | v5
6 | town2 | v6
7 | town3 | v7
8 | town3 | v8
9 | town3 | v9


I want to select only town1 and town3, and only v1, v3, v7, v8
I've select define classes each class differentley and use SQL Querry to select only Village :v1,v3,v7,v8 to shown on label, but it's not working.
this is my SQL querry code :


subd= 'town1' AND 'town3' AND village='v1' AND 'v3' AND 'v7' AND 'v8'


Any solution for this?



Answer



Your SQL query should be:


(subd = 'town1' or subd = 'town3') and village in ('v1','v3','v7','v8')


for only town1 with v1,v3..v8 and town3 with v1,v3..v8.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...