LuisSevillano

BEGIN;

ALTER TABLE table1 ADD COLUMN exp_id text;

UPDATE table1
    SET exp_id = temp_query.exp_id
FROM (
    SELECT t2.exp_id FROM table2 t2 JOIN table1 t1 on t2.gid = t1.gid
) AS temp_query;

LuisSevillano

#!/usr/bin/env bash
# https://askubuntu.com/questions/610903/how-can-i-create-a-video-file-from-a-set-of-jpg-images
ffmpeg -framerate 30 -i \
    path_to_file_%04d.jpeg \
    -c:v libx264 \
    -profile:v high \
    -crf 18 \
    -pix_fmt yuv420p \
    output.mp4

LuisSevillano

SELECT *, pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database';

LuisSevillano

year_int
1985
1986
1996
1994
1996
1997
2000
1992
1996

LuisSevillano

LuisSevillano

.pill {
  position: relative;
}
.pill::before {
  content: '';
  position: absolute;
  top: 50%;
  left: 0;
  right: 100%;
  margin-top: -5px;

LuisSevillano

function normalize(str) {
    var from = "1234567890ÃÀÁÄÂÈÉËÊÌÍÏÎÒÓÖÔÙÚÜÛãà áäâèéëêìíïîòóöôùúüûÑñÇç '/&().!",
        to = "izeasgtogoAAAAAEEEEIIIIOOOOUUUUaaaaaeeeeiiiioooouuuunncc_____",
        mapping = {};

    for (var i = 0, j = from.length; i < j; i++) {
        mapping[from.charAt(i)] = to.charAt(i);
    }

    var ret = [];

LuisSevillano

import { timeFormatLocale } from 'd3-time-format';
import { formatLocale } from 'd3-format';
// You need 'rollup-plugin-json' in rollup.config.js
import es from 'd3-format/locale/es-ES.json';
import ES from 'd3-time-format/locale/es-ES.json';

export default function() {
  var locale = timeFormatLocale(ES);
  var formatted = formatLocale(es).format;
  var f = formatted('2,');

LuisSevillano

border: none
height: 960

LuisSevillano

Most basic example to center and scale your map with d3.geoBounds(), d3.geoCentroid() and d3.geoDistance().