library(raster)
## Warning: package 'raster' was built under R version 4.0.5
## Loading required package: sp
library(sp)
library(rgdal)
## rgdal: version: 1.5-23, (SVN revision 1121)
## Geospatial Data Abstraction Library extensions to R successfully loaded
## Loaded GDAL runtime: GDAL 3.2.1, released 2020/12/29
## Path to GDAL shared files: C:/Users/Usuario/Documents/R/win-library/4.0/rgdal/gdal
## GDAL binary built with GEOS: TRUE 
## Loaded PROJ runtime: Rel. 7.2.1, January 1st, 2021, [PJ_VERSION: 721]
## Path to PROJ shared files: C:/Users/Usuario/Documents/R/win-library/4.0/rgdal/proj
## PROJ CDN enabled: FALSE
## Linking to sp version:1.4-5
## To mute warnings of possible GDAL/OSR exportToProj4() degradation,
## use options("rgdal_show_exportToProj4_warnings"="none") before loading rgdal.
## Overwritten PROJ_LIB was C:/Users/Usuario/Documents/R/win-library/4.0/rgdal/proj
#concatenamos los nombres de las bandas
bandas<- paste0("C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B",1:7,".tif")
bandas
## [1] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B1.tif"
## [2] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B2.tif"
## [3] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B3.tif"
## [4] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B4.tif"
## [5] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B5.tif"
## [6] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B6.tif"
## [7] "C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/LC08_L1TP_008058_20180317_20200901_02_T1_B7.tif"
landsat <- stack(bandas)
landsat
## class      : RasterStack 
## dimensions : 7731, 7581, 58608711, 7  (nrow, ncol, ncell, nlayers)
## resolution : 30, 30  (x, y)
## extent     : 413385, 640815, 203385, 435315  (xmin, xmax, ymin, ymax)
## crs        : +proj=utm +zone=18 +datum=WGS84 +units=m +no_defs 
## names      : LC08_L1TP//1_02_T1_B1, LC08_L1TP//1_02_T1_B2, LC08_L1TP//1_02_T1_B3, LC08_L1TP//1_02_T1_B4, LC08_L1TP//1_02_T1_B5, LC08_L1TP//1_02_T1_B6, LC08_L1TP//1_02_T1_B7 
## min values :                     0,                     0,                     0,                     0,                     0,                     0,                     0 
## max values :                 65535,                 65535,                 65535,                 65535,                 65535,                 65535,                 65535
#install.packages("sf")
library(sf)
## Warning: package 'sf' was built under R version 4.0.5
## Linking to GEOS 3.9.0, GDAL 3.2.1, PROJ 7.2.1
library(readxl)
## Warning: package 'readxl' was built under R version 4.0.5
# LLAMAMOS EL ARCHIVO EXCEL CON PUNTOS
puntos <- read_xlsx("C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/puntos.xlsx")
#puntos

#CONCVERTIR EXCEL EN BDE

puntos_geo <- puntos %>% 
st_as_sf(coords = c("x","y"))

plot(puntos_geo)

