Latest Contributions by AZendel

‎06-06-2022

I agree. ESRI, please improve/fix this!

‎05-11-2022

We often have databases with 200K, sometimes 1M+ records. Geoprocessing is way too slow when doing joins --> select by attribute --> calculate field, even with proper indexes. SQL can do it in a couple of seconds (literally) with UPDATE ... INNER JOIN....WHERE. There are many other areas where SQL is much more efficient than geoprocessing (and sometimes the opposite is true). Beyond the need for Desktop Geodatabases, is ESRI going to continue to offer the Workgroup database? It seems like those can't be administered from Pro either.

‎05-11-2022

@George_Thompson , are there any updates to this? We rely on the 'Desktop Geodatabase' (formerly 'Personal ArcSDE' database) quite heavily. We are trying to ween our staff off of ArcMap since it won't be supported much longer.

‎05-10-2022

Yes, please! GPX files are likely to be a part of the industry for many years to come. I don't necessarily need 'drag and drop' functionality, but I'd like to add a GPX file to a map/scene in Pro via the 'add data' button or via the catalog pane without having to convert it to FGDB or shapefile first.

‎03-23-2022

Thanks for your responses. I wonder if we are talking about 2 different issues. The 10 second wait that I'm talking about happens when you list the database contents by double clicking the database connection below ArcMap/ArcCatalog ArcGIS Pro: Our Oracle SDE database is otherwise very performant, even with large datasets that are versioned and/or have archiving enabled. The county's DBA regularly compresses the database to flush out the add and deletes tables when necessary. I imagine that he conducts other tuning and maintenance tasks to keep database operations in a healthy state. I only notice significant latency while waiting for Arc* desktop products to list the contents of the database. That's what makes me suspect that ESRI developers may want to investigate if they can improve the queries that this action kicks off. Is anybody else experiencing this?

‎03-22-2022

Our county has been on an Oracle Enterprise Geodatabase (ArcSDE) for over 15 years. When I add a large feature class (100K+ parcels, 200K+ address point locations) to both ArcMap and ArcGIS Pro, it's capable of filling the map with 10s of thousands of features every second. This demonstrates that the database and our network are plenty fast! But if it's that fast, why does it take nearly 10 seconds to list the contents of the database in ArcCatalog and the Catalog pane of ArcGIS Pro? I realize that this might sound impatient and trivial, but those ten seconds add up. If I work 48 weeks out of the year and list the contents of the database 5 times per day, that's 3.3 hours per year -- almost half a day of work waiting for the contents to populate. I realize that contents of the geodatabase are stored in the "GDB" tables of the database. Then it must do joins to group feature classes inside of feature datasets. Then it must also filter out objects that the current user doesn't have access to. And so on. So it's not simple, but 10 seconds seems excessive. It would be nice to see some effort put into this (or an explanation of why previous efforts have run into walls).

‎01-28-2022

@ShanaBritt, thanks for clarifying! Our central GIS office manages our ArcGIS Server environment. A good number of people are on older versions of ArcMap, so I'm not sure if they can upgrade the locator yet. When that option is available, can you include the 'new' geocoding output fields (score, standardized address, etc.) and not have USER_ appended to the input fields? That would be the sweet spot for my needs.

‎01-28-2022

When using one of our inhouse locators (served via ArcGIS Server), I don't get the option mentioned in step 6D mentioned above. And I often want the geocoding result fields, such as match type, score, standardized address, etc. They help me hunt down poor matches. But what I do NOT want is the USER_ prefix on all of the input fields. ArcMap didn't do this. ESRI, please provide an option to exclude the USER_ prefix regardless of what geocoding service/locator that you're using! I think this idea should be reopened.

‎01-28-2022

ESRI, please provide an option to exclude the very annoying USER_ prefix to all of the input fields!

‎01-28-2022

