Summary:
What are the options for building a Municipal Agreement Registry using the ArcGIS platform? (Enterprise/Portal or AGOL)
The system is meant to track and manage legal agreements. 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. And the table 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: one-to-many relationship.
- 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 product do you recommend for a primarily non-spatial system like this?
