Latest Contributions by AndrewRudin1

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

I am a GIS professional within my organization. I'm trying to write a python script that can access our ArcGIS Online organization to help me automate management the layers and other items I'm responsible for.  Some of these layers are not shared publicly and are restricted by groups within the org.  I login into our organization with an account federated with our Active Directory.  I want the script I'm writing to run at night and obtain info from all my items, so it can't prompt me for a password at runtime. I'm following the instructions in the API help (link here) for how to connect, but I'm running into issues.  Specifically I'm using the sample code from the section after the paragraph: "If the configured identity provider is compatible, you may also be able to provide your username and password, along with the client_id for a non interactive login experience using OAuth 2.0, as shown below:" I have Pro 2.4 installed, and I'm using a python environment that has the ArcGIS API for python upgraded to 1.6.2. Here is my code: import arcgis gis = arcgis.GIS("https://myagolorg.maps.arcgis.com", username="MyActiveDirectoryUsername", password="MyActiveDirectoryPassword", client_id='MyAGOLAppClientID') print("Successfully logged in as: " + gis.properties.user.username) When I run this in a Jupyter Notebook, I get a 'module not found error'.   ModuleNotFoundError: No module named 'bs4' I googled bs4 and figured out it's a module named BeautifulSoup4.  I went back into Pro and added that package to my environment  After this install is done I rerun by script, but now I get a variable reference error:  UnboundLocalError: local variable 'oauth_info' referenced before assignment Has anyone been able to successfully login to their AGOL org from python API using a federated account and no credentials prompt?  If there is another method let me know.  I know that a built-in account would be easier but that's not my preference.  I know that an app login my work for connecting, but it won't provide access to items that aren't shared publicly. Thank you,  ... View more