AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

exclude polygons from map matching the first 3 of 8 characters of a property

6 REPLIES 6
Reply
Message 1 of 7
Anonymous
568 Views, 6 Replies

exclude polygons from map matching the first 3 of 8 characters of a property

I've been searching in the discussion threads and the help menu but I am probably not searching the right keywords or something because I am sure this has been asked, I just cannot find it...

 

i have an attribute that is 8 characters long. I want to exclude from my map any polygons where the 8 digit property starts with '760' How do I do that? I tried to use a wildcard * but that didn't work. 

 

Thanks in advance!

 

Rebecca

6 REPLIES 6
Message 2 of 7
Murph_Map
in reply to: Anonymous

Are these attributtes from an FDO connection or blocks or object data tables? 

 

Murph
Supporting the troops daily.
Message 3 of 7
Anonymous
in reply to: Murph_Map

Thank you for the reply! 

 

They are from an FDO Connection. 

 

What I have is some parcels which I have queried to fit within a polyline I created. Several of the parcels have multiple polygons in one place. They did this to indicate parcel's Possessory Interest (PI; basically someone has taxable interest in the parcel but not ownership. The PI polygons have Parcel numbers that begin with 760 followed by the remaining 5 digits. I want to eliminate all of the PI parcels from my map so I am left with the just the ownership polygons. 

 

Rebecca

Message 4 of 7
Gary_Braun
in reply to: Anonymous

Right-click on your parcels layer in the Display Manager and select "Query to Filter Data...".

You need to create a query that looks similar to:

 

NOT (ParcelNumber LIKE '760%')

 

Replace ParcelNumber with whatever the correct attribute name is in your data, it should then filter your parcels and only display any that don't begin with 760.

Message 5 of 7
Anonymous
in reply to: Gary_Braun

Thank you Gary! It does not seem to like the NOT part of it. Can you tell what I am doing wrong from the screenshot?

Message 6 of 7
Gary_Braun
in reply to: Anonymous

Not completely sure, but you have two different criteria going on, one spatial and the second by attribute. Try add an AND before the NOT and see what happens.
Message 7 of 7
Anonymous
in reply to: Gary_Braun

I got it to work. Here is what I typed in case anyone needs to know. 

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report