Skip to content

Instantly share code, notes, and snippets.

View Tristramg's full-sized avatar

Tristram Gräbener Tristramg

89 followers · 3 following
View GitHub Profile
@Tristramg
Tristramg / locinfra.py
Last active February 13, 2024 14:11
locinfra: extraction rk
import csv
import os
class Row:
def __init__(self, row):
self.srv = f"{row['LIGNE']}-{row['TRONCON']}-{row['VOIE']}"
self.longitude = float(row['LONGITUDE'])
self.latitude = float(row['LATITUDE'])
self.pk = float(row['PK'])
@Tristramg
Tristramg / lrs.rs.rs.rs
Last active January 29, 2024 17:01
pub struct Id<T> {
id: String,
_phantom: std::marker::PhantomData<T>,
}
use std::collections::HashMap;
pub struct Topology {
pub metadata: Metadata,
pub networks: Vec<Network>,
@Tristramg
Tristramg / concorde_to_geojson.py
Created August 29, 2023 07:47
communes.tsp
import tsplib95
import geojson
import pyproj
problem = tsplib95.load('communes.tsp')
f = open("out_linkern","r")
lines = f.readlines()[1:]
transformer = pyproj.Transformer.from_crs(2154, 4326, always_xy=True)
coordinates = []
@Tristramg
Tristramg / script.sh
Created April 12, 2023 14:31
Calcul du niveau d’enclave des communes en France
# On importe le tracé des communes dans la base postgres
# Source des données https://geoservices.ign.fr/adminexpress
# -I pour créer un indexe (ça premet de gagner un peu de temps au moment de croiser les données)
# -D pour le format dump, pour que ça aille plus vite
# -s 2154 pour préciser que les données sont projetée en Lambert 93 (même si par la suite ça n’a pas servi comme précision)
shp2pgsql -s 2154 -I -D ADMIN-EXPRESS_3-1__SHP_LAMB93_FXX_2023-03-20/ADMIN-EXPRESS/1_DONNEES_LIVRAISON_2023-03-20/ADE_3-1_SHP_LAMB93_FXX/COMMUNE.shp communes | psql
# Idem pour les côtes
shp2pgsql -I -D -s 2154 Limite_terre_mer_France_metropolitaine/SHAPE/Limite_terre-mer_France_metropolitaine_fermeturesLIMAR.shp cotes | psql
@Tristramg
Tristramg / process.sql
Created August 24, 2020 12:59
ALTER TABLE ways RENAME COLUMN gid TO id,
ALTER TABLE ways ADD COLUMN country text;
ALTER TABLE ways RENAME COLUMN maxspeed_forward TO maxspeed;
ALTER TABLE ways DROP COLUMN maxspeed_backward;
ALTER TABLE ways DROP COLUMN cost_s;
ALTER TABLE ways DROP COLUMN reverse_cost_s;
ALTER TABLE ways DROP COLUMN one_way;
ALTER TABLE ways DROP COLUMN oneway;
ALTER TABLE ways DROP COLUMN priority;
ALTER TABLE ways DROP COLUMN tag_id;
@Tristramg
Tristramg / netex_publisher.py
Created April 17, 2020 07:26
"""
This tool is meant to process GTFS files from transport.data.gouv.fr,
convert them to the NeTEx format,
and upload them as community resources to transport.data.gouv.fr
"""
import logging
import subprocess
import tempfile
import urllib.request
@Tristramg
Tristramg / dawa.py
Last active April 16, 2020 08:24
"""
This tool is meant to process GTFS files from transport.data.gouv.fr,
convert them to the NeTEx format,
and upload them as community resources to transport.data.gouv.fr
"""
import urllib.request
import tempfile
import subprocess
import requests
@Tristramg
Tristramg / recette.py
Created March 30, 2020 12:33
import csv
import json
import os
import shutil
import subprocess
import time
import urllib.request
tartare = "../tartare-tools/target/release/gtfs2netexfr"
url = "https://transport.data.gouv.fr/api/datasets"
@Tristramg
Tristramg / nouvelle_caledonie.sql
Created December 31, 2019 10:21
INSERT INTO commune(nom, insee, surf_ha)
VALUES
('Nouméa', 98818, 4570),
('Bélep', 98801, 6950),
('Boulouparis', 98802, 86560),
('Bourail', 98803, 79760),
('Canala', 98804, 43870),
('Dumbéa', 98805, 25460),
('Farino', 98806, 4800),
('Hienghène', 98807, 106880),
@Tristramg
Tristramg / index.html
Created December 24, 2019 21:45
vanillla js of https://observablehq.com/@tristramg/freespico
<!DOCTYPE html>
<html>
<head>
<title>Freespico</title>
<script src="https://d3js.org/d3-dsv.v1.min.js"></script>
<script src="https://d3js.org/d3-fetch.v1.min.js"></script>
</head>
<body>
<h1>Freespico</h1>
<button onclick="compute()">Find route</button>