Latest Contributions by badrinathkar

我想填充字段(MaxElv)选择highest value from another field (Elevation) based on the Id field (Id). The data looks like this: Id Elevation MaxElv 1 50 1 72 1 83 1 66 2 105 3 27 3 24 2 98 1 46 3 22 2 96 3 26 2 99 4 25 4 21 4 22 3 28 1 52 I have develop the following code: >>> import arcpy ... fc = 'Country' ... CountryList = [] ... with arcpy.da.SearchCursor(fc, ["Id"]) as cur1: ... for row1 in cur1: ... if row1[0] not in CountryList: ... CountryList.append(row1[0]) ... ... for i in CountryList: ... ElevList = [] ... where = """{} = {}""".format("Id", i) ... with arcpy.da.SearchCursor(fc, ["Elevation"], where) as cur2: ... for row2 in cur2: ... if row2[0] not in ElevList: ... ElevList.append(row2[0]) ... ElevList.sort() ... max_Elev= ElevList[-1] ... where2 = """{} = '{}' AND {} = {}""".format("Id", i, "Elevation", max_Elev) ... with arcpy.da.UpdateCursor(fc, ["MaxElv"], where2) as cur3: ... for row3 in cur3: ... row3[0] = 1 ... cur3.updateRow(row3) But it gives the following error Runtime error >>> import arcpy ... fc = 'Country' ... CountryList = [] ... with arcpy.da.SearchCursor(fc, ["Id"]) as cur1: ... for row1 in cur1: ... if row1[0] not in CountryList: ... CountryList.append(row1[0]) ... ... for i in CountryList: ... ElevList = [] ... where = """{} = {}""".format("Id", i) ... with arcpy.da.SearchCursor(fc, ["Elevation"], where) as cur2: ... for row2 in cur2: ... if row2[0] not in ElevList: ... ElevList.append(row2[0]) ... ElevList.sort() ... max_Elev= ElevList[-1] ... where2 = """{} = '{}' AND {} = {}""".format("Id", i, "Elevation", max_Elev) ... with arcpy.da.UpdateCursor(fc, ["MaxElv"], where2) as cur3: ... for row3 in cur3: ... row3[0] = 1 ... cur3.updateRow(row3) But it gives the following error Runtime error Traceback (most recent call last): File "", line 20, in RuntimeError: An invalid SQL statement was used. Traceback (most recent call last): File "", line 20, in RuntimeError: An invalid SQL statement was used. ... View more

我已经pythan worksp脚本工具ace + "/Data.shp" is sucessfully saving the files as here: >>> import arcpy ... import os ... import sys ... from arcpy import env ... arcpy.env.overwriteOutput = True ########################################### ... InFc = arcpy.GetParameterAsText(0) ... workspace= arcpy.GetParameterAsText(1) ... Output_Data_shp = workspace + "/Data.shp" ... Output_Table_dbf = workspace + "/Table.dbf" ... # Process: Table Select ... arcpy.TableSelect_analysis(InFc, Output_Table_dbf, "") ... # Process: Dissolve ... arcpy.Dissolve_management(InFc, Output_Data_shp, "", "", "MULTI_PART", "DISSOLVE_LINES") But when I allow users to define the path, the tools fails to execute. For this I used following code: >>> import arcpy ... import os ... import sys ... from arcpy import env ... arcpy.env.overwriteOutput = True ########################################### ... InFc = arcpy.GetParameterAsText(0) ... Output_Data_shp = arcpy.GetParameterAsText(1) ... Output_Table_dbf = arcpy.GetParameterAsText(2) ... # Process: Table Select ... arcpy.TableSelect_analysis(InFc, Output_Table_dbf, "") ... # Process: Dissolve ... arcpy.Dissolve_management(InFc, Output_Data_shp, "", "", "MULTI_PART", "DISSOLVE_LINES") For information, I am running the Python script inside a normal toolbox (i.e. not inside a python toolbox). I have defined the data types correctly under the Parameters tab of the script. Although python is quite new to me and I am not trained enough to implement codes into the script to detect errors, I think the GetParametersAsText defines the directory with Single Backslash (/) which hinders the tool to execute. Any suggestions to solve the issue? Thanks in advance. ... View more