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

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

Parent Directory Parent Directory | Revision Log Revision Log

Revision 2192 - (hide annotations)
Thu Aug 29 17:51:28 2013 UTC (11 years, 5 months ago) by fmichon
File size: 65749 byte(s) 
Mise à jour du test des architectes fréquents pour qu'il fonctionne.
1 fmichon 1801 --------------------------------------------------------------------------------
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 softime 2177 (10, 'Guichet Unique', '[email protected]', 'guichet', 'aca8a84cc15c9d23d11e96a15df4f828', 1, 'DB', 6),
27 fmichon 1801
28 softime 2177 (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 fmichon 1801 ;
35    
36     ---
37     --- DIRECTIONS
38     ---
39    
40     INSERT INTO direction VALUES
41    
42     (1, 'ADS', 'Direction ADS', 'Direction des autorisations des droits du sol', 'Jeanette Rochefort', NULL, NULL)
43    
44     ;
45    
46    
47     ---
48     --- DIVISIONS
49     ---
50    
51     INSERT INTO division(division, code, libelle, chef, direction, om_validite_debut, om_validite_fin) VALUES
52    
53     (22, 'H', 'subdivision H', 'Paien Labossière', 1, NULL, NULL),
54     (23, 'J', 'subdivision J', 'Stéphane Cartier', 1, NULL, NULL)
55    
56     ;
57    
58    
59     ---
60     --- INSTRUCTEURS
61     ---
62    
63     INSERT INTO instructeur VALUES
64    
65     (1, 'Louis Laurent', NULL, 22,
66     (SELECT om_utilisateur from om_utilisateur where login='instr')
67     , NULL, NULL),
68     (2, 'Martine Nadeau', NULL, 22,
69     (SELECT om_utilisateur from om_utilisateur where login='instr1')
70     , NULL, NULL),
71     (3, 'Roland Richard', NULL, 23,
72     (SELECT om_utilisateur from om_utilisateur where login='instr2')
73 softime 2177 , NULL, NULL),
74     (4, 'Pierre Martin', NULL, 22,
75     (SELECT om_utilisateur FROM om_utilisateur WHERE login='divi')
76 fmichon 1801 , NULL, NULL)
77     ;
78    
79    
80     ---
81     --- AFFECTATION AUTOMATIQUE
82     ---
83    
84     INSERT INTO affectation_automatique VALUES (1, NULL, NULL, NULL, 1, NULL);
85     INSERT INTO affectation_automatique VALUES (2, NULL, NULL, NULL, 2, 1);
86     INSERT INTO affectation_automatique VALUES (3, NULL, NULL, NULL, 3, 3);
87    
88 fmichon 2192
89     ---
90     --- ARCHITECTES
91     ---
92    
93     INSERT INTO architecte VALUES (nextval('architecte_seq'), 'Mercier', 'Paul', '113 boulevard de pont de vivaux', '', '13010', 'Marseille', 'France', '054645', '0497856235', '0497856236', '[email protected]', '', true);
94     INSERT INTO architecte VALUES (nextval('architecte_seq'), 'Mercier', 'Jean', '113 boulevard de pont de vivaux', '', '13010', 'Marseille', 'France', '56454', '0491352689', '0491352685', '[email protected]', '', true);
95    
96 fmichon 1801 --
97 fmichon 1844 -- 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
98     --
99 fmichon 1801
100     --
101     -- PostgreSQL database dump
102     --
103    
104     --
105     -- Data for Name: arrondissement; Type: TABLE DATA; Schema: openads; Owner: postgres
106     --
107    
108     COPY arrondissement (arrondissement, libelle, code_postal) FROM stdin;
109     1 1 13001
110     2 2 13002
111     3 3 13003
112     4 4 13004
113     5 5 13005
114     6 6 13006
115     7 7 13007
116     8 8 13008
117     9 9 13009
118     10 10 13010
119     11 11 13011
120     12 12 13012
121     13 13 13013
122     14 14 13014
123     15 15 13015
124     16 16 13016
125     \.
126    
127    
128     --
129     -- Name: arrondissement_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
130     --
131    
132     SELECT pg_catalog.setval('arrondissement_seq', 17, false);
133    
134    
135     --
136     -- Data for Name: commission_type; Type: TABLE DATA; Schema: openads; Owner: postgres
137     --
138    
139     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;
140     1 CTU Commission Technique d'Urbanisme 40 rue Fauchier 13001 MARSEILLE \N [email protected]\[email protected] David CHEVALIER\nGuillaume LAMBERT Vous trouverez en pièces jointes les documents cités en objet du mail \N \N
141     \.
142    
143    
144     --
145     -- Data for Name: commission; Type: TABLE DATA; Schema: openads; Owner: postgres
146     --
147    
148 fmichon 1970 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;
149     1 CTU20121201 1 Commission Technique d'Urbanisme 2012-12-01 15:00 40 rue Fauchier 13001 MARSEILLE 2a fmichon@atreal.fr\nsupport@atreal.fr David CHEVALIER\nGuillaume LAMBERT \N \N \N \N
150 fmichon 1801 \.
151    
152    
153     --
154     -- Name: commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
155     --
156    
157     SELECT pg_catalog.setval('commission_seq', 2, false);
158    
159 fmichon 1844
160 fmichon 1801 --
161 fmichon 1844 -- Name: commission_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
162     --
163    
164     SELECT pg_catalog.setval('commission_type_seq', 2, false);
165    
166    
167     --
168 fmichon 1801 -- Data for Name: dossier_autorisation; Type: TABLE DATA; Schema: openads; Owner: postgres
169     --
170    
171 vpihour 2150 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;
172     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
173     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
174     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
175     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
176     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
177     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
178     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
179     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
180 fmichon 1801 \.
181    
182    
183     --
184     -- Data for Name: dossier; Type: TABLE DATA; Schema: openads; Owner: postgres
185     --
186    
187 vpihour 2159 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;
188     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 \N \N
189     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
190 nhaye 2188 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 805ab009; \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
191 vpihour 2159 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
192     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
193 nhaye 2188 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 806ab001A005; 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
194 vpihour 2159 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
195     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
196 fmichon 1801 \.
197    
198    
199     --
200     -- Data for Name: signataire_arrete; Type: TABLE DATA; Schema: openads; Owner: postgres
201     --
202    
203     COPY signataire_arrete (signataire_arrete, civilite, nom, prenom, qualite, signature, defaut, om_validite_debut, om_validite_fin) FROM stdin;
204     1 4 Dupont Albert Maire X t \N \N
205     \.
206    
207 vpihour 2056 --
208     -- Data for Name: document_numerise; Type: TABLE DATA; Schema: openads; Owner: postgres
209     --
210 fmichon 1801
211 vpihour 2056 COPY document_numerise (document_numerise, uid, dossier, nom_fichier, date_creation, document_numerise_type) FROM stdin;
212     1 483cf5c504c9f81a7c7f470c5a209140 AZ0130551200001P0 20130614ARRT.pdf 2013-06-14 9
213     \.
214    
215    
216 fmichon 1801 --
217 vpihour 2056 -- Name: document_numerise_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
218     --
219    
220     SELECT pg_catalog.setval('document_numerise_seq', 2, false);
221    
222     --
223 fmichon 1801 -- Data for Name: instruction; Type: TABLE DATA; Schema: openads; Owner: postgres
224     --
225    
226 vpihour 2150 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;
227     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
228     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
229     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
230     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
231     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
232     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
233     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
234     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
235     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
236     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
237 fmichon 1801 \.
238    
239    
240     --
241     -- Data for Name: demande; Type: TABLE DATA; Schema: openads; Owner: postgres
242     --
243    
244 vpihour 2079 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;
245 fmichon 1801 1 1 1 PC0130551200001P0 PC0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 1 \N
246     2 2 2 PC0130551200002P0 PC0130551200002 2012-12-17 \N \N \N \N \N \N \N \N \N 2 \N
247     3 3 3 PD0130551200001P0 PD0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 3 \N
248     4 4 4 PA0130551200001P0 PA0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 4 \N
249     5 5 5 DP0130551200001P0 DP0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 5 \N
250     6 6 6 CU0130551200001P0 CU0130551200001 2012-12-17 \N 2 PLACE CASTELLANE \N MARSEILLE 13006 \N \N \N 6 \N
251     7 7 7 AZ0130551200001P0 AZ0130551200001 2012-12-17 123ab001; 113 BD DE PONT DE VIVAUX \N MARSEILLE 13010 \N \N \N 7 10
252     8 8 8 AT0130551200001P0 AT0130551200001 2012-12-17 \N \N \N \N \N \N \N \N \N 8 \N
253     \.
254    
255    
256     --
257     -- Name: demande_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
258     --
259    
260     SELECT pg_catalog.setval('demande_seq', 9, false);
261    
262    
263     --
264     -- Data for Name: demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
265     --
266    
267     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;
268     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
269     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
270     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
271     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
272     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
273     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
274     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
275     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
276     \.
277    
278    
279     --
280     -- Name: demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
281     --
282    
283     SELECT pg_catalog.setval('demandeur_seq', 9, false);
284    
285    
286     --
287     -- Data for Name: dossier_commission; Type: TABLE DATA; Schema: openads; Owner: postgres
288     --
289    
290     COPY dossier_commission (dossier_commission, dossier, commission_type, date_souhaitee, motivation, commission, avis, lu) FROM stdin;
291     1 AZ0130551200001P0 1 2012-12-19 1 t
292     \.
293    
294    
295     --
296     -- Name: dossier_commission_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
297     --
298    
299     SELECT pg_catalog.setval('dossier_commission_seq', 2, false);
300    
301    
302     --
303     -- Name: instruction_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
304     --
305    
306 vpihour 2150 SELECT pg_catalog.setval('instruction_seq', 11, false);
307 fmichon 1801
308    
309     --
310     -- Data for Name: lien_demande_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
311     --
312    
313     COPY lien_demande_demandeur (lien_demande_demandeur, petitionnaire_principal, demande, demandeur) FROM stdin;
314     1 t 1 1
315     2 t 2 2
316     3 t 3 3
317     4 t 4 4
318     5 t 5 5
319     6 t 6 6
320     7 t 7 7
321     8 t 8 8
322     \.
323    
324    
325     --
326     -- Name: lien_demande_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
327     --
328    
329     SELECT pg_catalog.setval('lien_demande_demandeur_seq', 9, false);
330    
331    
332     --
333     -- Data for Name: lien_dossier_autorisation_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
334     --
335    
336     COPY lien_dossier_autorisation_demandeur (lien_dossier_autorisation_demandeur, petitionnaire_principal, dossier_autorisation, demandeur) FROM stdin;
337     1 t PC0130551200001 1
338     2 t PC0130551200002 2
339     3 t PD0130551200001 3
340     4 t PA0130551200001 4
341     5 t DP0130551200001 5
342     6 t CU0130551200001 6
343     7 t AZ0130551200001 7
344     8 t AT0130551200001 8
345     \.
346    
347    
348     --
349     -- Name: lien_dossier_autorisation_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
350     --
351    
352     SELECT pg_catalog.setval('lien_dossier_autorisation_demandeur_seq', 9, false);
353    
354    
355     --
356     -- Data for Name: lien_dossier_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
357     --
358    
359     COPY lien_dossier_demandeur (lien_dossier_demandeur, petitionnaire_principal, dossier, demandeur) FROM stdin;
360     1 t PC0130551200001P0 1
361     2 t PC0130551200002P0 2
362     3 t PD0130551200001P0 3
363     4 t PA0130551200001P0 4
364     5 t DP0130551200001P0 5
365     6 t CU0130551200001P0 6
366     7 t AZ0130551200001P0 7
367     8 t AT0130551200001P0 8
368     \.
369    
370    
371     --
372     -- Name: lien_dossier_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
373     --
374    
375     SELECT pg_catalog.setval('lien_dossier_demandeur_seq', 9, false);
376    
377    
378     --
379     -- Data for Name: lot; Type: TABLE DATA; Schema: openads; Owner: postgres
380     --
381    
382 vpihour 2150 COPY lot (lot, libelle, dossier_autorisation, dossier) FROM stdin;
383     1 test 20m² PC0130551200002 PC0130551200002P0
384     2 test 59m² PC0130551200002 PC0130551200002P0
385 fmichon 1801 \.
386    
387    
388     --
389     -- Data for Name: lien_lot_demandeur; Type: TABLE DATA; Schema: openads; Owner: postgres
390     --
391    
392     COPY lien_lot_demandeur (lien_lot_demandeur, lot, demandeur, petitionnaire_principal) FROM stdin;
393     1 1 7 t
394     2 2 7 t
395     \.
396    
397 nhaye 2188 --
398     -- Data for Name: donnees_techniques; Type: TABLE DATA; Schema: openads; Owner: postgres
399     --
400 fmichon 1801
401 nhaye 2188 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) FROM stdin;
402     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
403     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
404     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
405     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
406     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
407     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
408     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
409     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
410     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
411     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
412     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
413     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
414     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
415     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
416     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
417     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
418     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
419     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
420     \.
421    
422 fmichon 1801 --
423     -- Name: lien_lot_demandeur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
424     --
425    
426     SELECT pg_catalog.setval('lien_lot_demandeur_seq', 3, false);
427    
428    
429     --
430     -- Data for Name: service; Type: TABLE DATA; Schema: openads; Owner: postgres
431     --
432    
433     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;
434     59.02 Atelier du Patrimoine Square Belsunce 13001 Marseille 1 2 f f 2000-01-01 2100-01-01 pour_conformite
435     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
436     59.07 Service de l' Espace Public Rue Mongrand 13006 Marseille 0 7 f f 2000-01-01 2100-01-01 pour_information
437     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
438     59.12 Direction de la Propreté Urbaine DOCTEUR HECKEL 13011 Marseille 0 12 f f 2000-01-01 2100-01-01 pour_information
439     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
440     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
441     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
442     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
443     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
444     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
445     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
446     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
447     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
448     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
449     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
450     59.51 Direction de la Protection Civile Rue Nau 13005 Marseille 0 51 f f 2000-01-01 2100-01-01 avec_avis_attendu
451     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
452     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
453     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
454     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
455     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
456     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
457     59.64 Direction des Sports Allée Ray Grassi 13008 Marseille 1 63 f f 2000-01-01 2100-01-01 avec_avis_attendu
458     59.67 GDF Exploitation Transport Rue de Lyon 13015 Marseille 0 66 f f 2000-01-01 2100-01-01 avec_avis_attendu
459     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
460     59.70 AUTRE 0 69 f f 2000-01-01 2100-01-01 avec_avis_attendu
461     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
462     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
463     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
464     1ER Maire 1er Secteur 0 501 f f 2000-01-01 2100-01-01 avec_avis_attendu
465     2EME Maire 2ème Secteur 0 502 f f 2000-01-01 2100-01-01 avec_avis_attendu
466     3EME Maire 3ème Secteur 0 503 f f 2000-01-01 2100-01-01 avec_avis_attendu
467     4EME Maire 4ème Secteur 0 504 f f 2000-01-01 2100-01-01 avec_avis_attendu
468     5EME Maire 5ème Secteur 0 505 f f 2000-01-01 2100-01-01 avec_avis_attendu
469     6EME Maire 6ème Secteur 0 506 f f 2000-01-01 2100-01-01 avec_avis_attendu
470     7EME Maire 7ème Secteur 0 507 f f 2000-01-01 2100-01-01 avec_avis_attendu
471     8EME Maire 8ème Secteur 0 508 f f 2000-01-01 2100-01-01 avec_avis_attendu
472     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
473     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
474     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
475     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
476     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
477     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
478     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
479     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
480     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
481     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
482     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
483     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
484     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
485     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
486     59.10 MARSEILLE AMENAGEMENT - SOLEAM La Canebière 13001 MARSEILLE 0 511 f f 2000-01-01 2100-01-01 avec_avis_attendu
487     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
488     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
489     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
490     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
491     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
492     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
493     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
494     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
495     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
496     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
497     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
498     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
499     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
500     59.01 SERAM Capitaine Geze BP 10256 13308 Marseille Cedex 14 0 541 f f 2000-01-01 2100-01-01 avec_avis_attendu
501     59.88 DAE - RESID TOURISME ET HOTELIER 0 542 f f 2000-01-01 2100-01-01 avec_avis_attendu
502     59.11 LE TRAM RUE SAINT PIERRE 13005 MARSEILLE 0 543 f f 2000-01-01 2100-01-01 avec_avis_attendu
503     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
504     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
505     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
506     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
507     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
508     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
509     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
510     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
511     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
512     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
513     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
514     800 Changement d'Usage mairie secteur mairie de secteur 0 564 f f 2000-01-01 2100-01-01 avec_avis_attendu
515     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
516     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
517     59.89 BMP / PHOTOVOLTAIQUE Boulevard de Strasbourg 13303 Marseille Cedex 3 0 570 f f 2000-01-01 2100-01-01 avec_avis_attendu
518     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
519     DAEWE DAE - BUREAU ENTREPOT INDUSTRIE AGRICOLE 0 572 f f 2000-01-01 2100-01-01 avec_avis_attendu
520     JURIW PARQUET 0 574 f f 2000-01-01 2100-01-01 avec_avis_attendu
521     59.88 DAE - COMMERCE ARTISANAT 0 575 f f 2000-01-01 2100-01-01 avec_avis_attendu
522     59.36 Service de la Planification Urbaine Rue Colbert 13001 MARSEILLE 0 576 f f 2000-01-01 2100-01-01 avec_avis_attendu
523     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
524     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
525     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
526     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
527     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
528     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
529     DAE2 DAE - ETUDIANT - PUBLIC - ENSEIGNEMENT - RECHERCHE 0 584 f f 2000-01-01 2100-01-01 avec_avis_attendu
530     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
531     59.73 DDTM Taxe Aménagement 0 586 f f 2000-01-01 2100-01-01 avec_avis_attendu
532     ERPSE ERP Service Securité 24 rue de Rome 13001 Marseille [email protected] 3 23 f f 2012-11-03 2013-02-03 avec_avis_attendu
533     ERPAC ERP Service Accessibilité 24 rue de Rome 13001 Marseille [email protected] 3 24 f f 2012-11-03 2013-02-03 avec_avis_attendu
534     ERPSC ERP Service Conformité 24 rue de Rome 13001 Marseille [email protected] 3 587 f f 2012-11-03 2013-02-03 avec_avis_attendu
535 vpihour 2150 59.01 Direction de l'Eau et de l'Assainissement Boulevard Joseph Vernet 13008 Marseille [email protected] 1 1 f t 2000-01-01 2100-01-01 pour_conformite
536 fmichon 1801 \.
537    
538 vpihour 2056 --
539     -- Data for Name: consultation; Type: TABLE DATA; Schema: openads; Owner: postgres
540     --
541 fmichon 1801
542 vpihour 2056 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;
543     1 PC0130551200002P0 2013-01-01 \N 2013-02-01 1 \N 2013-01-01 \N t 120000000001 OP_FAILURE t
544     2 PC0130551200001P0 2013-03-01 \N 2013-04-01 1 \N 2013-03-01 \N t 120000000001 OP_FAILURE t
545     \.
546    
547    
548 fmichon 1801 --
549 vpihour 2056 -- Name: consultation_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
550     --
551    
552     SELECT pg_catalog.setval('consultation_seq', 3, false);
553    
554    
555     --
556 fmichon 1801 -- Data for Name: lien_service_om_utilisateur; Type: TABLE DATA; Schema: openads; Owner: postgres
557     --
558    
559     COPY lien_service_om_utilisateur (lien_service_om_utilisateur, om_utilisateur, service) FROM stdin;
560     1 6 1
561     2 6 7
562     3 6 13
563     4 8 6
564     5 8 8
565     6 8 15
566     7 7 77
567     \.
568    
569    
570     --
571     -- Name: lien_service_om_utilisateur_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
572     --
573    
574     SELECT pg_catalog.setval('lien_service_om_utilisateur_seq', 8, false);
575    
576    
577     --
578     -- Data for Name: service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
579     --
580    
581     COPY service_categorie (service_categorie, libelle) FROM stdin;
582     1 Maire de secteur
583     2 Service ville
584     3 Service extérieur
585     4 Consultation (villa) sans cession
586     5 Consultation pour cession
587     10 Consultation gros projet
588     11 Consultation Préfet
589     14 Consultation obligatoire version papier
590     15 Consultation mini dossier papier
591     16 photovoltaique
592     18 DADU - JURIDIQUE
593     \.
594    
595    
596     --
597     -- Data for Name: lien_service_service_categorie; Type: TABLE DATA; Schema: openads; Owner: postgres
598     --
599    
600     COPY lien_service_service_categorie (lien_service_service_categorie, service_categorie, service) FROM stdin;
601     1 4 1
602     2 4 2
603     3 10 6
604     4 2 7
605     5 10 8
606     6 10 12
607     7 2 13
608     8 10 15
609     9 5 17
610     10 14 22
611     11 3 25
612     12 15 31
613     13 2 39
614     14 15 43
615     15 15 45
616     16 15 49
617     17 2 50
618     18 15 51
619     19 15 52
620     20 2 54
621     21 15 57
622     22 15 59
623     23 15 60
624     24 3 61
625     25 2 63
626     26 15 66
627     27 2 67
628     28 15 69
629     29 15 70
630     30 15 72
631     31 14 77
632     32 1 501
633     33 1 502
634     34 1 503
635     35 1 504
636     36 1 505
637     37 1 506
638     38 1 507
639     39 1 508
640     40 15 14
641     41 14 19
642     42 15 21
643     43 5 26
644     44 15 30
645     45 2 38
646     46 3 42
647     47 15 44
648     48 4 46
649     49 3 48
650     50 14 71
651     51 15 76
652     52 15 79
653     53 15 80
654     54 3 511
655     55 2 512
656     56 15 513
657     57 10 519
658     58 2 36
659     59 11 528
660     60 5 20
661     61 2 68
662     62 15 531
663     63 15 532
664     64 2 533
665     65 3 538
666     66 15 539
667     67 15 540
668     68 4 541
669     69 10 542
670     70 15 543
671     71 15 544
672     72 14 546
673     73 15 547
674     74 14 549
675     75 14 550
676     76 3 552
677     77 2 553
678     78 2 560
679     79 15 561
680     80 4 562
681     81 3 563
682     82 3 564
683     83 15 56
684     84 14 568
685     85 16 570
686     86 14 571
687     87 10 572
688     88 18 574
689     89 10 575
690     90 2 576
691     91 2 577
692     92 2 578
693     93 2 580
694     94 3 581
695     95 10 5
696     96 14 583
697     97 10 584
698     98 2 585
699     99 3 586
700     \.
701    
702    
703     --
704     -- Name: lien_service_service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
705     --
706    
707     SELECT pg_catalog.setval('lien_service_service_categorie_seq', 100, false);
708    
709    
710     --
711     -- Name: lot_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
712     --
713    
714     SELECT pg_catalog.setval('lot_seq', 3, false);
715    
716    
717     --
718     -- Data for Name: quartier; Type: TABLE DATA; Schema: openads; Owner: postgres
719     --
720    
721     COPY quartier (quartier, arrondissement, code_impots, libelle) FROM stdin;
722     1 1 801 01 – BELSUNCE
723     2 1 802 02 – CHAPITRE
724     3 1 803 03 – NOAILLE
725     4 1 804 04 – OPERA
726     5 1 805 05 – ST. CHARLES
727     6 1 806 06 – THIERS
728     7 2 807 01 – ARENC
729     8 2 808 02 – LES GRANDS CARMES
730     9 2 809 03 – HOTEL DE VILLE
731     10 2 810 04 – JOLIETTE
732     11 3 811 01 – BELLE DE MAI
733     12 3 812 03 – ST. LAZARE
734     13 3 813 04 – ST. MAURONT
735     14 3 814 02 – LA VILETTE
736     15 4 815 01 – LA BLANCARDE
737     16 4 816 02 – LES CHARTREUX
738     17 4 817 03 – CHUTES LAVIES
739     18 4 818 04 – CINQ AVENUES
740     19 5 819 01 – BAILLE
741     20 5 820 02 – LE CAMAS
742     21 5 821 03 – LA CONCEPTION
743     22 5 822 04 – ST. PIERRE
744     23 6 823 01 – CASTELLANE
745     24 6 824 02 – LODI
746     25 6 825 03 – N. DAME DU MONT
747     26 6 826 04 – PALAIS DE JUSTICE
748     27 6 827 05 – PREFECTURE
749     28 6 828 06 – VAUBAN
750     29 7 829 01 – BOMPARD
751     30 7 830 02 – ENDOUME
752     31 7 831 07 – LES ILES
753     32 7 832 03 – PHARO
754     33 7 833 04 – ROUCAS BLANC
755     34 7 834 06 – ST LAMBERT
756     35 7 835 05 – ST. VICTOR
757     36 8 836 01 – BONNEVEINE
758     37 8 837 02 – LES GOUDES
759     38 8 838 03 – MONTREDON
760     39 8 839 04 – PERIER
761     40 8 840 05 – LA PLAGE
762     41 8 841 06 – LA POINTE ROUGE
763     42 8 842 07 – ROUET
764     43 8 843 09 – ST. GINIEZ
765     44 8 844 08 – STE ANNE
766     45 8 845 10 – VIEILLE CHAPELLE
767     46 9 846 01 – LES BAUMETTES
768     47 9 847 02 – LE CABOT
769     48 9 848 03 – CARPAGNE
770     49 9 849 04 – MAZARGUES
771     50 9 850 05 – LA PANOUSE
772     51 9 851 06 – LE REDON
773     52 9 852 08 – SORMIOU
774     53 9 853 07 – STE MARGUERITE
775     54 9 854 09 – VAUFREGES
776     55 10 855 01 – CAPELETTE
777     56 10 856 02 – MENPENTI
778     57 10 857 03 – PONT DE VIVAUX
779     58 10 858 04 – ST. LOUP
780     59 10 859 05 – ST. TRONC
781     60 10 860 06 – LA TIMONE
782     61 11 861 01 – LES ACCATES
783     62 11 862 02 – LA BARASSE
784     63 11 863 03 – LES CAMOINS
785     64 11 864 04 – EOURES
786     65 11 865 05 – LA MILLIERE
787     66 11 866 06 – LA POMME
788     67 11 867 07 – ST. MARCEL
789     68 11 868 08 – ST. MENET
790     69 11 869 09 – LA TREILLE
791     70 11 870 10 – LA VALBARELLE
792     71 11 871 11 – LA VALENTINE
793     72 12 872 01 – LES CAILLOLS
794     73 12 873 02 – LA FOURRAGERE
795     74 12 874 03 – MONTOLIVET
796     75 12 875 04 – ST. BARNABE
797     76 12 876 05 – ST. JEAN DU DESERT
798     77 12 877 06 – ST. JULIEN
799     78 12 878 07 – LES TROIS LUCS
800     79 13 879 01 – CHÂTEAU GOMBERT
801     80 13 880 02 – LA CROIX ROUGE
802     81 13 881 03 – MALPASSE
803     82 13 882 04 – LES MEDECINS
804     83 13 883 05 – LES MOURETS
805     84 13 884 06 – LES OLIVES
806     85 13 885 07 – PALAMA
807     86 13 886 08 – LA ROSE
808     87 13 887 09 – ST. JEROME
809     88 13 888 10 – ST. JUST
810     89 13 889 11 – ST. MITRE
811     90 14 890 01 – LES ARNAVAUX
812     91 14 891 02 – BON SECOURS
813     92 14 892 03 – LE CANET
814     93 14 893 04 – LE MERLAN
815     94 14 894 05 – ST. BARTHELEMY
816     95 14 895 06 – ST. JOSEPH
817     96 14 896 07 – STE MARTHE
818     97 15 897 01 – LES AYGALADES
819     98 15 898 02 – BOREL
820     99 15 899 03 – LA CABUCELLE
821     100 15 900 04 – LA CALADE
822     101 15 901 05 – LES CROTTES
823     102 15 902 06 – LA DELORME
824     103 15 903 07 – N. DAME LIMITE
825     104 15 904 08 – ST. ANTOINE
826     105 15 905 09 – ST. LOUIS
827     106 15 906 10 – VERDURON
828     107 15 907 11 – LA VISTE
829     108 16 908 01 – L'ESTAQUE
830     109 16 909 02 – LES RIAUX
831     110 16 910 03 – ST. ANDRE
832     111 16 911 04 – ST. HENRI
833     \.
834    
835    
836     --
837     -- Name: quartier_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
838     --
839    
840 fmichon 1844 SELECT pg_catalog.setval('quartier_seq', 112, false);
841 fmichon 1801
842    
843     --
844     -- Name: service_categorie_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
845     --
846    
847     SELECT pg_catalog.setval('service_categorie_seq', 19, false);
848    
849    
850     --
851     -- Name: service_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
852     --
853    
854     SELECT pg_catalog.setval('service_seq', 588, false);
855    
856    
857     --
858     -- Name: signataire_arrete_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
859     --
860    
861     SELECT pg_catalog.setval('signataire_arrete_seq', 2, false);
862    
863 vpihour 2056 --
864     -- Data for Name: lien_demande_type_etat_dossier_autorisation; Type: TABLE DATA; Schema: openads; Owner: postgres
865     --
866 fmichon 1801
867 vpihour 2056 COPY lien_demande_type_etat_dossier_autorisation (lien_demande_type_etat_dossier_autorisation, demande_type, etat_dossier_autorisation) FROM stdin;
868     1 17 2
869     2 18 2
870     3 19 2
871     4 20 2
872     5 21 2
873     6 22 2
874     7 23 2
875     8 24 2
876     \.
877    
878    
879 fmichon 1801 --
880 vpihour 2056 -- Name: lien_demande_type_etat_dossier_autorisation_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
881     --
882    
883     SELECT pg_catalog.setval('lien_demande_type_etat_dossier_autorisation_seq', 9, false);
884    
885     --
886 fmichon 1801 -- PostgreSQL database dump complete
887     --
888    

Properties

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