expression to assign roads to codes???

[ouspensky]

Hi I want to do something similar to a LOOKUP or Reclassify. I have an autoCAD file of road centerlines I have exported to SDF with three different colors 10,162, and 256. Now what I want to do is read them into infraworks assigning a road type to each color.

so I want to write an expression similar to:

IF COLOR =10 THEN 'Arterial' IF COLOR =162 THEN 'SubArterial' IF COLOR =256 THEN 'Local' in QGIS I would write the following SQL: CASE( WHEN "COLOR" = 10 Then 'Arterial'.... how to do a similar reclass in Infraworks???

[BrianHailey]

I wrote a blog post on this very subject not too long ago. You can read it HERE.

[ouspensky]

thanks but your blog site is blocked in China

[BrianHailey]

Hmmmm, the link in my post doesn't work for me either. Try THIS.