Latest Contributions by JoshuaBixby

‎09-12-2014

With 10.1 I seem to remember some quirky behavior, I would argue a bug, where you need to include the OBJECTID field in the GROUP BY clause even if you aren't selecting OBJECTID. Try the following and see if it works: tab = r'H:\Documents\ArcGIS\Default.gdb\arlist' with arcpy.da.SearchCursor(tab, ["fc", "item2"], sql_clause=(None, "GROUP BY fc, item2, objectid")) as cursor: for row in cursor: print "{0}, {1}".format(row[0], row[1]) I believe the root cause was that OBJECTID in 10.1 is being implicitly selected with the SearchCursor and not handling it in the GROUP BY clause creates the error. I don't recall this being listed in Addressed Issues for 10.2/10.2.1/10.2.2, but the behavior did change between 10.1 and 10.2.x.

‎09-12-2014

At least in 10.2.2 with personal and file geodatabases, the following works for me: with arcpy.da.SearchCursor(fc, ["field1", "field2"], sql_clause=(None, "GROUP BY field1, field2")) as cursor: for row in cursor:

‎09-05-2014

A bug on this issue has been opened with Esri Support. As of now, no timeline for when it might be addressed. Esri Support: Bug BUG-000081100: Arcpy.mapping.MapDocument.saveACopy() does not work the same as the ArcMap Save A Copy functionality. The output mxd is not compacted.

‎09-02-2014

Although this won't address the immediate need for a workaround, I think there is a bug here. If one uses MapDocument.saveaCopy and specifies an earlier version, like 10.0 from 10.1 or 10.2, the output of the saved MXD is dramatically smaller on several large MXDs I grabbed. Basically saving from ArcMap to any version shrinks the file size and saving from arcpy to previous version shrinks the file size, but saving from arcpy to current version doesn't. I have a bit more digging before deciding whether to open an Esri Support case/incident.

‎09-02-2014

First response from Esri Development is Declined, "known issue." The explanation was a bit terse and jumbled, so I asked for clarification. If it is a "known issue," it isn't well documented because I have yet to find any reference to this limitation. If you have, please share a link here. I will wait to draw a final conclusion but this has the potential to be yet another Esri Known Unknown.

‎08-29-2014

Looking back through existing bugs, came across the following from ArcGIS 9.2: NIM006067: Date Modified field does not update as a result of edits made to file geodatabase feature classes. I can't say whether that earlier bug is related to this issue. The bug above was addressed in 9.2 SP2 and 9.3, but sometimes bugs come back in later versions. Regardless, this doesn't seem to be the first time there has been an issue with the Modified properties of file geodatabases. Let's hope the 'Low' severity of the earlier bug isn't an indicator of how much developers care about giving accurate information to users.

‎08-29-2014

I submitted this information through Esri Support and a bug was opened: #NIM104745 - The date modified field in ArcCatalog contents tab does not update after edits made to a file geodatabase feature class.

‎08-26-2014

I have heard back from Esri Support and Esri Development. I will restrict comments on the first three parts in the series and post final comments with part four of the series: What's in a Name: When Known = Unknown .

‎08-26-2014

I have heard back from Esri Support and Esri Development. I will restrict comments on the first three parts in the series and post final comments with part four of the series: What's in a Name: When Known = Unknown .

‎08-26-2014

I have heard back from Esri Support and Esri Development. I will restrict comments on the first three parts in the series and post final comments with part four of the series: What's in a Name: When Known = Unknown .

‎08-26-2014

A coworker finally got an answer from Esri through other channels: Esri wrote: ...ArcPad does not use IWA authentication. This is a feature we are not planning to add in the next release, and is not currently on our radar for future releases either.

‎08-26-2014

Recently, a program specialist approached me with questions about the file modified dates in ArcCatalog. I started by explaining the Modified column in ArcCatalog shows when the data or schema was last changed in a shapefile or feature class; well, a feature class in a file geodatabase at least. The user wasn't buying it, so I set out to show him what I meant. I can't recall if Modified has been an option in the Contents window all along or if it was added sometime along the way, but I do know it isn't turned on by default. Since I don't use it much, I had to go enable it: I don't like demoing on real data for several reasons, including the fact the data can sometimes be the problem, so I whipped up an empty shapefile and feature class for testing. As you can see, the shapefile was created and last modified the other day. Let's use ArcPy and an InsertCursor to put a record into the shapefile and check the Modified date. After refreshing the Contents window, we can see the Modified date gets updated after the edit session is ended using the stopEditing command. That seems pretty reasonable, i.e., the changes are committed after the editing is complete and the Modified column is updated to reflect the time the edit session ended. Let's do the same thing with a feature class. That's odd. After ending the edit session and refreshing the Contents window, ArcCatalog is still showing the feature class as being modified when it was created a few days ago. Maybe it is my code or something is messed up with this ArcCatalog session. I am going to close out of ArcCatalog and start over. This is even more odd. The Modified column now shows 4 minutes before the edit session ended. In fact, the Modified column shows a time that is prior to starting my edit session (the timestamps for starting the session aren't given above, but the edit session was started less than a minute before I ended it). If the Modified column isn't showing the start or end of an edit session, what is it showing with feature classes? The answer, when ArcCatalog or ArcMap is closed. I have checked in ArcMap with manual edit sessions, and the behavior is the same. Yes, the Modified column for feature classes doesn't show when data is updated like with shapefiles but when the application is closed. In our organization with casual GIS users and disconnected Citrix sessions, the discrepancy can be days.

‎08-19-2014

Although I am thinking the UpdateCursor (arcpy.da) might still be faster, one could also use Make Feature Layer or Select Layer By Attribute followed by Calculate Field. My preference is usually arcpy, but there are other geoprocessing ways of accomplishing the same task. def removeName(shapefilePath): arcpy.MakeFeatureLayer_management(shapefilePath, "shapefileLayer", ' "NAME" LIKE \'***%\' ') arcpy.CalculateField_management("shapefileLayer", "NAME", "str()", "PYTHON_9.3")

‎08-19-2014

Charlie Frye wrote: Thanks Ian--I've been writing VBA lately... An Esri staffer writing VBA? Isn't that sacrilegious these days seeing that Esri deprecated VBA in 10.1 and has been trying unsuccessfully to retire it since then.

‎08-19-2014

Bueller? Beuller? No one from Esri staff visits the Portal for ArcGIS place?

Online Status	Online
Date Last Visited	3 hours ago

My Ideas

Latest Contributions by JoshuaBixby

Re: arcpy.da.SearchCursor - sqlprefix

Re: arcpy.da.SearchCursor - sqlprefix

Re: Automate the .saveACopy() ArcPy method to reduce MXD file size

Re: Automate the .saveACopy() ArcPy method to reduce MXD file size

Re: What Time is it: When Changed != Modified

Re: What Time is it: When Changed != Modified

Re: What Time is it: When Changed != Modified

Re: What's in a Name: When in_memory = ?

Re: What's in a Name: When in_memory != In-memory

Re: What's in a Name: When in_memory = In-memory

Re: ArcPad and Portal

What Time is it: When Changed != Modified

Re: Arcpy - delete attribute data if string starts with..

Re: Arcpy - delete attribute data if string starts with..

Re: ArcPad and Portal

Re: New ParameterArray container

Re: New ParameterArray container

Re: What is the fastest way to add a new machine t...

Re: ArcGIS Enterprise Kubernetes / GIS Functionali...

Re: What is the fastest way to add a new machine t...

Python Snippets

Esri Forestry Group (EFG)