Install Postgres/PostGIS and get started with spatial SQL

PostgreSql is already the second most loved database according to the 2018 StackOverflow survey and it’s the fastest growing in popularity . It’s billed as the “world’s most advanced open source relational database”, and with its comprehensive adherence to SQL standards compliance, it’s easy to see why users love it. But when you add the spatial […]

Continue reading →

Manipulating and mapping US Census data in R using the acs, tigris and leaflet packages

Census data the hard way Plotting census data with ggplot2 Interactive plotting with the leaflet package Options 1: Convert the data.frame back to a SpatialPolygonsDataFrame Options 2: Make use of the existing SpatialPolygonsDataFrame Census data the easy(er) way 1) Set up the packages 2) Get the spatial data (tigris) 3) Get the tabular data (acs) […]

Continue reading →