Latest Contributions by JohnFix1

Last post for now.... The active query running that is taking FOREVER is: SELECT top 1 GEOM FROM MYDB.DBO.ADDRESS_GEOCODE_VW WHERE GEOM IS NOT NULL ... View more

Just adding some info to the above, in SSMS I was able to see the query that is running....ArcGIS Pro 2.6 is trying to determine the bounding box of the table. The query is: SELECT min(((GEOM.STEnvelope()).STPointN(1)).STX),min(((GEOM.STEnvelope()).STPointN(1)).STY),max(((GEOM.STEnvelope()).STPointN(3)).STX),max(((GEOM.STEnvelope()).STPointN(3)).STY) FROM MYDB.DBO.ADDRESS_GEOCODE_VW‍‍‍ "MYDB" is just a placeholder for my actual DB name. "ADDRESS_GEOCODE_VW" is a view. The table has 9.7 million rows and this query has been running for 4 hours at this point. When the base table is added to a map in Pro, it's very fast and renders as fast as I can drag the map. ... View more

Thanks Brad, This also sheds some light on why my developer keeps telling me that runtime needs a *.locb" file.  This file is only created in ArcMap when the "create runtime content" is enabled. We are using Xamarin so we can deploy to different platforms. This will force us to use the less desirable "address locator" in ArcMap. While making the vector tile caches and mobile map packages in ArcGIS Pro. What a convoluted process. And there is zero chance (ok, I should never say "zero") we'll make one package for 64-bit and another for all other platforms. Do you know if non-64-bit apps built with runtime will be able to use the "locator" format in the future? Thanks, John ... View more

We are having the same problem with an app we are working on. Only difference is we built a "locator" (not address locator) in ArcGIS Pro with both house address and street range styles.  This has become a show stopper in our development efforts. ... View more

Thanks Joe, we'll take a look. But this looks like exactly what we are dealing with and what we need. ... View more

We think the answer may be contained in this link: http://desktop.arcgis.com/en/arcobjects/latest/net/webframe.htm#b3d3f316-8436-463d-988e-11ba9ca03e78.htm ... View more

We too have almost the exact same need...to get at what used to be called the "section" table (in "coverages", yes I am showing my age). Basically the pieces that make up a route. We plan to enter a support ticket to get help with this issue. ... View more

This behavior reminds me of when ArcMap/ArcCatalog were first released. It spent so much time digging into subfolders so it could display an icon beside the folder so you knew if it had GIS data in it. It was unacceptable back then and modifications were made to the apps, I can't understand why Esri thinks it would be acceptable now.  It is a productivity killer, plain and simple. ... View more

Where do you work and what is your role?  Hello, I'm John Fix from Lancaster, Pennsylvania. I own my own company (IronCompass.com) that specializes in applications for emergency response. We have a product called OnScene Xplorer. I also work as a Geospatial Architect in state government. What GIS success have you had this year and what product did you use? (big or small - no win is out of bounds) This year I have been creating vector tile caches. It's unbelievable how fast they are generated and how small they are on disk. We're replacing a 70GB raster tile cache that took over 40 hours to render with a 250MB vector cache that takes about 15 minutes to render. Wow! What is your expertise (GIS related or not), and how can that help the community? I started GIS with PC Arc/Info 3.2 back in 1988. The PC didn't even have a mouse. I used a large Calcomp digitizer as the "mouse". For training I use VHS tapes and workbooks from, back then, E.S.R.I. Certainly times have changed! I've done a lot of cartographic projects over my career (National Geographic Atlas of the World) and understand a lot of tips to making a nice looking map. I've also built a lot of spatial databases and am always looking for short-cuts to improve efficiencies.   Favorite place on earth ( at this time): -76.290960, 41.329896 ... View more

Kory, I do submit my email with the error report. I'll have the patch installed and see if I notice a difference. ... View more

I too am experiencing a high frequency of crashes in ArcMap 10.6x. It happens 4-10 times per day and with all different kinds of simple tasks. Typically what happens is the graphics just fail. The entire app "white screens" and I have no recourse but to kill the process. When that happens, the "error report" dialog does not display. Other times it crashes with the error report dialog and I must apologize to Esri for how I voice my frustration in my comments.... I also use 10.5.1 without any crashes on another setup (I do contact work at different locations). One difference I notice with my work on 10.6x, I have an open connection to Oracle 11g to view spatial data along with my local data. My 10.5 setup, I often have a connection to SQL Server 2017 viewing native geometries. The crashes with 10.6 is killing productivity.... and ArcGIS Pro doesn't have all the features I need.... ... View more

Arcplot! Now that takes me back! "Display 1040" hahaha ... View more

As an old Arc/Info user I was wondering, where is the "section" table? lol. Thank you very much, this command is what I needed. ... View more