This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: '3.8' | |
services: | |
csv2sql: | |
image: csv2sql:latest # Remplacez par le nom/tag de votre image Docker | |
build: ./csv2sql | |
volumes: | |
- data:/home/opam/csvsql | |
entrypoint: /bin/sh -c "while true; do sleep 30; done" # Garder le conteneur en vie pour l'exécution des commandes | |
postgres: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
# -*- coding: utf-8 -*- | |
# Draw psql output as iTerm2 v3 inline graph using matplotlib | |
# Author: Alexander Korotkov <a.korotkov@postgrespro.ru> | |
import sys | |
import re | |
import warnings | |
import matplotlib | |
matplotlib.use("Agg") |
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Initialized native services in: /root/.gradle/native | |
Removing 0 daemon stop events from registry | |
Starting a Gradle Daemon (subsequent builds will be faster) | |
Starting process 'Gradle build daemon'. Working directory: /root/.gradle/daemon/4.10.2 Command: /usr/local/openjdk-8/bin/java -XX:MaxPermSize=4g -Xmx6144M -Dfile.encoding=UTF-8 -Duser.country -Duser.language=en -Duser.variant -cp /root/.gradle/wrapper/dists/gradle-4.10.2-all/9fahxiiecdb76a5g3aw9oi8rv/gradle-4.10.2/lib/gradle-launcher-4.10.2.jar org.gradle.launcher.daemon.bootstrap.GradleDaemon 4.10.2 | |
Successfully started process 'Gradle build daemon' | |
An attempt to start the daemon took 2.389 secs. | |
The client will now receive all logging from the daemon (pid: 1440). The daemon log file: /root/.gradle/daemon/4.10.2/daemon-1440.out.log | |
Starting build in new daemon [memory: 6.2 GB] | |
Using 1 worker leases. | |
Starting Build |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Docker for wireapp-android compiling | |
FROM openjdk:8 as base | |
RUN apt-get clean && \ | |
rm -rf /var/lib/apt/lists/* && \ | |
apt-get update && \ | |
apt-get install -yq libc6 libstdc++6 zlib1g libncurses5 build-essential libssl-dev ruby ruby-dev wget --no-install-recommends docker.io vim unzip apt-utils maven sudo file && \ | |
apt-get clean |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table if exists tmpGeoAdresses; | |
create table tmpGeoAdresses(id text,nom_voie text,id_fantoir text, | |
numero text, rep text,code_insee text,code_post text, | |
alias text,nom_ld text,x float,y float,commune text,fant_voie text, | |
fant_ld text,lat numeric,lon numeric); | |
create table bureauxAdresse(bureau text, adresse text, cp text, ville text); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_01-csv.bz2 && bunzip2 BAN_odbl_01-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_01-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI | |
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_02-csv.bz2 && bunzip2 BAN_odbl_02-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_02-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI | |
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_03-csv.bz2 && bunzip2 BAN_odbl_03-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_03-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI | |
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_04-csv.bz2 && bunzip2 BAN_odbl_04-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_04-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI | |
curl -O http://bano.openstreetmap.fr/BAN_odbl/BAN_odbl_05-csv.bz2 && bunzip2 BAN_odbl_05-csv.bz2 ; echo "copy tmpgeoadresses from 'path_to/BAN_odbl_05-csv' DELIMITERS ',' CSV HEADER;" | psql -d LFI | |
curl -O http://bano.openstreetmap. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Exemple de réutilisation opendata | |
_ _ _ ___ ___ | |
/_\ | \| | __| _ \ | |
/ _ \| .` | _|| / | |
/_/ \_\_|\_|_| |_|_\ | |
Description : installations radioélectriques de plus de 5 watts, hormis celles de l'Aviation Civile et des ministères de la Défense et de l'Intérieur. | |
Les données présentées proviennent d'une base de données de l'ANFR alimentée par tous les exploitants d'installations radioélectriques, | |
publics ou privés, dans le cadre de la procédure administrative prévue par l'article L.43 du code des postes et communications électroniques. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table threePointsData( tid serial primary key, p1 geometry(Point,4326), p2 geometry(Point,4326), p3 geometry(Point,4326),n1 text, n2 text, n3 text, k1 text, v1 text, k2 text, v2 text, k3 text, v3 text, | |
ang double precision, distp1p2 double precision, distp2p3 double precision, distp1p3 double precision, bearing double precision); | |
insert into threePointsData(p1,p2,p3, n1,n2, n3, k1, v1, k2, v2, k3, v3, ang, distp1p2, distp2p3, distp1p3, bearing) | |
SELECT p1.point, p2.point, p3.point, p1.nom, p2.nom, p3.nom, p1.tagk, p1.tagv, p2.tagk, p2.tagv, p3.tagk, p3.tagv, | |
abs | |
( | |
degrees( | |
ST_Azimuth( p3.point , p2.point) -- Pc, Pb | |
- |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var tab = ["Aï-Khanoum,Afghanistan", | |
"Aq Köprük,Afghanistan", | |
"Begrâm,Afghanistan", | |
"Bouddhas de Bâmiyân,Afghanistan", | |
"Bâmiyân,Afghanistan", | |
"Complexe archéologique bactro-margien,Afghanistan", | |
"Minaret et vestiges archéologiques de Djam,Afghanistan", | |
"Hadda,Afghanistan", | |
"Haji Piyada,Afghanistan", | |
"Mes Aynak,Afghanistan", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
open Sequence.Infix | |
type op = | |
| Add | |
| Mult | |
| Div | |
| Minus | |
| Int of int | |
let pp_op out = function |
NewerOlder