Latest Contributions by BradJones

I'm working on a Python add-in with a combobox where a user queries a table of facilities by name then zooms to a feature selected (many more steps because it's a nonspatial table with related featureclass). Because there can be multiple facilities with the same name I have the results in a query table added to the TOC.  If there is only one result the mxd it zooms to the selected extent.  If the result is >1 I want to populate a combo box (same or second one) with the results in the query table so the user can select from that list (facility name and address). The problem is it won't recognize the results query table in the mxd. When I create a search cursor to read the query table and append them to the combobox I get: RuntimeError: 'in_table' is not a table or a featureclass Here is the code from  onFocus.     def onFocus(self, focused):         # Empty the Combobox items list         self.items = []         # Establish a reference to the current MXD         mxd = arcpy.mapping.MapDocument("Current")         print mxd         # Establish a reference to the first DataFrame object in the current MXD         df = arcpy.mapping.ListDataFrames(mxd)[0]         print df         # Create table object for results query table         qtable = arcpy.mapping.ListTableViews(mxd, "results", df)         print qtable         with arcpy.da.SearchCursor(qtable, ["Name", "Address"]) as cursor:             for row in cursor:                 self.items.append(row)                 print row         del mxd, df This is my first Python add-in. Thanks EDIT: Here is some more code:     def onEnter(self):         # Set current mxd and dataframe.         mxd = arcpy.mapping.MapDocument("CURRENT")         df = arcpy.mapping.ListDataFrames(mxd, "")[0]         # Make Query Table         env.workspace = r"********PATH TO SDE CONNECTION********"         eadFacil = "FEATURECLASS"         print(query)         table = arcpy.MakeQueryTable_management(eadFacil, "results", "", "", "", "Name" + " like '%" + query + "%'")         print(table)         result = arcpy.GetCount_management(table)         count = int(result.getOutput(0))         print(count)         # Conditional statement based on number of results returned.         if count == 1:             with arcpy.da.SearchCursor(table, ["BO", "Factype"], "Name" + " like '%" + query + "%'") as cursor:                 for row in cursor:                     building = row[0]                     print building                     code = row[1]                     print code ... View more

I'm a total noob when it comes to the JavaScript API.  I'm teaching myself.  I'm trying to use the UniqueValueRenderer to render one of my feature layers.  When I do it with a simple renderer in the code that's commented out it works.  When I use UniqueValueRenderer or ClassBreaksRenderer the layer doesn't draw.  What am I missing? Thanks require(["esri/map",         "esri/layers/FeatureLayer",         "esri/symbols/SimpleLineSymbol",         "esri/renderers/UniqueValueRenderer",         "esri/InfoTemplate",         "dojo/on",         "dojo/_base/Color",         "dojo/domReady!"], function(Map,         FeatureLayer,         SimpleLineSymbol,         UniqueValueRenderer,         InfoTemplate,         on,         Color) {     var map = new Map("map", {         basemap: "streets",         center: [-92.331404, 34.746788],         zoom: 13,         logo: false     });     // create the FeatureLayer object     var sewerLines = new FeatureLayer("http://maps.lrwu.com/wa/rest/services/MoreLayers/MapServer/1", {         mode: FeatureLayer.MODE_ONDEMAND,         outFields: ["UPS_MH", "DWN_MH", "PIPLEN", "PIPDIA", "UPS_DWN", "UNITTYPE"],         displayOnPan: false     });     var manholes = new FeatureLayer("http://maps.lrwu.com/wa/rest/services/MoreLayers/MapServer/0", {         mode: FeatureLayer.MODE_ONDEMAND,         outFields: ["MH_NO", "SERVSTAT", "MHDPTH", "INSTDATE", "DROPMH", "OWN", "COMPKEY"],         displayOnPan: false     });     var eadFacilities = new FeatureLayer("http://maps.lrwu.com/wa/rest/services/MoreLayers/MapServer/7", {         mode: FeatureLayer.MODE_ONDEMAND,         outFields: ["BO_UNIQ", "PERMITTEE", "PERMITTYPE", "ACCOUNTNO", "TRUNKLINE"],         displayOnPan: false     });     //Set the symbol and render the sewerLines     //var symbol = new SimpleLineSymbol(     //                SimpleLineSymbol.STYLE_SOLID,     //                new Color([255,0,0,1]),     //                3);     var renderer = new UniqueValueRenderer(null, "UNITTYPE");     renderer.addValue("GRAVITY", new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([0, 0, 0, 1]), 3));     renderer.addValue("FORCE", new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([ 0, 0, 255, 1]), 3));     renderer.addValue("PRVGRV", new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([0, 128, 0, 1]), 3));     sewerLines.setRenderer(renderer);     // addLayers must use an array to list layers added.     map.addLayers([sewerLines, manholes, eadFacilities]); }); ... View more