Latest Contributions by Matt-Goodman

Hi, I'm using ArcGIS Pro 3.3.5 and trying to query a feature class in an Enterprise SQL db to select records with duplicate ID's.  The query below used to work for me, regularly. I used to run it at the end of each day without an issue, but it recently stopped working:  [ADD_ID] IN (SELECT [ADD_ID] FROM [sde].[stlouis].[ADDRPLCS_MARADDRESS] GROUP BY [ADD_ID] HAVING COUNT(*) > 1)     I suspect it was never supported or supposed to work and probably a recent SQL server upgrade ended it. My sense is that this is a known limitation, an unsupported operation, based on the Esri documentation prescribing methods to find duplicates (https://support.esri.com/en-us/knowledge-base/how-to-identify-duplicate-or-unique-values-in-arcgis-pr-000023355). The problem is that all of the supported methods seem to require population of a new attribute field, or outputting a new feature class. Isn't there a way to just select them? This seems like such a foundational SQL function, it's surprising that it isn't supported through the Pro interface.  Does anyone know more precisely why my SQL query above would have stopped working, or any other work-around methods for making this selection work? A SQL select via the python window, perhaps?  Thanks,  -Matt ... View more

I use ArcGIS Pro for my daily work, but we're currently stuck with one legacy system on a runtime that requires an ArcMap 10.x .mxd, and I'm having trouble with a specific layer that's drawing really slowly.  I've used the PerfQA Analyzer tool and it's singling-out my 'Lakes' layer...showing that it's taking roughly 1 to 2 full seconds to draw.  What I don't understand is: what is the "Selection" portion of the rendering? The "Geography" and "Annotation" portions are fast, but it's the "Selection" that takes so long. Why? There is no definition query on the layer, the labeling doesn't use any SQL expression, and the layer isn't even 'selectable' in the table of contents.  I have tried re-creating spatial index and other attribute indexes. I am trying to determine what I might be able to change in order to speed-up this portion of the rendering. ... View more

I am interested in using a entirely fake GIS dataset in ArcGIS desktop for educational purposes - is anyone aware of such a data set?  The SQL 'database' world has the infamous "Northwind.db" database with which to work, a fake business relational database. Does the GIS world has something similar? Perhaps somewhere in the 'gaming engine' world (in which if have almost no knowledge). Could someone point me in the right direction?  Requirements: must be able to download and work with locally (.gdb, .shp) must include address points, road centerlines, and community boundaries Preferences: includes fake (or at least altered/re-oriented) aerial imagery that aligns with the vector data exists in a WGS84 geographic coordinate system (perhaps in the real-world's ocean, or an uninhabited part of the real-world); or, a factitious coordinate system that uses units resembling latitude/longitude.     ... View more

Hello,  Our 911 dispatch center needs a simple local map viewer that I can package with a local copy of our GIS data and a local address locator. This seems like it should be one of the easiest, most foundational software solutions provided by Esri, but with ArcGIS Explorer 'expiring' in less than a year, there is no viable alternate solution? Requirements are not too difficult: Has to operate on Windows desktop (Field Maps is Android / iOS only) Must work 100% offline (no sign-in required). If it is going to serve as a fail-safe, in case of a total network failure, it has to be available even when the computer is offline.  Has to be able to display a map and allow address searches using our in-house address locator files.  Is there anything out there, or in development, that would fill this business need? ... View more