Portraying the Water Crisis in Iranian Newspapers: An Approach Using Structure Query Language (SQL)

被引:11
|
作者
Amiraslani, Farshad [1 ]
Dragovich, Deirdre [2 ]
机构
[1] Ulster Univ, Fac Life & Hlth Sci, Sch Geog & Environm Sci, Coleraine BT52 1SA, Londonderry, North Ireland
[2] Univ Sydney, Sch Geosci, Sydney, NSW 2006, Australia
关键词
water; newspapers; Iran; SQL; RIVER-BASIN; MANAGEMENT; COVERAGE; ISSUES; MEDIA; SYSTEM; NEWS;
D O I
10.3390/w13060838
中图分类号
X [环境科学、安全科学];
学科分类号
08 ; 0830 ;
摘要
Water is a valuable resource for which demand often exceeds supply in dry climates. Managing limited water resources becomes increasingly difficult in circumstances of recurring drought, rising populations, rapid urbanisation, industrial development, and financial constraints, such as occur in Iran. Newspapers both report on and influence people's understanding of water-related issues. An analysis was undertaken of two major Iranian daily newspapers over a 7-year period. Structure Query Language (SQL) was employed to identify relationships among a total of 1275 records/fields which were extracted from 84 water-related news items. They were analysed for message, contributor, spatiality and allocated space. Of the water-related items, wetlands comprised 33% (class), public awareness 54% (message), local level 56% (spatiality), and authorities 53% (contributor). Space allocation on each page was mostly <40% (94% of items). Four examples were highlighted of ambitious engineering projects adopted in response to water distribution issues. It is concluded that the general lack of educating messages about water use efficiency in rural areas and water consumption in cities does not assist in developing positive water-saving local behaviours. Newspapers could be a useful tool in a broader strategy for addressing and managing the demand side of the water crisis in Iran.
引用
收藏
页数:13
相关论文
共 6 条
  • [1] Analysis of the optimization of SQL statements of the Structured Query Language using large volumes of data
    Vicuna Pino, Ariosto Eugenio
    Ponce Ordonez, Jessica Alexandra
    Erazo Moreta, Orlando Ramiro
    REVISTA PUBLICANDO, 2018, 5 (16): : 70 - 79
  • [2] Enhancing Faculty Grading Productivity Using Robotic Process Automation (RPA): The Development of a Structured Query Language (SQL) Automated Grading Tool
    Coyne, Joshua G.
    Summers, Scott L.
    Wood, David A.
    ISSUES IN ACCOUNTING EDUCATION, 2024, 39 (04): : 55 - 68
  • [3] An Exploration of a Socio-Cultural Approach Using Significant Variables of Pattern Language Amongst Iranian Experts of Environmental Design
    Khakzand, Mehdi
    JOURNAL OF ASIAN ARCHITECTURE AND BUILDING ENGINEERING, 2014, 13 (02) : 295 - 302
  • [4] Minimum Cost Design of Hydraulic Water Retaining Structure by using Coupled Simulation Optimization Approach
    Al-Juboori, Muqdad
    Datta, Bithin
    KSCE JOURNAL OF CIVIL ENGINEERING, 2019, 23 (03) : 1095 - 1107
  • [5] Evaluating a novel tiered scarcity adjusted water budget and pricing structure using a holistic systems modelling approach
    Sahin, Oz
    Bertone, Edoardo
    Beal, Cara
    Stewart, Rodney A.
    JOURNAL OF ENVIRONMENTAL MANAGEMENT, 2018, 215 : 79 - 90
  • [6] MODELING SOCIO-ECOLOGICAL STRUCTURE OF LOCAL COMMUNITIES PARTICIPATION FOR MANAGING LIVESTOCK DRINKING WATER USING THE AGENT-BASED APPROACH
    Islami, I.
    Sadoddin, A.
    Barani, H.
    Asgharpourmasouleh, A.
    Akhbari, M.
    APPLIED ECOLOGY AND ENVIRONMENTAL RESEARCH, 2017, 15 (03): : 1173 - 1192