Latest Contributions by LisCollins

Hi all, I have been having trouble with getting Calculatefield_management to accept my SQL expression variables. I have tried various ways to enter the variables to get the first two calculate field functions to work. The error is now occurring with the 3rd calculate field/expression3/calculating the NA in the code below. [arcpy.CalculateField_management(inFeatures, fieldName3, expression3, "PYTHON_9.3")] I get different errors depending on how I enter in the variable. One of the errors I get while debugging now: Traceback (most recent call last):   File "test.py", line 175, in <module>     arcpy.CalculateField_management(inFeatures, fieldName3, expression3, "PYTHON_9.3")   File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\management.py", line 3354, in CalculateField     raise e ExecuteError: ERROR 999999: Error executing function. The value type is incompatible with the field type. [NA] Failed to execute (CalculateField). Method The first calculatefield updates the RG field based on the numbers in the !Join_Count! features column. RG is a short integer. The second calculatefield updates the PG field which is (!RG!/sum of RG) * 100. PG should be a float since it's finding the percentage. The third calcualtefield udpates the NA field which is !PG! * 12425. NA should be a short integer. Any suggestions on how I can write expression3 to be the correct field type format for NA? Thanks. My Background -Novice Programmer -Using the Python 2.75 Idle Shell -Using ArcMap 10.2.1 Sample Code Snippet: # Import ArcPy site-package to use Arcgis and os modules to use operating system import arcpy, os, sys, string, numpy from arcpy import env env.overwriteOutput = True #set environment settings to where mxd is saved env.workspace = r'J:\folder\scripts' #folders output = r'J:\folder\scripts\output' + "\\" inFeatures = output + "joined_" + c.name + "_" + w.name + ".dbf" print inFeatures #First Calculate Field from spatial join count numbers fieldName = "RG"    #SHORT expression = '!Join_Count!'   #LONG type arcpy.CalculateField_management(inFeatures, fieldName, expression, "PYTHON_9.3") print "Join Count numbers added to RG Field" #Need sum of rg... arr = arcpy.da.FeatureClassToNumPyArray(inFeatures, ('RG')) # Sum the RG field print "The total sum of features in RG is: " rg_sum = arr["RG"].sum() print rg_sum flnum = "!RG!" print flnum #Calculate PG which equals (!RG!/Sum of !RG!) * 100 fieldName2 = "PG"   #FLOAT type, it's a percentage number arcpy.CalculateField_management(inFeatures, fieldName2, "(float('!RG!')) / " +  str(rg_sum) + "* 100" , "PYTHON_9.3") arr = arcpy.da.FeatureClassToNumPyArray(inFeatures, ('PG')) PG_sum = arr["PG"].sum() print "The total sum of features in PG is: " + str(PG_sum)  #should equal 100.0 # Calculate NA, which equals !PG! * 12425 fieldName3 = "NA"   #SHORT type, it needs to be a whole number expression3 = "'!PG!' * 12425" arcpy.CalculateField_management(inFeatures, fieldName3, expression3, "PYTHON_9.3") arr = arcpy.da.FeatureClassToNumPyArray(inFeatures, ('NA')) NA_sum = arr["NA"].sum() print "The total sum of features in NA is: " + str(NA_sum)  #needs to equal 12425 ... View more

Hi, I have a web map where users want to be able to add their own text to the map. But for some reason the code is ignoring my if statement that says only add text when button is clicked. What it's currently doing: -When user clicks on map, the default text entered in the Text Box displays on the map. -When user presses the submit text button, clicks on the map, the text entered in the Text Box displays on the map. -Text is added to the map even after the submit button was pressed once when user clicks on map. -It conflicts with the other tools in the map like the measure tool. What I want it to do: -I only want the text in the text box to show after the submit button is pressed once not conflict with other tools. [Ex., user presses the submit button, clicks on map, text is added to the map. User clicks on map again, no text is added to the map. If user wants text to be added to the map again, the user will have to click the submit button again.] Background Info: Level: newbie JS developer. Using ESRI JavaScript API - ESRI's Public information web map template: Esri/public-information-map-template-js · GitHub This code was added to the main.js file in the _init: function (). The code is posted below. Suggestions appreciated. Thanks. if (this.config.enableAddText) {              if (query("div#TextButton .dijitButton .dijitButtonNode").on('click', lang.hitch (this, function()           {console.log("if query text button accessed")                })))      {      var map = this.map;      console.log("text button was clicked");      query("div#mapDiv").on('click', lang.hitch (this, function (evt){      var map = this.map;         map.graphics.add(             new Graphic(             new Point(evt.mapPoint.x, evt.mapPoint.y, new esri.SpatialReference({ wkid: 102100 })),             new TextSymbol(dojo.byId("tsText").value).setColor(                    new Color([0,0,0])).setAlign(esri.symbol.Font.ALIGN_START).setAngle(0).setOffset(0,0).setFont(                    new Font("12pt").setWeight(esri.symbol.Font.WEIGHT_BOLD))                     )         );         console.log(map);         console.log(evt.mapPoint.x);         console.log(evt.mapPoint.y);         console.log(dojo.byId("tsText").value);         console.log("added text graphic");                    }));              }                      }; ... View more