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 *.*
#!/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'] |
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, |
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# |
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""" |
#!/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 |
-- #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 |
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 |
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 |