Latest Contributions by LorindaGilbert

‎02-23-2022

I guess the answer to one or multiple also depends on the usage of the feature service. I would test both.

‎10-25-2021

If popdiff is the label, not the data, you can use this var popdiff = Text(tot20 - tot10, '#,###')

‎10-20-2021

Hi, I'm attempting to create a data expression from a published dataset on our site in ArcGIS Online using the FeatureSetByPortalItem function. The data has not been shared as of yet due to just starting the build out of the dashboard. I can't seem to find the proper syntax for accessing this data, the instructions say that the portal is "https:\\www.arcgis.com", our site on AGOL is prefaced as "org.maps.arcgis.com". When I attempt to look at the rest services (which it is only a feature layer rather than a map service or feature service), I get that a token is required. I did find the full URL for this one with the Token, so am able to see the listing of the layer IDs (only one). Putting in the org.maps.arcgis.com, I get that it failed to fetch. I was able to create an expression using data from the living atlas, however, it isn't the data that I want to use. EDITED TO UPDATE: just testing various combinations, I was able to use www.arcgis.com as the portal and the itemID and layer ID, it started working and gave me the list of the data in the feature set. Not sure if there was a wait time or what. Now to add the calculations that are required for some data coming out of this feature set. Thanks, Lorinda

‎09-28-2021

Hi, Have a table with a related table that I'd like to sort the related table in descending order (as the latest data is the most important). It is sorting in ascending order. Has anyone been able to actually get the data to sort descending? This is a character field for the year. Hopefully by doing this in ArcPro it will follow thru to the web app that is also using the same data. Thanks, Lorinda

‎08-23-2021

Hi All, We're looking to create a new grid for mapping use. Wanted to know if anyone has used the grid index creation tools to create one that would radiate out from a central location, i.e. if you were to look at the x,y coordinates and see x running right, -x running left, y running up, -y running down. Our addresses originate at a central intersection in the city and we'd like to recreate a new grid system for mapping using the central location as the origin for the map series. I have some ideas on how to accomplish this manually, but wanted to see if it could be done thru geoprocessing. Thanks, Lorinda

‎08-19-2021

In the the first sequence you haven't done anything to the original value of your variable 'cmts'. You do in the second sequence. Very cool. var cmts = $feature.Comments var Uc = Upper(cmts) return Uc; Here I create a new variable and return it. Not as cool. No need to create a variable because you use the object properties.

‎08-19-2021

Hi All, Is there a way in ArcPro that I could first test that a field has a value, if it doesn't, then have it select a value from a specific attribute in another feature class or a map service? It would have to be from something that we don't have as a feature service since the data we are pulling the attribute from is not owned/maintained by us. Edited: Reason for looking for an attribute rule method is that the client doesn't necessarily want to use a web app for editing the data. Wants to learn to use ArcPro, but data edited has specific items to be added and calculated as data entered. Moving from stored procedures in Oracle forms to graphic editing. Thanks, Lorinda

‎08-19-2021

Especially when you are using data that you don't maintain but have the map service for. It should never be in the datastore if you don't own/maintain it.

‎08-12-2021

I tried it with an attribute rule. var cmts = $feature.Comments Upper(cmts) return cmts; Applied after adding test string, still lower case. Did I miss something in this one? Did as a calculation rule, maybe it should be a constraint rule?

‎06-08-2021

I think that this is more of a Microsoft thing and not Esri. In terms of ArcGIS clients, we support either edition. The main differences are on the # of cores / memory / capabilities; https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison PDF: https://download.microsoft.com/download/2/9/0/290f991b-5971-42e5-bb2c-81f700622b2e/SQL%20Server%202019%20Editions%20Datasheet.pdf Hope that helps!

‎05-12-2021

Hi Lorinda, When you publish a hosted feature service it gets stored in the ArcGIS Data Store. The ArcGIS Data Store is indeed a PostgreSQL database. It is not designed to be accessed like you would access an Enterprise Geodatabase in SQL Server. For web feature layers to take advantage of attribute rules, they must reference registered data sources. This ensures that the data is not copied during the publishing process and is directly referenced by the service. Link here to share data with attribute rules as referenced data. Best of luck

‎04-27-2021

