• Title/Summary/Keyword: PostGIS

Search Result 130, Processing Time 0.031 seconds

3D Object Modeling for Laser Radar Simulation (레이저레이더 시뮬레이션을 위한 3차원 객체 모델링)

  • Kim, Geun-Han;Jun, Chul-Min
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.16 no.2
    • /
    • pp.57-65
    • /
    • 2008
  • The improvement of the performance in laser radar simulation requires fast retrievals of the spatial locations and attributes of objects in response to the laser signals of the simulators. Since the data used in simulation are complex 3D objects such as terrain, buildings and vehicles, and are of large sizes, commonly used 3D modeling tools are not suitable for this use. We proposed a method to store such 3D objects in a database, perform required queries and integrate with visualization tools. We showed the processes for the data modeling based on 3D topological concepts and then building a spatial DBMS. Also, we illustrated the process for accessing and visualizing the stored data using VRML and performed test computations using some laser signal data. With further enhancement on data modeling and LOD problems in visualization, the proposed method will be practically applied in different situations including laser simulation.

  • PDF

An Environmental Impact Assessment System for Microscale Winds Based on a Computational Fluid Dynamics Model (전산유체역학모형에 근거한 미기상 바람환경 영향평가 시스템)

  • Kim, Kyu Rang;Koo, Hae Jung;Kwon, Tae Heon;Choi, Young-Jean
    • Journal of Environmental Impact Assessment
    • /
    • v.20 no.3
    • /
    • pp.337-348
    • /
    • 2011
  • Urban environmental problem became one of major issues during its urbanization processes. Environmental impacts are assessed during recent urban planning and development. Though the environmental impact assessment considers meteorological impact as a minor component, changes in wind environment during development can largely affect the distribution pattern of air temperature, humidity, and pollutants. Impact assessment of local wind is, therefore, a major element for impact assessment prior to any other meteorological impact assessment. Computational Fluid Dynamics (CFD) models are utilized in various fields such as in wind field assessment during a construction of a new building and in post analysis of a fire event over a mountain. CFD models require specially formatted input data and produce specific output files, which can be analyzed using special programs. CFD's huge requirement in computing power is another hurdle in practical use. In this study, a CFD model and related software processors were automated and integrated as a microscale wind environmental impact assessment system. A supercomputer system was used to reduce the running hours of the model. Input data processor ingests development plans in CAD or GIS formatted files and produces input data files for the CFD model. Output data processor produces various analytical graphs upon user requests. The system was used in assessing the impacts of a new building near an observatory on wind fields and showed the changes by the construction visually and quantitatively. The microscale wind assessment system will evolve, of course, incorporating new improvement of the models and processors. Nevertheless the framework suggested here can be utilized as a basic system for the assessment.

Development and implementation of smart pipe network operating platform focused on water quality management (스마트 상수관망 수질관리 운영플랫폼 개발과 적용)

  • Dae Hee Park;Ju Hwan Kim
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2023.05a
    • /
    • pp.453-453
    • /
    • 2023
  • 상수관망의 수질사고와 이상상황 발생시 대응을 위해서는 급수구역에 설치되어 있는 자동수질측정기, 정밀여과장치, 재염소주입설비, 자동드레인 등의 계측·제어설비들 간의 유기적인 정보공유를 통한 제어를 필요로 한다. 스마트 상수관망 운영플랫폼은 이러한 인프라 시설의 운영방안을 고려하여 분산되어 있는 계측데이터를 통합감시 및 제어하는 시스템으로 개발되었다. 상수관망 운영플랫폼은 능동형 분석 제어기술을 도입하여, 스마트 상수관망 인프라 설비를 최적제어할 수 있도록 구현하였다. 통합운영 플랫폼은 PostgreSQL, PostGIS, GeoServer, OpenLayers 등의 기술을 활용하여 개발하였다. 플랫폼은 계측감시, 시설관리, 운영제어 등의 기능으로 구성되며, 상수도 업무지원을 위한 관망해석 및 네트워크 분석 기능을 지원한다. 본 시스템은 스마트 상수도 구축사업을 통해 구축한 유량·수질모니터링 장비와 수질관리를 위해 도입된 재염소, 자동드레인 설비의 운영상태를 실시간 조회하는 모니터링 프로그램과, 관망해석 프로그램 그리고 대상설비의 최적제어를 위한 운영관리 프로그램으로 구성되어 있다. 모니터링 프로그램은 현장에서 측정되고 있는 유량, 수압, 수질, 펌프운전 등의 상태를 실시간으로 감시하고 클라우드 데이터베이스에 저장·관리하는 기능을 수행한다. 관망해석 프로그램은 EPA_Net모형과 연계되어 관망수리·수질해석을 수행하는 부분으로 재염소설비의 염소 추가주입이나 자동드레인을 통한 배제시 나타나게되는 관의 수리·수질변화를 클라우드 컴퓨팅 환경에서 분석하고 결과를 가시화 하는 기능을 갖고 있다. 운영관리 프로그램은 재염소 주입이 필요할 경우 주입량의 산정하는 부분과 관망 파손이나 수질사고 발생시 최적 단수예상지역을 도출하는 기능을 보유하고 있다. 향후 스마트 상수관망의 능동형 수질관리를 추진하는 지자체에 도입하여 인프라운영관리 기술 확보 및 수질관리 능력 개선과 실시간 감시 및 위기 대응능력 향상에 기여할 것으로 기대된다.

  • PDF

