Skip to content

Instantly share code, notes, and snippets.

View baditaflorin's full-sized avatar

Florin Badita-Nistor baditaflorin

63 followers · 136 following
View GitHub Profile
@baditaflorin
baditaflorin / r_problems.r
Last active October 11, 2016 23:16
x <- structure(c("2012-09-27 09:08:37", "2012-09-29 10:06:33", "2012-10-01 09:44:36","2012-10-04 14:37:05", "2012-10-15 13:18:21", "2012-10-17 17:33:46","2012-10-18 11:52:13", "2016-10-06 15:11:01", "2016-10-07 13:00:09","2016-10-07 12:20:57"), class = c("xts", "zoo"), .indexCLASS = "Date", tclass = "Date", .indexTZ = "UTC", tzone = "UTC", format = "%Y-%m-%d %H:%M:%S", index = structure(c(1348704000,1348876800, 1349049600, 1349308800, 1350259200, 1350432000, 1350518400,1475712000, 1475798400, 1475798400), tzone = "UTC", tclass = "Date"), .Dim = c(10L,1L))
y <- structure(c("1961-08-04 10:00:00", "1971-01-01 11:00:00", "1978-01-01 11:00:00","1979-01-01 11:00:00", "1983-01-01 11:00:00", "1984-01-01 11:00:00","1985-01-01 11:00:00", "2016-10-07 20:28:24", "2016-10-07 18:27:54","2016-10-08 00:38:40"), class = c("xts", "zoo"), .indexCLASS = "Date", tclass = "Date", .indexTZ = "UTC", tzone = "UTC", format = "%Y-%m-%d %H:%M:%S", index = structure(c(-265420800,31536000, 252460800, 283996800, 410227200, 441763200, 4733
@baditaflorin
baditaflorin / results_NA_highway_length_per_type_different_attr.md
Created September 2, 2016 15:20
name w_highway total_km lanes_km maxspeed_km ref_km surface_km width_km sidewalk_km
canada unclassified 377,649 304,400 134,195 2,789 317,040 166 1,723
canada residential 262,424 213,683 9,844 2,286 166,879 28 11,321
canada tertiary 221,622 200,622 13,024
@baditaflorin
baditaflorin / NA_highway_length_per_type_different_attr.sql
Created September 2, 2016 14:51
-- #Version: 0.1
-- #Author: Florin Badita,Vasile Ceteras
-- #Date: 30.08.16
-- #Website: http://www.openstreetmap.org/user/baditaflorin/diary
-- #Email: [email protected]
-- #Licence AGPLv3+ - https://github.com/baditaflorin/osm-postgis-scripts/blob/master/LICENSE
/* #Example of Use: count the length of highways by type */
-- #Start Code
/* Abrevations list
@baditaflorin
baditaflorin / mapillary2exif.sh
Created August 26, 2016 07:20 — forked from cquest/mapillary2exif.sh
Bash script to copy Mapillary pictures from an iPhone, and update the EXIF data
#!/bin/bash
# This bash script copies pictures from Mapillary folders stored on an iPhone
# then update the pictures EXIF data to get the GPS and timestamp
# written by Christian Quest - August 2016
# requires jq and exiftool, if missing: apt install jq exiftool
# tested on Ubuntu 16.04
# copy Mapillary internal json data (contains GPS info, and more)
rsync /run/user/1000/gvfs/afc*/com.mapillary.app/cameras/internal/ internal -a
@baditaflorin
baditaflorin / postgres-cheatsheet.md
Created July 21, 2016 08:25 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

@baditaflorin
baditaflorin / 50plus.csv
Created September 18, 2015 09:00
We can't make this file beautiful and searchable because it's too large.
1115685144,164,POINT(20.15355 70.3168),"""source""=>""US NGA Pub. 115. 2010-09-09."""," """"man_made""""=>""""lighthouse"""""," """"skv:PTEMA""""=>""""6701"""""," """"skv:OBJTYPE""""=>""""Navigasjonsinstallasjon"""""," """"source:file""""=>""""http://www.vidargundersen.com/osm/N5000_Fyr.osm.bz2"""""," """"seamark:name""""=>""""Fugloykallen"""""," """"seamark:type""""=>""""light_major"""""," """"skv:OBJECTID""""=>""""10"""""," """"skv:OPERATOR""""=>""""borjon"""""," """"skv:SUBTYPEKOD""""=>""""1"""""," """"seamark:light:1:group""""=>""""2"""""," """"seamark:light:1:range""""=>""""12"""""," """"seamark:light:2:group""""=>""""2"""""," """"seamark:light:2:range""""=>""""16"""""," """"seamark:light:3:group""""=>""""2"""""," """"seamark:light:3:range""""=>""""13"""""," """"seamark:light:4:group""""=>""""2"""""," """"seamark:light:4:range""""=>""""16"""""," """"seamark:light:5:group""""=>""""2"""""," """"seamark:light:5:range""""=>""""13"""""," """"seamark:light:6:group""""=>""""2"""""," """"seamark:light:6:range"""
@baditaflorin
baditaflorin / map.geojson
Last active September 18, 2015 08:34
List of nodes POI that have over 100 tags
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@baditaflorin
baditaflorin / 240_instante_unite_linux.csv
Last active September 16, 2015 14:59
numar numar_vechi data institutie departament categorie_caz stadiu_procesual obiect data_modificare nume calitate_parte solutie ultimul_rand
103/280/2003 101/2003 2003-01-09T00:00:00+00:00 JudecatoriaPITESTI Judecatorie Civil Fond anulare titlu propr. 2013-09-20T18:22:10+00:00
108/280/2003 106/2003 2003-01-09T00:00:00+00:00 JudecatoriaPITESTI Judecatorie Civil Fond const.nulit.act.vz.cump. 2013-09-20T18:22:11+00:00 Popa Gheorghe#Popa Valeria#Nanciu Maria# Reclamant#Reclamant#Pârât#
@baditaflorin
baditaflorin / gist:9856e100835e44f47449
Created September 16, 2015 14:54
code insert
DROP TABLE instante CASCADE;
CREATE TABLE instante
( numar varchar,
numar_vechi varchar,
data varchar,
institutie varchar,
departament varchar,
categorie_caz varchar,
studiu_procesual varchar,
obiect varchar,
@baditaflorin
baditaflorin / code
Last active August 29, 2015 14:18
#!/usr/bin/env ruby
# encoding: utf-8
require 'savon'
require 'csv'
startDate = Date.new(2004, 01, 01)
stopDate = Date.today
csvHeaders = ['numar', 'numar_vechi', 'data', 'institutie', 'departament',
'categorie_caz', 'stadiu_procesual', 'obiect', 'data_modificare','nume','calitate_parte','solutie']