|
POST
|
Yes it can be automated and you are on the right track, but please post your code.
... View more
03-15-2022
04:24 PM
|
0
|
0
|
761
|
|
POST
|
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
03-15-2022
04:19 PM
|
0
|
0
|
3340
|
|
POST
|
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
03-10-2022
02:33 PM
|
0
|
2
|
2671
|
|
POST
|
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
03-04-2022
02:44 PM
|
0
|
0
|
795
|
|
POST
|
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
03-04-2022
07:02 AM
|
0
|
0
|
1626
|
|
POST
|
'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
03-04-2022
04:35 AM
|
0
|
0
|
1636
|
|
POST
|
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
03-03-2022
02:02 PM
|
0
|
0
|
2953
|
|
POST
|
I can't see where "GlobalId' is coming from but there is something odd about your searchfields list. Do you really want to read the same field ('xy') twice? I think you can do that but it seems redundant. Will line 9 ever return True? Perhaps 'xy' is an alias and not really the column name? It might help to see how you create the curN and curL cursors. For your code to work they must be created with the same number of list elements (3) as the search cursor.
... View more
03-03-2022
10:46 AM
|
2
|
4
|
2962
|
|
POST
|
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
03-02-2022
01:57 PM
|
0
|
0
|
2336
|
|
POST
|
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
03-01-2022
09:59 AM
|
0
|
1
|
803
|
|
POST
|
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
02-22-2022
05:08 AM
|
1
|
1
|
969
|
|
POST
|
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
02-21-2022
03:46 PM
|
0
|
1
|
2792
|
|
POST
|
I usually construct the payload as a python dict then convert the dict to json using the technique described here.
... View more
02-21-2022
10:03 AM
|
1
|
0
|
1090
|
|
POST
|
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
02-18-2022
07:39 PM
|
0
|
3
|
1577
|
|
POST
|
If you do a Describe on the feature class, a hosted feature catalog path should start with 'https'. fc = 'https://services2.arcgis.com/dJOijx2lWTlGQBDJ/arcgis/rest/services/CW_3872/FeatureServer'
arcpy.Describe(fc).catalogPath
'https://services2.arcgis.com/dJOijx2lWTlGQBDJ/arcgis/rest/services/CW_3872/FeatureServer'
... View more
02-16-2022
11:38 AM
|
1
|
0
|
795
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-18-2025 03:42 PM | |
| 1 | 11-19-2025 02:36 PM | |
| 1 | 08-11-2025 09:19 PM | |
| 2 | 08-07-2025 11:47 AM | |
| 1 | 01-18-2022 07:15 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-28-2025
04:52 AM
|