/[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 2451 - (show annotations)
Fri Nov 8 09:17:45 2013 UTC (11 years, 2 months ago) by vpihour
File size: 71364 byte(s) 
Rajout des données supprimées qui faisaient échouer les tests
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 1
253 5 \N \N \N 1 8
254 \.
255
256
257 --
258 -- Name: affectation_automatique_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
259 --
260
261 SELECT pg_catalog.setval('affectation_automatique_seq', 6, false);
262
263
264 --
265 -- Name: arrondissement_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
266 --
267
268 SELECT pg_catalog.setval('arrondissement_seq', 17, false);
269
270
271 --
272 -- Data for Name: commission_type; Type: TABLE DATA; Schema: openads; Owner: postgres
273 --
274
275 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;
276 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
277 \.
278
279
280 --
281 -- Data for Name: commission; Type: TABLE DATA; Schema: openads; Owner: postgres
282 --
283
284 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;
285 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
286 \.
287
288
289 --
290 -- Name: commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
291 --
292
293 SELECT pg_catalog.setval('commission_seq', 2, false);
294
295
296 --
297 -- Name: commission_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
298 --
299
300 SELECT pg_catalog.setval('commission_type_seq', 2, false);
301
302
303 --
304 -- Data for Name: dossier_autorisation; Type: TABLE DATA; Schema: openads; Owner: postgres
305 --
306
307 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;
308 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
309 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
310 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
311 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
312 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
313 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
314 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
315 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
316 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
317 \.
318
319
320 --
321 -- Data for Name: dossier; Type: TABLE DATA; Schema: openads; Owner: postgres
322 --
323
324 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;
325 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
326 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
327 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
328 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
329 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
330 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
331 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
332 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
333 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
334 \.
335
336
337 --
338 -- Data for Name: service; Type: TABLE DATA; Schema: openads; Owner: postgres
339 --
340
341 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;
342 59.02 Atelier du Patrimoine Square Belsunce 13001 Marseille 1 2 f f 2000-01-01 2100-01-01 pour_conformite
343 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
344 59.07 Service de l' Espace Public Rue Mongrand 13006 Marseille 0 7 f f 2000-01-01 2100-01-01 pour_information
345 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
346 59.12 Direction de la Propreté Urbaine DOCTEUR HECKEL 13011 Marseille 0 12 f f 2000-01-01 2100-01-01 pour_information
347 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
348 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
349 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
350 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
351 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
352 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
353 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
354 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
355 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
356 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
357 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
358 59.51 Direction de la Protection Civile Rue Nau 13005 Marseille 0 51 f f 2000-01-01 2100-01-01 avec_avis_attendu
359 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
360 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
361 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
362 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
363 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
364 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
365 59.64 Direction des Sports Allée Ray Grassi 13008 Marseille 1 63 f f 2000-01-01 2100-01-01 avec_avis_attendu
366 59.67 GDF Exploitation Transport Rue de Lyon 13015 Marseille 0 66 f f 2000-01-01 2100-01-01 avec_avis_attendu
367 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
368 59.70 AUTRE 0 69 f f 2000-01-01 2100-01-01 avec_avis_attendu
369 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
370 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
371 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
372 1ER Maire 1er Secteur 0 501 f f 2000-01-01 2100-01-01 avec_avis_attendu
373 2EME Maire 2ème Secteur 0 502 f f 2000-01-01 2100-01-01 avec_avis_attendu
374 3EME Maire 3ème Secteur 0 503 f f 2000-01-01 2100-01-01 avec_avis_attendu
375 4EME Maire 4ème Secteur 0 504 f f 2000-01-01 2100-01-01 avec_avis_attendu
376 5EME Maire 5ème Secteur 0 505 f f 2000-01-01 2100-01-01 avec_avis_attendu
377 6EME Maire 6ème Secteur 0 506 f f 2000-01-01 2100-01-01 avec_avis_attendu
378 7EME Maire 7ème Secteur 0 507 f f 2000-01-01 2100-01-01 avec_avis_attendu
379 8EME Maire 8ème Secteur 0 508 f f 2000-01-01 2100-01-01 avec_avis_attendu
380 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
381 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
382 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
383 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
384 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
385 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
386 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
387 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
388 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
389 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
390 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
391 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
392 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
393 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
394 59.10 MARSEILLE AMENAGEMENT - SOLEAM La Canebière 13001 MARSEILLE 0 511 f f 2000-01-01 2100-01-01 avec_avis_attendu
395 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
396 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
397 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
398 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
399 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
400 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
401 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
402 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
403 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
404 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
405 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
406 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
407 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
408 59.01 SERAM Capitaine Geze BP 10256 13308 Marseille Cedex 14 0 541 f f 2000-01-01 2100-01-01 avec_avis_attendu
409 59.88 DAE - RESID TOURISME ET HOTELIER 0 542 f f 2000-01-01 2100-01-01 avec_avis_attendu
410 59.11 LE TRAM RUE SAINT PIERRE 13005 MARSEILLE 0 543 f f 2000-01-01 2100-01-01 avec_avis_attendu
411 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
412 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
413 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
414 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
415 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
416 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
417 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
418 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
419 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
420 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
421 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
422 800 Changement d'Usage mairie secteur mairie de secteur 0 564 f f 2000-01-01 2100-01-01 avec_avis_attendu
423 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
424 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
425 59.89 BMP / PHOTOVOLTAIQUE Boulevard de Strasbourg 13303 Marseille Cedex 3 0 570 f f 2000-01-01 2100-01-01 avec_avis_attendu
426 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
427 DAEWE DAE - BUREAU ENTREPOT INDUSTRIE AGRICOLE 0 572 f f 2000-01-01 2100-01-01 avec_avis_attendu
428 JURIW PARQUET 0 574 f f 2000-01-01 2100-01-01 avec_avis_attendu
429 59.88 DAE - COMMERCE ARTISANAT 0 575 f f 2000-01-01 2100-01-01 avec_avis_attendu
430 59.36 Service de la Planification Urbaine Rue Colbert 13001 MARSEILLE 0 576 f f 2000-01-01 2100-01-01 avec_avis_attendu
431 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
432 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
433 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
434 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
435 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
436 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
437 DAE2 DAE - ETUDIANT - PUBLIC - ENSEIGNEMENT - RECHERCHE 0 584 f f 2000-01-01 2100-01-01 avec_avis_attendu
438 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
439 59.73 DDTM Taxe Aménagement 0 586 f f 2000-01-01 2100-01-01 avec_avis_attendu
440 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
441 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
442 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
443 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
444 \.
445
446
447 --
448 -- Data for Name: consultation; Type: TABLE DATA; Schema: openads; Owner: postgres
449 --
450
451 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;
452 1 PC0130551200002P0 2013-01-01 \N 2013-02-01 1 \N 2013-01-01 \N t 120000000001 OP_FAILURE t
453 2 PC0130551200001P0 2013-03-01 \N 2013-04-01 1 \N 2013-03-01 \N t 120000000001 OP_FAILURE t
454 \.
455
456
457 --
458 -- Name: consultation_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
459 --
460
461 SELECT pg_catalog.setval('consultation_seq', 3, false);
462
463
464 --
465 -- Data for Name: document_numerise; Type: TABLE DATA; Schema: openads; Owner: postgres
466 --
467
468 COPY document_numerise (document_numerise, uid, dossier, nom_fichier, date_creation, document_numerise_type) FROM stdin;
469 1 483cf5c504c9f81a7c7f470c5a209140 AZ0130551200001P0 20130614ARRT.pdf 2013-06-14 9
470 \.
471
472
473 --
474 -- Data for Name: signataire_arrete; Type: TABLE DATA; Schema: openads; Owner: postgres
475 --
476
477 COPY signataire_arrete (signataire_arrete, civilite, nom, prenom, qualite, signature, defaut, om_validite_debut, om_validite_fin) FROM stdin;
478 1 4 Dupont Albert Maire X t \N \N
479 \.
480
481
482 --
483 -- Data for Name: instruction; Type: TABLE DATA; Schema: openads; Owner: postgres
484 --
485
486 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;
487 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
488 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
489 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
490 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
491 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
492 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
493 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
494 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
495 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
496 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
497 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
498 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
499 \.
500
501
502 --
503 -- Data for Name: demande; Type: TABLE DATA; Schema: openads; Owner: postgres
504 --
505
506 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;
507 1 1 1 PC0130551200001P0 PC0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 1 \N
508 2 2 2 PC0130551200002P0 PC0130551200002 2012-12-17 \N \N \N \N \N \N \N \N \N 2 \N
509 3 3 3 PD0130551200001P0 PD0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 3 \N
510 4 4 4 PA0130551200001P0 PA0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 4 \N
511 5 5 5 DP0130551200001P0 DP0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 5 \N
512 6 6 6 CU0130551200001P0 CU0130551200001 2012-12-17 \N 2 PLACE CASTELLANE \N MARSEILLE 13006 \N \N \N 6 \N
513 7 7 7 AZ0130551200001P0 AZ0130551200001 2012-12-17 123ab001; 113 BD DE PONT DE VIVAUX \N MARSEILLE 13010 \N \N \N 7 10
514 8 8 8 AT0130551200001P0 AT0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 8 \N
515 9 8 8 AT0130551300001P0 AT0130551300001 2013-11-06 \N \N \N \N \N \N \N \N \N 12 \N
516 \.
517
518
519 --
520 -- Name: demande_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
521 --
522
523 SELECT pg_catalog.setval('demande_seq', 10, false);
524
525
526 --
527 -- Data for Name: demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
528 --
529
530 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;
531 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
532 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
533 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
534 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
535 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
536 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
537 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
538 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
539 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
540 \.
541
542
543 --
544 -- Name: demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
545 --
546
547 SELECT pg_catalog.setval('demandeur_seq', 10, false);
548
549
550 --
551 -- Name: document_numerise_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
552 --
553
554 SELECT pg_catalog.setval('document_numerise_seq', 2, false);
555
556
557 --
558 -- Data for Name: lot; Type: TABLE DATA; Schema: openads; Owner: postgres
559 --
560
561 COPY lot (lot, libelle, dossier_autorisation, dossier) FROM stdin;
562 1 test 20m² PC0130551200002 PC0130551200002P0
563 2 test 59m² PC0130551200002 PC0130551200002P0
564 \.
565
566
567 --
568 -- Data for Name: donnees_techniques; Type: TABLE DATA; Schema: openads; Owner: postgres
569 --
570
571 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;
572 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
573 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
574 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
575 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
576 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
577 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
578 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
579 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
580 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
581 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
582 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
583 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
584 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
585 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
586 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
587 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
588 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
589 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
590 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
591 \.
592
593
594 --
595 -- Name: donnees_techniques_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
596 --
597
598 SELECT pg_catalog.setval('donnees_techniques_seq', 20, false);
599
600
601 --
602 -- Data for Name: dossier_autorisation_parcelle; Type: TABLE DATA; Schema: openads; Owner: postgres
603 --
604
605 COPY dossier_autorisation_parcelle (dossier_autorisation_parcelle, dossier_autorisation, parcelle, libelle) FROM stdin;
606 1 AZ0130551200001 \N 805AB0009
607 2 AZ0130551200001 \N 806AB0001
608 3 AZ0130551200001 \N 806AB0002
609 4 AZ0130551200001 \N 806AB0003
610 5 AZ0130551200001 \N 806AB0004
611 6 AZ0130551200001 \N 806AB0005
612 \.
613
614
615 --
616 -- Name: dossier_autorisation_parcelle_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
617 --
618
619 SELECT pg_catalog.setval('dossier_autorisation_parcelle_seq', 7, false);
620
621
622 --
623 -- Data for Name: dossier_commission; Type: TABLE DATA; Schema: openads; Owner: postgres
624 --
625
626 COPY dossier_commission (dossier_commission, dossier, commission_type, date_souhaitee, motivation, commission, avis, lu) FROM stdin;
627 1 AZ0130551200001P0 1 2012-12-19 1 t
628 \.
629
630
631 --
632 -- Name: dossier_commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
633 --
634
635 SELECT pg_catalog.setval('dossier_commission_seq', 2, false);
636
637
638 --
639 -- Data for Name: dossier_parcelle; Type: TABLE DATA; Schema: openads; Owner: postgres
640 --
641
642 COPY dossier_parcelle (dossier_parcelle, dossier, parcelle, libelle) FROM stdin;
643 1 PD0130551200001P0 \N 805AB0009
644 2 AZ0130551200001P0 \N 806AB0001
645 3 AZ0130551200001P0 \N 806AB0002
646 4 AZ0130551200001P0 \N 806AB0003
647 5 AZ0130551200001P0 \N 806AB0004
648 6 AZ0130551200001P0 \N 806AB0005
649 \.
650
651
652 --
653 -- Name: dossier_parcelle_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
654 --
655
656 SELECT pg_catalog.setval('dossier_parcelle_seq', 7, false);
657
658
659 --
660 -- Name: instruction_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
661 --
662
663 SELECT pg_catalog.setval('instruction_seq', 13, false);
664
665
666 --
667 -- Data for Name: lien_demande_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
668 --
669
670 COPY lien_demande_demandeur (lien_demande_demandeur, petitionnaire_principal, demande, demandeur) FROM stdin;
671 1 t 1 1
672 2 t 2 2
673 3 t 3 3
674 4 t 4 4
675 5 t 5 5
676 6 t 6 6
677 7 t 7 7
678 8 t 8 8
679 9 t 9 9
680 \.
681
682
683 --
684 -- Name: lien_demande_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
685 --
686
687 SELECT pg_catalog.setval('lien_demande_demandeur_seq', 10, false);
688
689
690 --
691 -- Data for Name: lien_dossier_autorisation_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
692 --
693
694 COPY lien_dossier_autorisation_demandeur (lien_dossier_autorisation_demandeur, petitionnaire_principal, dossier_autorisation, demandeur) FROM stdin;
695 1 t PC0130551200001 1
696 2 t PC0130551200002 2
697 3 t PD0130551200001 3
698 4 t PA0130551200001 4
699 5 t DP0130551200001 5
700 6 t CU0130551200001 6
701 7 t AZ0130551200001 7
702 8 t AT0130551200001 8
703 9 t AT0130551300001 9
704 \.
705
706
707 --
708 -- Name: lien_dossier_autorisation_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
709 --
710
711 SELECT pg_catalog.setval('lien_dossier_autorisation_demandeur_seq', 10, false);
712
713
714 --
715 -- Data for Name: lien_dossier_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
716 --
717
718 COPY lien_dossier_demandeur (lien_dossier_demandeur, petitionnaire_principal, dossier, demandeur) FROM stdin;
719 1 t PC0130551200001P0 1
720 2 t PC0130551200002P0 2
721 3 t PD0130551200001P0 3
722 4 t PA0130551200001P0 4
723 5 t DP0130551200001P0 5
724 6 t CU0130551200001P0 6
725 7 t AZ0130551200001P0 7
726 8 t AT0130551200001P0 8
727 9 t AT0130551300001P0 9
728 \.
729
730
731 --
732 -- Name: lien_dossier_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
733 --
734
735 SELECT pg_catalog.setval('lien_dossier_demandeur_seq', 10, false);
736
737
738 --
739 -- Data for Name: lien_lot_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
740 --
741
742 COPY lien_lot_demandeur (lien_lot_demandeur, lot, demandeur, petitionnaire_principal) FROM stdin;
743 1 1 7 t
744 2 2 7 t
745 \.
746
747
748 --
749 -- Name: lien_lot_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
750 --
751
752 SELECT pg_catalog.setval('lien_lot_demandeur_seq', 3, false);
753
754
755 --
756 -- Data for Name: lien_service_om_utilisateur; Type: TABLE DATA; Schema: openads; Owner: postgres
757 --
758
759 COPY lien_service_om_utilisateur (lien_service_om_utilisateur, om_utilisateur, service) FROM stdin;
760 1 6 1
761 2 6 7
762 3 6 13
763 4 8 6
764 5 8 8
765 6 8 15
766 7 7 77
767 8 18 1
768 \.
769
770
771 --
772 -- Name: lien_service_om_utilisateur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
773 --
774
775 SELECT pg_catalog.setval('lien_service_om_utilisateur_seq', 9, false);
776
777
778 --
779 -- Data for Name: service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
780 --
781
782 COPY service_categorie (service_categorie, libelle) FROM stdin;
783 1 Maire de secteur
784 2 Service ville
785 3 Service extérieur
786 4 Consultation (villa) sans cession
787 5 Consultation pour cession
788 10 Consultation gros projet
789 11 Consultation Préfet
790 14 Consultation obligatoire version papier
791 15 Consultation mini dossier papier
792 16 photovoltaique
793 18 DADU - JURIDIQUE
794 \.
795
796
797 --
798 -- Data for Name: lien_service_service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
799 --
800
801 COPY lien_service_service_categorie (lien_service_service_categorie, service_categorie, service) FROM stdin;
802 1 4 1
803 2 4 2
804 3 10 6
805 4 2 7
806 5 10 8
807 6 10 12
808 7 2 13
809 8 10 15
810 9 5 17
811 10 14 22
812 11 3 25
813 12 15 31
814 13 2 39
815 14 15 43
816 15 15 45
817 16 15 49
818 17 2 50
819 18 15 51
820 19 15 52
821 20 2 54
822 21 15 57
823 22 15 59
824 23 15 60
825 24 3 61
826 25 2 63
827 26 15 66
828 27 2 67
829 28 15 69
830 29 15 70
831 30 15 72
832 31 14 77
833 32 1 501
834 33 1 502
835 34 1 503
836 35 1 504
837 36 1 505
838 37 1 506
839 38 1 507
840 39 1 508
841 40 15 14
842 41 14 19
843 42 15 21
844 43 5 26
845 44 15 30
846 45 2 38
847 46 3 42
848 47 15 44
849 48 4 46
850 49 3 48
851 50 14 71
852 51 15 76
853 52 15 79
854 53 15 80
855 54 3 511
856 55 2 512
857 56 15 513
858 57 10 519
859 58 2 36
860 59 11 528
861 60 5 20
862 61 2 68
863 62 15 531
864 63 15 532
865 64 2 533
866 65 3 538
867 66 15 539
868 67 15 540
869 68 4 541
870 69 10 542
871 70 15 543
872 71 15 544
873 72 14 546
874 73 15 547
875 74 14 549
876 75 14 550
877 76 3 552
878 77 2 553
879 78 2 560
880 79 15 561
881 80 4 562
882 81 3 563
883 82 3 564
884 83 15 56
885 84 14 568
886 85 16 570
887 86 14 571
888 87 10 572
889 88 18 574
890 89 10 575
891 90 2 576
892 91 2 577
893 92 2 578
894 93 2 580
895 94 3 581
896 95 10 5
897 96 14 583
898 97 10 584
899 98 2 585
900 99 3 586
901 \.
902
903
904 --
905 -- Name: lien_service_service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
906 --
907
908 SELECT pg_catalog.setval('lien_service_service_categorie_seq', 100, false);
909
910
911 --
912 -- Name: lot_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
913 --
914
915 SELECT pg_catalog.setval('lot_seq', 3, false);
916
917
918 --
919 -- Name: quartier_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
920 --
921
922 SELECT pg_catalog.setval('quartier_seq', 112, false);
923
924
925 --
926 -- Name: service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
927 --
928
929 SELECT pg_catalog.setval('service_categorie_seq', 19, false);
930
931
932 --
933 -- Name: service_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
934 --
935
936 SELECT pg_catalog.setval('service_seq', 588, false);
937
938
939 --
940 -- Name: signataire_arrete_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
941 --
942
943 SELECT pg_catalog.setval('signataire_arrete_seq', 2, false);
944
945
946 --
947 -- PostgreSQL database dump complete
948 --
949

Properties

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