A study on Model of Database for GIS Analysis of Subsidence in Mine Area

전체 글

(1) , 35, 4 , 339-346, 2002 Econ. Environ. Geol., 35(4), 339-346, 2002.

(2)

(3) . . . .

(4) . . . . A study on Model of Database for GIS Analysis of Subsidence in Mine Area Kwangsoo Kwon1, Yoon-Seop Chang2, Shik Yu2 and Hyeong-Dong Park2* 1. Geophysical Exploration & Mining Research Division, Korea Institute of Geoscience and Mineral Resources School of Civil, Urban and Geosystem Engineering, Seoul National University. 2. Efficient database and DBMS are essential for GIS analysis of subsidence in the abandoned mine area. A data structure and a suitable analysis method were proposed for an efficient analysis of subsidence in the abandoned mine area. Data models for the location of mine, ground water level, subsidence measurement and subsidence cracks were defined and structured to the database.. subsidence, GIS, database, abandoned mine area.

(5)

(6)

(7) ! " #$% &'

(8) ()*+ , - ./ 012 345% " #67 8*&9 :& ;<9 => ?@ AB CD E - 3F2 GH 5%

(9) . . . . . . . . . . . > 21 ABCDE Y3#F G L2MU2 N qr` QsH Rt@ . !" #$% &' ( ) * #+, - , ./#- #0 1 23#0 21 4#56 7892 :

(10) #; <=< > ?@ 1 23#0 ./#1 ABCDE 4 #F GH6 IJCK L2M N OP, QR OS TQ 42 32 L2MU21 23 #6 V2 WX8#@ +QR- L2MU2 , N2< Y3- ZEY [2 \]> ? D< ./#, ^_` >5 a 21 G L2MU2- S b#@ cd e -6 fg, ./#1 ABCDE hi 4 #F G hjQR, C klmn o4 pi . . . ./#- uv` w6 xKy` hi z{E < |} ~ fg1 \ < xy* klm Q- ?} }5Y 2 @> ~ T ?@ 1 y } #TG 6 DE S#> 6 DE 42 S# @ fg, \ q` pE <=6 m2 S #< 4, m A B` >5H ~ m, o42 x#@ !, fg1 kl#6 mn* 2- c ./#, 1 >5 [m2 x#@ -. . . . . . . .

(11) . . .

(12) . .

(13)

(14) . . . .

(15) . . . . . *Corresponding author: [email protected]. . .

(16)

(17) 6 2 ABCDE 3Ã T ?@ 4, !´* T8fg T¶fg (2 ÄÅ#; Æ] } ?} ¸DE #> hi 4#F-6 C # Ç@ Æ¥ fg, /#- H , 1 ÈSÉDE ÊË2 S#< 26 QÌ Three basic types for representation of geometric model. /#4-6 oABC2@ cd * ABCK ®i1 RK@6 -g Í#> \C 3]6 m* DE¸ :3Ã T ?@ , SS ?D 21 FD E ./#hi- C !G kl` 4

(18)

(19) H R> @ e 4-6 i 2> ? m* Àj, , Î 6 1 E # D E, ¡ DE ¥@ cd , Ï ¤6 , ` ¢£ >5# @ E ¥@ fg, Æ_` Ð T ? > Ñ 4- g Ò4Ó S#@ * @« )2 ¥@

(20) m* z ¤6 z , GE hi¥@ ¦ ! #<- H #. <1 §¨6 m2©E m-6 m-6 ªqiS C; x#@6 ¤6 2 ?@ 2 m- c * @« )2 + AB_* ÔT¸Õ ªqi xÖg ÈS ¬#; ¥@ #¸ Æ ¸DE #6 m-6 ABCDE ®i S#@ ¤ ¤6 DE Æ]6 mDE AB ¤ { ` #<, E ®i¢DE¯ + C Y32 S#@ 2× ABCK m* @« 4` G ®iAB2 @ m- oH S °± )* DE \ØÐ T ?@ ; ®i]6 2 ?@.

(21) ./#, ²G< G³u´ 'Q* DE ®i#0 <=µ T ?@ ¬ ¶·gz ` <=6 fg- H¸. e m2 ,¹1 º T ?@ »¼SE , ½¾-g <=<6 , ¿. ¬À, ÁÂ- c - H ¤6.

(22) m-a »¼SE 1 ÙH 42 S#@ m * fg, \ q` pE .u#6 V2©E f gÆ_` >5 ./#, 4- Ú}<@ ¤ fg, mv_` >5 $a, hj_ 0 1 Û; 4Ð T ?@ ¬ T¶fg 4DE K /#a T8fg 4 , /#z, 2-g Í#> ¸DE6 Representation of subsidence using point type. .

(23) . . . . . . . .

(24) . !"##$. . .

(25) . . .

(26) .

(27) . .

(28) . . .

(29) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . '. . . .

(30) . . . . . (. )$ . ) $. .

