ermolaev

CREATE TEMP TABLE test_data ON COMMIT DROP AS (SELECT
	warehouses.product_id::TEXT,
	user_id AS transaction_id
FROM
	"line_items"
INNER JOIN "users" ON "users"."id" = "line_items"."user_id"
INNER JOIN "warehouses" ON "warehouses"."id" = "line_items"."warehouse_id"
INNER JOIN "products" ON "products"."id" = "warehouses"."product_id"
AND (products.deleted_at IS NULL)
WHERE

ermolaev

Demo app to go along with blog post about creating custom TopoJSON data here

http://datamaps.markmarkoh.com/using-custom-map-data-w-datamaps/