• Journal of Intelligence and Information Systems
• /
• v.17 no.2
• /
• pp.61-75
• /
• 2011

A Geographic Information System(GIS) is a system that captures, stores, analyzes, manages and presents data with reference to geographic location data. In the later 1990s and earlier 2000s it was limitedly used in government sectors such as public utility management, urban planning, landscape architecture, and environmental contamination control. However, a growing number of open-source packages running on a range of operating systems enabled many private enterprises to explore the concept of viewing GIS-based sales and customer data over their own computer monitors. K telecommunication company has dominated the Korean telecommunication market by providing diverse services, such as high-speed internet, PSTN(Public Switched Telephone Network), VOLP (Voice Over Internet Protocol), and IPTV(Internet Protocol Television). Even though the telecommunication market in Korea is huge, the competition between major services providers is growing more fierce than ever before. Service providers struggled to acquire as many new customers as possible, attempted to cross sell more products to their regular customers, and made more efforts on retaining the best customers by offering unprecedented benefits. Most service providers including K telecommunication company tried to adopt the concept of customer relationship management(CRM), and analyze customer's demographic and transactional data statistically in order to understand their customer's behavior. However, managing customer information has still remained at the basic level, and the quality and the quantity of customer data were not enough not only to understand the customers but also to design a strategy for marketing and sales. For example, the currently used 3,074 legal regional divisions, which are originally defined by the government, were too broad to calculate sub-regional customer's service subscription and cancellation ratio. Additional external data such as house size, house price, and household demographics are also needed to measure sales potential. Furthermore, making tables and reports were time consuming and they were insufficient to make a clear judgment about the market situation. In 2009, this company needed a dramatic shift in the way marketing and sales activities, and finally developed a dedicated GIS_based market analysis and sales management system. This system made huge improvement in the efficiency with which the company was able to manage and organize all customer and sales related information, and access to those information easily and visually. After the GIS information system was developed, and applied to marketing and sales activities at the corporate level, the company was reported to increase sales and market share substantially. This was due to the fact that by analyzing past market and sales initiatives, creating sales potential, and targeting key markets, the system could make suggestions and enable the company to focus its resources on the demographics most likely to respond to the promotion. This paper reviews subjective and unclear marketing and sales activities that K telecommunication company operated, and introduces the whole process of developing the GIS information system. The process consists of the following 5 modules : (1) Customer profile cleansing and standardization, (2) Internal/External DB enrichment, (3) Segmentation of 3,074 legal regions into 46,590 sub_regions called blocks, (4) GIS data mart design, and (5) GIS system construction. The objective of this case study is to emphasize the need of GIS system and how it works in the private enterprises by reviewing the development process of the K company's market analysis and sales management system. We hope that this paper suggest valuable guideline to companies that consider introducing or constructing a GIS information system.

• Journal of Food Hygiene and Safety
• /
• v.24 no.1
• /
• pp.56-62
• /
• 2009

Patulin, a mycotoxin mainly produced by Penicillium and Aspergillus, is found in various foods. In the present, a maximum acceptable level for patulin is established at $50{\mu}g/kg(ppb)$ in apple juices and apple concentrates in Korea. But patulin may be detected in foods produced with other fruits. In the present study, patulin contamination was analyzed in 520 samples of fruit juices and beverages, and 50 samples of fruit juice concentrates. High performance liquid chromatography(HPLC) was applied to quantitatively analyze patulin levels in samples and liquid chromatography-mass spectrometry(LC/MS/MS) was used to remove false positive results. The results showed that three samples of 520 fruit juices and beverages and five samples of 50 fruit juice concentrates were contaminated by patulin, $9.8-18.0{\mu}g/kg$ and $4.7-18.2{\mu}g/kg$ respectively. Contaminated samples were produced with apple, orange or pear. This indicates that it is necessary to extend the regulatory range of patulin. In the other hands, the present study confirmed the effectiveness of LC/MS/MS analytical method to remove false positive results.

• Economic and Environmental Geology
• /
• v.37 no.1
• /
• pp.61-72
• /
• 2004

