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

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

Parent Directory Parent Directory | Revision Log Revision Log

Revision 240 - (show annotations)
Tue Nov 22 21:07:04 2011 UTC (13 years, 2 months ago) by fraynaud
File size: 21071 byte(s) 
mise en place de schema
1 -- $Id: initdata_sig.sql,v 1.1 2010-08-22 22:00:29 fraynaud Exp $
2 -- initialisation de donnees
3 -- base d'essai
4
5 -- cartes
6
7 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (5, 1, 'raphele', 'raphele', '', '6', '', '', 'Oui', 'Oui', '4.71417,43.64,4.72994,43.65166', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
8 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (8, 1, 'vitrolles', 'vitrolles demonstration', 'Oui', '4', '', '', 'Oui', 'Oui', '5.2094,43.4136,5.3345,43.4759', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
9 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (7, 1, 'masthibert', 'mas Thibert copie du 05/09/2011', '', '6', '', '', 'Oui', 'Oui', '4.72345,43.55348,4.73134,43.55932', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
10 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (6, 1, 'agglomeration', 'agglomeration consultation', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
11 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (3, 1, 'dossier', 'dossier saisie', 'Oui', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', 'Oui', 'dossier', 'geom', '../scr/tab.php?obj=PC');
12 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (9, 1, 'servitude_point', 'saisie point servitude', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/servitude_point.php?menu=0&id=', 'select astext(geom) as geom, libelle as titre, observation as description, servitude_point as idx from servitude_point order by geom, servitude_point', 'Oui', 'servitude_point', 'geom', '../scr/tab.php?obj=servitude_point');
13 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (4, 1, 'salin', 'salin de giraud', 'Oui', '6', '', '', 'Oui', 'Oui', '4.701,43.3966,4.7636,43.4298', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
14 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (13, 1, 'parcelle', 'parcelle saisie', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', 'Oui', 'parcelle', 'geom', '../scr/tab.php?obj=parcelle');
15 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (10, 1, 'servitude_ligne', 'ligne servitude', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/servitude_ligne.php?menu=0&id=', 'select astext(geom) as geom, libelle as titre, observation as description, servitude_ligne as idx from servitude_ligne order by geom, servitude_ligne', 'Oui', 'servitude_ligne', 'geom', '../scr/tab.php?obj=servitude_ligne');
16 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (15, 1, 'parcelle_lot', 'parcelle lot saisie', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', 'Oui', 'parcelle_lot', 'geom', '../scr/tab.php?obj=parcelle_lot');
17 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (14, 1, 'pos', 'pos saisie', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/dossier.php?menu=0&id=', 'select astext(geom) as geom, parcelle as titre, (dossier||'' ''||demandeur_nom) as description, dossier as idx from dossier order by geom,dossier', 'Oui', 'pos', 'geom', '../scr/tab.php?obj=pos');
18 INSERT INTO public.om_sig_point (om_sig_point, om_collectivite, id, libelle, actif, zoom, fond_osm, fond_bing, fond_sat, layer_info, etendue, projection_externe, url, om_sql, maj, table_update, champ, retour) VALUES (11, 1, 'servitude_surfacique', 'serv. surface', '', '18', 'Oui', 'Oui', 'Oui', 'Oui', '4.5868,43.6518,4.6738,43.7018', 'EPSG:2154', '../app/servitude_surfacique.php?menu=0&id=', 'select astext(geom) as geom, libelle as titre, observation as description, servitude_surfacique as idx from servitude_surfacique order by geom, servitude_surfacique', 'Oui', 'servitude_surfacique', 'geom', '../scr/tab.php?obj=servitude_surfacique');
19
20 ALTER SEQUENCE public.om_sig_point_seq RESTART WITH 16;
21
22 -- widget
23
24 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (4, 1, 'Carte de Raphèle', '../scr/tab_sig_point.php?obj=raphele&zoom=6', 'Est présenté ici les permis de RAPHELE', '3');
25 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (2, 1, 'Carte de salin', '../scr/tab_sig_point.php?obj=salin&zoom=6', 'Est presente ici les permis de salin de giraud', '3');
26 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (1, 1, 'Ma météo à Arles', '#', '<div id=''cont_f5089b722555454d1872b91f52beafd4''>
27 <h2 id=''h_f5089b722555454d1872b91f52beafd4''><a href=''http://www.tameteo.com/'' title=''Météo''>Météo</a></h2>
28 <a id=''a_f5089b722555454d1872b91f52beafd4'' href=''http://www.tameteo.com/meteo_Arles-Europe-France-Bouches+du+Rhone--1-25772.html'' target=''_blank'' title=''Météo Arles'' style=''color:#666666;font-family:1;font-size:14px;''></a><script type=''text/javascript'' src=''http://www.tameteo.com/wid_loader/f5089b722555454d1872b91f52beafd4''></script>
29 </div>', '3');
30 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (5, 1, 'Mon horoscope', '#', '<!--DEBUT CODE ASTROO-->
31
32 <!--debut code perso-->
33
34 <iframe width=''232'' height=''302'' marginheight=''0'' marginwidth=''0'' frameborder=''0'' align=''center'' src=''http://www.astroo.com/horoscope.htm'' name=''astroo'' allowtransparency=''true''>
35
36 <!--fin code perso-->
37
38 <a href=''http://www.astroo.com/horoscope.php'' target=''_top'' title=''Cliquez-ici pour afficher l''horoscope quotidien''><font face=''Verdana'' size=''2''><b>afficher l''horoscope du jour</b></font></a></iframe>
39
40 <noscript><a href=''http://www.astroo.com/horoscope.php'' target=''_blank''>horoscope</a></noscript>
41
42 <!--FIN CODE ASTROO-->', '3');
43 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (6, 1, 'Carte agglomération ', '../scr/tab_sig_point.php?obj=agglomeration', 'representation de l agglomération d''Arles', '3');
44 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (7, 1, 'Actualités ATREAL', '#', '<script src=''http://www.gmodules.com/ig/ifr?url=http://www.ajaxgaier.com/iGoogle/rss-reader%2B.xml&up_title=Actualit%C3%A9s%20atReal&up_feed=http%3A%2F%2Fwww.atreal.fr%2Fatreal%2Fcommunaute%2Factualites-atreal%2FRSS&up_contentnr=9&up_fontsize=9&up_lineheight=70&up_titlelink=&up_bullet=1&up_reload_feed=0&up_reload_fqcy=0&up_hl_background=FFFFFF&synd=open&w=200&h=100&title=&border=%23ffffff%7C3px%2C1px+solid+%23999999&output=js''></script>', '3');
45 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (8, 1, 'Retour Consultation', '../scr/tab.php?obj=consultation_retour', 'Ce lien vous permet d''accéder à la liste des consultations sans avis qui ont une date de retour encore valide', '3');
46 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (9, 1, 'Mes dossiers limite à 10 Jours', '#', '<script type=''text/javascript''>
47 $.ajax({
48 type: ''GET'',
49 url:''../app/tab_wid.php'',
50 cache: false,
51 data: ''&obj=dossierlimite'',
52 success: function(html){
53 $(''#aff3'').replaceWith(html);
54 }
55 });
56 </script><div id=''aff3''></div>', '3');
57 INSERT INTO public.om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (3, 1, 'dossier notifié / dossiers', '#', '<script type=''text/javascript''>
58 $.ajax({
59 type: ''GET'',
60 url:''../app/jquerytest.php'',
61 cache: false,
62 data: '''',
63 success: function(html){
64 $(''#aff3'').replaceWith(html);
65 }
66 });
67 </script><div id=''aff3''></div>', '3');
68
69 ALTER SEQUENCE public.om_widget_seq RESTART WITH 10;
70
71
72 -- data sig
73
74 -- parcelle
75
76 INSERT INTO public.parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0010', '', '', '', '', 250, NULL, NULL, '01030000206A0800000100000005000000ED34050CF45F2941F65D701374FC5741E0CE59AD09602941C43ABB2174FC57410B616D0608602941679EC6696EFC57419DC46A9CF05F294103D01BAD6EFC5741ED34050CF45F2941F65D701374FC5741');
77 INSERT INTO public.parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0011', '', '', '', '', 400, NULL, NULL, '01030000206A08000001000000060000006CEF7959B55F29415909631C71FC5741C41FC4E6D15F2941AAA53F2F71FC57411F40A276D15F2941E8A587986EFC57410E2A4807B45F29412EA4AFA06EFC5741EC69E3EDB45F2941DB22146A6EFC57416CEF7959B55F29415909631C71FC5741');
78 INSERT INTO public.parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0012', '', '', '', '', 800, NULL, NULL, '01030000206A080000010000000A0000009BEEE689A15F2941F2744B8570FC5741522659E9915F294172C9C6CD70FC57419F100CC7935F2941CD1FA83A75FC5741262F831A985F2941D29A833D75FC57413288512A9A5F294108AAE87A78FC574185010281BE5F2941C99FE99278FC574115D0859EEB5F294139C982EF77FC5741CFD9DB6EE95F2941EFAD3D7375FC5741209592F9A45F29419A629FEB75FC57419BEEE689A15F2941F2744B8570FC5741');
79 INSERT INTO public.parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0013', '', '', '', '', 700, NULL, NULL, '01030000206A0800000100000005000000E2931B9D905F2941BD58EBCC70FC574170EF274D995F2941D280749B70FC5741B233BAE8975F29410BBA1C8E6EFC57414C72A0568E5F2941363698DA6EFC5741E2931B9D905F2941BD58EBCC70FC5741');
80 -- parcelle lot
81 INSERT INTO public.parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (1, 'LA MAJOR', '1', 1290.000, '01030000206A08000001000000050000005A9641791F6129412AA0BD2884FC574191090F25526129413C9C96187CFC57419D9C3CD0536129417DC0F1B481FC57414603C22F2A6129414F8DDA6B87FC57415A9641791F6129412AA0BD2884FC5741');
82 INSERT INTO public.parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (2, 'LA MAJOR', '2', 1432.000, '01030000206A08000001000000050000003D94B1741F6129416B70544484FC5741083CEB9A0F61294151A403AB80FC5741941D620E13612941FAD372807BFC5741FA72A9C6546129414D8B20E37BFC57413D94B1741F6129416B70544484FC5741');
83 INSERT INTO public.parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (3, 'LA MAJOR', '3', 1231.000, '01030000206A080000010000000600000076E5EDA6FB602941479C9EF080FC5741AC2F2D980861294141BF613081FC57414B0780040D6129416A6EDA607BFC5741C19649E2FA602941B73AA81D7BFC574145AEE0AEFF6029416FDD0D807DFC574176E5EDA6FB602941479C9EF080FC5741');
84 -- pos
85 INSERT INTO public.pos (pos, libelle, geom) VALUES ('PSMV', 'Secteur sauvegarde centre ville', '01030000206A080000010000001A0000003A4624DCE35B2941FC6CBF958FFC57417FADC5B28E5C2941CCB9AD649DFC57413AC3A890C75D29414D3B7AB4AAFC5741B31722CBD35E29411B1509BFB5FC5741678AB8E8C25F294105818156C9FC57414D9372C3286029410AAF6D8BC0FC5741DC3317BB8A60294133623154BAFC574159C8910F40622941982D5EB2B3FC574189693A9E08622941198813278AFC57416853DCDD9B612941CDAD72F653FC574198F206F464612941D7B4AE193CFC5741C619310718612941592F49A540FC5741787D723E17612941F29C416345FC5741B01189D722602941BA45E5B151FC5741C44D9CA06B5F2941FF33A4ED4FFC57411815A2AF285F2941535866F441FC57416D5CC8D5AC5D2941599CE7CC3BFC5741803F8D3F6F5D2941B86D395437FC5741834DA553425D29412E0136C836FC57418B04177AC95C2941831EF5BE34FC5741F5123524C05C2941E2D2AF6243FC5741C09138529A5C294147D6F7D36BFC5741609BCB04495C2941750824F875FC574199245494365C29411FBA76D27CFC57414DF759D0275C29417E18FD6382FC57413A4624DCE35B2941FC6CBF958FFC5741');
86 INSERT INTO public.pos (pos, libelle, geom) VALUES ('UC0', 'Roquette', '01030000206A0800000100000010000000A10507B7D158294171BFFE7C3CFC5741867A684FBF5929413887CF8F59FC5741EB33D9E74D5A294170824ABF6AFC574131F5DB82F45A294134CDC6497DFC57415E8F7639B75B294150B15C508DFC574124B92881F75B2941400D626781FC5741FAC1E2C3265C294115C391B973FC5741503A9E35785C29419566ABB868FC574175C88900AE5C29418CA7A26133FC5741A65D26C3BF5B294147C887512FFC5741AA24A60B225B2941107230DB25FC5741A6308FE67D5A29419767CD5B19FC5741E839F94D4D5A29417E7BB0181AFC57411BAED841AC59294162848FE524FC574165AD3FCC6259294117F5D47329FC5741A10507B7D158294171BFFE7C3CFC5741');
87 INSERT INTO public.pos (pos, libelle, geom) VALUES ('NU', 'Espaces verts inconstructible', '01030000206A080000010000000D000000C376252C165F2941FBE12A5E41FC574184397471155F2941A1E85DC945FC5741720434FC515F294107DD6E554BFC574168EF6AAC535F294157493DD650FC5741D1C754797B5F29416FB885F050FC574178E74D7CEF5F29418497BFCE50FC57418A6F092217602941A4B0DF984CFC574113FC258A2B612941B3077C323BFC5741C0C4A54F02612941E029FA4139FC5741BA2D72157A5F2941385C4A253FFC5741BE5BE8EA2C5F2941A157C1EA3FFC57415A3C9930295F2941970E538641FC5741C376252C165F2941FBE12A5E41FC5741');
88 -- servitude
89 INSERT INTO public.servitude_ligne (servitude_ligne, libelle, observation, distance, geom) VALUES (2, 'Route Ciculation', 'Boulevard emile combe', 150, '01020000206A080000070000005E5D4B0D1B6129417B5009C9EAFC574101920D86DB6129413F3D7F58DEFC574142A83FA11F62294126C5744AD0FC574144300EBA4B622941A5334BE1C0FC5741B0F0FE3F58622941458196F9B3FC57411545A2B2236229415BE76EE38DFC5741CAC9F7CA76612941DFBF6BE938FC5741');
90 INSERT INTO public.servitude_ligne (servitude_ligne, libelle, observation, distance, geom) VALUES (1, 'Route circulation', 'Boulevard des lices', 100, '01020000206A080000050000005C9CA031C35C294129C323D930FC57418446B570845D2941968ABDCB34FC57411C27C5E0C85D2941E9E359B739FC57411ABC232F295F29412437DFEF3EFC57414F2E9E55706129413C507D1736FC5741');
91 INSERT INTO public.servitude_ligne (servitude_ligne, libelle, observation, distance, geom) VALUES (3, 'Voie ferrée', 'Servitude de voie ferrée', 300, '01020000206A0800000400000068013DA385612941179A391819FD574128A62FDFF46129419EB6C788ECFC5741A74D5B766A622941627F7270C3FC5741D016D9546C64294123573E5A3DFC5741');
92
93 INSERT INTO public.servitude_point (servitude_point, libelle, observation, distance, geom) VALUES (3, 'MH ', 'Primatiale Sainte Trophime ', 500, '01010000206A080000F2386B3CB95E29414E778FC462FC5741');
94 INSERT INTO public.servitude_point (servitude_point, libelle, observation, distance, geom) VALUES (2, 'MH', 'Théâtre antique', 500, '01010000206A08000099418DC6C25F2941EA6E6CB55EFC5741');
95 INSERT INTO public.servitude_point (servitude_point, libelle, observation, distance, geom) VALUES (1, 'MH', 'Cloitre Ste Trophime', 500, '01010000206A08000086CA96F5BD5E294165C1F81F5BFC5741');
96 INSERT INTO public.servitude_point (servitude_point, libelle, observation, distance, geom) VALUES (4, 'MH', 'Eglise de la Major', 500, '01010000206A0800004D3C8EE78F61294109377C7D7FFC5741');
97 INSERT INTO public.servitude_point (servitude_point, libelle, observation, distance, geom) VALUES (5, 'MH', 'Eglise Saint Julien', 500, '01010000206A080000377E0999805F2941D47520B9AFFC5741');
98
99 INSERT INTO public.servitude_surfacique (servitude_surfacique, libelle, observation, distance, geom) VALUES (1, 'Arenes ', 'Monument historique - contactez les monuments historiques ', 500, '01030000206A08000001000000130000005A6A80843E602941343CB55193FC57414E84C52B60602941C488F4F193FC5741DDBB5EA08B602941A35C13DF92FC5741BAA42723AC602941BC90C0EF8FFC5741B8E9F275D460294180868EA187FC5741E21C4F02E16029412231FDCA7FFC57413678479BD7602941E3EEB6D679FC5741988435C7C2602941560EE4EE74FC5741FAB12FF09E60294104285CD271FC5741A91E813971602941CB2554D770FC5741EE5CC7884760294189B42EB471FC5741B1EE0170236029413CF65D6275FC5741E43183C7076029414E5C57617AFC5741986E78BFF35F294173CFC25D80FC5741F848AB4DF45F29418545C97B87FC57413E5FEB510060294129FF2A568DFC5741CAF5AABC1E6029416A62E5D591FC5741192186954360294183CC421694FC57415A6A80843E602941343CB55193FC5741');
100 INSERT INTO public.servitude_surfacique (servitude_surfacique, libelle, observation, distance, geom) VALUES (3, 'Zone innondable', 'A preciser dans l arrete', NULL, '01030000206A080000010000001B0000001D8BDB44D05B29410E140F4A90FC57413FABCA081D5C294119E9B02582FC57415081EE7C295C2941335907D97AFC5741EA9432E5345C2941153021E879FC5741E17FBD674A5C29411E660C6F75FC574137A521217A5C29416D0B1DFA79FC574195A9C967845C2941AF757CA67AFC5741C8FCD0A8E25C29411B815E377BFC5741383B017DEE5C2941BFE5C6F87CFC57419D172A20445D2941B1FACD4C7DFC5741743B80A24F5D294141F5D1FE80FC5741242DFAB85A5D2941F40F89FE81FC57418C9996D7E55D2941A9FC416E83FC5741188F28ECF75D29419D562F0484FC5741F52BE81BF95D2941E6EEDBD191FC5741FA99A19DFB5D29412DE5835D92FC5741DDC9B4B3195E29412BCAF6A093FC574158BB3B881E5E29414BB195149BFC5741407C762C205E2941016DAB9F9BFC5741AEB8A5723D5E2941BF5CC88F9CFC574112D6B4A3365E29415509EC5AA6FC5741B6F075011E5E29413B897AC5A8FC5741AC522FC20A5E29416789FC03AAFC5741751C5151C05D2941960F190AAAFC5741E2290EB7905D294177865006AAFC5741C0CE4B1C815C2941BEE5BB6F9EFC57411D8BDB44D05B29410E140F4A90FC5741');
101 INSERT INTO public.servitude_surfacique (servitude_surfacique, libelle, observation, distance, geom) VALUES (2, 'DPR', 'Droit de preemption', 0, '01030000206A08000001000000170000006AB5C544D3582941C9B208923DFC574152AE3F27645A294130BB53506CFC574159D2E61FC05B2941684ECFD38BFC57417EF69CE1E15B2941FE8BDA1691FC574140F46C54895C2941439125759EFC5741D90A8AE28C5E29417E1B0A59B5FC57418638E91F905F2941CEBF58DFCCFC5741B9CA0EABF45F29415ED711F8E0FC57419E0056458A612941A57151B4DDFC57410B8F03F5C5612941F3000DAFD8FC57417B22D5A7D46129416F14018CD3FC57417A5FE3BE2862294138168898B8FC574144572587096229412C8C501D8FFC574191DD1685C9612941D38572776FFC574173E7AC39606129415CD7E54839FC574163AE2C84315F29414AAA35E640FC5741BEF5140EB95D2941C035592F3BFC5741D292003C6A5D29413AF9E53C36FC57419258827AD25B294161B2AF4E31FC5741D5D9F3D97B5A294112524D4B1BFC5741FFDA084E605A29419820615C1AFC574137247DDD475A2941A2228D971BFC57416AB5C544D3582941C9B208923DFC5741');
102
103 -- seq
104 SELECT pg_catalog.setval('public.servitude_surfacique_seq', 3, true);
105 SELECT pg_catalog.setval('public.servitude_ligne_seq', 3, true);
106 SELECT pg_catalog.setval('public.servitude_point_seq', 5, true);
107 SELECT pg_catalog.setval('public.parcelle_lot_seq', 2, true);
108
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26