(31) . '. . ' *$ . . . . . . . $ ( '. !"##$ . + ( '. . ,. .

(32) . . %&. '

(33) . . . !"##$ . . . . . .

(34) .

(35) Ð T ?> Ñ 4- g m®í S# fg, ·C` >5 "2 S #@ ^Q 2 , DE _¥ ` @« )2 \ØÐ T ?@ . . . .

(36) . . . . . Representation of subsidence using line type.. 2 ` #F }Ü@ cd Tf` #6 ¤6 1 cE OÝ#0 (, 4` TÞHß @ , Tf2 ?6 @« )* ` \ØÐ T ?@ . (. )$ . !"##$ . -. . . . . (. )$ . ) $. .

(37) . ,.

(38) 1,

(39). + ( '. )$ . . ,.

(40) .

(41) .

(42) . . . ,-. '. ¤6 43.

(43) . . . .&#. $ ( '. /. + ( '. -. '. ¤6 fgy * à2 á#6 g ?} ` âÐ fgà` ¢£ >5Hß @ À.CDE6 m - ã_1 ÙH fgà` >5Ð T ? D '0-6 - $ , DE >5Ð T ?@ ¤ fg à- cd @ '1 0 ` gkÐ Tg ?D< 2 Æ_4 ( 2P äå- æÓ5 Íç#@

(44) . . . .

(45) . . .

(46) . m* Àj, , ÎDE ¥@6 - m eCK 26 @ cd , Ï ¤6 , E ¥@ ¬ 9` <=F GH6 ä À è1 é6 ê ` ëS#0 4#6 $1 ì6@ cd fg, Æ_` .

(47) . . . . . ¤6 AB_* ÔT¸Õ ªqi xÖg ÈS #¸ Æ ¸DE #6 m-6 m »¼SE ABCDE ®i S#@ ¬ , u´` Q,#F GH , hJ'Q2 {gE x#@ 1 >5 * - \Ø¥ m` î¢ VDE zG $- Hï]6 Q2 ?D @« )2 \Ø¥@

(48) . . $ ( '. '. . . . .

(49) . . . . ,.

(50) . '. ¤6.

(51) m-a »¼ SE 1 ÙH 42 S#@ m* fg, \ qð¸ ñéd ·C` pE .u#6 V2©E fgòF1 >5 ./ #, 4- Ú}<©E {g, - $ ¤6 ã_1 Ù Q,$,# (, äå2 Í x#@ »¼SE T¶fg 4DE K / #a T8fg 4, /#z, 2-g Í#> ¸DE6 2 ` #F }Ü@ cd Tf` #6 ¤6 1 cE OÝ# 0 (, 4` TÞHß @ G, , \Ø 3 , \Ø 3` ó#0 @« )*

(52) . . . !"##$ . . . .

(53) . 2.

(54) . .

(55)

(56) . . (. !"##$ . )$ . . . .

(57)

(58) #0 mv_` +[CDE >5Ð T ?@. . . ! " #$ ! " %& û 4 W- c±· ./# hi 4- ü m, :3g1 \Ð T ?@ , ·C` >5 òF- c / # z` 8[ 4Ð T ?¸ fg+, Æ_2< mv_` >5 4* {g, ù>iú` Ù äå ` TÞHß @ ¤ &# , /#

(59) ý¡þ2 @ fgR@6 ÿD /#Ög ò; h]6 V DE <=<¸ -6 .u] Ç6@ , Æ_2< mv_` >5 4 - Ú}< ã_1 :3 òF 42 } Qg S#©E @ m- oH ABC2@ &# - H6

(60)

(61) , a »¼SE {gE . u] Ç6@

(62) , L2M m, ¬_ ®iAB, &# 1 .uÐ T ?6 , \ CK ¸2 ¿@ cd ¾.CDE ¶SÐ

(63) ` FeDE #0 òF1 .u#< &# 1 .u¨6 mn2 x#@ #' ()* +," -. 2 mn* F¿ , m` pE 23#6 VDE ü fg, kl ` ÙH 4, fg1 kl#0 ` .u¨; ¥@ fg, à* (, ã_E Ðï#0 fg I vP /#4 klxKDE, :3 E 23¥ @ 6 DE OS kl#; ¥@ - Hï]6 6 -g fg, À E {g kl]} ?@ ÀQ à` S6 DE, 2 ÍSÐ -6 {gE ` 23#0 kl@ 2 mn* , kl2< hi 4 (- ?} sCDE öÞ]> ó Æ%` ÊËE "2 S#@ kl hi Qz { , äåDE öÞ]©E CK /#h i-6 oABCK 42 ?@ . . . 3! .

(64)

(65) . Representation of subsidence using polygon type.. ` \ØÐ T ?@.

(66) . .

(67) .

(68) '. ' $ ( ' + ( '. ,. )$ '. ,-. '. ¤6 43.

(69) . . .&#. . /. -. . '. ¤6 fg, à2 á#6 - oH -6 ·CDE 8[ "®iS S#@ cd -a )* {g, >5xK2 x @ ¬ fgS ãCDE ô; 4î#< wáfga Æ]} 4îÐ * klAB2 õ }ö@ ¤ -a )* mv_ 4* 8 [ TÞ#F }5 1 ÙH zCDE ÷> ø fg- Hï#6 G1 OÝ#> { g, ù>iú x 21 _#6 { ` OÝ

(70) . . . .

(71) .

(72) .

(73) . . .

(74) . . . .

(75)

(76) . . .

(77) . '0.

(78) . . . .

(79) . *. 4

(80) . 5$ . . '. . &#. &#.

(81) . .

(82) . . . .

(83) .

(84) .

(85) . . . .

(86) Adaptability of geometric representation of subsidence (decreasing order of adaptability: Type Point Line Polygon. Shaft representation. . Connectivity. Orientation. . . Size & Dimension. . ) Memory & Data structure. . .

(87) /012 ! 2 mn* 6 \ ./# QRhiz QR, f2 w x {®iP ÊËäå @ iE öÞ¥@ ]6 fgG #TG /# /# ( ¦ ü fg, kl ` ÙH 4, f ` zDE Q#0 kl, çi_ ® g1 kl#0 ` .u¨; i3 _, çi_ (` >5 N Ep, ¥@ 2 * kl - Hï]6 4` F`

(88) #6 V` CDE # @ . E Q@6 fg à, á S ?6 34

(89) 5 + - H6 à` - Q@6 , fgG6 kl P ¹ TQ` \# 2S ?@ cd {g, ` _Ð xS D fg ¾I, ÀCK hiS S#@ G, >6 á]6 6 @ p×< !"´ - @. , /#'Q m` W DE , F¿ QRS ¹ #> Q¡ F!y2 ?D©E 1 #6 4 fg, Æ 4- OSE KH QR f2 ãCDE x¥@ e -

(90) ¥ NE ` ñ

(91) a )2 OS#6 $1 \ØÐ T ?@ p-6 fg- h ÞQhiC QRa +C Q R, SE <|} kl#g! 'J# @ ÞQhiC QR-6 ü fg- H !"

(92) 2< /#hi C- cd Àó, hi. "1 0Ð T ?g! # @ ¤ - < =# Wa )2

(93) 1 kl#0 ö- . Þ#> ?6 !"

(94) /#Ä$9d6 hj_` >5 N` Ð T ?g! # @ ¤6 @« ¬JE6 !"fg, G1 kl#6 VD 43 E >¾C Ö 2-g ! . .

(95) -S 3]> ?6 ` >5#0 èkl m òF3 ` â#g! # @ fg, kl* fgJ ¤6 ` x- cd ¤6 QÆ- W #0 kl#g 2 , ü S ã¥ fg- Æ_` ! # > fgG- F1 ¢£ kl# é> ?} üó - çi#@ ¤ { fg- 0 , ä_F- c %_` ¢£ 4Ð T /#1 sCDE¸ H# Ç> Æ¥ fg ?g! # @ ¾I1 >5 fg H- ./# , H2 S#@ ^Ó fg,

(96) F f®i äå (- Ù1 #©E [m - C# ,}1 Ù 42 S#@ . . . . . . . . &#. . . . . '0. .

(97) . . . . . '0. *. 4

(98) 5$ . . . 2.

(99) .

(100) . 6 & '. &# $ " '. . . '0. . . $ ( '. . + ( ' ,. .

(101) . 7. '. ,-. ,. '

(102) . . . .&#. /. -. ' &# $ " ' .&#

(103) . /. . . . &#. . . . . . . . . . . . !. - e Wa )2 fg, Ghi- , ABCK $S x# F= hix Ê ` ÙH ãCDE hiS x V* # TG /# qéM Æ /# Q ( ` \ØÐ T ?@ 2, £ i ¬ (, y* F N 2P f2 x] Ç6 2©E F N 2P {g, N Ep, x_2 C@ cd e - . '0. . . . . . . . . . '0. . Management of mine location information..

(104)

(105). . Management of subsidence measurement information. Management of groundwater information.. 6

(106) #TG, f* ZEY hQ, ' Q 2¹ '¥ hQ` Ù ã ¤6 wFC qéM (- ,H x#; ¥@ cd kl6 ò; ÞQhiC QR +GQR ã_QR ¦ #TG (DE <& T ?@ ÞQhiQR6 hi " h' QF1 kl#g! #0 J C á2< - C ÞQQR1 î¢#g! # @ \ O` Ù #T G h6 &'hj ()

(107) hj

(108) hj (DE @ ]} ?} h' 1 Ù 4*S x#@ h, +G6 èklm, Q p- c G, kl` #g! 'J# > h, O S QR1 Û; 4#g! #F GH F¿, OQRa òS ]g! hj O 1 kl#g ! # @ #TG6 Oäåz, Q- z§+ > #TG,g1 ¢£ kl#g! # @ . . . . . . . . . . . . 8. '. . 9"

(109). $. . . . '. . . . . '. . . 785 /#6 ./# z` z- ¤6 Ê JF1 ÙH Q -` ,¹#6 VDE -6 À ´- $./ äå` TÞ#> ? @ !´- H6 FCK JS I JCDE hiÃ x_2 ?D©E e ` E hi#0 f#> 4#6 äå2 x#@ /#6 { fga hj* ?D< E §0 T 6 2 ?@ ^Ó K[ fg, /# E KH

(110) ý /#6 ¤@ wáfg- ,Hg

(111) ýÐ T ?D©E hj 0 1 4#6 + C G, K[_ 4` Ù mn2 S C#@ . . . . '0. . : . . . cd /#6 ÞQhiC QR +GC Q RE hi]}ß @ ÞQhiC QR-6 hi" h' h'F 2-g h'mn` î¢#> ?@ m-6 1 ØOQ )* ¬h'g klÐ T ?g! #0 Q¡_* @ õ}< F!, ¿2z Êx oQ_CK h'- Hï g klÐ T ?g ! # @ ¬Q* 3 (, +¬ oQÌ QÖ - V2 QÌÖ* ÖFF1 23 #0 kl V` Q#> ?@ y} :3]> ?6 '' ##$ , klg î¢# ÊáGJE M, g kl S4! # @ cd QFF- c æ 4g SÐ T ?g! ' J# @ +GQR6 èkl m, â- c d /#, Q Gè1 kl#g! # @ /# Ê-6 #<, fga h¥ yg ?D< ¤@ fg- , uvg ?6 S 5D ©E { /#1 {g hi#g! # @ . . . '. . . . . . . . . . . . 9:; /#z2

(112) ý#· z, .2< $%- 2

(113) ýÐ S ?@ * 6DE

(114) ý #; ] fg, /#- c 7Hg 42< R8´ Q (, E :3Ã T ?@ û @. S, y* /#

(115) ý Ia hj¥ V2 ¸ /#6, Æ%E @9}6 QRHï¥@ cd ÞQhiC QR /# 2¹ QR +GC QR { ^_QR (DE < |} hi@ ÞQhiC QR-6 hi" h' 1 ÙH whCK :¬2 52 î¢]6 h'1 hiÐ T ?g! # @ ¤ h' - 2¹1 ë . . . . . . . . ;. . . '.

(116) #0 hiC ·` >5# @ ¤ 2¹6 {g, >?4i1 ÙH hi]g! # @ , +G QR6 èkl m` Q P ü , èa . hj O 1 'Q#g! # @ { QR6 hi" ô2 @Z F1 kl4! #0 /# 7Hg, 4` GH x óCK QR1 î¢#g! # @ ¤ + - c /#zg ABÐ T ?} /#öÞ ãg ` G Fe 1 NÐ T ?g! # @ G, 3` W DE e , L2MU2- \ kl¥ y` Qi#· a )@ e -6 E 1 23# D L2M, kl f TQ2 32#g! C}1 23#0 Dd2CE Ep`

(117) # @ Fz- L2MU21 N#> Dd2CE Management of subsidence crack information. Ep` \¢DE¯ KÈ¥ 3, GH Ç> [2 S#g! # @ #0 R@ Q¡#; hi#g! # @ 2 2¹ I, h'1 {gE 4#0 +;

(118) ýÐ T " #$ ?6 Qa 2¹ h'S z2 Hg hi S#g! # @ /#6 2¹ e -6 ABCK ./# hi1 G '0 kl* Fa Í} 2¹ <=m` kl4! N` GH , v` >5#0 fghi. . '. . . . . . . 3! . '0<. < $#. . 9. . *= . . . . .

(119) Categories and items for database input. Main Category Mine Location. Groundwater. Subsidence Measurement. Subsidence Cracks. Detailed Category. Data items. Administration. Mine ID, Developer ID. Location. Coordinate type(UTM, Lat/Long) Location(Lat, Long, x, y, Depth). Administration. GW ID, Observer ID, Date. Location. Coordinate type(UTM, Lat/Long) Location(Lat, Long, x, y) Ref borehole ID. Attributes. Suface height, Water level. Administration. Meas ID, Observer ID, Date Measurement type. Location. Coordinate type(UTM, Lat/Long) Measurements. Administration. Cracks ID, Observer ID, Date. Location. Coordinate type(UTM, Lat/Long) Location(Lat, Long, x, y) Radius, Ref borehole ID. Image info.. Date, Observer ID Image type(Scan, Digital camera) Image data. Individual crack. Crack ID Length, Width, Date. . $4$.

(120)

(121) C qDE m- H - QR1 ¢£ @N T ?g! 'J# @ ^ ¬ ` o# @ 21 ÙH I* ÆJ* @« Ó { ` ü fg- H E §¨ Ç g! #0 7HzM fg4î- +zh_ 4 )@ m* üü hi - 23]g! _# @ + - c öÞzMg ABÐ T ? fgã_ mv_ hia 4 fgòF- c /#4 (- S C $1 é> ?6 VD } /#öÞ ãg 4 /#. R8 G 4 (, F E 1 NÐ T ?g! # @ E 4]K@ > 1 23 ./# 4- z§#6 üó F ¬ ` 4 Æ m` FeDE # ` ÙH vP S , fg ./# 0 4, fg1 kl¢DE¯ ` .u¨> kl - Hï] y` '0E NÐ e Ep` FeE R@ 6 4` . E Q#> fg à, á S ¡¥ ` NÐ T ?` VDE F¥@ ?6 + - H6 à` - Q#6 Ä % % m` â#6 V2 ./# hi- C VDE 4]K@ e 6 , #- TÞ 2z, fg hi- Æ1 W DE # ]KD 2- O* P , Q` ¾é@ 0 QR, f2 w x]6 ` Ê hi DE 'Q#> 21 hiÐ T ?6 L2MU21 &'() N# > ÆJ* @« )2 x ¥@ ./# fghi 7Hhia 2- c 4 J KLM NO .P2 HQ ` GH6 fg G #TG /# /# I : RSTUV !I "#"$ ( S, QR1 Ê hiHß @ 4 % ) ** + ,

(122) + -

(123) * + $. £ QR (* NP , f 2 &

(124) '( .

(125) . *

(126)

(127) / ' )'$. 3]6 QR2©E {g, hi Ep, *

(128) $ 0 ' #1" - 2- $&*

(129) * +*

(130) x_2 C@

(131) *

(132) 3 '$-

(133) + 3 $

(134) ¥ hiEp* ./# , 11$ ## 1 ¢£ :3#F GH h' h' 3. 4 56 + &

(135) + 7 ##

(136) * $

(137) 2 )

(138)

(139) * + -. *

(140)

(141) 8$ F m 2¹ (` NÐ

(142)

(143)

(144) + 6

(145) * $"! T ?g! #0 , @ ¡Ra Í} p- 9

(146) 5& ##0 6 *

(147) ** +

(148) 3 '$-

(149) + 3 1$ c æg >5 4` Ð T ?g! # @ # ./# hi- fg- ÎÊ¥ L- o H 7HzM` 4Ð T ?g! #F GH W X Y SHZ: W X Y [\]

(150). . . .

(151) . : . . . . . .

(152) . . &#. . . 8. . . '0. . . . *. 4

(153) . 5$ . . . &#. '0. . . . '0. . . . . . . . . . 2. . . . '0. . 2. '0. . . '. . :. . . 7. 1. . 1. . .

(154)