Latest Contributions by RPGIS

‎02-17-2025

@MitchellDrennan Just for clarification, are you talking about displaying certain rows as the map is panned around and only showing those rows. If that is the case then it might be the limitation of pro as it currently stands since the standalone table does not have a spatial component. The problem with manually panning maps is those are not as conducive compared to using spatial filters or bookmarks. The method that I propose is similar to the examples that you linked but not quite. The methods that I used in the past generally referred to manually selected a group of features and assigning them a unique value to filter by. I then added those same values to the other table and set the page query to match. It is still somewhat manually but at least it got me close to what I needed. The only challenge with manually creating anything is that it will have to manually be updated. I don't know if your data is dynamic in any manner, but if it is, then I would suggest using an alternative means such as another layer to pull information from and using arcade to populate that particular field in both the feature and table(s). I also vaguely remember that as a capability in arcmap but I have noticed substantial changes when moving to pro where even the simplest of capabilities are no longer present. But that was years ago.

‎02-17-2025

Hi @MitchellDrennan, I am afraid that it isn't possible because, unlike spatial data tables, regular tables have no spatial component which is why it isn't possible. What you can do, however, is if you want specific features to show in both the map and tables that correspond with a set of records you can Create a common field that matches those specific values and another for a specified extent( optional ) in both the feature class and table Recreate the maps series based on that value and it should have similar behavior to what you are looking for. It is kind of a lengthy work around, but I have used it in the past when I had multiple features in a map that I wanted to show and related table information that corresponded with it.

‎02-14-2025

I use this as part of an attribute rule for the most part but it I have yet to test it in other places such as dashboards. It's mostly a data load operation, similar to using append with field map.

‎02-14-2025

Hi @PatrickLösel, So the geometry needs to be a point feature, which you can look up in the documentation here. In terms of the code, it might be that there is an inherent syntax issue with part of the code reading as text and not script. Try writing the code using the point feature that is mentioned and see if that does the trick.

‎02-13-2025

I noticed that there some issues with the console values as well that I am trying to breakdown the math but this code was copied, like you said, using copilot but it is incorrect. When I ran some tests it worked in some instances and not in others. I also noticed that sometimes it would be off by 4 degrees in some spots but I am trying to figure out where that issue is in the code.

‎02-12-2025

Hi, Currently, the workflow for publishing services requires using ArcGIS Pro, which limits the process to the machine where the service was originally published. This dependency creates a significant drawback: requiring the installation of the entire ArcGIS Pro application on each machine designated for publishing services. Additionally, configuring symbology, labels, and other elements must be done on the same machine. To address these limitations, I propose creating a publishing app or service configurator hosted on the portal server. This solution would allow services to reside on the server and enable the creation and configuration of symbology, labels, filters, and other settings through registered database connections. This approach would save considerable time and reduce the complexity of managing multiple services across different machines.

‎02-12-2025

This is already possible. You can set the table rows to query by the page query in the table properties.

‎02-12-2025

I know of someone who was trying to push for that but there were too many limitations with using Survey123 compared to field maps. That is why most of our projects are created to be used in field maps instead.

‎02-12-2025

Hi @wizgis, It is possible to do so in Dashboards. You would simply create a new feature set under "Data Expressions" and use the newly created data for any of the needed widgets in the dashboard. The code below should give you some ideas on how to go about it. var P = Portal('<portal url>') var Pnts = FeatureSetByPortalItem( P , '<item id>' , '<layer id>' , '<list of field names>' , True )// layer id is often 0 if the only layer var Poly = FeatureSetByPortalItem( P , '<item id>' , '<layer id>' , '<list of field names>' , True )// layer id is often 0 if the only layer var IntPntPoly = Intersects( Geoemtry( Pnts ) , Poly ) var GrpBy = GroupBy(IntPntPoly , '<layer name>', { name: '<custom field name>', expression: '<field name in layer>', statistic: 'COUNT' }) return GrpBy

‎02-03-2025

In addition, something that is also quickly done, is with the search cursor there is the option to use sql queries within the cursor that will allow for you to filter data based on a certain criteria. This might be faster than using the cursor without a sql statement. Note: Script updated on 2/4/2025 import arcpy import SearchCursor as Search feature = r'<filepath>' fieldnames = [<list of fieldnames>] query = 'WHERE <fieldname> IS NOT NULL' # You can also set the query to as an f string to f"WHERE NONE NOT IN {tuple(fieldnames)}" limit = 25 hasvalues = False with Search( feature , fieldnames , query ) as cursor: for row in cursor: if len( set(row).difference({None}) ) > 0: hasvalues = True if limit == 0 or hasvalues is True: break limit = limit - 1 if hasvalues is True: x = 'Do something'

‎01-31-2025

Hi @Davide_Pili , It might be possible, and probably far fetched, but you might be able to use arcade to get the username and create a custom set of features within the dashboard as an extra dataset. Portal functions | ArcGIS Arcade | Esri Developer

‎01-31-2025

Thanks @LindsayRaabe_FPCWA for the suggestion. I went ahead and made the changes, and I am hoping that this can be used to create a function for attribute rules. I think there might be something simpler than this, but I will need to explore further.

‎01-30-2025

