Skip to content

Instantly share code, notes, and snippets.

View denysvitali's full-sized avatar

Denys Vitali denysvitali

365 followers · 227 following
View GitHub Profile
@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);
@denysvitali
denysvitali / rectangle.rs
Created April 10, 2018 19:04
fn deg2meter_lng(lng: f64) -> f64 {
111412.84 * lng.cos() - 93.5 * (3.0 * lng).cos() + 0.118 * (5.0 * lng).cos()
}
fn deg2meter_lat(lat: f64) -> f64 {
111132.92 - 559.82 * (2.0 *lat).cos() + 1.175 * (4.0 *lat).cos() - 0.0023 * (6.0 *lat).cos()
}
fn get_stops_by_coordinates(c1: Coordinate, c2: Coordinate, r1: f64, r2: f64) -> String {
let result : Vec<Stop> = Vec::new();
@denysvitali
denysvitali / consegna.sh
Created April 8, 2018 19:22
Consegna
#!/bin/bash
SER_NUM=$1
echo ${SER_NUM}
mkdir serie${SER_NUM}
tar -cvf serie${SER_NUM}/serie${SER_NUM}-source.tar.gz ../serie/src/it/denv/supsi/progconc/serie/serie${SER_NUM}
cp ~/Downloads/serie-${SER_NUM}.pdf serie${SER_NUM}/serie-${SER_NUM}.pdf
tar -cvf serie${SER_NUM}.tar.gz serie${SER_NUM}
rm -rf serie${SER_NUM}/
@denysvitali
denysvitali / customer.xml
Created January 27, 2018 22:35
SWC/customer.xml (Swisscom customer.xml from a Galaxy S8+ firmware file)
<?xml version="1.0" encoding="UTF-8"?>
<CustomerData>
<GeneralInfo>
<CSCEdition>ED0008</CSCEdition>
<Country>Switzerland</Country>
<CountryISO>CH</CountryISO>
<Region>EUR</Region>
<SalesCode>SWC</SalesCode>
<NbNetworkInfo>2</NbNetworkInfo>
<NetworkInfo>