Skip to content

Instantly share code, notes, and snippets.

View baditaflorin's full-sized avatar

Florin Badita-Nistor baditaflorin

53 followers · 124 following
View GitHub Profile
@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 / 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
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']