Noise Exposure Data - Round 3
Department for Environment, Food and Rural Affairs
@ukgov.noise_exposure_data_round_3
Department for Environment, Food and Rural Affairs
@ukgov.noise_exposure_data_round_3
The file contains information about the estimated number of people in England exposed to road traffic, railway and industrial noise. These data come from the strategic noise mapping undertaken in 2017 to meet the requirements of the Environmental Noise Directive (Directive 2002/49/EC) (END) and the Environmental Noise (England) Regulations 2006 (as amended) (Regs).
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2022-07-01T04:01:38Z
CREATE TABLE noise_exposure_data_england_round_3 (
"location_agglomeration" VARCHAR,
"road_pop_lden_55db" BIGINT -- Road Pop Lden>=55dB,
"road_pop_lden_60db" BIGINT -- Road Pop Lden>=60dB,
"road_pop_lden_65db" BIGINT -- Road Pop Lden>=65dB,
"road_pop_lden_70db" BIGINT -- Road Pop Lden>=70dB,
"road_pop_lden_75db" BIGINT -- Road Pop Lden>=75dB,
"road_pop_lnight_50db" BIGINT -- Road Pop Lnight>=50dB,
"road_pop_lnight_55db" BIGINT -- Road Pop Lnight>=55dB,
"road_pop_lnight_60db" BIGINT -- Road Pop Lnight>=60dB,
"road_pop_lnight_65db" BIGINT -- Road Pop Lnight>=65dB,
"road_pop_lnight_70db" BIGINT -- Road Pop Lnight>=70dB,
"railways_pop_lden_55db" BIGINT -- Railways Pop Lden>=55dB,
"railways_pop_lden_60db" BIGINT -- Railways Pop Lden>=60dB,
"railways_pop_lden_65db" BIGINT -- Railways Pop Lden>=65dB,
"railways_pop_lden_70db" BIGINT -- Railways Pop Lden>=70dB,
"railways_pop_lden_75db" BIGINT -- Railways Pop Lden>=75dB,
"railways_pop_lnight_50db" BIGINT -- Railways Pop Lnight>=50dB,
"railways_pop_lnight_55db" BIGINT -- Railways Pop Lnight>=55dB,
"railways_pop_lnight_60db" BIGINT -- Railways Pop Lnight>=60dB,
"railways_pop_lnight_65db" BIGINT -- Railways Pop Lnight>=65dB,
"railways_pop_lnight_70db" BIGINT -- Railways Pop Lnight>=70dB,
"industry_pop_lden_55db" VARCHAR -- Industry Pop Lden>=55dB,
"industry_pop_lden_60db" VARCHAR -- Industry Pop Lden>=60dB,
"industry_pop_lden_65db" VARCHAR -- Industry Pop Lden>=65dB,
"industry_pop_lden_70db" VARCHAR -- Industry Pop Lden>=70dB,
"industry_pop_lden_75db" VARCHAR -- Industry Pop Lden>=75dB,
"industry_pop_lnight_50db" VARCHAR -- Industry Pop Lnight>=50dB,
"industry_pop_lnight_55db" VARCHAR -- Industry Pop Lnight>=55dB,
"industry_pop_lnight_60db" VARCHAR -- Industry Pop Lnight>=60dB,
"industry_pop_lnight_65db" VARCHAR -- Industry Pop Lnight>=65dB,
"industry_pop_lnight_70db" VARCHAR -- Industry Pop Lnight>=70dB,
"agglomerationpopulation" VARCHAR
);Anyone who has the link will be able to view this.