date: 21-07-2021
0.1 Lectura tabla madre
Esta tabla es la que contiene la información comunal, provincial y regional asociada a una columna llamada Parcela_ID y es la que tenemos que unir a cada tabla sobre la que deseamos obtener las estadísticas básicas (sumaries).
<- read_sf("../../../archivos_grandes/mallas 1 kms chile/Malla_1km_Chile_GCS_xComuna.shp")
malla_sf <- as.data.frame(malla_sf)
malla_df <- head(malla_df,5)
abc kbl(abc) %>%
kable_styling(bootstrap_options = c("striped", "hover")) %>%
kable_paper() %>%
scroll_box(width = "100%", height = "300px")
Malla1k | Malla2k | Malla4k | Malla8k | Malla16k | Parcela_ID | REGION | NOM_REGION | PROVINCIA | NOM_PROVIN | COMUNA | NOM_COMUNA | geometry |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0 | 0 | 0 | 0 | 1 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-68.73185 -56.5077) |
1 | 0 | 0 | 0 | 0 | 3 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.27731 -55.97484) |
1 | 0 | 0 | 0 | 0 | 4 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.2613 -55.97462) |
1 | 2 | 0 | 0 | 0 | 5 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.30974 -55.96631) |
1 | 0 | 0 | 0 | 0 | 6 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.29373 -55.96609) |
0.2 Lectura tabla 1
http://ide.dataintelligence-group.com/descargas_gee/indice_ndgi.csv
<- read_csv("../../../archivos_grandes/4_indice_ndgi.csv") tabla
##
## -- Column specification --------------------------------------------------------
## cols(
## .default = col_double()
## )
## i Use `spec()` for the full column specifications.
<- head(tabla,5)
abc kbl(abc) %>%
kable_styling(bootstrap_options = c("striped", "hover")) %>%
kable_paper() %>%
scroll_box(width = "100%", height = "300px")
Parcela_ID | 2000_04 | 2000_05 | 2000_06 | 2000_07 | 2000_08 | 2000_09 | 2000_10 | 2000_11 | 2000_12 | 2001_01 | 2001_02 | 2001_03 | 2001_04 | 2001_05 | 2001_06 | 2001_07 | 2001_08 | 2001_09 | 2001_10 | 2001_11 | 2001_12 | 2002_01 | 2002_02 | 2002_03 | 2002_04 | 2002_05 | 2002_06 | 2002_07 | 2002_08 | 2002_09 | 2002_10 | 2002_11 | 2002_12 | 2003_01 | 2003_02 | 2003_03 | 2003_04 | 2003_05 | 2003_06 | 2003_07 | 2003_08 | 2003_09 | 2003_10 | 2003_11 | 2003_12 | 2004_01 | 2004_02 | 2004_03 | 2004_04 | 2004_05 | 2004_06 | 2004_07 | 2004_08 | 2004_09 | 2004_10 | 2004_11 | 2004_12 | 2005_01 | 2005_02 | 2005_03 | 2005_04 | 2005_05 | 2005_06 | 2005_07 | 2005_08 | 2005_09 | 2005_10 | 2005_11 | 2005_12 | 2006_01 | 2006_02 | 2006_03 | 2006_04 | 2006_05 | 2006_06 | 2006_07 | 2006_08 | 2006_09 | 2006_10 | 2006_11 | 2006_12 | 2007_01 | 2007_02 | 2007_03 | 2007_04 | 2007_05 | 2007_06 | 2007_07 | 2007_08 | 2007_09 | 2007_10 | 2007_11 | 2007_12 | 2008_01 | 2008_02 | 2008_03 | 2008_04 | 2008_05 | 2008_06 | 2008_07 | 2008_08 | 2008_09 | 2008_10 | 2008_11 | 2008_12 | 2009_01 | 2009_02 | 2009_03 | 2009_04 | 2009_05 | 2009_06 | 2009_07 | 2009_08 | 2009_09 | 2009_10 | 2009_11 | 2009_12 | 2010_01 | 2010_02 | 2010_03 | 2010_04 | 2010_05 | 2010_06 | 2010_07 | 2010_08 | 2010_09 | 2010_10 | 2010_11 | 2010_12 | 2011_01 | 2011_02 | 2011_03 | 2011_04 | 2011_05 | 2011_06 | 2011_07 | 2011_08 | 2011_09 | 2011_10 | 2011_11 | 2011_12 | 2012_01 | 2012_02 | 2012_03 | 2012_04 | 2012_05 | 2012_06 | 2012_07 | 2012_08 | 2012_09 | 2012_10 | 2012_11 | 2012_12 | 2013_01 | 2013_02 | 2013_03 | 2013_04 | 2013_05 | 2013_06 | 2013_07 | 2013_08 | 2013_09 | 2013_10 | 2013_11 | 2013_12 | 2014_01 | 2014_02 | 2014_03 | 2014_04 | 2014_05 | 2014_06 | 2014_07 | 2014_08 | 2014_09 | 2014_10 | 2014_11 | 2014_12 | 2015_01 | 2015_02 | 2015_03 | 2015_04 | 2015_05 | 2015_06 | 2015_07 | 2015_08 | 2015_09 | 2015_10 | 2015_11 | 2015_12 | 2016_01 | 2016_02 | 2016_03 | 2016_04 | 2016_05 | 2016_06 | 2016_07 | 2016_08 | 2016_09 | 2016_10 | 2016_11 | 2016_12 | 2017_01 | 2017_02 | 2017_03 | 2017_04 | 2017_05 | 2017_06 | 2017_07 | 2017_08 | 2017_09 | 2017_10 | 2017_11 | 2017_12 | 2018_01 | 2018_02 | 2018_03 | 2018_04 | 2018_05 | 2018_06 | 2018_07 | 2018_08 | 2018_09 | 2018_10 | 2018_11 | 2018_12 | 2019_01 | 2019_02 | 2019_03 | 2019_04 | 2019_05 | 2019_06 | 2019_07 | 2019_08 | 2019_09 | 2019_10 | 2019_11 | 2019_12 | 2020_01 | 2020_02 | 2020_03 | 2020_04 | 2020_05 | 2020_06 | 2020_07 | 2020_08 | 2020_09 | 2020_10 | 2020_11 | 2020_12 | 2021_01 | 2021_02 | 2021_03 | 2021_04 | 2021_05 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
267847 | 0.1258471 | 0.1066222 | 0.2293803 | 0.0831130 | 0.0472291 | 0.3384963 | 0.1719201 | 0.5899067 | 0.6928049 | 0.6493834 | 0.4953341 | 0.4961861 | 0.3049411 | 0.2518476 | 0.0537644 | 0.1957048 | 0.2586991 | 0.4995848 | 0.4091685 | 0.6500114 | 0.7165501 | 0.5279150 | 0.6567320 | 0.3424967 | 0.4514693 | 0.0901429 | 0.1360734 | 0.1890924 | 0.2933352 | 0.0930897 | 0.5407569 | 0.5617932 | 0.5612413 | 0.3416005 | 0.6581128 | 0.3902457 | 0.2895282 | 0.4995158 | 0.0756109 | 0.1368246 | 0.2922525 | 0.3330983 | 0.3473100 | 0.3453798 | 0.3252006 | 0.5467526 | 0.5823506 | 0.4155908 | 0.3400275 | 0.0906226 | 0.0109188 | 0.3360478 | 0.1472678 | 0.3908311 | 0.2460810 | 0.6552235 | 0.5270876 | 0.3756698 | 0.6659249 | 0.3807061 | 0.2385949 | 0.1561000 | 0.2037255 | 0.2131417 | 0.1668757 | 0.3566980 | 0.3366054 | 0.4093588 | 0.4151637 | 0.6338996 | 0.5796109 | 0.4962114 | 0.3380627 | 0.2129941 | 0.1497982 | 0.1507107 | 0.2626836 | 0.1650982 | 0.4948174 | 0.5971427 | 0.4441610 | 0.7838318 | 0.4759408 | 0.4527297 | 0.5154772 | 0.1794797 | 0.1645030 | 0.2431840 | 0.4115733 | 0.5684519 | 0.4693378 | 0.5373346 | 0.6038097 | 0.7491623 | 0.4791336 | 0.3079312 | 0.3168190 | 0.2050710 | 0.1331366 | 0.2719072 | 0.2603540 | 0.4374405 | 0.5226590 | 0.7069263 | 0.6520431 | 0.6181098 | 0.5306580 | 0.6567264 | 0.5578275 | 0.2281150 | 0.3876001 | 0.1725591 | 0.2200692 | 0.4211202 | 0.3379284 | 0.2086906 | 0.7437432 | 0.5268391 | 0.3948167 | 0.3426430 | 0.1864559 | 0.2241652 | 0.1930349 | 0.1088820 | 0.3065698 | 0.1499617 | 0.6269324 | 0.6533970 | 0.4719908 | 0.4155228 | 0.7093649 | 0.2395347 | 0.4033240 | 0.4105641 | 0.1644046 | 0.1313090 | 0.1470022 | 0.2015395 | 0.5328532 | 0.4057155 | 0.6773311 | 0.6508635 | 0.3835748 | 0.3608338 | 0.1346818 | 0.0989063 | 0.1876326 | 0.3599186 | 0.2065777 | 0.3416605 | 0.5503016 | 0.2245619 | 0.2786363 | 0.6895414 | 0.3345416 | 0.3384368 | 0.7347342 | 0.2546951 | 0.0789068 | 0.3358597 | 0.2034124 | 0.2313789 | 0.5798241 | 0.6906303 | 0.6977813 | 0.7306239 | 0.2865096 | 0.3878020 | 0.2631609 | 0.2943164 | 0.2653514 | 0.4686905 | 0.3614335 | 0.3075573 | 0.4357900 | 0.4436680 | 0.4630274 | 0.4099583 | 0.4426965 | 0.3304565 | 0.3060642 | 0.1295204 | 0.1385141 | 0.0690759 | 0.2581398 | 0.3433666 | 0.8476980 | 0.5524307 | 0.6428121 | 0.6135572 | 0.3872745 | 0.6914508 | 0.4070049 | 0.4063463 | 0.2021537 | 0.1092644 | 0.1381908 | 0.4717962 | 0.5894028 | 0.6264352 | 0.5369205 | 0.4812799 | 0.6292396 | 0.3547386 | 0.5118440 | 0.2298790 | 0.1563758 | 0.3442996 | 0.4792075 | 0.3286034 | 0.3348625 | 0.4363654 | 0.6007677 | 0.5415169 | 0.4781482 | 0.5422564 | 0.2667023 | 0.1955426 | 0.2890420 | 0.2288287 | 0.2048617 | 0.2878368 | 0.6043518 | 0.5371665 | 0.7128938 | 0.6783124 | 0.4719378 | 0.4364414 | 0.1697154 | 0.3035273 | 0.0798120 | 0.2404646 | 0.2204375 | 0.6126667 | 0.1215987 | 0.6261218 | 0.5577145 | 0.5142868 | 0.7341693 | 0.3218056 | 0.4550553 | 0.1646114 | 0.0422123 | 0.3116624 | 0.0981813 | 0.1603259 | 0.5980756 | 0.4676077 | 0.6906844 | 0.6911135 | 0.7249860 | 0.2859546 | 0.4600493 | 0.2066408 |
267715 | 0.3803689 | 0.4953081 | 0.7406526 | 0.3619543 | 0.3860795 | 0.6294131 | 0.5921026 | 0.6543641 | 0.5615683 | 0.7336177 | 0.7599821 | 0.7662988 | 0.7622109 | 0.5428140 | 0.1843117 | 0.6696398 | 0.7125977 | 0.7518304 | 0.7167495 | 0.4811070 | 0.7590530 | 0.7519214 | 0.7480695 | 0.3540315 | 0.5687980 | 0.6864725 | 0.7345935 | 0.4502956 | 0.4433477 | 0.4180194 | 0.6933325 | 0.5780419 | 0.6528400 | 0.4323639 | 0.6296281 | 0.7366098 | 0.5931745 | 0.6573642 | 0.6284431 | 0.7054363 | 0.6637206 | 0.6949214 | 0.5297132 | 0.5812843 | 0.3473749 | 0.7346623 | 0.7569644 | 0.5946566 | 0.5323520 | 0.7522153 | 0.6657032 | 0.6735419 | 0.5759336 | 0.4047080 | 0.6085081 | 0.7411004 | 0.5692191 | 0.6158311 | 0.7483586 | 0.5676332 | 0.7323827 | 0.7511101 | 0.4347810 | 0.6872249 | 0.5853032 | 0.7861119 | 0.4090078 | 0.6421382 | 0.7532185 | 0.7505715 | 0.6947215 | 0.6387549 | 0.7393597 | 0.6142517 | 0.4656430 | 0.7339821 | 0.7445719 | 0.6845271 | 0.6791663 | 0.6398938 | 0.4964411 | 0.7716882 | 0.7372404 | 0.7326901 | 0.7183756 | 0.6313543 | 0.6935020 | 0.4470375 | 0.6789395 | 0.6017635 | 0.6568784 | 0.6345382 | 0.6301240 | 0.6596071 | 0.7597545 | 0.7212815 | 0.6736704 | 0.7370616 | 0.7110961 | 0.6502936 | 0.7554785 | 0.6480942 | 0.5324999 | 0.7450841 | 0.7300774 | 0.7345454 | 0.5501626 | 0.6067423 | 0.5545308 | 0.7245104 | 0.4872499 | 0.6061149 | 0.5072575 | 0.6001078 | 0.5198085 | 0.3753437 | 0.5137647 | 0.6899447 | 0.6154998 | 0.7555028 | 0.4352412 | 0.6020875 | 0.3549937 | 0.7200402 | 0.7649539 | 0.5381710 | 0.7430649 | 0.7511140 | 0.5933096 | 0.6973152 | 0.7589871 | 0.6210902 | 0.5548609 | 0.5986987 | 0.6353831 | 0.5704029 | 0.7295566 | 0.5767723 | 0.5751059 | 0.5785169 | 0.7430939 | 0.6602786 | 0.5224018 | 0.7557011 | 0.7435826 | 0.3467218 | 0.6595703 | 0.6146256 | 0.7223920 | 0.5835164 | 0.5141358 | 0.7238749 | 0.3815865 | 0.7712997 | 0.6101209 | 0.7889541 | 0.7610474 | 0.4964167 | 0.6056800 | 0.5317398 | 0.6635815 | 0.7638291 | 0.4556492 | 0.7599977 | 0.7656948 | 0.7335353 | 0.6220990 | 0.6460949 | 0.6331232 | 0.6714994 | 0.7289367 | 0.6810383 | 0.6054162 | 0.5694965 | 0.6998549 | 0.5945965 | 0.7162827 | 0.7387602 | 0.7686483 | 0.7389629 | 0.5645342 | 0.5810977 | 0.6882061 | 0.5332808 | 0.4772924 | 0.4175624 | 0.7768647 | 0.7185197 | 0.6955115 | 0.7689456 | 0.7379485 | 0.7601116 | 0.6982134 | 0.7673644 | 0.6575910 | 0.6385709 | 0.7586733 | 0.7091134 | 0.6304874 | 0.7695605 | 0.5582016 | 0.6241372 | 0.7160947 | 0.7543954 | 0.4481445 | 0.7858437 | 0.2301559 | 0.7891467 | 0.6004363 | 0.7490807 | 0.5921217 | 0.6195411 | 0.7377508 | 0.6280348 | 0.7108398 | 0.7629775 | 0.6383976 | 0.6793770 | 0.7627268 | 0.7995757 | 0.7363972 | 0.5567889 | 0.5434169 | 0.6020768 | 0.5832573 | 0.7229834 | 0.5559547 | 0.7036030 | 0.4368655 | 0.4547091 | 0.7743116 | 0.7636283 | 0.6884515 | 0.5059515 | 0.5977126 | 0.7673095 | 0.5883397 | 0.6383568 | 0.7324539 | 0.7150117 | 0.7598670 | 0.7788633 | 0.5691868 | 0.8386500 | 0.6716898 | 0.7849282 | 0.7711988 | 0.6034966 | 0.5957400 | 0.7427678 | 0.7703298 | 0.6671923 | 0.6130629 | 0.7335565 |
267714 | 0.4832253 | 0.7001022 | 0.5119658 | 0.5606434 | 0.4073254 | 0.5019460 | 0.6254296 | 0.7017722 | 0.5415684 | 0.7333316 | 0.7317972 | 0.7520840 | 0.7438636 | 0.5072703 | 0.1411277 | 0.5407146 | 0.5382130 | 0.7298792 | 0.5016331 | 0.5720743 | 0.7139168 | 0.7453774 | 0.7345882 | 0.4419222 | 0.6505530 | 0.6219487 | 0.6781468 | 0.4684619 | 0.3822936 | 0.5035958 | 0.4779235 | 0.5201857 | 0.5009612 | 0.4186213 | 0.5985887 | 0.7388042 | 0.6873236 | 0.5949165 | 0.5822643 | 0.6527109 | 0.5241590 | 0.7474362 | 0.5051515 | 0.5333118 | 0.3345726 | 0.6915054 | 0.7304378 | 0.5521908 | 0.5131022 | 0.7122776 | 0.6498092 | 0.6460512 | 0.5738261 | 0.4680555 | 0.4527810 | 0.7239487 | 0.5711970 | 0.6373602 | 0.7267185 | 0.5809932 | 0.5741698 | 0.7165073 | 0.5083452 | 0.6489635 | 0.5898392 | 0.7456431 | 0.4344001 | 0.6412764 | 0.6082785 | 0.5450215 | 0.7495195 | 0.6824127 | 0.7196606 | 0.5908524 | 0.4731450 | 0.7210342 | 0.6967678 | 0.6541250 | 0.7138851 | 0.5077022 | 0.5623289 | 0.7289053 | 0.7362868 | 0.6383318 | 0.5018267 | 0.6594731 | 0.6828135 | 0.5570596 | 0.6833439 | 0.6025414 | 0.6885842 | 0.6053234 | 0.5752304 | 0.6423074 | 0.7636981 | 0.7161417 | 0.6274074 | 0.7230224 | 0.6431884 | 0.6798402 | 0.7178873 | 0.6177576 | 0.6814353 | 0.6798141 | 0.7164967 | 0.7193025 | 0.5877429 | 0.5503296 | 0.5120105 | 0.7111018 | 0.4502046 | 0.6194145 | 0.4648879 | 0.6956431 | 0.4798481 | 0.2784416 | 0.5132268 | 0.6986545 | 0.5838797 | 0.7638143 | 0.5947384 | 0.6627544 | 0.4267037 | 0.7198342 | 0.7434961 | 0.3976694 | 0.7277696 | 0.7330618 | 0.6692562 | 0.6427289 | 0.7127151 | 0.6767339 | 0.6239269 | 0.5737414 | 0.7147806 | 0.5656886 | 0.7008867 | 0.5131056 | 0.6640644 | 0.5600390 | 0.6999553 | 0.6855488 | 0.4554106 | 0.7462358 | 0.7002122 | 0.3561364 | 0.7047815 | 0.7160888 | 0.7055461 | 0.5866667 | 0.3200547 | 0.6824782 | 0.4257341 | 0.7314172 | 0.5031608 | 0.7737274 | 0.5504660 | 0.4722282 | 0.5227781 | 0.5215142 | 0.6491230 | 0.7005247 | 0.5564200 | 0.6987144 | 0.7148175 | 0.7711282 | 0.5935452 | 0.7339520 | 0.7427342 | 0.6421747 | 0.5624478 | 0.6062445 | 0.5518090 | 0.6143821 | 0.6732137 | 0.6695538 | 0.7034719 | 0.6917796 | 0.7175752 | 0.6567807 | 0.4038758 | 0.5603628 | 0.6483873 | 0.5290865 | 0.4995715 | 0.4336492 | 0.7392876 | 0.6704941 | 0.7022923 | 0.7546397 | 0.7562395 | 0.7604392 | 0.7547077 | 0.7338901 | 0.6112041 | 0.5642493 | 0.6157033 | 0.6757613 | 0.6575307 | 0.7513207 | 0.5979299 | 0.6730503 | 0.7603712 | 0.7526435 | 0.6386701 | 0.7844878 | 0.1559307 | 0.7911018 | 0.5750449 | 0.6710805 | 0.5349989 | 0.6359656 | 0.5406938 | 0.7234538 | 0.7100227 | 0.7581108 | 0.7002782 | 0.6602722 | 0.7215952 | 0.7085735 | 0.7249825 | 0.4203996 | 0.6979436 | 0.5848296 | 0.5695161 | 0.6715075 | 0.5682902 | 0.6587518 | 0.4217949 | 0.5526923 | 0.7206565 | 0.7379491 | 0.6379071 | 0.5235019 | 0.6251909 | 0.7268035 | 0.6124780 | 0.7183365 | 0.7292267 | 0.7301006 | 0.6902454 | 0.7560465 | 0.6799614 | 0.7465114 | 0.6356588 | 0.7718080 | 0.7177662 | 0.7003960 | 0.7438958 | 0.7417671 | 0.7417676 | 0.6287631 | 0.6550280 | 0.6948635 |
267713 | 0.2611426 | 0.3952597 | 0.5831253 | 0.4137798 | 0.3264628 | 0.5114615 | 0.5113319 | 0.4604856 | 0.4882748 | 0.6102145 | 0.5873494 | 0.6427411 | 0.6069465 | 0.4137424 | 0.1235177 | 0.4606529 | 0.5042201 | 0.4665904 | 0.4841545 | 0.4650506 | 0.5160873 | 0.5669175 | 0.5587608 | 0.4001842 | 0.5264497 | 0.3886149 | 0.4817135 | 0.3837391 | 0.3274481 | 0.3176227 | 0.3663595 | 0.3816876 | 0.4981895 | 0.3114367 | 0.4694761 | 0.5955925 | 0.6050789 | 0.5044143 | 0.4524501 | 0.5398530 | 0.3931352 | 0.5687568 | 0.4452681 | 0.4091398 | 0.2589007 | 0.6542674 | 0.5764731 | 0.4299070 | 0.4519315 | 0.5196996 | 0.4653238 | 0.4338787 | 0.4938052 | 0.4213875 | 0.3373146 | 0.6109650 | 0.4104663 | 0.5812605 | 0.5559058 | 0.5039039 | 0.4409546 | 0.6111587 | 0.4691932 | 0.4860886 | 0.5080923 | 0.5870042 | 0.2137108 | 0.4226560 | 0.4346822 | 0.4992716 | 0.5760119 | 0.6600430 | 0.6657764 | 0.5101290 | 0.3982593 | 0.4844986 | 0.5786549 | 0.5681861 | 0.6229075 | 0.5103269 | 0.4132960 | 0.5861939 | 0.6023065 | 0.4139189 | 0.5424094 | 0.4793252 | 0.4591969 | 0.4401011 | 0.5257943 | 0.5578207 | 0.3955604 | 0.4321623 | 0.5262471 | 0.6232731 | 0.4614808 | 0.5079735 | 0.4191965 | 0.5737010 | 0.4000303 | 0.5531973 | 0.6383230 | 0.5164936 | 0.5951695 | 0.5667709 | 0.5005260 | 0.4769976 | 0.4897742 | 0.4956104 | 0.4973722 | 0.4972640 | 0.4227006 | 0.4079544 | 0.3865521 | 0.5790411 | 0.5680041 | 0.2658599 | 0.4893597 | 0.5797191 | 0.6596422 | 0.5595952 | 0.3061600 | 0.4932427 | 0.3003543 | 0.5527586 | 0.5957623 | 0.2844815 | 0.5320678 | 0.5027245 | 0.3520231 | 0.5493377 | 0.5440265 | 0.6110618 | 0.5244377 | 0.4172890 | 0.5406562 | 0.4797075 | 0.5511391 | 0.4639056 | 0.4699818 | 0.4668714 | 0.4362587 | 0.4756033 | 0.3492489 | 0.5881104 | 0.5061626 | 0.4396836 | 0.4793482 | 0.5586082 | 0.5490821 | 0.4716071 | 0.4304907 | 0.5419438 | 0.3765666 | 0.5828046 | 0.4860605 | 0.6458265 | 0.5707886 | 0.3607152 | 0.5105336 | 0.3592214 | 0.4451944 | 0.5409003 | 0.4083132 | 0.6199374 | 0.5592991 | 0.5631707 | 0.5917099 | 0.4617210 | 0.6514323 | 0.4733908 | 0.3836156 | 0.4583426 | 0.4595350 | 0.5264083 | 0.4370705 | 0.4768339 | 0.4894826 | 0.5973861 | 0.5302386 | 0.4823793 | 0.2544456 | 0.4282333 | 0.4425786 | 0.4744442 | 0.4401366 | 0.3553142 | 0.6887315 | 0.5392258 | 0.5964823 | 0.5330818 | 0.5496979 | 0.5990086 | 0.4664280 | 0.5248047 | 0.3679496 | 0.3195691 | 0.3900813 | 0.4946840 | 0.5789605 | 0.4769845 | 0.5162289 | 0.5959813 | 0.6571429 | 0.6503262 | 0.5119481 | 0.7090560 | 0.1125884 | 0.6556543 | 0.5462681 | 0.6425241 | 0.2817638 | 0.4912288 | 0.4450727 | 0.6612452 | 0.5771460 | 0.5355807 | 0.6019515 | 0.5230477 | 0.5716006 | 0.5725053 | 0.5507929 | 0.3970922 | 0.5146845 | 0.5255502 | 0.4929993 | 0.4866550 | 0.4504423 | 0.4718757 | 0.3421840 | 0.5545454 | 0.5246677 | 0.6786721 | 0.5517561 | 0.4510867 | 0.5725778 | 0.5736589 | 0.5031506 | 0.6609797 | 0.5724730 | 0.5800642 | 0.4894794 | 0.6532926 | 0.5931452 | 0.6450694 | 0.5344211 | 0.6635295 | 0.5168172 | 0.6397301 | 0.5598484 | 0.6118920 | 0.4516958 | 0.4708380 | 0.5469277 | 0.5401278 |
267712 | 0.4547167 | 0.6563932 | 0.6053436 | 0.6981080 | 0.3529129 | 0.5398088 | 0.6085082 | 0.6928738 | 0.4622971 | 0.6957133 | 0.6065510 | 0.7229838 | 0.7079386 | 0.5000408 | 0.2164211 | 0.4813102 | 0.6061707 | 0.6959254 | 0.6015372 | 0.4499926 | 0.6966881 | 0.6944158 | 0.6765950 | 0.3699021 | 0.5623374 | 0.4509543 | 0.6227279 | 0.5609844 | 0.3646477 | 0.5124902 | 0.7079290 | 0.4605024 | 0.6629019 | 0.4248891 | 0.6688701 | 0.7037491 | 0.6814740 | 0.6248984 | 0.4587929 | 0.6177842 | 0.5916021 | 0.5358283 | 0.4744387 | 0.4092796 | 0.4373368 | 0.6673012 | 0.6982018 | 0.5588148 | 0.4899277 | 0.6753268 | 0.6437256 | 0.5334671 | 0.5374659 | 0.3357590 | 0.4685315 | 0.6990027 | 0.5303640 | 0.6458344 | 0.6952461 | 0.5673252 | 0.5796429 | 0.6865675 | 0.4975024 | 0.6558357 | 0.5503752 | 0.6480731 | 0.4818044 | 0.6619780 | 0.5271592 | 0.6337712 | 0.6915911 | 0.6847801 | 0.6687710 | 0.6563838 | 0.4670988 | 0.6829228 | 0.6010160 | 0.6281571 | 0.7073068 | 0.5951997 | 0.3880003 | 0.5591632 | 0.6642982 | 0.4601634 | 0.6958184 | 0.6078283 | 0.6301203 | 0.5101771 | 0.5222566 | 0.6135088 | 0.5064167 | 0.5489508 | 0.5414745 | 0.5947770 | 0.6430372 | 0.6453116 | 0.5078971 | 0.4334027 | 0.6394345 | 0.6518868 | 0.6250417 | 0.6608978 | 0.6396908 | 0.6565829 | 0.6944780 | 0.6808007 | 0.5128541 | 0.6977909 | 0.5897025 | 0.6761298 | 0.4754926 | 0.5991706 | 0.4637392 | 0.5608857 | 0.6136113 | 0.4545268 | 0.5404332 | 0.6571622 | 0.7359449 | 0.7247268 | 0.3802720 | 0.5477577 | 0.2870214 | 0.6853293 | 0.6737782 | 0.5708508 | 0.6739561 | 0.6700832 | 0.5964483 | 0.5522502 | 0.6907023 | 0.6965123 | 0.5093285 | 0.5065784 | 0.6919770 | 0.5328795 | 0.6826400 | 0.4485483 | 0.5346657 | 0.5271834 | 0.6948242 | 0.6756233 | 0.5544072 | 0.7129827 | 0.6394886 | 0.4701629 | 0.6790834 | 0.5722380 | 0.6371814 | 0.4828645 | 0.4599259 | 0.6713347 | 0.5026871 | 0.7015773 | 0.6191967 | 0.7128431 | 0.5669962 | 0.5916072 | 0.5578154 | 0.4305320 | 0.6763584 | 0.6923837 | 0.4541859 | 0.6688696 | 0.6955233 | 0.7023767 | 0.7106151 | 0.6399001 | 0.7137238 | 0.6210122 | 0.5425829 | 0.5822155 | 0.6126683 | 0.6285701 | 0.6661381 | 0.6098407 | 0.6499412 | 0.6708413 | 0.6831898 | 0.6703511 | 0.4129413 | 0.5228449 | 0.6661242 | 0.5555670 | 0.5293980 | 0.4005808 | 0.7054160 | 0.6695635 | 0.6659482 | 0.7008768 | 0.7055906 | 0.6792097 | 0.6902622 | 0.6784289 | 0.7014394 | 0.6474046 | 0.5611969 | 0.6158949 | 0.6624151 | 0.7056415 | 0.5649056 | 0.6133915 | 0.7085002 | 0.7181533 | 0.5887969 | 0.7677211 | 0.2118739 | 0.7198706 | 0.5658970 | 0.6994476 | 0.4847050 | 0.6792096 | 0.5601634 | 0.7446912 | 0.6944551 | 0.6780972 | 0.6228193 | 0.6441290 | 0.7209100 | 0.7088233 | 0.6711117 | 0.4722665 | 0.6704764 | 0.5654027 | 0.5939378 | 0.6720047 | 0.5036068 | 0.7215979 | 0.2966610 | 0.5476121 | 0.5691583 | 0.7236997 | 0.5953367 | 0.7341303 | 0.7090694 | 0.6733212 | 0.5919740 | 0.6958376 | 0.7042018 | 0.7088205 | 0.6642962 | 0.7211332 | 0.6410148 | 0.7454240 | 0.5975906 | 0.6819476 | 0.5538669 | 0.6478238 | 0.6524869 | 0.7131571 | 0.6218687 | 0.6486182 | 0.6689903 | 0.6267120 |
0.3 Las unimos
<- merge(x=malla_df, y=tabla, by="Parcela_ID", all.x = TRUE) union
<- head(union,5)
abc kbl(abc) %>%
kable_styling(bootstrap_options = c("striped", "hover")) %>%
kable_paper() %>%
scroll_box(width = "100%", height = "300px")
Parcela_ID | Malla1k | Malla2k | Malla4k | Malla8k | Malla16k | REGION | NOM_REGION | PROVINCIA | NOM_PROVIN | COMUNA | NOM_COMUNA | geometry | 2000_04 | 2000_05 | 2000_06 | 2000_07 | 2000_08 | 2000_09 | 2000_10 | 2000_11 | 2000_12 | 2001_01 | 2001_02 | 2001_03 | 2001_04 | 2001_05 | 2001_06 | 2001_07 | 2001_08 | 2001_09 | 2001_10 | 2001_11 | 2001_12 | 2002_01 | 2002_02 | 2002_03 | 2002_04 | 2002_05 | 2002_06 | 2002_07 | 2002_08 | 2002_09 | 2002_10 | 2002_11 | 2002_12 | 2003_01 | 2003_02 | 2003_03 | 2003_04 | 2003_05 | 2003_06 | 2003_07 | 2003_08 | 2003_09 | 2003_10 | 2003_11 | 2003_12 | 2004_01 | 2004_02 | 2004_03 | 2004_04 | 2004_05 | 2004_06 | 2004_07 | 2004_08 | 2004_09 | 2004_10 | 2004_11 | 2004_12 | 2005_01 | 2005_02 | 2005_03 | 2005_04 | 2005_05 | 2005_06 | 2005_07 | 2005_08 | 2005_09 | 2005_10 | 2005_11 | 2005_12 | 2006_01 | 2006_02 | 2006_03 | 2006_04 | 2006_05 | 2006_06 | 2006_07 | 2006_08 | 2006_09 | 2006_10 | 2006_11 | 2006_12 | 2007_01 | 2007_02 | 2007_03 | 2007_04 | 2007_05 | 2007_06 | 2007_07 | 2007_08 | 2007_09 | 2007_10 | 2007_11 | 2007_12 | 2008_01 | 2008_02 | 2008_03 | 2008_04 | 2008_05 | 2008_06 | 2008_07 | 2008_08 | 2008_09 | 2008_10 | 2008_11 | 2008_12 | 2009_01 | 2009_02 | 2009_03 | 2009_04 | 2009_05 | 2009_06 | 2009_07 | 2009_08 | 2009_09 | 2009_10 | 2009_11 | 2009_12 | 2010_01 | 2010_02 | 2010_03 | 2010_04 | 2010_05 | 2010_06 | 2010_07 | 2010_08 | 2010_09 | 2010_10 | 2010_11 | 2010_12 | 2011_01 | 2011_02 | 2011_03 | 2011_04 | 2011_05 | 2011_06 | 2011_07 | 2011_08 | 2011_09 | 2011_10 | 2011_11 | 2011_12 | 2012_01 | 2012_02 | 2012_03 | 2012_04 | 2012_05 | 2012_06 | 2012_07 | 2012_08 | 2012_09 | 2012_10 | 2012_11 | 2012_12 | 2013_01 | 2013_02 | 2013_03 | 2013_04 | 2013_05 | 2013_06 | 2013_07 | 2013_08 | 2013_09 | 2013_10 | 2013_11 | 2013_12 | 2014_01 | 2014_02 | 2014_03 | 2014_04 | 2014_05 | 2014_06 | 2014_07 | 2014_08 | 2014_09 | 2014_10 | 2014_11 | 2014_12 | 2015_01 | 2015_02 | 2015_03 | 2015_04 | 2015_05 | 2015_06 | 2015_07 | 2015_08 | 2015_09 | 2015_10 | 2015_11 | 2015_12 | 2016_01 | 2016_02 | 2016_03 | 2016_04 | 2016_05 | 2016_06 | 2016_07 | 2016_08 | 2016_09 | 2016_10 | 2016_11 | 2016_12 | 2017_01 | 2017_02 | 2017_03 | 2017_04 | 2017_05 | 2017_06 | 2017_07 | 2017_08 | 2017_09 | 2017_10 | 2017_11 | 2017_12 | 2018_01 | 2018_02 | 2018_03 | 2018_04 | 2018_05 | 2018_06 | 2018_07 | 2018_08 | 2018_09 | 2018_10 | 2018_11 | 2018_12 | 2019_01 | 2019_02 | 2019_03 | 2019_04 | 2019_05 | 2019_06 | 2019_07 | 2019_08 | 2019_09 | 2019_10 | 2019_11 | 2019_12 | 2020_01 | 2020_02 | 2020_03 | 2020_04 | 2020_05 | 2020_06 | 2020_07 | 2020_08 | 2020_09 | 2020_10 | 2020_11 | 2020_12 | 2021_01 | 2021_02 | 2021_03 | 2021_04 | 2021_05 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | 0 | 0 | 0 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-68.73185 -56.5077) | 0.3973215 | 0.2146300 | 0.1518731 | 0.1393840 | 0.0448156 | 0.0303526 | 0.5459300 | 0.4028059 | 0.2001724 | 0.3319951 | 0.6872389 | 0.4537359 | 0.4895110 | 0.3271727 | 0.2436677 | 0.0331593 | 0.1863969 | 0.3631693 | 0.0145289 | 0.5584424 | 0.3649698 | 0.3358672 | 0.4191244 | 0.1568334 | 0.1994133 | 0.2346375 | 0.0002681 | 0.0001796 | 0.3805019 | 0.4263387 | 0.4147148 | 0.2428569 | 0.5127967 | 0.4026468 | 0.3711418 | 0.3902935 | 0.1865722 | 0.2550929 | -0.1130332 | 0.1014110 | 0.3680592 | 0.1588193 | 0.3258201 | 0.3218594 | 0.1253790 | 0.2030271 | 0.4203821 | 0.5297751 | 0.1342806 | 0.3247042 | -0.0724159 | 0.1991210 | 0.2560700 | 0.1820745 | 0.3002679 | 0.4891661 | 0.4670699 | 0.3644476 | 0.2783649 | 0.4492001 | 0.3218165 | 0.1194264 | 0.1451221 | 0.2518471 | 0.1694565 | 0.5055332 | 0.4942373 | 0.2613541 | 0.4648265 | 0.6763652 | 0.3948718 | 0.3611051 | 0.4909779 | 0.2094595 | 0.2665684 | 0.3568725 | 0.3114973 | 0.1482260 | 0.5061330 | 0.3183820 | 0.5237706 | 0.3795621 | 0.5396512 | 0.1976682 | 0.2630415 | 0.2670577 | 0.0314706 | 0.1437885 | 0.2595116 | -0.0141670 | 0.0756519 | 0.5309498 | 0.4077301 | 0.4411156 | 0.4931130 | 0.1842254 | 0.4737489 | 0.2094096 | 0.1533994 | 0.2308918 | 0.3475128 | 0.1972657 | 0.2328706 | 0.4251827 | 0.4115110 | 0.6350197 | 0.2698338 | 0.2983661 | 0.5039750 | 0.2758114 | 0.1713811 | 0.0693439 | 0.1540578 | 0.0729030 | 0.2413731 | 0.3408315 | 0.5085428 | 0.5676711 | 0.4715877 | 0.3311237 | 0.5082301 | 0.1137091 | 0.1253027 | 0.0555896 | 0.2718761 | 0.3315076 | 0.1955967 | 0.3675182 | 0.1896015 | 0.4172126 | 0.2734840 | 0.4861871 | 0.0262251 | 0.2319362 | 0.1191576 | 0.1992612 | 0.4483174 | 0.3389156 | 0.1455103 | 0.3602508 | 0.3436535 | 0.2392478 | 0.7158683 | 0.4739185 | 0.3733273 | 0.2233478 | 0.0018651 | -0.1801725 | 0.3657100 | 0.2762284 | 0.0744593 | 0.1590244 | 0.1831221 | 0.2423926 | 0.3815734 | 0.3100812 | 0.2604021 | -0.0066088 | 0.0337845 | 0.0423953 | 0.2279281 | 0.4315422 | 0.4557948 | 0.3356753 | 0.0369608 | 0.4279975 | 0.4169388 | 0.0726285 | 0.4309376 | 0.1556493 | 0.1418307 | 0.3342667 | 0.4257647 | 0.3344239 | 0.4290860 | 0.3683859 | 0.2877634 | 0.1323857 | 0.4592455 | 0.6521953 | 0.2347886 | 0.3299306 | 0.1409166 | 0.0791857 | 0.2433861 | 0.3570259 | 0.3677760 | 0.0981448 | 0.6642106 | 0.3157753 | 0.1756666 | 0.4671720 | 0.3853311 | 0.3441328 | -0.0191278 | 0.1694000 | -0.0274727 | 0.4050136 | 0.2452453 | 0.0302496 | 0.2337385 | 0.2422648 | 0.4410334 | 0.2757591 | 0.1516334 | 0.1685713 | 0.0506467 | 0.1449733 | 0.2266760 | 0.2240800 | 0.1281162 | 0.3309761 | 0.2698140 | 0.2168590 | 0.3882581 | 0.6270700 | 0.4951232 | 0.0279726 | 0.0767755 | 0.2206375 | 0.2159663 | 0.4740904 | 0.4052665 | 0.5697842 | 0.3079102 | 0.5476224 | 0.2220436 | 0.3373755 | 0.4636123 | 0.1747648 | -0.0222014 | -0.0036558 | 0.3276795 | 0.1719980 | 0.2828249 | 0.3308627 | 0.5089225 | 0.4605694 | 0.2645424 | 0.4375688 | 0.3419004 | 0.3237963 | -0.0717229 | 0.1293134 | 0.1282168 | 0.2326074 | 0.5852037 | 0.1452783 | 0.2807197 | 0.4869900 | 0.2582437 | 0.1624982 | 0.3086590 | 0.0923483 |
3 | 1 | 0 | 0 | 0 | 0 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.27731 -55.97484) | 0.2019121 | 0.2971516 | 0.2732316 | -0.1228680 | 0.1145698 | 0.2101227 | 0.3817056 | 0.2048071 | 0.1565023 | 0.4894629 | 0.4644592 | 0.2590545 | 0.4000604 | 0.4199428 | -0.1372478 | -0.0521884 | 0.1293602 | 0.4097144 | 0.5174862 | 0.5495389 | 0.4200448 | 0.3307449 | 0.3695115 | 0.2410675 | 0.2526246 | 0.1896384 | -0.0313977 | 0.0589065 | 0.2544328 | 0.6261229 | 0.2493143 | 0.3978083 | 0.3558161 | 0.3089245 | 0.4351968 | 0.4041951 | 0.0327788 | 0.1007594 | 0.0455593 | 0.2233590 | 0.3168871 | 0.2787922 | 0.4398955 | 0.3055702 | 0.1155201 | 0.2820437 | 0.3461594 | 0.3872437 | 0.2916330 | 0.5656996 | 0.0933890 | 0.2522264 | 0.3796747 | 0.3037615 | 0.1667846 | 0.3298210 | 0.3620471 | 0.4882937 | 0.3117957 | 0.2256261 | 0.1692073 | 0.2968934 | 0.0406197 | 0.2034765 | 0.1904050 | 0.4161870 | 0.6539698 | 0.3215595 | 0.2459480 | 0.4030388 | 0.4880761 | 0.2949579 | 0.2702498 | 0.1225843 | 0.3989988 | 0.0595549 | 0.2495136 | 0.0211354 | 0.6471679 | 0.3956292 | 0.3897551 | 0.2909186 | 0.1539061 | 0.2182016 | 0.2128887 | 0.1124244 | 0.0005326 | 0.0023111 | 0.1440825 | -0.0291773 | 0.1114783 | 0.2968038 | 0.2432001 | 0.4042704 | 0.5711961 | 0.3068095 | 0.3055968 | 0.2647724 | 0.0581169 | 0.0930685 | 0.3028010 | 0.3705021 | 0.2962695 | 0.4974354 | 0.2798482 | 0.1679209 | 0.2480307 | 0.2730406 | 0.0654864 | -0.0705705 | 0.0575625 | 0.0612765 | 0.1489575 | 0.4213479 | 0.3406918 | 0.1232852 | 0.1873140 | 0.4501258 | 0.5873255 | 0.2882554 | 0.3461648 | 0.4050584 | -0.0088314 | 0.2817274 | 0.2867134 | 0.6508061 | 0.5735008 | 0.5125513 | 0.3853793 | 0.2512615 | 0.3982383 | 0.4768272 | 0.2549323 | 0.3445160 | 0.0365716 | 0.2114923 | 0.5014066 | 0.3344937 | 0.1587099 | 0.6633649 | 0.3369069 | 0.6219262 | 0.4190660 | 0.3817759 | 0.1564075 | 0.3566276 | -0.0577256 | 0.0234765 | 0.4689167 | 0.3886219 | 0.4782299 | 0.0296728 | 0.3452405 | 0.2811309 | 0.1445903 | 0.3815596 | 0.4796174 | 0.2112006 | 0.2109464 | -0.0110200 | -0.1701647 | 0.4504696 | 0.3096207 | 0.4182698 | 0.3126968 | 0.3522675 | 0.3657465 | 0.2599567 | 0.6066660 | 0.2896263 | 0.0616528 | 0.0161947 | 0.3114125 | 0.4269470 | 0.3355842 | 0.3833872 | 0.5758890 | 0.3886679 | 0.5759244 | 0.4597330 | 0.2874912 | 0.0385521 | 0.0480288 | 0.0946252 | 0.2254717 | 0.3700892 | 0.2436418 | 0.0837234 | 0.3842109 | 0.2853101 | 0.3410858 | 0.3436788 | 0.2296640 | 0.5591251 | 0.1038806 | 0.2535412 | 0.1399396 | 0.4243903 | 0.4037636 | 0.0351992 | 0.3870823 | 0.0985848 | 0.4374083 | 0.1904091 | 0.6396176 | 0.2919373 | 0.0189989 | 0.2940528 | 0.3383030 | 0.2888318 | 0.1768165 | 0.4291083 | 0.3992519 | 0.2187813 | 0.5117244 | 0.6595101 | 0.5110434 | 0.0430894 | 0.0701634 | 0.1209643 | 0.5755160 | 0.3714485 | 0.5472094 | 0.3928012 | 0.4043454 | 0.4245811 | 0.2442293 | 0.3021642 | 0.2783264 | 0.1368737 | -0.0274474 | 0.2249399 | 0.3898091 | 0.1519554 | 0.3759555 | 0.4123799 | 0.3723719 | 0.0724137 | 0.3528258 | 0.5036645 | 0.5834818 | 0.4095579 | 0.1590591 | 0.2396069 | 0.3159101 | 0.1781152 | 0.4375727 | 0.3005522 | 0.3572342 | 0.4170505 | 0.5285963 | 0.3184377 | 0.1928311 | 0.0651535 |
4 | 1 | 0 | 0 | 0 | 0 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.2613 -55.97462) | 0.4162234 | 0.2025857 | 0.1735186 | -0.0197602 | 0.1645573 | 0.2767906 | 0.2668369 | 0.2511674 | 0.1937621 | 0.4018884 | 0.3910433 | 0.4815724 | 0.3016684 | 0.4884604 | 0.0586402 | 0.1218484 | 0.1393796 | 0.3967762 | 0.2295831 | 0.4779049 | 0.3532710 | 0.2975117 | 0.4770423 | 0.2897362 | 0.1377883 | 0.1471952 | -0.0578604 | 0.1953101 | 0.4539105 | 0.4517489 | 0.3488187 | 0.2714277 | 0.4396646 | 0.2963782 | 0.3384434 | 0.3632728 | 0.0534471 | 0.0731780 | -0.1133891 | 0.1528272 | 0.4516405 | 0.2009545 | 0.4913585 | 0.3092163 | 0.1733011 | 0.3475065 | 0.1680320 | 0.4038504 | 0.2620144 | 0.4060350 | 0.2036341 | 0.2561303 | 0.2741537 | 0.1224462 | 0.1498313 | 0.4148271 | 0.2972855 | 0.4684377 | 0.2096325 | 0.3728585 | 0.1895005 | 0.3768938 | 0.1374931 | 0.0849607 | 0.3309753 | 0.4729100 | 0.5656573 | 0.2103767 | 0.4272800 | 0.5890484 | 0.3727634 | 0.3465151 | 0.2938517 | 0.2300820 | 0.2026260 | 0.1943121 | 0.0875613 | 0.0800543 | 0.5648299 | 0.1944477 | 0.5507130 | 0.3476895 | 0.1468913 | 0.1704008 | 0.2591754 | 0.2196747 | 0.0611376 | -0.0324387 | 0.2750284 | 0.2662202 | 0.1763547 | 0.5610960 | 0.2344482 | 0.3759716 | 0.4821886 | 0.3532732 | 0.1616024 | 0.3479441 | 0.2534806 | 0.1171156 | 0.2459247 | 0.4287559 | 0.2195451 | 0.3269073 | 0.3241518 | 0.2565483 | 0.4473748 | 0.4171066 | 0.1447974 | 0.2998891 | 0.1613764 | -0.0316785 | 0.2415949 | 0.2069409 | 0.1015921 | 0.1170308 | 0.4048401 | 0.4327822 | 0.4795597 | 0.3748139 | 0.1941790 | 0.3649777 | -0.0166131 | 0.1800746 | 0.2356589 | 0.2421442 | 0.4536588 | 0.6656566 | 0.3451194 | 0.2156983 | 0.4799551 | 0.3575991 | 0.2159931 | 0.2781163 | 0.0417069 | 0.1745050 | 0.3965986 | 0.6107379 | 0.0988127 | 0.5971555 | 0.3073514 | 0.4717472 | 0.3945646 | 0.5069222 | 0.2973585 | 0.1431391 | -0.0451094 | -0.0004906 | 0.4424000 | 0.3695359 | 0.4086704 | 0.1719239 | 0.4992893 | 0.1893986 | 0.3533438 | 0.2456813 | 0.3891798 | 0.1626676 | 0.1305303 | -0.0422863 | 0.8659988 | 0.3900797 | 0.2253034 | 0.3690738 | 0.1854153 | 0.3718287 | 0.3257415 | 0.2076000 | 0.5306393 | 0.3213157 | 0.2172169 | 0.0879881 | 0.3539237 | 0.3105684 | 0.2760615 | 0.3721038 | 0.4795282 | 0.4503834 | 0.6388310 | 0.3076726 | 0.3465133 | 0.1720632 | 0.1372819 | 0.2063729 | 0.4319781 | 0.2793002 | 0.2763068 | 0.0524451 | 0.5069813 | 0.2735591 | 0.2379185 | 0.2180723 | 0.2092012 | 0.2619640 | 0.0752278 | 0.2181053 | 0.2265883 | 0.4521530 | 0.2773859 | 0.0139194 | 0.2537756 | 0.2365920 | 0.5174412 | 0.5189791 | 0.3289248 | 0.1169380 | -0.1026340 | 0.1961677 | 0.4371607 | 0.0670942 | 0.1518921 | 0.4373925 | 0.3161797 | 0.3141525 | 0.3449994 | 0.4821819 | 0.4194645 | 0.3657581 | -0.0425722 | 0.0424988 | 0.3822291 | 0.4501493 | 0.2641494 | 0.4928803 | 0.3732395 | 0.3986183 | 0.3330801 | 0.4841522 | 0.3755184 | 0.1570252 | 0.0686311 | 0.2196135 | 0.2786346 | 0.0968261 | 0.4229150 | 0.3910553 | 0.2975336 | 0.3437383 | 0.3758527 | 0.1519492 | 0.5962982 | 0.3361025 | 0.0484126 | 0.1177819 | 0.3745731 | 0.1835015 | 0.4836402 | 0.3943186 | 0.3414994 | 0.4892670 | 0.6177906 | 0.1827967 | 0.1807829 | 0.1086822 |
5 | 1 | 2 | 0 | 0 | 0 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.30974 -55.96631) | 0.1477981 | 0.0656941 | 0.1962903 | -0.0654091 | 0.2110435 | 0.0773423 | 0.2625395 | 0.3560966 | 0.2872638 | 0.4389614 | 0.4128580 | 0.4545379 | 0.2017083 | 0.4075305 | 0.1984363 | 0.0566458 | 0.1495790 | 0.3429517 | 0.0994682 | 0.4292413 | 0.3835605 | 0.1836092 | 0.4609039 | 0.2510787 | 0.0503131 | 0.0768998 | 0.0585701 | 0.0737072 | 0.2813639 | 0.5546392 | 0.2770585 | 0.3422130 | 0.3022594 | 0.2795102 | 0.2077028 | 0.5571283 | 0.0344449 | -0.1404897 | -0.1320342 | 0.0958548 | 0.2530484 | 0.1869264 | 0.3253092 | 0.1288866 | 0.2460639 | 0.2118131 | 0.2756183 | 0.2872131 | 0.3868125 | 0.1544910 | 0.1311177 | 0.1777579 | 0.0590240 | 0.0676505 | 0.1620725 | 0.2863651 | 0.3751576 | 0.3103259 | 0.3792233 | 0.2879936 | 0.1024096 | 0.2978728 | 0.1948688 | 0.2321656 | 0.3658547 | 0.5701537 | 0.3853054 | 0.2005046 | 0.4577830 | 0.2734210 | 0.3966551 | 0.1560800 | 0.1209014 | 0.0829080 | 0.3007721 | 0.1747245 | 0.1299877 | 0.1901685 | 0.4546789 | 0.1924901 | 0.4640783 | 0.3591947 | 0.1420366 | 0.1313524 | 0.3032855 | 0.0381654 | 0.0430562 | -0.0762165 | 0.0781917 | 0.2930430 | 0.1570067 | 0.3509932 | 0.2166983 | 0.2675476 | 0.4652920 | 0.2727329 | 0.0283233 | 0.2172140 | 0.1181368 | 0.0998209 | 0.1162061 | 0.3599249 | 0.0548240 | 0.2530183 | 0.2732610 | 0.0963627 | 0.4737621 | 0.0807874 | 0.1469325 | 0.1312603 | 0.1046754 | -0.0714802 | 0.2776123 | 0.1386712 | 0.0230935 | 0.0867508 | 0.3748703 | 0.2677570 | 0.5367888 | 0.1887717 | 0.0449282 | 0.0950541 | -0.0330587 | 0.1928789 | 0.2014941 | 0.3973930 | 0.2727389 | 0.2349020 | 0.0213552 | 0.2372432 | 0.2494236 | 0.2558674 | 0.1215504 | 0.0952898 | -0.1627322 | 0.0622808 | 0.2169484 | 0.5715218 | 0.0190964 | 0.4582819 | 0.1683133 | 0.6226279 | 0.2941116 | 0.3833341 | 0.2992290 | 0.1025045 | -0.0354195 | -0.0904778 | 0.1725425 | 0.3459773 | 0.0099407 | 0.0430800 | 0.3814077 | 0.1077198 | 0.3464760 | 0.3001665 | 0.0873866 | 0.0566293 | 0.1874889 | -0.0775135 | 0.0023186 | 0.1502231 | 0.0944922 | 0.3334643 | 0.3096258 | 0.3336789 | 0.1870312 | 0.0706755 | 0.2535951 | 0.1875569 | 0.1384856 | 0.0485921 | 0.3353146 | 0.5625567 | 0.3027347 | 0.2554033 | 0.3905493 | 0.3289209 | 0.4098206 | 0.3142466 | 0.3213671 | -0.1556059 | -0.0046485 | 0.1414770 | -0.0154947 | 0.1250254 | 0.3092473 | 0.2473853 | 0.4122152 | 0.1101487 | 0.2048991 | 0.1328227 | 0.1195678 | 0.0856742 | -0.0282742 | 0.1283694 | 0.1456963 | 0.2868395 | 0.2374425 | 0.0338649 | 0.2875977 | 0.3367367 | 0.4354162 | 0.3510065 | 0.7741704 | -0.0230350 | -0.1452779 | 0.0765759 | 0.3485821 | 0.1007402 | 0.1136774 | 0.3287523 | 0.2519391 | 0.1833120 | 0.3294384 | 0.5071044 | 0.1960800 | 0.0030013 | 0.1238960 | 0.1114289 | 0.1786952 | 0.4135876 | 0.2352873 | 0.2721779 | 0.2357064 | 0.2545760 | 0.2707192 | 0.3151855 | 0.0894588 | 0.0732311 | 0.0319388 | 0.3784596 | 0.1992783 | 0.0289177 | 0.2439770 | 0.2649565 | 0.4139887 | 0.2398195 | 0.4190091 | 0.4915136 | 0.2548729 | 0.1184995 | -0.0679935 | 0.0817764 | 0.0394948 | 0.3002861 | 0.3394981 | 0.1774335 | 0.3602765 | 0.1873765 | 0.1282666 | 0.1585262 | 0.0377919 | 0.0096649 |
6 | 1 | 0 | 0 | 0 | 0 | 12 | REGIÓN DE MAGALLANES Y DE LA ANTÁRTICA CHILENA | 122 | ANTÁRTICA CHILENA | 12201 | CABO DE HORNOS | POINT (-67.29373 -55.96609) | 0.1906805 | 0.3584509 | 0.3482276 | 0.0855483 | 0.3219249 | 0.2617323 | 0.6957904 | 0.4802160 | 0.4166921 | 0.4757008 | 0.6709570 | 0.4887578 | 0.5291415 | 0.5834994 | 0.1788618 | 0.1245604 | 0.2623426 | 0.6581216 | 0.4801801 | 0.5670594 | 0.5931260 | 0.4610963 | 0.6828671 | 0.3322658 | 0.2888779 | 0.3258281 | 0.0146016 | 0.3504415 | 0.5474098 | 0.6932551 | 0.4095198 | 0.3920779 | 0.4735823 | 0.4880317 | 0.4478168 | 0.6675137 | 0.4026553 | 0.3329979 | 0.0024331 | 0.3556137 | 0.5859901 | 0.4437301 | 0.6770514 | 0.3967957 | 0.3812667 | 0.4682120 | 0.5059573 | 0.6149679 | 0.5591344 | 0.3830025 | 0.2142930 | 0.4363937 | 0.3267762 | 0.2800291 | 0.3140503 | 0.6366462 | 0.6260611 | 0.5491301 | 0.6579889 | 0.3813239 | 0.2929524 | 0.3886213 | 0.3216357 | 0.3304597 | 0.6229272 | 0.6313913 | 0.7519313 | 0.3777347 | 0.5437608 | 0.5396510 | 0.6055500 | 0.2906795 | 0.3453460 | 0.4026211 | 0.3926840 | 0.3142011 | 0.2968823 | 0.4667527 | 0.7076901 | 0.4626266 | 0.7206722 | 0.6576200 | 0.2525479 | 0.2589020 | 0.6547194 | 0.2948658 | 0.3103515 | 0.2853155 | 0.4129342 | 0.4630284 | 0.2942922 | 0.6619200 | 0.3164595 | 0.4374352 | 0.6327345 | 0.5299772 | 0.5884207 | 0.5654488 | 0.3623458 | 0.2287222 | 0.2629798 | 0.5690254 | 0.4329121 | 0.5537809 | 0.3839245 | 0.2376152 | 0.5191963 | 0.4416137 | 0.4241623 | 0.2946303 | 0.1616533 | 0.1604789 | 0.4127760 | 0.3147743 | 0.4860878 | 0.1776260 | 0.4693545 | 0.6082152 | 0.6224236 | 0.4335715 | 0.3983586 | 0.3481432 | 0.1525111 | 0.1537928 | 0.5525616 | 0.7230522 | 0.5774204 | 0.4710200 | 0.5635137 | 0.4436531 | 0.4461823 | 0.5102766 | 0.2885078 | 0.2056151 | 0.0835178 | 0.2447335 | 0.4293252 | 0.7174560 | 0.1161360 | 0.7159871 | 0.2958138 | 0.5872920 | 0.3045805 | 0.5671707 | 0.5052515 | 0.3432086 | -0.0306744 | 0.0130432 | 0.5653160 | 0.4694101 | 0.4032983 | 0.1552466 | 0.5532779 | 0.2667658 | 0.6672541 | 0.4956377 | 0.3709511 | 0.0803872 | 0.2613400 | 0.0803173 | 0.0349058 | 0.5277045 | 0.4363455 | 0.6023725 | 0.2512571 | 0.5308812 | 0.4004334 | 0.2779965 | 0.4647961 | 0.4740974 | 0.1985909 | 0.4468327 | 0.3995830 | 0.6016818 | 0.3144113 | 0.5301095 | 0.6006650 | 0.4844457 | 0.6755843 | 0.5762751 | 0.4718948 | 0.0840481 | -0.0259051 | 0.2575366 | 0.5572850 | 0.5000153 | 0.4920087 | 0.3809356 | 0.5924106 | 0.4116322 | 0.3167891 | 0.3867258 | 0.2018285 | 0.3801816 | 0.0864503 | 0.3888329 | 0.3813658 | 0.4984243 | 0.5209593 | 0.1121291 | 0.4609805 | 0.4753214 | 0.5665568 | 0.5029179 | 0.6720954 | 0.4241511 | 0.2308727 | 0.1386340 | 0.3421921 | 0.4358511 | 0.2679468 | 0.5611614 | 0.4131956 | 0.4153092 | 0.5784667 | 0.7300670 | 0.5165224 | 0.4454621 | 0.2572732 | 0.2289749 | 0.3555341 | 0.5213309 | 0.6151390 | 0.5940902 | 0.4818980 | 0.5177854 | 0.5629594 | 0.3074280 | 0.6734643 | 0.2450678 | 0.0695398 | 0.4951354 | 0.5159559 | 0.2536003 | 0.5306916 | 0.4752865 | 0.4063421 | 0.3038760 | 0.5268801 | 0.5413257 | 0.6055988 | 0.2878919 | 0.0692112 | 0.2499027 | 0.3108495 | 0.4529144 | 0.6631094 | 0.3555360 | 0.6626591 | 0.3375255 | 0.4750578 | 0.2392058 | 0.2782892 | 0.1619685 |
0.4 Generamos los summary por comuna para los tres primeros campos
<- unique(union$COMUNA) codigos_comunales_unicos
<- data.frame()
receptaculo
for (i in codigos_comunales_unicos){
<- paste(i,sep = " ")
comuna
<- filter(union, union$COMUNA == i)
union_2
<- sapply(union_2[,c(14:16)], summary)
f <- cbind(Descriptor = rownames(f), f)
myDF <- as.data.frame(myDF)
myDF rownames(myDF) <- NULL
2:4] <- sapply(myDF[,2:4],as.numeric)
myDF[,<- cbind(comuna,myDF)
g <- rbind(receptaculo,g)
receptaculo }
head(receptaculo,50)
## comuna Descriptor 2000_04 2000_05 2000_06
## 1 12201 Min. -2.01806617 -0.54966426 -0.491912097
## 2 12201 1st Qu. 0.04996427 -0.04596014 -0.124268159
## 3 12201 Median 0.22442935 0.13483280 -0.043583713
## 4 12201 Mean 0.24394156 0.15867180 -0.014704755
## 5 12201 3rd Qu. 0.41489339 0.36167967 0.089083046
## 6 12201 Max. 0.82054698 0.78915685 0.583380342
## 7 12303 Min. -6.06173420 -0.58330947 -0.575824976
## 8 12303 1st Qu. 0.19072670 -0.01759856 -0.097421117
## 9 12303 Median 0.51337516 0.32199919 0.045286998
## 10 12303 Mean 0.39241141 0.24202600 0.061724728
## 11 12303 3rd Qu. 0.61449558 0.46795723 0.240906239
## 12 12303 Max. 4.04266167 0.80132937 0.623277545
## 13 12101 Min. -1.94184434 -0.75267738 -0.646758914
## 14 12101 1st Qu. 0.16336109 0.12504328 -0.081886519
## 15 12101 Median 0.28391737 0.25296962 0.007083424
## 16 12101 Mean 0.31143591 0.24878770 0.042654777
## 17 12101 3rd Qu. 0.48028603 0.38645808 0.157741144
## 18 12101 Max. 0.81550252 0.72332150 0.606460154
## 19 12301 Min. -1.23459888 -0.88348782 -0.421747655
## 20 12301 1st Qu. 0.43701330 0.43992195 0.175765276
## 21 12301 Median 0.50132233 0.48111242 0.242253751
## 22 12301 Mean 0.49101642 0.46564700 0.231396906
## 23 12301 3rd Qu. 0.56216359 0.51435977 0.298739284
## 24 12301 Max. 0.87201881 0.64714450 0.537956953
## 25 12103 Min. -2.70194721 -0.50665307 -0.477149546
## 26 12103 1st Qu. 0.10613902 0.13124044 -0.105105609
## 27 12103 Median 0.27683212 0.36096762 -0.007391960
## 28 12103 Mean 0.27922360 0.30509381 0.035440034
## 29 12103 3rd Qu. 0.44600657 0.49178997 0.152407873
## 30 12103 Max. 12.44869900 0.76072735 0.648841321
## 31 12302 Min. -0.63935572 -0.30070654 -0.371516764
## 32 12302 1st Qu. 0.44598103 0.42393440 0.234400734
## 33 12302 Median 0.50655955 0.46117246 0.273443192
## 34 12302 Mean 0.48563675 0.44865249 0.264731783
## 35 12302 3rd Qu. 0.54389006 0.48987737 0.309250653
## 36 12302 Max. 0.63550937 0.59329003 0.435938329
## 37 12401 Min. -11.61976528 -10.18087578 -0.545801401
## 38 12401 1st Qu. 0.01362163 0.11465185 -0.085872464
## 39 12401 Median 0.10907979 0.36437675 -0.000383731
## 40 12401 Mean 0.13006119 0.30422515 0.029902243
## 41 12401 3rd Qu. 0.23132343 0.52170461 0.140684597
## 42 12401 Max. 2.71685123 3.20945501 0.671299875
## 43 12102 Min. -0.42114845 -0.48842767 -0.457429409
## 44 12102 1st Qu. 0.35631411 0.41953727 0.176798146
## 45 12102 Median 0.42056766 0.45680532 0.242843725
## 46 12102 Mean 0.42591639 0.44100066 0.230521135
## 47 12102 3rd Qu. 0.52727963 0.50044581 0.303638212
## 48 12102 Max. 0.68849862 0.62730569 0.527805388
## 49 12104 Min. -0.39366624 -0.41169241 -0.334096134
## 50 12104 1st Qu. 0.37923446 0.44469649 0.215079784
0.5 Guardar
write_xlsx(receptaculo,"stats_indice_ndgi.xlsx")
0.5.1 codigo importante 1
# f <- sapply(union[,c(14:40)], summary)
# myDF <- cbind(Descriptor = rownames(f), f)
# myDF <- as.data.frame(myDF)
# rownames(myDF) <- NULL
# myDF[,2:4] <- sapply(myDF[,2:4],as.numeric)
# myDF
0.5.2 codigo importante 2
# codigos_comunales_unicos <- unique(union$COMUNA)
# codigos_comunales_unicos
#
# receptaculo <- data.frame()
# for (i in codigos_comunales_unicos){
# comuna <- paste(i,sep = " ")
# t <- summary(union[,14:16])
# g <- cbind(comuna,t)
# receptaculo <- rbind(receptaculo,g)
# }
0.6 filtros por Provincia:
0.7 Guardar
0.8 filtros por Región:
0.9 Guardar
1 Lectura tabla 2
http://ide.dataintelligence-group.com/descargas_gee/consolidado_suelos_por_banda.csv
2 Lectura tabla 3
http://ide.dataintelligence-group.com/descargas_gee/indice_ndgi.csv
3 Lectura tabla 4
http://ide.dataintelligence-group.com/descargas_gee/indice_ndsi.csv