• Title/Summary/Keyword: Spatial database

Search Result 1,133, Processing Time 0.023 seconds

Producing Firefighting Vulnerability Maps Using GIS - A Case Study of Dalseo-gu, Daegu - (GIS를 이용한 화재진압 취약성 지도 제작 - 대구광역시 달서구를 사례로 -)

  • KIM, Sung-Jae;CHOI, Gap-Yong;CHANG, Eun-Mi;SONG, Wan-Young
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.18 no.3
    • /
    • pp.11-20
    • /
    • 2015
  • Fire incidents, which occur every year, cause huge damage to properties and humans. Significant time and costs have been invested in minimizing and responding to such accidents. With the recent advances in the development of spatial information, in the firefighting field, studies have been conducted to effectively bring fires under control using GIS(Geographic Information System). Most of such studies, however, focused on individual analyses of firefighting-related factors, but comprehensive research on the vulnerability factors in fire control activities, a major part of firefighting activity, has yet to be done. This study sought to pinpoint and analyze the factors that obstruct fire controlling, and to gather relevant data and create GIS-based databases. Based on such database, GIS-based overlay analysis was conducted to produce a fire control vulnerability map. The findings of this study will enable a quantitative analysis of firefighting obstruction factors to assist the personnel engaging in firefighting in rational decision-making, such as in formulating a firefighting operation plan for securing golden time.

Analysis and Prediction for Spatial Distribution of Functional Feeding Groups of Aquatic Insects in the Geum River (금강 수계 수서곤충 섭식기능군의 공간분포 분석 및 예측)

  • Kim, Ki-Dong;Park, Young-Jun;Nam, Sang-Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.15 no.1
    • /
    • pp.99-118
    • /
    • 2012
  • The aim of this study is to define a correlation between spatial distribution characteristics of FFG(Functional Feeding Groups) of aquatic insects and related environmental factors in the Geum River based on the theory of RCC(River Continuum Concept). For that objective we had used SMRA(Stepwise Multiple Regression Analysis) method to analyze close relationship between the distribution of aquatic insects and the physical and chemical factors that may affect their inhabiting environment in the study area. And then, a probabilistic method named Frequency Ratio Model(FRM) and spatial analysis function of GIS were applied to produce a predictive distribution map of biota community considering their distribution characteristics according to the environmental factors as related variables. As a result of SMRA, the values of decision coefficient for factors of elevation, stream width, flow velocity, conductivity, temperature and percentage of sand showed higher than 0.5. Therefore these 6 environmental factors were considered as major factors that might affect the distribution characteristics of aquatic insects. Finally, we had calculated RMSE(Root Mean Square Error) between the predicted distribution map and prior survey database from other researches to verify the result of this study. The values of RMSE were calculated from 0.1892 to 0.4242 according to each FFG so we could find out a high reliability of this study. The results of this study might be used to develop a new estimation method for aquatic ecosystem with macro invertebrate community and also be used as preliminary data for conservation and restoration of stream habitats.

Linkage Base of Geo-based Processing Service and Open PaaS Cloud (오픈소스 PaaS 클라우드와 공간정보 처리서비스 연계 기초)

  • KIM, Kwang-Seob;LEE, KI-Won
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.20 no.4
    • /
    • pp.24-38
    • /
    • 2017
  • The awareness and demand for technological elements in the field of cloud computing and their application models have increased. Cloud-based service information systems are being expanded for use in many applications. Advancements in information technology are directly related to spatial information. PaaS is an important platform for implementing a substantial cloud ecosystem to develop geo-based application services. For this reason, it is necessary to analyze the PaaS cloud technology prior to the development of SaaS. The PaaS cloud supports sharing of related extensions, database operations and management, and application development and deployment. The development of geo-spatial information systems or services based on PaaS in ranging the domestic and overseas range is in the initial stages of both research and application. In this study, state-of-the-art cloud computing is reviewed and a conceptual design for geo-based applications is presented. The proposed model is based on container methods, which are the core elements of PaaS cloud technology based on open source. It is thought that these technologies contribute to the applicability and scalability of the geo-spatial information industry that addresses cloud computing. It is expected that the results of this study will provide a technological base for practical service implementation and experimentation for geo-based applications.

Development of Biotope area ratio Estimation Model using GIS (GIS를 활용한 생태면적률 산정 모델 개발)

  • Lee, Ji-Soo;Lee, Seung-Wook;Lee, Seung-Yeob;Hong, Won-Hwa
    • Spatial Information Research
    • /
    • v.19 no.2
    • /
    • pp.9-18
    • /
    • 2011
  • The purpose of this research is to evaluate an accurate biotope area ratio model with efficiency and convenience of database management through promoting sustainable development to provide people amenities in a new town. In particular, the biotope area ratio is used not only in the environment impact assessment but Green building certification criteria. But now there is no any index map of biotope. So it is very hard to implement with data for supplement results. In this research, we suggest the model of integrated attributable information. The evaluation of biotope area ratio is to include a basic land use planning map and a building coverage area which is a wall of greening surface and roof. In case of non building coverage area, the evaluation of biotope area ratio is to include water space, artificial ground, natural ground and pervious gap-pave. A weighted value on the spatial information is combined into the information. And then the merged one is given a land use planning information in a block. In the weighted value on the space type information, it is possible to in its circumstances. Therefore, it can be substituted a correspondence of numerical change for various values elastically in this model.

