topic Re: Intermediate Labelling Expressions in Map 3D in AutoCAD Map 3D Forum

Intermediate Labelling Expressions in Map 3D

AllDayBreakfast — Mon, 31 Oct 2022 22:56:17 GMT

I have a SHP file of a road network in AutoCAD Map 3D where I want to exclude road name labelling with the word 'private' or that of a particular value (which I can access in a list). Basically, any street name with the word "private" I do not want labelled. In ArcGIS Pro, this is easy: I choose the property I want (`STNAME`) and then in the SQL tab I choose the same expression where `STNAME` does not include the text `PRIVATE`

STNAME NOT LIKE '%PRIVATE%'

In Map 3D, this same expression returns an error "The operator syntax: 'NOT' is invalid. Click here to move the cursor to the error(9)". When I remove `NOT`, I get the error "Error: Result types are mismatched: the validation operation expected 'Text' but the expression returned 'Boolean'".

Any solutions on how to omit the entries I want that contain the specific words?

Re: Intermediate Labelling Expressions in Map 3D

parkr4st — Tue, 01 Nov 2022 10:48:49 GMT

can you post the data or a screen shot of a portion of the data table so we can see the format of STNAME?

Re: Intermediate Labelling Expressions in Map 3D

ChicagoLooper — Tue, 01 Nov 2022 11:27:35 GMT

@AllDayBreakfast Wrote

<<….Result types are mismatched: the validation operation expected 'Text' but the expression returned 'Boolean'".>>

Boolean sounds strange because Boolean should be ‘this’ or ‘that.’ For example, yes or no, 0 or 1. Another example is data attribute attribute named ‘Is_Private’ with values either TRUE or FALSE.

if your ‘STNAME’ attribute has names like Main St., County Blvd., City Ave. and River Rd (Private), then that’s not Boolean.

I’m with @parkr4st. Upload a screenshot, or the columns and rows, of the list, the database file (dbf). Even better would be to upload the shp, shx, dbf and prj files for evaluation.

Re: Intermediate Labelling Expressions in Map 3D

AllDayBreakfast — Tue, 01 Nov 2022 13:24:09 GMT

Sorry, I may have been confusing in my first post. There is no field/attribute named "In_Private". The field is STNAME and it contains text data of road names (which I'm using to label the data on the map). Some of the road names contain the word "private" in them. See picture below:

Notice that some of the names contain the word "private", and some don't. So when labelling my map, I'd like to exclude the road names that have that word in them.

The SHP file I'm using can be found here: https://opendata.citywindsor.ca/Uploads/Street%20Centreline_UTM83.zip (note that this link will download the zip file). The main site is here: City of Windsor Open Data Catalogue (citywindsor.ca)

Thank you for replying and trying to help!

Re: Intermediate Labelling Expressions in Map 3D

ChicagoLooper — Wed, 02 Nov 2022 01:40:56 GMT

Hello @AllDayBreakfast

Try it like this:

Here's the BEFORE and AFTER using the shapefile you uploaded in Post #4 of this thread.

Before....

After...

Re: Intermediate Labelling Expressions in Map 3D

Pointdump — Wed, 02 Nov 2022 07:49:29 GMT

Hi @AllDayBreakfast,
Following along with interest. Thanks for posting your data.
I tried just now to create 2 Thematic Rules, one without labels, one with:
NOT STNAME LIKE ' - PRIVATE'
STNAME LIKE ' - PRIVATE'
Seems to work.

EDIT: Zooming in, it still shows "- PRIVATE " Streets, so nope, this doesn't work.
Dave

Re: Intermediate Labelling Expressions in Map 3D

Pointdump — Wed, 02 Nov 2022 09:17:25 GMT

OK, using 2 Thematic Rules works this way:
STNAME LIKE '%PRIVATE%' [Feature Label:None]
NOT STNAME LIKE '%PRIVATE%' [Feature Label:Text]

Dave

Re: Intermediate Labelling Expressions in Map 3D

O_Eckmann — Wed, 02 Nov 2022 10:51:01 GMT

Hi @AllDayBreakfast ,

Correct expression in labelling is :

If ( ' STNAME LIKE ''%PRIVATE%'' ' , '', STNAME )

You should enclose boolean expression with ' ' to convert it into text format, and because you have a string in your condition, you need to double ' before and after it.

Olivier

Re: Intermediate Labelling Expressions in Map 3D

AllDayBreakfast — Wed, 02 Nov 2022 14:30:32 GMT

Thank you for the instructions! Although it isn't the label expression I'm looking for, I can see how it solves the problem because you're querying out the data I don't need anyway.

Thank you so much!

Re: Intermediate Labelling Expressions in Map 3D

AllDayBreakfast — Wed, 02 Nov 2022 14:32:25 GMT

Copied and pasted the code into the expression window and it worked! Thank you so much! I just wish I knew how to read the code so I can change aspects of it in the future. Regardless, I'm making this as solved.

Thank you!

Re: Intermediate Labelling Expressions in Map 3D

O_Eckmann — Wed, 02 Nov 2022 20:20:15 GMT

Hi @AllDayBreakfast ,

For exemple with numeric boolean test : NOLANE = 2 it could be written

if NOLANE = 2

then write label as text = '2'

else write label as text empty ( = '')

but Map 3D need only string info in the 3 members of condition if. So it should be written

if (' NOLANE = 2 ', '2', '')

Every term is enclosed with quote to ensure it's treated as string.

If your boolean condition works with string value, you should use double quote to enclose string value and keep quote to enclose boolean condition

For exemple to test ST_NAME = 'BROADWAY' you should write

if (' ST_NAME = ''BROADWAY'' ' , 'BROAD', 'NOT BROAD')

Hope it was clear enough.

Olivier