@KoryKramer , I don't see that optional parameters input when geocoding against our in-house/custom locator. But it does show up when I chose the ESRI World Geocoding service. If I was using the ESRI service, do any of those options remove the annoying "USER_" prefix? I personally don't mind all of the new field that geocoding adds (e.g., match type, match score, standardize addresses). When I append the geocoding output to an existing feature class that doesn't have those fields, they are automatically excluded. But having to rename all of the fields that start with USER_ ain't fun!

‎01-24-2022

I'd like to know the same information for the same reason: how many AGO credits could this feature class eat up? Below is a screenshot of a FGDB feature class from ArcCatalog. Is this available in Pro? If not, I'll add it to the ArcGIS Ideas. I'm not an expert on databases, but I understand that many RDBMS's will pre-allocate space for database contents, as Vince mentioned above. Then as features/rows are updated or deleted, the size of the data doesn't really shrink until something like 'vacuum' in Postgres is run to clean out 'dead' rows. So I can appreciate why that would be a difficult question to answer for enterprise (SDE) geodatabases. But it would be nice to have this functionality for FGDB's.

‎01-14-2022

It would be great if we could add any web-accessible font to our web maps, both in the new (former 'beta') map viewer and when styling vector tile maps. The current font selection is somewhat extensive in the number of choices, but many are too 'artsy' and not very practical (Atomic Age, Audiowide, Cabin Sketch, etc). I'd love to be able to use Open Sans (with all of its weights - and the condensed version), Lato, Source Sans (multiple weights), PT Sans, Mukta, etc. It would be nice if there was an input box that we could paste links to the fonts, such as https://fonts.googleapis.com/css2?family=Work+Sans:wght@100&display=swap

‎01-06-2022

The add query layer work-around worked for me as well, but we use Oracle, not SQL Server as listed in the bug report. And I agree, it's a bit annoying. We have been dragging these same 'spatial views' from ArcCatalog into ArcMap for the last 12+ years with no problems. If it works in ArcMap, why can't it work in Pro? ESRI, please look into making this easier for us.

‎12-21-2021

YES, PLEASE!

‎11-08-2021

Please implement this, ESRI! Case in point, I did a spatial join between two feature classes with some fields that have the same name. So the output table has NumSFR and NumSFR_1. The '_1' tips me off as two which feature class the field came from. These setting should be applied to: The 'attribute table' view The 'attributes' view "Identify tool" (clicking a feature with the navigate tool) Geoprocessing tools (Calcuate field, Merge, Append, etc) It'd be ideal for people to specify this setting for each project, not all projects. But if it can only be one, I want the latter.

Online Status	Online
Date Last Visited	an hour ago

My Ideas

Latest Contributions by AZendel

Re: Editing Geodatabase Annotation in layout mode? Or efficient alternative?

Re: ArcGIS Pro and local SQL Express DB

Re: ArcGIS Pro and local SQL Express DB

Re: GPX Drag&Drop Support in ArcGIS Pro

Re: Improve the speed of listing contents in an Enterprise Geodatabase (ArcSDE)

Improve the speed of listing contents in an Enterprise Geodatabase (ArcSDE)

Re: GeoCoding Table | Esri Renames my fields | Would you change this so mine stay the same

Re: GeoCoding Table | Esri Renames my fields | Would you change this so mine stay the same

Re: Geo coding | DO NOT change the Field Names in conversion

Re: Add possibility to remove all "Match" columns when geocoding from ArcGIS Pro and ArcMap

Re: Size of a feature class

Allow any web-based font for labels in maps and vector tile styling

Re: Failed to add data - spatial view ArcGIS Pro

Re: Spatial join without creating a new feature class

Re: Setting to disable field aliases

Re: Editing Geodatabase Annotation in layout mode?...

Re: I cant create features due to :Value doesn't ...

Re: Size of a feature class

Allow users to continue sketch when reshape fails ...

Re: ArcPro not honoring selection for attribute st...