Spatial OLAP Implementation for GIS Decision-Making - With emphasis on Urban Planning - (GIS 의사결정을 지원하기 위한 Spatial OLAP 구현 - 도시계획을 중심으로 -)

  • Kyung, Min-Ju;Yom, Jae-Hong
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.27 no.6
    • /
    • pp.689-698
    • /
    • 2009
  • SOLAP system integrates and complements the functions of both OLAP and GIS systems. This enables users not only to easily access geospatial data but also to analyze and extract information for decision making. In this study a SOLAP system was designed and implemented to provide urban planners with GIS information when making urban planning decisions. Rapid urbanization in Korea has brought about ill-balanced urban structure as the result of development without detailed analysis of urban plans. Systematic urban planning procedures and automated systems are crucial for detail analysis of future development plans. Data regarding the development regulations and current status of land use need to be assessed precisely and instantly. Multi-dimensional aspects of a suggested plan must be formulated instantly and examined thoroughly using 'what if' scenarios to come up with a best possible plan. The SOLAP system presented in this study designed the dimension tables and the fact tables for supplying timely geospatial information to the planners when making decisions regarding urban planning. The database was implemented using open source DBMS and was populated with necessary attribute data which was freely available from the Statistics Korea bureau homepage. It is anticipated the SOLAP system presented in this study will contribute to better urban planning decisions in Korea through more timely and accurate provision of geospatial information.

A GIS-Based Seismic Vulnerability Mapping and Assessment Using AHP: A Case Study of Gyeongju, Korea (GIS 기반 AHP를 이용한 지진 취약성 지도제작 및 평가: 경주시를 중심으로)

  • Han, Jihye;Kim, Jinsoo
    • Korean Journal of Remote Sensing
    • /
    • v.35 no.2
    • /
    • pp.217-228
    • /
    • 2019
  • In this study, a seismic vulnerability map of Gyeongju city, where the 9.12 Gyeongju earthquake occurred, was produced and evaluated using analytic hierarchy process(AHP) and geographic information system (GIS). Geotechnical, physical, social, structural, and capacity factors were selected as the main indicators and 18 sub-indicators to construct a spatial database. Weights derived using the AHP were applied to the 18 sub-indicators, which generated a vulnerability map of the five main indicators. After weighting the five generated maps, we created seismic vulnerability maps by overlaying each of the five maps. The seismic vulnerability map was classified into five zones, i.e., very high, high, moderate, low, and safe. For seismic vulnerability, the results indicated that 3% of Gyeongju area is characterized as having very high vulnerability, while 19% was characterized as safe. Based on district standards, Jungbu-dong, Hwangoh-dong, Hwangseong-dong, Seonggeon-dong, and Dongcheon-dong were high-risk areas, and Bodeok-dong, Gangdong-myeon, Yangbuk-myeon, Yangnam-myeon, and Oedong-eup were characterized as safe areas. The seismic vulnerability map produced in this study could possibly be used to minimize damage caused by earthquakes and could be used as a reference when establishing policies.

Long-term distribution trend analysis of largemouth bass (Micropterus salmoides), based on National Fish Database, and the ecological risk assessments (전국자연환경조사 자료를 이용한 배스(Micropterus salmoides) 시공간 분포 분석 및 생태위해성 평가)

  • Kim, Jeong Eun;An, Kwang-Guk
    • Korean Journal of Environmental Biology
    • /
    • v.39 no.2
    • /
    • pp.207-217
    • /
    • 2021
  • Using the data from the national survey of fish, we determined the population size and the distribution of Micropterus salmoides, which is a translocated species into the aquatic ecosystem of Korea. . The spatial concentration of this species was determined by performing an optimized hot spot analysis. After determining potential invasiveness and risk assessment, we measured the disturbance of biodiversity in the aquatic ecosystem. The result of distribution analysis indicates that the population of M. salmoides was concentrated in the major basins of Han river, Geum river, Nakdong river, and Yeongsan-Seomjin river, including the Jeju island. In particular, Nakdong river basin showed the highest appearance rate. On the contrary, Yeongsan-Seomjin river basin showed the lowest appearance rate. The Nakdong river and the Nakdong river basin were the areas with the high spatial concentration of M. salmoides. On the other hand, only Han river basin and Geum river basin had the lowest spatial concentration. The fish invasiveness screening kit(FISK) was used to assess M. salmoides, which inhabited a broad region of aquatic ecosystem: the assessment score was 31.0, indicating its 'highly invasive' nature. Our study aims to encourage research that improves the biodiversity and the conservation of M. salmoides in a priority area.

