|
POST
|
I think we are suffering with the same issue. Are you publishing using ArcGIS pro 3.*?
... View more
04-04-2023
03:53 AM
|
0
|
1
|
1125
|
|
POST
|
Today, in the version ArcGIS Server 11, it is happening again.
... View more
04-04-2023
02:31 AM
|
0
|
0
|
1087
|
|
POST
|
I do not understand the idea behind extensions:DesignOnlyResourceDictionary if you can not used it in design time, because it will not be loaded.
... View more
01-19-2023
03:19 AM
|
1
|
0
|
1230
|
|
POST
|
I am migrating to .NET 6, for the migration to ArcGIS Pro 3.0 SDK, and have some Manual UI test..... same Error. Man you are a savior. I owe you a beer
... View more
01-19-2023
03:00 AM
|
0
|
0
|
2023
|
|
POST
|
Additional Note: The tool MakeRouteEventLayer does not like either the "memory" workspaces as input. The documentation: https://pro.arcgis.com/en/pro-app/2.9/tool-reference/linear-referencing/make-route-event-layer.htm does not state this.
... View more
12-19-2022
02:15 AM
|
0
|
0
|
1588
|
|
POST
|
After some trial and error (not you pity documentation) I found that Intersect tool does not like "memory" (modern, state of the art) workspaces as INPUT, it does not care about the output:
... View more
12-19-2022
01:34 AM
|
0
|
0
|
1588
|
|
POST
|
As I posted as evidence, both scenarios are the same, the only difference is the location of the expected result. but in order to provide more evidence, i ran the scripts against an smaller dataset, and print the results:
... View more
12-19-2022
01:29 AM
|
0
|
0
|
1588
|
|
POST
|
This blows my mind!!!! if I use the syntax uParcel = arcpy.da.UpdateCursor(parcels, Pfields, SQL) in query to modify 10 items, it works ok. As soon as i change the where clause to modify 23700 features, it gives me the error mentioned above. then I change to the syntax: with arcpy.da.UpdateCursor(parcels, Pfields, SQL)as uCursor: if fu****ing works. This library is so unstable.
... View more
12-07-2022
11:50 PM
|
0
|
1
|
6228
|
|
POST
|
Despite the fact that unique identifiers are supported, I went for a casting approach database = 'C:\\Installation\\updm.sde'
egdb_conn = arcpy.ArcSDESQLExecute(database)
# Getting the ID's froma table
sql_clause = "SELECT CAST(PROJECT_ID AS VARCHAR(100)) from DataOwner.My_PROJECTS;"
query_return = egdb_conn.execute(sql_clause)
# Whatever operation you want to do with the results, in this case
# is just the verification of how many results, but they will be
# iterated later
len(query_return) * by the way the semicolon does not make any difference.
... View more
12-06-2022
11:59 PM
|
0
|
0
|
1830
|
|
POST
|
Any suggestion when the same error appears, despite the fact that the value of the parameter is already set to True?
... View more
12-05-2022
05:23 AM
|
1
|
0
|
3228
|
|
POST
|
Thanks for the suggestion. As a matter of fact I did it before of making the post, but I did it again just to be able to copy and paste the output from the execution: ---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
In [48]:
Line 7: query_return = egdb_conn.execute(sql_clause)
File C:\ArcGISPro\Resources\ArcPy\arcpy\arcobjects\arcobjects.py, in execute:
Line 44: return convertArcObjectToPythonObject(self._arc_object.Execute(*gp_fixargs(args)))
AttributeError: ArcSDESQLExecute: StreamBindOutputColumn ArcSDE Error -65 Invalid pointer argument to function
--------------------------------------------------------------------------- As I already state in my original post this happens with columns defined as unique identifier. If I try to make the query to an INT, VARCHAR or DECIMAL column, the query is performed with out any issues.
... View more
12-04-2022
01:38 AM
|
0
|
0
|
1859
|
|
POST
|
Using ArcGIS Pro 2.9.5 I found that ArcSDESQLExecute is not able to handle unique identifiers in a table. I tried to run the following Script: database = 'C:\\Installation\\updm.sde'
egdb_conn = arcpy.ArcSDESQLExecute(database)
sql_clause = "SELECT PROJECT_ID from DataOwner.My_PROJECTS;"
print(sql_query)
query_return = egdb_conn.execute(sql_clause)
len(query_return) the table My_PROJECTS has a column PROJECT_ID defined as a uniqueidentifier., the result odf the execution is: ---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
In [39]:
Line 12: query_return = egdb_conn.execute(sql_clause)
File C:\ArcGISPro\Resources\ArcPy\arcpy\arcobjects\arcobjects.py, in execute:
Line 44: return convertArcObjectToPythonObject(self._arc_object.Execute(*gp_fixargs(args)))
AttributeError: ArcSDESQLExecute: StreamBindOutputColumn ArcSDE Error -65 Invalid pointer argument to function
... View more
12-02-2022
01:38 AM
|
0
|
3
|
1910
|
|
POST
|
Hi fellow, to be hones I do not trust yet in the implementation of arcpy for the use of objects with the function "with", I would strongly suggest to go in the direction of the old school and use the methods of the editor object: startOperation () stopOperation () abortOperation () undoOperation () redoOperation () https://gis.stackexchange.com/questions/158594/using-arcpy-da-editor-correctly Here ( https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/editor.htm ) check the Editor Example 2
... View more
11-28-2022
11:40 PM
|
0
|
0
|
3479
|
|
POST
|
I am using ArcGIS Pro 2.9, and trying to make some basic spatial operations. Two sets of features were selected from a geodatabase, and using them, an intersection will be performed. As it is not intended to persist this objects, the script use the "in_memory" workspace (it was done for the version 2.1 thinking in ArcDesktop). Today, in an attempt to update the script with the new characteristics of the version 2.9, I found that the intersect tool does not like the memory workspaces. Here is my evidence: reading the documentation of the intersect tool, it does not mention a restriction for this kind of datasets. Is this a bug? How do I report it?
... View more
11-25-2022
12:05 AM
|
0
|
7
|
1688
|
|
POST
|
Do you mean Pyhton 3.6+? I can say for experience that some of the arcpy tools in Python 3.7 (ArcGIS Pro 2.9) that some of the tools accept f-string as parameters other does not: This example does not work (using the f-string in the where_clause parameter): where_clause_with_date_filter = f"{where_clause} AND {date_filter}"
points_select = arcpy.analysis.Select("{0}.{1}".format(schema_owner, TABLE_CAL_POINTS), r"memory\f{0}".format(uuid4().hex),where_clause_with_date_filter) generates the error: File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\analysis.py", line 138, in Select
raise e
File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\analysis.py", line 135, in Select
retval = convertArcObjectToPythonObject(gp.Select_analysis(*gp_fixargs((in_features, out_feature_class, where_clause), True)))
File "C:\Program Files\ArcGIS\Server\framework\runtime\ArcGIS\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000358: Invalid expression f"{where_clause} AND {date_filter}"
Failed to execute (Select). i have tried to use the f-string in search cursor, and update cursor and found that in the feature_class parameter,m it does not accept f-strings, but in the where_clause it does: with arcpy.da.UpdateCursor("{0}.{1}".format(schema_owner, TABLE_LINKAGES),
["REFERENCE_FEATURE_ID"],
where_clause=f"PROJECT_ID = '{project_id}'") as cursor:
... View more
11-22-2022
04:42 AM
|
0
|
0
|
8318
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 12-01-2023 02:45 AM | |
| 1 | 07-19-2021 11:25 PM | |
| 1 | 07-21-2023 04:44 AM | |
| 1 | 07-07-2023 05:15 AM | |
| 1 | 01-19-2023 03:19 AM |
| Online Status |
Offline
|
| Date Last Visited |
08-02-2024
12:42 AM
|