Establishment and Application of Landscape Control Point Selection Method for Landscape Assessment of Urban Development Projects (도시개발사업의 경관평가를 위한 조망점 선정체계 구축 및 적용)

  • Jang, Cheol-Kyu;Jung, Sung-Gwan;Kim, Kyung-Tae
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.39 no.3
    • /
    • pp.39-50
    • /
    • 2011
  • This study furnishes basis data for plan foundation and proper valuation of view by presenting objective and concrete selection standards and ways of Landscape Control Point(LCP) on valuation of development projects. To sum up the results of study, it establishes the prospect, publicity and direction of view as a selection standard LCP on precedent studies. The prospect, which includes visual range, direction of view, geographical features, and visibility, sets up as a valuation basis picking out the available places which have alterations according to direction and distance in practice. In the case of publicity, to select the place as there presentative area where public activities often happen than others, thirteen evaluation indexes including administration facilities, educational facilities, commercial facilities and so on. And variation of landscape is set up as an assessment index to know how much the land has changed from the beginning to the end of development. To apply the selection standards to sample places, the preliminary LCP is founded by analyzing both the prospect and published; a series of courses for selecting the final LCP is founded by analyzing the preliminary LCP and variableness of landscape on a basic of placed which have many alterations of view. At last, in the case of a selection system for LCP, the preliminary LCP is founded by analyzing both the prospect and publicity; a series of courses for selecting the final LCP is found by analyzing the preliminary LCP and variableness of landscape. Applying selection standards and the assessment index to the Sam-deok 3 residence improvement area, in the case of prospect, the southern distant view area has the largest extent. Next, the results of the assessment using the system of publicity show that a five-lane road is taking up the largest area. Hence, a total of 48 preliminary LCPs are set up by analyzing both the prospect and publicity. The results of analyzing landscape variation, one of the valuation indexes, show that Sam-deok dong around the post office has the highest rate of variation at 28.07%. Finally, three LCPs in each part, which are close range, middle range and distance view, are selected; thus, a total of nine LCPs are selected. The selected LCPs that go through a series of practical courses like a GIS program have a lot of professional opinions and are expected to secure objectivity of landscape assessment.

The Analysis of the Influential Factors on Design Trends and Color Trends in the Late 20th Century (20세기 후반 디자인 트렌드의 형성요인과 색채 트렌드 분석)

  • Kim, Hyun-Kyung;Kim, Young-In
    • Archives of design research
    • /
    • v.20 no.1 s.69
    • /
    • pp.5-20
    • /
    • 2007
  • The aim of this research is to find out the flows of mega-trends and design trends by analyzing the factors that influence trend and design trends in the late 20th century. Moreover, it is to forecast and recommend design color trends by evaluating color trends in design trends for the near future. Secondary and primary research were used in parallel. In the late 20th century, mega-trends were analyzed from secondary research based on PEST. Design trends were analyzed from case studies in fashion, space, product and visual design. On this basis, design color trends were analyzed. Also, color trends were forecast for the near future. The results are as follows. Firstly, the main trends in the late 20th century were 'female thinking', 'back to the nature' and 'heaven of peace'. Second, main design trends in the 1970s were modernism, post-modernism and high-tech. In the 1980s, with those of the 1970s, ecology was introduced In the late 1980s. In the 1990s, modernism rose again and ecology had an influence. The trends of 'female thinking' and 'back to the nature' controled the design in the early 2000s. Third, design colors in the late 20th century changed from Red to Purple Blue. Tones changed from 'grayish' to 'dull' Finally, it was forecast that Purple Blue, Yellow Red and Green colors with 'grayish', 'dull' and 'deep' tones were going to be used mainly in the near future. Also, achromatic colors with female and warm nuances would be reflected in design parts. This research will be very useful in that it has built a concrete database reflected on design trends forecasting in the near future by organizing academically a methodology to identify trends reflected on design and identifying relation between mega-trends and design trends based on analyzing factors that influence trend.

  • PDF

