Latest Contributions by JustinWolff

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

We stood up a Dashboard reporting COVID-19 data a few months ago and are regularly being asked to apply significant changes, which require republishing services and updating the map utilized by the Dashboard. This ultimately requires significant time to rebuild the Dashboard to look at the new, updated source web map.  We can't simply clone a new dashboard from Portal into AGO, because we must retain the existing Dashboard URL.  Is there a way to utilize the ArcGIS Online Assistant to "replace" the .json of the AGO Dashboard with that from an updated Portal Dashboard?  So far my attempts at altering the .json have not worked.  Thanks  (we're running Portal 10.7) Our current COVID-19 Dashboard in AGO: ArcGIS Dashboards  ... View more