POST
|
Joshua, I am impressed...That was exactly the problem and your explaination was outstanding! Thank you, you saved my day... Stefan
... View more
04-29-2015
11:28 PM
|
0
|
1
|
1036
|
POST
|
I am developing a toolbox where the user can select an attribute (dropdown list) which comes from a PostGIS database and based on this attribute a select statement (selectbyAttribute) will be executed... Sounds easy... Here is a code snippet: input_AZ = str(arcpy.GetParameterAsText(0)) sql_exp = 'aktenzahl = ' + input_AZ ("aktenzahl" is the column (character) of the PostGIS db) arcpy.SelectLayerByAttribute_management (lyr_postgis, "NEW_SELECTION", sql_exp) sql_exp looks like this: "aktenzahl = VIIa-20150429a" but I get the following error: ERROR 000358 [The SQL statement was not a select statement] Does somebody know, how a SQL statement in arcpy has to look like (e.g. inverted comma) when executing on PostGIS? Thank you in advance! Stefan
... View more
04-29-2015
03:00 AM
|
0
|
4
|
5747
|
POST
|
Ok, I think I need a hint, because i am a bit stuck... Here is an illustration of my problem: - One feature class with overlapping polygons - I want the geometry and the attributes of the red area within the yellow and the blue one - no overlapping anymore - I don`t want a new output file - everything has to be done within the original shape I guess the union method of the polygon object could be the solution but I don't know how to call it. Do i need to loop through the geometry objects? Has somebody a code snipplet whith something simelar (e.g. polygon methods)?
... View more
04-24-2015
05:07 AM
|
0
|
0
|
616
|
POST
|
Two overlapping polygons within the same feature class. I will try the above mentioned polygon methods and let you know! Thank You!
... View more
04-23-2015
11:28 PM
|
0
|
0
|
616
|
POST
|
Dear Darren, I've got a polygon shape with 2 polygons. Polygon A is located below polygon B. Now I want the geometry of B within Polygon A. The thing is, that I don't want to create a new shapefile, like toolbox "Union" or toolbox "Erase" are doing it... Everything should be done within the input polygon shape. The correct tool within arcgis is the clip function of the editor. But in arcpy?
... View more
04-23-2015
01:02 AM
|
0
|
3
|
616
|
POST
|
Hi, i have got a polygon shape with overlapping features. Using the clip tool of the editor (not "toolbox -> analysis tools -> clip"!) will get me the correct result. Now I want to use editor clip with arcpy, but I can't find it. Does anybody know, if this function exists in arcpy? "Erase" would be an option, but I don't want to create a new shape file for the output... Best regards, Stefan
... View more
04-22-2015
06:05 AM
|
0
|
5
|
4310
|
POST
|
Dear collegues, I have written an arcpy script which gets its input from a shapefile. Everything worked fine. Now I am trying to change the script to a file geodatabase (script is nealry the same) an I get the error massage "The cursor has been invalidated because the edit operation has stopped." The script includes an UpdateCursor and the error appears at updateRow(). Another strange thing is, that the first iteration works fine, and the error appears when doing the second iteration.. Does somebody know where the difference between "updateCursor - shapefile" and "updateCursor - file geodatabase" is? I am working with ArcGIS 10.2, Python 2.7, Windows7. Does anybody know this kind of error? Best regards, Stefan
... View more
01-09-2015
02:17 AM
|
0
|
1
|
4592
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|