Latest Contributions by DavidSolari

My data is RGB satellite imagery which is why our histograms have such different distributions. In either case you can change the stretch type, edit the min & max values to present, and you can drag the little arrows at the bottom of each color band graph left & right: this is what shifts and compresses your colors. This is all real-time so try to manipulate all the different controls and options on that pane and see how that affects your map. ... View more

If you just want to change how it's displayed in Pro, there's a little chart button next to the "Stretch type" drop-down in the symbology pane. This gets you rudimentary levels adjustment, like this example where I turn the world into a cool nightmare zone:   I think you can use "Export as raster function template" from the symbology hamburger menu to get something you can use in further processing, but this is where I hit my limit on raster processing so I'll let someone else answer the tough stuff. ... View more

Welcome to the exciting world of the Travelling Salesman Problem! Trying to solve this the "exact" way has what's called factorial scaling, that means if it takes 1ms to solve for 2 locations, it takes a full hour to solve for 10, and you have over 200 so that won't work if you want this done before the universe burns out. Fortunately there's many heuristic algorithms that run a bit faster at the expense of 100% accuracy, which is better than nothing. Looking around I found the python_tsp package, which claims to not only have a bunch of TSP solvers but can also build an input matrix for you given some lat/longs. You can use the ArcGIS for Python API to extract the features you need, then build a 2D numpy array with the coordinates, then solve with the tsp package. You'll have to do a bit more work to correlate that output with the ID of your features and then write the info back in, but this too can be done with the ArcGIS API to create a one-click solution. ... View more

The usual suggestion for Arcade based fields in Pro is an Attribute Rule to calculate into a premade field. Is this excessive to add a simple calculation to a table in a limited context? Absolutely! I can't find an obvious Ideas post that suggests this type of "Arcade Field" so it's worth making one. Not sure if this'll work, but because you're in a layout you can try working with the Report tools to built your table, there may be ways to calculate your field in there. ... View more

Shocked this hasn't been at least considered, from what I know of how Arcade is implemented this is trivial due to language-level support in JavaScript. If ESRI is concerned with sloppy expressions causing load issues in ArcGIS Online (very difficult as regex is supposed to evaluate client-side, but I'm sure there's a way to cause mayhem somehow) then limiting their Profile set as a trial would be a good start. ... View more

Found a similar issue from a while back, does disabling the "Optimize performance for feature services" option improve consistency? Also to be clear, are these appends against the feature service layer or DB direct connection layer? Append is one of the few tools greenlit to work with direct connections but it can be flaky. ... View more

Shot in the dark: Does changing arcpy.conversion.TableToExcel to arcpy.TableToExcel_conversion fix the issue? As a hacksaw fix you can try checking the Python version and if it's 3 then pop any ArcMap paths in sys.path to unlink the old environment. ... View more

Ah sorry, I forgot to sub out my playground test variable, replace f with $feature in your case. ... View more

If you're doing editing workflows on this data you can look into the ETL tools for your database to mirror a query as a standalone table, and then push changes back to the databases as needed. That way you can edit data while also keeping it appropriately warehoused. Not the best situation but it can work. ... View more

That's the max field length in most databases (largest singed 32-bit integer) it usually means your field was designed to hold big blocks of text. In your case it looks like the data design process went sideways but if you can read the field as-is in the rest of ArcGIS then the length probably isn't the issue. ... View more

Your expression runs fine in the Arcade Playground so I doubt it's the issue. Maybe some parts of ArcGIS handle nonstandard formatting weird, you can sub in this 1-line version to test that: Iif(f.stop_id == "00627", "pile to the East", "") Does the pop-up work in the regular map viewer or is it broken everywhere? Some pictures of how you've configured the pop-up will help here. ... View more

Branch Versioned data stores all edits to DEFAULT in a single table. Updates appear as a new record with a creation timestamp and deletions appear as a copy of the record with a flag set and the name of which user deleted it. There's pros and cons to branch versioning beyond the archive table but if it meets your needs then go for it. My org uses branch versioning all over the place and the tables have been an invaluable audit source when someone fat-fingers the delete button. If DEFAULT-only is unacceptable and you need an audit trail of all activity then what @CodyPatterson suggested is required. Just keep in mind that A) the username logged will always be the Enterprise username for service edits, but it'll be the name of the DB user for direct connection edits so you'll have to proactively configure editing rights; and B) any triggers you add to a feature class/table have to be maintained outside of ArcGIS and you may have to rewrite them if fundamental changes are made through ArcGIS. ... View more

If I'm reading your question right, you want to capture the data from an HTML form and feed that into Survey123, correct? To get the form data and prevent the usual submit action, you'll need some JavaScript, this StackOverflow question is a great jumping off point. Once you have the data, you can turn that into a URL which opens the web app with values filled by default. The user can then finish any remaining questions and submit the final form. If you want to skip the Survey123 interface altogether you can look into the JavaScript SDK to connect to the hosted feature service that stores the Survey data and insert a new record. Or use the REST API without the SDK if you need to minimize dependencies. ... View more

If the Map Service has dynamic map layers turned on (it usually is as that's been the default for ages) you can try something like this sample code to query out certain data from that sublayer and/or substitute a renderer that hides the undesirable pixels. ... View more