Latest Contributions by DavidSolari

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

Like Dan said, Dissolve with the "sector" field should be enough. If you need a more specific workflow, here's an arcpy function that'll condense a bunch of geometries into one multipart: import ujson def reduce_geoms(geoms: list[arcpy.Geometry]) -> arcpy.Geometry: iter_geom = iter(geoms) first = next(iter_geom) assert first.type != "point" retval = ujson.loads(first.JSON) has_curves = "curvePaths" in retval path_key = "curvePaths" if has_curves else "paths" for g in iter_geom: gson = ujson.loads(g.JSON) paths = None if "curvePaths" in gson: paths = gson["curvePaths"] if not has_curves: retval["curvePaths"] = retval["paths"] del retval["paths"] path_key = "curvePaths" else: paths = retval["paths"] retval[path_key].extend(paths) return arcpy.AsShape(retval, True) ... View more

Unless it's hidden somewhere sneaky Arcade doesn't have any regex related functions, and that's all you have access to with the new Form specification. You'll either have to swap to Survey123 which does have more complex expression parsing or you can use Arcade functions like Find to see if a certain character appears in an answer or compare its location to another one. ... View more