1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE view ddc_appia."VL_DOSSIERDIAETAPEDDC" ("IDDOSSIER", "NOMDOSSIER", "TYPEADS", "DATEDEPOT", "DATEDECISION", "NATUREDECISION", "TYPEDECISION", "GEOREFERENCE", "X", "Y", "ALTITUDE", "REFERENCESCADASTRALES", "DESIGNATIONBIEN") AS (
Select ddc_appia."DOSSIERDEPOT"."ID_DOSSIER" as "IDDOSSIER",
x."NOMDOSSIER",
x."CODEADS" as "TypeADS", DD."DATEDEPOT",
x."DECISIONDATESIGNATURE" as "DateDecision",
("DECISIONPREEMPTION", case "DECISIONPREEMPTION" when 1 then varchar 'Favorable' when 0 then varchar 'Défavorable' end) as "NatureDecision",
("DECISIONPREEMPTION", case "DECISIONPREEMPTION" when Null then 'Null' else 'Préemption' end) as "TypeDecision",
DD."PROVENANCE" as "Georeference",
DD."X",
DD."Y",
DD."Z" as "Altitude",
DD."REFERENCESCADASTRALES",
y."DESIGNATIONBIEN"
From (ddc_appia."DOSSIERDECISIONDIA" right outer join ddc_appia."DOSSIER" on ddc_appia."DOSSIER"."ID_DOSSIER" = ddc_appia."DOSSIERDECISIONDIA"."ID_DOSSIER")x , ddc_appia."DOSSIERDEPOT" DD, (ddc_appia."DOSSIERDESCRIPTIONDIA" right outer join ddc_appia."DOSSIER" on ddc_appia."DOSSIER"."ID_DOSSIER" = ddc_appia."DOSSIERDESCRIPTIONDIA"."ID_DOSSIER")y
Where (ddc_appia."DOSSIER"."ID_DOSSIER" = ddc_appia."DOSSIERDEPOT"."ID_DOSSIER")
And (x."CODEADS" = 'DA')
); |
Partager