Jump to content

 
Photo

Case sensitive selection in ArcGIS

- - - - - ArcGIS

  • Please log in to reply
5 replies to this topic

#1
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,862 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

So I have a Personal Geodatabase in ArcGIS 10.0 where I ended up with some attribute values that are almost the same, but not exactly. The difference is that there's one bunch of features saying "other" and another one saying "Other" (and they're actually subtly different, I messed up, I know that's bad...)

 

When I tried to select [value] = 'other' it returned both sets of features. Turns out that ArcGIS is only doing case insensitive selections in Personal Geodatabases. Seriously ESRI?

 

Funny enough the symbolisation is working case sensitive!

 

Any suggestion on how I can get around this?


Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#2
jrat

jrat

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 143 posts
  • Gender:Male
  • Location:Hagerstown, MD
  • United States

Well, you could export your attribute table and use another editor that is case sensitive and replace one of your "o/Others" to something else. Then, join the table back to your FC and use the joined table to select the records to change, make your updates and trash the joined table.  You could use ObjectID as your join or create a temporary JoinID before you export the attribute table. You could use excel to find and replace all the 'others' to 'hey change this is Arcmap'.  excel has an option to match case while finding and replacing.



#3
Unit Seven

Unit Seven

    Legendary Contributor

  • Moderator
  • PipPipPipPipPip
  • 266 posts
  • Gender:Male
  • Location:New Zealand
  • New Zealand

Hey Hans,

 

ucase([VALUE]) = 'OTHER' should do what you are after. Or lcase([VALUE]) = 'other'.

 

Have to keep in mind Arc's selection all uses the SQL of the database being accessed—in the case of a personal it the same SQL as Access but if you were doing the same thing in an Oracle SDE database or File Geodatabase you need to change syntax accordingly.


S a m B r o w n

U N I T S E V E N
unit.seven@gmail.com

Miramar, Wellington
N E W Z E A L A N D

#4
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,862 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Thanks for the suggestions. I ended up just running it through FME, doing an update on the table itself.


Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#5
rudy

rudy

    Ultimate Contributor

  • Validated Member
  • PipPipPipPipPipPip
  • 739 posts
  • Gender:Male
  • Location:Canada
  • Canada

Hmmm. . . . not what I'm finding in 10.1 . . . seems to be case sensitive when going through Selection > Select by Attributes . . . .



#6
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,862 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Apparently it depends on the format your data is stored in (just like the use of ' vs " to identify text strings).


Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics





Also tagged with one or more of these keywords: ArcGIS

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->