New answers tagged query
0
I found the issue. It has to do with the layer URL input. The initial url variable was stored as something like this (https://xxx/arcgis/rest/services/xxx/xxxx/MapServer/). This is ok for identify tasks but for query tasks it requires the layer ID (something like this https://xxx/arcgis/rest/services/xxx/xxxx/MapServer/0). All i had to do was to include the ...
10
I'll answer my own question but credit goes to user30184 for giving me a couple clues. The problem seems to be that the first few thousand rows in my table are LineStrings and apparently QGIS isn't examining all of the rows and finding the other geometry types in the table.
The solution, at least in QGIS 3.18.2, is to check the "Don't resolve type of ...
5
Perhaps the only thing that you need to do is to refresh the connection by pressing the Connect button again.
This was my test case:
CREATE TABLE geometrytest (id integer, geom geometry(MultiLineString));
INSERT INTO geometrytest values (1,ST_GeomFromText('MultiLineString ((0 0,3 3))'));
ALTER TABLE geometrytest ALTER COLUMN geom type geometry(Geometry);
...
5
Use a where clause to delete all rows returned by the cursor:
where_clause = "{0} IN('HAWAII', 'ALASKA')".format(arcpy.AddFieldDelimiters(datasource=outputft, field="State_Name"))
with arcpy.da.UpdateCursor(in_table=outputft, field_names="State_Name", where_clause=where_clause) as cursor:
for row in cursor:
cursor....
Top 50 recent answers are included
