Latest Contributions by JCGuarneri

‎03-10-2022

In the process of cleaning up datasets we no longer use and looking at disk usage for an Enterprise geodatabase, I discovered that nearly half of the disk usage is coming from the historical tables of two frequently updated items, a feature class in a feature dataset and a table. These two items participate in a relationship class with each other. Between the two of them, the tables are taking up almost 95 GB, whereas the current data only takes up about 3 GB combined. Is there a way to keep the size of the historical tables in check without turning off geodatabase history?

‎02-23-2022

@jcarlson When I check the layers property, all the layers show up. I just tried FeatureLayerCollection, and that has the tables. I think I'm on the right path now. Thanks!

‎02-22-2022

We just moved a table over to branch versioning as our test case, and I'm trying to update a script that we used to edit values in this table. It looks like I need to use the Python API. I'm finding the feature service using content.search() and trying to pull up the tables using the tables property of the feature service item. However, it doesn't return any tables. The layers property returns a list of layers. I can see the table if I look at the REST endpoint, but not in the Python API. My question is: Are there any alternative paths to getting to this table? For example, can I open the table object using its REST URL? Also, anyone have any ideas as to why the table isn't showing up in the search? Bonus question: Can tables in feature services work with SearchCursors and UpdateCursors? Or should I use a different approach to update individual rows?

‎11-16-2021

Aha! It seems so obvious now. Thank you!

‎11-16-2021

I'm trying to set up and configure the egdbdatastore Monitor add-in to track my data store installs. I can't seem to find any documentation. The Readme isn't helpful, and I think there's supposed to be a PDF, but I don't see one. Does anyone have a link to some documentation?

‎10-12-2021

Are all the maps rotated by the same amount? In that case, my inclination would be to just use one North arrow for all maps. If there is a hard requirement for each map to have its own North arrow, or if they are rotated by different amounts, the simplest approach would be to use guides. Find the measurement of the edges of your maps, then insert guides at measurements that are offset from the edges by the desired amount. In the pictured example above, you'd need two vertical guides and 6 horizontal guides. Once you have the guides in place, you can just move the arrows into position. If you want to get really fiddly, you can also manually enter values for the position by accessing the placement options on the format element tab. You can set both the position and anchor point (the spot in the element that the position refers to). If you really need full control, you can even adjust these positions in a Python script using the arcpy.mp module. I've used this when exporting pages in a map series to make sure everything's right where I want it. I think the Map Production extension has tools that make that even easier, but I've never used it.

‎10-06-2021

I had that happen before. I ended up having to call esri tech support to reset the license. The only other way is if you can figure out what device it's set for offline mode on and access that. If you can do that, you can release the offline mode from that device.

‎10-05-2021

