Missing historic data (22/12/2022 onwards)

Attention: Support team.

It appears the Impala "state_vectors_data4" table has not been updated since the 21st December 2022.

Proof:

select count(*), FROM_unixtime(hour, 'yyyy/MM/dd') as rth_date, 'WINCHESTER-WEST' as area_of_record
FROM state_vectors_data4 where lat between 51.06152 and 51.09048
and lon between -1.366071 and -1.320889
and hour between (extract(epoch from now()) - (3600*24*20)) and (extract(epoch from now()) - (3600*24*0))
group by rth_date order by rth_date desc;

Richard Herson - Founder of  www.AircraftTrafficSurvey.com , a Not-For-Profit organisation serving UK communities.

Thanks for the update.

Richard.

I see that progress is being made and that some data is again being written to the state_vectors_data4 table.

I have felt exposed from not having the data available over the past few weeks as it has allowed the aviation industry to become less accountable for Noise and Emissions.

Thanks all.

Richard Herson - Founder of www.AircraftTrafficSurvey.com , a Not-For-Profit organisation serving UK communities.

Are you still working on restoring the historic data?
I'm looking for data from 09/01/2023 and 10/01/2023 within whole Europe.

That's ok. Just want to know if it is still in progress.

Thank you.