Latest Contributions by Bud

Summary: What are the options for building a Municipal Legal Agreement Registry using the ArcGIS platform? (Enterprise/Portal or AGOL) The system is meant to manage legal agreement data and documents/files. It would primarily be a non-spatial system with forms, lists, & hyperlinks, and it would have a secondary map component for spatial visualization. Details: A list of legal agreements that the City, businesses, or residents have signed. New list entries are to be submitted using a form. The records would have hyperlinks to legal documents on a local network drive. Agreement types: Civil Development (subdivision, site plan, condo) Business Development (sponsorship, grant, advertising, loan) Land Information (easement, parcel, land transfer, encroachment, rental, licensing, shared road) Facilities and Maintenance (access, construction) Legal (contract, financial, purchase/sale, funding, data sharing, non-disclosure, union) A list of 10,000 existing agreements to be loaded, growing to a maximum of 15,000 records. And there are additional related tables that have a one-to-many relationship, with less than 10,000 records each. A web map to visualize where the agreements are located, and symbolize the agreements by type. Unfortunately, not all records will have a spatial component. Best guess is we will do some combination of the following to map the records that do have spatial information: Geocode tabular addresses Join a City_Property_ID field to a City_Property polygon layer Join a Subdivision_Number to a Subdivision polygon layer Looking to build a no-code or low-code solution that has strong form and list functionality. We've ruled out Microsoft Power Apps and SharePoint Lists because they don't support this many records, and they don't handle related 1:M tables well. What ArcGIS web product do you recommend for a primarily non-spatial system like this? For example, Experience Builder, Dashboards, or something else. ... View more

As @MobiusSnake pointed out in https://community.esri.com/t5/arcgis-online-questions/add-guid-field-to-existing-agol-survey123-feature/m-p/1698411/highlight/true#M68519: Using a custom GUID field, it’s possible to automatically populate the field with GUIDs (at the hosted feature layer level) using the NEWID() function/default value via the Admin REST API. { "fields": [ { "name" : "MyID", "type" : "esriFieldTypeGUID", "alias" : "My ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ] } @Katie_Clark mentioned: After creating the feature layer, I opened it in a web map and created a feature. At first I was worried because the interface looked like this: But after submitting the form and checking the attribute table, the value was populated! I was also confused when the new feature Edit window showed NEWID() as the field value, prior to saving the feature. I thought it was going to insert the literal text “NEWID()” instead of a GUID value, which isn't what I want. This idea is to display something more intuitive in the Edit tool’s field value text box, such as the GUID value, instead of “NEWID()”.   ... View more

I have a hosted feature layer in AGOL: I can open the layer in the Visualizations tab, change something like the symbology, the pop-up field order, or the form configuration field order. Then Save As. The new layer is shown in the Contents tab as a feature layer, not as a hosted feature layer. Questions: What's the difference between a hosted feature layer and a feature layer? Does the feature layer point to the hosted feature layer? Does a feature layer not allow me to set privileges for it? Why would I use a feature layer instead of a view?     ... View more

Can Power Automate and webhooks be used for the following in AGOL? When a feature with multiple attachments is created in a Survey123 feature layer, copy the feature to a different feature layer, including copying the multiple attachments. (Event-driven webhook, not on a schedule.) ... View more