8. Mapas para el aguacate:

Es de nuestro interes obtener mapas de producción y área cosechada del aguacate. Primeramente, se realiza el mapa para conocer la producción de aguacate en el 2018:

aguacate_valle <- eva_valle %>%  filter(CULTIVO == "AGUACATE")  %>%  dplyr::select(MUNICIPIO, COD_MUN, YEAR, PERIODO, ton_Prod, RENDIM) 
aguacate_valle
unique(aguacate_valle$YEAR)
 [1] 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
aguacate_valle %>% replace(is.na(.), 0) -> aguacate_valle2
aguacate_valle %>% group_by(MUNICIPIO, COD_MUN, YEAR) %>%
   summarize(ton_Prod=sum(ton_Prod)) -> aguacate_valle2
`summarise()` has grouped output by 'MUNICIPIO', 'COD_MUN'. You can override using the `.groups` argument.
aguacate_valle2 %>% 
  group_by(COD_MUN) %>% 
  gather("ton_Prod", key = variable, value = number)   %>% 
  unite(combi, variable, YEAR) %>%
  pivot_wider(names_from = combi, values_from = number, values_fill = 0) ->                                                                    aguacate_valle3
mun_valle_aguacate = left_join(mun_valle, aguacate_valle3, by="COD_MUN")

Se realiza el mapa:

bins <- c(0, 250, 500, 1000, 2000, 3000, 4000, 7000, 9000)
pal <- colorBin("Oranges", domain = mun_valle_aguacate$ton_Prod_2018, bins = bins)

  mapa4 <- leaflet(data = mun_valle_aguacate) %>%
  addTiles() %>%
  addPolygons(label = ~ton_Prod_2018,
              popup = ~MPIO_CNMBR,
              fillColor = ~pal(ton_Prod_2018),
              color = "#444444",
              weight = 1,
              smoothFactor = 0.5,
              opacity = 1.0,
              fillOpacity = 0.5,
              highlightOptions = highlightOptions(color = "white", weight = 2, bringToFront = TRUE)
              ) %>%
  addProviderTiles(providers$OpenStreetMap) %>%
  addLegend("bottomright", pal = pal, values = ~ton_Prod_2018,
    title = "Producción de aguacate en Valle del Cauca [Ton] (2018)",
    opacity = 1
  )
mapa4

Ahora, se hace el mapa del área cosechada en 2018:

aguacate_valle <- eva_valle %>%  filter(CULTIVO == "AGUACATE")  %>%  dplyr::select(MUNICIPIO, COD_MUN, YEAR, PERIODO, Ha_cosecha) 
aguacate_valle %>% group_by(MUNICIPIO, COD_MUN, YEAR) %>%
   summarize(Ha_cosecha=sum(Ha_cosecha)) -> aguacate_valle2
`summarise()` has grouped output by 'MUNICIPIO', 'COD_MUN'. You can override using the `.groups` argument.
aguacate_valle2 %>% 
  group_by(COD_MUN) %>% 
  gather("Ha_cosecha", key = variable, value = number)   %>% 
  unite(combi, variable, YEAR) %>%
  pivot_wider(names_from = combi, values_from = number, values_fill = 0) ->                                                                    aguacate_valle3
mun_aguacate_valle = left_join(mun_valle, aguacate_valle3, by="COD_MUN")
mun_aguacate_valle
bins <- c(0, 50, 100, 150, 200, 250, 300, 350, 400)
pal <- colorBin("Blues", domain = mun_aguacate_valle$Ha_cosecha_2018, bins = bins)

  mapa5 <- leaflet(data = mun_aguacate_valle) %>%
  addTiles() %>%
  addPolygons(label = ~Ha_cosecha_2018,
              popup = ~MPIO_CNMBR,
              fillColor = ~pal(Ha_cosecha_2018),
              color = "#444444",
              weight = 1,
              smoothFactor = 0.5,
              opacity = 1.0,
              fillOpacity = 0.5,
              highlightOptions = highlightOptions(color = "white", weight = 2, bringToFront = TRUE)
              ) %>%
  addProviderTiles(providers$OpenStreetMap) %>%
  addLegend("bottomright", pal = pal, values = ~Ha_cosecha_2018,
    title = "Área cosechada de aguacate en Valle del Cauca [Ha] (2018)",
    opacity = 1
  )
