Latest Contributions by mpboyle

I can't seem to find a way to filter for empty strings through the Portal map viewer.  We have empty string values within some text fields and are unable to filter these. An empty string value is different than a NULL value, which can be filtered using the "is blank" expression in the map viewer. FYI --- we are using ArcGIS Enterprise 10.7.1 ... View more

I have a fairly simple Sql trigger set to run on a point feature class.  The trigger, however, doesn't seem to execute when the point is initially inserted.  Any subsequent edit of the feature will seem to work as expected.  The trigger is on the add delta table of the feature class.  The screenshot below is a query of the add delta table showing the edit history of a feature (most recent last).  The trigger should update the XCoordinate, YCoordinate, Longitude, and Latitude fields after insert.  You can see that on the initial insert of the feature, those fields remain NULL.  Any edits after initial insert (rows 2-4) show those fields getting updated. Is there some reason the trigger isn't working on the initial insert of the feature?  I am testing by editing through a web map in ArcGIS Enterprise (10.7.1). Below are some details of my feature class, database, etc... and the trigger statement. RDBMS: Sql Server 2014 Standard Geodatabase Version: 10.7.1 Feature Class is Registered as Versioned Feature Class is Archived ALTER TRIGGER [dbo].[triggerName] ON [dbo].[a999] AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- ================================================== -- UPDATE COORDINATE FIELDS -- ================================================== -- update X coordinate field update t set t.XCoordinate = i.SHAPE.STX from EnterpriseDatabase.DBO.a999 as t inner join inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID -- update Y coordinate field update t set t.YCoordinate = i.SHAPE.STY from EnterpriseDatabase.DBO.a999 as t inner join inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID -- update Longitude field update t set t.Longitude = (select db1.dbo.get_longitude(i.SHAPE.STX, i.SHAPE.STY)) from EnterpriseDatabase.DBO.a999 as t inner join inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID -- update Latitude field update t set t.Latitude = (select db1.dbo.get_latitude(i.SHAPE.STX, i.SHAPE.STY)) from EnterpriseDatabase.DBO.a999 as t inner join inserted as i on t.OBJECTID = i.OBJECTID and t.SDE_STATE_ID = i.SDE_STATE_ID‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ END‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

When a search result is not found, the highlighted text is shown.  Is this text string stored in a file somewhere where it can be altered?  We've had a request to include specific contact information if this occurs.  Or...can a javascript file be written to append text to the end? ... View more

I have a service that has a polygon feature class representing parcels, and a related table populated with tax history data.  Using Arcade, I'm able to build a pop-up in a web map that displays the tax information for each tax authority. However, this only seems to work in ArcGIS Online (AGO).  If I use the same service, and the same Arcade expressions within Portal (10.7.1), the pop-up does not display, or seem to retrieve any of the related table information, specifically when calling an iterator to get the individual rows within the related table feature set. If I use the Console function to test if the FeatureSet is returning/finding anything, it seems to indicate that the related records are being found in Portal, as the number of related tax records found is correct...but none of the individual rows within the related table feature set are being returned. Is this a known issue/bug in Portal...?...is there some sort of performance issue in Portal when it comes to retrieving the data? Any ideas...? Below is the Arcade expression being used, and console returns between both AGO and Portal.  AGO returns what I want, Portal does not ... like I said, seems to be specific to the iterator. // get gpn var gpn = $feature.GPN; // construct sql var sql = "GPN=" + "'" + gpn + "'"; // create feature set var fsTaxBill = FeatureSetByName($map, "Tax Bill Distribution"); // order feature set var fs = OrderBy(Filter(fsTaxBill, sql), "TaxGross DESC"); // get feature set count var cnt = Count(fs); // display number of related records found Console('Number of related tax records found: ' + cnt) // create return place holder var p = ""; // check if any related records were found if (cnt > 0) { // create iterator Console("Start iterator...") for (var x in fs) { Console("Within iterator...") // get tax authority var a = x.TaxAuthority; // get and format gross tax var g = "$" + Text(x.TaxGross, "#,###.00"); // add authority and gross tax to place holder p += a + ": " + g + TextFormatting.NewLine } Console("End interator...") } else { // no related tax information found p = "No tax information found..." } // display return value Console(p) // return value return p‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Related table pop-up working in ArcGIS Online AGO console test --- iterator working Related table pop-up NOT working in Portal Portal console test --- iterator NOT working ... View more

I really like the idea of shared pooling instances with the latest releases of ArcGIS Server.  Rather than having dedicated SOC instances running, we can dedicate certain services to participate in the shared pool to save server resources. One thing I have noticed with services participating in the shared pool is that anti-aliasing is not honored for these services.  Once I remove a service from the shared pool, I notice anti-aliasing is honored.  I'm just curious why this is?...and if this is something that can be changed / implemented in future releases? I know this may be a small issue for some, but as someone who enjoys good looking maps, it's one thing I notice right away with services. ... View more

Using the ArcGIS API for Python, is there a way to get the name of a user's folder if provided the folder ID? For example, one of the properties of a portal item is "ownerFolder", which returns the id of the user's folder where the portal item is housed.  This is very helpful if the user has many folders when trying to find the item.  I'd like to know the name of this folder rather than just having the id.  Is there something similar to "content.get('item_id')" that can be used to return folder properties? I'm aware of arcgis.gis.User("user_name").folders ... which returns a list of dictionaries providing information about all the folders a user has.  I don't really want to cross-reference all the user's folders and then match the id, but if that's the only way... ... View more

We currently have an enterprise geodatabase that we use for hosting read-only web services.  I'm wondering if this would be better suited for a local file geodatabase on our ArcGIS Server machine, in terms of read performance? What I'm really interested in is: is there a way to get quantifiable data that would show performance differences? For example, if I had the same feature class in an enterprise gdb and a file gdb, and each are published to separate services, can I be able to determine any noticeable performance gains? ... are the ArcGIS Server statistics a good method for doing this?...are there other tools that would help detect performance differences? My initial thoughts would be: a local file gdb should perform better since it's local to the Server machine, and since it's a file gdb, it doesn't have to authenticate a user, read any versions, and connect to a different server. I'm not sure if it would be leaps and bounds better in performance, and maybe it wouldn't provide any noticeable performance gains at all...I'm just curious on if others have tried detecting performance differences, and if so, what methods, tools, etc... did you use and which were helpful. ... View more

I think it would be incredibly useful to provide your machine's installed font list as an option when trying to create a point symbol callout for labels in Pro. Currently, when I create a point symbol callout label in Pro (2.3.3) and select "More Point Symbols", I'm provided a gallery of point symbols for the project.  I think it would be beneficial to have the option to browse your installed fonts in order to have the ability to select a specific character from an installed font. I don't really want to have to create a point symbol just to use it as a callout in a label. Similarly, what if I want multiple characters in my callout, I'd like to be able to add characters to the callout as needed. ... View more