Hopefully this is fairly simple to answer:
I have numeric values [St_NUMB] I'm adding as labels. I see that Map is converting them to strings [TOSTRING"(ST_NUMB)"]. The ST_Numb refers to a street number for a a house, and any outbuildings are labels as '0' (zero) since they are not technically an addressable structure. I have a large amount of data with a value of '0' (zero) that I would like to filter out of the labels. I'm really not sure what expression or command is the simplest to use.
Thanks in advance.
Brian
Hello
In your SDF, SHP, SQLite, Oracle, etc Table, the ST_NUMB Field is :
Number/Interger?
OR
Character/Varchar ?
Have you some A-Z chars (or other non numeric chars) after the numbers ?
Some samples (as I can imagine) : 0123 , 00456A , 00789 AB , etc
Bye, Pat
Patrice BRAUD
Hi,
create two rules in the display manager, the first with the filter-expression St_NUMB = 0 (that does not show a label) and the other as the default "Standard".
- alfred -
Hi,
in the label, you can use this expression
If ( ' St_NUMB = 0 ' , '', ToString ( St_NUMB) )
Olivier
Can't find what you're looking for? Ask the community or share your knowledge.