Drainage Structure Table

[Joe-Bouza]

I am trying to duplicate a structure table for a client and they like to have the following matrix with the associated size. I thought I could write a few expressions to filter out the various sizes thusly as an example

IF({Pipe Inner Diameter or Width}>1.5,-1,{Pipe Inner Diameter or Width}) I would then supress the negative values from displaying. There are two problems. I started with an OOTB structure and pipe table.

1. when I set the cell to contain structure outflow pipes, the data properties appears to up date but then reverts to the default "structure text" (yes I pressed the arrow =>

2. when in the style composer the parameter list does not list the newly create expressions

This seems like it should be doable. where am I wrong?

[sirjoelsph]

Joe,

I was able to get this idea to work for structure diameter in a structure table or pipe diameter in a pipe table, but not a pipe diameter in a structure table like you're going for.  I've seen a lot of complaints about the two not working back and forth with each other.  Let's gang up and get them to finally let us do this kind of thing!

You might be able to get closer to what you're looking for using a pipe table and use pipe start station, pipe start offset, and pipe start structure for your first few columns.

[Joe-Bouza]

Thanks Joel, I came upon that too and though ok I'll use two tables and wouldn't you know it they don't line up! What the F#$@?

[sirjoelsph · Accepted solution]

I've tried something like that before too Joe.  It's your inches sign under size and foot sign under length that make the rows taller.  Parenthesis have the same effect.  Maybe add a foot sign under offset?

[Joe-Bouza]

Hi Joel

Thanks. that was a good observation.

Adding the foot tic makes it better but still not a perfect match? The further down the table to mismatch get worse.

[jmayo-EE · Accepted solution]

Gotta get the inch character in there as well. No size in the first table.

[Joe-Bouza]

Rats!

but good call. I took the size col out because it would be redundant anyway. Still off?

[Joe-Bouza]

Finally got it. the titles had different fonts

[jmayo-EE]

In my best Bill & Ted, 'Excellent!"

[Joe-Bouza]

Next Challenge: The next part of the table continues with columns for county structure type, and the rows report the structure depth. Again I created expressions for each type. I cannot find away to read the description in the expression builder so I am reading the insideStructerWidth and length.

So I have structures A,B,C and X all with different dimensions LXW 48x30, 48x48, 72x48 and 96x48. I wrote an expression for each and used the expression in the corresponding column, True shows RimToSump and False shows-1, then I hide negative values.

in pseudo code I wrote, for example: If( L=4 and W=4,RimToSump, -1), and all my type B 48x48 are blank,. Is my logic correct?