Joel Masselink jmasselink

Files for the example in The end of CartoCSS.

The corresponding data is available here: https://www.mapbox.com/bites/00261/plants.min.json (1MB file)

How to set up a quick geocoding system on google spreadsheets.

Create a new spreadsheet
Open the Scripts editor and paste the script attached
Use on your spreadsheet this new formula

=searchMapzen(place_cell,mapzen_api_key)

Eurostat, World Bank and others: https://ikashnitsky.github.io/2017/data-acquisition-two/
Star Wars data: in dplyr, http://dplyr.tidyverse.org/reference/starwars.html
Baby names data: babynames package, https://cran.r-project.org/web/packages/babynames/index.html
Movies data: https://cran.r-project.org/web/packages/ggplot2movies/index.html ggplot2movies package
Game of Thrones screen time: https://github.com/Preetish/GoT_screen_time
Open Bike Data: https://github.com/ropensci/bikedata
Tons of data through 538: https://cran.r-project.org/web/packages/fivethirtyeight/vignettes/fivethirtyeight.html
Public health data England: fingertipsR, https://cran.r-project.org/web/packages/fingertipsR/
Financial data via Quandl: https://www.quandl.com/tools/r
Cyclones: https://github.com/ropensci/rrricanesdat

PostGIS && GIS

cdb-manager

A simple browser-based terminal for running SQL against Carto using the SQL API

http://github.com/cartodb/cdb-manager
git clone [email protected]:CartoDB/cdb-manager.git
When you're done cloning, enter the directory and run ./httpserv.py
Point your browser at http://locahost:8000

Labels with callout lines in QGIS

UPDATE: As of October 2019, QGIS 3.10 has built-in support for label callout lines!

Callouts, sometimes called leader lines, are lines between labels and features on a map. They are useful when constraints of space force a label to be moved away from the

	__author__ = 't-joelm'
	import glob, os
	import csv

	def rename(dir, pattern, titlePattern)
	for pathAndFilename in glob.iglob(os.path.join(dir, pattern)):
	title, ext = os.path.splitext(os.path.basename(pathAndFilename))
	os.rename(pathAndFilename,
	os.path.join(dir, titlePattern % title + ext))