Check om adressepunkter ligger inden i bygninger

SELECT
  *
FROM
  kursus.adgangsadresser a
WHERE NOT EXISTS
  (SELECT 1 FROM kursus.bygning b WHERE st_contains(b.wkb_geometry, a.septima_geometri) )

Ligger adressepunkter inden i småbygninger ?

WITH byg_geokod AS (
  SELECT
    b_bbr.byg_anvend_kode,
    b_geodk.wkb_geometry
  FROM
    kursus.bygning b_geodk JOIN
    kursus.co40100t b_bbr ON (b_geodk.septima_bygn_uuid = b_bbr.bygning_id)
)
SELECT
  *
FROM
  kursus.adgangsadresser a JOIN
  byg_geokod bg ON ( st_contains(bg.wkb_geometry, a.septima_geometri) AND bg.byg_anvend_kode > 900);

Find antallet af enheder i hver bygning

SELECT
  b.bygning_id, COUNT(1)
FROM
  kursus.co40100t b JOIN
  kursus.co40200t o ON (b.bygning_id = o.bygning_id) JOIN
  kursus.co40300t eo ON (eo.opgang_id = o.opgang_id)
GROUP BY
  b.bygning_id