Latest Contributions by BrianLeroux

I would like to see additional premium attributes added to the AGOL World Geocoder output. My particular use case is based on adding attributes to correctly match addresses across different lines of business and data vendors. Many companies are utilizing Melissa MAKs and/or Precisely Ids. If you make these additional optional outputs of the world geocoder it would promote more companies to use this type of data and simplifying data merging. Adding optional outputs could increase the per geocode credit consumption. Example: Vendor uses satellite data to assess building damage and notes damage to buildings and supplies MAK for each address. Insurer queries vendor for all damage from that specific storm and filter results to only MAKs that insures covers. insurer is quickly able to assess overall impact. The old method entails trying to join geocoded policies to damage building footprints. Since geocoding is not always rooftop, you need to add buffer to try to match which leads to some still not having a match and other matched to incorrect property. These errors result in miscalculations in overall damage assessment.

Vince - Thank you for this info. I will pass it along to our DBAs to see if we can build a better process. We had registered the tables as we thought the performance would be better for our web services.

My DB Admins are not familiar with ArcSDE so I am trying to find guidance on proper ways to load data into SQL server tables that are registered with SDE. The data are geocoded points from another non SDE database and have a geometry filed for location data. After I register the table it is adding a new column called [GDB_GEOMATTR_DATA]. So the admins have a nightly process to truncate ,insert all the rows, and finally update to fill geometry column. This is done purely in SQL and is not using ArcGIS to load any data. That will leave the [GDB_GEOMATTR_DATA] column empty. So my question is what is the proper ETL strategy with a registered table and can we perform the ETL without needing ArcGIS or ArcPy?

‎05-06-2026

This seems like such an obvious idea. Now sure how this has not been implemented in 4 years. Drive times are such a big part of GIS site selection and analysis. Let's go ESRI.

‎04-15-2026

I have not been able to find much documentation regarding binning and loading of new features to a feature class. There does not seem to be any tooling available that would allow someone to trigger a method to rebuild the binning fields.

‎04-14-2026

I have enabled binning on a SQL server database table that I have and am using database compute to handle the binning without using cache bins. When enabling binning a couple fields are added to the table. The geo_fhexstr_4326 filed is the only one with data and the bins render great. My challenge is we have a process to truncate and reload the table everyday. This is not something we can easily change. When the data is truncated the geo_fhexstr field gets nullified and i was hoping the GDB functionality would rebuild this field as a request to that table is made. unfortunately that is not the case so i am looking to see if there is a way without disabling and re-enabling binning on this table every day. Any ideas?

‎01-20-2026

@Ayyaz Is it possible to have this tool work with Windows Auth SSO? I did go through the runPortalCalls script and updated target = GIS(target_portal, username, pwd, verify_cert = validate_cert) to target = GIS(target_portal) so that it would successfully log in. Then I removed the token parameters from all calls in that same script. It now is able to complete running the entire script but still running into issues with getting all the info. Here are the errors I am still battling. Error In accessing Portal for ArcGIS License Information Error In accessing Portal for ArcGIS OIDC Configuration Error Obtaining in Portal Certificates Error Grabbing ArcGIS Server Certificate Lists for Site I also wanted to point out a bug. On line 182 of updateReportPortalLiceneceDetails.py you use next_row when it should be initial_row. Current: next_row = UpdateConfigurationSheetCell(portdal_license_sheet, next_row, initial_column, "Unable to access License Information for Portal for ArcGIS ", '', '','') Should be: next_row = UpdateConfigurationSheetCell(portdal_license_sheet, initial_row, initial_column, "Unable to access License Information for Portal for ArcGIS ", '', '','')

‎11-10-2025

Just upgraded ArcGIS Enterprise so wanted to test out feature binning on a service I have. In Pro i turned on feature binning. Compute settings set to database and summary statistics have a few configured fields. I also configured the pop ups for both features and bins which all work great in Pro. Bins showing summary statistics. Shared as a web layer to my enterprise and opened in a web map in portal. When viewing bins and clicking to get a pop up, I do not get summary statistics but rather a pop up from an underlying feature. So my question is, do feature bin summary pop ups for in web maps on Enterprise 11.5?

‎05-09-2025

Good news is i found VS code kept a history and I was able to recover code. Now the problem is experience builder seems to have a cached version of the widget even though it is not in the custom widgets folder. When I put updated code in that folder and restart webpack it states it is a duplicate name and doesn't load the new one. I can't figure out how to remove the old code. Assuming it is buried in some config somewhere.

‎05-09-2025

Sadly I somehow had a tsx file deleted from a custom widget and I am not able to recover it. i have an older version but if I use that I lose 2 days of work from changes I made. I have a compiled copy of a widget from a distribution. When I import the map back into eXb Dev from the deployment zip the widget shows back up but it is not decompiled back into my custom widgets folder. Does anyone know a way to decompile a widget using webpack if even possible?

‎04-25-2025

Here is an example of it working how I would want using a rotation renderer with RotationType set to geographic vs arithmetic. https://developers.arcgis.com/javascript/latest/sample-code/visualization-vv-rotation/

‎04-25-2025

@JeffreyThompson2 Looks nice but does not fix my rotation issue. After you draw a shape and set rotation, that rotation angle seems to be tied to the underlying "canvas" and not the map. For instance, after you draw a shape like an arrow, right click and rotate the map. If the arrow was pointed up (map North) and you rotate the map 180 degrees, the arrow still point up (now map south). In arcgis pro there is an option on symbology to align angle with the display or the map. Not sure if there is anything similar in eXb.

‎03-12-2025

Not sure you want to work on the draw widget but there is a flaw that is killing me. The is no way to rotate point symbols and when you place them on the map the hold original display orientation even after you rotate the map. For example if you put an arrow, which they all point upward, if you rotate the map after you place one it still points up even though North has changed. I was going to use this to draw vehicle accident diagrams but I can't orient vehicles to align with a roadway.

‎03-12-2025

The draw widget really needs a way to rotate symbols for points. All the arrows point up/North with no way to rotate which makes them useless for the most part. Even when you rotate the map they stay pointed Upward. I would think we want all symbols (lines, points etc.) to lock orientation when the map rotates with the ability to manually rotate any features. If I place an arrow and rotate it south I want it to stay south even when I rotate the map.

‎02-04-2025

Hi @GeeteshSingh07 - Thanks for the update. A couple of questions on this before I try this method. Do you have 2 instances if eXb dev running for different environments? I typically just use one and log in and out of different environments and only the apps for the current environment show after logging in. After you ran this process, how much in the new experience was broken? I have to imagine anything related to data sources from the previous environment would be broken and need to all be links to new data sources.

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by BrianLeroux

Additional Geocoding Attributes

Re: ETL Process for SQL Tables

ETL Process for SQL Tables

Re: Use Driving Distance/Time in Near Me Widget

Re: Database Driven Feature Binning

Database Driven Feature Binning

Re: Configuration Reporter

Feature Binning Popups

Re: Experience Builder Dev Edition Lost Widget Help!!!

Experience Builder Dev Edition Lost Widget Help!!!

Re: Widget Wishlist

Re: Widget Wishlist

Re: Widget Wishlist

Re: ArcGIS Experience Builder 2025 Roadmap

Re: Migrating Experience Builder gives Error: This is an experience. Please switch to experiences tab and try again

Additional Geocoding Attributes

Re: ArcGIS Experience Builder 2025 Roadmap

Re: Replicate Experiences between portals

Replicate Experiences between portals

Re: ExB Dev Edition - Enterprise Login

Web AppBuilder Custom Widgets