Se van a comprarar dos softwares para la autocorrelación espacial al calcular Indice de Moran
library(readxl)
df <- read_excel("./BD_MODELADO.xlsx")
library(DT)
Registered S3 methods overwritten by 'htmltools':
method from
print.html tools:rstudio
print.shiny.tag tools:rstudio
print.shiny.tag.list tools:rstudio
Registered S3 method overwritten by 'htmlwidgets':
method from
print.htmlwidget tools:rstudio
datatable(df, class='cell-border stripe', filter='top', options = list(pageLength=10,autoWidth=T))
library(ggplot2)
ggplot(df, aes(x = Avg_X_MCB, y=Avg_Y_MCE, colour=Avg_CEa_07))+
geom_point(size = 4)+
scale_color_continuous(type = 'viridis')

ggplot(df, aes(x = Avg_X_MCB, y=Avg_Y_MCE, colour=Avg_CEa_15))+
geom_point(size = 4)+
scale_color_continuous(type = 'viridis')

ggplot(df, aes(x = Avg_X_MCB, y=Avg_Y_MCE, colour=NDVI))+
geom_point(size = 4, shape = 15)+
scale_color_continuous(type = 'viridis')

Indice de Moran
library(ape)
t.dists<-as.matrix(dist(cbind(df$Avg_X_MCB, df$Avg_Y_MCE)))
dim(t.dists)
[1] 313 313
t.dists.inv<-1/t.dists
t.dists.inv[is.infinite(t.dists.inv)] <- 0
diag(t.dists.inv)<-0
t.dists.inv[1:5, 1:5]
1 2 3 4 5
1 0.00000000 0.19320482 0.02207833 0.05403989 0.04558763
2 0.19320482 0.00000000 0.02476496 0.04650837 0.05738726
3 0.02207833 0.02476496 0.00000000 0.01665161 0.03039597
4 0.05403989 0.04650837 0.01665161 0.00000000 0.03392139
5 0.04558763 0.05738726 0.03039597 0.03392139 0.00000000
I. MORAN de conductividad electrica a 70 cm de profundidad
I.Moran_70<-Moran.I(df$Avg_CEa_07, t.dists.inv); I.Moran_70
$observed
[1] 0.2687468
$expected
[1] -0.003205128
$sd
[1] 0.004665906
$p.value
[1] 0
I. MORAN de conductividad electrica a 150 cm de profundidad
I.Moran_150<-Moran.I(df$Avg_CEa_15, t.dists.inv); I.Moran_150
$observed
[1] 0.160951
$expected
[1] -0.003205128
$sd
[1] 0.00465455
$p.value
[1] 0
I. MORAN NVDI
I.Moran_NDVI<-Moran.I(df$NDVI, t.dists.inv); I.Moran_NDVI
$observed
[1] 0.09750403
$expected
[1] -0.003205128
$sd
[1] 0.004644979
$p.value
[1] 0
GeoDa
I. MORAN de conductividad electrica a 70 cm de profundidad

I. MORAN de conductividad electrica a 150 cm de profundidad

I. MORAN NVDI

