/[openfoncier]/trunk/data/pgsql/init_data.sql
ViewVC logotype

Contents of /trunk/data/pgsql/init_data.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 2450 - (show annotations)
Thu Nov 7 18:56:52 2013 UTC (11 years, 2 months ago) by vpihour
File size: 71350 byte(s) 
Ajout de deux nouveaux web-services. Un sortant vers le référentiel ERP qui lui envoie un message en cas d'ajout de pièces sur un dossier AT et un entrant qui va compléter ou clôturer un dossier AT.
1 --------------------------------------------------------------------------------
2 -- Jeu de données
3 --
4 -- @package openfoncier
5 -- @version SVN : $Id$
6 --------------------------------------------------------------------------------
7
8 ---
9 --- UTILISATEURS
10 ---
11
12 INSERT INTO om_utilisateur (om_utilisateur, nom, email, login, pwd, om_collectivite, om_type, om_profil) VALUES
13
14 (2, 'Anonyme', '[email protected]', 'anony', '9163834aac262db4408928dd21608752', 1, 'DB', 1),
15
16 (3, 'Instructeur', '[email protected]', 'instr', 'e1403d6e7f5e9a4b9090db9056e5b08a', 1, 'DB', 3),
17 (4, 'Instructeur 1', '[email protected]', 'instr1', 'e1403d6e7f5e9a4b9090db9056e5b08a', 1, 'DB', 3),
18 (5, 'Instructeur 2', '[email protected]', 'instr2', 'e1403d6e7f5e9a4b9090db9056e5b08a', 1, 'DB', 3),
19
20 (6, 'Service consulté', '[email protected]', 'consu', '0da946569d9461a74e7495ade5719b16', 1, 'DB', 4),
21 (7, 'Service consulté 1', '[email protected]', 'consu1', '0da946569d9461a74e7495ade5719b16', 1, 'DB', 4),
22 (8, 'Service consulté 2', '[email protected]', 'consu2', '0da946569d9461a74e7495ade5719b16', 1, 'DB', 4),
23
24 (9, 'Cellule suivi', '[email protected]', 'suivi', '88a76b5541cd34cea92bc20ec5bf75e2', 1, 'DB', 5),
25
26 (10, 'Guichet Unique', '[email protected]', 'guichet', 'aca8a84cc15c9d23d11e96a15df4f828', 1, 'DB', 6),
27
28 (11, 'Service consulté interne', '[email protected]', 'consuint', '41f5107d08bf85431bf518a48315008b', 1, 'db', 8),
29 (12, 'Visualisation DA et DI', '[email protected]', 'visudadi', 'f5482d356ab55aae5edf5e6146f44644', 1, 'db', 9),
30 (13, 'Visualisation DA', '[email protected]', 'visuda', 'f8d59fd856bf844a90f0968e8acd8cac', 1, 'db', 10),
31 (14, 'Qualificateur', '[email protected]', 'qualif', 'c7f6e8776497fc37bc20c6eae9db1c9d', 1, 'db', 7),
32 (15, 'Divisionnaire', '[email protected]', 'divi', 'a8124c681eeedd309a78db78c6d087b9', 1, 'db', 11),
33 (16, 'Chef de service', '[email protected]', 'chef', 'cbb4581ba3ada1ddef9b431eef2660ce', 1, 'db', 12),
34 (17, 'ldap_instructeur', '[email protected]', 'ldap_instructeur', '84b07083423cf92950e2eb1e2fb1995f', 1, 'ldap', 3),
35 (18, 'ldap_service', '[email protected]', 'ldap_service', 'dfcf7011422a7f19a16e0f92287a37d6', 1, 'ldap', 4)
36 ;
37
38 ---
39 --- DIRECTIONS
40 ---
41
42 INSERT INTO direction VALUES
43
44 (1, 'ADS', 'Direction ADS', 'Direction des autorisations des droits du sol', 'Jeanette Rochefort', NULL, NULL)
45
46 ;
47
48
49 ---
50 --- DIVISIONS
51 ---
52
53 INSERT INTO division(division, code, libelle, chef, direction, om_validite_debut, om_validite_fin) VALUES
54
55 (22, 'H', 'subdivision H', 'Paien Labossière', 1, NULL, NULL),
56 (23, 'J', 'subdivision J', 'Stéphane Cartier', 1, NULL, NULL)
57
58 ;
59
60
61 ---
62 --- INSTRUCTEURS
63 ---
64
65 INSERT INTO instructeur VALUES
66
67 (1, 'Louis Laurent', NULL, 22,
68 (SELECT om_utilisateur from om_utilisateur where login='instr')
69 , NULL, NULL),
70 (2, 'Martine Nadeau', NULL, 22,
71 (SELECT om_utilisateur from om_utilisateur where login='instr1')
72 , NULL, NULL),
73 (3, 'Roland Richard', NULL, 23,
74 (SELECT om_utilisateur from om_utilisateur where login='instr2')
75 , NULL, NULL),
76 (4, 'Pierre Martin', NULL, 22,
77 (SELECT om_utilisateur FROM om_utilisateur WHERE login='divi')
78 , NULL, NULL),
79 (5, 'ldap_instructeur', NULL, 22,
80 (SELECT om_utilisateur from om_utilisateur where login='ldap_instructeur')
81 , NULL, NULL)
82 ;
83
84
85
86 ---
87 --- ARCHITECTES
88 ---
89
90 INSERT INTO architecte VALUES (nextval('architecte_seq'), 'Mercier', 'Paul', '113 boulevard de pont de vivaux', '', '13010', 'Marseille', 'France', '054645', '0497856235', '0497856236', '[email protected]', '', true);
91 INSERT INTO architecte VALUES (nextval('architecte_seq'), 'Mercier', 'Jean', '113 boulevard de pont de vivaux', '', '13010', 'Marseille', 'France', '56454', '0491352689', '0491352685', '[email protected]', '', true);
92
93 --
94 -- pg_dump -a -t openads.service -t openads.service_categorie -t openads.lien_service_om_utilisateur -t openads.lien_service_service_categorie -t openads.arrondissement -t openads.quartier -t openads.dossier_autorisation -t openads.dossier -t openads.signataire_arrete -t openads.instruction -t openads.demande -t openads.demandeur -t openads.lien_demande_demandeur -t openads.lien_dossier_autorisation_demandeur -t openads.lien_dossier_demandeur -t openads.lot -t openads.lien_dossier_lot -t openads.lien_lot_demandeur -t openads.commission -t openads.commission_type -t openads.dossier_commission openads > /tmp/init_data.sql
95 --
96
97 --
98 -- PostgreSQL database dump
99 --
100
101 --
102 -- Data for Name: arrondissement; Type: TABLE DATA; Schema: openads; Owner: postgres
103 --
104
105 COPY arrondissement (arrondissement, libelle, code_postal, code_impots) FROM stdin;
106 1 1 13001 201
107 2 2 13002 202
108 3 3 13003 203
109 4 4 13004 204
110 5 5 13005 205
111 6 6 13006 206
112 7 7 13007 207
113 8 8 13008 208
114 9 9 13009 209
115 10 10 13010 210
116 11 11 13011 211
117 12 12 13012 212
118 13 13 13013 213
119 14 14 13014 214
120 15 15 13015 215
121 16 16 13016 216
122 \.
123
124
125 --
126 -- Data for Name: quartier; Type: TABLE DATA; Schema: openads; Owner: postgres
127 --
128
129 COPY quartier (quartier, arrondissement, code_impots, libelle) FROM stdin;
130 1 1 801 01 – BELSUNCE
131 2 1 802 02 – CHAPITRE
132 3 1 803 03 – NOAILLE
133 4 1 804 04 – OPERA
134 5 1 805 05 – ST. CHARLES
135 6 1 806 06 – THIERS
136 7 2 807 01 – ARENC
137 8 2 808 02 – LES GRANDS CARMES
138 9 2 809 03 – HOTEL DE VILLE
139 10 2 810 04 – JOLIETTE
140 11 3 811 01 – BELLE DE MAI
141 12 3 812 03 – ST. LAZARE
142 13 3 813 04 – ST. MAURONT
143 14 3 814 02 – LA VILETTE
144 15 4 815 01 – LA BLANCARDE
145 16 4 816 02 – LES CHARTREUX
146 17 4 817 03 – CHUTES LAVIES
147 18 4 818 04 – CINQ AVENUES
148 19 5 819 01 – BAILLE
149 20 5 820 02 – LE CAMAS
150 21 5 821 03 – LA CONCEPTION
151 22 5 822 04 – ST. PIERRE
152 23 6 823 01 – CASTELLANE
153 24 6 824 02 – LODI
154 25 6 825 03 – N. DAME DU MONT
155 26 6 826 04 – PALAIS DE JUSTICE
156 27 6 827 05 – PREFECTURE
157 28 6 828 06 – VAUBAN
158 29 7 829 01 – BOMPARD
159 30 7 830 02 – ENDOUME
160 31 7 831 07 – LES ILES
161 32 7 832 03 – PHARO
162 33 7 833 04 – ROUCAS BLANC
163 34 7 834 06 – ST LAMBERT
164 35 7 835 05 – ST. VICTOR
165 36 8 836 01 – BONNEVEINE
166 37 8 837 02 – LES GOUDES
167 38 8 838 03 – MONTREDON
168 39 8 839 04 – PERIER
169 40 8 840 05 – LA PLAGE
170 41 8 841 06 – LA POINTE ROUGE
171 42 8 842 07 – ROUET
172 43 8 843 09 – ST. GINIEZ
173 44 8 844 08 – STE ANNE
174 45 8 845 10 – VIEILLE CHAPELLE
175 46 9 846 01 – LES BAUMETTES
176 47 9 847 02 – LE CABOT
177 48 9 848 03 – CARPAGNE
178 49 9 849 04 – MAZARGUES
179 50 9 850 05 – LA PANOUSE
180 51 9 851 06 – LE REDON
181 52 9 852 08 – SORMIOU
182 53 9 853 07 – STE MARGUERITE
183 54 9 854 09 – VAUFREGES
184 55 10 855 01 – CAPELETTE
185 56 10 856 02 – MENPENTI
186 57 10 857 03 – PONT DE VIVAUX
187 58 10 858 04 – ST. LOUP
188 59 10 859 05 – ST. TRONC
189 60 10 860 06 – LA TIMONE
190 61 11 861 01 – LES ACCATES
191 62 11 862 02 – LA BARASSE
192 63 11 863 03 – LES CAMOINS
193 64 11 864 04 – EOURES
194 65 11 865 05 – LA MILLIERE
195 66 11 866 06 – LA POMME
196 67 11 867 07 – ST. MARCEL
197 68 11 868 08 – ST. MENET
198 69 11 869 09 – LA TREILLE
199 70 11 870 10 – LA VALBARELLE
200 71 11 871 11 – LA VALENTINE
201 72 12 872 01 – LES CAILLOLS
202 73 12 873 02 – LA FOURRAGERE
203 74 12 874 03 – MONTOLIVET
204 75 12 875 04 – ST. BARNABE
205 76 12 876 05 – ST. JEAN DU DESERT
206 77 12 877 06 – ST. JULIEN
207 78 12 878 07 – LES TROIS LUCS
208 79 13 879 01 – CHÂTEAU GOMBERT
209 80 13 880 02 – LA CROIX ROUGE
210 81 13 881 03 – MALPASSE
211 82 13 882 04 – LES MEDECINS
212 83 13 883 05 – LES MOURETS
213 84 13 884 06 – LES OLIVES
214 85 13 885 07 – PALAMA
215 86 13 886 08 – LA ROSE
216 87 13 887 09 – ST. JEROME
217 88 13 888 10 – ST. JUST
218 89 13 889 11 – ST. MITRE
219 90 14 890 01 – LES ARNAVAUX
220 91 14 891 02 – BON SECOURS
221 92 14 892 03 – LE CANET
222 93 14 893 04 – LE MERLAN
223 94 14 894 05 – ST. BARTHELEMY
224 95 14 895 06 – ST. JOSEPH
225 96 14 896 07 – STE MARTHE
226 97 15 897 01 – LES AYGALADES
227 98 15 898 02 – BOREL
228 99 15 899 03 – LA CABUCELLE
229 100 15 900 04 – LA CALADE
230 101 15 901 05 – LES CROTTES
231 102 15 902 06 – LA DELORME
232 103 15 903 07 – N. DAME LIMITE
233 104 15 904 08 – ST. ANTOINE
234 105 15 905 09 – ST. LOUIS
235 106 15 906 10 – VERDURON
236 107 15 907 11 – LA VISTE
237 108 16 908 01 – L'ESTAQUE
238 109 16 909 02 – LES RIAUX
239 110 16 910 03 – ST. ANDRE
240 111 16 911 04 – ST. HENRI
241 \.
242
243
244 --
245 -- Data for Name: affectation_automatique; Type: TABLE DATA; Schema: openads; Owner: postgres
246 --
247
248 COPY affectation_automatique (affectation_automatique, arrondissement, quartier, section, instructeur, dossier_autorisation_type_detaille) FROM stdin;
249 3 \N \N \N 3 3
250 4 1 1 \N 4 1
251 2 1 2 \N 2 1
252 1 \N \N \N 1 \N
253 \.
254
255
256 --
257 -- Name: affectation_automatique_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
258 --
259
260 SELECT pg_catalog.setval('affectation_automatique_seq', 5, false);
261
262
263 --
264 -- Name: arrondissement_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
265 --
266
267 SELECT pg_catalog.setval('arrondissement_seq', 17, false);
268
269
270 --
271 -- Data for Name: commission_type; Type: TABLE DATA; Schema: openads; Owner: postgres
272 --
273
274 COPY commission_type (commission_type, code, libelle, lieu_adresse_ligne1, lieu_adresse_ligne2, lieu_salle, listes_de_diffusion, participants, corps_du_courriel, om_validite_debut, om_validite_fin) FROM stdin;
275 1 CTU Commission Technique d'Urbanisme 40 rue Fauchier 13001 MARSEILLE \N fmichon@atreal.fr\nsupport@atreal.fr David CHEVALIER\nGuillaume LAMBERT Vous trouverez en pièces jointes les documents cités en objet du mail \N \N
276 \.
277
278
279 --
280 -- Data for Name: commission; Type: TABLE DATA; Schema: openads; Owner: postgres
281 --
282
283 COPY commission (commission, code, commission_type, libelle, date_commission, heure_commission, lieu_adresse_ligne1, lieu_adresse_ligne2, lieu_salle, listes_de_diffusion, participants, om_fichier_commission_ordre_jour, om_final_commission_ordre_jour, om_fichier_commission_compte_rendu, om_final_commission_compte_rendu) FROM stdin;
284 1 CTU20121201 1 Commission Technique d'Urbanisme 2012-12-01 15:00 40 rue Fauchier 13001 MARSEILLE 2a [email protected]\[email protected] David CHEVALIER\nGuillaume LAMBERT \N \N \N \N
285 \.
286
287
288 --
289 -- Name: commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
290 --
291
292 SELECT pg_catalog.setval('commission_seq', 2, false);
293
294
295 --
296 -- Name: commission_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
297 --
298
299 SELECT pg_catalog.setval('commission_type_seq', 2, false);
300
301
302 --
303 -- Data for Name: dossier_autorisation; Type: TABLE DATA; Schema: openads; Owner: postgres
304 --
305
306 COPY dossier_autorisation (dossier_autorisation, dossier_autorisation_type_detaille, exercice, insee, terrain_references_cadastrales, terrain_adresse_voie_numero, terrain_adresse_voie, terrain_adresse_lieu_dit, terrain_adresse_localite, terrain_adresse_code_postal, terrain_adresse_bp, terrain_adresse_cedex, terrain_superficie, arrondissement, depot_initial, erp_numero_batiment, erp_ouvert, erp_date_ouverture, erp_arrete_decision, erp_date_arrete_decision, numero_version, etat_dossier_autorisation, date_depot, date_decision, date_validite, date_chantier, date_achevement, avis_decision, etat_dernier_dossier_instruction_accepte, dossier_autorisation_libelle) FROM stdin;
307 PC0130551200001 1 \N 01234 \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N PC 013055 12 00001
308 PC0130551200002 2 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N PC 013055 12 00002
309 PD0130551200001 3 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N PD 013055 12 00001
310 DP0130551200001 5 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N DP 013055 12 00001
311 CU0130551200001 6 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N CU 013055 12 00001
312 AZ0130551200001 7 \N \N 123ab001; 113 boulevard pont de vivaux \N Marseille 13010 \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N AZ 013055 12 00001
313 AT0130551200001 8 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 1 \N \N \N \N \N \N \N AT 013055 12 00001
314 PA0130551200001 4 \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 \N \N \N \N \N 0 2 2012-12-17 2010-08-01 2012-08-01 \N \N 8 2 PA 013055 12 00001
315 AT0130551300001 8 \N \N \N \N \N \N \N \N \N \N \N \N 2013-11-06 \N \N \N \N \N 0 1 2013-11-06 \N \N \N \N \N \N AT 013055 13 00001
316 \.
317
318
319 --
320 -- Data for Name: dossier; Type: TABLE DATA; Schema: openads; Owner: postgres
321 --
322
323 COPY dossier (dossier, annee, etat, instructeur, date_demande, date_depot, date_complet, date_rejet, date_notification_delai, delai, date_limite, accord_tacite, date_decision, date_validite, date_chantier, date_achevement, date_conformite, parcelle, pos, sig, batiment_nombre, logement_nombre, shon, shon_calcul, shob, lot, hauteur, piece_nombre, amenagement, parcelle_lot, parcelle_lot_lotissement, description, temp1, temp2, temp3, temp4, temp5, servitude, erp, avis_decision, enjeu_erp, enjeu_urba, division, autorite_competente, a_qualifier, terrain_references_cadastrales, terrain_adresse_voie_numero, terrain_adresse_voie, terrain_adresse_lieu_dit, terrain_adresse_localite, terrain_adresse_code_postal, terrain_adresse_bp, terrain_adresse_cedex, terrain_superficie, dossier_autorisation, dossier_instruction_type, date_dernier_depot, version, incompletude, evenement_suivant_tacite, evenement_suivant_tacite_incompletude, etat_pendant_incompletude, date_limite_incompletude, delai_incompletude, dossier_libelle, numero_versement_archive, duree_validite, geom, geom1) FROM stdin;
324 PC0130551200001P0 notifier 2 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f \N \N \N \N \N \N \N \N \N PC0130551200001 1 2012-12-17 0 f \N \N \N \N \N PC 013055 12 00001P0 \N 0 01010000206A080000CDCCCCCC0EFE2941295C8FC2DD2AFC40 \N
325 PD0130551200001P0 notifier 3 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 23 3 f 805AB0009; \N \N \N \N \N \N \N \N PD0130551200001 11 2012-12-17 0 f \N \N \N \N \N PD 013055 12 00001P0 \N 0 \N \N
326 DP0130551200001P0 notifier 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f \N \N \N \N \N \N \N \N \N DP0130551200001 21 2012-12-17 0 f \N \N \N \N \N DP 013055 12 00001P0 \N 0 \N \N
327 CU0130551200001P0 notifier 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f \N \N \N \N \N \N \N \N \N CU0130551200001 26 2012-12-17 0 f \N \N \N \N \N CU 013055 12 00001P0 \N 0 \N \N
328 AZ0130551200001P0 notifier 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f 806AB0001A0005; 113 boulevard pont de vivaux \N Marseille 13010 \N \N \N AZ0130551200001 31 2012-12-17 0 f \N \N \N \N \N AZ 013055 12 00001P0 \N 0 \N \N
329 AT0130551200001P0 notifier 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f \N \N \N \N \N \N \N \N \N AT0130551200001 36 2012-12-17 0 f 64 \N \N \N \N AT 013055 12 00001P0 \N 0 \N \N
330 PA0130551200001P0 accepter 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui 2010-08-01 2012-08-01 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f 8 f f 22 1 f \N \N \N \N \N \N \N \N \N PA0130551200001 16 2012-12-17 0 f \N \N \N \N \N PA 013055 12 00001P0 \N 0 \N \N
331 PC0130551200002P0 notifier 1 2012-12-17 2012-12-17 2012-12-17 \N 2013-01-17 2 2013-02-17 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f 22 1 f \N \N \N \N \N \N \N \N \N PC0130551200002 6 2012-12-17 0 f \N \N \N \N \N PC 013055 12 00002P0 \N 0 \N \N
332 AT0130551300001P0 incomplet \N 2013-11-06 2013-11-06 2013-11-06 \N 2013-12-06 2 2014-01-06 Oui \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N f f \N \N t \N \N \N \N \N \N \N \N \N AT0130551300001 36 2013-11-06 0 f \N \N \N \N \N AT 013055 13 00001P0 \N 0 \N \N
333 \.
334
335
336 --
337 -- Data for Name: service; Type: TABLE DATA; Schema: openads; Owner: postgres
338 --
339
340 COPY service (abrege, libelle, adresse, adresse2, cp, ville, email, delai, service, consultation_papier, notification_email, om_validite_debut, om_validite_fin, type_consultation) FROM stdin;
341 59.02 Atelier du Patrimoine Square Belsunce 13001 Marseille 1 2 f f 2000-01-01 2100-01-01 pour_conformite
342 59.06 Direction de la Circulation Place de la Joliette CUMPM - Les Docks - Atrium 10.7 13002 Marseille 1 6 f f 2000-01-01 2100-01-01 pour_conformite
343 59.07 Service de l' Espace Public Rue Mongrand 13006 Marseille 0 7 f f 2000-01-01 2100-01-01 pour_information
344 59.08 Division Prévention des Marins Pompiers / PREV Boulevard de Strasbourg 13303 Marseille Cedex 3 1 8 f f 2000-01-01 2100-01-01 pour_information
345 59.12 Direction de la Propreté Urbaine DOCTEUR HECKEL 13011 Marseille 0 12 f f 2000-01-01 2100-01-01 pour_information
346 59.13 Régie des Tranports de Marseille - DTP/CIP du Métro 13013 Marseille 0 13 f f 2000-01-01 2100-01-01 avec_avis_attendu
347 59.15 DGST - Service de l'Espace Urbain 320-330, Avenue du Prado 13008 Marseille 0 15 f f 2000-01-01 2100-01-01 avec_avis_attendu
348 59.17 Conseil Général des BDR - Direction des Routes Avenue Joseph Vidal 13285 Marseille cedex 08 0 17 f f 2000-01-01 2100-01-01 avec_avis_attendu
349 59.22 Architecte des Bâtiments de France (Sites) Place de la Joliette - Les Docks S.D.A.P. des Bouches du Rhône 13567 Marseille cedex 02 1 22 f f 2000-01-01 2100-01-01 avec_avis_attendu
350 59.25 Agence d'Urbanisme de l'Agglomération de Marseille La Canebière 13001 Marseille 1 25 f f 2000-01-01 2100-01-01 avec_avis_attendu
351 59.31 Direction Opérationnelle des Télécommunications Chemin du Sablier 13008 Marseille 0 31 f f 2000-01-01 2100-01-01 avec_avis_attendu
352 59.39 Service Logement S.A.H. - Changement d'usage Rue Colbert 13001 Marseille 0 39 f f 2000-01-01 2100-01-01 avec_avis_attendu
353 59.43 Direction Dép de l'Inspection Sanitaire et Sociale Rue Saint Sébastien Programmation et Equipement 13006 Marseille 0 43 f f 2000-01-01 2100-01-01 avec_avis_attendu
354 59.45 Préfecture, Service des Etablissements Classés Place de la Préfecture Hôtel de la Préfecture 13006 Marseille 0 45 f f 2000-01-01 2100-01-01 avec_avis_attendu
355 59.49 Service des Armées Caserne Audéoud Place de la Corderie 13002 Marseille 0 49 f f 2000-01-01 2100-01-01 avec_avis_attendu
356 59.50 Direction des Services Concédés et des S.E.M. Rue Colbert 13001 Marseille 1 50 f f 2000-01-01 2100-01-01 avec_avis_attendu
357 59.51 Direction de la Protection Civile Rue Nau 13005 Marseille 0 51 f f 2000-01-01 2100-01-01 avec_avis_attendu
358 59.52 Chambre de Commerce et d'Industrie de Marseille Palais de la Bourse 13001 Marseille 0 52 f f 2000-01-01 2100-01-01 avec_avis_attendu
359 59.54 Direction des Opérations Funéraires Rue Saint Pierre 13005 Marseille 1 54 f f 2000-01-01 2100-01-01 avec_avis_attendu
360 59.57 Télédiffusion de France Allée Ray Grassi 13008 Marseille 0 57 f f 2000-01-01 2100-01-01 avec_avis_attendu
361 59.59 DDTM 13 - Service de la Mer et du Littoral rue Antoine Zattara 13332 Marseille cedex3 0 59 f f 2000-01-01 2100-01-01 avec_avis_attendu
362 59.60 SO.MI.MAR M.I.N. des Arnavaux 13014 Marseille 0 60 f f 2000-01-01 2100-01-01 avec_avis_attendu
363 59.61 RTE - GET PROVENCE ALPES DU SUD rue Louis Lépine Les Chabauds Nord 13330 Bouc Bel Air 1 61 f f 2000-01-01 2100-01-01 avec_avis_attendu
364 59.64 Direction des Sports Allée Ray Grassi 13008 Marseille 1 63 f f 2000-01-01 2100-01-01 avec_avis_attendu
365 59.67 GDF Exploitation Transport Rue de Lyon 13015 Marseille 0 66 f f 2000-01-01 2100-01-01 avec_avis_attendu
366 59.68 Direction de l' Eclairage Public Rue Sénac 13001 Marseille 1 67 f f 2000-01-01 2100-01-01 avec_avis_attendu
367 59.70 AUTRE 0 69 f f 2000-01-01 2100-01-01 avec_avis_attendu
368 59.71 Direction Régionale Industrie Recherche Avenue du Prado 13008 Marseille 0 70 f f 2000-01-01 2100-01-01 avec_avis_attendu
369 59.73 Dir. Départementale des Territoires et de la Mer Antoine Zattara 13332 Marseille cedex 3 0 72 f f 2000-01-01 2100-01-01 avec_avis_attendu
370 59.78 Direction des Handicapés Avenue du Prado Cellule Accessibilité 13008 Marseille 0 77 f f 2000-01-01 2100-01-01 avec_avis_attendu
371 1ER Maire 1er Secteur 0 501 f f 2000-01-01 2100-01-01 avec_avis_attendu
372 2EME Maire 2ème Secteur 0 502 f f 2000-01-01 2100-01-01 avec_avis_attendu
373 3EME Maire 3ème Secteur 0 503 f f 2000-01-01 2100-01-01 avec_avis_attendu
374 4EME Maire 4ème Secteur 0 504 f f 2000-01-01 2100-01-01 avec_avis_attendu
375 5EME Maire 5ème Secteur 0 505 f f 2000-01-01 2100-01-01 avec_avis_attendu
376 6EME Maire 6ème Secteur 0 506 f f 2000-01-01 2100-01-01 avec_avis_attendu
377 7EME Maire 7ème Secteur 0 507 f f 2000-01-01 2100-01-01 avec_avis_attendu
378 8EME Maire 8ème Secteur 0 508 f f 2000-01-01 2100-01-01 avec_avis_attendu
379 59.14 Société Nationale des Chemins de Fer Français Esplanade Saint-Charles 13001 Marseille 0 14 f f 2000-01-01 2100-01-01 avec_avis_attendu
380 59.19 Architecte des Bâtiments de France (Monuments) Place de la Joliette - Les Docks S.D.A.P. des Bouches du Rhône 13567 Marseille cedex 02 1 19 f f 2000-01-01 2100-01-01 avec_avis_attendu
381 59.21 Préfet, Direction des Affaires Décentralisées Monsieur le Préfet des Bouches du Rhône Bureau de l'Urbanisme et Protection d 13282 Marseille Cedex 6 0 21 f f 2000-01-01 2100-01-01 avec_avis_attendu
382 59.26 Direction des Infrastructures - CUMPM BP 48014 13567 Marseille Cedex 02 0 26 f f 2000-01-01 2100-01-01 avec_avis_attendu
383 59.30 Orange France Rue Jacques Réattu - Buroparc Bât H Unité de Pilotage Réseau Sud Est 13009 Marseille 0 30 f f 2000-01-01 2100-01-01 avec_avis_attendu
384 59.38 Direction Développement Economique, Affaires Int. Rue Henri Barbusse 13001 Marseille 1 38 f f 2000-01-01 2100-01-01 avec_avis_attendu
385 59.42 Commision Départ. de l'Aménagement Commercial Préfecture des Bouches du Rhône - DCSE Boulevard Paul Peytral 13282 Marseille Cedex 20 0 42 f f 2000-01-01 2100-01-01 avec_avis_attendu
386 59.44 Direction Dép. de l'Action Sanitaire et Sociale Rue Saint Sébastien Service de l'Inadaptation et de la Prog 13006 Marseille 0 44 f f 2000-01-01 2100-01-01 avec_avis_attendu
387 59.46 Société des Eaux de la Ville de Marseille Rue Edouard Delanglade 13006 Marseille 1 46 f f 2000-01-01 2100-01-01 avec_avis_attendu
388 59.48 Port Autonome de la Ville de Marseille Place de la Joliette 13002 Marseille 1 48 f f 2000-01-01 2100-01-01 avec_avis_attendu
389 59.72 DDTM 13 - Service Urbanisme Antoine Zattara 13332 Marseille cedex 3 0 71 f f 2000-01-01 2100-01-01 avec_avis_attendu
390 59.77 Brigade Domaniale - Centre des Impôts de Ste Anne Boulevard Baptiste Bonnet 13285 Marseille Cedex 8 0 76 f f 2000-01-01 2100-01-01 avec_avis_attendu
391 59.83 Direction Régionale des Affaires Culturelles Boulevard du Roy René 13617 Aix en Provence cedex 1 0 79 f f 2000-01-01 2100-01-01 avec_avis_attendu
392 59.84 Direction Régionale des Antiquités Service de la Conservation Régionale de Historiques 13617 Aix en Provence Cedex 0 80 f f 2000-01-01 2100-01-01 avec_avis_attendu
393 59.10 MARSEILLE AMENAGEMENT - SOLEAM La Canebière 13001 MARSEILLE 0 511 f f 2000-01-01 2100-01-01 avec_avis_attendu
394 59.10 Grand Projet Ville Boulevard du Capitaine Gèze 13015 MARSEILLE 0 512 f f 2000-01-01 2100-01-01 avec_avis_attendu
395 59.44 Direction Départ. des Services Vétérinaires Rue Saint Sébastien BP 23 Cédex 6 13447 MARSEILLE 0 513 f f 2000-01-01 2100-01-01 avec_avis_attendu
396 59.10 Service Prévention et Sécurité du Public ZÃ R Avenue Alexandre Dumas 13008 MARSEILLE 0 519 f f 2000-01-01 2100-01-01 avec_avis_attendu
397 59.36 Service Conseil et Droit de l 'Urbanisme Place François Mireur 13001 MARSEILLE 0 36 f f 2000-01-01 2100-01-01 avec_avis_attendu
398 59.10 ETABLISSEMENT PUBLIC EUROMEDITERRANEE PLACE DE LA JOLIETTE LES DOCKS BP 52620 13567 MARSEILLE CEDEX 02 0 528 f f 2000-01-01 2100-01-01 avec_avis_attendu
399 59.20 Direction Voirie et Entretien des Espaces Publics Allée de la Voirie 13014 Marseille 1 20 f f 2000-01-01 2100-01-01 avec_avis_attendu
400 59.69 D.G.de l'Architecture et des Bâtiments Communaux Boulevard de Louvain 13008 Marseille 1 68 f f 2000-01-01 2100-01-01 avec_avis_attendu
401 59.10 MISSION METRO - TRAMWAY PLACE DE LA JOLIETTE 13567 MARSEILLE cedex 02 0 531 f f 2000-01-01 2100-01-01 avec_avis_attendu
402 59.10 DIRECTION DES PORTS ET AEROPORTS PLACE DE LA JOLIETTE BP 48014 13002 MARSEILLE cedex 02 0 532 f f 2000-01-01 2100-01-01 avec_avis_attendu
403 59.11 DIRECTION DES SYSTEMES D'INFORMATION AV ROGER SALENGRO 13003 MARSEILLE 0 533 f f 2000-01-01 2100-01-01 avec_avis_attendu
404 59.79 Commission Départ. d'Accessibilité aux Handicapés Antoine Zattara D.D.T.M. 13 / Service Construction - Ac 13332 Marseille 0 538 f f 2000-01-01 2100-01-01 avec_avis_attendu
405 59.87 CUMPM - DUAEIC - Service Hab. Pol. de la Ville Les Docks - Atrium 10.7 BP48014 13567 Marseille Cedex 02 0 539 f f 2000-01-01 2100-01-01 avec_avis_attendu
406 59.01 Direction de l'Eau et de l'Assainissement - SPANC Boulevard Joseph Vernet 13008 Marseille 0 540 f f 2000-01-01 2100-01-01 avec_avis_attendu
407 59.01 SERAM Capitaine Geze BP 10256 13308 Marseille Cedex 14 0 541 f f 2000-01-01 2100-01-01 avec_avis_attendu
408 59.88 DAE - RESID TOURISME ET HOTELIER 0 542 f f 2000-01-01 2100-01-01 avec_avis_attendu
409 59.11 LE TRAM RUE SAINT PIERRE 13005 MARSEILLE 0 543 f f 2000-01-01 2100-01-01 avec_avis_attendu
410 59.32 Ministère de la Défense / Armée de l'Air Etat-Major de la Région Aérienne Sud Section Environnement Aéronautique - BP 33998 BORDEAUX Armées 0 544 f f 2000-01-01 2100-01-01 avec_avis_attendu
411 59.89 DRAC Monuments Historiques Pôle Recherche et Valorisation du Pa 23, Boulevard du Roy René 13617 Aix en Provence Cedex 1 1 546 f f 2000-01-01 2100-01-01 avec_avis_attendu
412 59.90 DRAC Archéologie Service Régional de l'Archéologie 23, Boulevard du Roy René 13617 Aix en Provence Cedex 1 0 547 f f 2000-01-01 2100-01-01 avec_avis_attendu
413 999 Transmission Monsieur le Préfet DCLCV 4eme BUREAU URBANISME BD PAUL PETRAL 13282 MARSEILLE CEDEX 1 549 f f 2000-01-01 2100-01-01 avec_avis_attendu
414 59.11 Division Prévention Marins Pompiers/ERP Boulevard de Strasbourg 13303 Marseille Cedex 3 0 550 f f 2000-01-01 2100-01-01 avec_avis_attendu
415 59.82 Société Marseillaise du Tunnel Prado Carénage Avenue Arthur Scott BP 40 13448 Marseille Cantini Cedex 1 552 f f 2000-01-01 2100-01-01 avec_avis_attendu
416 59.63 Direction de la Petite Enfance DGEPE (crèches) Rue des Convalescents 13233 Marseille Cedex 20 0 553 f f 2000-01-01 2100-01-01 avec_avis_attendu
417 59.81 Direction de l'Education DGEPE Rue des Convalescents 13233 Marseille cedex 20 1 560 f f 2000-01-01 2100-01-01 avec_avis_attendu
418 59.73 Direction Régionale de l'Environnement PACA Le Tholonet - BP 120 13603 Aix en Provence - Cedex 01 0 561 f f 2000-01-01 2100-01-01 avec_avis_attendu
419 59.47 ERDF-MED-ACCUEIL-URBANISME Les Jardins de Duranne 510, Rue René Descartes 13592 Aix en Provence 0 562 f f 2000-01-01 2100-01-01 avec_avis_attendu
420 59.59 Syndicat Intercommunal de l'Huveaune de la Fleuride - ZI les paluds 13400 Aubagne 0 563 f f 2000-01-01 2100-01-01 avec_avis_attendu
421 800 Changement d'Usage mairie secteur mairie de secteur 0 564 f f 2000-01-01 2100-01-01 avec_avis_attendu
422 59.56 Monsieur le Préfet (dérogation PLU) Dir. des collectivités locales et du 7 Avenue du Général Leclerc 13332 Marseille Cedex 3 0 56 f f 2000-01-01 2100-01-01 avec_avis_attendu
423 59.89 SDAP des BdR Les Docks - Atrium 104 10 Place de la Joliette 13567 marseille cedex2 0 568 f f 2000-01-01 2100-01-01 avec_avis_attendu
424 59.89 BMP / PHOTOVOLTAIQUE Boulevard de Strasbourg 13303 Marseille Cedex 3 0 570 f f 2000-01-01 2100-01-01 avec_avis_attendu
425 59.89 POLICE NATIONALE Sous Commission Départ. de la Sé 2 rue Antoine Becker 13002 Marseille 0 571 f f 2000-01-01 2100-01-01 avec_avis_attendu
426 DAEWE DAE - BUREAU ENTREPOT INDUSTRIE AGRICOLE 0 572 f f 2000-01-01 2100-01-01 avec_avis_attendu
427 JURIW PARQUET 0 574 f f 2000-01-01 2100-01-01 avec_avis_attendu
428 59.88 DAE - COMMERCE ARTISANAT 0 575 f f 2000-01-01 2100-01-01 avec_avis_attendu
429 59.36 Service de la Planification Urbaine Rue Colbert 13001 MARSEILLE 0 576 f f 2000-01-01 2100-01-01 avec_avis_attendu
430 59.36 Service Aménagement et Habitat - CENTRE SUD Rue Colbert 13001 MARSEILLE 0 577 f f 2000-01-01 2100-01-01 avec_avis_attendu
431 59.36 Service Aménagement et Habitat - NORD Rue Colbert 13001 MARSEILLE 0 578 f f 2000-01-01 2100-01-01 avec_avis_attendu
432 59.36 Service de l'Action Fonçière Place François Mireur 13001 MARSEILLE 0 580 f f 2000-01-01 2100-01-01 avec_avis_attendu
433 59.36 CUMM - DUFE - Service Urbanisme et Foncier Rue Heni Barbusse 13001 MARSEILLE 0 581 f f 2000-01-01 2100-01-01 avec_avis_attendu
434 59.05 Service Parcs et Jardins, du Littoral et de la Mer Avenue Clot-Bey 13008 Marseille 0 5 f f 2000-01-01 2100-01-01 avec_avis_attendu
435 59.10 Service Prévention et Gestion des Risques ERP Avenue Alexandre Dumas 13008 MARSEILLE 0 583 f f 2000-01-01 2100-01-01 avec_avis_attendu
436 DAE2 DAE - ETUDIANT - PUBLIC - ENSEIGNEMENT - RECHERCHE 0 584 f f 2000-01-01 2100-01-01 avec_avis_attendu
437 59.29 DEEU Ravalements de facade Avenue du Prado Le Grand Pavois 13008 Marseille 0 585 f f 2000-01-01 2100-01-01 avec_avis_attendu
438 59.73 DDTM Taxe Aménagement 0 586 f f 2000-01-01 2100-01-01 avec_avis_attendu
439 ERPSE ERP Service Securité 24 rue de Rome 13001 Marseille erp@some.fr 3 23 f f 2012-11-03 2013-02-03 avec_avis_attendu
440 ERPAC ERP Service Accessibilité 24 rue de Rome 13001 Marseille erp@some.fr 3 24 f f 2012-11-03 2013-02-03 avec_avis_attendu
441 ERPSC ERP Service Conformité 24 rue de Rome 13001 Marseille erp@some.fr 3 587 f f 2012-11-03 2013-02-03 avec_avis_attendu
442 59.01 Direction de l'Eau et de l'Assainissement Boulevard Joseph Vernet 13008 Marseille support@atreal.fr 1 1 f t 2000-01-01 2100-01-01 pour_conformite
443 \.
444
445
446 --
447 -- Data for Name: consultation; Type: TABLE DATA; Schema: openads; Owner: postgres
448 --
449
450 COPY consultation (consultation, dossier, date_envoi, date_retour, date_limite, service, avis_consultation, date_reception, motivation, fichier, lu, code_barres, om_fichier_consultation, om_final_consultation) FROM stdin;
451 1 PC0130551200002P0 2013-01-01 \N 2013-02-01 1 \N 2013-01-01 \N t 120000000001 OP_FAILURE t
452 2 PC0130551200001P0 2013-03-01 \N 2013-04-01 1 \N 2013-03-01 \N t 120000000001 OP_FAILURE t
453 \.
454
455
456 --
457 -- Name: consultation_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
458 --
459
460 SELECT pg_catalog.setval('consultation_seq', 3, false);
461
462
463 --
464 -- Data for Name: document_numerise; Type: TABLE DATA; Schema: openads; Owner: postgres
465 --
466
467 COPY document_numerise (document_numerise, uid, dossier, nom_fichier, date_creation, document_numerise_type) FROM stdin;
468 1 483cf5c504c9f81a7c7f470c5a209140 AZ0130551200001P0 20130614ARRT.pdf 2013-06-14 9
469 \.
470
471
472 --
473 -- Data for Name: signataire_arrete; Type: TABLE DATA; Schema: openads; Owner: postgres
474 --
475
476 COPY signataire_arrete (signataire_arrete, civilite, nom, prenom, qualite, signature, defaut, om_validite_debut, om_validite_fin) FROM stdin;
477 1 4 Dupont Albert Maire X t \N \N
478 \.
479
480
481 --
482 -- Data for Name: instruction; Type: TABLE DATA; Schema: openads; Owner: postgres
483 --
484
485 COPY instruction (instruction, destinataire, date_evenement, evenement, lettretype, complement, complement2, dossier, action, delai, etat, accord_tacite, delai_notification, archive_delai, archive_date_complet, archive_date_rejet, archive_date_limite, archive_date_notification_delai, archive_accord_tacite, archive_etat, archive_date_decision, archive_avis, archive_date_validite, archive_date_achevement, archive_date_chantier, archive_date_conformite, complement3, complement4, complement5, complement6, complement7, complement8, complement9, complement10, complement11, complement12, complement13, complement14, complement15, avis_decision, date_finalisation_courrier, date_envoi_signature, date_retour_signature, date_envoi_rar, date_retour_rar, date_envoi_controle_legalite, date_retour_controle_legalite, signataire_arrete, numero_arrete, archive_date_dernier_depot, archive_incompletude, archive_evenement_suivant_tacite, archive_evenement_suivant_tacite_incompletude, archive_etat_pendant_incompletude, archive_date_limite_incompletude, archive_delai_incompletude, code_barres, om_fichier_instruction, om_final_instruction, document_numerise, archive_autorite_competente, autorite_competente, duree_validite_parametrage, duree_validite) FROM stdin;
486 1 PC0130551200001P0 2012-12-17 1 recepisse_1 PC0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000001 \N \N \N \N \N 0 0
487 2 PC0130551200002P0 2012-12-17 1 recepisse_1 PC0130551200002P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000002 \N \N \N \N \N 0 0
488 3 PD0130551200001P0 2012-12-17 1 recepisse_1 PD0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000003 \N \N \N \N \N 0 0
489 4 PA0130551200001P0 2012-12-17 1 recepisse_1 PA0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000004 \N \N \N \N \N 0 0
490 5 DP0130551200001P0 2012-12-17 1 recepisse_1 DP0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000005 \N \N \N \N \N 0 0
491 6 CU0130551200001P0 2012-12-17 1 recepisse_1 CU0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000006 \N \N \N \N \N 0 0
492 7 AZ0130551200001P0 2012-12-17 1 recepisse_1 AZ0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000007 \N \N \N \N \N 0 0
493 8 AT0130551200001P0 2012-12-17 1 recepisse_1 AT0130551200001P0 initialisation 2 notifier Oui 1 0 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000008 \N \N \N \N \N 0 0
494 9 AZ0130551200001P0 2013-02-27 81 arrete AZ0130551200001P0 acceptation 0 accepter Non 0 2 2012-12-17 \N 2013-02-17 2013-01-17 Oui notifier \N \N \N \N \N 7 \N \N 2013-03-27 \N 2013-03-27 \N 2013-03-27 1 \N 2012-12-17 f \N \N \N \N \N 110000000009 \N \N 1 \N \N 0 0
495 10 PA0130551200001P0 2010-08-01 30 arrete PA0130551200001P0 acceptation 24 accepter Non 0 2 2012-12-17 \N 2013-02-17 2013-01-17 Oui notifier \N \N \N \N \N 8 \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000010 \N f \N 1 \N 0 0
496 11 DP0130551200001P0 2013-09-02 81 arrete DP0130551200001P0 acceptation 0 accepter Non 0 2 2012-12-17 \N 2013-02-17 2013-01-17 Oui notifier \N \N \N \N \N 7 \N \N \N \N \N \N \N \N \N 2012-12-17 f \N \N \N \N \N 110000000011 \N f \N 1 \N 0 0
497 12 AT0130551300001P0 2013-11-06 95 recepisse_1 AT0130551300001P0 initialisation 2 incomplet Oui 1 0 \N \N \N \N \N \N \N \N \N \N 2013-11-06 \N \N \N \N \N \N \N \N 2013-11-06 f \N \N \N \N \N 110000000012 4bacae99867140ec2df71ba4dbdecde5 t \N \N \N 0 0
498 \.
499
500
501 --
502 -- Data for Name: demande; Type: TABLE DATA; Schema: openads; Owner: postgres
503 --
504
505 COPY demande (demande, dossier_autorisation_type_detaille, demande_type, dossier_instruction, dossier_autorisation, date_demande, terrain_references_cadastrales, terrain_adresse_voie_numero, terrain_adresse_voie, terrain_adresse_lieu_dit, terrain_adresse_localite, terrain_adresse_code_postal, terrain_adresse_bp, terrain_adresse_cedex, terrain_superficie, instruction_recepisse, arrondissement) FROM stdin;
506 1 1 1 PC0130551200001P0 PC0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 1 \N
507 2 2 2 PC0130551200002P0 PC0130551200002 2012-12-17 \N \N \N \N \N \N \N \N \N 2 \N
508 3 3 3 PD0130551200001P0 PD0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 3 \N
509 4 4 4 PA0130551200001P0 PA0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 4 \N
510 5 5 5 DP0130551200001P0 DP0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 5 \N
511 6 6 6 CU0130551200001P0 CU0130551200001 2012-12-17 \N 2 PLACE CASTELLANE \N MARSEILLE 13006 \N \N \N 6 \N
512 7 7 7 AZ0130551200001P0 AZ0130551200001 2012-12-17 123ab001; 113 BD DE PONT DE VIVAUX \N MARSEILLE 13010 \N \N \N 7 10
513 8 8 8 AT0130551200001P0 AT0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 8 \N
514 9 8 8 AT0130551300001P0 AT0130551300001 2013-11-06 \N \N \N \N \N \N \N \N \N 12 \N
515 \.
516
517
518 --
519 -- Name: demande_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
520 --
521
522 SELECT pg_catalog.setval('demande_seq', 10, false);
523
524
525 --
526 -- Data for Name: demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
527 --
528
529 COPY demandeur (demandeur, type_demandeur, qualite, particulier_nom, particulier_prenom, particulier_date_naissance, particulier_commune_naissance, particulier_departement_naissance, personne_morale_denomination, personne_morale_raison_sociale, personne_morale_siret, personne_morale_categorie_juridique, personne_morale_nom, personne_morale_prenom, numero, voie, complement, lieu_dit, localite, code_postal, bp, cedex, pays, division_territoriale, telephone_fixe, telephone_mobile, indicatif, courriel, notification, frequent, particulier_civilite, personne_morale_civilite) FROM stdin;
530 1 petitionnaire particulier DUPONT JACQUES \N \N \N \N \N \N \N \N \N 12 RUE DE LA LOI BATIMENT F \N MARSEILLE 13155 \N \N France \N \N \N \N \N f f \N \N
531 2 petitionnaire particulier DURAND GÉRARD \N \N \N \N \N \N \N \N \N 17 AVENUE DE LA RÉPUBLIQUE \N \N MARSEILLE 13002 \N \N France \N \N \N \N \N f f \N \N
532 3 petitionnaire particulier MARTIN PAUL \N \N \N \N \N \N \N \N \N 3 PLACE CASTELLANE \N \N MARSEILLE 13006 \N \N France \N \N \N \N \N f f \N \N
533 4 petitionnaire particulier BLANC MARCEL \N \N \N \N \N \N \N \N \N 8 BOULEVARD DE PONT DE VIVAUX \N \N MARSEILLE 13010 \N \N France \N \N \N \N \N f f \N \N
534 5 petitionnaire particulier LEGRAND PIERRE \N \N \N \N \N \N \N \N \N 19 AVENUE DU PRADO \N \N MARSEILLE 13008 \N \N France \N \N \N \N \N f f \N \N
535 6 petitionnaire personne_morale \N \N \N \N \N BOUYGUES \N \N \N \N \N 36 AVENUE DE LA CAPELETTE \N \N MARSEILLE 13010 \N \N France \N \N \N \N \N f f \N \N
536 7 petitionnaire particulier PETIT MARTHE \N \N \N \N \N \N \N \N \N 41 AVENUE DE TOULON \N \N MARSEILLE 13006 \N \N France \N \N \N \N \N f f \N \N
537 8 petitionnaire particulier BERNARD LILIANE \N \N \N \N \N \N \N \N \N 58 AVENUE JULES CANTINI \N \N MARSEILLE 13006 \N \N France \N \N \N \N \N f f \N \N
538 9 petitionnaire particulier Dupont Jean \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N France \N \N \N \N \N f f \N \N
539 \.
540
541
542 --
543 -- Name: demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
544 --
545
546 SELECT pg_catalog.setval('demandeur_seq', 10, false);
547
548
549 --
550 -- Name: document_numerise_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
551 --
552
553 SELECT pg_catalog.setval('document_numerise_seq', 2, false);
554
555
556 --
557 -- Data for Name: lot; Type: TABLE DATA; Schema: openads; Owner: postgres
558 --
559
560 COPY lot (lot, libelle, dossier_autorisation, dossier) FROM stdin;
561 1 test 20m² PC0130551200002 PC0130551200002P0
562 2 test 59m² PC0130551200002 PC0130551200002P0
563 \.
564
565
566 --
567 -- Data for Name: donnees_techniques; Type: TABLE DATA; Schema: openads; Owner: postgres
568 --
569
570 COPY donnees_techniques (donnees_techniques, dossier_instruction, lot, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, su_avt_shon1, su_avt_shon2, su_avt_shon3, su_avt_shon4, su_avt_shon5, su_avt_shon6, su_avt_shon7, su_avt_shon8, su_avt_shon9, su_cstr_shon1, su_cstr_shon2, su_cstr_shon3, su_cstr_shon4, su_cstr_shon5, su_cstr_shon6, su_cstr_shon7, su_cstr_shon8, su_cstr_shon9, su_trsf_shon1, su_trsf_shon2, su_trsf_shon3, su_trsf_shon4, su_trsf_shon5, su_trsf_shon6, su_trsf_shon7, su_trsf_shon8, su_trsf_shon9, su_chge_shon1, su_chge_shon2, su_chge_shon3, su_chge_shon4, su_chge_shon5, su_chge_shon6, su_chge_shon7, su_chge_shon8, su_chge_shon9, su_demo_shon1, su_demo_shon2, su_demo_shon3, su_demo_shon4, su_demo_shon5, su_demo_shon6, su_demo_shon7, su_demo_shon8, su_demo_shon9, su_sup_shon1, su_sup_shon2, su_sup_shon3, su_sup_shon4, su_sup_shon5, su_sup_shon6, su_sup_shon7, su_sup_shon8, su_sup_shon9, su_tot_shon1, su_tot_shon2, su_tot_shon3, su_tot_shon4, su_tot_shon5, su_tot_shon6, su_tot_shon7, su_tot_shon8, su_tot_shon9, su_avt_shon_tot, su_cstr_shon_tot, su_trsf_shon_tot, su_chge_shon_tot, su_demo_shon_tot, su_sup_shon_tot, su_tot_shon_tot, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tax_su_princ_log_nb1, tax_su_princ_log_nb2, tax_su_princ_log_nb3, tax_su_princ_log_nb4, tax_su_princ_log_nb_tot1, tax_su_princ_log_nb_tot2, tax_su_princ_log_nb_tot3, tax_su_princ_log_nb_tot4, tax_su_princ_surf1, tax_su_princ_surf2, tax_su_princ_surf3, tax_su_princ_surf4, tax_su_princ_surf_sup1, tax_su_princ_surf_sup2, tax_su_princ_surf_sup3, tax_su_princ_surf_sup4, tax_su_heber_log_nb1, tax_su_heber_log_nb2, tax_su_heber_log_nb3, tax_su_heber_log_nb_tot1, tax_su_heber_log_nb_tot2, tax_su_heber_log_nb_tot3, tax_su_heber_surf1, tax_su_heber_surf2, tax_su_heber_surf3, tax_su_heber_surf_sup1, tax_su_heber_surf_sup2, tax_su_heber_surf_sup3, tax_su_secon_log_nb, tax_su_tot_log_nb, tax_su_secon_log_nb_tot, tax_su_tot_log_nb_tot, tax_su_secon_surf, tax_su_tot_surf, tax_su_secon_surf_sup, tax_su_tot_surf_sup, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_am_statio_ext, tax_sup_bass_pisc, tax_empl_ten_carav_mobil_nb, tax_empl_hll_nb, tax_eol_haut_nb, tax_pann_volt_sup, tax_am_statio_ext_sup, tax_sup_bass_pisc_sup, tax_empl_ten_carav_mobil_nb_sup, tax_empl_hll_nb_sup, tax_eol_haut_nb_sup, tax_pann_volt_sup_sup, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tax_su_non_habit_surf1, tax_su_non_habit_surf2, tax_su_non_habit_surf3, tax_su_non_habit_surf4, tax_su_non_habit_surf5, tax_su_non_habit_surf6, tax_su_non_habit_surf7, tax_su_non_habit_surf_sup1, tax_su_non_habit_surf_sup2, tax_su_non_habit_surf_sup3, tax_su_non_habit_surf_sup4, tax_su_non_habit_surf_sup5, tax_su_non_habit_surf_sup6, tax_su_non_habit_surf_sup7, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, dossier_autorisation, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr) FROM stdin;
571 1 PC0130551200002P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
572 2 AT0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
573 3 AZ0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
574 4 CU0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
575 5 DP0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
576 6 PA0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
577 7 PC0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
578 8 PD0130551200001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
579 9 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N PC0130551200002 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
580 10 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N AT0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
581 11 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N AZ0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
582 12 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N CU0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
583 13 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N DP0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
584 14 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N PA0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
585 15 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N PC0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
586 16 \N \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N PD0130551200001 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
587 17 \N 1 f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
588 18 \N 2 f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f nesaispas nesaispas nesaispas nesaispas nesaispas nesaispas \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
589 19 AT0130551300001P0 \N f f f f \N f \N f \N \N \N f f f f f f f f f f f f f f f f f f f \N \N \N f f f f f f f \N \N \N \N \N \N \N f \N \N \N \N f f f \N \N \N \N \N \N f f f f \N f f f f f f \N \N \N \N \N \N \N \N \N f f f f f f f f f f f f f \N \N \N \N \N \N \N \N f f f f f f f f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N f \N f \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N \N f f \N \N \N \N \N \N \N \N \N f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
590 \.
591
592
593 --
594 -- Name: donnees_techniques_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
595 --
596
597 SELECT pg_catalog.setval('donnees_techniques_seq', 20, false);
598
599
600 --
601 -- Data for Name: dossier_autorisation_parcelle; Type: TABLE DATA; Schema: openads; Owner: postgres
602 --
603
604 COPY dossier_autorisation_parcelle (dossier_autorisation_parcelle, dossier_autorisation, parcelle, libelle) FROM stdin;
605 1 AZ0130551200001 \N 805AB0009
606 2 AZ0130551200001 \N 806AB0001
607 3 AZ0130551200001 \N 806AB0002
608 4 AZ0130551200001 \N 806AB0003
609 5 AZ0130551200001 \N 806AB0004
610 6 AZ0130551200001 \N 806AB0005
611 \.
612
613
614 --
615 -- Name: dossier_autorisation_parcelle_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
616 --
617
618 SELECT pg_catalog.setval('dossier_autorisation_parcelle_seq', 7, false);
619
620
621 --
622 -- Data for Name: dossier_commission; Type: TABLE DATA; Schema: openads; Owner: postgres
623 --
624
625 COPY dossier_commission (dossier_commission, dossier, commission_type, date_souhaitee, motivation, commission, avis, lu) FROM stdin;
626 1 AZ0130551200001P0 1 2012-12-19 1 t
627 \.
628
629
630 --
631 -- Name: dossier_commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
632 --
633
634 SELECT pg_catalog.setval('dossier_commission_seq', 2, false);
635
636
637 --
638 -- Data for Name: dossier_parcelle; Type: TABLE DATA; Schema: openads; Owner: postgres
639 --
640
641 COPY dossier_parcelle (dossier_parcelle, dossier, parcelle, libelle) FROM stdin;
642 1 PD0130551200001P0 \N 805AB0009
643 2 AZ0130551200001P0 \N 806AB0001
644 3 AZ0130551200001P0 \N 806AB0002
645 4 AZ0130551200001P0 \N 806AB0003
646 5 AZ0130551200001P0 \N 806AB0004
647 6 AZ0130551200001P0 \N 806AB0005
648 \.
649
650
651 --
652 -- Name: dossier_parcelle_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
653 --
654
655 SELECT pg_catalog.setval('dossier_parcelle_seq', 7, false);
656
657
658 --
659 -- Name: instruction_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
660 --
661
662 SELECT pg_catalog.setval('instruction_seq', 13, false);
663
664
665 --
666 -- Data for Name: lien_demande_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
667 --
668
669 COPY lien_demande_demandeur (lien_demande_demandeur, petitionnaire_principal, demande, demandeur) FROM stdin;
670 1 t 1 1
671 2 t 2 2
672 3 t 3 3
673 4 t 4 4
674 5 t 5 5
675 6 t 6 6
676 7 t 7 7
677 8 t 8 8
678 9 t 9 9
679 \.
680
681
682 --
683 -- Name: lien_demande_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
684 --
685
686 SELECT pg_catalog.setval('lien_demande_demandeur_seq', 10, false);
687
688
689 --
690 -- Data for Name: lien_dossier_autorisation_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
691 --
692
693 COPY lien_dossier_autorisation_demandeur (lien_dossier_autorisation_demandeur, petitionnaire_principal, dossier_autorisation, demandeur) FROM stdin;
694 1 t PC0130551200001 1
695 2 t PC0130551200002 2
696 3 t PD0130551200001 3
697 4 t PA0130551200001 4
698 5 t DP0130551200001 5
699 6 t CU0130551200001 6
700 7 t AZ0130551200001 7
701 8 t AT0130551200001 8
702 9 t AT0130551300001 9
703 \.
704
705
706 --
707 -- Name: lien_dossier_autorisation_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
708 --
709
710 SELECT pg_catalog.setval('lien_dossier_autorisation_demandeur_seq', 10, false);
711
712
713 --
714 -- Data for Name: lien_dossier_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
715 --
716
717 COPY lien_dossier_demandeur (lien_dossier_demandeur, petitionnaire_principal, dossier, demandeur) FROM stdin;
718 1 t PC0130551200001P0 1
719 2 t PC0130551200002P0 2
720 3 t PD0130551200001P0 3
721 4 t PA0130551200001P0 4
722 5 t DP0130551200001P0 5
723 6 t CU0130551200001P0 6
724 7 t AZ0130551200001P0 7
725 8 t AT0130551200001P0 8
726 9 t AT0130551300001P0 9
727 \.
728
729
730 --
731 -- Name: lien_dossier_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
732 --
733
734 SELECT pg_catalog.setval('lien_dossier_demandeur_seq', 10, false);
735
736
737 --
738 -- Data for Name: lien_lot_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
739 --
740
741 COPY lien_lot_demandeur (lien_lot_demandeur, lot, demandeur, petitionnaire_principal) FROM stdin;
742 1 1 7 t
743 2 2 7 t
744 \.
745
746
747 --
748 -- Name: lien_lot_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
749 --
750
751 SELECT pg_catalog.setval('lien_lot_demandeur_seq', 3, false);
752
753
754 --
755 -- Data for Name: lien_service_om_utilisateur; Type: TABLE DATA; Schema: openads; Owner: postgres
756 --
757
758 COPY lien_service_om_utilisateur (lien_service_om_utilisateur, om_utilisateur, service) FROM stdin;
759 1 6 1
760 2 6 7
761 3 6 13
762 4 8 6
763 5 8 8
764 6 8 15
765 7 7 77
766 8 18 1
767 \.
768
769
770 --
771 -- Name: lien_service_om_utilisateur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
772 --
773
774 SELECT pg_catalog.setval('lien_service_om_utilisateur_seq', 9, false);
775
776
777 --
778 -- Data for Name: service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
779 --
780
781 COPY service_categorie (service_categorie, libelle) FROM stdin;
782 1 Maire de secteur
783 2 Service ville
784 3 Service extérieur
785 4 Consultation (villa) sans cession
786 5 Consultation pour cession
787 10 Consultation gros projet
788 11 Consultation Préfet
789 14 Consultation obligatoire version papier
790 15 Consultation mini dossier papier
791 16 photovoltaique
792 18 DADU - JURIDIQUE
793 \.
794
795
796 --
797 -- Data for Name: lien_service_service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
798 --
799
800 COPY lien_service_service_categorie (lien_service_service_categorie, service_categorie, service) FROM stdin;
801 1 4 1
802 2 4 2
803 3 10 6
804 4 2 7
805 5 10 8
806 6 10 12
807 7 2 13
808 8 10 15
809 9 5 17
810 10 14 22
811 11 3 25
812 12 15 31
813 13 2 39
814 14 15 43
815 15 15 45
816 16 15 49
817 17 2 50
818 18 15 51
819 19 15 52
820 20 2 54
821 21 15 57
822 22 15 59
823 23 15 60
824 24 3 61
825 25 2 63
826 26 15 66
827 27 2 67
828 28 15 69
829 29 15 70
830 30 15 72
831 31 14 77
832 32 1 501
833 33 1 502
834 34 1 503
835 35 1 504
836 36 1 505
837 37 1 506
838 38 1 507
839 39 1 508
840 40 15 14
841 41 14 19
842 42 15 21
843 43 5 26
844 44 15 30
845 45 2 38
846 46 3 42
847 47 15 44
848 48 4 46
849 49 3 48
850 50 14 71
851 51 15 76
852 52 15 79
853 53 15 80
854 54 3 511
855 55 2 512
856 56 15 513
857 57 10 519
858 58 2 36
859 59 11 528
860 60 5 20
861 61 2 68
862 62 15 531
863 63 15 532
864 64 2 533
865 65 3 538
866 66 15 539
867 67 15 540
868 68 4 541
869 69 10 542
870 70 15 543
871 71 15 544
872 72 14 546
873 73 15 547
874 74 14 549
875 75 14 550
876 76 3 552
877 77 2 553
878 78 2 560
879 79 15 561
880 80 4 562
881 81 3 563
882 82 3 564
883 83 15 56
884 84 14 568
885 85 16 570
886 86 14 571
887 87 10 572
888 88 18 574
889 89 10 575
890 90 2 576
891 91 2 577
892 92 2 578
893 93 2 580
894 94 3 581
895 95 10 5
896 96 14 583
897 97 10 584
898 98 2 585
899 99 3 586
900 \.
901
902
903 --
904 -- Name: lien_service_service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
905 --
906
907 SELECT pg_catalog.setval('lien_service_service_categorie_seq', 100, false);
908
909
910 --
911 -- Name: lot_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
912 --
913
914 SELECT pg_catalog.setval('lot_seq', 3, false);
915
916
917 --
918 -- Name: quartier_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
919 --
920
921 SELECT pg_catalog.setval('quartier_seq', 112, false);
922
923
924 --
925 -- Name: service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
926 --
927
928 SELECT pg_catalog.setval('service_categorie_seq', 19, false);
929
930
931 --
932 -- Name: service_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
933 --
934
935 SELECT pg_catalog.setval('service_seq', 588, false);
936
937
938 --
939 -- Name: signataire_arrete_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
940 --
941
942 SELECT pg_catalog.setval('signataire_arrete_seq', 2, false);
943
944
945 --
946 -- PostgreSQL database dump complete
947 --
948

Properties

Name Value
svn:keywords Id
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26