|
POST
|
I just heard back from Esri: To [re]create the [Cases Current] view add the Cases feature service to the map viewer. From Analysis open the Join Features tool. Configure your settings for the join and at the bottom check the option to save the output as a hosted view. To define the join you will do a 1:1 attribute join based on the name field, and sort on the Report Date field in descending order. You still have to manually recreate all the views, but I hope that helps. -Andrew
... View more
03-19-2020
08:57 AM
|
1
|
2
|
2639
|
|
POST
|
I'm dealing with this today as well. From what little I know about hosted layer views, you cannot alter the schema of the view to include new fields from the source layers, so you have to recreate them all. To make it more complex, the 'Cases Current' hosted view does some aggregation from the cases table to the related boundaries layer, so that you have one table with the most recent counts for each boundary. The view was created by Esri's solution so I don't know you can see the code for how the join is done, let alone recreate it. Hoping to get some answers this afternoon. I'll share here if I find out some tricks -Andrew
... View more
03-19-2020
08:49 AM
|
0
|
3
|
2639
|
|
POST
|
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
02-13-2020
08:56 AM
|
0
|
1
|
896
|
|
POST
|
I'm new to insights and am new to Insights and am trying to understand the process to join several tables together for analysis. Is there a way to modify a table join after I've created it? For example, below I created an inner join, but now after inspecting the resulting data more I realize it needs to be a left join. Is there a way to make that change in the model without redoing everything? In the model window I can click the join step, and then click the pencil icon. It gives me the properties of the join, but there's no way to modify it. I guess I'm just used to model builder where you can go back and change the properties of a tool in the middle of the workflow, then rerun only the tools after that point in the model. I should also mention I'm using the new desktop version of Insights
... View more
01-24-2020
07:07 AM
|
1
|
1
|
1010
|
|
IDEA
|
If it's not in there already, this is great time to add this ability into the new Map Viewer that's going into Beta. Map Viewer Beta: Coming Soon I have been able to label stream layers in Pro, but the moment you publish the Pro map as a service to Enterprise, the labels no longer appear for the end user. Last time I tried was Pro 2.3 and Enterprise/GeoEevent 10.6.1
... View more
10-16-2019
12:58 PM
|
0
|
0
|
2663
|
|
IDEA
|
If it's not in there already, this is great time to add this ability into the new Map Viewer that's going into Beta. Map Viewer Beta: Coming Soon I have been able to label stream layers in Pro, but the moment you publish the Pro map as a service to Enterprise, the labels no longer appear for the end user. Last time I tried was Pro 2.3 and Enterprise/GeoEevent 10.6.1
... View more
10-16-2019
12:58 PM
|
0
|
0
|
2593
|
|
POST
|
Update: For the basic dyamic date filter (Query #1), I did find some detail in the REST API help. Although I'm using Pro instead of the REST API, they do have some notes in the Feature Service/Layer Query method on the WHERE parameter: Query (Feature Service/Layer)—ArcGIS REST API: Services Directory | ArcGIS for Developers . However, It still didn't work. I entered the following query in Pro, and although the query validates, the layer still shows records older than 1 day. gpstime >= ( current_timestamp - interval '1' day)
... View more
10-14-2019
10:14 AM
|
0
|
1
|
1477
|
|
POST
|
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
10-14-2019
09:35 AM
|
0
|
3
|
1713
|
|
POST
|
Thank you Brian. I've heard from another source that the typical frequency can very, but 3-5 seconds up to minutes is possible.
... View more
10-01-2019
07:45 AM
|
1
|
0
|
2581
|
|
POST
|
I'm trying to do some capacity planning for our GeoEvent server to handle AVL data. For those of you that have integrated GeoEvent with your AVL systems, what is the average frequency of messages from each vehicle to the AVL hosting server? For example, does each vehicle send a message every 5 seconds? every 10 seconds? every 60 seconds Actually I guess there are 3 levels of detail on message frequency across the data pipeline: How often does each vehicle's device obtain a GPS location? How often does each vehicle's device send position data to the hosting server? How often does GeoEvent query the hosting server to obtain new data? I'm just trying to get a feel for what the industry standard is these days. Thank you for any insights you can provide -Andrew
... View more
09-30-2019
07:33 AM
|
0
|
2
|
2849
|
|
POST
|
Thank you Peter, I'll see if I can use that endpoint to extract the logins on a regular basis and aggregate login counts by user in Excel or BI tools to get a general feel for how much staff are using Pro.
... View more
09-18-2019
09:43 AM
|
1
|
1
|
5190
|
|
BLOG
|
Is there a way to obtain this admin token programmatically via the REST API? Is it different then the token obtained by the/sharing/rest/oauth2/authorize endpoint or the /sharing/rest/generateToken endpoint? I ask because I'm trying to get an ETL tool to retrieve data from the AGOL REST API's portal_history endpoint via my federated admin account, but the authentication documentation for the API sends me in circles for this type of Portal administrative workflow where I just need to connect to the ArcGIS Online Org or Enterprise Portal and query out some details about users, items, licenses, etc. I assume the code is as basic as two lines 1) Submit REST call containing my credentials to obtain the token 2) Submit REST call to the Portal_History endpoint containing my credentials
... View more
09-11-2019
04:36 PM
|
0
|
0
|
3364
|
|
POST
|
Is there a way through the ArcGIS API (or other tools) to grab detailed Named User ArcGIS Pro license usage statistics from ArcGIS Online? The question I'm trying to answer is, "Out of all the users I've assigned a Pro license to, who's using them and who isn't?" For example, John Smith's ArcGIS Pro was pulling a license from ArcGIS Online for 4 hours on August 26th, and then have that kind of daily detail going back 30, 60, 90 days. I've seen that there is a generic chart of this information in ArcGIS Online if you go to Organization->Status->Apps, and then scroll to the bottom of the page to the "Usage of ArcGIS Pro by Org Members" chart. I'd like to extract this data and use it as a reference in my GIS user reports I'm compiling in Excel. I've inspected the API reference and didn't see a way to grab the numbers. The closest I found is the "Previsioned Listings property of users" which will show you what apps a user has been given a license for. And even then you have to run this for every user in your Org and find out if they have a Pro license assigned. I believe OpenLM has a new tool to do this in their July 2019 release, but I was curious if there is an out of the box way.
... View more
09-04-2019
12:08 PM
|
2
|
4
|
5381
|
|
POST
|
Thank you. That was the ticket! Here's some new code you can run the Pro python window. Not pretty at all, but it does print the title and list of users from the group. from arcgis.gis import GIS gis = GIS("pro") all_groups = gis.groups.search('1=1') for group in all_groups: members = group.get_members() users_list = members['users'] users_string = ','.join(users_list) print(group.title + '...' + users_string)
... View more
08-08-2019
06:44 AM
|
0
|
0
|
4227
|
|
POST
|
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
08-05-2019
08:11 AM
|
3
|
3
|
7825
|
| Title | Kudos | Posted |
|---|---|---|
| 5 | 11-19-2025 07:03 AM | |
| 1 | 06-16-2025 02:17 PM | |
| 18 | 10-11-2024 12:58 PM | |
| 5 | 09-20-2024 09:19 AM | |
| 4 | 07-28-2022 08:55 AM |
| Online Status |
Offline
|
| Date Last Visited |
Friday
|