Skip to main content
  • EN

Hello, any help would be greatly appreciated with this idea I have:

 

I am trying to figure out the least convoluted way to take my current data and get it into the format ArcPro likes it to be in to take full advantage of the Time Slider.

 

My ultimate goal is to use the time slider in arcpro and the user can slide the time to show how a floor was occupied throughout time.

So, I have a large amount of motion detectors. The data is fed to me like so:

SensorName Timestamp SensorStatus
1 12:00 1/1/2024 On
2 12:05 1/1/2024 On
1 12:06 1/1/2024 Off
2 12:10 1/1/2024 Off

Then Sensor 1 could be triggered again and so forth

 

Arc seems to want the start and end times in the same row. like so:

SensorName Start End
1 12:00 1/1/2024 12:06 1/1/2024
2 12:05 1/1/2024 12:10 1/1/2024

 

It needs to organize 100s of results from numerous sensors and get the start/stop times on the same row, for the correct sensor, for the correct period of time. 

This can be done with a Sorter (Sort By SensorName, Timestamp) and an AttributeCreator with Adjacent Feature Processing switched On (To look at next +1 Feature) with Conditional Value that where SensorName[+1] = SensorName then End = Timestamp[+1].  Finally remove the second superfluous row per Sensor with DuplicateFilter

 

or alternatively, Sorter  as above  , + DuplicateFiter by SensorName (To split into start start and stop time) + 2x AttributeRenamer on the two DuplicateFilter ports to rename the first port Timestamp to Start and the the second port to End and join these back together with FeaureJoiner (join by SensorName)

OK, with sample data, something like this, using AttributeCreator Adjacent Feature Processing.

 

 

 

AttributeCreator Parameters

 

 

Start =

​​​​​​

 

End = 

 

 

Input
 


Output
 

 

I think that worked, thank you so much! I will learn more about the adjacent feature attribute option, I had no idea about it!

 

I really appreciate your time/effort/help!

Reply


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.