The Information System for Reporting Density of Alcohol Stores Surrounding Educational Institutions in Nakhon Si Thammarat, Thailand
Article Sidebar
Published:
May 4, 2019
Keywords:
Density of Alcohol Stores Geographic Information System Decision Support System
Main Article Content
Abstract
This research aimed (1) to explore the density of alcohol stores surrounding educational institutions in Nakhon Si Thammarat within 2 kilometers of the school, (2) to develop the geographic information system to analyze the density of those alcohol stores, and (3) to evaluate the effectiveness and user perception of the system then improve to meet the needs of users. Two groups of the samples were (1) alcohol stores surrounding 36 educational institutions in Nakhon Si Thammarat within 2 kilometers of the school, and (2) by purposive sampling, 6 persons involved in the arrangement of alcohol distribution zones near schools and 108 general users were collected. The surveys, interviews and questionnair were used for data collected. The system has been developed using web-based technology. Google Map was applied as a tool to collect the spatial information. The percentages (%), the nearest neighbor index (NNI), and the density of the alcohol stores were used to describe the results. In the results, 449 alcohol stores were collected and distributed in the fourth pattern (-1.65 < Z score < -0.55). Start from 1,000 meters, the distance collecting data would reduce the alcohol stores density in lower rank. The research revealed that the system development using web-based technology and integrated information visualization to present as spatial data, charts, and dimension tables was satisfied from users. The overall average for user satisfaction with the system was at a high level
(=4.12, S.D.=0.482). The finding indicated that the integrated information visualization system was satisfied by the users and could be used to improve decision making for monitoring the alcohol stores surrounding school and the new one.
Article Details
How to Cite
จินพล พ., & เจือบุญ ม. (2019). The Information System for Reporting Density of Alcohol Stores Surrounding Educational Institutions in Nakhon Si Thammarat, Thailand. JOURNAL OF SOUTHERN TECHNOLOGY, 12(1), 103–114. Retrieved from https://so04.tci-thaijo.org/index.php/journal_sct/article/view/150950
Section
Research Manuscript
-
Authors must agree to the journal publication rules and allow the editors to edit the manuscripts for publication.
-
Author’s right belongs to the author but Journal of Southern Technology holds the right of first publication and thus allow readers to use the article for the purpose of education but not commercial.
References
Ashe, M., Jernigan, D., Kline, R., Galaz, R. (2003). Land use planning and the control of alcohol, 2003 tobacco,
firearms, and fast food restaurants. American Journal Public Health, 93(9), 1404-1408.
Ayuka, F., Barnett, R., & Pearce, J. (2014). Neighbourhood availability of alcohol outlets and hazardous alcohol
consumption in New Zealand. Health and Place, 29, 186-199.
Babor, T. F., Caetano, R., Casswell, S., Edwards, G., Giesbrecht, N., Graham, K., Rossow, I. (2010). Alcohol: No
Ordinary Commodity: Research and Public Policy (2nd). NY: Oxford University Press.
Campbell, C.A., Hahn, R.A., Elder, R., Brewer, R., Chattopadhyay, S., Fielding, J. (December 2009). The Effectiveness
of Limiting Alcohol Outlet Density as a Means of Reducing Excessive Alcohol Consumption and Alcohol-related
Harms. Am J Prev Med, 37(6), p.556-569 Published by Elsevier Inc. on behalf of American Journal of Preventive
Medicine.
Carlson, T., York, S., & Primomo, J. (2011). The utilization of geographic information systems to create a site selection
strategy to disseminate an older adult fall prevention program. The Social Science Journal, 48, 159-174.
Cen ter for Alcohol Studies. (2015). Density of alcohol stores related with young consumption. Retrieved December 24,
2015, from https://cas.or.th/knowledge/ความหนาแน่นของจุดจำหน่าย [in Thai]
Chaisong, S., Pakdeesettakul, K., & Thamrangsi, T. (2013). Provincial Alcohol Report 2011. Nonthaburi: Center for
Alcohol Studies. [in Thai]
Chen, M. J., Grube, J. W., & Gruenewald, P. J. (2010). Community alcohol outlet density and underage drinking,
Addiction, 105, 270–278.
Ebdon, D. (1985). Statistics in Geography. London: Basil Blackwell.
Evans, B., & Sabel, C. E. (2012). Open-Source web-based geographical information system for health exposure
assessment. International Journal of Health Geographics, 11(2), 1-11.
Excise Department. (2016). Zoning of Prohibited Alcohol Consumption Selling in The Vicinity of Schools. Retrieved
March 22, 2017, from https://www.excise.go.th/cs/groups/ public/documents/document/dwnt/
mjcy/~edisp/uatucm272028.pdf [in Thai]
Gruenewald P.J., Freisthler, B., Remer, L., Lascala, E.A., Treno, A. (2006). Ecological models of alcohol outlets and
violent assaults: crime potentials and geospatial analysis. Addiction, 101, 666-677.
Hay, G. C., Whigham, P. A., Kypri, K., & Langley, J. D. (2009). Neighborhood deprivation and access to alcohol outlets:
A national study. Health and Place, 15, 1086-1093.
Hosiri, T., Sittisun, C., & Limsricharoen, K. (2016). Drinking behavior and its prevalence in grade 10th students. J.
Psychiatr. Assoc. Thailand, 61(1), 3-14. [in Thai]
Jinpon, P., & Jaraeprapal, U. (2015). Geographic Information System Development for Older Adults Health Care. In The
7th Walailak Research National Conference (P. 95). Nakhon Si Thammarat: Walailak University. [in Thai]
Jinpon, P., Songsee, M., Tabaniyom, S., Thenwong, K., & Wuttisak, W. (2017). Integrated information visualization to
support decision making for promotion of older persons’ perceptions toward human rights following the act on
older persons B.E. 2546 in Nakhon Si Thammarat, Thailand. Journal of Southern Technology, 10(1), 175-184.
[in Thai]
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2012, May 23-25). Implementing dashboard decision support
system for subdistrict administration organization network: A case study at Pakpoon subdistrict administration
organisation. In proceeding of the 16th International annual symposium on computational science and engineering
(ANSCSE16) (pp. 187-190). Chiang Mai: Chiang Mai University.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2013, March 20-22). Dashboard decision support system for
community well-being assessment system in Thailand. PRAGMA24 Workshop, Bangkok, Thailand.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2014, September 3-4). Implementing community well-being
assessment system: A case study at Pakpoon subdistrict administration organisation. In The 6th Walailak Research
National Conference (p. 135). Nakhon Si Thammarat: Walailak University.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2016). Integrated information visualization to support decision-
making in order to strengthen communities: Design and usability evaluation. Informatics for Health and Social
Care, 1-14, https://dx.doi.org/10.1080/17538157.2016.1255626.
Kemmis, S., & McTaggart, R. (2000). Participatory Action Research. In N. Denzin & Y. Lincoln (Eds.), Handbook of
Qualitative Research (2nd ed., pp. 567–605).Thousand Oaks, CA: Sage.
Khan, M.E., & Khan, F. (2014). Importance of software testing in software development life cycle. International Journal
of Computer Science, 11(2), 120-123.
Kypri, K., Paschall, M. J., Langley, J. D., Baxter, J., & Bourdeau, B. (2010). The role of drinking locations in university
student drinking: Findings from a national web-based survey. Drug and Alcohol Dependence, 111, 38-43.
Lannen, J.D. (2013). Why SDLC Controls are important for a project. Retrieved June 25, 2017, from
https://www.isaca.org/chapters3/ Atlanta/AboutOurChapter/Documents/
Why%20SDLC%20Controls%20are%20Important%20for%20a%20Project.pdf
Markowitz, S., Chatterji, P., Kaestner, R. (2003). Estimating the impact of alcohol policies on youth suicides. J Ment
Health Policy Econ, 6(1), 37-46.
McCarthy, P. (2005). Alcohol, public policy, and highway crashes: a time-series analysis of older-driver safety. Transp
Econ Policy, 39(1), 109-125.
Norstrom, T. (2000). Outlet density and criminal violence in Norway 1960–1995. Journal Study Alcohol, 61(6), 907-911.
Ponpanatham, P. (2015). Distribution of Alcohol Stores around University in Bangkok and its Vicinity. Nonthaburi:
Center for Alcohol Studies. [in Thai]
Thai Anti Alcohol. (2017). Strategic Plan 5 Years (2017-2021). Department of Disease Control, (p. 188). [in Thai]
. (2014). Act of Service Facility. Retrieved March 22, 2017, from
https://www.thaiantialcohol.com/uploads/files/content/download/ 4fffe7816f60d.pdf [in Thai]
The Secretariat of the House of Representatives. (2016). Command of the Head of the National Peace Corps No.
46/2016. Retrieved March 22, 2017, from https://library2.parliament.go.th/giventake/content_ncpo/ ncpo-head-
order46-2559.pdf [in Thai]
The Excise Department Area at Nakhon Si Thammarat. (2017). Zoning. Retrieved March 22, 2017, from
https://www.excise.go.th/ nakhonsithammarat/PEOPLE/ KNOWLEDGE/KM/index.htm [in Thai]
Thamrangsi, T. (2013). Situation of Alcohol Consumption and Effect in Thailand 2013. Nonthaburi: Center for Alcohol
Studies. [in Thai]
Thaikla, K. (2007). Comparative Study of Density of Liquor Stores within 500 Meters Radius around Educational
Institutions and Drinking Behaviors of Students. Nonthaburi: Center for Alcohol Studies. [in Thai]
Wattanaphorn, K., Naramitpitakkool, P., Jongprasertying, P., Thamrangsi, T., & Center for alcohol studies. (2007).
Provincial Alcohol Report 2007. Nonthaburi: Center for Alcohol Studies. [in Thai]
Witworaphong, N., & Sookrung, K. (2016). Report of Alcohol Consumption Situation in Thailand 2015. Nonthaburi:
Center for Alcohol Studies. [in Thai]
World Health Organization. (2014). Global Status Report on Alcohol and Health 2014. Geneva: WHO Press.
Xie, X., Mann, R. E., & Smart, R.G. (2000.) The direct and indirect relationships between alcohol prevention measures
and alcoholic liver cirrhosis mortality. Journal Study Alcohol, 61(4), 499-506.
Young, R., Macdonald, L., & Ellaway, A. (2013). Associations between proximity and density of local alcohol outlets and
alcohol use among Scottish adolescents. Health and Place, 19, 124-130
firearms, and fast food restaurants. American Journal Public Health, 93(9), 1404-1408.
Ayuka, F., Barnett, R., & Pearce, J. (2014). Neighbourhood availability of alcohol outlets and hazardous alcohol
consumption in New Zealand. Health and Place, 29, 186-199.
Babor, T. F., Caetano, R., Casswell, S., Edwards, G., Giesbrecht, N., Graham, K., Rossow, I. (2010). Alcohol: No
Ordinary Commodity: Research and Public Policy (2nd). NY: Oxford University Press.
Campbell, C.A., Hahn, R.A., Elder, R., Brewer, R., Chattopadhyay, S., Fielding, J. (December 2009). The Effectiveness
of Limiting Alcohol Outlet Density as a Means of Reducing Excessive Alcohol Consumption and Alcohol-related
Harms. Am J Prev Med, 37(6), p.556-569 Published by Elsevier Inc. on behalf of American Journal of Preventive
Medicine.
Carlson, T., York, S., & Primomo, J. (2011). The utilization of geographic information systems to create a site selection
strategy to disseminate an older adult fall prevention program. The Social Science Journal, 48, 159-174.
Cen ter for Alcohol Studies. (2015). Density of alcohol stores related with young consumption. Retrieved December 24,
2015, from https://cas.or.th/knowledge/ความหนาแน่นของจุดจำหน่าย [in Thai]
Chaisong, S., Pakdeesettakul, K., & Thamrangsi, T. (2013). Provincial Alcohol Report 2011. Nonthaburi: Center for
Alcohol Studies. [in Thai]
Chen, M. J., Grube, J. W., & Gruenewald, P. J. (2010). Community alcohol outlet density and underage drinking,
Addiction, 105, 270–278.
Ebdon, D. (1985). Statistics in Geography. London: Basil Blackwell.
Evans, B., & Sabel, C. E. (2012). Open-Source web-based geographical information system for health exposure
assessment. International Journal of Health Geographics, 11(2), 1-11.
Excise Department. (2016). Zoning of Prohibited Alcohol Consumption Selling in The Vicinity of Schools. Retrieved
March 22, 2017, from https://www.excise.go.th/cs/groups/ public/documents/document/dwnt/
mjcy/~edisp/uatucm272028.pdf [in Thai]
Gruenewald P.J., Freisthler, B., Remer, L., Lascala, E.A., Treno, A. (2006). Ecological models of alcohol outlets and
violent assaults: crime potentials and geospatial analysis. Addiction, 101, 666-677.
Hay, G. C., Whigham, P. A., Kypri, K., & Langley, J. D. (2009). Neighborhood deprivation and access to alcohol outlets:
A national study. Health and Place, 15, 1086-1093.
Hosiri, T., Sittisun, C., & Limsricharoen, K. (2016). Drinking behavior and its prevalence in grade 10th students. J.
Psychiatr. Assoc. Thailand, 61(1), 3-14. [in Thai]
Jinpon, P., & Jaraeprapal, U. (2015). Geographic Information System Development for Older Adults Health Care. In The
7th Walailak Research National Conference (P. 95). Nakhon Si Thammarat: Walailak University. [in Thai]
Jinpon, P., Songsee, M., Tabaniyom, S., Thenwong, K., & Wuttisak, W. (2017). Integrated information visualization to
support decision making for promotion of older persons’ perceptions toward human rights following the act on
older persons B.E. 2546 in Nakhon Si Thammarat, Thailand. Journal of Southern Technology, 10(1), 175-184.
[in Thai]
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2012, May 23-25). Implementing dashboard decision support
system for subdistrict administration organization network: A case study at Pakpoon subdistrict administration
organisation. In proceeding of the 16th International annual symposium on computational science and engineering
(ANSCSE16) (pp. 187-190). Chiang Mai: Chiang Mai University.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2013, March 20-22). Dashboard decision support system for
community well-being assessment system in Thailand. PRAGMA24 Workshop, Bangkok, Thailand.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2014, September 3-4). Implementing community well-being
assessment system: A case study at Pakpoon subdistrict administration organisation. In The 6th Walailak Research
National Conference (p. 135). Nakhon Si Thammarat: Walailak University.
Jinpon, P., Jaroensutasinee, M., & Jaroensutasinee, K. (2016). Integrated information visualization to support decision-
making in order to strengthen communities: Design and usability evaluation. Informatics for Health and Social
Care, 1-14, https://dx.doi.org/10.1080/17538157.2016.1255626.
Kemmis, S., & McTaggart, R. (2000). Participatory Action Research. In N. Denzin & Y. Lincoln (Eds.), Handbook of
Qualitative Research (2nd ed., pp. 567–605).Thousand Oaks, CA: Sage.
Khan, M.E., & Khan, F. (2014). Importance of software testing in software development life cycle. International Journal
of Computer Science, 11(2), 120-123.
Kypri, K., Paschall, M. J., Langley, J. D., Baxter, J., & Bourdeau, B. (2010). The role of drinking locations in university
student drinking: Findings from a national web-based survey. Drug and Alcohol Dependence, 111, 38-43.
Lannen, J.D. (2013). Why SDLC Controls are important for a project. Retrieved June 25, 2017, from
https://www.isaca.org/chapters3/ Atlanta/AboutOurChapter/Documents/
Why%20SDLC%20Controls%20are%20Important%20for%20a%20Project.pdf
Markowitz, S., Chatterji, P., Kaestner, R. (2003). Estimating the impact of alcohol policies on youth suicides. J Ment
Health Policy Econ, 6(1), 37-46.
McCarthy, P. (2005). Alcohol, public policy, and highway crashes: a time-series analysis of older-driver safety. Transp
Econ Policy, 39(1), 109-125.
Norstrom, T. (2000). Outlet density and criminal violence in Norway 1960–1995. Journal Study Alcohol, 61(6), 907-911.
Ponpanatham, P. (2015). Distribution of Alcohol Stores around University in Bangkok and its Vicinity. Nonthaburi:
Center for Alcohol Studies. [in Thai]
Thai Anti Alcohol. (2017). Strategic Plan 5 Years (2017-2021). Department of Disease Control, (p. 188). [in Thai]
. (2014). Act of Service Facility. Retrieved March 22, 2017, from
https://www.thaiantialcohol.com/uploads/files/content/download/ 4fffe7816f60d.pdf [in Thai]
The Secretariat of the House of Representatives. (2016). Command of the Head of the National Peace Corps No.
46/2016. Retrieved March 22, 2017, from https://library2.parliament.go.th/giventake/content_ncpo/ ncpo-head-
order46-2559.pdf [in Thai]
The Excise Department Area at Nakhon Si Thammarat. (2017). Zoning. Retrieved March 22, 2017, from
https://www.excise.go.th/ nakhonsithammarat/PEOPLE/ KNOWLEDGE/KM/index.htm [in Thai]
Thamrangsi, T. (2013). Situation of Alcohol Consumption and Effect in Thailand 2013. Nonthaburi: Center for Alcohol
Studies. [in Thai]
Thaikla, K. (2007). Comparative Study of Density of Liquor Stores within 500 Meters Radius around Educational
Institutions and Drinking Behaviors of Students. Nonthaburi: Center for Alcohol Studies. [in Thai]
Wattanaphorn, K., Naramitpitakkool, P., Jongprasertying, P., Thamrangsi, T., & Center for alcohol studies. (2007).
Provincial Alcohol Report 2007. Nonthaburi: Center for Alcohol Studies. [in Thai]
Witworaphong, N., & Sookrung, K. (2016). Report of Alcohol Consumption Situation in Thailand 2015. Nonthaburi:
Center for Alcohol Studies. [in Thai]
World Health Organization. (2014). Global Status Report on Alcohol and Health 2014. Geneva: WHO Press.
Xie, X., Mann, R. E., & Smart, R.G. (2000.) The direct and indirect relationships between alcohol prevention measures
and alcoholic liver cirrhosis mortality. Journal Study Alcohol, 61(4), 499-506.
Young, R., Macdonald, L., & Ellaway, A. (2013). Associations between proximity and density of local alcohol outlets and
alcohol use among Scottish adolescents. Health and Place, 19, 124-130