You're missing parenthesis around the last else if and you have an extra "}" at the end. It's easier to see this if you indent the code. var billclass = "V" var dor = 6400 var parea = 3457 var newfee = 0 var pimparea = 1500; var dwell = 2; var ouswmm = "Y" if (parea > 0 && (billclass == "V") && (dor < 6647 && dor > 5399)) { newfee = Round(((parea / 43560) * (12 * 0.1 * 5.99)) + 119.88, 2) } else if (parea > 43560 && (billclass == "V") && (dor < 5400 || dor > 6647)) { newfee = Round((parea / 43560) * (12 * (4.0 + (0.2 * 5.99))), 2) } else if (parea <= 43560 && (billclass == "V")) { newfee = Round((12 * (4.0 + (0.2 * 5.99))), 2) } else { if ((billclass == "M") && ((pimparea / 2000) < (1.15 * dwell)) && (ouswmm == "N")) { newfee = Round((pimparea / 2000) * (12 * (4.00 + (1.0 * 5.99))), 2) } else if ((billclass == "M") && (pimparea / 2000 < (1.15 * dwell)) && (ouswmm == "Y")) { newfee = Round((pimparea / 2000) * (12 * (4.00 + (0.3 * 5.99))), 2) } else if ((billclass == "M") && (pimparea / 2000 >= (1.15 * dwell)) && (ouswmm == "N")) { newfee = ((119.88 * 1.15) * dwell) } else if ((billclass == "M") && (pimparea / 2000 >= (1.15 * dwell)) && (ouswmm == "Y")) { newfee = ((69.56 * 1.15) * dwell) } else if (billclass == "M" && newfee < 5) { newfee = 5 } } Console(newfee)

‎04-01-2021

Hi All, Just got back to this. Turns out a couple of items were causing this issue. One, data was in an enterprise SDE and I was not connected as the data owner. But I took TigerWoulds suggestion and moved the data to a fgdb and tested, I am able to add attribute rules now. So will proceed in that direction for now; later I will try another as the owner of the data in the enterprise SDE. That's for the next big data edit style switch for our addressing and streets using the Addressing Model. Now I'm going to start a new thread since I am having issues with the Arcade expressions in the Attribute Rule. Thanks for the help. Lorinda

‎02-10-2021

Hi LorindaGilbert, Have you tried using the 'Allow assignment of unique numeric IDs for map service publishing' setting in the layer? For ArcMap: https://desktop.arcgis.com/en/arcmap/latest/map/publish-map-services/map-authoring-considerations.htm#:~:text=Right%2Dclick%20the%20name%20of,table%20in%20the%20data%20frame. See this blog for ArcGIS Pro settings: https://community.esri.com/t5/arcgis-enterprise-documents/utilising-unique-numeric-ids-in-published-services/ta-p/915453

‎02-05-2021

Thanks Josh! That was it! I figured it had to do with the extra dot, and I tried with quotes and brackets, just not in the format you suggested. It's working now. Now to get it to speed up the data retrieval - but that is most likely due to pulling across servers and databases which I know that ESRI isn't fond of doing 🙂 . Thanks again!

Online Status	Offline
Date Last Visited	‎01-12-2024 09:28 PM

My Ideas

Latest Contributions by LorindaGilbert

Re: Stand alone tables vs definition query

Re: Advanced Formatting use and having the numbers formatted with commas

Accessing data shared privately on your own site at AGOL for Data Expression in Dashboards

Sort order of Related Table in the pop-up

Using a central point for the origin in Map Series or Data Driven Pages

Re: Enforcing Upper Case text in attribute

Attribute Rule that would function like intersection does on Smart Editor

Re: Arcade FeatureDataSetByName() for calculations

Re: Default or Force column to store Upper Case?

Re: SQL Server Enterprise versus Standard

Re: Hosted Feature Service location and viewing

Re: Arcade scripting in Attribute Rules

Re: Creating Attribute Rules in ArcGIS Pro

Re: Indices in republished map service change

Re: Accessing Shape.STarea() from featuresetbyname

Re: ArcGIS Pro Set/Update Data source for all laye...

Sort order of Related Table in the pop-up

Re: Arcade error : FeatureSetByPortalItem cannot b...

One of several Attribute Rules not calculating as ...

Re: Publishing Survey using fields that are Non Ed...