Latest Contributions by WesMiller

In this case <> means does not equal. So if "OWNERNAME"  does not equal 'S_HOUSING' AND "OWNERNAME" does not equal 'HOUSING ASSOCIATION' when both queries evaluate to true then select it. ... View more

Thanks again Dan.  I don't know how often I'll be here - I'm not really working with ArcPy/Python as much as I'd like, rather, only use it for scripting/batch processing when I have something large to run (usu. raster analyses/models).  Great to have this forum - and great to see you staying on top of it all for us! ... View more

Sounds like you need Iterate Feature Classes—Help | ArcGIS for Desktop  and Feature Class To Feature Class—Help | ArcGIS for Desktop  unless you need to test if the field exists ... View more

Thanks. I would have made the sniplet if the license they got for my ArcMap allowed it. And it would have made my life MUCH simpler. I'll now research the Append and get it to work. Thanks. ... View more

Thanks for the code. ... View more

I have not discovered a way to reorder or turn on , off visibility of fields. What my suggestion does is allow the same field to be displayed as you iterate to the next row. You may have to use your arrows to scroll to the field you want. The field with the black outline will be the field that you'll see. Hope this makes sense. ... View more

I think one of the approach to make it easier to understand arcpy workflow is to build it in ModelBuilder first, then export the model into python script. That may give an idea of how the script can be structured. Overall it sounds like a data driven page problem. See this post. Hope this helps... ... View more

Hi, here's an update: Tech support replied on our network problems: That was fairly easy, we had done the simplify on the original shape rather than getting a clone of the shape, simplifying that and then assigning it to the feature and storing it. Switching to that second method seems to fix the network problem. Also, we find that some features are split inti multipart features by the simplify, which the network doesn't like, but we can skip and log those features and handle them by hand. As to the other suggestions: The duplicate features are part of a geometric network in a large production geodatabase, and while extracting a large number of network features and the reloading them might be possible in theory, it's not something I'd really like to try. And no, having this many features with duplicate vertices is not a common occurrence but rather very specific to one customer situation. We've started cheking on other databases and generally find a handful of features with "real" duplicate vertices (rather than vertices that are very close) in many databases, but these tend to be a few and can be fixed by hand, if one so desires. Martin ... View more

How about wrapping the whole if/then in a try/except?... If something goes wrong, you can send yourself an email. ... View more

You may be interested in Defining feature class properties—Help | ArcGIS for Desktop ... View more

I found the problem.  I am dealing with attributed relationship classes (not standard 1:M) which creates the RID field and relationship class table.  Thanks for the help ... View more

don't know where the functionality lies then if it isn't accessible through arcpy and the interface to arctoolbox, sorry ... View more

Yep. Using Python to get the list of tracts, then edit a template XML document and create all the XML documents for all the tracts, and then making the new feature classes for each of the tracts. Now it's 'merely a matter of programming!" ... View more

You could create a dictionary and return the names. And a text element it would be a little extra work to keep up the list and either run the script or create an Addin TextElement—Help | ArcGIS for Desktop users= {'uname':'User Name','oname':'Other Name','yName':'Use Your Name'} users[os.getenv('username')] ... View more

Thanks Wes.  Adding that code to the exported python script works. arcpy.refreshcatalog({file path to database connection file}) ... View more