Spatial Assessment of Climate Suitability for Summer Cultivation of Potato in North Korea (기후적합도 모형을 활용한 북한지역 내 감자의 여름재배 적지 탐색)

  • Kang, Minju;Hyun, Shinwoo;Kim, Kwang Soo
    • Korean Journal of Agricultural and Forest Meteorology
    • /
    • v.24 no.1
    • /
    • pp.35-47
    • /
    • 2022
  • Expansion of potato production areas can improve the food security in North Korea because the given crop has less requirements for agricultural materials and facilities. The Global Agro-Ecological Zones (GAEZ) model, which was developed to evaluate climate suitability under different cultivation conditions, was used to identify potential areas for the potato production. The spatial estimates of crop suitability under low and high input management conditions were downloaded from the GAEZ data portal. The values of suitability were obtained at the potato occurrence sites retrieved from the Global Biodiversity Information Facility (GBIF) database. The suitable areas for the potato production were identified using a threshold value derived from the suitability estimates at the occurrence sites. It was found that 90% of the occurrence sites had the suitability index value >3,333, which was set to be the threshold value. The suitable areas in North Korea were summarized by province and county. Rice cultivation areas were excluded from the analysis. The reported relative acreage of potato production was better represented by the suitable areas under the low input management options than the high input conditions. The suitable areas also had a similar distribution to the reported acreage of potato production by county. These results indicated that the GAEZ model would be useful to identify the candidate production areas, which would facilitate the increases in potato production especially under future climate conditions. Furthermore, monthly maps of crop suitability can be used to design cropping systems that would improve crop production under the limited use of agricultural materials and facilities.

Spatial modeling of mortality from acute lower respiratory infections in children under 5 years of age in 2000-2017: a global study

  • Almasi, Ali;Reshadat, Sohyla;Zangeneh, Alireza;Khezeli, Mehdi;Teimouri, Raziyeh;Naderi, Samira Rahimi;Saeidi, Shahram
    • Clinical and Experimental Pediatrics
    • /
    • v.64 no.12
    • /
    • pp.632-641
    • /
    • 2021
  • Background: Over the past few decades, various goals have been defined to reduce the mortality of children caused by acute lower respiratory infections (ALRIs) worldwide. However, few spatial studies to date have reported on ALRI deaths. Purpose: We aimed to assess the spatial modeling of mortality from ALRI in children under 5 years of age during 2000-2017 using a global data. Methods: The data on the mortality of children under 5 years old caused by ALRI were initially obtained from the official website of the World Health Organization. The income status of their home countries was also gathered from the Country Income Groups (World Bank Classification) website and divided into 5 categories. After that, in the ArcGIS 10.6 environment, a database was created and the statistical tests and related maps were extracted. The Global Moran's I statistic, Getis-Ord Gi statistic, and geographically weighted regression were used for the analyses. In this study, higher z scores indicated the hot spots, while lower z scores indicated the cold spots. Results: In 2000-2017, child mortality showed a downward trend from 17.6 per 100,000 children to 8.1 and had a clustered pattern. Hot spots were concentrated in Asia in 2000 but shifted toward African countries by 2017. A cold spot that formed in Europe in 2007 showed an ascending trend by 2017. Based on the results of geographically weighted regression test, the regions identified as the hot spots of mortality from ALRI in children under 5 years old were among the middle-income countries (R2=0.01, adjusted R2=8.77). Conclusion: While the total number of child deaths in 2000-2017 has decreased, the number of hot spots has increased among countries. This study also concluded that, during the study period, Central and Western Africa countries became the main new hot spots of deaths from ALRI.

A Spatio-Temporal Clustering Technique for the Moving Object Path Search (이동 객체 경로 탐색을 위한 시공간 클러스터링 기법)

  • Lee, Ki-Young;Kang, Hong-Koo;Yun, Jae-Kwan;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.7 no.3 s.15
    • /
    • pp.67-81
    • /
    • 2005
  • Recently, the interest and research on the development of new application services such as the Location Based Service and Telemetics providing the emergency service, neighbor information search, and route search according to the development of the Geographic Information System have been increasing. User's search in the spatio-temporal database which is used in the field of Location Based Service or Telemetics usually fixes the current time on the time axis and queries the spatial and aspatial attributes. Thus, if the range of query on the time axis is extensive, it is difficult to efficiently deal with the search operation. For solving this problem, the snapshot, a method to summarize the location data of moving objects, was introduced. However, if the range to store data is wide, more space for storing data is required. And, the snapshot is created even for unnecessary space that is not frequently used for search. Thus, non storage space and memory are generally used in the snapshot method. Therefore, in this paper, we suggests the Hash-based Spatio-Temporal Clustering Algorithm(H-STCA) that extends the two-dimensional spatial hash algorithm used for the spatial clustering in the past to the three-dimensional spatial hash algorithm for overcoming the disadvantages of the snapshot method. And, this paper also suggests the knowledge extraction algorithm to extract the knowledge for the path search of moving objects from the past location data based on the suggested H-STCA algorithm. Moreover, as the results of the performance evaluation, the snapshot clustering method using H-STCA, in the search time, storage structure construction time, optimal path search time, related to the huge amount of moving object data demonstrated the higher performance than the spatio-temporal index methods and the original snapshot method. Especially, for the snapshot clustering method using H-STCA, the more the number of moving objects was increased, the more the performance was improved, as compared to the existing spatio-temporal index methods and the original snapshot method.

  • PDF