Change Detection of land-surface Environment in Gongju Areas Using Spatial Relationships between Land-surface Change and Geo-spatial Information (지표변화와 지리공간정보의 연관성 분석을 통한 공주지역 지표환경 변화 분석)

  • Jang Dong-Ho
    • Journal of the Korean Geographical Society
    • /
    • v.40 no.3 s.108
    • /
    • pp.296-309
    • /
    • 2005
  • In this study, we investigated the change of future land-surface and relationships of land-surface change with geo-spatial information, using a Bayesian prediction model based on a likelihood ratio function, for analysing the land-surface change of the Gongju area. We classified the land-surface satellite images, and then extracted the changing area using a way of post classification comparison. land-surface information related to the land-surface change is constructed in a GIS environment, and the map of land-surface change prediction is made using the likelihood ratio function. As the results of this study, the thematic maps which definitely influence land-surface change of rural or urban areas are elevation, water system, population density, roads, population moving, the number of establishments, land price, etc. Also, thematic maps which definitely influence the land-surface change of forests areas are elevation, slope, population density, population moving, land price, etc. As a result of land-surface change analysis, center proliferation of old and new downtown is composed near Gum-river, and the downtown area will spread around the local roads and interchange areas in the urban area. In case of agricultural areas, a small tributary of Gum-river or an area of local roads which are attached with adjacent areas showed the high probability of change. Most of the forest areas are located in southeast and from this result we can guess why the wide chestnut-tree cultivation complex is located in these areas and the capability of forest damage is very high. As a result of validation using a prediction rate curve, a capability of prediction of urban area is $80\%$, agriculture area is $55\%$, forest area is $40\%$ in higher $10\%$ of possibility which the land-surface change would occur. This integration model is unsatisfactory to Predict the forest area in the study area and thus as a future work, it is necessary to apply new thematic maps or prediction models In conclusion, we can expect that this way can be one of the most essential land-surface change studies in a few years.

Susceptibility Mapping of Umyeonsan Using Logistic Regression (LR) Model and Post-validation through Field Investigation (로지스틱 회귀 모델을 이용한 우면산 산사태 취약성도 제작 및 현장조사를 통한 사후검증)

  • Lee, Sunmin;Lee, Moung-Jin
    • Korean Journal of Remote Sensing
    • /
    • v.33 no.6_2
    • /
    • pp.1047-1060
    • /
    • 2017
  • In recent years, global warming has been continuing and abnormal weather phenomena are occurring frequently. Especially in the 21st century, the intensity and frequency of hydrological disasters are increasing due to the regional trend of water. Since the damage caused by disasters in urban areas is likely to be extreme, it is necessary to prepare a landslide susceptibility maps to predict and prepare the future damage. Therefore, in this study, we analyzed the landslide vulnerability using the logistic model and assessed the management plan after the landslide through the field survey. The landslide area was extracted from aerial photographs and interpretation of the field survey data at the time of the landslides by local government. Landslide-related factors were extracted topographical maps generated from aerial photographs and forest map. Logistic regression (LR) model has been used to identify areas where landslides are likely to occur in geographic information systems (GIS). A landslide susceptibility map was constructed by applying a LR model to a spatial database constructed through a total of 13 factors affecting landslides. The validation accuracy of 77.79% was derived by using the receiver operating characteristic (ROC) curve for the logistic model. In addition, a field investigation was performed to validate how landslides were managed after the landslide. The results of this study can provide a scientific basis for urban governments for policy recommendations on urban landslide management.

