Correct determination of max `env_airport_noise_data_year` in `location.crosswalk_year_fill`

ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management

https://ccao-data.github.io/data-architecture/

5 stars 3 forks source link

Correct determination of max `env_airport_noise_data_year` in `location.crosswalk_year_fill` #284

Closed wrridgeway closed 6 months ago

wrridgeway commented 6 months ago

SQL is returning 'omp' as our max data year for env_airport_noise in our location data crosswalk. We need to exclude this value when searching for a maximum data year.