topic Re: Filter list of values - Choose Description but code sent to database in Python Questions

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

ionarawilson1 — Tue, 02 Jul 2013 13:02:51 GMT

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!

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

MathewCoyle — Tue, 02 Jul 2013 13:25:28 GMT

Just use a dictionary with the domain value/description so you can reference one with the other.

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

ionarawilson1 — Tue, 02 Jul 2013 15:33:17 GMT

Thank you Matthew, but can you be a little more specific? Do you have any similar examples? thanks!

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

RhettZufelt — Tue, 02 Jul 2013 17:26:40 GMT

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_

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

ionarawilson1 — Wed, 03 Jul 2013 15:07:50 GMT

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

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

RhettZufelt — Wed, 03 Jul 2013 15:34:00 GMT

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_

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

StacyRendall1 — Wed, 03 Jul 2013 21:04:32 GMT

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.

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

RhettZufelt — Sat, 11 Dec 2021 06:44:45 GMT

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"

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

ionarawilson1 — Sat, 11 Dec 2021 06:44:48 GMT

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)

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

ionarawilson1 — Fri, 05 Jul 2013 16:51:02 GMT

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!!!

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

StacyRendall1 — Sat, 11 Dec 2021 06:44:51 GMT

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...

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

ionarawilson1 — Sat, 11 Dec 2021 06:44:53 GMT

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'

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

ionarawilson1 — Mon, 08 Jul 2013 13:37:00 GMT

Thank you so much Stacy! I just need to have parenthesis around the field names!!!!

   with arcpy.da.UpdateCursor("Stewardship", ("Office", "Forester")) as rows

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

ionarawilson1 — Mon, 08 Jul 2013 14:48:20 GMT

I have another question about other data types but I will start a new thread! Thanks again!

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

StacyRendall1 — Mon, 08 Jul 2013 21:11:56 GMT

Great! Yeah, sorry, I forgot to add the quotes!

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

miaoyananmiao — Tue, 09 Jul 2013 05:23:15 GMT

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�?