topic Time Sequential Values in Spatial Data Science Questions

Time Sequential Values

AbiRoberts — Wed, 11 Sep 2019 18:36:44 GMT

Hello! I hate to rehash old threads but, despite my research,I am still confused on how to determine the difference between sequential values in rows of the same field. In my case specifically - times in rows of the same field. Would anyone be so kind as to help? I happened across Table_tools_pro by Dan_Patterson, but the sequential calculator only works on numeric fields. Is this something that *should* be able to change easily? Or is there another way?

In this code: https://community.esri.com/thread/215566-sequential-difference-in-a-single-column-with-field-calculator. Curr_val is referencing the field in the expression block (!RasterValu!) correct? Which would be whatever field I am trying to obtain values from? Will this work on a date field?

Should I instead be attempting to use the datetime.timedelta() in the field calculator?

I have seen some threads referencing cursors but I have not yet reached that level of Python 3 #master and I think I am at the point where I know enough to know that I have a long ways to go.

Any help would be greatly appreciated.

Re: Time Sequential Values

DanPatterson_Retired — Wed, 11 Sep 2019 21:05:31 GMT

Abi... what is the exact format of your field? Featureclass in a geodatabase?

There are ways to calculate differences in time values using python

Re: Time Sequential Values

AbiRoberts — Fri, 13 Sep 2019 02:46:11 GMT

Hi Dan! It is a point feature class in a geodatabase. The attribute table for the points contain time stamps, one with a date type and another with text type.

Re: Time Sequential Values

AbiRoberts — Sat, 14 Sep 2019 13:49:00 GMT

I figured it out!

It seems that my problem was not the code for determining the sequential time but the function created to calculate it. It was passed two different data types and it only works if it is passed the text variable before the numeric variable. Also I (may have un-necessarily?) used import datetime from datetime, which appeared to help..