Latest Contributions by JohnPapageorgiou

‎10-19-2020

Hi Aaron, Since implementing this a couple of weeks ago, we have run into some of the same issues you described. So far we have had issues with file geodatabases getting corrupted or data disappearing. Access mdb files seem to be fine for now but we'll see how that goes. We haven't tried anything with raster files yet. We ended up moving most of our non-GIS files to Egnyte and kept the bulk of our GIS data on premises. When testing this out a few months ago, I recall loading large feature classes from Egnyte into an mxd took a very long time, if the feature class ended up loading at all. For now we are staying with a hybrid system until we find a better solution. Thank you very much for your response, this is very helpful information. thanks, John

‎10-08-2020

Our company will be migrating all of our files/data/applications from our aging on premises servers to Egnyte cloud services. Does anyone have any experience with integrating these products? Any recommendations? Some pros and cons in moving in this direction would be helpful as well. We do not have ArcGIS enterprise, just several ArcGIS desktop and Pro licenses and an ArcGIS online Organizational account. I'm interested in Egnyte Cloud Services specifically because we have already invested in it. Any feedback is welcome. thank you, John

‎10-08-2020

Hi Dan, That worked with the condition of adding a new field of the total area and calculating it first. So all fields need to be created and populated before I can use the above code block. I was interested in a method of using the sum of the areas without having to create a new field and populate it with area sums (that are the same value). Otherwise it worked. thank you, John

‎08-13-2020

Hi Dan, thank you for your reply unfortunately e = float(!area_acres!)/float(summed_total) * float(100) gives me a syntax error which I'm trying to resolve. When I put double quotations around the whole expression, the variables become strings and the float command does not work. I'll keep trying and responses are still welcome. thank you, John

‎08-13-2020

Looks like you moved it for me, thank you!

‎08-13-2020

Thank you Kory. Can you tell me how to get it there? thanks, John

‎08-13-2020

Hi, I have a feature class with two fields I am interested in using. One field is "area_acres" and the other is "Survey_Pcnt". I have calculated the field "area_acres". My intent is to sum all the values in the field "area_acres" and then use that "summed_total" in the following expression to calculate the "Survey_Pcnt" field: "!area_acres!/summed_total*100". I have managed to sum all the values successfully, but when I try to add summed_total as a variable in the expression and run the script I get the error: TypeError: unsupported operand type(s) for /: 'str' and 'float'. This error leads me to believe I'm trying to perform division between a string and floating point which wouldn't work. Below is my code that I'm having trouble with. summed_total = sum((r[0] for r in arcpy.da.SearchCursor(env.workspace + "/APE_intersect_dissolve_adequacy", ['area_acres']))) print (summed_total) percentage_expression = "(float(!area_acres!))"/float(summed_total)*"(float(100))" arcpy.CalculateField_management(env.workspace + "/APE_intersect_dissolve_adequacy","Survey_Pcnt", percentage_expression, "PYTHON_9.3") I have tried writing the percentage_expression many different ways to no avail. At this point any help is greatly appreciated. Let me know if there is any other information I can provide. I am using ArcGIS desktop 10.7.1 and arcpy. thank you, John

‎10-14-2019

I am in the same situation here. Any information relevant to Matthew's question would be helpful to me as well. Thank you.

‎06-28-2019

Same issue here, except the edits won't sync anymore for the past two weeks. At least before the edits would sync, not anymore. This is a big problem because we rely on the workflow collector provides. It worked fine before, what changed? We need the sync ability to work again.

‎03-06-2019

Hi Rhett, My apologies for my delayed response. Thank you for your response that was the direction I took. Managing the lists was a bit of a learning curve. SearchCursor was helpful as well in my instance. thanks, John

‎02-02-2019

Thank you Josh! That did the trick.

‎02-02-2019

