Latest Contributions by JustinWolff

Using ArcGIS Pro 2.9.5 Advanced and file geodatabase for all data workspaces. I have a model built using an iterator to perform various geoprocessing on input polygon geometry*, where the goal is output in a table where each row contains beginning and end x/y coordinate pairs, which will be used elsewhere outside of the model to create line features. Following geoprocessing of the input shapes, I'm perform four Sort functions on a table to get the minimum or maximum value for a specific field, then a Get Field Value to capture that first record from the sort for each of the four Sorts.  This is where I get stuck: I'm currently using the Get Field Value results, followed by Collect Values and exporting those results to separate tables, then merging the four tables together.  The result is close to what I need, but I need to dissolve the records together but am not sure how with a standalone table. Because this is within an iterate, ideally I could just use the four Get Field Values and use those to calculate fields in another table (where each iteration calculates on the same record) - but I cannot figure out how to do that.  Perhaps I'm approaching this wrong altogether, or perhaps there's a way to use Pandas to dissolve/melt the merged table output...I'm stuck.  Any help would be appreciated.  Thanks *I am manually merging parcel data together by PLSS section, and then using this model builder process to create PLSS quarter section lines based on the geometry of the merged parcels.  The model builder iteration is to perform the various geoprocessing section-by-section.  The desired result is for cleaner cartographic displays where at least the section lines and parcel boundaries are coincident.  So far this model is only focused on the West-East quarter section lines.  If I can get it working I'll expand it to also create South-North lines as well. ... View more

I'm not great with Arcade and stumped.  I'm trying to create a pie chart in a Dashboard based on two date fields, 'Ordered' and 'Received'.  Records are either null or populated with the date ordered or received.  I'd like the pie chart to show counts of Ordered and Received.  I think I need to use the GroupBy function, but I'm not sure what I'm doing.  Thanks.   var p = <portal>; var tracts = FeatureSetByPortalItem(Portal(p),<item>, <id>, [ 'OBJECTID', 'Name', ‘Ordered', 'Received', ], false ); var count = GroupBy(tracts, [ // fields/expressions to group statistics by { name: ‘Ordered', expression: 'Received IS NOT NULL'}, { name: ‘Received', expression: 'Received IS NULL'} ], [ {name: 'Ordered', expression: '1', statistic: 'COUNT'} ]); return(count)     ... View more

I have a feature class with multiple overlapping polygon layers (state boundary, county boundaries, legislative boundaries and city boundaries) for use in a dashboard.  It's published as a feature service, and saved in a map with the 'merged' layer visible, and a copy of the merged layer set with a filter to isolate each type (state, legislature, county and city) as separate layers - these are turned off in the map.  Basically i need a pop up to return everything all the time, but not return an empty value for Municipalities when users don't click on a city. I'm attempting to use Arcade where a user click in the map (on the 'merged' layer) returns a pop up with values from all intersecting, individual type layers at that location.  These are returned in a popup where users would toggle using the arrows from one layer to another. I'm stuck using the intersectLayer function within an if/then, or how to accomplish this otherwise...maybe some of this needs to be handled in the pop up HTML. Below is what little I have, and the current results (which are not accurate): Arcade expression:   var buff = Buffer($feature, -50, 'feet') var intersectLayer = Intersects(FeatureSetByName($map,"Counties"), buff) for (var f in intersectLayer) {return '$' + Text(Round(Number(f.Total_Funds),2),'#,###,###,###.##')}     Pop up configure HTML:   <div style="text-align: center;"><font color="#c0c0c0" size="4"><b>{expression/expr2}</b></font></div><b><font color="#FFC843">First Tranche Allocation:</font></b> {expression/expr6}<br /> <b><font color="#FFC843">Total Fund Allocation:</font></b> {expression/expr5}     We are working in Portal 10.8.1 and we won't be upgrading until 10.9.1, at which point we may utilize some extended Arcade functionality in Dashboards, but this project is moving forward now. Thanks ... View more

I have a .csv that was created using input_xls.to_csv, and everything delimits correctly.  However, within some of the string records are commas (e.g. a business name like 'Widgets, Inc.').  The result is incorrect delimiting when importing the .csv into a file geodatabase using arcpy.conversion.TableToTable -  values end up shifted over into other columns.  I want to replace the commas with a space. I cannot figure out how to use either something like .apply(lambda x: x.replace(',', ' ')) or  [val if val else " " for val in row] + ([" "] * (len(first_row) - len(row))) (found here: https://community.esri.com/t5/python-questions/find-and-replace-blanks-in-csv-with-python/m-p/673632)  Any help to nudge me in the right direction would be appreciated.  Thanks. ... View more

We are attempting to maintain a dataset to include records only for the past 3 years.  New records are appended daily (via other scripted geoprocessing). The table is in Enterprise SQL, and contains both varchar date (dd/mm/yyyy) and datetime (yyyy-mm-dd hh:mm:ss:ms) fields. How do I select records that are 3 years older than yesterday (for deletion)?  I thought I was going down the correct path with this in SQL but I'm not getting far:    DateTimeField < DATEADD(yy, -3, CONVERT(datetime, CONVERT(varchar, GETDATE(), 101))) I need selections to the day, not the datetime (e.g. On March 11, the new records from March 10 are appended, and anything more than 3 years older than March 10 are deleted.  It's to the full date, not the actual time of day when the script is run.)  This selection will be used within a scheduled .py daily. Thanks Justin ... View more

Version: ArcGIS Pro 2.6.3 Data: Enterprise SQL 2016 I have a table of parcel sales data, with ParcelID field (text type) as the parcel identifier and SaleDate (date type).  There are multiple rows for the same ParcelID value, each with a different SaleDate value.  I want a selectio of the records keeping only the latest date, within model builder (it's part of a larger process). Based on the guidance here: https://support.esri.com/en/technical-article/000008936 I have the following in a Select Layer By Attribute or Table Select tool - both have the same results: SaleDate IN (SELECT MAX(SaleDate) FROM countySL GROUP BY ParcelID) I cannot get this to return the correct values.   I run this in SSMS and get exactly what I'd expect: SELECT n.* FROM [dbo].[COUNTYSL] n INNER JOIN ( SELECT ParcelID, MAX(SaleDate) AS SaleDate FROM [dbo].[COUNTYSL] GROUP BY ParcelID ) AS MAX ON MAX.ParcelID = n.ParcelID AND MAX.SaleDate = n.SaleDate ORDER BY ParcelID; GO I had originally built everything around FGDB, but moved to Enterprise SQL to use GROUP BY functionality.  Is there something special with the date format? In SSMS, this is what the countySL data looks like: Source countySL table And if I run the query below I get what I need: functional query in SSMS But in ArcGIS Pro model builder, if I use the query below: SQL in Model Builder I get this: Table Select results I've attempted using the Select Layer By Attribute tool as well, and messed with the 'Invert Where Clause' and attempted to switch selection from the source table, but it doesn't work either.  What am I missing? Thanks ... View more