Spot Elevation Comparison Grid from -/+ to C/F

[rjames94]

Is there anyway to change the spot elevation grid labels to use C (Cut) and F (Fill) instead of default positive and negative signs? I looked into the label settings and don't see a option for that or know of a way to customize it to get what I need. Let me know if there's any solution to this, thanks!

[Anonymous]

could you write an expression to do it? I don't have it open right now, can't check.

[rjames94]

I'm not very familiar with expressions. After some researching I found a way to color the text red/blue depending on if its a cut/fill. Still would like to add the C to all cuts and F to all fills.

[rl_jackson]

Could this be something that u could use Earthwork Plan Production on. It sets up a grid surface and provides all this information based on your defined grid size. I use it to calculate the amount of fill in a mound based on the 2 surfaces....

Maybe a image of what your working with would help.

[ChrisRS · Accepted solution]

I would use the expressions and the 'text height trick'

3 expressions: *
Label Text Height:   0.125/12                                                                               This is the desired text height in feet
Cut Text Height:      IF({Surface Elevation}>=0,{Label Text Height},0)        Text Height if in Cut, 0 if in Fill

Fill Text Height:       IF({Surface Elevation}>=0,{Label Text Height},0)        Text Height if in Fill, 0 if in Cut

The Label will require 3 components:

Conceptually, each label will read C:F:xx.xx, with either teh C: or F: text height set to 0 making the invisible.

Please note the Text height, Anchor Point and Attachment settings for each component.
Also note that the sign is dropped for the Surface Elevation component. 

* Strictly speaking, 'Label Text Height' expression is not needed. It is used as a constant that makes the other expressions more readable. Should you wish to chanfe this text height, it only needs to adjusted in one place.

Good luck.

[rjames94]

Still facing a few issues after applying your settings. Looking to use the spot elevations on grid to achieve what you show. Below is what I'm getting, also posted my settings. Am I missing something? Let me know, thanks.

[ChrisRS · Accepted solution]

1. Sorry, there is an embarrassing typo in my original post. 
   Cut Text Height should be "<", not ">=+":
         IF({Surface Elevation}<0,{Label Text Height},0)        Text Height if in Cut, 0 if in Fill
2. Fill Component (also my typo):
   General: Anchor Point: Middle right
   Text: Alignment: Middle left

I will post a correction.

Good Luck.

[rjames94]

Works beautifully. Thank you very much

[ChrisRS · Accepted solution]

This is a correction to Post 5 an discussed in Post 7

I would use the expressions and the 'text height trick'

3 expressions: *
Label Text Height:   0.125/12                                                                               This is the desired text height in feet
Cut Text Height:      IF({Surface Elevation}<0,{Label Text Height},0)          Text Height if in Cut, 0 if in Fill

Fill Text Height:       IF({Surface Elevation}>=0,{Label Text Height},0)        Text Height if in Fill, 0 if in Cut

The Label will require 3 components:

Conceptually, each label will read C:F:xx.xx, with either teh C: or F: text height set to 0 making the invisible.

Please note the Text height, Anchor Point and Attachment settings for each component.
Also note that the sign is dropped for the Surface Elevation component. 

* Strictly speaking, 'Label Text Height' expression is not needed. It is used as a constant that makes the other expressions more readable. Should you wish to change this text height, it only needs to adjusted in one place.

Good luck.