sema+hrsz-bol_linestringek.sql

SELECT st_buildarea(st_union(geom)) FROM (

SELECT p1.pont_id id1, p1.pont_y y1, p1.pont_x x1, p1.pont_h h1,
       p2.pont_id id2, p2.pont_y y2, p2.pont_x x2, p2.pont_h h2,
       st_geomfromtext('LINESTRING('||p1.pont_y||' '||p1.pont_x||','||p2.pont_y||' '||p2.pont_x||')',23700) geom
FROM 9_1078_2018.t_hatarvonal
JOIN 9_1078_2018.t_pont p1 ON p1.pont_id=pont_id_1
JOIN 9_1078_2018.t_pont p2 ON p2.pont_id=pont_id_2
WHERE hatarvonal_id IN (
SELECT hatarvonal_id FROM 9_1078_2018.t_hatar
  WHERE hatar_id IN (
    SELECT hatar_id FROM 9_1078_2018.t_felulet
    WHERE felulet_id IN (
      SELECT felulet_id FROM 9_1078_2018.t_obj_attrbc WHERE helyr_szam='01'
      UNION
      SELECT felulet_id FROM 9_1078_2018.t_obj_attrbd WHERE helyr_szam='01'
    )
  )
)

) g