Latest Contributions by ToddHenry1

I'd like to add two more. 1.  Enable the user to give a new for the resulting layer instead of Query Name_Result.  This is especially useful if you have the create new layer each time the query is run option enabled.  Sometimes, I want to see two different subsets of the same layer / service on the map and then run some analysis.  It is hard to remember which one is which. 2.  Enable the user to remove those layers from the map directly from the Layer widget instead of re-opening the query widget.  I often end up with many query layers as I use it to view a trade area of a specific location. ... View more

Scott, Here is the screenshot again. Please let me know if you can’t see it or I need to put it in a zip file. ... View more

Scott, The reason for the request is that users like to look at both the pivot table and the map. When reviewing the pivot table it would be convenient for them to see the name associated with the location. Here is a screenshot of the pivot table without our data that shows the setup. If you put the pivot table in tabublar view, the data for each point is on 1 row. It did figure out how to get the store name from my ArcGIS Online content to show up in the pop-up by including it as a field when I created the custom location type. <http://www.dickssportinggoods.com/home/index.jsp> Todd Henry Sr Technical Manager, Real Estate Market Research 345 Court Street l Coraopolis, PA 15108 todd.henry@dcsg.com<mailto:todd.henry@dcsg.com> l o: 724.273.4026 l m: 412.522.3269 <http://www.facebook.com/dickssportinggoods>[cid:image003.jpg@01CEB48E.2B0533C0]<https://twitter.com/DICKS> ... View more

It would be a much simpler workflow to do it from the attribute table instead of having to go to the item details or use the export data analysis tool (which uses credits).  Our users want easy access to the results of their anlaysis and being able to export easily is important. ... View more

I need it because the field order in the underlying database table is how the fields are ordered by default when I use publish them to a feature service. When I try to use that service in ArcGIS Online and I want to re-arrange the fields to make it easier for editors to fin similar information, the process for reordering those fields for editing is very tedious. I believe it also impacts the field order when editing in Desktop. <http://www.dickssportinggoods.com/home/index.jsp> Todd Henry Sr Technical Manager, Real Estate Market Research 345 Court Street l Coraopolis, PA 15108 todd.henry@dcsg.com<mailto:todd.henry@dcsg.com> l o: 724.273.4026 l m: 412.522.3269 <http://www.facebook.com/dickssportinggoods>[cid:image003.jpg@01CEB48E.2B0533C0]<https://twitter.com/DICKS> ... View more

It would be helpful in the Attachment Manager within ArcMap to be able to rename attachments without having to find them in the related attachment table.  Often photos get created with generic names and we would like to make them more descriptive so people know what they are going to see when they view the attachment. ... View more

Dan, Sometimes I would have more than 10 items to concatenate.  Also, I'm not sure where I would insert that into the code.  I took a stab at creating a new variable called sort_field which I can get to populate in the tool, but I'm getting a data type error when running it because it is looking for a string and found a float field.   Here is the part of the code where I think I want to use that sort_field. # Group a sequence of case field ID's and value pairs into a dictionary of lists.     dictionary = collections.defaultdict(list)     try:         srows = None         srows = arcpy.SearchCursor(input_table, '', '', '', '{0} A;{1} A'.format(case_field, from_field))         for row in srows:             case_id = row.getValue(case_field)             value = row.getValue(sort_field)             if from_field in ['Double', 'Float']:                 value = locale.format('%s', (row.getValue(from_field)))             if value <> None:                 dictionary[case_id].append(value)     except RuntimeError as re:         arcpy.AddError('Error in accessing {0}. {1}'.format(input_table, re.args[0]))     finally:         if srows:             del srows     try:         urows = None         urows = arcpy.UpdateCursor(input_table)         for row in urows:             case_id = row.getValue(case_field)             values = dictionary[case_id]             f = u''.join(unicode(val) for val in values)             if not delimiter == '':                 if (len(f) + (len(values)-1)) > to_field_length:                     arcpy.AddError('Length of the Copy to Field is less than the length of the content you are trying to copy.')                 else:                     if from_field_type in ['String']:                         if to_field_type in ['String']:                             row.setValue(to_field, delimiter.join(sorted(set([val for val in values if not value is None]))))                     else:                         row.setValue(to_field, delimiter.join(sorted(set([str(val) for val in values if not value is None]))))             else:                 if to_field_type in ['String']:                     if len(f) > to_field_length:                         arcpy.AddError('Length of the Copy to Field is less than the length of the content you are trying to copy.')                 else:                     if from_field_type in ['String']:                         if to_field_type in ['String']:                             row.setValue(to_field, delimiter.join(sorted(set([val for val in values if not value is None]))))                     else:                         if to_field_type in ['String']:                             row.setValue(to_field, delimiter.join(sorted(set([str(val) for val in values if not value is None]))))                         elif to_field_type in ['Integer', 'SmallInteger'] :                             row.setValue(to_field, int(delimiter.join(sorted(set([str(val) for val in values if not val is None])))))                         elif to_field_type in ['Double', 'Float']:                             row.setValue(to_field, float(delimiter.join(sorted(set([str(val) for val in values if not val is None])))))             # Date formatting can be edited to match local.             if from_field_type in ['Date']:                 row.setValue(sort(to_field, delimiter.join([val.strftime('%d%m%Y') for val in values if not val is None])))             urows.updateRow(row) ... View more

Was this every fixed or did someone discover a workaround to print an extent that isn't the default from the Data Driven Pages setup? ... View more

Dan, 1.   The concatenated field does not have to be sorted but would be the secondary sort, if I used it. 2.  I'm sorting numeric data (distances) Here is a quick illustrative sample ID       Competitor   Distance       Current Concatenated Output      Desired Output 1         A  (5.00)              5                   A (5.00), B(2.00)                    B(2.00), A (5.00) 1         B (2.00)               2                  A (5.00), B (2.00)                    B (2.00), A (5.00) The current tool sorts by the Competitor Field which is the field to be concatenated. I then use subsequent tools in my model to get just one records for ID 1. ... View more

This is a big issue for us.  If our users are in the Eastern Time Zone and enter date, our SQL database stores the time value as 5 AM of the day they entered which I believe is 5 AM UTC.  If a user in the Pacific time zone views a pop-up with that information it will show the day before because that translates to 9 PM PST time on the previous day. Does anyone have a status on this fix. ... View more