Latest Contributions by AndrewRudin1

ArcGIS Pro provides a nice GUI for updating python libraries used by the software.  For folks like me this makes it so much easier to get started with the python features, since I don't have to worry about learning Conda. However, when I hear about a new version of the arcgis python library being available, when I go to the Python Package Manager, it is not shown as an option to update.  I am curious why this flagship library from Esri is not available for update through this window when so many smaller ancillary libraries are available.   I do know that the Python API help has a page explaining how to do the update via the conda terminal:  Install and set up | ArcGIS for Developers .  However, the instructions don't look like they've been updated since 2.2.  Also, it is a little clunky to go through these steps when Pro has a feature to make updates easier.  ... View more

Currently ArcGIS Online allows layers to be non-editable for the public, but if the item is in a "group with update capabilities", the members of that group can add the layer to an AGOL map with full editing control and make edits. However, if these users add these layers to ArcGIS Pro, they cannot edit.  I would like for the group editing ability on the layer be honored in Pro.   I guess the current workaround is to make the hosted layer editable and share that with the group, then make a hosted view that is non-editable, and share that with the public.  It's just extra items for us to maintain. ... View more

I'm joining two tables in ArcGIS Insights (ArcGIS Online) and I know both tables will have orphans after the join.  For my analysis, these orphans need to have the column I'm measuring on converted from Null to zero.  Once I create the joined table, I'm viewing the table and clicking +Field button, with the intent to create a new field that follows this logic: IF [measure_field] is null, THEN Value=0, ELSE Value=[measure_field] In the Insights calculate field window, I couldn't find a way to check if a field's value is null.  Is this possible?  Or is there a better way to cleanup nulls during the join? ... View more

I have some AVL data hosted in a 10.6.1 spatiotemporal big data store.  I'm trying to apply some filters in Pro based on the GPS timestamp but it's not working.  The Pro documentation covers supported functions for the traditional RDMS, shapefile, and file database formats, but doesn't discuss compatibility for the newer ArcGIS Online, Relational Data Store, and Spatiotemporal Data Store options. Specifically I'm trying to do two queries on a single spatiotemporal hosted feature layer and contains historical vehicle location data.  The point layer has a VEHICLE_ID column to store the unique ID for each vehicle, and a GPSTIME field for the time the location was caption. Query #1:  Filter the dataset to only records with a timestamp in the last 24 hours.  I tried a def. query GPSTIME > (CURRENT_TIMESTAMP() - 1), but that returned an expression error. Query #2: Filter the dataset to only the record with the latest timestamp for each vehicle_id.  I believe with a traditional RDMS, this type of query can be handled with a whereclause along the lines of the following:   gpstime = (SELECT max(gpstime) from MYGPSTABLE WHERE vehicle_id = MYGPSTABLE.vehicle_id) ... View more