Excluding Multiple Words from Labeling

MichaelTrevino — Tue, 07 May 2013 15:06:22 GMT

I want to be able to label my streets with defined classes so I get FSC = 'Freeway' in my SQL query but, I also want the query to exclude any labels like OFFRAMP, ONRAMP, FRONTAGE, ect. I can get the query to exclude one or the other for example:
FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%RAMP%' will exclude all the 'RAMP' but when I go to add the frontage to the query it makes the '%RAMP'% query no longer work. How do I get both not to show up and preserve my main FSC = 'Freeway' query?

(FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%RAMP%' ) OR (FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%FRONTAGE%')

This didn't work either.

Thanks for any help.

Mike T

Re: Excluding Multiple Words from Labeling

RobertBorchert — Tue, 07 May 2013 15:31:31 GMT

Depending on where you get your data from roads should or may have a road classification system built in.

Normally a 2 digit number 01 = Interstate 02= Federal Highway. Further down the list 22 = Ramp 19 = Frontage Road.

If that attribute exists in your data I would suggest building your query to tell it to only label the particular class.

In my state the attribute is called RTE_Syst as per our DOT

If your roads don't have this classification system built in I would suggest taking the time to do so as you may find a lot of other utility for its use.

I want to be able to label my streets with defined classes so I get FSC = 'Freeway' in my SQL query but, I also want the query to exclude any labels like OFFRAMP, ONRAMP, FRONTAGE, ect. I can get the query to exclude one or the other for example:
FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%RAMP%' will exclude all the 'RAMP' but when I go to add the frontage to the query it makes the '%RAMP'% query no longer work. How do I get both not to show up and preserve my main FSC = 'Freeway' query?

(FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%RAMP%' ) OR (FSC = 'FREEWAY' AND NOT FULL_NAME LIKE '%FRONTAGE%')

This didn't work either.

Thanks for any help.

Mike T

topic Re: Excluding Multiple Words from Labeling in Mapping Questions

Excluding Multiple Words from Labeling

Re: Excluding Multiple Words from Labeling