wrridgeway
commented
9 months ago Alright, years before 2010 now work as well:
select
year, env_airport_noise_data_year, count(*) as count
from "z_ci_exploratory-airport-filling-and-joining_location".vw_pin10_location_fill
where env_airport_noise_dnl is not null
group by year, env_airport_noise_data_year
| year | env_airport_noise_data_year | count |
|---|---|---|
| 2023 | omp | 1412712 |
| 2022 | omp | 1413874 |
| 2021 | omp | 1415410 |
| 2020 | 2020 | 1415664 |
| 2019 | 2019 | 1415193 |
| 2018 | 2018 | 1414731 |
| 2017 | 2017 | 1414896 |
| 2016 | 2016 | 1414449 |
| 2015 | 2015 | 1414155 |
| 2014 | 2014 | 1413788 |
| 2013 | 2013 | 1413759 |
| 2012 | 2012 | 1413732 |
| 2011 | 2011 | 1413698 |
| 2010 | 2010 | 1413699 |
| 2009 | 2010 | 1409873 |
| 2008 | 2010 | 1406035 |
| 2007 | 2010 | 1399194 |
| 2006 | 2010 | 1392137 |
| 2005 | 2010 | 1383617 |
| 2004 | 2010 | 1375639 |
| 2003 | 2010 | 1368442 |
| 2002 | 2010 | 1362485 |
| 2001 | 2010 | 1356131 |
| 2000 | 2010 | 1352312 |
The previous solution to the airport noise issue was sufficient for modeling, but lacking as a long-term solution since airport noise wasn't backward filled for years earlier than 2010. That issue is now resolved.