I'm trying to set up a calculation attribute rule to populate a general ledger account value based on the contents of some text fields, and I'm running into trouble with validating the rule. My Arcade script works when I run it as a field calculation, as a popup calculation, and even validates in the Expression Builder in the attribute rule setup. When I go to save the rule, I get an error of 002717: Invalid Arcade expression, Arcade error: String type expected, Script line 39 (that's line 18 in the code snippet below). Is this a bug, or is there something I'm doing wrong here? I'm using ArcGIS Pro version 2.8.3. My code is basically the following. I've shortened the dict and redacted accounts, but you get the idea. //lookup dictionary for account numbers var accountDict = { 'DISTNonUnionSUV' : '######-####-###', 'DISTNonUnionVan' : '######-####-###', 'DISTNonUnionTruck' : '######-####-###', 'DISTUnionBackhoe' : '######-####-###' }; //collect values from fields var vehDept = $feature.Department; var vehClass = $feature.Class; var unionStatus = $feature.VehicleType; //concatenate values to generate key var accountType = vehDept + unionStatus + vehClass; //retrieve and return GL Account var accountNum = accountDict[accountType]; return accountNum; And proof that it's validating in the expression builder:

‎09-09-2021

Interesting idea. I did check the IIS logs, but all the entries come from the same machine. I'm guessing this is because the requests come in via Portal. Also, I'm not sure blocking the source would be the solution. I'm pretty sure it's coming in via official channels. It's almost certainly from our field crews, and almost certainly not external. We have everything blocked off with a firewall and VPN access.

‎09-08-2021

I've been getting an error multiple times a day related to a feature service that we use for gate valve inspections. The message is "Exception in setting 'ownership' role Failed to return the service configuration 'GateInspectionReport.MapServer'. Server machine 'https://{redacted}/arcgis/sharing/rest/content/items/b2615dccfb1847318dd4d611bf9173df' returned an error. 'Item does not exist or is inaccessible.'" I've confirmed that item b2615dccfb1847318dd4d611bf9173df does not exist. However, I can't seem to track down where in the chain of communication something is asking for that item. I've checked the hyperlink that opens Survey123, the Survey123 XLS form, the JSON for all maps/services/etc related to that workflow in AGO-Assistant. I've even tried searching for dependent items using the API for Python. I have not been able to turn up anything. Is there somewhere else I should be looking? I haven't been able to pin down when the error is triggered. I have some clues that point to attribute edits, but nothing solid. The Esri products involved here are Portal/Server 10.8.1 with all patches, Collector 20.2.4, and the "Classic" version of Survey123.

‎08-27-2021

I've found the solution to my own problem. Using Arcade, I was able to build the custom URL that way and return it as text in a popup field. From there, I simply had to pass that value into the Hyperlink function in a custom attribute display. It returns the correct link when you click on it, in desktop and mobile, and I was successfully able to launch the Cityworks mobile app.

‎08-26-2021

Johannes, I'll have to try that out and report back. I'd considered that approach as an option, but hadn't gone down the rabbit hole yet. That's a nice bit of code you've got and I feel like that could work, depending on the max number of plans.

‎08-25-2021

Hello, all. I've seen similar questions asked here, but none quite get at what I'm looking for. We maintain a bunch of plan area polygons that store a hyperlink to scanned construction plans. Currently, we access those plans just from the popup of the plan area. In any given area, for any given asset (water mains, for example), there may be multiple plans that are relevant. Currently, we have to cycle through all the plan popups to find the one we want, but it's been requested that I make it so we can click on an individual asset and see all the relevant plans. I'm thinking something with Arcade would be the best bet at a solution that is performant, maintainable, and doesn't balloon our database size. However, I can only seem to get about 2/3 of the way there. I have an expression that can return each link on it's own line, but it's hard to read and it doesn't automatically format as a link: //get names and hyperlinks of intersecting plan features var plans = Intersects($feature, FeatureSetByName($datastore,"Plan Area", ["PlanName","Hyperlink"])); //create string to store hyperlinks and add links with lines in between var linkList = ''; for (var p in plans){ var linklist = linklist + p.Hyperlink + TextFormatting.Newline; } return linklist; Which returns: https://website.com/link1.pdf https://website.com/link2.pdf https://website.com/link3.pdf Since it's all in a single field, none of the URL text acts as a link. What I'd like to do is have all the plan names listed and formatted as hyperlinks to the corresponding plan document: Plan 1->https://website.com/link1.pdf Plan 2->https://website.com/link2.pdf Plan 3->https://website.com/link3.pdf Have I reached the limits of the popup's capabilities, or is there a key step I missed? Alternatively, is there a way to pass this info to Javascript API to build a popup in a map built that way?

‎07-01-2021

When adding DB credentials in ArcGIS Monitor, we have to follow a clunky process that requires typing out a connection string just so. Instead of (or in addition to) using this connection string method, it would be great to be able to use an existing .sde database connection file like we can when setting up a datasource in Server.

‎06-18-2021

The official take from Esri support is that this is out of scope for support, since it's a URL to open a third party application. I'd agree if the case was that the the link failed to open the third-party app, but the issue is the link is getting modified by the Esri platform. Very disappointed.

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by JCGuarneri

Controlling Size of Historical tables?

Re: Editing a Branch versioned table

Editing a Branch versioned table

Re: Documentation for egdbdatastore Monitor add in?

Documentation for egdbdatastore Monitor add in?

Re: Placing an object to the same place in every map in a Layout View

Re: URGENT: ArcGIS Pro thinks I'm in offline mode on another computer & I can't access it

Attribute Rule Validation Trouble

Re: Unable to Track Down Reference to Non-Existent Item

Unable to Track Down Reference to Non-Existent Item

Re: Cross-App URLs being Renamed in Web Maps

Re: Arcade Expressions to get Hyperlinks from Multiple Overlapping Polygons

Arcade Expressions to get Hyperlinks from Multiple Overlapping Polygons

Allow ArcGIS Monitor to Import Database Credential From .sde File

Re: Cross-App URLs being Renamed in Web Maps

Ability to Remove Asset Types, Change Terminal Con...

Re: How to run geoprocessing off a script output i...

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

Re: Please ensure gssapi is installed

Re: Unable to Monitor Federated Server