I created a simple database view to summarize our site address data in a MSAG-like format. Basically, it's a list of our road names with the high and low addresses for each, that's grouped by road. Here's the code:
SELECT fullname as "Full Road Name", count(fullname) as "# of Addresses", Min(Cast(addrnum as double precision)) as "Low Address", Max(Cast(addrnum as double precision)) as "High Address", Format(last_edited_date,'d', 'en-US') as "Date Edited"
FROM [GIS].[dbo].[SiteAddressPoint_evw]
Group By fullname, last_edited_date
Order By fullname;
I'd like to publish the table to our Open Data Hub so that people can query it or download it on their own.
Since the data is summarized, I don't have an Object ID field or another type of unique identifier, so I can't add it to a map or register it with our Enterprise Geodatabase.
Does anyone know if there's a workaround or a solution that would allow me to do this? I tried including the ObjectID in the query, but that creates rows for each address and undoes the grouping.
