R tricks

• Concatenate a list of data frames
• Convert data from long to wide format
• Fetch data from a PostgreSQL database
• Format a number with leading zeros
• Quickly visualize an sf object
• Generate a global rectangular grid with sf
• Generate a hexagonal grid covering an sf object
• Mutate all numeric columns in a data frame
• Start a Docker container with RStudio and geospatial tools
• Set environment variables from a file
• Use a string as variable name in a formula
• Plot a world map in ggplot2
• Read data from a Google Sheet
• Convert sf geometries to WKT
• Write a data frame to a PostgreSQL table