1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
CREATE VIEW V_ADS1 (NUM_FEUILLE, TYPE_ADS, NUM_DOSSIER, DATREC, PROJ_INSEE, DEM_INSEE, GEOCODE, CO_NOM, ANNEE, TYPE_COMMUNE, DEM_CODE_CM, PROJ_CODE_CM) AS
SELECT NUM_FEUILLE,
TYPE_ADS,
NUM_DOSSIER,
DATREC,
PROJ_INSEE,
GEOCODE,
c.CO_NOM,
c.CO_NOM,
SUBSTR(DATREC,7,4),
CASE WHEN TYPE_ADS='PC' THEN CO_NOM||' - '||'Permis de construire'
WHEN TYPE_ADS='PD' THEN CO_NOM||' - '||'Permis de détruire'
WHEN TYPE_ADS='CU' THEN CO_NOM||' - '||'Certificat d''urbanisme'
END,
v.TOPONYME_VILLE,
v.TOPONYME_VILLE
FROM ADS1 a, COMMUNES c, VOIES_CM v
WHERE c.CO_NUMINSEE = a.PROJ_INSEE AND c.CO_NUMINSEE = a.DEM_INSEE AND v.CODE_CM = DEM_CODE_CM AND V.CODE_CM = PROJ_CODE_CM |
