Tag Archives: ArcPy

Ever wondered what layers reside in all my MXD’s? Is there a way to summarize each layers’ properties?

Here’s one way forward utilizing ArcGIS for Desktop and Python….

Working at Esri Australia in the Support and Training realm, we listen to numerous client’s requests, concerns and workflow issues. To keep abreast of how our technology is heading, one source I frequent is Continue reading

Error handling with Python – writing messages out to a text file (log file)

Debugging geoprocessing scripts in Python is never easy, especially when these scripts are run as a scheduled task.
I’ve had a number of requests of how to debug a scheduled python script (especially when issues occur), and write the output to a text file.

Please find below a simple python script that I hope will help others to debug their scripts: Continue reading

Formatting Python Strings for SQL Queries

One of the trickiest aspects of Python, especially for beginners, is string formatting, particularly building SQL statements for use in tools like Select_analysis or as a query parameter to MakeFeatureLayer. The combination of single- and double-quotes, along with using variables for field names and values, is enough to trip up the most experienced of programmers. Here’s a tip to make it a bit easier.

I find the easiest way to create dynamic SQL query strings in Python is to use the string formatting syntax (official documentation; clearer tutorial). As a quick overview, it means you can do something like:

variable_name = "I am a variable"
print "This string has a variable coming up next: %s" % variable_name

which prints

"This string has a variable coming up next: I am a variable"

So that’s exactly the same as saying

"This string has a variable coming up next: " + variable_name

Except it is a little more formal, and a little more clear in certain circumstances. In particular when you’re constructing long strings out of many variables, it’s a little easier to handle, e.g.

var_1 + " " + var_2 + " some static text " + var_3 + "!"


"%s %s some static text %s!"%(var_1,var_2,var_3)

It’s particularly handy for SQL queries which involve all that nasty '"'+var_1+'"'+"'"+val_1+"'" business! So in the most basic case you’d say

sql_query = '"%s" = \'%s\'' % (field_name,value_to_select)

Which, while still not easy on the eye, is a little more intelligible. Note the escaping-out of the single quotes around the %s because we used single quotes to define the string. You could just as easily use

sql_query = "\"%s\" = '%s'" % (field_name,value_to_select)

Up to you. You can expand the concept as needed to involve as many fields and variables as you need, and the result is basically always more readable than any combination of quotes, plusses, spaces, and backslashes!

There are more advanced methods for string formatting in Python, too; the link at the top is a good place to start.

It’s also worth noting that as of Python 2.6 (used in ArcGIS 10.0), the method of string formatting discussed in this post is technically old hat. If you’re using ArcGIS 10.0 and/or Python 2.6 or greater, you should be using the new str.format() method detailed here. To quote the documentation:

This method of string formatting is the new standard in Python 3.0, and should be preferred to the % formatting … in new code.

However, it’s not supported in Python versions <= 2.5, so if you’re in an ArcGIS 9.3.1 environment you’ll need to use the % formatting as detailed in this post. The % formatting will work just fine in 10.0, and will still work in code run under ArcGIS 10.1, which uses Python 2.7.

Thom M

Ozri Update: Cartography – Think Big!

The latest from Ozri

Hello from Melbourne. Thanks to everyone who made it out this morning to see Kellie and I talk about streamlining your cartography workflows.

Carto is definitely a favourite topic, for Kel and I, when we get started we can talk about mapping and visualisation for well.. hours. We did however, manage to distill what we wanted our session to convey. When it comes to cartography it’s time to Think Big! Continue reading