Latest Contributions by RichardFairhurst

My instructions would give you the 42 year average by Month if this table has 42 rows (i.e., One row with 12 month column each giving the mean/average value of water for each month.  Otherwise what field defines the Cell?  If there is a field that has cell ID values then make that the Case Field in the Summary Statistics tool.  But then how do you you know which year is which in this table?  Are you sure you have correctly described what data this table contains?  Beyond the month names none of the other column names mean anything without an explanation. No matter what, the Summary Statistics tool is the tool that does what you are after since this is not a spatial feature class, just a table.  If this was a Feature Class then the Dissolve tool would be better to do the summaries spatially. ... View more

Use the Summary Statistics tool in the Analysis Toolbox -> Statistics toolset without any case field and add each month to the summary field list and use the Mean option.  Optionally you can add each month multiple times to get the Min, Max, and Std Dev as well at the same time using this tool. ... View more

It cannot be done with standard layer symbology.  There is no equivalent to label classes, which can apply multiple scale dependent settings to labels in a single layer, that applies to standard layer symbology.  The Labels tab has a "Scale Ranges..." button, which is required to set up that behavior, but the Symbology tab does not have any button like that.  Scale ranges only affect standard layer symbology by making it visible or invisible, not by altering any layer symbology settings.   You must create separate layers with separate scale ranges and symbology styles to do this with standard layer symbology, which most people manage in a group layer. Representations possibly can do this, but I have never tried setting that up myself.  After looking at the help though it appears that even repesentations rely on different layers to control multiple scales, at the very least no help topic clearly explained how more than one representation rule based on scale range could be applied to a feature within a representation.  In fact, although it is a bit vague and unclear, it seems to suggest that multiple scale range control of representations may also possibly involve multiple layers of feature classes in this help topic: Do you need to use this dataset at multiple scales? How will the representations change at each map scale? You may find that you'll need alternative feature class representations for use at other scale ranges. In these cases, you can consider additional feature classes for representing the same data theme for each scale range. I do not believe that "alternative feature class representations for use at other scale ranges" can be applied within a single layer any more than multiple standard layer symbology configurations based on scale can be applied to a layer You must adapt your requirements to fit the way the software works.  Sorry. In general, Esri favors designing simple, limited rules for layers and geoprocessing operations that requires a user to generate a new layer or geoprocessing output any time they want to go beyond those rules, rather than designing complex, sophisticated rules that can make a single layer or geoprocessing operation serve a wider range of behaviors. ... View more

I have used this tool repeatedly with 10.2 and never seen that error.  So it is definitely not the version causing the problem. What kind of table is the event table?  I never recommend using Excel for anything in ArcMap if that is what you are using.  I always convert Excel tables to File geodatabase tables. Can you screen shot your set up screen for the tool?  How did you assign the tool parameters?  Did you browse for the event source?  Are the route source and event source in your map or being access from disk?  Is this behavior occurring as part of a model or script or just from running the tool directly manually?  Do you have full access rights to the output workspace?  Are there spaces or special characters in the folder or file names?  Sounds like an error creating the output table.  Is that correct? ... View more

I would think that to select one of each Category all at once in the layer you would want the code to be like this: import arcpy  """Get the current map layers."""  mxd = arcpy.mapping.MapDocument("CURRENT")  lyrName = "line" """Find the layer name"""  lyr = arcpy.mapping.ListLayers(mxd, lyrName)[0]  dict = {}  with arcpy.da.SearchCursor(fc, ["Category", "OID@"]) as cursor:      for row in cursor:         keyValue = row[0]         if not keyValue in valueDict:             dict[keyValue] = row[1]    del cursor  #perform selection based on one ObjecctID value from each Category  whereClause = "OBJECTID IN (" for key in dict:    if whereClause == "OBJECTID IN (":        whereClause = whereClause + str(dict(key))     else:        whereClause = whereClause + ", " + str(dict(key)) whereClause = whereClause + ")" arcpy.SelectLayerByAttribute_management(lyrName, "NEW_SELECTION", whereClause) print 'finished' ... View more

Try the code now.  I was trying to write it without testing, but now I have tested it on my own data.  131652 records summarized based on 16040 unique ID categories were processed in 1 minute 8 seconds. ... View more

An Insert cursor would probably be the best for creating a new feature class and would finish in less than 2 minutes most likely.  I would not do this, unless you create a unique key for each point that is not the ObjectID, since without that you have no way to reliably relate the new feature class to the old.  So I won't do this based on what you have shown. Select by Attribute, especially using the Add to Selection option is time consuming, but it was necessary if I was to do what you originally asked and not alter the schema of the table.  The only way to avoid days of processing is to create a new flag field indicating if the record was in the Top 20% or not and use an update cursor to populate it.  Then you could use a simple SQL selection on that field.  That could complete in under 3 minutes.  I will assume that is what you will do, since it is the easiest for me to recode and the most flexible for exporting and processing. ... View more

The code has been written to work as an Advanced Label Expression, not as a field calculation.  For a field calculation I would write it like: Parser:  VB Script Use Codeblock:  Checked Pre-Logic Codeblock: Output = [NAME] dblQoute = instr(Output, chr(34)) if dblQuote > 0 Then  Output = Left(Output, dblQuote - 1) & " inch" NAME= Output ... View more

Caught that and fixed it in my post just before I saw your reply.  Retry the code. ... View more

You should have included that detail in your description of what you were trying to do, since dropping text is a completely different issue.  So Try: Function FindLabel ( [NAME] )   If Not IsNull([NAME]) Then     NewStr = [Name]     If Instr(NewStr, chr(34)) > 0 Then       NewStr = Left(NewStr, Instr(NewStr, chr(34)))     End If     NewStr = Replace(NewStr, chr(34), " inch")     FindLabel = NewStr   End If End Function ... View more

To make all quotes turn into " inch" your VB Script label code should be: Function FindLabel ( [NAME] )   If Not IsNull([NAME]) Then     NewStr = Replace([NAME], "''"", " inch")     FindLabel = NewStr   End If End Function This assumes no quote character in your data is a real quote character and always changes to inch.  If that is true, you should not have to deal with the full field value in your features, just the quote character. ... View more

Well I misread your earlier post.  !Shape@Area! and !Shape@Length! are the area and perimeter values of the feature in its native units.  So is this just a simple unit conversion problem?  If so, once you know the native units of the feature you can get the conversion factors from here and apply them to the row[2] and row[3] values to get square meters and meters.  Or you could provide a Spatial Reference that used meters as the cursor's fourth parameter and then the !Shape@Area! and !Shape@Length! would return values in square meters and meters. If you are trying to independently calculate area and confirm the values against those of the area and length returned by the shape method, than the euclidean distance method I gave will be one method for doing that for the perimeter length, provided the distances are not covering a large portion of the globe's surface.  For area calculations I don't know an independent formula that will work for all possible polygon shapes (which in part accounts for why we buy Esri's product to take advantage of people who have figured that out).  Using the !Shape@Area! values, or the getArea values from a geometry would be the approaches I would take. ... View more