Latest Contributions by DavidSolari

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

An untested concept: generate the random points (probably at a higher density than you normally would), run Extract Multi Values to Points to get the population values in there, normalize those values to (0 .. 1), then field calculate a yes/no field using your preferred Python RNG function, flagging every point whose normalized pop value is higher than the normalized RNG value. Delete whatever failed and you should have some weighted results. ... View more

Alfred's suggestion is the intended way to get a Double parameter so I can't say why it's failing for you. As a workaround, try getting all your parameters using arcpy.GetParameterInfo() and then use the value or valueAsText parameters as needed. For example, a drop-in replacement for the first line of your sample is: proximity_threshold = arcpy.GetParameterInfo()[1].value   ... View more