AnsweredAssumed Answered

Filter list of values - Choose Description but code sent to database

Question asked by ionarawilson on Jul 2, 2013
Latest reply on Jul 8, 2013 by myn@bjtu

Like • Show 0 Likes0
Comment • 15

I am a newbie to Python but eager to learn. I need to create tools in ArcMap to enter and edit data. Users will need to enter for example the name of the office they work, so I created domains for that. So let's say the user completed a task in Alpine, then he would enter Alpine in the drop-down box. So for each office there is a domain. For example:

Code   Description

AL       Alpine
AU      Austin
CA      Carthage

And so on...

The problem is that I need the user to see the description in the dropdown box but the code to be sent to the database when he chooses an office name. So for example he would choose Austin, but the database would record AU in the office field.

The way it is now, when I create the parameters using the out-of-the-box properties of the script, I have to use the Filter and enter a value list. However, if I use the description value in the list of values (which is want I want) , this description will be recorded in the table. For example if the user chooses Austin, Austin would be recorded in the database, instead of AU. Is there a way to change this? I was reading about tool validators but I have no idea how to use it. Thank you for any help you can provide!

stacyrendall Jul 3, 2013 2:04 PM

Correct Answer

Ionara, I will elaborate on mzcoyles solution, as it is the right one for this situation.

A Python dictionary is a way of storing information under 'keys'. A dictionary will return a value when supplied the correct key. For example, a dictionary of phone numbers (name is key, phone number is value):

>>> phoneBook = {'Bob': 4566461, 'Jane': 8954556}

The dictionary is constructed by wrapping it in curly braces. The names are strings, so they have quotes around them, while the numbers are stored as numbers. The : indicates that the value corresponds to the key.

If I query the phoneBook dictionary with the key for Bob, his name, it will return his phone number:

>>> phoneBook['Bob'] 4566461

So, in your case, something like this should work:

 # userValue represents what the user selected, i.e. userValue = 'Alpine'  officeCodeDict = {'Alpine': 'AL', 'Austin': 'AU', 'Carthage': 'CA'}  # databaseValue is what you send to the database databaseValue = officeCodeDict[userValue]  # so, if userValue is Alpine, databaseValue is AL

Hope this helps.

See the reply in context

No one else had this question

Outcomes

15 Replies

mzcoyle Jul 2, 2013 6:25 AM
Mark Correct
Correct Answer
Just use a dictionary with the domain value/description so you can reference one with the other.
Like • Show 0 Likes0
Actions
ionarawilson Jul 2, 2013 8:33 AM
Mark Correct
Correct Answer
Thank you Matthew, but can you be a little more specific? Do you have any similar examples? thanks!
Like • Show 0 Likes0
Actions
rzufelt Jul 2, 2013 10:26 AM
Mark Correct
Correct Answer
Ionara,

Really don't make tools, so not sure what an editing tool would do. Since it will be running in ArcMap, if there is a way to open the Attribute window (from editor) (perhaps a template mxd with your tool), then they would be able to pick all the domain values directly from the dropdown in the attribute window itself.

Would be active for either selected features, or newly created features.

not sure if this helps at all, just thougth I'd point it out if you weren't already familiar with it.

R_
Like • Show 0 Likes0
Actions
ionarawilson Jul 3, 2013 8:07 AM
Mark Correct
Correct Answer
rzufelt,

I know we could use that, but we want to make sure the users will be entering all the records. Creating a tool insures that because the script does not run if they don't choose all the parameters but an user can leave a record blank when editing the feature in the table of attributes. At least I haven't found a good way to prevent that. Thanks
Like • Show 0 Likes0
Actions
rzufelt Jul 3, 2013 8:34 AM
Mark Correct
Correct Answer
Only way I can think of would be when you create the fields, set it to not allow null values. This way, "something" would have to be entered, but could be anything that meets the field type, would not be restricted to your list (except, of course, for the fields that have a domain on them).

R_
Like • Show 0 Likes0
Actions
stacyrendall Jul 3, 2013 2:04 PM
Unmark Correct
Correct Answer
Ionara, I will elaborate on mzcoyles solution, as it is the right one for this situation.

A Python dictionary is a way of storing information under 'keys'. A dictionary will return a value when supplied the correct key. For example, a dictionary of phone numbers (name is key, phone number is value):
```
>>> phoneBook = {'Bob': 4566461, 'Jane': 8954556}
```
The dictionary is constructed by wrapping it in curly braces. The names are strings, so they have quotes around them, while the numbers are stored as numbers. The : indicates that the value corresponds to the key.

If I query the phoneBook dictionary with the key for Bob, his name, it will return his phone number:
```
>>> phoneBook['Bob'] 4566461
```
So, in your case, something like this should work:
```
 # userValue represents what the user selected, i.e. userValue = 'Alpine'  officeCodeDict = {'Alpine': 'AL', 'Austin': 'AU', 'Carthage': 'CA'}  # databaseValue is what you send to the database databaseValue = officeCodeDict[userValue]  # so, if userValue is Alpine, databaseValue is AL
```
Hope this helps.
Like • Show 0 Likes0
Actions

