Latest Contributions by JakeSkinner

You can create an XY Event Layer from the excel table using the Make XY Event Layer tool.  You can then Append the output from this tool to the SLEEVES feature class. ... View more

1.  You can add an 'else' statement with an alert message if the matching candidate is not greater than 80.  Ex:         if (candidate.score > 80) {             console.log(candidate.score);             var attributes = {                 address: candidate.address,                 score: candidate.score,                 locatorName: candidate.attributes.Loc_name             };         geom = candidate.location;         var graphic = new Graphic(geom, symbol, attributes, infoTemplate);         //add a graphic to the map at the geocoded location         map.graphics.add(graphic);         //add a text symbol to the map listing the location of the matched address.         var displayText = candidate.address;         var font = new Font(             "16pt",             Font.STYLE_NORMAL,             Font.VARIANT_NORMAL,             Font.WEIGHT_BOLD,             "Helvetica"         );                 var textSymbol = new TextSymbol(             displayText,             font,             new Color("#666633")         );         textSymbol.setOffset(0,8);         map.graphics.add(new Graphic(geom, textSymbol));             return false; //break out of loop after one candidate with score greater than 80 is found.         }         else{             alert("No results found, please enter another address");         }         }); 2.  Add 'autofocus' property to the input tag.  Ex: <input type="text" id="address" value="380 New York St, Redlands" size="30" autofocus="autofocus"/> ... View more

Hi Neil, Looks like you are trying to iterate through the shape field, which won't be possible, unless you are working with a multipoint feature class: for pnt in row[1]:         print("{0}, {1}".format(pnt.X, pnt.Y)) However, you can return the XY coordinates a couple ways: for row in arcpy.da.SearchCursor(infc, ["OID@", "SHAPE@"]):     print("Feature {0}:".format(row[0]))     print row[1].centroid.X, row[1].centroid.Y or: for row in arcpy.da.SearchCursor(infc, ["OID@", "SHAPE@XY"]):     print("Feature {0}:".format(row[0]))     print row[1] ... View more

You can use the datatype property of the Describe function to do this.  Ex: desc = arcpy.Describe(fc) print desc.datatype ... View more

You can add an IF statement.  Ex: with arcpy.da.SearchCursor(fc, ["AddressID"]) as cursor:         for row in cursor:             if "CC" in row[0]:                 list.append(int(row[0].strip("CC")))        del cursor ... View more

Hello, If you want to delete fields, you will want to use the Delete Field function. ... View more

What you need to do is strip 'CC' from the AddressID and then convert the value to an integer before appending it to the list.  You can then sort the list, select the last value, add one and then append 'CC' back to this value.  Ex: def onMouseDownMap(self, x, y, button, shift):       arcpy.env.workspace = r"C:\Temp\test.mdb"     fc = "points"     list = []     with arcpy.da.SearchCursor(fc, ["AddressID"]) as cursor:         for row in cursor:             list.append(int(row[0].strip("CC")))            del cursor     list.sort()     AddressID = list[-1] + 1     AddressID = 'CC' + str(AddressID)     row_values = [(x, y, (x, y), AddressID)]     cursor = arcpy.da.InsertCursor(fc, ["X_Coord", "Y_Coord", "SHAPE@XY", "ADDRESSID"])     for row in row_values:         cursor.insertRow(row)     del cursor     arcpy.RefreshActiveView() ... View more

In your case, you need every added point to be greater than the largest AddressID, i.e. CC56560?  If that is the case, what is the larget AddressID? Or, is this tool going to be used for multiple feature classes, and the AddressID varies? i.e. CC00100 is the largest for one feature class, CC032232 is the largest for another feature class ... View more

I may not be understanding what you are looking to accomplish.  Do you want the basemap to not display when the map is loaded?  Then use the button to toggle the basemap on? ... View more

I would recommend creating a text input rather than textarea: <input type="text" id="address" value="380 New York St, Redlands" size="30"/> ... View more

Since AddressID is a text field, you will have to convert it to an int, add 1, then convert it back to a string.  Replace: AddressID = list[-1] + 1 with: AddressID = int(list[-1].strip('CC0')) + 1 AddressID = 'CC0' + str(AddressID) ... View more