afcotroneo

afcotroneo / omni-bonus

Created March 29, 2021 17:43

	create table gps_agg_blkgrps_pre as (
	select
	count(*) as total_pings,
	sum(Dist_m) as total_distance,
	b.GEOID
	from tripstats a,
	la_blkgrps b
	where st_contains(b.omnisci_geo,st_setsrid(st_point(a.point_x, a.point_y), 4326)) = 1
	group by b.GEOID
	);

afcotroneo / omni-retro-metro

Created April 10, 2021 22:33

["#ea5545", "#f46a9b", "#ef9b20", "#edbf33", "#ede15b", "#bdcf32", "#87bc45", "#27aeef", "#b33dc6"]

afcotroneo / omni-dutch-field

Created April 10, 2021 22:34

[#e60049", "#0bb4ff", "#50e991", "#e6d800", "#9b19f5", "#ffa300", "#dc0ab4", "#b3d4ff", "#00bfa0"]

afcotroneo / omni-spring-pastels

Created April 10, 2021 22:36

["#fd7f6f", "#7eb0d5", "#b2e061", "#bd7ebe", "#ffb55a", "#ffee65", "#beb9db", "#fdcce5", "#8bd3c7"]

afcotroneo / omni-river-nights

Created April 10, 2021 22:36

["#b30000", "#7c1158", "#4421af", "#1a53ff", "#0d88e6", "#00b7c7", "#5ad45a", "#8be04e", "#ebdc78"]

afcotroneo / omni-blue-yellow

Created April 10, 2021 22:38

["#115f9a", "#1984c5", "#22a7f0", "#48b5c4", "#76c68f", "#a6d75b", "#c9e52f", "#d0ee11", "#d0f400"]

afcotroneo / omni-gray-red

Created April 10, 2021 22:39

["#d7e1ee", "#cbd6e4", "#bfcbdb", "#b3bfd1", "#a4a2a8", "#df8879", "#c86558", "#b04238", "#991f17"]

afcotroneo / omni-black-pink

Created April 10, 2021 22:39

["#2e2b28", "#3b3734", "#474440", "#54504c", "#6b506b", "#ab3da9", "#de25da", "#eb44e8", "#ff80ff"]

afcotroneo / omni-blues

Created April 10, 2021 22:40

["#0000b3", "#0010d9", "#0020ff", "#0040ff", "#0060ff", "#0080ff", "#009fff", "#00bfff", "#00ffff"]

afcotroneo / omni-blue-red

Created April 10, 2021 22:41

["#1984c5", "#22a7f0", "#63bff0", "#a7d5ed", "#e2e2e2", "#e1a692", "#de6e56", "#e14b31", "#c23728"]