Kontrola křižovatek

pocet_nasnapovanych.sql

select count(*) from import.pm_junction_pt j
where (select 1 from import.pm_road_ln r
       where routing is not null and
       r.geometrie && j.geometrie and
       (j.geometrie && ST_StartPoint(r.geometrie) or
        j.geometrie && ST_EndPoint(r.geometrie)) limit 1) is not null;

pocet_nenasnapovanych.sql

select count(*) from import.pm_junction_pt j
where (select 1 from import.pm_road_ln r
       where routing is not null and
       r.geometrie && j.geometrie and
       (j.geometrie && ST_StartPoint(r.geometrie) or
        j.geometrie && ST_EndPoint(r.geometrie)) limit 1) is null
       and (select 1 from import.pm_road_ln r
            where not (ST_Buffer(j.geometrie, 5) && r.geometrie) limit 1) is null;