Skip to content

Instantly share code, notes, and snippets.

@MarHoff
Created January 27, 2017 15:28
Show Gist options
  • Save MarHoff/d10181c364f2482c2198ed94a6e6c59b to your computer and use it in GitHub Desktop.
Save MarHoff/d10181c364f2482c2198ed94a6e6c59b to your computer and use it in GitHub Desktop.
SQL for 12 class colorbrewer
WITH tcolor as (SELECT * FROM (VALUES
(1,'#a6cee3'::text),
(2,'#1f78b4'),
(3,'#b2df8a'),
(4,'#33a02c'),
(5,'#fb9a99'),
(6,'#e31a1c'),
(7,'#fdbf6f'),
(8,'#ff7f00'),
(9,'#cab2d6'),
(10,'#6a3d9a'),
(11,'#ffff99'),
(0,'#b15928')) as t(color,rgb))
SELECT * FROM tcolor
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment