Latest Contributions by DonMorrison1

Yes it can be automated and you are on the right track, but please post your code.  ... View more

I've never found a good way to get around this from python. Usually when my script fails (and I know nobody else should be using the database) I delete the locks on the database and then rerun the script. There is probably a less disruptive way - I'd be curious to find out.    ... View more

You can create a layer from an AGOL hosted feature layer by referencing the hosted feature layer's URL. For example: url = 'https://services2.arcgis.com/dJOijx2lWTlGQBDJ/arcgis/rest/services/CW_3863/FeatureServer/0' arcpy.management.MakeFeatureLayer(url, 'NewLayer')   ... View more

True - but you need a unique value that allows you to link a record in the table with a record in the feature class.  In database terminology it is a foreign key.  It can't be PermitNum since there are duplicates, so it has to be PermitNum plus something else. ... View more

I think if you dump out the length of 'row' after this statement if will be 1, which causes the error since it must be the length fieldList when you call updateRow row = [i.replace(chr(10), eolchar).replace(chr(13), eolchar)]   ... View more

'TypeError: sequence size must match size of the row' typically means that the length of the field list you use to create the cursor does not match the length of the list you use when doing the insert/delete/update row.  ... View more

If I understand what you are trying to do, I would consider a bit of a different approach like this (warning - I did not test this code): lyr = arcpy.MakeFeatureLayer_management(NIDs_Joined , "temp_lyr1", "NLDID IS NULL")[0] arcpy.CopyFeatures_management(lyr, to_append) lyr = arcpy.MakeFeatureLayer_management(NIDs_Joined , "temp_lyr2", "xy <> xy_1")[0] arcpy.CopyFeatures_management(lyr, change_loc)   ... View more

This is very curious and I hope somebody from ESRI can explain it.  To answer your question there are some cases when memory is constrained that running in 32 bit mode can be more efficient due to the smaller pointer size (4 bytes vs  8 bytes) - this results in smaller stack and heap sizes and less swapping to disk. But I'm quite sure that is not the problem here.  You could try to run the Python Profiler (cProfile) which will tell you which python functions are consuming the most time but this gives you no visibility into the underlying C code which is where I'd guess the real work is happening. ... View more

I don't think it is possible to do what your are trying since you don't really have a column with a unique value in either your feature class or table.  So, once again, forget about figuring out how to solve the problem with python for now.  You have to find something in or add something to the data that lets you associate each record in the table with one and only one record in the feature class. Once you have that we can discuss how to make it work using python. ... View more

Try parameter type "DEWorkspace"  for you output geodatabase.  I've never used dependent parameters so I can't help with that one. I think your syntax is wrong on line 9.  GetParameterAsText only takes one parameter and you are passing 2.  ... View more

I actually don't see the error message - I do see the source code in red - is that what you are calling the error message? Also: Here are the file types supported by TabletoTable_conversion - I've never worked with Access files so maybe they work.: Geodatabase dBASE (.dbf) Comma-separated values (.csv or .txt) Microsoft Excel worksheets (.xls or .xlsx) In-memory table views I think you are going to have to copy one file at a time, it looks like you are trying to pass in a list I would also print out (if running in a toolbox, use AddMessage) the variables along the way as you assign them just to verify they are what you expect - once you have it working you can remove those ... View more

I usually construct the payload as a python dict then convert the dict to json using the technique described here.      ... View more

I've been following this and would like to help you out with the python question but I suggest you forget about python for now and first tell us what are the names of the fields are in the table and the feature class that let you uniquely identify each record - as I posted previously.  Like @Anonymous User I deduced from your example that it was PermitNum and Apps, but evidently that is not correct. For this to work you must have a field or combination of fields in your table view that uniquely identifies each record in that view AND the "matching record" in the feature class. I may be wrong but it appears to me that you don't have this so the problem really has nothing to do with python but in your data ... View more