The soil samples were collected from the paddy field near the mine tailing dumps in the abandoned Duckum mine in Korea. In the laboratory, the soil solution was extracted from the soil using centrifuge, and analysed for the chemical composition. Physical and chemical soil properties were also analysed. Kaolinite is the main clay minerals in the paddy soil and the CEC value is therefore relatively low. Nearly all soil samples show enrichment in their trace elemental concentrations(Cd, Cu, Pb and Zn) compared with natural background level. Some soil samples exceed the soil remediation intervention values for Cd, Pb and Zn and target value for Cu, when compared with Dutch standard, whereas As, Ni and Cr are in normal range. Lead concentrations in some samples near the mine tailing dumps also exceed the standard for remediation act for agricultural area set by Korean soil conservation law. The trace elemental concentrations are higher in the paddy soil nearer the mine tailing dumps and lower for the samples from distance. Similar trend with distance is found for the soil solution chemistry but the decrease with distance from the mine tailing dumps are sharper than the changes in soil chemistry. Cadmium, Cu and Pb concentrations in the soil solution are very low, ranging from a tenth and hundredths to a maximum of several mg/l, whereas their concentrations in soils are highly enriched for natural background. Most of the trace elements are thought to be either removed by reduced iron sulphides or iron oxides, depending on the redox changes. Geochemical equilibrium modelling indicate the presence of solubility controlling solid phases for Cd and Pb, whereas Zn and Cu might have been controlled by adsorption/desorption processes. Although pollutants migration through solution phase are thought to be limited by adsorption onto various Fe, Mn solid phases, the pollutants exist as easily releasable fractions such as exchangeable site. In this case, the paddy soil would act as pollutant pool, which will supply to plants in situ. whenever the geochemical conditions favour.

• Journal of Korean Society of Forest Science
• /
• v.29 no.1
• /
• pp.20-53
• /
• 1976

For the purpose of detecting the capability of the trees to resist air pollution and of determining the tree species best suited for purification of polluted air, particularly with regard to $SO_2$ contamination, six following ornamental tree species were selected as experimental materials: i.e., Hibiscus syriacus L., Ginkgo biloba L., Forsythia koreana Nak., Syringa dilatata Nak., Larix leptolepis Gordon, and Pinus rigida Miller. The susceptiblities of the trees were observed and analyzed on the basis of area ratio of smoke injury spots to the total leaf area. The results of the experiments are as follows: I. The Susceptibilities to Sulfur Dioxide. (1) The decreasing order of tolerance to $SO_2$ by species was as follows: 1. Hibiscus syriacus 2. Ginkgo biloba, 3. Forsythia koreana, 4. Syringa dilatata, 5. Larix leptolepis, and 6. Pinus rigida. In general, Hibiscus syriacus and Ginkgo biloba can be grouped as the most resistant and Larix leptolepis and Pinus rigida as the least resistant and Forsythia koreana and Syringa dilatata as of intermediate resistance. (2) The sulfur content of the leaves treated by $SO_2$ increased in proportion to the increase of the concentration of the fumigation. The content in the coniferous species proved to be less than that of the broad-leaved species, but Ginkgo biloba proved to contain as much sulfur as broad-leaved species. (3) The earlier-stage leaves fumigated in June with the $SO_2$ concentration up-to-l-ppm showed that sulfur content increases in proportion to the increase of the concentration of the fumigation, but the difference between concentration was not so significant. (4) The later-stage leaves fumigated in October showed higher sulfur content than the earlier stage leaves, and a wider range of difference in sulfur content was detected among different concentrations. The limit of fumigation resulting in culmination of sulfur absoption in broad-leaved species, such as Syringa dilatata, Hibiscus syriacus, and Forsythia koreana proved to be around 0.6 ppm. (5) Due to the sprouting ability and the adventitious bud formation, the recovery from $SO_2$ fumigation was prominent in Hibiscus syriacus, Syringa dilatata, and Forsythia koreana. (6) The differences in the smoke spot color were recognized by species: namely, dirt-brown in Syringa dilatata, brilliant yellowish-brown in Pinus rigida and Ginkgo biloba, whitish-yellow in Hibiscus syriacus and reddish-brown in Forsythia koreana. (7) The leaf margins proved to be most susceptible, and the leaf bases of the mid-rib most tolerant. In both Ginkgo biloba and Larix leptolepis, the younger leaves were more resistant to $SO_2$ than the older ones. II. The ulfur Content of the Leaves of the Ornamental Trees Growing in the City of Seoul. (1) The sulfur contents in the leaves of the Seoul City ornamental trees showed a remarkably higher value than those of the leaves in the non-polluted areas. The sulfur content of the leaves in the non-polluted area proved to be in the following descending order: Salix pseudo-lasiogyne Leveille, Ginkgo biloba L., Alianthus altissima swingle, Platanus orientalis L., and Populus deltoides Marsh. (2) In respect to the sulfur contents in the leaves of the ornamental trees in the city of Seoul, the air pollution proved to be the worst in the areas of Seoul Railroad Station, the Ahyun Pass, and the Entrance to Ewha Womans University. The areas of Deogsu Palace, Gyeongbog Palace, Changdeog Palace, Changgyeong Park and the Hyehwa Intersection were least polluted, and the areas of the East Gate, the Ulchi Intersection and the Seodaemun Intersection are in the intermediate state.