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
相关论文
共 50 条
  • [1] An Approach for Generating SQL Query Using Natural Language Processing
    More, Priyanka
    Kudale, Bharti
    Deshmukh, Pranali
    Biswas, Indira N.
    More, Neha J.
    Gomes, Francisco S.
    INTELLIGENT COMMUNICATION TECHNOLOGIES AND VIRTUAL MOBILE NETWORKS, ICICV 2019, 2020, 33 : 226 - 230
  • [2] Natural Language Query to SQL conversion using Machine Learning Approach
    Arefin, Minhazul
    Hossen, Kazi Mojammel
    Uddin, Mohammed Nasir
    2021 3RD INTERNATIONAL CONFERENCE ON SUSTAINABLE TECHNOLOGIES FOR INDUSTRY 4.0 (STI), 2021,
  • [3] Human Language Question To SQL Query Using Deep Learning
    Ahkouk, Karam
    Machkour, Mustapha
    2019 THIRD INTERNATIONAL CONFERENCE ON INTELLIGENT COMPUTING IN DATA SCIENCES (ICDS 2019), 2019,
  • [4] Formation of SQL from Natural Language Query using NLP
    Uma, M.
    Sneha, V
    Sneha, G.
    Bhuvana, J.
    Bharathi, B.
    2019 SECOND INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE IN DATA SCIENCE (ICCIDS 2019), 2019,
  • [5] Blended Learning for Improving Flexibility of Learning Structure Query Language (SQL)
    Lertnattee, Verayuth
    Pamonsinlapatham, Perayot
    BLENDED LEARNING: NEW CHALLENGES AND INNOVATIVE PRACTICES, ICBL 2017, 2017, 10309 : 343 - 353
  • [6] Translating Controlled Natural Language Query into SQL Query using Pattern Matching Technique
    Kumar, Rajender
    Dua, Mohit
    2014 INTERNATIONAL CONFERENCE FOR CONVERGENCE OF TECHNOLOGY (I2CT), 2014,
  • [7] Grid global structure query language G2SQL
    Xie, Z.
    Chen, Z. L.
    Wu, L.
    Tian, G.
    2008 PROCEEDINGS OF INFORMATION TECHNOLOGY AND ENVIRONMENTAL SYSTEM SCIENCES: ITESS 2008, VOL 2, 2008, : 847 - 852
  • [8] Research on natural language query to SQL method with fused table structure
    Liu, Chuanlong
    Liao, Wei
    Xu, Zhen
    2024 5TH INTERNATIONAL CONFERENCE ON COMPUTER ENGINEERING AND APPLICATION, ICCEA 2024, 2024, : 564 - 567
  • [9] PSS-SQL: Protein Secondary Structure - Structured Query Language
    Mrozek, Dariusz
    Wieczorek, Dominika
    Malysiak-Mrozek, Bozena
    Kozielski, Stanislaw
    2010 ANNUAL INTERNATIONAL CONFERENCE OF THE IEEE ENGINEERING IN MEDICINE AND BIOLOGY SOCIETY (EMBC), 2010, : 1073 - 1076
  • [10] Enhancement of Natural Language to SQL Query Conversion using Machine Learning Techniques
    Prasad, Akshar
    Badhya, Sourabh S.
    Yashwanth, Y. S.
    Rohan, Shetty
    Shobha, G.
    Deepamala, N.
    INTERNATIONAL JOURNAL OF ADVANCED COMPUTER SCIENCE AND APPLICATIONS, 2020, 11 (12) : 494 - 503