rzufelt Jul 3, 2013 2:10 PM

and to check if the key exists then do something, I use this:

         if (officeCodeDict.has_key(userValue)):
             myVal= siteDict[userValue]
         else:
             print "not an acceptable value"

Actions

ionarawilson Jul 5, 2013 9:47 AM

Thank you Stacy and Rhett. You guys are awesome!!!:o



#Sets parameters (attributes)
    Office =  gp.GetParameterAsText(0)

    Forester = gp.GetParameterAsText(1)
    Status =  gp.GetParameterAsText(2)

    officeDomain = {'Alpine': 'AL', 'Austin': 'AU', 'Carthage': 'CA', 'Corpus Christi': 'CC', 'Conroe': 'CO', 'Crockett': 'CR',
                      'Crockett':'CR', 'College Station': 'CS', 'Canyon': 'CY', 'Dallas': 'DA', 'El Paso': 'EP', 'Fort Worth': 'FW',
                      'Gilmer': 'GI', 'Granbury': 'GR', 'Hamilton': 'HA', 'Henderson': 'HE'}
    officeCode= officeDomain[Office]
    foresterDomain = {'Brittany Compton': 'bcompton', 'Brian Pope': 'bpope', 'Buster Robinson': 'brobinson',
                        'Clay Bales': 'cbales', 'Daniel Duncum': 'dduncum', 'Daniel Lewis': 'dlewis'}
    foresterCode = foresterDomain[Forester]



#Create Update Cursor
    rows = arcpy.UpdateCursor("Stewardship")

    #Update Forester
    for row in rows:


        if (officeDomain.has_key(Office)):
            row.Office = officeCode
            rows.updateRow(row)

Actions

ionarawilson Jul 5, 2013 9:51 AM
Mark Correct
Correct Answer
Also, one last question: Do I have to create an update cursor fo every field? I tried having just one update cursor for all fields and it works but does that cause data locks? Should I create one cursor for each cursor and keep deleting the rows so as to remove data locks? Thank you!!!
Like • Show 0 Likes0
Actions

stacyrendall Jul 5, 2013 4:53 PM

Hi Ionara,

Issues with data locks are not a result of updating multiple fields at the same time (I mean, they are just as likely to be an issue for multiple fields as one field).

You can definitely update multiple rows. If you have 10.1, I recommend you use da.UpdateCursor in conjunction with the with statement, described here. Using the with statement guarantees that data locks are cleared. You can use it like so:

    #Create Update Cursor
    with arcpy.da.UpdateCursor("Stewardship", (Office, Forester)) as rows:
        # row comes back as a tuple in the order specified here, so Office is row[0], Foester is row[1]
        for row in rows:
            row[0] = officeCode
            row[1] = foresterCode
            rows.updateRow(row)

When it leaves the indented block it will clear up any data locks on the feature class.

If you are using 10.0 you can update multiple rows like this:

    #Create Update Cursor
    rows = arcpy.UpdateCursor("Stewardship")
    for row in rows:
        row.Office = officeCode
        row.Forester = foresterCode
        rows.updateRow(row)

I removed your check for key validity (if (officeDomain.has_key(Office)):). You mentioned that the values come from a dropdown list, so you have control over what values the user can possibly select, and thus they cannot enter a value that isn't in the dictionary...

If the user is entering text, instead, you could do something like this, which will print out an error message and exit the script if they enter an invalid value (note that I have also put the dictionary creation at the top as you only need this to happen once each time the script runs):

# set up the dictionaries
officeDomain = {'Alpine': 'AL', 'Austin': 'AU', 'Carthage': 'CA', 'Corpus Christi': 'CC', 'Conroe': 'CO', 'Crockett': 'CR',
                      'Crockett':'CR', 'College Station': 'CS', 'Canyon': 'CY', 'Dallas': 'DA', 'El Paso': 'EP', 'Fort Worth': 'FW',
                      'Gilmer': 'GI', 'Granbury': 'GR', 'Hamilton': 'HA', 'Henderson': 'HE'}
foresterDomain = {'Brittany Compton': 'bcompton', 'Brian Pope': 'bpope', 'Buster Robinson': 'brobinson',
                      'Clay Bales': 'cbales', 'Daniel Duncum': 'dduncum', 'Daniel Lewis': 'dlewis'}

#Sets parameters (attributes)
Office =  gp.GetParameterAsText(0)
Forester = gp.GetParameterAsText(1)
Status =  gp.GetParameterAsText(2)

# check parameters are valid    
if officeDomain.has_key(Office):
    officeCode= officeDomain[Office]
