Skip to content

Instantly share code, notes, and snippets.

View lexman's full-sized avatar

Alexandre Bonnasseau lexman

15 followers · 3 following
View GitHub Profile
@lexman
lexman / pg_frontier.sql
Last active August 29, 2015 14:01
Find a possible frontier between two polygons that intersect in several points in PostGIS
CREATE OR REPLACE FUNCTION frontiere(in poly_a geometry, in poly_b geometry) RETURNS geometry AS $frontiere$
DECLARE
borders_intersection geometry;
working_geom geometry;
pct_debut float;
pct_fin float;
curs refcursor;
pt_row record;
prev_abs float;
@lexman
lexman / gist:085c0812be4b5bd46616
Created May 28, 2015 21:35
Test gist.md

Bla bla test

@lexman
lexman / Dockerfile
Last active June 1, 2016 16:23
Dockerfile for tuttle
FROM ubuntu:wily
MAINTAINER Lexman <tuttle@lexman.org>
RUN apt-get update && apt-get install -y python python-psycopg2 postgresql-client python-pip
RUN pip install --upgrade pip
RUN pip install https://github.com/lexman/tuttle/archive/master.zip
RUN chmod +x /usr/local/bin/tuttle*
VOLUME ["/project"]
WORKDIR /project
@lexman
lexman / auto_update_travis.md
Last active July 2, 2016 17:29
Auto update datapackage with travis-ci

Don't want to run the update script of your datapackage by yourself ? Let travis-ci do it for you !

If your datapackage already :

  • has scripts that download the source data, cleans it or reformat it into a nice interoperable format
  • rely on make to run the scripts
  • have tests to validate the data

Then you want to go to the next step... Here's a tutorial to enable regular updates of the data with travis-ci.

@lexman
lexman / fgeoms.wkt
Created November 2, 2016 08:38
Mesure performance of MVT encoding
This file has been truncated, but you can view the full file.
POLYGON ((3374.04019305061 3632.557997917989, 3422.187636559895 3685.289638734976, 3454.846640970636 3689.95330138813, 3433.979223531428 3745.217242354673, 3443.861160390793 3777.258687908703, 3466.564755984164 3782.048913868493, 3560.92024597002 3706.366335737985, 3513.788141754511 3658.018904738914, 3504.074365663987 3603.481306072266, 3522.470039910608 3587.356936344673, 3599.439814760154 3628.77179012695, 3597.272923632862 3658.042583144445, 3636.93522887759 3679.026247330679, 3679.440832776035 3628.889955167455, 3719.774790915282 3636.168475234939, 3712.446682847002 3673.099647333293, 3731.56468575499 3676.199898919382, 3763.858612906955 3633.908711623546, 3800.394288615911 3652.36292862898, 3836.077799390429 3630.850526123366, 3969.013697802403 3688.078395835735, 3993.043027264197 3642.266991736717, 4022.656453745466 3629.923317894427, 4036.239366335848 3580.749338634079, 3986.099747730562 3575.490843150037, 3955.838159275653 3537.861761088105, 3970.121477092962 3462.454421327158, 3937.778873524798 3443
@lexman
lexman / fgeoms.wkt.zip
Last active November 7, 2016 15:46
shapes for benching mappbox-vector-tiles
This file has been truncated, but you can view the full file.
View raw
@lexman
lexman / json_oneline.awk
Created February 24, 2017 15:56
# usage:
# @include "json.awk"
# BEGIN {
# src["hello"] = "world"
# json_save("test.json", src)
# json_load("test.json", dst)
# print dst["hello"]
# }
#
# value:
@lexman
lexman / dontclickhere_drivy.py
Created June 23, 2018 17:02 — forked from sylver/dontclickhere_drivy.py
My solution for Drivy dontclickhere riddle
#!/usr/bin/env python
import sys
from StringIO import StringIO
import requests
from PIL import Image
BASE_URL = 'http://dontclickhere.drivy.com'
CACHE = {}
@lexman
lexman / demande_acces_donnees.txt
Created October 9, 2018 21:06
Demande d'accès aux données personelles
Bonjour,
conformément à la législation sur la protection des données personnelles, je vous écris pour que vous me transmettiez les données que vous possédez sur moi, dans leur intégralité, c'est à dire autant les données brutes receuillies que les résultats de calculs et de modèles.
Par ailleurs, il vous incombe aussi de m'apporter la preuve de consentement d'utilisation des mes données (date, site, texte du consentement, copie d'écran) qui vous autoriserait à me contacter à des fins publicitaires.
Bien que le droit d'accès à mes données qui existe depuis longtemps, je me permet de vous rappeler que depuis le 25 mai dernier, vous avez un mois pour me répondre. Et que si vous ne vous conformez pas à la loi, ou que vous montrez de la mauvaise volonté, vous êtes passibles d'un amende de 20 millions d'euros.
Respectueusement,
@lexman
lexman / graphviz.html
Created November 13, 2018 12:58
Graphviz Example
This file has been truncated, but you can view the full file.
<script type="text/vnd.graphviz" id="graphviz">
digraph workflow {
rankdir="LR";
Node [style="rounded,filled", shape=box, fillcolor=none]
"p_tuttlefile_5" [label="tuttlefile_5", URL="#tuttlefile_5", color=green, fontcolor=green, width=0, height=0] ;
"p_tuttlefile_5" -> "file%3A//departements-pbf"
"file%3A//departements-pbf" [fillcolor=green, label="departements-pbf"] ;
"p_tuttlefile_8" [label="tuttlefile_8", URL="#tuttlefile_8", color=green, fontcolor=green, width=0, height=0] ;
"p_tuttlefile_8" -> "file%3A//zips"