df1 <- extract(landsat,puntos_geo)
df1
##       LC08_L1TP_008058_20180317_20200901_02_T1_B1
##  [1,]                                       11282
##  [2,]                                       11327
##  [3,]                                       10908
##  [4,]                                       12428
##  [5,]                                       11086
##  [6,]                                       11324
##  [7,]                                       11206
##  [8,]                                       11093
##  [9,]                                       10887
## [10,]                                       10908
## [11,]                                       10808
## [12,]                                       10883
## [13,]                                       10954
## [14,]                                       11185
## [15,]                                       11494
## [16,]                                       10947
## [17,]                                       11387
## [18,]                                       11051
## [19,]                                       12980
## [20,]                                       11150
## [21,]                                       11043
## [22,]                                       10971
## [23,]                                       11048
## [24,]                                       11453
## [25,]                                       11111
## [26,]                                       11040
## [27,]                                       11858
## [28,]                                       10856
## [29,]                                       10757
## [30,]                                       10797
## [31,]                                       10838
## [32,]                                       10906
## [33,]                                       10967
## [34,]                                       10702
## [35,]                                       11046
## [36,]                                       12480
## [37,]                                       13271
## [38,]                                       12891
## [39,]                                       12044
## [40,]                                       13450
## [41,]                                       12274
## [42,]                                       12431
## [43,]                                       12596
## [44,]                                       12470
## [45,]                                       12721
## [46,]                                       12010
## [47,]                                       12880
##       LC08_L1TP_008058_20180317_20200901_02_T1_B2
##  [1,]                                       10470
##  [2,]                                       10672
##  [3,]                                        9909
##  [4,]                                       11475
##  [5,]                                       10242
##  [6,]                                       10455
##  [7,]                                       10316
##  [8,]                                       10205
##  [9,]                                        9923
## [10,]                                        9889
## [11,]                                        9798
## [12,]                                        9880
## [13,]                                       10022
## [14,]                                       10327
## [15,]                                       10795
## [16,]                                       10101
## [17,]                                       10727
## [18,]                                       10149
## [19,]                                       12839
## [20,]                                       10261
## [21,]                                       10093
## [22,]                                        9952
## [23,]                                       10128
## [24,]                                       10588
## [25,]                                       10197
## [26,]                                       10069
## [27,]                                       11158
## [28,]                                        9863
## [29,]                                        9765
## [30,]                                        9816
## [31,]                                        9867
## [32,]                                        9925
## [33,]                                       10016
## [34,]                                        9739
## [35,]                                       10135
## [36,]                                       11837
## [37,]                                       12610
## [38,]                                       12520
## [39,]                                       11163
## [40,]                                       12920
## [41,]                                       11538
## [42,]                                       11842
## [43,]                                       11957
## [44,]                                       11895
## [45,]                                       12080
## [46,]                                       11255
## [47,]                                       12146
##       LC08_L1TP_008058_20180317_20200901_02_T1_B3
##  [1,]                                        9889
##  [2,]                                       10243
##  [3,]                                        9372
##  [4,]                                       11211
##  [5,]                                        9549
##  [6,]                                        9792
##  [7,]                                        9627
##  [8,]                                        9438
##  [9,]                                        9167
## [10,]                                        8928
## [11,]                                        8744
## [12,]                                        8968
## [13,]                                        9518
## [14,]                                        9850
## [15,]                                       10276
## [16,]                                        9717
## [17,]                                       10453
## [18,]                                        9800
## [19,]                                       14143
## [20,]                                        9997
## [21,]                                        9684
## [22,]                                        9325
## [23,]                                        9767
## [24,]                                        9776
## [25,]                                        9489
## [26,]                                        9492
## [27,]                                       10692
## [28,]                                        9357
## [29,]                                        9095
## [30,]                                        9249
## [31,]                                        9346
## [32,]                                        9444
## [33,]                                        9436
## [34,]                                        9192
## [35,]                                        9800
## [36,]                                       11489
## [37,]                                       12086
## [38,]                                       11889
## [39,]                                       10674
## [40,]                                       12285
## [41,]                                       11181
## [42,]                                       11519
## [43,]                                       11618
## [44,]                                       11776
## [45,]                                       11450
## [46,]                                       10684
## [47,]                                       11693
##       LC08_L1TP_008058_20180317_20200901_02_T1_B4
##  [1,]                                        9153
##  [2,]                                       10253
##  [3,]                                        8148
##  [4,]                                       10342
##  [5,]                                        8992
##  [6,]                                        9321
##  [7,]                                        9026
##  [8,]                                        8811
##  [9,]                                        8142
## [10,]                                        7992
## [11,]                                        7780
## [12,]                                        7995
## [13,]                                        8563
## [14,]                                        9151
## [15,]                                       10469
## [16,]                                        8842
## [17,]                                       10623
## [18,]                                        8790
## [19,]                                       16160
## [20,]                                        8903
## [21,]                                        8381
## [22,]                                        7974
## [23,]                                        8630
## [24,]                                        9365
## [25,]                                        8860
## [26,]                                        8408
## [27,]                                       10910
## [28,]                                        8092
## [29,]                                        7908
## [30,]                                        7970
## [31,]                                        8164
## [32,]                                        8150
## [33,]                                        8297
## [34,]                                        8006
## [35,]                                        8702
## [36,]                                       11363
## [37,]                                       11627
## [38,]                                       11610
## [39,]                                        9936
## [40,]                                       11525
## [41,]                                       10981
## [42,]                                       10998
## [43,]                                       11333
## [44,]                                       11608
## [45,]                                       11009
## [46,]                                       10283
## [47,]                                       11313
##       LC08_L1TP_008058_20180317_20200901_02_T1_B5
##  [1,]                                        8474
##  [2,]                                       17093
##  [3,]                                       21435
##  [4,]                                       18856
##  [5,]                                        8987
##  [6,]                                        9489
##  [7,]                                        9281
##  [8,]                                        8989
##  [9,]                                        9754
## [10,]                                       11895
## [11,]                                        9616
## [12,]                                       14464
## [13,]                                       12398
## [14,]                                       15907
## [15,]                                       16478
## [16,]                                       20141
## [17,]                                       18387
## [18,]                                       19661
## [19,]                                       22161
## [20,]                                       19423
## [21,]                                       16681
## [22,]                                       20737
## [23,]                                       20584
## [24,]                                       13591
## [25,]                                       11705
## [26,]                                       21176
## [27,]                                       14783
## [28,]                                       20070
## [29,]                                       21016
## [30,]                                       20098
## [31,]                                       21264
## [32,]                                       20571
## [33,]                                       19764
## [34,]                                       21173
## [35,]                                       21743
## [36,]                                       17551
## [37,]                                       14824
## [38,]                                       16697
## [39,]                                       18263
## [40,]                                       16167
## [41,]                                       17035
## [42,]                                       18858
## [43,]                                       17871
## [44,]                                       18968
## [45,]                                       16528
## [46,]                                       16286
## [47,]                                       16347
##       LC08_L1TP_008058_20180317_20200901_02_T1_B6
##  [1,]                                        6981
##  [2,]                                       17329
##  [3,]                                       12932
##  [4,]                                       14954
##  [5,]                                        7127
##  [6,]                                        7805
##  [7,]                                        7503
##  [8,]                                        7182
##  [9,]                                        7655
## [10,]                                        8136
## [11,]                                        7435
## [12,]                                        9416
## [13,]                                        8994
## [14,]                                       13131
## [15,]                                       20033
## [16,]                                       15119
## [17,]                                       16353
## [18,]                                       15220
## [19,]                                       22362
## [20,]                                       15563
## [21,]                                       11500
## [22,]                                       12393
## [23,]                                       14741
## [24,]                                       13820
## [25,]                                       10085
## [26,]                                       13513
## [27,]                                       14996
## [28,]                                       12467
## [29,]                                       11689
## [30,]                                       11551
## [31,]                                       13408
## [32,]                                       12746
## [33,]                                       12827
## [34,]                                       13249
## [35,]                                       14945
## [36,]                                       16044
## [37,]                                       15164
## [38,]                                       15081
## [39,]                                       14263
## [40,]                                       15612
## [41,]                                       14980
## [42,]                                       15990
## [43,]                                       16423
## [44,]                                       15831
## [45,]                                       15790
## [46,]                                       15124
## [47,]                                       15365
##       LC08_L1TP_008058_20180317_20200901_02_T1_B7
##  [1,]                                        6250
##  [2,]                                       12662
##  [3,]                                        8667
##  [4,]                                       11842
##  [5,]                                        6322
##  [6,]                                        6777
##  [7,]                                        6555
##  [8,]                                        6316
##  [9,]                                        6530
## [10,]                                        6706
## [11,]                                        6340
## [12,]                                        7215
## [13,]                                        7029
## [14,]                                        9319
## [15,]                                       15837
## [16,]                                       10105
## [17,]                                       11515
## [18,]                                       10062
## [19,]                                       18823
## [20,]                                       10289
## [21,]                                        8281
## [22,]                                        8413
## [23,]                                        9648
## [24,]                                       11721
## [25,]                                        7944
## [26,]                                        8840
## [27,]                                       11729
## [28,]                                        8246
## [29,]                                        7843
## [30,]                                        7815
## [31,]                                        8713
## [32,]                                        8365
## [33,]                                        8582
## [34,]                                        8663
## [35,]                                        9793
## [36,]                                       12952
## [37,]                                       13570
## [38,]                                       12769
## [39,]                                       11214
## [40,]                                       13202
## [41,]                                       11914
## [42,]                                       12670
## [43,]                                       13274
## [44,]                                       11562
## [45,]                                       13338
## [46,]                                       11994
## [47,]                                       12836
df2 <- aggregate(df1,list(puntos_geo$clase), mean)
df2
##         Group.1 LC08_L1TP_008058_20180317_20200901_02_T1_B1
## 1          agua                                    11055.17
## 2 constucciones                                    12611.23
## 3        suelos                                    11350.09
## 4    vegetacion                                    10976.36
##   LC08_L1TP_008058_20180317_20200901_02_T1_B2
## 1                                    10138.50
## 2                                    11941.38
## 3                                    10573.18
## 4                                    10029.45
##   LC08_L1TP_008058_20180317_20200901_02_T1_B3
## 1                                    9439.167
## 2                                   11504.231
## 3                                   10289.182
## 4                                    9469.455
##   LC08_L1TP_008058_20180317_20200901_02_T1_B4
## 1                                    8635.667
## 2                                   11071.385
## 3                                    9853.636
## 4                                    8446.636
##   LC08_L1TP_008058_20180317_20200901_02_T1_B5
## 1                                    11749.75
## 2                                    17250.08
## 3                                    18630.64
## 4                                    19368.64
##   LC08_L1TP_008058_20180317_20200901_02_T1_B6
## 1                                    8859.167
## 2                                   15432.385
## 3                                   15857.545
## 4                                   12678.455
##   LC08_L1TP_008058_20180317_20200901_02_T1_B7
## 1                                    7096.000
## 2                                   12549.000
## 3                                   11577.818
## 4                                    8673.364
# exportar el df a un excel
#install.packages("writexl")
library(writexl)
## Warning: package 'writexl' was built under R version 4.0.5
write_xlsx(df2,"C:/Users/Usuario/Desktop/electiva II/PROYECTO2/IMAGEN/dataframe.xlsx")
grafica <- raster("C:/Users/Usuario/Desktop/electiva II/PROYECTO2/curva espectral.png")

plot(grafica)

#install.packages("Rcpp")
library(Rcpp)
library(leaflet)
## Warning: package 'leaflet' was built under R version 4.0.5
longitude_astudy <- c(-75.350937, -75.231709, -75.236316, -75.347638)
latitud_astudy <- c( 2.835484,  2.837110,   2.767743,   2.765785)
plot(longitude_astudy, latitud_astudy)

mapa_uno <- leaflet() %>%  
addTiles() %>%
addMarkers(lng = -75.257864, lat = 2.779560, popup="casa")
addPolygons(mapa_uno,longitude_astudy,latitud_astudy)