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

Properties

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