Skip to content

Instantly share code, notes, and snippets.

View grischard's full-sized avatar

Guillaume Rischard grischard

90 followers · 194 following
View GitHub Profile
@grischard
grischard / nomatchincaclr-vdl.csv
Created August 23, 2020 18:46
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
"osm_id","url","numero","rue","codepostal","localite","note","way"
48988426,"https://osm.org/way/48988426","4-6","Allée des Poiriers","2360","Luxembourg",,"0103000020110F00000100000007000000E56BFCB7D4EF2441A3AC8651545958410615AFE96BF02441B21DFDEE4259584198B4392697F02441ED6410A748595841851681E36AF024410F0872BD4D5958412E093DB227F024410D26397755595841129DF054FFEF244137A2361B5A595841E56BFCB7D4EF2441A3AC865154595841"
131547447,"https://osm.org/way/131547447","10-14","Allée du Carmel","1354","Luxembourg",,"0103000020110F00000100000009000000A73CBF5956F824413C0366962757584196EF647A9AF82441E251E07C265758415CEA05109EF82441135E9E232A575841CCBAEF3E89F82441769118762A57584148FCDDC591F824417BCBF9E831575841F34EA9C0F1F824415C6DB06D3A575841887342A9D8F824417FBF16D73E575841E396C2CC64F8244109077E8F34575841A73CBF5956F824413C03669627575841"
201399418,"https://osm.org/way/201399418","2-8","Avenue Charles de Gaulle","1653","Luxembourg",,"0103000020110F0000010000000F0000002C07BCC136D82441FEBF3797945458416DD80B745ED824417DC5B4019454584
@grischard
grischard / relhum2humabs.py
Last active August 7, 2020 21:47
def relhum2humabs(relhum, temp):
"""
Relative to Absolute humidity converter:
this gives interpolated AH results from the below
table for relhum values of 10% to 100% and temp values
of -25c to +50c
Parameters: relative humidity (%), temperature (C)
Returns the current absolute humidity (kg/m3?) and the maximum possible at this temperature (kg/m3?)
"""
humray = [
@grischard
grischard / Addresses with no match in CACLR by (street-locality) pair count.tsv
Last active July 5, 2020 21:54
Count Street Locality
1 Aale Wee Buederscheid
1 Allée des Poiriers Luxembourg
1 Allée du Carmel Luxembourg
1 Am Bongert Canach
1 Am Elbert Junglinster
1 Am Happgaart Sandweiler
1 An de Kampen Mertert
1 An der Delt Neunhausen
1 An der Gaessel Colmar-Berg
@grischard
grischard / agglutinated-addresses.csv
Last active June 17, 2020 20:37
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 11 columns, instead of 7 in line 7.
rue,numero,localite,code_postal,id_caclr_rue,id_caclr_bat,lat_wgs84,lon_wgs84,coord_est_luref,coord_nord_luref,id_geoportail
Allée de la Poudrerie,10,Kockelscheuer,1899,2276,84858,49.559593880644755,6.101639986978819,75190.1050000002,69437.00999954632,100A00889002913_2276_10
Allée de la Poudrerie,8,Kockelscheuer,1899,2276,84857,49.559593880644755,6.101639986978819,75190.1050000002,69437.00999954632,100A00889002913_2276_8
An der Schmëdd,11,Hunsdorf,7397,9056,237623,49.69702094569644,6.1315344691089315,77360.1941999996,84720.56099955324,074D00314001451_9056_11
An der Schmëdd,1,Hunsdorf,7397,9056,237618,49.69702094569644,6.1315344691089315,77360.1941999996,84720.56099955324,074D00314001451_9056_1
An der Schmëdd,3,Hunsdorf,7397,9056,237619,49.69702094569644,6.1315344691089315,77360.1941999996,84720.56099955324,074D00314001451_9056_3
An der Schmëdd,5,Hunsdorf,7397,9056,237620,49.69702094569644,6.1315344691089315,77360.1941999996,84720.56099955324,074D00314001451_9056_5
An der Schmëdd,7,Hunsdorf,7397,9056,237621,49
@grischard
grischard / privacy_policy_url.md
Last active March 12, 2020 23:40

These are, grouped by URL, the privacy_policy_url attributes we have in ELI today:

@grischard
grischard / lidar-urls.geojson
Created February 25, 2020 17:34
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@grischard
grischard / place-population.py
Created February 13, 2020 09:27
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
Return GeoJSON centroids with population for each locality in Luxembourg.
BD-Adresses doesn't include communes, so we use the OpenStreetMap community's
csventrifuge output, which has been enriched. The output of this script is
© OpenStreetMap Contributors, see https://openstreetmap.org/copyright.
@grischard
grischard / crashdump
Created November 20, 2019 14:28
Process: postgres [52802]
Path: /usr/local/Cellar/postgresql/11.5_1/bin/postgres
Identifier: postgres
Version: 0
Code Type: X86-64 (Native)
Parent Process: postgres [482]
Responsible: postgres [482]
User ID: 502
Date/Time: 2019-11-20 15:27:38.492 +0100
@grischard
grischard / meteolux-alerts-examples.csv
Created November 14, 2019 16:25
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 2 columns, instead of 1 in line 5.
false;true;Danger potentiel;Avis de chaleur;Dimanche 14:00 à 18:00, pour le sud du pays: Sud du pays: températures maximales prévues autour de 30°C. Faible risque d'orages isolés en soirée.;yellow;09;;2017-06-11 14:00;2017-06-11 18:00sep=;
false;true;Danger potentiel;Avis de chaleur;Dimanche 14:00 à 18:00, pour le sud du pays: Températures maximales aux alentours de 30°C.;yellow;09;;2017-06-11 14:00;2017-06-11 18:00sep=;
false;true;Danger potentiel;Avis de chaleur;Dimanche 14:00 à 18:00, pour le sud du pays: Températures maximales jusqu'à 30°C.;yellow;09;;2017-06-11 14:00;2017-06-11 18:00sep=;
false;true;Danger potentiel;Avis de chaleur;Dimanche 14:00 à 18:00, pour le sud du pays: Températures maximales prévues: 30°C au sud du pays.;yellow;09;;2017-06-11 14:00;2017-06-11 18:00sep=;
false;true;Danger potentiel;Avis de chaleur;Jeudi 14:00 à 17:00, pour le sud du pays: Températures maximales jusqu'à 30°C.;yellow;09;;2017-06-15 14:00;2017-06-15 17:00
false;true;Danger potentiel;Avis de chaleur;Lundi 13:00 à 1
@grischard
grischard / radium crash
Created November 5, 2019 13:38
Process: Radium [29379]
Path: /Applications/Radium.app/Contents/MacOS/Radium
Identifier: com.catpigstudios.Radium3
Version: 3.1.3 (338)
App Item ID: 597611879
App External ID: 813100600
Code Type: X86-64 (Native)
Parent Process: ??? [1]
Responsible: Radium [29379]
User ID: 502