Skip to content

Instantly share code, notes, and snippets.

View denysvitali's full-sized avatar

Denys Vitali denysvitali

448 followers · 258 following
View GitHub Profile
@denysvitali
denysvitali / play_stream.sh
Created June 22, 2018 20:08
DATE_NOW=$(echo $(date +%s) - 20 | bc); HDNTS=$(curl https://tp.srgssr.ch/akahd/token\?acl\=/i/enc20a_gop@141646/\* | jq .token.authparams -r | sed 's/^hdnts=//'); ffmpeg -i https://srgssrgop20a-lh.akamaihd.net/i/enc20a_gop@141646/master.m3u8\?start\=$DATE_NOW\&start\=$DATE_NOW\&hdnts\=$HDNTS -c copy video.ts
@denysvitali
denysvitali / hosts-denvit
Created April 29, 2018 08:05
#
# /etc/hosts: static lookup table for host names
#
#<ip-address> <hostname.domain.org> <hostname>
127.0.0.1 localhost.localdomain localhost
#::1 localhost.localdomain localhost
127.0.0.1 analytics.ti-edu.ch
127.0.0.1 lb.usemaxserver.de
@denysvitali
denysvitali / spotify-adblock.txt
Last active April 29, 2018 08:03
# Spotify
127.0.0.0 media-match.com
127.0.0.0 adclick.g.doublecklick.net
127.0.0.0 www.googleadservices.com
#127.0.0.0 open.spotify.com
127.0.0.0 pagead2.googlesyndication.com
#127.0.0.0 desktop.spotify.com
127.0.0.0 googleads.g.doubleclick.net
127.0.0.0 pubads.g.doubleclick.net
127.0.0.0 securepubads.g.doubleclick.net
@denysvitali
denysvitali / improved_query2.sql
Created April 24, 2018 21:38
SELECT trip.uid FROM (
SELECT DISTINCT st.trip_id, st.feed_id FROM stop_time as st
INNER JOIN (SELECT s.uid, s.id, s.feed_id FROM stop as s
WHERE
ST_Within(
s.position::geometry,
ST_MakeEnvelope(
5.9559,45.818, 10.4921, 47.8084,
4326)
)
@denysvitali
denysvitali / improved_query.sql
Created April 24, 2018 21:28
WITH stops_time AS (
WITH stops_in_region AS (
SELECT s.uid, s.id, s.feed_id FROM stop as s
WHERE
ST_Within(
s.position::geometry,
ST_MakeEnvelope(
5.9559,45.818, 10.4921, 47.8084,
4326)
)
@denysvitali
denysvitali / schema.sql
Created April 24, 2018 20:41
GTFS DB Schema
CREATE TABLE public.agency (
uid varchar(255) NOT NULL,
id varchar(255) NOT NULL,
"name" varchar(255) NOT NULL,
url varchar(512) NULL,
timezone varchar(255) NULL,
lang varchar(20) NULL,
phone varchar(255) NULL,
feed_id varchar(64) NOT NULL,
fare_url varchar(512) NULL,
@denysvitali
denysvitali / cumulative_interp.px
Created April 21, 2018 14:13
import json
from pprint import pprint
import time
from datetime import date,datetime,timedelta
from numpy import arange
import matplotlib.pyplot as plt
from matplotlib.dates import DayLocator, HourLocator, DateFormatter, drange, date2num
from matplotlib.markers import MarkerStyle
import numpy as np
@denysvitali
denysvitali / cumulative.py
Created April 21, 2018 14:02
import json
from pprint import pprint
import time
from datetime import date,datetime,timedelta
from numpy import arange
import matplotlib.pyplot as plt
from matplotlib.dates import DayLocator, HourLocator, DateFormatter, drange, date2num
from matplotlib.markers import MarkerStyle
import numpy as np
@denysvitali
denysvitali / gist:d08f66ed2e6e89bec43157ce575afe68
Created April 18, 2018 20:20
Section "ServerLayout"
Identifier "layout"
Screen 0 "intel-edp1"
Screen 1 "intel-hdmi1"
EndSection
#Section "Device"
# Identifier "nvidia"
# BusID "PCI:1:0:0"
#EndSection
@denysvitali
denysvitali / gps.rs
Created April 11, 2018 09:24
fn deg2meter_lng(lng: f64) -> f64 { // X: E - W
111412.84 * lng.cos() - 93.5 * (3.0 * lng).cos() + 0.118 * (5.0 * lng).cos()
}
fn deg2meter_lat(lat: f64) -> f64 { // Y: N - S
111132.92 - 559.82 * (2.0 *lat).cos() + 1.175 * (4.0 *lat).cos() - 0.0023 * (6.0 *lat).cos()
}
// Orange
p1.lng = c2.lng + r2 * 1.0/deg2meter_lng(c2.lng);