alrocar’s gists

alrocar / ingest_from_array.py

Created July 20, 2020 16:07

Ingest to Tinybird from a Python array

	import csv
	import requests

	from io import StringIO
	from requests.adapters import HTTPAdapter
	from urllib3.util.retry import Retry

	rows = [[1, 2, 3], [4, 5, 6]]

	endpoint = 'https://api.tinybird.co'

alrocar / kuviz.html

Last active December 26, 2019 11:25

	<iframe src="https://public.carto.com/kuviz/f8dcf0ef-45e5-4578-a245-af443c870ffa" height="600" width="600" />


	<iframe src="https://www.youtube.com/embed/enMumwvLAug" frameborder="0" allowfullscreen="true"> </iframe>

alrocar / collect-terrain-tiles.py

Created March 2, 2019 10:40

	#!/usr/bin/env python
	from __future__ import print_function
	from math import log, tan, pi
	from itertools import product
	from argparse import ArgumentParser
	from os.path import join, splitext

	import tempfile, shutil, urllib, io, sys, subprocess

	tile_url = 'https://elevation-tiles-prod.s3.amazonaws.com/geotiff/{z}/{x}/{y}.tif'

alrocar / create_buildings_named_map.py

Created October 31, 2018 17:08

	import os
	import sys
	import argparse

	from carto.auth import APIKeyAuthClient
	from carto.maps import NamedMapManager


	parser = argparse.ArgumentParser(description=(
	'Example of CopySQLClient usage to stream data from NEXRAD Level 2'

alrocar / import_us_buildings.py

Last active February 7, 2019 16:46

	import os
	import sys
	import argparse
	try:
	from urllib2 import urlopen
	except ImportError:
	from urllib.request import urlopen

	try:
	from StringIO import BytesIO

alrocar / animate lines script

Last active July 5, 2018 10:21

animate lines script

	with lines as
	(SELECT cartodb_id, color, ord, ST_Segmentize(ST_MakeLine(st_centroid(the_geom), lead(st_centroid(the_geom)) OVER (ORDER BY ord))::geography, 100000)::geometry as the_geom
	FROM world_borders_four_colors_1_adjacency_list),
	tosplit AS (
	SELECT * FROM lines
	WHERE ST_XMax(the_geom) - ST_XMin(the_geom) > 180
	),
	nosplit AS (
	SELECT * FROM lines
	WHERE ST_XMax(the_geom) - ST_XMin(the_geom) <= 180

alrocar / high quality gif

Last active May 26, 2018 15:13

high-quality-gif

	# first create a palette of the portion of the video with more colors

	ffmpeg -y -ss 20 -t 3 -i input.mp4 -vf fps=50,scale=640:-1:flags=lanczos,palettegen palette.png

	# then use the palette to obtain high quality colors

	ffmpeg -i input.mp4 -i palette.png -filter_complex "fps=50,scale=640:-1:flags=lanczos[x];[x][1:v]paletteuse" output.gif

	# -ss -> start from second
	# -t -> duration

alrocar / PostGIS functions for map coloring

Created April 22, 2018 19:30

	CREATE OR REPLACE FUNCTION adjacency_list(table_name regclass, user_name text) RETURNS void AS $$
	BEGIN
	EXECUTE format('DROP TABLE IF EXISTS %s_adjacency_list;
	CREATE TABLE %s_adjacency_list AS
	SELECT DISTINCT a.cartodb_id,
	array_agg(b.cartodb_id) over (PARTITION BY a.cartodb_id) AS adjacent,
	count(b.*) over (PARTITION BY a.cartodb_id) AS valence,
	0 AS color
	FROM %s a,
	%s b

alrocar / carto-python-bigquery

Created April 18, 2018 05:11

This is a sample snippet to ingest data from BigQuery into CARTO by using both Python SDKs

	A snippet to make a query to BigQuery and import the result in CARTO using both Python client libraries:

	```
	#!/usr/bin/env python

	import argparse
	import time
	import uuid
	from tempfile import NamedTemporaryFile

alrocar / index.html

Last active October 31, 2017 17:08

	<!DOCTYPE html>
	<html>
	<head>
	<title>Reacciones al #AccordDeParis</title>
	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />
	<style>
	html, body, #map {
	height: 100%;

alrocar alrocar