Latest Contributions by MikeOnzay

‎03-01-2016

IT reported no network anomalies during that time. The only maintenance that was occurring was a backup of the virtual machines. I stopped running the tool through the night and focused on doing smaller sets throughout the day. I haven't had any problems since then.

‎02-29-2016

Is there an option in the config file (or could there be) that would allow multiple points to be created at the main? In this screenshot you can see 4 points representing meters. After running the Add Laterals to Connection tool only one point was created on the main and 4 laterals were connected to it.

‎02-27-2016

Are there log files associated with this toolbar? I was running the Add Laterals to Connection tool on about 600 features overnight and in the morning I saw this message window: then after clicking through several of the above dialogs I was unable to save my edits. I had to exit ArcMap without being able to save. Upon re-opening the MXD I could see that the last feature created was at 2/27/2016 3:15:44 AM. Fortunately, it did save up to that point (I'm running this against a named version in SDE) and I was able to post and reconcile. The only process that was occurring against the SDE database at that time last night were routine backups. I don't know if a log file would have been helpful in this case.

‎11-04-2015

After working with ESRI tech support on this for the last few weeks I'm answering my original question / discussion by stating that ESRI agrees that removing the join should have not caused the subsequent use of SelectByLayerAttribute to fail. It is a bug and they were able to reproduce the error I was seeing using their own test data. BUG-000091905 : If an "OR" operator is specified on a table view and that table view previously participated in a join, running the Select by Attributes geoprocessing tool encounters error 000358: Invalid expression In working with MY case, ESRI determined that using the IN operator instead of an OR would be a workaround. I can confirm that this works. However, using IN may not work in all cases. In researching this error ESRI also found a similar bug NIM097634 - The Select Layer By Attribute where_clause tool fa.. that was found in 2013 and is still open. Hopefully this new bug will help both bugs rise to the top and get fixed soon.

‎10-15-2015

Before the join the fields look like this: u'TicketStatus' During the join all of the fields look like: u'RockGIS.DPWUTIL.MissUtilityTickets_TEST.TicketStatus' arcpy.SelectLayerByAttribute_management("missu_lyr","NEW_SELECTION", "TicketStatus = 'Marked' OR TicketStatus = 'Clear/No conflict'") or arcpy.SelectLayerByAttribute_management("missu_lyr","NEW_SELECTION",( "RockGIS.DPWUTIL.MissUtilityTickets_TEST.TicketStatus = 'Marked' OR" "RockGIS.DPWUTIL.MissUtilityTickets_TEST.TicketStatus = 'Clear/No conflict'")) throw ExecuteError: ERROR 000358: Invalid expression If I remove the join the fields look like this: u'TicketStatus' The selection still doesn't not work. I have to delete the view and create a new one and then the selection will work.

‎10-14-2015

The script builds a table in a file gdb using other data sources. That table is is joined to the SDE featureclass and then 4 fields in the FC are calculated. In the code below I'm only showing the first of the 4 fields that gets calculated from the join table. The second calculate in row 3 below doesn't use any value from the join table but I need to calculate this value now while the tables are joined. arcpy.AddJoin_management(in_layer_or_view="missu_lyr", in_field="TicketNo", join_table=path_to_join_table, join_field="TicketNo", join_type="KEEP_COMMON") with arcpy.da.Editor(wksp) as edit: arcpy.CalculateField_management('missu_lyr', sdeFieldPrefix + 'TicketStatus',"!ticketstatus.TicketStatus!",expression_type="PYTHON_9.3",code_block="#") arcpy.CalculateField_management('missu_lyr', sdeFieldPrefix + 'OpenClosed','"O"',expression_type="PYTHON_9.3",code_block="#") arcpy.RemoveJoin_management('missu_lyr') At this point missu_lyr is still a subset (the subset being that the where_clause when the view was setup had: where_clause = "OpenClosed = 'O' OR OpenClosed IS NULL") of the the entire data without the join now. I just found that if I tried to do a new selection on it arcpy.SelectLayerByAttribute_management("missu_lyr","NEW_SELECTION","TicketStatus = 'Marked' OR TicketStatus = 'Clear/No conflict'") the selection failed. It was only after deleting the view and creating a new view did the selection work.

‎10-13-2015

Thanks for the link on how to post code because I know that I'm supposed to do that but it was not obvious to me last night as to where I could find it on the editor toolbar.

‎10-13-2015

Are you saying that rather than just using arcpy.MakeTableview by itself it would be better to call it while it is being assigned to a variable? I did a test. myvar = arcpy.MakeTableView_management(os.path.join(wksp, targetFC),"missu_lyr",where_clause = "OpenClosed = 'O' OR OpenClosed IS NULL", workspace="") arcpy.GetCount_management("missu_lyr") <Result '27'> arcpy.Delete_management('missu_lyr', 'GPTableView') <Result 'true'> myvar <Result 'missu_lyr'> # I did not expect to see this arcpy.GetCount_management("missu_lyr") Traceback (most recent call last): File "<interactive input>", line 1, in <module> File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\management.py", line 15306, in GetCount raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset missu_lyr does not exist or is not supported Failed to execute (GetCount). I did it the other way too. myvar = arcpy.MakeTableView_management(os.path.join(wksp, targetFC),"missu_lyr",where_clause = "OpenClosed = 'O' OR OpenClosed IS NULL", workspace="") arcpy.GetCount_management("missu_lyr") <Result '27'> del myvar arcpy.GetCount_management("missu_lyr") <Result '27'> Maybe this is a case where the variable is just referencing the object and not actually holding it? Deleting the variable just deletes the reference.

‎10-13-2015

All I know how to do is use arcpy.Delete_management('missu_lyr') to delete that view. I'm not aware that I can do anything else. Your suggestion of keeping track of locals().keys() is something new for me that I will explore. I think my approach of creating a new view to do selections is reasonable. I'm not processing large files so I'm not worried about running out of memory before the script ends

‎10-13-2015

In the first part of my script the view is created with a where clause which I think is like a selection but not something you can really clear. Then I do the join. Then some calculations. Initially I was trying to do a new selection on that view and it was failing even after removing the join. My scenario is a little different from what you are asking although I don't disagree with it. In some earlier versions of my script when I was trying to figure out the correct workflow (I had more selections in the second part) I was intentionally clearing the selections.

‎10-12-2015

I've been working on a python script for awhile now and I've been stumped for over a week as to why the script would throw an error when I tried to use SelectLayerByAttribute after I removed a join on a tableview that is based on a SDE featureclass. I finally figured out the solution today but I don't really understand why it works. Or, I should say, I don't understand why it didn't work before. The solution was to break my script into two parts: Using one view for the AddJoin and then deleting that view and creating a separate view to perform an action without the join. I had a working script that created a tableview using a where clause from an SDE featureclass, pulled in data from other sources, joined that data to the tableview, did some calculations, then removed the join and deleted the tableview. arcpy.MakeTableView_management(os.path.join(wksp, targetFC),"missu_lyr",where_clause = "OpenClosed = 'O' OR OpenClosed IS NULL", workspace="") Later on I needed to do an additional calculation on the featureclass but I didn't need the table joined anymore. I tried to just continue my workflow by removing that join and using the SelectLayerByAttribute command to get a subset and then calculate the values. However, I kept getting an "ERROR 000358: Invalid expression" on it. arcpy.AddJoin_management(in_layer_or_view="missu_lyr", in_field="TicketNo", join_table=path_to_table, join_field="TicketNo", join_type="KEEP_COMMON") # do stuff arcpy.RemoveJoin_management('missu_lyr') arcpy.SelectLayerByAttribute_management("missu_lyr","NEW_SELECTION","TicketStatus = 'Marked' ") Executing: SelectLayerByAttribute missu_lyr NEW_SELECTION " "TicketStatus" = 'Marked'" Start Time: Mon Oct 12 17:30:07 2015 ERROR 000358: Invalid expression An invalid SQL statement was used. Failed to execute (SelectLayerByAttribute). What really stumped me is that I could run my script to a certain point (I'm using PyScripter) and then try the select command and check the results with GetCount_management and I get what expected. I also did the workflow in the interactive window in ArcMap with no errors. After 37 minutes on the phone with ESRI tech support today I could not give up (they were elevating my issue) and I finally tried removing the join, deleting the view and recreating a new view with a new name and the same syntax. arcpy.MakeTableView_management(os.path.join(wksp, targetFC),"missu_lyr2",where_clause = "OpenClosed = 'O' OR OpenClosed IS NULL", workspace="") arcpy.SelectLayerByAttribute_management("missu_lyr2","NEW_SELECTION","TicketStatus = 'Marked' ") Then the selection worked. The calculation worked. My script finally worked. Does the act of creating a join and then removing it leave some funny prefixed fieldname behind? Or is it a best practice to always create a new view after a join before doing selections? Message was edited by: Mike Onzay Edited to add syntax highlighting

‎12-11-2014

My admin can see the options now. I agree that if non-admins cannot use it the icon should be hidden. The help guide should also be updated to reflect that you cannot get to the profile page from there.

‎12-11-2014

While logged into an ArcGIS Online Organizational (AGOL-O) account and viewing My Organization I see a gear icon on every member line. For myself or the administrator nothing happens when clicking on these icons. From the help guide it appears that most of the actions are something an admin would need to do except for modifying a profile. However, if I want to modify my profile I can do that elsewhere. Does the gear icon work for anyone else?

‎10-21-2014

How is Geoform different from Collector? Are they complementary?

‎08-28-2014

Right. I'm trying to partially replace a string in the path. As I said in my original post the help guide states that it is possible to do partial strings. I need some help figuring out how to do that.

Online Status	Offline
Date Last Visited	‎10-06-2025 12:09 PM

My Ideas

Latest Contributions by MikeOnzay

Re: Water Utility Network Editing - Log file?

Water Utility Network Editing - option to add multiple points in same location?

Water Utility Network Editing - Log file?

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Using the same table view with and without a join throws an error when using SelectLayerByAttribute

Re: Gear icon under actions in My Organization - Is anyone using it?

Gear icon under actions in My Organization - Is anyone using it?

Geoform vs Collector

Re: Use partial paths in findAndReplaceWorkspacePaths

Workflow Manager vs GIS Request Management

Re: Use csv list to suggest names, but allowing in...

Customize label when hovering above bar chart

View Attachments in an existing survey

Re: Print fail started overnight