Skip to content

Instantly share code, notes, and snippets.

View baditaflorin's full-sized avatar

Florin Badita-Nistor baditaflorin

50 followers · 124 following
View GitHub Profile
@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']
@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 / 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 / map.geojson
Last active September 18, 2015 08:34
List of nodes POI that have over 100 tags
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@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 / 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 / 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: baditaflorin@gmail.com
-- #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 / 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 / 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 / virus.svg
Created November 20, 2016 20:46
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.