Latest Contributions by Bud

ArcGIS Pro 2.9.5; ArcGIS Online data: As a new ArcGIS Online user, it seems like the Catalog Pane > Portal tab contains more an just Portal data. It contains ArcGIS Online data too. Is there a reason why that tab is named "Portal" and not something more accurate/intuitive like "Portal & ArcGIS Online"? Feel free to let me know if I've misunderstood something. ... View more

ArcGIS Pro 2.9.5 As discussed with @JonathanNeal in a separate message, I'm wondering if it would help to add a selection icon in GP tool descriptions in the Catalog Pane to indicate if the tool honors selections. For example, with the Join Field tool, if rows are selected in the join table via Select By Attributes, only those selected rows will be populated in the new fields in the Input table. Related use case:  https://community.esri.com/t5/data-management-questions/1-m-join-to-pull-feature-with-specific-attribute/m-p/1533464/highlight/true#M45367  However, the Add Join tool does not work that way; selection are not honored. I'm aware that it's generally known that most geoprocessing tools honor selections unless otherwise specified. But there are exceptions, so I think it would be helpful to clarify this important difference between similar tools.  ... View more

It looks like mobile geodatabases aren't supported in ArcGIS Online. What can you add to ArcGIS Online? As far as I can tell, I would need to copy the mobile geodatabase data to a different filetype like a file geodatabase, and then zip the file geodatabase and upload it that way, which seems backwards. This is where GIS people get into trouble: too many copies of data. It would be great if ArcGIS Online could be enhanced so that we could upload data directly from a mobile geodatabase.     ... View more

https://ws.geoservices.lrc.gov.on.ca/arcgis5/rest/services/Elevation/Ontario_DTM_LidarDerived/ImageServer ArcGIS Online > ArcGIS REST Services Directory > ImageServer > View In:  There are several hyperlinks on that page—various methods to access the data. One of the links is an ArcMap link. As a novice who knows nothing about AGOL (or Portal?), why is there an ArcMap link, but not an ArcGIS Pro link? Should that page be enhanced so that there is a ArcGIS Pro option?   ... View more

Can anyone recommend a specific SQLite ODBC driver? For the purpose of connecting to a mobile geodatabase using non-ArcGIS programs like Excel. Use case: Store geoprocessing outputs in a format accessible to ArcGIS Pro and Excel ... View more

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB; ST_GEOMETRY Our master GIS data is stored in our enterprise geodatabase. The data can be easily accessed in Excel via ODBC for the purpose of tabular analysis and visualization by non-GIS people. That works well. However, when it comes to one-off geoprocessing outputs, I haven’t found a good place to store the resulting data. For example, I used the Spatial Join GP tool on EGDB data to bring the attributes of a polygon FC into a point FC (intersect). The question is: Where to store the output? The data needs to remain accessible in ArcGIS Pro. And it should also be accessible in Excel for the purpose of tabular analysis and visualization by non-GIS people. I don’t want to clutter the EGDB with a FC like PERMITS_spatial_join_SUBDIVISION_20240829. The data won’t be used regularly, but we do need to keep it for approximately one year. I could ask I.T. to create a data owner in the EGDB called GP_OUTPUTS and store this kind of data there. But it seems backwards to store ad hoc data in a production enterprise database. The source FCs have tens of thousands of features, so a ST_GEOMETRY spatial SQL query would be far too slow. Additionally, the query would be dynamic. In this case, a static, unchanging snapshot is preferred. A file geodatabase won’t work because it wouldn’t be accessible from Excel. Storing the data within an .XLSX file would strip out the spatial component. I’d prefer not to do that; I still want to access the data spatially in ArcGIS Pro. Although, in some cases, storing point coordinates in X & Y columns in the Excel data might be an acceptable workaround. Concurrent users aren’t a concern. And read-only access is fine. A file type that supports full-blown SQL queries would be preferred. Such as running a SQL GROUP BY query using Excel’s “Microsoft Query” window and ODBC. Excel Power Query would be an alternative option, but it is pretty clunky compared to SQL. Any ideas? ... View more