topic Re: SDF Layer Style Rule Expression in AutoCAD Map 3D Forum

SDF Layer Style Rule Expression

townest — Thu, 08 Aug 2019 18:41:48 GMT

Hi,

I'm looking for cleaner layer rule expression syntax than the following sample:

ParcelNum = 'TL55682' OR ParcelNum = 'TL88956'

Something like:

ParcelNum = ('TL55682', 'TL88956')

You can see where I'm going with this...to include a large'ish arbitrary csv list that would be cleaner that repeating ParcelNum = XX OR.

Thank you.

Tyler

Map3d2019

Re: SDF Layer Style Rule Expression

Gary_Braun — Thu, 08 Aug 2019 18:50:27 GMT

Try ParcelNum IN ('TL55682', 'TL88956')

Re: SDF Layer Style Rule Expression

townest — Thu, 08 Aug 2019 19:11:50 GMT

Great. Thank you.

What language is the Map3d expression language, so I can learn more about it? I've perused documentation for language to no avail.

Tyler

Re: SDF Layer Style Rule Expression

Gary_Braun — Thu, 08 Aug 2019 19:23:31 GMT

Sorry but I don't know what language it is. Similar to SQL in some ways, but probably their own thing. As for learning more about it, I think their online reference is going to be your best bet.

https://knowledge.autodesk.com/support/autocad-map-3d/learn-explore/caas/CloudHelp/cloudhelp/2019/ENU/MAP3D-Use/files/GUID-81C2C69B-BABB-4716-BDF8-993C59FF2B99-htm.html

Re: SDF Layer Style Rule Expression

townest — Thu, 08 Aug 2019 19:38:44 GMT

Yeh, I've been through that, but it's rudimentary at best. I'm not even seeing your 'IN' solution.

@Gary_Braun, while I have you. Something that's been a severe disappointment is my inability to write expressions on more than one joined property. Say you have SDF of parcels joined to ODBC of parcel data (owner, tax, district, phone,etc). Try a simple label concat expression with joined properties (e.g. owner, phone) and the expression fails. I've presented this question before here and confirmed this behavior. But maybe you know a workaround. Joining data is the essence of GIS, so I'm having difficulty thinking this the end of the story.

FYI: The work around of bulk copy to another SDF thereby embedding the joined data is not really desirable.

Thank you.

Tyler

Re: SDF Layer Style Rule Expression

Gary_Braun — Thu, 08 Aug 2019 20:02:49 GMT

Yes it fails for me as well, and I don't have an answer.

All I can say is that as much as I love Map 3D, I do all of my GIS work in other software for many reasons, this being but one more of them.

Re: SDF Layer Style Rule Expression

ChicagoLooper — Mon, 12 Aug 2019 20:24:50 GMT

To match any value in a list, you can use the IN operator. You can find it in Create Query window (see image-1).

1-The IN operator can be found here.

To achieve your goal in a more elegant way, join two or more strings into one by using the CONCAT function.For example below, three strings have been joined to form a parcel label (see image-2).

parcelpin
mail_addr_
mail_zip

2-CONCAT function.

Use the line break '\P' to put the strings on separate lines. The line break is case sensitive.