Hi, I found this code that I copied from copilot and modified for my specific needs and works somewhat but needs some major corrections. // Constants for NAD83 Georgia West (FIPS 1002) var A = 6378137.0; // Semi-major axis for NAD83 var F = 1 / 298.257222101; // Flattening for NAD83 var E2 = (2 * F) - (F * F); // Eccentricity squared var centralMeridian = -84.16666666666667 * (PI / 180); // Central meridian for Georgia West (degrees to radians) var latitudeOfOrigin = 30.0 // Latitude of origin (degrees to radians) var scaleFactor = 0.9999; // Scale factor var falseEasting = 2296583.333333 * 0.3048006096012192; // False easting in meters (1 US foot = 0.3048006096012192 meters) var falseNorthing = 0.0; // False northing in meters // Function to convert State Plane (NAD83) to Latitude and Longitude function statePlaneToLatLong(x, y) { x *= 0.3048006096012192; // Convert x from US Feet to meters y *= 0.3048006096012192; // Convert y from US Feet to meters x -= falseEasting; y -= falseNorthing; var m = y / scaleFactor; var mu = m / (A * (1 - (E2 / 4) - (3 * E2 * E2 / 64) - (5 * E2 * E2 * E2 / 256))); var e1 = (1 - sqrt(1 - E2)) / (1 + sqrt(1 - E2)); var phi1 = mu + (3 * e1 / 2 - 27 * pow(e1, 3) / 32) * sin(2 * mu) + (21 * pow(e1, 2) / 16 - 55 * pow(e1, 4) / 32) * sin(4 * mu) + (151 * pow(e1, 3) / 96) * sin(6 * mu) + (1097 * pow(e1, 4) / 512) * sin(8 * mu); var sinPhi1 = sin(phi1); var cosPhi1 = cos(phi1); var t1 = tan(phi1) * tan(phi1); var c1 = E2 * cosPhi1 * cosPhi1 / (1 - E2); var r1 = A * (1 - E2) / pow(1 - E2 * sinPhi1 * sinPhi1, 1.5); var n1 = A / sqrt(1 - E2 * sinPhi1 * sinPhi1); var d = x / (n1 * scaleFactor); // Calculate latitude and longitude in radians var latitude = phi1 - (n1 * tan(phi1) / r1) * (d * d / 2 - (5 + 3 * t1 + 10 * c1 - 4 * c1 * c1 - 9 * E2) * pow(d, 4) / 24 + (61 + 90 * t1 + 298 * c1 + 45 * t1 * t1 - 252 * E2 - 3 * c1 * c1) * pow(d, 6) / 720); var longitude = centralMeridian + (d - (1 + 2 * t1 + c1) * pow(d, 3) / 6 + (5 - 2 * c1 + 28 * t1 - 3 * c1 * c1 + 8 * E2 + 24 * t1 * t1) * pow(d, 5) / 120) / cosPhi1; // Convert latitude and longitude to degrees var latitudeDeg = latitude * (180 / PI)*10; var longitudeDeg = longitude * (180 / PI); // Format results as degrees North and degrees West return { latitude: round( abs(latitudeDeg) , 6), longitude: round( abs(longitudeDeg) , 6) }; } // Example usage with provided coordinates var x = Geometry($feature).x; // X coordinate in US feet var y = Geometry($feature).y; // Y coordinate in US feet var result = statePlaneToLatLong(x, y); console(result); // Output: {latitude: "xy.xyzxyz° N", longitude: "xy.xyzxyz° W"} return result.latitude

‎01-30-2025

Thanks @KenBuja for catching the result = "null" and not dictionary. That was my bad. I should have wrote it like this. var pattern = "com" // Substring to match field names starting with "com" var result = Null for (var field in $feature) { if (Lower(Left(field, Count(pattern))) == pattern && !IsEmpty($feature[field])) { result = Text(Dictionary( field , $feature[field] ))// Create dictionary and convert to text } } Console(result) return result

‎01-29-2025

You mentioned you tried using the 'Expects' as it had been given, and it still returned a blank dictionary. Can you run your code with console wherever there is a line of code that is running and paste a snippet of the results? You code looks fine, but it is strange that it doesn't return the fields you are looking for.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by RPGIS

Re: Limit attribute table to only those rows that satisfy a Page Query when a Map Series is turned on

Re: Limit attribute table to only those rows that satisfy a Page Query when a Map Series is turned on

Re: Sharing some functions that could be added for further arcade enhancements

Re: Creating a centroid Point Feature from a Polygon with attribute rules

Re: Arcade Script For Converting From State Plane to Decimal Degrees

Separate Publishing Environment For Portal

Re: Limit attribute table to only those rows that satisfy a Page Query when a Map Series is turned on

Re: Opening Existing Survey in Survey123 Connect

Re: Dynamic count of points inside a polygon

Re: Faster way to iterate through Feature Datasets and Add to Map?

Re: data expressions to filter a feature layer

Re: Just thought to share.

Arcade Script For Converting From State Plane to Decimal Degrees

Re: Create label from the nonNull fields in layer

Re: Create label from the nonNull fields in layer

Re: ARcGIS Fieldmaps - photo attachment, new workf...

Re: list comprehension to evaluate each element of...

Re: Category selector not working on table created...

Re: $pixel profile has all null values in arcade e...

Re: Feature Linked annotation missing ArcGIS Pro

ArcGIS Arcade