Labelling OSM question

1029
0
08-10-2012 12:07 AM
MatthewPegels
New Contributor
Hi all,

I have a question concerning labelling OSM data.
I want to label the US interstates (from the OSM data), where I use the following Sql statement:

SELECT * FROM roads WHERE
"fclass" = 'motorway'
and "ref" LIKE 'I %%%'

This statement gives me the interstates (see attachment), but I dont want to include the I in the symbology. Does someone know a way to exclude the I in the symbology? I guess this can be solved by editing the sql statement?

Thanks in advance.
Tags (2)
0 Kudos
0 Replies