Π Nws tau piav qhia tias qhov kev tshaj tawm no tau tsim los ntawm cov ntaub ntawv ntawm cov txiaj ntsig cadastral ntawm cov vaj tsev nyob hauv Khanty-Mansi Autonomous Okrug.
Cov tswv yim yog nthuav tawm nyob rau hauv daim ntawv ntawm cov kauj ruam. Txhua qhov kev ntxuav tau ua tiav hauv Excel, vim tias cov cuab yeej siv ntau tshaj plaws thiab cov haujlwm tau piav qhia tuaj yeem rov ua dua los ntawm cov kws tshaj lij feem ntau paub Excel. Thiab zoo heev haum rau tes-rau-tes ua haujlwm.
Cov theem xoom yuav yog kev ua haujlwm ntawm kev tso tawm thiab txuag cov ntaub ntawv, txij li nws yog 100 MB loj, tom qab ntawd nrog cov haujlwm no yog kaum thiab ntau pua, lawv siv sijhawm ntau.
Qhib, qhov nruab nrab, yog 30 vib nas this.
Txuag - 22 sec.
Thawj theem pib nrog kev txiav txim siab qhov ntsuas qhov ntsuas ntawm cov ntaub ntawv.
Table 1. Cov cim qhia ntawm cov ntaub ntawv
Technology 2.1.
Peb tsim ib qho chaw pabcuam, Kuv muaj nws hauv qab tus lej - AY. Rau txhua qhov nkag, peb tsim cov qauv "=LENGTH(F365502)+LENGTH(G365502)+β¦+LENGTH(AW365502)"
Tag nrho cov sij hawm siv rau theem 2.1 (rau Schumann formula) t21 = 1 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 2.1 (rau Schumann formula) n21 = 0 pcs.
Qhov thib ob theem.
Tshawb xyuas cov khoom ntawm cov ntaub ntawv.
2.2. Tag nrho cov txiaj ntsig hauv cov ntaub ntawv yog tsim los ntawm cov qauv cim. Yog li ntawd, cia peb taug qab cov txheeb cais los ntawm cov cim.
Table 2. Cov cim ntsuas ntawm cov cim hauv cov ntaub ntawv nrog rau kev tshuaj xyuas ua ntej ntawm cov txiaj ntsig.
Technology 2.2.1.
Peb tsim ib qho chaw pabcuam - "alpha1". Rau txhua cov ntaub ntawv, peb tsim cov qauv "=CONCATENATE(Sheet1!B9;...Sheet1!AQ9)"
Peb tsim ib lub cell ruaj Omega-1. Peb yuav hloov pauv cov cim cim raws li Windows-1251 los ntawm 32 txog 255 rau hauv lub xovtooj no.
Peb tsim ib qho chaw pabcuam - "alpha2". Nrog cov mis "= FIND(SYMBOL(Omega,1); "alpha1", N)".
Peb tsim ib qho chaw pabcuam - "alpha3". Nrog cov mis "=IF(ISNUMBER("alpha2",N),1)"
Tsim ib lub cell ruaj βOmega-2β, nrog rau cov mis β=SUM(βalpha3βN1: βalpha3βN365498)β
Table 3. Cov txiaj ntsig ntawm kev soj ntsuam ua ntej ntawm cov txiaj ntsig
Rooj 4. yuam kev kaw nyob rau theem no
Tag nrho cov sij hawm siv rau theem 2.2.1 (rau Schumann formula) t221 = 8 teev.
Tus lej kho qhov yuam kev ntawm theem 2.2.1 (rau Schumann formula) n221 = 0 pcs.
Theem 3
Qhov thib peb kauj ruam yog sau lub xeev ntawm dataset. Los ntawm kev muab txhua cov ntaub ntawv tus lej tshwj xeeb (ID) thiab txhua daim teb. Qhov no yog qhov tsim nyog los sib piv cov ntaub ntawv hloov dua siab tshiab nrog rau qhov qub. Qhov no tseem yuav tsum tau ua kom zoo dua ntawm kev ua pab pawg thiab kev lim dej. Ntawm no dua peb tig mus rau lub rooj 2.2.2 thiab xaiv ib lub cim uas tsis siv hauv cov ntaub ntawv. Peb tau txais yam uas pom hauv daim duab 10.
Fig. 10. Muab cov cim qhia.
Tag nrho cov sij hawm siv rau theem 3 (rau Schumann formula) t3 = 0,75 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 3 (rau Schumann formula) n3 = 0 pcs.
Txij li cov qauv Schumann xav kom theem ua tiav los ntawm kev kho qhov yuam kev. Cia peb rov qab mus rau theem 2.
Theem 2.2.2
Hauv cov kauj ruam no peb tseem yuav kho qhov chaw ob thiab peb zaug.
Fig. 11. Tus naj npawb ntawm ob qhov chaw.
Kev kho qhov yuam kev tau txheeb xyuas hauv cov lus 2.2.4.
Rooj 5. Kev kho qhov yuam kev theem
Ib qho piv txwv ntawm vim li cas ib qho piv txwv xws li kev siv cov ntawv "e" lossis "e" yog qhov tseem ceeb tau nthuav tawm hauv daim duab 12.
Daim duab 12. Qhov tsis sib xws hauv tsab ntawv "e".
Tag nrho cov sij hawm siv nyob rau hauv kauj ruam 2.2.2 t222 = 4 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 2.2.2 (rau Schumann formula) n222 = 583 pcs.
Plaub theem.
Kev txheeb xyuas qhov kev rov ua dua tshiab yog qhov zoo rau theem no. Ntawm 44 teb, 6 teb:
7 - Lub hom phiaj ntawm cov qauv
16 - Tus naj npawb ntawm cov av hauv av
17 - Niam txiv kwv
21 - Pawg Sab Laj
38 - Cov qauv tsis muaj (kev piav qhia)
40 β Cultural cuab yeej cuab tam
Lawv tsis muaj kev nkag. Uas yog, lawv yog redundant.
Teb "22 - Lub Nroog" muaj ib qho kev nkag, Daim duab 13.
Fig. 13. Qhov tsuas yog nkag yog Z_348653 hauv "City" teb.
Daim teb "34 - Lub tsev lub npe" muaj cov ntawv nkag uas tsis meej rau lub hom phiaj ntawm daim teb, Daim duab 14.
Daim duab 14. Ib qho piv txwv ntawm qhov tsis ua raws li kev nkag.
Peb cais cov teb no los ntawm cov ntaub ntawv. Thiab peb sau cov kev hloov pauv hauv 214 cov ntaub ntawv.
Tag nrho cov sij hawm siv rau theem 4 (rau Schumann formula) t4 = 2,5 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 4 (rau Schumann formula) n4 = 222 pcs.
Table 6. Kev txheeb xyuas cov ntaub ntawv teev cov ntsuas tom qab theem 4
Feem ntau, kev txheeb xyuas cov kev hloov pauv hauv cov ntsuas (Table 6) peb tuaj yeem hais tias:
1) Qhov piv ntawm tus lej nruab nrab ntawm cov cim rau tus qauv sib txawv ntawm qib yog ze rau 3, uas yog, muaj cov cim qhia ntawm kev faib tawm ib txwm muaj (rau sigma txoj cai).
2) Ib qho tseem ceeb sib txawv ntawm qhov tsawg kawg nkaus thiab siab tshaj levers los ntawm qhov nruab nrab qib qhia tau hais tias txoj kev kawm ntawm cov tails yog ib qho kev cog lus thaum tshawb nrhiav qhov yuam kev.
Cia peb tshuaj xyuas cov txiaj ntsig ntawm kev nrhiav qhov yuam kev siv Schumann txoj kev.
Idle theem
2.1. Tag nrho cov sij hawm siv rau theem 2.1 (rau Schumann formula) t21 = 1 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 2.1 (rau Schumann formula) n21 = 0 pcs.
3. Tag nrho cov sij hawm siv rau theem 3 (rau Schumann formula) t3 = 0,75 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 3 (rau Schumann formula) n3 = 0 pcs.
Cov theem zoo
2.2. Tag nrho cov sij hawm siv rau theem 2.2.1 (rau Schumann formula) t221 = 8 teev.
Tus lej kho qhov yuam kev ntawm theem 2.2.1 (rau Schumann formula) n221 = 0 pcs.
Tag nrho cov sij hawm siv nyob rau hauv kauj ruam 2.2.2 t222 = 4 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 2.2.2 (rau Schumann formula) n222 = 583 pcs.
Tag nrho cov sij hawm siv nyob rau hauv kauj ruam 2.2 t22 = 8 + 4 = 12 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 2.2.2 (rau Schumann formula) n222 = 583 pcs.
4. Tag nrho cov sij hawm siv rau theem 4 (rau Schumann formula) t4 = 2,5 teev.
Tus lej ntawm qhov yuam kev pom nyob rau theem 4 (rau Schumann formula) n4 = 222 pcs.
Txij li thaum muaj xoom theem uas yuav tsum tau suav nrog hauv thawj theem ntawm Schumann qauv, thiab ntawm qhov tod tes, theem 2.2 thiab 4 yog qhov muaj kev ywj pheej, tom qab ntawd muab cov qauv Schumann xav tias los ntawm kev nce lub sijhawm ntawm daim tshev, qhov tshwm sim. ntawm kev kuaj xyuas qhov yuam kev txo qis, uas yog, qhov ntws txo qis, tom qab ntawd los ntawm kev tshuaj xyuas qhov ntws no peb yuav txiav txim siab seb theem twg yuav tsum tau ua ntej, raws li txoj cai, qhov twg qhov tsis ua haujlwm ntau zaus, peb yuav muab theem ntawd ua ntej.
Daim duab 15.
Los ntawm cov qauv hauv daim duab 15 nws ua raws li nws yog qhov zoo dua los tso rau theem plaub ua ntej theem 2.2 hauv kev suav.
Siv Schumann tus qauv, peb txiav txim siab kwv yees thawj tus lej ntawm qhov yuam kev:
Daim duab 16.
Los ntawm cov txiaj ntsig hauv daim duab 16 nws tuaj yeem pom tau tias qhov kev kwv yees tus naj npawb ntawm qhov yuam kev yog N2 = 3167, uas yog ntau dua li qhov tsawg kawg nkaus ntawm 1459.
Raws li qhov tshwm sim ntawm kev kho, peb tau kho 805 qhov yuam kev, thiab tus lej kwv yees yog 3167 - 805 = 2362, uas tseem ntau dua li qhov tsawg kawg nkaus uas peb tau txais.
Peb txhais parameter C, lambda thiab kev ntseeg tau muaj nuj nqi:
Daim duab 17.
Qhov tseem ceeb, lambda yog qhov qhia tseeb ntawm qhov kev siv zog uas raug kuaj pom ntawm txhua theem. Yog tias koj saib saum toj no, qhov kev kwv yees yav dhau los ntawm qhov ntsuas no yog 42,4 yuam kev hauv ib teev, uas zoo heev piv rau Schumann qhov taw qhia. Hloov mus rau thawj ntu ntawm cov khoom siv no, nws tau txiav txim siab tias tus nqi uas tus tsim tawm pom qhov yuam kev yuav tsum tsis pub qis dua 1 qhov yuam kev ntawm 250,4 cov ntaub ntawv, thaum kuaj 1 cov ntaub ntawv ib feeb. Li no tus nqi tseem ceeb ntawm lambda rau Schumann qauv:
60/250,4 = 0,239617.
Ntawd yog, qhov yuav tsum tau ua cov txheej txheem tshawb nrhiav qhov yuam kev yuav tsum tau ua kom txog thaum lambda, los ntawm 38,964 uas twb muaj lawm, txo mus rau 0,239617.
Los yog kom txog rau thaum qhov ntsuas N (muaj peev xwm ntawm qhov yuam kev) rho tawm n (kho tus lej ntawm qhov yuam kev) txo qis dua qhov pib peb txais (hauv thawj ntu) - 1459 pcs.
Tau qhov twg los: www.hab.com