Dominik Janisch djanisch

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                djanisch
                / keybase.md
            
            
              Created
              February 13, 2021 16:29
            
          
    Keybase proof

I hereby claim:

I am djanisch on github.
I am domjisch (https://keybase.io/domjisch) on keybase.
I have a public key ASC9XhoA533079SkXuKIm-USu8MnWP4S3Ok1AcZ56TV-fgo

To claim this, I am signing this object:

  
## osm-laengste-gerade.sql
-- alle Zuglinien als Relation abfragen
with recursive get_lines as (
	select osm_id, way, row_number() over() as tmp_id from at_osm.planet_osm_line
	where route in ('train', 'railway')
),
-- die einzenen Punkte der Relationen ermitteln
dump_points as (
	select tmp_id, osm_id, path[1] as path_id, geom from get_lines as a inner join lateral st_dumppoints(way) as b on true
),
-- den Winkel zwischen den einzelnen Punkten berechnen
	-- alle Zuglinien als Relation abfragen
	with recursive get_lines as (
	select osm_id, way, row_number() over() as tmp_id from at_osm.planet_osm_line
	where route in ('train', 'railway')
	),
	-- die einzenen Punkte der Relationen ermitteln
	dump_points as (
	select tmp_id, osm_id, path[1] as path_id, geom from get_lines as a inner join lateral st_dumppoints(way) as b on true
	),
	-- den Winkel zwischen den einzelnen Punkten berechnen