Latest Contributions by timdunlevie1

Hi all, I have a feature class in a fgdb (ArcMap 10.6) and I want to add a definition query which shows me records that have a 'Start_Date' within 90 days of the current date. The issue I have is that the Date field (DD/MM/YYYY) I am using, I can only use the DD/MM portion of this field as the year part is not a future year date. For example: ID, Start_Date 1, 02/11/2015 2, 10/12/2001 3, 10/01/2011 Is there a way to use the day & month of the "Start_Date" field to determine  if the Start_Date is within 90 days of today's date or Current Date. My filter so far is this: (EXTRACT(MONTH FROM Start_Date) >= EXTRACT(MONTH FROM CURRENT_DATE)) and (EXTRACT(MONTH FROM Start_Date) <= EXTRACT(MONTH FROM CURRENT_DATE)+3) This is using the MONTH field, and it works to a degree, but is not quite precise. It also has a problem with dates that fall in January as those records are not selected by add +3 from current month (10). Can you combine EXTRACT(DAY....) AND EXTRACT(MONTH...) in the same query? I've been trying but keep getting a syntax error. thanks ... View more

Hi all, I have a feature class which has 1 field which are hyperlinks to photos: e.g. [PHOTO] : C:\temp\photo1.jpg, c:\temp\photo2.jpg, c:\temp\photo3,jpg All one string in the PHOTO field, separated by commas. I want to strip out each hyperlink and update 9 Hyperlink fields in the feature class: [HYPERLINK1], [HYPERLINK2], [HYPERLINK3]….[HYPERLINK9]. I thought it would be easy going something like this: with arcpy.da.UpdateCursor(fc, ['PHOTOS', 'HYPERLINK1', 'HYPERLINK2', 'HYPERLINK3', 'HYPERLINK4', 'HYPERLINK5', 'HYPERLINK6', 'HYPERLINK7', 'HYPERLINK8', 'HYPERLINK9']) as cursor:     for row in cursor:         row[1] = row[0].split(",")[0]         row[2] = row[0].split(",")[1]         row[3] = row[0].split(",")[2]         row[4] = row[0].split(",")[3]          etc...         cursor.updateRow(row) But I'm getting an out of index range as the [PHOTOS] field has some nulls. And also the [PHOTO] field can have between NULL and 9 Hyperlink strings separated by commas. So the above code would work if there were 9 strings separated by commas. Is there a way to get around this? ArcGIS v10.6, windows 10 Thanks ... View more

Hi all, I'm trying to compare data values in 2 separate feature classes and find out what has changed. FCnew | FIELDA (shapefile or feature class) FCmaster | FIELDA (feature class in a fgdb) FCnew is periodically being updated by external source - this can have new values or have original values removed. FCmaster is the master table I manage. This consists of the original FCnew values, and will change periodically from the FCnew. What I currently do in arcpy is join a master set of objects to FCnew attributes and then truncate FCmaster and append current records. Now I want to show what has changed as well....ideally saved to a text file. So all I want to do is compare the 2 fields (FIELDA) and print out what values are different. I've had a look at table compare etc... but find it hard to just tell me what values have changed from one field. I was thinking of building dictionaries of each set in arcpy and somehow comparing those lists? Any help would be greatly appreciated. Just put me onto the right course....! Using ArcGIS Desktop 10.6.1 Thanks ... View more