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

Properties

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