LS0tCnRpdGxlOiAiw41uZGljZSBkZSBNb3JhbiAoQkQgTW9kZWxhZG8pIgphdXRob3I6ICJOaWNvbMOhcyBDaWZ1ZW50ZXMiCmRhdGU6ICIxOS8xMC8yMDIwIgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpTZSB2YW4gYSBjb21wcmFyYXIgZG9zIHNvZnR3YXJlcyBwYXJhIGxhIGF1dG9jb3JyZWxhY2nDs24gZXNwYWNpYWwgYWwgY2FsY3VsYXIgSW5kaWNlIGRlIE1vcmFuCgpgYGB7cn0KbGlicmFyeShyZWFkeGwpCmRmIDwtIHJlYWRfZXhjZWwoIi4vQkRfTU9ERUxBRE8ueGxzeCIpCmxpYnJhcnkoRFQpCmRhdGF0YWJsZShkZiwgY2xhc3M9J2NlbGwtYm9yZGVyIHN0cmlwZScsIGZpbHRlcj0ndG9wJywgb3B0aW9ucyA9IGxpc3QocGFnZUxlbmd0aD0xMCxhdXRvV2lkdGg9VCkpCmBgYAoKYGBge3J9CmxpYnJhcnkoZ2dwbG90MikKCmdncGxvdChkZiwgYWVzKHggPSBBdmdfWF9NQ0IsIHk9QXZnX1lfTUNFLCBjb2xvdXI9QXZnX0NFYV8wNykpKwogICBnZW9tX3BvaW50KHNpemUgPSA0KSsKICAgc2NhbGVfY29sb3JfY29udGludW91cyh0eXBlID0gJ3ZpcmlkaXMnKQpgYGAKCmBgYHtyfQpnZ3Bsb3QoZGYsIGFlcyh4ID0gQXZnX1hfTUNCLCB5PUF2Z19ZX01DRSwgY29sb3VyPUF2Z19DRWFfMTUpKSsKICAgZ2VvbV9wb2ludChzaXplID0gNCkrCiAgIHNjYWxlX2NvbG9yX2NvbnRpbnVvdXModHlwZSA9ICd2aXJpZGlzJykKYGBgCgpgYGB7cn0KZ2dwbG90KGRmLCBhZXMoeCA9IEF2Z19YX01DQiwgeT1BdmdfWV9NQ0UsIGNvbG91cj1ORFZJKSkrCiAgIGdlb21fcG9pbnQoc2l6ZSA9IDQsIHNoYXBlID0gMTUpKwogICBzY2FsZV9jb2xvcl9jb250aW51b3VzKHR5cGUgPSAndmlyaWRpcycpCmBgYAojIyBJbmRpY2UgZGUgTW9yYW4KCmBgYHtyfQpsaWJyYXJ5KGFwZSkKdC5kaXN0czwtYXMubWF0cml4KGRpc3QoY2JpbmQoZGYkQXZnX1hfTUNCLCBkZiRBdmdfWV9NQ0UpKSkKZGltKHQuZGlzdHMpCmBgYApgYGB7cn0KdC5kaXN0cy5pbnY8LTEvdC5kaXN0cwp0LmRpc3RzLmludltpcy5pbmZpbml0ZSh0LmRpc3RzLmludildIDwtIDAKZGlhZyh0LmRpc3RzLmludik8LTAKdC5kaXN0cy5pbnZbMTo1LCAxOjVdCmBgYAojIyBJLiBNT1JBTiBkZSBjb25kdWN0aXZpZGFkIGVsZWN0cmljYSBhIDcwIGNtIGRlIHByb2Z1bmRpZGFkCgpgYGB7cn0KSS5Nb3Jhbl83MDwtTW9yYW4uSShkZiRBdmdfQ0VhXzA3LCB0LmRpc3RzLmludik7IEkuTW9yYW5fNzAKYGBgCiMjIEkuIE1PUkFOIGRlIGNvbmR1Y3RpdmlkYWQgZWxlY3RyaWNhIGEgMTUwIGNtIGRlIHByb2Z1bmRpZGFkCgpgYGB7cn0KSS5Nb3Jhbl8xNTA8LU1vcmFuLkkoZGYkQXZnX0NFYV8xNSwgdC5kaXN0cy5pbnYpOyBJLk1vcmFuXzE1MApgYGAKIyMgSS4gTU9SQU4gTlZESQoKYGBge3J9CkkuTW9yYW5fTkRWSTwtTW9yYW4uSShkZiRORFZJLCB0LmRpc3RzLmludik7IEkuTW9yYW5fTkRWSQpgYGAKIyMgR2VvRGEKCiMjIEkuIE1PUkFOIGRlIGNvbmR1Y3RpdmlkYWQgZWxlY3RyaWNhIGEgNzAgY20gZGUgcHJvZnVuZGlkYWQKIVtdKC4vTU9SQU4xLnBuZykKCiMjIEkuIE1PUkFOIGRlIGNvbmR1Y3RpdmlkYWQgZWxlY3RyaWNhIGEgMTUwIGNtIGRlIHByb2Z1bmRpZGFkCgohW10oLi9NT1JBTjIucG5nKQoKIyMgSS4gTU9SQU4gTlZESQoKIVtdKC4vTU9SQU4zLnBuZyk=