Latest Contributions by KimberlyGarbade

I don't see an error in the code....I guess you could try substituting 'Address' for '1' after the expression: keyword in line 6... but that seems like a long shot. Is your data coming from portal or AGOL, or straight from a geodatabase?  What version of ArcGIS Pro are you using?  Are you sure your license plate number is a text field?   If the data is coming straight from a database and your pro version is 2.5 or newer and your GUID looking ID is indeed in text format, then I'm think there might be something "off" in you data.  What that something is I don't know, but I don't believe in coincidences (much) and it seems like a coincidence that no matter the potential solution, it gets to a certain point and fails... each time with a new message. You could try exporting out a very small subset of your data (like ten records) and testing the process against that.  If it works or it doesn't its a clue.  If it works, its a clue that one or more records in your input data have something in them that is disrupting ArcGIS.  If it doesn't try substituting some "simpler" plate numbers (something like "ABD123") in the your test data and trying again... or simpler address ("1234 ABC ST W")... if that fails I'm at a complete loss. Sorry for sending you down rabbit holes, but that's all I can think of. I  ... View more

New approach... You can uses Arcade. I added a text field (MultipleAddressMessage) to my table and populated it like this using Calculate field using an Arcade expression: Using this Arcade code:  var License = $feature.LongPlate //get all records having the plate in this record var test = Filter(FeatureSetByName($datastore,"TestPoints",['LongPlate','Address'],true),"LongPlate = @License") //Use GroupBy to get the stats you want - return type is another feature set. //returns a feature set having an Address column and a NumberOfAddresses column var result = GroupBy(test,'Address',{name: 'NumberOfAddresses',expression: '1', statistic: 'COUNT'}) //Check for null Feature Set If(IsEmpty(first(result))){ //if null return 'not parked' return 'not parked' //should never happen but have to test for null } else { for(var instance in result){ //Step through GroupBy returned feature set and derive the values you want var TotalInstances = TotalInstances + instance.NumberOfAddresses var NumUniqueAddresses = NumUniqueAddresses + 1 } return "Plate number: " + first(test).LongPlate + " appeared at " + text(NumUniqueAddresses) + " unique address a total of " + text(TotalInstances) + " times." } ... View more

That is indeed what I was asking. That plate value field is quite the value... let me test with a GUID like number and very verbose addresses... Still works for me (see below).  Have you limited your selected features somehow.. you mentioned a definition query (I also applied one to my test and it had not effect on it working, but maybe yours returns zero records or something odd like that).  You could try export your data to a new file GDB and then running the tool against that data using the same file GDB to hold the generated stats table.   ... View more

Hmmm.... I didn't do anything "fancy" (below).  Can you share a screen shot of your data's table as an example? Also, what are the field definitions of "Plate_value" and "Address"?   ... View more

You can use the frequency geoprocessing tool: Original Data:    Frequency Table generated by tool:   ... View more

You can't unrun the model (as far as I know).  You could restore from a backup you made before you ran the model initially.  If you don't have one, you'll have to go into the table or feature class that has the duplicated fields and delete them.... you can right click the field in table view and click "Delete" or use the "Fields" pane to manage the fields.   K ... View more

That code works for me no problem (at first I thought Arcade might be baulking at the use of variable names that could be reserved words...I.E. "field" and "fields"), but in SQL Server at least that is not the case (I'm assuming you are talking about Oracle 18.1).  I'm not much of an Oracle person.  Can you tell me about the "ref_Cadastral_Denbury_Field" layer (I'm assuming feature class).  Is it in the same geodatabase as the feature class you are adding or editing $feature to/in?  Who owns "ref_Cadastral_Denbury_Field"?  Do you have permission to use it?  ... View more

Sorry.  No easy way.  Just a not so bad way. If your data is in a database table leave it their before you convert the data to points.  Then create a database view using SQL similar to that shown below. Original Data (SQL Table, could have been imported from .csv): Use the "Create Database View" geoprocessing tool using this code easier to read version below Then you can use this view (TestView in my case) to create a new query layer in your map by dragging it onto your map's table of contents.  The new query layer looks like this: You can now use the add data tool's X,Y point conversion tool to bring the data into the map in such a way that it can use Pie Chart Symbology  As for the weights being in text, you can make the conversion when you make your database view using the SQL CAST() function... something like this should work:   Hope this helps.    ... View more

Sorry to ask another question, but I'm trying to picture the data: each tow will have many records in the table; one for each fish type?  For example: If this is true is this a table linked to a point feature class or is it a feature class with multiple points at the same location.. I.E. stacked on top of each other, one point for each fish type at each tow location? ... View more

Can you show us a sample of the data you want to summarize in the Pie Chart symbols... an image of the fields you have to use and their values maybe; or a sample .csv file? ... View more

I hope I understand what you mean by "Predominant Incident".  I defined it to mean if you had 10 car crashes (for example 5 Multi Car, 3 Single Car, 1 Bicycle, 1 Pedestrian) the predominant type would be "Multi Car" Another thing I will say is that I'm testing this on my home ArcGIS Pro single use install, so I didn't write the Arcade for a dashboard pulling from a portal, but the logic should be pretty similar. I had test data laying around so I used  that and wrote an attribute rule to populate a new field named "Predominent" (spelled wrong) with the predominant value from the TextTst field (in the image below I updated the IntTest field from 6 to 7 to fire the Arcade to populate the Predominent field) The expression I used uses OrderBy (DESCending) to order the feature set returned by the GroupBy function in descending order from most to least occurrences of COUNT.  The First function just takes the first record from this ordered feature set.  The only problem is if you have a tie its only going to take the first one. Here it is in plain text: return First(OrderBy(GroupBy((FeatureSetByName($datastore, 'TestPoints',['TxtTest'],false)), 'TxtTest',{name: 'NumberTest', expression: '1', statistic: 'COUNT'}),'NumberTest DESC')).TxtTest Hope this helps. K ... View more

Hmmm... I do see the behavior you are talking about.  When you use a custom expression to set the symbology values and you set the scale for these symbols using the sliders, the labels for these features draw regardless of the scale you are viewing the data at in your map, and this is not true when you just use two fields rather than a custom setting (in this scenario the labels turn on and off with the lines). I would say if its a bug its a small one...maybe an inconsistency. You can fix this behavior by setting the scale at which your labels turn on and off (as in the image below).  When I set the In Beyond or Out Beyond values for both layers in the table of contents (one set up each way you describe), the labeling functions as expect (and identically) for both scenarios.     ... View more

Have you updated a layer recently?  I've seen this kind of error when you've initially symbolized or labeled based on a layer's attributes and then, later, the schema of the layer changed in such a way that the attribute the symbol of label was based on has been renamed, deleted, or its contents have changed in such a way as the filter being used cannot find the requested values.  ... View more

I usually steal the instance name right from SSMS when I can't remember it (which is more often lately).  Its the same as the Server name in the SSMS database connection dialog:   ... View more