In running queries on a geofenced location in the San Francisco Bay Area around airport KHAF, in the table state_vectors_data4, I'm having trouble interpreting the data.
I get long runs of state_vectors with increasing times for any given aircraft (icao24), where the rest of the data - lon, lat, velocity, etc. are identical. The timestamps from the start of the runs to the ends can be 5 minutes or more. Then there are occasional "skips" of as much as 30 minutes before the next record, while the aircraft has apparently moved only a few hundred feet or so.
For example, here's a run starting at 1641094994 and ending at 1641095296 for ade9b8. I believe this is a span of 302 seconds?
Of course the plane wasn't standing still, so I must misunderstand the data in some way. Any help would be appreciated!
PS - The actual query that produced this data is:
select * from state_vectors_data4 where hour>=1641024000 and hour<1641542400 and lat>=37.45 and lat<=37.55 and lon<=-122.43 and lon>=-122.53 and baroaltitude<=300 order by icao24,time;