Latest Contributions by MathewCoyle

It depends on the securities you have. Can you just reference the file system of your remote DB server? Have you referenced your remote DB on your application server? Have you gone through these steps? I'm assuming you are using SQL Server based on your naming. http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000613000000 ... View more

My solution was to create a version then create a database connection file and reference the newly created version as the default. I could then drop the change version operation as the edit opens with the specified version from the connection file. ... View more

The script would surely error out if I tried to read featureclasses from something that is not a workspace. That is half correct. In your case you have created a sde connection file which is a recognized workspace type. Whether or not it actually references a valid database connection is irrelevant to the tool. Running an arcpy.ListFeatureClasses() on an invalid sde connection will return an empty list. ... View more

Check to make sure the field has that exact name and it is the right type. ... View more

Are you looking for ListFeatureClasses? ... View more

What is your expression? And why not use an update cursor? ... View more

You can access the aliasName property through Describe. Without getting into ArcObjects I don't think you will be able to write to the aliasName property. You can test to see if the alias matches the one in your record and flag that for modification, but automatically changing it would be more difficult. Edit: My mistake. It seems there is a tool for that in 10.1. I don't think it is available in 10.0, however. AlterAliasName ... View more

Something like this should work if you are referring to your ddp index field value. If it isn't your index field then just insert the name of the field instead of ddp.pageNameField.name import arcpy mxd = arcpy.mapping.MapDocument("CURRENT") ddp = mxd.dataDrivenPages for pageNum in range(1, ddp.pageCount + 1):     mxd.dataDrivenPages.currentPageID = pageNum     id_val = ddp.pageRow.getValue(ddp.pageNameField.name)     arcpy.mapping.ExportToJPEG(mxd, r"C:\output\{0}_reachmap.jpg".format(id_val)) del mxd ... View more

Great.  Thanks for the quick reply.  Any idea where I would find this information? Are you using an exchange server or something else? If they are not using the default SMTP port 25 your best source would be whoever setup the email server. Here's a quick list of possible ports depending on your setup.     POP3 - port 110     IMAP - port 143     SMTP - port 25/587     HTTP - port 80     Secure SMTP (SSMTP) - port 465     Secure IMAP (IMAP4-SSL) - port 585     IMAP4 over SSL (IMAPS) - port 993     Secure POP3 (SSL-POP) - port 995 ... View more

No, can you give me some examples. To borrow from the previous post, this line connects to your server. server = smtplib.SMTP('333.333.333.3') The IP address used is just an example of course, filling in your own IP or DNS where your email server is hosted. This assumes the default email port of 25 is used, as no port parameter is passed. If your email server has a custom configuration that uses a different port you may need to find that out from your IT people. I get the same error you posted if I try to connect using an incorrect port. server = smtplib.SMTP('my.email.server', 22) error: [Errno 10061] No connection could be made because the target machine actively refused it ... View more

Any one have this error? [Errno 10061] No connection could be made because the target machine actively refused it Are you sure you are using the right hostname and the port is open on your server? ... View more

Here is an example using an update cursor. Untested. import arcpy table = 'some_table' last_val = None count = 0 cursor = sorted(arcpy.da.UpdateCursor(table, ['PASS_NUM', 'TPN'])) for row in cursor:     if row[0] == last_val:         row[1] = count     elif row[0] != last_val:         count += 1         row[1] = count         last_val = row[0]     else:         pass     cursor.updateRow(row) ... View more

Definitely a good first step. Next you'll want to iterate over each unique value in your list and create a feature layer with the value defined as the where clause to create a layer of just that value. Do a select by location to get all the ddp rows you need then export those. Alternatively you can run an intersect on your ddp layer and your fire areas to get a match of ddp rows and fire areas to export. ... View more

You can eliminate the confusing escape characters by using string substitution and the AddFieldDelimiters function. query =  "{0} LIKE 'BOUND%'  AND {0} NOT LIKE 'BOUND-ADMIN-VIR'".format(arcpy.AddFieldDelimiters(Polyline, 'Layer')) arcpy.FeatureClassToFeatureClass_conversion(Polyline, Fea_Class_Path, "PCL_LN", query) Also, I don't see your Polyline variable declared anywhere. ... View more