I found a script that allows the input of a feature class and then it deletes all the fields in a feature class with the exception of those listed in the "if" statement. The script works great when passing 1 feature class or 1 file geodatabase table. However, I need to pass a list of tables as the input, and when I do, I get the error: IOError: "[ list of all the tables I tried to enter]" does not exist. Below is the script with my attempted modifications. Is what I am trying to do possible? Thank you in advance. John import arcpy from arcpy import env env.workspace = r"C:\user\test22\test_tables.gdb" list_filename_Tables = arcpy.ListTables("*_filename*") fc = list_filename_Tables for f in arcpy.ListFields(fc): if (f.name == 'OBJECTID' or f.name == 'ID' or f.name == 'Project1' or f.name == 'Height'): print("cant delete {}".format(f.name)) else: arcpy.DeleteField_management(fc, f.name)‍‍‍‍‍‍‍‍‍‍‍‍‍

‎01-30-2019

I have a set of file geodatabase tables that are an output form another process. From that output I created a subset based on part of the filename. I would like to merge all these files together but the merge tool will not work because in some tables a field with the common name "PROJECT" differs in length. My solution is to add a new field "Project1" and calculate it using the field calculator in arcpy. Unfortunately the problem I am having with this is that not all of the tables in my subset have the field "PROJECT" so the calculation is giving me the error: ExecuteError: ERROR 000539: Invalid field PROJECT Failed to execute (CalculateField). This leads me to believe, that I need to set up some sort of code block with IF ELSE to iterate through this list of tables and ignore tables where the "PROJECT" field is not present and continue. I need help writing that and figuring out where to place the code block. Any help is greatly appreciated. I am using ArcGIS desktop 10.4.1. This is what I have so far, thanks in advance. import arcpy import os from arcpy import env env.workspace = r"C:\John\test22\Caribou_Plumas_Testing.gdb" list_NRes_Tables = arcpy.ListTables("*_NRes*") for myTables in list_NRes_Tables: arcpy.AddField_management(myTables,"Project1","TEXT",255,"","","Project1", "NULLABLE", "NON_REQUIRED") for myTables in list_NRes_Tables: arcpy.CalculateField_management(myTables,"Project1","!PROJECT!","PYTHON")‍‍‍‍‍‍‍‍‍‍

‎08-30-2018

Hi Dan, Thank you for helping me think of this in a different way. That is exactly what is giving me difficulties. At present the field name is hardcoded because that is the only way I can get it to work. I'm having trouble figuring out how to define parameter 2. I tried "arcpy.GetParameterAsText" but that did not work. Is there some literature you can direct me to that discusses how to define a parameter whose variable is a field derived from an input feature class? thank you, John

‎08-30-2018

Hi Brittney, Thank you for your response, I'll give it a try. I forgot to mention that I am working in ArcGIS Desktop 10.4.1 will your solution work there, or do I have to use ArcGIS Pro? They use different versions of python. thanks, John

Online Status	Offline
Date Last Visited	‎03-16-2023 02:45 AM

My Ideas

Latest Contributions by JohnPapageorgiou

Re: Egnyte Cloud Services and ArcGIS Desktop

Egnyte Cloud Services and ArcGIS Desktop

Re: How to Set up an expression in arcpy to calculate percent where one of the variables is the result of a previous calculation

Re: How to Set up an expression in arcpy to calculate percent where one of the variables is the result of a previous calculation

Re: How to Set up an expression in arcpy to calculate percent where one of the variables is the result of a previous calculation

Re: How to Set up an expression in arcpy to calculate percent where one of the variables is the result of a previous calculation

How to Set up an expression in arcpy to calculate percent where one of the variables is the result of a previous calculation

Re: ArcGIS Enterprise in the cloud - pros/cons?

Re: Collector - "sync replica internal error" on device, yet edits sync

Re: Calculate new field in multiple tables based on an existing field that is not always present

Re: How to delete multiple fields from a list of geodatabase tables

How to delete multiple fields from a list of geodatabase tables

Calculate new field in multiple tables based on an existing field that is not always present

Re: Modifiable field variable

Re: Modifiable field variable

Re: Shapefile vs. Geodatabase