json i postgresql tabell

select
valuatedproperty,
casesid,
t1.prop_value -> 'use_of_property' as use_of_property,
t1.prop_value -> 'use_of_property_code' as use_of_property_code,
t1.prop_value -> 'unity_use' as unity_use,
t1.prop_value -> 'unit_use' as unit_use,
t1.prop_value -> 'year' as year,
t1.prop_value -> 'rec_year' as rec_year,
t1.prop_value -> 'general_info' -> 'grp' -> 'ceilmateriale' as ceilmateriale,
t1.prop_value -> 'general_info' -> 'grp' -> 'wallsmaterial' as walls,
t1.prop_value -> 'general_info' -> 'grp' -> 'heat' as varme_,
t1.prop_value -> 'general_info' -> 'grp' -> 'heat_suppl' as heat_suppl,
t1.prop_value -> 'general_info' -> 'grp' -> 'heat_suppl' as bath,
t1.prop_value -> 'constr_nummer' as constr_nummer,
t1.prop_value -> 'houseareal_nbv' as houseareal_nbv,
t1.konkr_v -> 'location_meters' -> 'coase' -> 'meters' as to_coase,
t1.konkr_v -> 'location_meters' -> 'road' -> 'meters' as to_road,
t1.konkr_v -> 'location_meters' -> 'high_way' -> 'meters' as to_motorroad,
t1.konkr_v -> 'location_meters' -> 'lake' -> 'meters' as to_lake,
t1.konkr_v -> 'location_meters' -> 'railroad' -> 'meters' as to_railroad,
t1.konkr_v -> 'location_meters' -> 'station' -> 'meters' as to_station,
t1.konkr_v -> 'location_meters' -> 'section' -> 'meters' as to_air,
t1.konkr_v -> 'location_meters' -> 'big_water' -> 'meters' as to_pipe,
t1.konkr_v -> 'bush' as bush
from
(
select
d.base_data -> 'grundlag' -> 'valuatedproperty_id' as valuatedproperty,
d.base_data -> 'casesdata' -> 'case' -> 'case_id' as casesid,
jsonb_array_elements(d.base_data -> 'ground' -> 'prop_info' -> 'prop_partial') prop_value,
d.base_data->'ground'->'prop_info' -> 'concrete_impo' as konkr_v
from
rsv_yolacile.juy_dokument d where dokumentgroup like '%RR%') t1;