else:
    arcpy.AddMessage('ERROR: Invalid value entered for Office: %s' % Office)
    exit()
if foresterDomain.has_key(Forester):
    foresterCode = foresterDomain[Forester]
else:
    arcpy.AddMessage('ERROR: Invalid value entered for Forester: %s' % Forester)
    exit()

## Cursors, etc.

Hope this helps...

Actions

ionarawilson Jul 8, 2013 6:12 AM

HI Stacy,

I tried your first option as I am using 10.1 but I am getting an error message.

Here is the code

##################################################
#
#
#Script:  Attribute Table for reporting (Stewardship)
#

##################################################

#Import modules
import os, sys, arcpy, traceback, arcgisscripting

#Set Map Document
mxd = arcpy.mapping.MapDocument("Current")

#Set Overwrite Option
arcpy.env.overwriteOutput = True


df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]

gp = arcgisscripting.create(10.1)
#del row
#del rows
try:
#Sets parameters (attributes)
    Office =  gp.GetParameterAsText(0)

    Forester = gp.GetParameterAsText(1)


    officeDomain = {'Alpine': 'AL', 'Austin': 'AU', 'Carthage': 'CA', 'Corpus Christi': 'CC', 'Conroe': 'CO', 'Crockett': 'CR',
                      'Crockett':'CR', 'College Station': 'CS', 'Canyon': 'CY', 'Dallas': 'DA', 'El Paso': 'EP', 'Fort Worth': 'FW',
                      'Gilmer': 'GI', 'Granbury': 'GR', 'Hamilton': 'HA', 'Henderson': 'HE'}
    officeCode= officeDomain[Office]
    foresterDomain = {'Brittany Compton': 'bcompton', 'Brian Pope': 'bpope', 'Buster Robinson': 'brobinson',
                        'Clay Bales': 'cbales', 'Daniel Duncum': 'dduncum', 'Daniel Lewis': 'dlewis'}
    foresterCode = foresterDomain[Forester]



#Create Update Cursor
    with arcpy.da.UpdateCursor("Stewardship", (Office, Forester)) as rows:
        # row comes back as a tuple in the order specified here, so Office is row[0], Forester is row[1]
        for row in rows:
            row[0] = officeCode
            row[1] = foresterCode
            rows.updateRow(row)


    #Refresh Map to reflect Changes
    arcpy.RefreshActiveView()
    mxd.save()

    del mxd,

except:


    tb = sys.exc_info()[2]
    tbinfo = traceback.format_tb(tb)[0]
    pymsg = "PYTHON ERRORS:\nTraceback Info:\n" + tbinfo + "\nError Info:\n     " +        str(sys.exc_type) + ": " + str(sys.exc_value) + "\n"
    msgs = "ARCPY ERRORS:\n" + arcpy.GetMessages(2) + "\n"

    arcpy.AddError(msgs)
    arcpy.AddError(pymsg)

    print msgs
    print pymsg

    arcpy.AddMessage(arcpy.GetMessages(1))
    print arcpy.GetMessages(1)

Here is the error - Austin is one of the options to choose for the office input in the dropdown box:

Start Time: Mon Jul 08 09:07:36 2013
Running script Stewardship32...
ARCPY ERRORS:


PYTHON ERRORS:
Traceback Info:
  File "D:\ArcGISData\SARS\Python_10April2013\BoundaryReporting_26March2013_changes_july2013_added_domain_changed_again.py", line 49, in <module>
    for row in rows:

Error Info:
     <type 'exceptions.RuntimeError'>: Cannot find field 'Austin'

Actions

ionarawilson Jul 8, 2013 6:37 AM
Mark Correct
Correct Answer
Thank you so much Stacy! I just need to have parenthesis around the field names!!!!
```
   with arcpy.da.UpdateCursor("Stewardship", ("Office", "Forester")) as rows
```
Like • Show 0 Likes0
Actions
ionarawilson Jul 8, 2013 7:48 AM
Mark Correct
Correct Answer
I have another question about other data types but I will start a new thread! Thanks again!
Like • Show 0 Likes0
Actions
stacyrendall Jul 8, 2013 2:11 PM
Mark Correct
Correct Answer
Great! Yeah, sorry, I forgot to add the quotes!
Like • Show 0 Likes0
Actions
myn@bjtu Jul 8, 2013 10:23 PM
Mark Correct
Correct Answer
Hello,mzcoyle.
I am not going to answer your question,but ask you some question about arcpy.
when you answer others' threads, you mentioned that "most of the the arcpy modules are only the python interface into the geoprocessor .dlls".
As i am confused of how arcpy make it possible for python to perform GIS functions, so i want to ask you that :
arcpy only import GIS functions and package them and finally give us interface to use in python programming�?
am i right�?
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Filter list of values - Choose Description but code sent to database

Outcomes

Related Content

Recommended Content