Skip to content

Instantly share code, notes, and snippets.

View LuisSevillano's full-sized avatar

Luis Sevillano LuisSevillano

100 followers · 233 following
View GitHub Profile
@LuisSevillano
LuisSevillano / query.sql
Created February 28, 2019 11:02
Add new column in PostgreSQL with a subquery and set a NOT NULL constraint
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
LuisSevillano / script.sh
Created January 21, 2019 13:17
Bash script to process frames and convert then to a video format with ffmpeg
#!/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
LuisSevillano / close.sql
Created December 6, 2018 08:24
Close all connections from a Postgres database
SELECT *, pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database';
@LuisSevillano
LuisSevillano / catastro_data.csv
Created July 12, 2018 09:15
Cadastre Data from http://www.sedecatastro.gob.es/. It contains the year of construction of each building in the ciry of A Coruña, Spain
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
year_int
1985
1986
1996
1994
1996
1997
2000
1992
1996
@LuisSevillano
LuisSevillano / google_stock_data.csv
Created February 3, 2018 12:22
Date Open High Low Close Volume Adj Close
8/19/2014 585.002622 587.342658 584.002627 586.862643 978600 586.862643
8/18/2014 576.11258 584.512631 576.002598 582.162619 1284100 582.162619
8/15/2014 577.862619 579.382595 570.522603 573.482626 1519100 573.482626
8/14/2014 576.182596 577.902645 570.882599 574.652582 985400 574.652582
8/13/2014 567.312567 575.002602 565.752564 574.782577 1439200 574.782577
8/12/2014 564.522567 565.902572 560.882518 562.732562 1542000 562.732562
8/11/2014 569.992585 570.492553 566.002578 567.882551 1214700 567.882551
8/8/2014 563.562536 570.252576 560.352561 568.772565 1494700 568.772565
8/7/2014 568.00257 569.89258 561.102543 563.362525 1110900 563.362525
@LuisSevillano
LuisSevillano / triangles.css
Created January 18, 2018 08:57
Positioning triangles inside an element with CSS pseudo elements
.pill {
position: relative;
}
.pill::before {
content: '';
position: absolute;
top: 50%;
left: 0;
right: 100%;
margin-top: -5px;
@LuisSevillano
LuisSevillano / index.js
Created December 23, 2017 11:06
Normalizer
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
LuisSevillano / index.js
Created December 21, 2017 14:33
Formating numbers and dates in Spanish
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
LuisSevillano / .block
Created December 4, 2017 18:41
From Hong Kong to Brussels
border: none
height: 960
@LuisSevillano
LuisSevillano / README.md
Created October 7, 2017 23:07
Center and Scale your map