Application of the Developed Pre- and Post-Processing System to Yongdamdam Watershed using PRMS Hydrological Model (수문학적 유역특성자료 자동화 추출 및 분석시스템 적용 (II) -PRMS 모형을 이용한 용담댐 유역을 대상으로-)

  • Kwon, Hyung-Joong;Hwang, Eui-Ho;Lee, Geun-Sang;Yu, Byeong-Hyeok;Koh, Deuk-Koo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.11 no.3
    • /
    • pp.13-22
    • /
    • 2008
  • The objective of this study is to evaluate the applicability of extracted PRMS input parameters by KGIS-Hydrology over Yongdam-Dam watershed. KGIS-Hydrology is a system for automatic extraction and analysis of watershed characteristic data. Input parameters of PRMS were generated from GIS data (DEM, soil, forest type, etc.) using KGIS-Hydrology. Multi-temporal meteorological data from Jangsu station of KMA (Korea Meteorological Administration) were used for all simulation periods. Input parameters of PRMS were optimized using observed runoff data of Yongdam-Dam station (1966-2001) and validated using observed runoff data of Yongdam-Dam station (2002-2006, Yongdam-Dam watershed). The results showed that the simulated flows were much closed to the observed flows of Yongdam-Dam (2002-2006) and Donghyang (2001-2004) station by 0.49~0.83 and 0.57~0.75 model efficiencies, respectively.

  • PDF

A Study on the Architectural Design Utility of Object-based CAD System (객체기반 CAD 시스템의 건축설계적 효용에 관한 연구)

  • Yoo, Chang-Geun
    • Journal of The Korean Digital Architecture Interior Association
    • /
    • v.2 no.1
    • /
    • pp.9-15
    • /
    • 2002
  • As architectural forms tend to be large-scaled, high-storied and complicated, use of computer for processing design information has been generalized. However, CAD use in the process of developing architectural design has been neglected greatly in the educational field of architectural field due to the surging of recognition that it may limit the essential property of architectural design. It may be resulted from the limitation of CAD system, that is, it is because of tardy speed of application development for the related areas with the lack of simplicity and clarity of flexibility to be secured on the drawing and user interface. Recent CAD systems, however, overcome such a limitation, convert into object-based design from entity-based drawing, drafting and modeling for implementing design concept of architects and it connects with internet linked to superspeed information communication network and changes process and stream of architectural design. Therefore, this study deals with utility of object based CAD system with products of Autodesk Co. and consequently obtain the following conclusions. First, it expands architect's design areas by supporting cooperative design system based on model-based architectural design and internet. Second, it reduces consumption of personal and material resources and time in the process of drawing production for improving architectural design works. Third, it can reduce the frequent design changes by improving understanding of architectural space with visualization of immediate 3D information, escaping from traditional methods to deliver design information to building owner through 2D drawing or model and perspective drawing requiring much cost and time. Fourth, it keeps exactness without omission or duplication of design information and generate and renew information of all related drawings on a drawing. Fifth, it is possible to change difficult and boring architectural design work into a pleasure owing to immediate modeling and drawing of design idea. In addition, digital drawing generated by using object-based CAD system can playa role of establishing Urban Information System to be used for protecting from building in disaster and urban disasters in connection with GIS numerical map and be used for reference of all kinds of information required fro post-management of buildings. However, what is more important is that surplus time from introduction of object-based CAD system should be used for consideration to be recognized as a good space and building built as a product of this project for comfort to urban people.

  • PDF

Performance Tests of 3D Data Models for Laser Radar Simulation (레이저레이더 시뮬레이션을 위한 3차원 데이터 모델의 성능 테스트)

  • Kim, Geun-Han;Kim, Hye-Young;Jun, Chul-Min
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.17 no.3
    • /
    • pp.97-107
    • /
    • 2009
  • Experiments using real guided weapons for the development of the LADAR(Laser radar) are not practical. Therefore, we need computing environment that can simulate the 3D detections by LADAR. Such simulations require dealing with large sized data representing buildings and terrain over large area. And they also need the information of 3D target objects, for example, material and echo rate of building walls. However, currently used 3D models are mostly focused on visualization maintained as file-based formats and do not contain such semantic information. In this study, as a solution to these problems, a method to use a spatial DBMS and a 3D model suitable for LADAR simulation is suggested. The 3D models found in previous studies are developed to serve different purposes, thus, it is not easy to choose one among them which is optimized for LADAR simulation. In this study, 4 representative 3D models are first defined, each of which are tested for different performance scenarios. As a result, one model, "Body-Face", is selected as being the most suitable model for the simulation. Using this model, a test simulation is carried out.

  • PDF