mapa5
LS0tDQp0aXRsZTogIk1pIGN1YXJ0byBSIE5vdGVib29rOiBVbmllbmRvIGRhdG9zIGdlb2VzcGFjaWFsZXMgeSBhdHJpYnV0b3Mgbm8gZXNwYWNpYWxlcyBQYXJ0ZSAyIg0Kb3V0cHV0OiBodG1sX25vdGVib29rDQphdXRob3I6IEx1aXNhIEZlcm5hbmRhIENhcnJpw7NuIFJhbcOtcmV6IHkgTWlndWVsIFNhbnRpYWdvIE1vcmFsZXMgUnXDrXoNCi0tLQ0KDQojIyMgOC4gTWFwYXMgcGFyYSBlbCBhZ3VhY2F0ZToNCg0KRXMgZGUgbnVlc3RybyBpbnRlcmVzIG9idGVuZXIgbWFwYXMgZGUgcHJvZHVjY2nDs24geSDDoXJlYSBjb3NlY2hhZGEgZGVsIGFndWFjYXRlLiBQcmltZXJhbWVudGUsIHNlIHJlYWxpemEgZWwgbWFwYSBwYXJhIGNvbm9jZXIgbGEgcHJvZHVjY2nDs24gZGUgYWd1YWNhdGUgZW4gZWwgMjAxODoNCg0KYGBge3J9DQphZ3VhY2F0ZV92YWxsZSA8LSBldmFfdmFsbGUgJT4lICBmaWx0ZXIoQ1VMVElWTyA9PSAiQUdVQUNBVEUiKSAgJT4lICBkcGx5cjo6c2VsZWN0KE1VTklDSVBJTywgQ09EX01VTiwgWUVBUiwgUEVSSU9ETywgdG9uX1Byb2QsIFJFTkRJTSkgDQpgYGANCg0KYGBge3J9DQphZ3VhY2F0ZV92YWxsZQ0KYGBgDQoNCmBgYHtyfQ0KdW5pcXVlKGFndWFjYXRlX3ZhbGxlJFlFQVIpDQpgYGANCg0KYGBge3J9DQphZ3VhY2F0ZV92YWxsZSAlPiUgcmVwbGFjZShpcy5uYSguKSwgMCkgLT4gYWd1YWNhdGVfdmFsbGUyDQpgYGANCg0KYGBge3J9DQphZ3VhY2F0ZV92YWxsZSAlPiUgZ3JvdXBfYnkoTVVOSUNJUElPLCBDT0RfTVVOLCBZRUFSKSAlPiUNCiAgIHN1bW1hcml6ZSh0b25fUHJvZD1zdW0odG9uX1Byb2QpKSAtPiBhZ3VhY2F0ZV92YWxsZTINCmBgYA0KDQpgYGB7cn0NCmFndWFjYXRlX3ZhbGxlMiAlPiUgDQogIGdyb3VwX2J5KENPRF9NVU4pICU+JSANCiAgZ2F0aGVyKCJ0b25fUHJvZCIsIGtleSA9IHZhcmlhYmxlLCB2YWx1ZSA9IG51bWJlcikgICAlPiUgDQogIHVuaXRlKGNvbWJpLCB2YXJpYWJsZSwgWUVBUikgJT4lDQogIHBpdm90X3dpZGVyKG5hbWVzX2Zyb20gPSBjb21iaSwgdmFsdWVzX2Zyb20gPSBudW1iZXIsIHZhbHVlc19maWxsID0gMCkgLT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGFndWFjYXRlX3ZhbGxlMw0KYGBgDQoNCmBgYHtyfQ0KbXVuX3ZhbGxlX2FndWFjYXRlID0gbGVmdF9qb2luKG11bl92YWxsZSwgYWd1YWNhdGVfdmFsbGUzLCBieT0iQ09EX01VTiIpDQpgYGANCg0KU2UgcmVhbGl6YSBlbCBtYXBhOg0KDQpgYGB7cn0NCmJpbnMgPC0gYygwLCAyNTAsIDUwMCwgMTAwMCwgMjAwMCwgMzAwMCwgNDAwMCwgNzAwMCwgOTAwMCkNCnBhbCA8LSBjb2xvckJpbigiT3JhbmdlcyIsIGRvbWFpbiA9IG11bl92YWxsZV9hZ3VhY2F0ZSR0b25fUHJvZF8yMDE4LCBiaW5zID0gYmlucykNCg0KICBtYXBhNCA8LSBsZWFmbGV0KGRhdGEgPSBtdW5fdmFsbGVfYWd1YWNhdGUpICU+JQ0KICBhZGRUaWxlcygpICU+JQ0KICBhZGRQb2x5Z29ucyhsYWJlbCA9IH50b25fUHJvZF8yMDE4LA0KICAgICAgICAgICAgICBwb3B1cCA9IH5NUElPX0NOTUJSLA0KICAgICAgICAgICAgICBmaWxsQ29sb3IgPSB+cGFsKHRvbl9Qcm9kXzIwMTgpLA0KICAgICAgICAgICAgICBjb2xvciA9ICIjNDQ0NDQ0IiwNCiAgICAgICAgICAgICAgd2VpZ2h0ID0gMSwNCiAgICAgICAgICAgICAgc21vb3RoRmFjdG9yID0gMC41LA0KICAgICAgICAgICAgICBvcGFjaXR5ID0gMS4wLA0KICAgICAgICAgICAgICBmaWxsT3BhY2l0eSA9IDAuNSwNCiAgICAgICAgICAgICAgaGlnaGxpZ2h0T3B0aW9ucyA9IGhpZ2hsaWdodE9wdGlvbnMoY29sb3IgPSAid2hpdGUiLCB3ZWlnaHQgPSAyLCBicmluZ1RvRnJvbnQgPSBUUlVFKQ0KICAgICAgICAgICAgICApICU+JQ0KICBhZGRQcm92aWRlclRpbGVzKHByb3ZpZGVycyRPcGVuU3RyZWV0TWFwKSAlPiUNCiAgYWRkTGVnZW5kKCJib3R0b21yaWdodCIsIHBhbCA9IHBhbCwgdmFsdWVzID0gfnRvbl9Qcm9kXzIwMTgsDQogICAgdGl0bGUgPSAiUHJvZHVjY2nDs24gZGUgYWd1YWNhdGUgZW4gVmFsbGUgZGVsIENhdWNhIFtUb25dICgyMDE4KSIsDQogICAgb3BhY2l0eSA9IDENCiAgKQ0KYGBgDQoNCmBgYHtyfQ0KbWFwYTQNCmBgYA0KQWhvcmEsIHNlIGhhY2UgZWwgbWFwYSBkZWwgw6FyZWEgY29zZWNoYWRhIGVuIDIwMTg6DQoNCmBgYHtyfQ0KYWd1YWNhdGVfdmFsbGUgPC0gZXZhX3ZhbGxlICU+JSAgZmlsdGVyKENVTFRJVk8gPT0gIkFHVUFDQVRFIikgICU+JSAgZHBseXI6OnNlbGVjdChNVU5JQ0lQSU8sIENPRF9NVU4sIFlFQVIsIFBFUklPRE8sIEhhX2Nvc2VjaGEpIA0KYGBgDQoNCmBgYHtyfQ0KYWd1YWNhdGVfdmFsbGUgJT4lIGdyb3VwX2J5KE1VTklDSVBJTywgQ09EX01VTiwgWUVBUikgJT4lDQogICBzdW1tYXJpemUoSGFfY29zZWNoYT1zdW0oSGFfY29zZWNoYSkpIC0+IGFndWFjYXRlX3ZhbGxlMg0KYGBgDQoNCmBgYHtyfQ0KYWd1YWNhdGVfdmFsbGUyICU+JSANCiAgZ3JvdXBfYnkoQ09EX01VTikgJT4lIA0KICBnYXRoZXIoIkhhX2Nvc2VjaGEiLCBrZXkgPSB2YXJpYWJsZSwgdmFsdWUgPSBudW1iZXIpICAgJT4lIA0KICB1bml0ZShjb21iaSwgdmFyaWFibGUsIFlFQVIpICU+JQ0KICBwaXZvdF93aWRlcihuYW1lc19mcm9tID0gY29tYmksIHZhbHVlc19mcm9tID0gbnVtYmVyLCB2YWx1ZXNfZmlsbCA9IDApIC0+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBhZ3VhY2F0ZV92YWxsZTMNCmBgYA0KDQpgYGB7cn0NCm11bl9hZ3VhY2F0ZV92YWxsZSA9IGxlZnRfam9pbihtdW5fdmFsbGUsIGFndWFjYXRlX3ZhbGxlMywgYnk9IkNPRF9NVU4iKQ0KYGBgDQoNCmBgYHtyfQ0KbXVuX2FndWFjYXRlX3ZhbGxlDQpgYGANCg0KYGBge3J9DQpiaW5zIDwtIGMoMCwgNTAsIDEwMCwgMTUwLCAyMDAsIDI1MCwgMzAwLCAzNTAsIDQwMCkNCnBhbCA8LSBjb2xvckJpbigiQmx1ZXMiLCBkb21haW4gPSBtdW5fYWd1YWNhdGVfdmFsbGUkSGFfY29zZWNoYV8yMDE4LCBiaW5zID0gYmlucykNCg0KICBtYXBhNSA8LSBsZWFmbGV0KGRhdGEgPSBtdW5fYWd1YWNhdGVfdmFsbGUpICU+JQ0KICBhZGRUaWxlcygpICU+JQ0KICBhZGRQb2x5Z29ucyhsYWJlbCA9IH5IYV9jb3NlY2hhXzIwMTgsDQogICAgICAgICAgICAgIHBvcHVwID0gfk1QSU9fQ05NQlIsDQogICAgICAgICAgICAgIGZpbGxDb2xvciA9IH5wYWwoSGFfY29zZWNoYV8yMDE4KSwNCiAgICAgICAgICAgICAgY29sb3IgPSAiIzQ0NDQ0NCIsDQogICAgICAgICAgICAgIHdlaWdodCA9IDEsDQogICAgICAgICAgICAgIHNtb290aEZhY3RvciA9IDAuNSwNCiAgICAgICAgICAgICAgb3BhY2l0eSA9IDEuMCwNCiAgICAgICAgICAgICAgZmlsbE9wYWNpdHkgPSAwLjUsDQogICAgICAgICAgICAgIGhpZ2hsaWdodE9wdGlvbnMgPSBoaWdobGlnaHRPcHRpb25zKGNvbG9yID0gIndoaXRlIiwgd2VpZ2h0ID0gMiwgYnJpbmdUb0Zyb250ID0gVFJVRSkNCiAgICAgICAgICAgICAgKSAlPiUNCiAgYWRkUHJvdmlkZXJUaWxlcyhwcm92aWRlcnMkT3BlblN0cmVldE1hcCkgJT4lDQogIGFkZExlZ2VuZCgiYm90dG9tcmlnaHQiLCBwYWwgPSBwYWwsIHZhbHVlcyA9IH5IYV9jb3NlY2hhXzIwMTgsDQogICAgdGl0bGUgPSAiw4FyZWEgY29zZWNoYWRhIGRlIGFndWFjYXRlIGVuIFZhbGxlIGRlbCBDYXVjYSBbSGFdICgyMDE4KSIsDQogICAgb3BhY2l0eSA9IDENCiAgKQ0KYGBgDQoNCg0KYGBge3J9DQptYXBhNQ0KYGBgDQoNCg==