Latest Contributions by JCGuarneri

‎09-20-2024

You're not kidding about that being faster! I had to make a couple minor modifications, but it is returning the correct number of values for each cycle year. I can't seem to get it to populate values correctly for ShopDescription and District (returns NaN), but I was considering splitting out those categories at the Cityworks URL side, anyway. Thank you for your help!

‎09-20-2024

Ah, that worked! Thank you. Theoretically, those are all unique. But I'm happy that works. Exposed another thing I need to sort out, but this get's me very close to the finish line.

‎09-20-2024

Oh, that's great! Definitely missed that in the release notes. I haven't updated the machine I typically publish from to 3.3 yet, so I'll have to give that a shot once I get there.

‎09-20-2024

I'm having trouble with an Arcade data source that I want to use in a dashboard (Enterprise 11.1). The goal is to take some inspections in Cityworks and sort them into bins based on what year in a 5-year cycle they fall in, to help managers rebalance them. The problem is, the expression returns fewer values than it pulls in initially. Even more perplexing, the exact number of records returned each time is different: Here's the code I'm using (server names changed to protect the innocent). Is there something I'm missing in the code that could cause that? var portalItem = 'RanDOmP0rta1iDNUm85r'; var thisPortal = Portal('https://myserver.mydomain.com/portal'); var inspections = FeatureSetByPortalItem(thisPortal, portalItem, 58,['InspectionId','PrjStartDate','ShopDescription','DistrictDescription']); //create dict to store updated features var cycleYears = { 'fields': [{'name':'InspectionID', 'type': 'esriFieldTypeOID'}, {'name':'ShopDescription', 'type': 'esriFieldTypeString'}, {'name':'District', 'type': 'esriFieldTypeString'}, {'name':'CycleYear','type': 'esriFieldTypeDouble'}], 'geometryType': '', 'features': [] } var count1 = Count(inspections); console(`Records in: ${count1}`); //put the year in each record into a bin //append to dict for(var f in inspections) { var cycleYear = (Year(f.PrjStartDate) % 5) +1; var new_f = {'attributes': {'InspectionID':f.InspectionID, //'PrjStartDate':f.PrjStartDate, 'ShopDescription':f.ShopDescription, //'Text1': f.Text1, 'District': f.DistrictDescription, 'CycleYear': cycleYear }} Push(cycleYears.features, new_f) } //convert to feature set and output as data source var inspCounts = FeatureSet(Text(cycleYears)); var count2 = Count(inspCounts) console(`Records out: ${count2}`); return inspCounts;

‎09-18-2024

This is definitely critical functionality, and I'm not sure why it's not included out of the box.

‎09-17-2024

This is absolutely critical. I have tables that come in from a non-geodatabase source that I need for web services. Right now, we need to maintain a copy of the data in our geodatabase. Originally, there were some other requirements that made this necessary. Modern Arcade popup options have made this unnecessary. Being able to publish this other table as a standalone would vastly simplify our data storage and workflows.

‎09-13-2024

I've attempted this fix, but It stays on the same requests version. Is there something I'm missing?

‎08-23-2024

I haven't tried pulling in matplotlib yet. I'm hoping to just stick with the Pandas tools to keep the code simpler for the end users. But that's a good suggestion. Edit: I just tried the method suggested. It did not make a difference.

‎08-23-2024

I'm developing a notebook for our environmental science team to extract, visualize, and analyze well level readings. I got it most of the way there using the web-based Jupyter editor and plots were looking good. I brought the notebook into Pro 3.2 to finish developing it and make it easier to share. Now that it's in Pro, when I run the plot() method on the Pandas dataframe, the plots do not show. It looks like it's creating the plot object successfully, just not drawing it. Interestingly, the plots that had already been generated in the web version are still showing in Pro (see below). I did confirm that there is actually data in the dataframe I'm trying to plot. Does anyone know how I can force it to draw.

‎08-19-2024

Fortunately, I fixed the server over the weekend. While less pressing, I'm still curious to know what the answer to this is.

‎08-17-2024

I had the unfortunate experience of the server I run Utility Network off of tanking yesterday. I'm waiting for Esri tech support to get back to me, and in the meantime I'm standing up replacement services on another machine so we can get back to work. When I publish the UN Feature Service, I'm able to connect, but I don't see the existing branches. Looking at the relevant table in SQL Server Management Studio, I can see that the versions still exist, but they specify that they're related to the UN Feature Service that is currently out of commission. My question is: is there a way to access them from the new feature service? And if not, will I be causing new and more interesting problems by creating new versions off the new feature service? If I can't get the old service back up and running, I'll also have to figure out how to reconcile and remove the old versions, but I'll cross that bridge when I come to it. PS I know disaster recovery tools would have made this all much easier. It turns out my automated disaster recovery backup process had been failing for at least a month. So, PSA to check on your automated processes!

‎08-01-2024

I had previously done it by adding World Geocoder as a server connection, and then adding that to the composite locator. Url is : https://geocode.arcgis.com/arcgis/services I had done that as recently as December of last year and it worked then. It's giving me trouble at the publishing phase for a new locator, though (service fails to start). Hopefully your experience is different.

‎07-03-2024

Thank you! This saved the day!

‎07-02-2024

Not being an Esri employee, I can't comment on how much work it would or wouldn't be. However, there's nothing stopping them from still using the XLS form. I'm picturing something much like what is already in place in the data design functionality (fields, domains, etc). Or better yet, why not make it so that the pick lists in forms just update with the existing Domains from the feature service they are pointed to? My larger point is that designing and working with Survey123 forms is shockingly divorced from the rest of the Enterprise/ArcGIS Online workflows that they're supposed to be tightly integrated with. Right now, I can make a Pro project that has a all the maps, layouts, reports, tools, etc, I need to set up and manage an enterprise-level workflow pretty much end to end. Survey123 is a glaring exception, and it would make sense if I could include any relevant forms in that same project.

‎06-18-2024

It's nice to have the standalone Survey123 Connect app for users other than the core GIS Staff, but it would be very convenient to also have that rolled into ArcGIS Pro. The standalone app can occasionally cause IT headaches, especially since it's installed via the Windows app store instead of as a standalone install file. If it's in Pro, it would already be there and we can also associate surveys with a specific project.

Online Status	Offline
Date Last Visited	‎09-20-2024 11:13 PM

My Ideas

Latest Contributions by JCGuarneri

Re: Custom Arcade Data source returns fewer records than it gets

Re: Custom Arcade Data source returns fewer records than it gets

Re: Publish a standalone to Enterprise (by reference)

Custom Arcade Data source returns fewer records than it gets

Re: Better Data Management in ArcGIS Data Store

Re: Publish a standalone to Enterprise (by reference)

Re: Connection to AGOL Exception

Re: Python Notebook - Pandas plots not drawing when imported to Pro

Python Notebook - Pandas plots not drawing when imported to Pro

Re: Published a new Branch Versioned Layer, Can't access existing Versions

Published a new Branch Versioned Layer, Can't access existing Versions

Re: Can esri world geocoder be used in composite locator?

Re: Duplicate GlobalID renders deleting/removing feature impossible - Delete selected features failed.

Re: Design and Publish Surveys from ArcGIS Pro

Design and Publish Surveys from ArcGIS Pro

Re: How can I change the order of popups on an Arc...

Re: Please ensure gssapi is installed

Re: Unable to Monitor Federated Server

Re: Locator not supported

Re: Cross-App URLs being Renamed in Web Maps