dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2022 as annee, 'Bâti vacant' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Bâti vacant' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Bâti vacant' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'L' /* succession */ AND ff2022_dep.d972_fftp_2022_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom
) AS _subq_1_
)" (geom)

dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2023 as annee, 'Bâti vacant' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2023_dep.d972_fftp_2023_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Bâti vacant' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2023_dep.d972_fftp_2023_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Bâti vacant' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'L' /* indivision */ AND ff2023_dep.d972_fftp_2023_pb0010_local.loghvac = 't' /* logement vacant */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom
) AS _subq_1_
)" (geom)

dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2022 as annee, 'Immeubles' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Immeubles' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Immeubles' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pb0010_local INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pb0010_local.logh = 't' /* logement d habitation */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'L' /* litige */ AND ff2022_dep.d972_fftp_2022_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom
) AS _subq_1_
)" (geom)

dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2023 as annee, 'Immeubles' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Immeubles' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Immeubles' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pb0010_local INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pb0010_local.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pb0010_local.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pb0010_local LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pb0010_local.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pb0010_local.logh = 't' /* logement d habitation */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'L' /* litige */ AND ff2023_dep.d972_fftp_2023_pb0010_local.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom

dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2022 as annee, 'Terrains nus' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Terrains nus' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2022 as annee, 'Terrains nus' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle INNER JOIN ff2022_dep.d972_fftp_2022_proprietaire_droit ON ff2022_dep.d972_fftp_2022_proprietaire_droit.idprocpte = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2022_dep.d972_fftp_2022_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2022_dep.d972_fftp_2022_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2022_dep.d972_fftp_2022_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2022_dep.d972_fftp_2022_proprietaire_droit.ccodem = 'L' /* litige */ AND ff2022_dep.d972_fftp_2022_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom

dbname='deal_ods' host=51.38.58.114 port=5432 user='user_deal' key='_uid_' checkPrimaryKeyUnicity='1' table="(SELECT row_number() over () AS _uid_,* FROM (SELECT DISTINCT 2023 as annee, 'Terrains nus' as type_de_bien, 'INDIVISION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'I' /* indivision */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Terrains nus' as type_de_bien, 'SUCCESSION' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'S' /* succession */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom UNION SELECT DISTINCT 2023 as annee, 'Terrains nus' as type_de_bien, 'LITIGE' as demembrement, public.iris_points.nom_iris as iris, CASE WHEN public.iris_points.ycoord is not null then end as geo_point_2d, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar) as nb_biens, ROUND(count(distinct as pourcent_parcelle, public.mque_contours_iris_ge.geom FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle INNER JOIN ff2023_dep.d972_fftp_2023_proprietaire_droit ON ff2023_dep.d972_fftp_2023_proprietaire_droit.idprocpte = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idprocpte LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric LEFT JOIN (SELECT public.iris_points.nom_iris as iris, count(distinct ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar)::decimal as nb_bien_total FROM ff2023_dep.d972_fftp_2023_pnb10_parcelle LEFT JOIN public.cadastre_parcelles_iris ON public.cadastre_parcelles_iris.id = ff2023_dep.d972_fftp_2023_pnb10_parcelle.idpar LEFT JOIN public.iris_points ON public.iris_points.code_iris = public.cadastre_parcelles_iris.code_iris::numeric WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris)a ON public.iris_points.nom_iris = a.iris LEFT JOIN public.mque_contours_iris_ge ON public.mque_contours_iris_ge.code_iris = public.cadastre_parcelles_iris.code_iris WHERE ff2023_dep.d972_fftp_2023_pnb10_parcelle.nlocal = 0 /* terrains nus */ AND ff2023_dep.d972_fftp_2023_proprietaire_droit.ccodem = 'L' /* litige */ AND ff2023_dep.d972_fftp_2023_pnb10_parcelle.catpro2 = 'X1' GROUP BY public.iris_points.nom_iris, public.iris_points.ycoord, public.iris_points.xcoord, nb_bien_total, public.mque_contours_iris_ge.geom