Latest Contributions by FilipKrál

Hi Alice, Did you try to configure the web adaptor again? Configuring the ArcGIS Web Adaptor I would check the site security settings, which you have probably checked already anyway. Sorry I cannot give you better advice. F. ... View more

Hi, Some time ago I asked a similar question and I am guessing the same answer applies to you. Can 10.2 answer Oracle where clause? Statements with LIKE operator are not standardized queries and they are disabled in 10.2+ by default. ArcGIS Help (10.2, 10.2.1, and 10.2.2) Hope this explains the issues you are having. Filip. ... View more

Hi Nuria, Bellow is the way I would do it (not tested). I am not sure if you need your keys in the dictionary of mean rainfall for each month to be the full name of the month. I used the number of the month (1 for January, 2 for February, ..., 12 for December) because it becomes much easier to write. If you need to work with full names of months, you should be able to reuse my code if you just add another dictionary to lookup the full name of a month by its number. Also, it really helps if you use the syntax highlighting feature of the advanced editor when pasting code to geonet. Here is how to do it: Posting Code blocks in the new GeoNet import arcpy fc = r'full/path/to/your/feature_class' lookup_mean_for_month = {1: 2.1, 2: 3.2, ..., 12: 2.8} # 12 items column_names = ["_20100101", "_20100201", ..., "_20121001"] # 36 elements arcpy.da.UpdateCursor(fc, column_names) as uc:     for row in uc:         newvalues = []         # you need an index to lookup the right column name         # because arcpy.da cursors don't remember column names         i = 0                  for cell in row:             column = column_names             # get the month from the column name             # "_20100101" -> 1, "_20100201" -> 2, ... etc.             month_index = int(column[5:7])             mean_for_month = lookup_mean_for_month[month_index]             # replace values lower than the mean of the month with zero             if float(cell) < float(mean_for_month):                 newvalues.append(0.0)             else:                 newvalues.append(cell)             i += 1 # increment i as you move onto the next cell in the row         # that is one row done, so save it:         uc.updateRow(newvalues)         # and move onto the next row ("for row in uc" loop continues) Hope this helps. Filip. ... View more