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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 134 by fraynaud, Thu Sep 22 10:41:33 2011 UTC revision 354 by fraynaud, Thu Jul 5 14:43:20 2012 UTC
# Line 1  Line 1 
1  -- $Id: initdata_sig.sql,v 1.1 2010-08-22 22:00:29 fraynaud Exp $  -- $Id: initdata_sig.sql,v 1.1 2010-08-22 22:00:29 fraynaud Exp $
2  -- initialisation de donnees  -- initialisation de donnees
3  -- base d'essai  -- base d'essai sur widget et données cartographiques
4    -- cette base d essai est donnee a titre d exemple
5    -- la base est localisée sur ARLES
6    
7    -- schema
8    -- SET search_path = openfoncier, pg_catalog;
9    
10    -- cartes
11    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (4, 1, 'salin', 'salin de giraud', 'Oui', '6', '', 'Oui', '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 &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php', NULL, NULL);
12    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) 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 &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php', NULL, NULL);
13    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) 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 &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php', NULL, NULL);
14    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (6, 1, 'agglomeration', 'agglomeration consultation', '', '18', '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 &DB_PREFIXEdossier  order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php', NULL, NULL);
15    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (10, 1, 'servitude_ligne', 'ligne servitude', '', '18', '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 &DB_PREFIXEservitude_ligne order by geom, servitude_ligne', '', 'servitude_ligne', 'geom', '../scr/tab.php?obj=servitude_ligne', NULL, NULL);
16    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (9, 1, 'servitude_point', 'saisie point servitude', '', '18', '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 &DB_PREFIXEservitude_point order by geom, servitude_point', '', 'servitude_point', 'geom', '../scr/tab.php?obj=servitude_point', NULL, NULL);
17    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (15, 1, 'parcelle_lot', 'parcelle lot saisie', 'Oui', '18', '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 &DB_PREFIXEdossier order by geom,dossier', '', 'parcelle_lot', 'geom', '../scr/tab.php?obj=parcelle_lot', '', 'Parcelle Lot');
18    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (11, 1, 'servitude_surfacique', 'serv. surface', '', '18', '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 &DB_PREFIXEservitude_surfacique order by geom, servitude_surfacique', 'Oui', 'servitude_surfacique', 'geom', '../scr/tab.php?obj=servitude_surfacique', 'polygon', 'servitude surfacique');
19    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (2, 1, 'pc_initialiser', 'Permis de construire initialiser', 'Oui', '10', 'Oui', '', '', 'Oui', '4.222,43.4,4.95,43.706', '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 &DB_PREFIXEdossier where nature = ''PC'' and etat =''initialiser'' order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php', 'point', 'dossier');
20    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (14, 1, 'pos', 'pos saisie', '', '18', '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 &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'pos', 'geom', '../scr/tab.php?obj=pos', 'polygon', 'POS ');
21    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (13, 1, 'parcelle', 'parcelle saisie', '', '18', '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 &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'parcelle', 'geom', '../scr/tab.php?obj=parcelle', 'polygon', 'parcelle');
22    INSERT INTO om_sig_map (om_sig_map, 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, type_geometrie, lib_geometrie) VALUES (3, 1, 'dossier', 'dossier', 'Oui', '18', '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 &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'dossier', 'geom', '../scr/tab.php?obj=PC', 'point', 'point');
23    -- sequences
24    ALTER SEQUENCE om_sig_map_seq RESTART WITH 16;
25    -- widget
26    INSERT INTO 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');
27    INSERT INTO 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');
28    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (1, 1, 'Ma météo à Arles', '#', '<div id=''cont_f5089b722555454d1872b91f52beafd4''>
29            <h2 id=''h_f5089b722555454d1872b91f52beafd4''><a href=''http://www.tameteo.com/'' title=''Météo''>Météo</a></h2>
30            <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>
31    </div>', '3');
32    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (5, 1, 'Mon horoscope', '#', '<!--DEBUT CODE ASTROO-->
33    
34    <!--debut code perso-->
35    
36    <iframe width=''232'' height=''302'' marginheight=''0'' marginwidth=''0'' frameborder=''0'' align=''center'' src=''http://www.astroo.com/horoscope.htm'' name=''astroo'' allowtransparency=''true''>
37    
38    <!--fin code perso-->
39    
40    <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>
41    
42    <noscript><a href=''http://www.astroo.com/horoscope.php'' target=''_blank''>horoscope</a></noscript>
43    
44    <!--FIN CODE ASTROO-->', '3');
45    INSERT INTO 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');
46    INSERT INTO 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');
47    INSERT INTO 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');
48    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (9, 1, 'Mes dossiers limite à 10 Jours', '#', '<script type=''text/javascript''>
49        $.ajax({
50            type: ''GET'',
51           url:''../app/tab_wid.php'',  
52           cache: false,
53           data: ''&obj=dossierlimite'',
54            success: function(html){
55                $(''#aff3'').replaceWith(html);
56            }
57        });
58    </script><div id=''aff3''></div>', '3');
59    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (3, 1, 'dossier notifié / dossiers', '#', '<script type=''text/javascript''>
60        $.ajax({
61            type: ''GET'',
62           url:''../app/jquerytest.php'',  
63           cache: false,
64           data: '''',
65            success: function(html){
66                $(''#aff3'').replaceWith(html);
67            }
68        });
69    </script><div id=''aff3''></div>', '3');
70    
71    ALTER SEQUENCE om_widget_seq RESTART WITH 10;
72    
73    -- --------
74    -- data sig
75    -- --------
76    
77    -- parcelle
78    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0010', '', '', '', '', 250, NULL, NULL, '01030000206A0800000100000005000000ED34050CF45F2941F65D701374FC5741E0CE59AD09602941C43ABB2174FC57410B616D0608602941679EC6696EFC57419DC46A9CF05F294103D01BAD6EFC5741ED34050CF45F2941F65D701374FC5741');
79    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0011', '', '', '', '', 400, NULL, NULL, '01030000206A08000001000000060000006CEF7959B55F29415909631C71FC5741C41FC4E6D15F2941AAA53F2F71FC57411F40A276D15F2941E8A587986EFC57410E2A4807B45F29412EA4AFA06EFC5741EC69E3EDB45F2941DB22146A6EFC57416CEF7959B55F29415909631C71FC5741');
80    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0012', '', '', '', '', 800, NULL, NULL, '01030000206A080000010000000A0000009BEEE689A15F2941F2744B8570FC5741522659E9915F294172C9C6CD70FC57419F100CC7935F2941CD1FA83A75FC5741262F831A985F2941D29A833D75FC57413288512A9A5F294108AAE87A78FC574185010281BE5F2941C99FE99278FC574115D0859EEB5F294139C982EF77FC5741CFD9DB6EE95F2941EFAD3D7375FC5741209592F9A45F29419A629FEB75FC57419BEEE689A15F2941F2744B8570FC5741');
81    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0013', '', '', '', '', 700, NULL, NULL, '01030000206A0800000100000005000000E2931B9D905F2941BD58EBCC70FC574170EF274D995F2941D280749B70FC5741B233BAE8975F29410BBA1C8E6EFC57414C72A0568E5F2941363698DA6EFC5741E2931B9D905F2941BD58EBCC70FC5741');
82    -- parcelle lot
83    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (1, 'LA MAJOR', '1', 1290.000, '01030000206A08000001000000050000005A9641791F6129412AA0BD2884FC574191090F25526129413C9C96187CFC57419D9C3CD0536129417DC0F1B481FC57414603C22F2A6129414F8DDA6B87FC57415A9641791F6129412AA0BD2884FC5741');
84    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (2, 'LA MAJOR', '2', 1432.000, '01030000206A08000001000000050000003D94B1741F6129416B70544484FC5741083CEB9A0F61294151A403AB80FC5741941D620E13612941FAD372807BFC5741FA72A9C6546129414D8B20E37BFC57413D94B1741F6129416B70544484FC5741');
85    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (3, 'LA MAJOR', '3', 1231.000, '01030000206A080000010000000600000076E5EDA6FB602941479C9EF080FC5741AC2F2D980861294141BF613081FC57414B0780040D6129416A6EDA607BFC5741C19649E2FA602941B73AA81D7BFC574145AEE0AEFF6029416FDD0D807DFC574176E5EDA6FB602941479C9EF080FC5741');
86    -- pos
87    INSERT INTO pos (pos, libelle, geom) VALUES ('PSMV', 'Secteur sauvegarde centre ville', '01030000206A080000010000001A0000003A4624DCE35B2941FC6CBF958FFC57417FADC5B28E5C2941CCB9AD649DFC57413AC3A890C75D29414D3B7AB4AAFC5741B31722CBD35E29411B1509BFB5FC5741678AB8E8C25F294105818156C9FC57414D9372C3286029410AAF6D8BC0FC5741DC3317BB8A60294133623154BAFC574159C8910F40622941982D5EB2B3FC574189693A9E08622941198813278AFC57416853DCDD9B612941CDAD72F653FC574198F206F464612941D7B4AE193CFC5741C619310718612941592F49A540FC5741787D723E17612941F29C416345FC5741B01189D722602941BA45E5B151FC5741C44D9CA06B5F2941FF33A4ED4FFC57411815A2AF285F2941535866F441FC57416D5CC8D5AC5D2941599CE7CC3BFC5741803F8D3F6F5D2941B86D395437FC5741834DA553425D29412E0136C836FC57418B04177AC95C2941831EF5BE34FC5741F5123524C05C2941E2D2AF6243FC5741C09138529A5C294147D6F7D36BFC5741609BCB04495C2941750824F875FC574199245494365C29411FBA76D27CFC57414DF759D0275C29417E18FD6382FC57413A4624DCE35B2941FC6CBF958FFC5741');
88    INSERT INTO pos (pos, libelle, geom) VALUES ('UC0', 'Roquette', '01030000206A0800000100000010000000A10507B7D158294171BFFE7C3CFC5741867A684FBF5929413887CF8F59FC5741EB33D9E74D5A294170824ABF6AFC574131F5DB82F45A294134CDC6497DFC57415E8F7639B75B294150B15C508DFC574124B92881F75B2941400D626781FC5741FAC1E2C3265C294115C391B973FC5741503A9E35785C29419566ABB868FC574175C88900AE5C29418CA7A26133FC5741A65D26C3BF5B294147C887512FFC5741AA24A60B225B2941107230DB25FC5741A6308FE67D5A29419767CD5B19FC5741E839F94D4D5A29417E7BB0181AFC57411BAED841AC59294162848FE524FC574165AD3FCC6259294117F5D47329FC5741A10507B7D158294171BFFE7C3CFC5741');
89    INSERT INTO pos (pos, libelle, geom) VALUES ('NU', 'Espaces verts inconstructible', '01030000206A080000010000000D000000C376252C165F2941FBE12A5E41FC574184397471155F2941A1E85DC945FC5741720434FC515F294107DD6E554BFC574168EF6AAC535F294157493DD650FC5741D1C754797B5F29416FB885F050FC574178E74D7CEF5F29418497BFCE50FC57418A6F092217602941A4B0DF984CFC574113FC258A2B612941B3077C323BFC5741C0C4A54F02612941E029FA4139FC5741BA2D72157A5F2941385C4A253FFC5741BE5BE8EA2C5F2941A157C1EA3FFC57415A3C9930295F2941970E538641FC5741C376252C165F2941FBE12A5E41FC5741');
90    -- servitude ligne
91    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (2, 'Route Ciculation', 'Boulevard emile combe', 150, '01020000206A080000070000005E5D4B0D1B6129417B5009C9EAFC574101920D86DB6129413F3D7F58DEFC574142A83FA11F62294126C5744AD0FC574144300EBA4B622941A5334BE1C0FC5741B0F0FE3F58622941458196F9B3FC57411545A2B2236229415BE76EE38DFC5741CAC9F7CA76612941DFBF6BE938FC5741');
92    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (1, 'Route circulation', 'Boulevard des lices', 100, '01020000206A080000050000005C9CA031C35C294129C323D930FC57418446B570845D2941968ABDCB34FC57411C27C5E0C85D2941E9E359B739FC57411ABC232F295F29412437DFEF3EFC57414F2E9E55706129413C507D1736FC5741');
93    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (3, 'Voie ferrée', 'Servitude de voie ferrée', 300, '01020000206A0800000400000068013DA385612941179A391819FD574128A62FDFF46129419EB6C788ECFC5741A74D5B766A622941627F7270C3FC5741D016D9546C64294123573E5A3DFC5741');
94    --           point
95    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (3, 'MH ', 'Primatiale Sainte Trophime ', 500, '01010000206A080000F2386B3CB95E29414E778FC462FC5741');
96    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (2, 'MH', 'Théâtre antique', 500, '01010000206A08000099418DC6C25F2941EA6E6CB55EFC5741');
97    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (1, 'MH', 'Cloitre Ste Trophime', 500, '01010000206A08000086CA96F5BD5E294165C1F81F5BFC5741');
98    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (4, 'MH', 'Eglise de la Major', 500, '01010000206A0800004D3C8EE78F61294109377C7D7FFC5741');
99    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (5, 'MH', 'Eglise Saint Julien', 500, '01010000206A080000377E0999805F2941D47520B9AFFC5741');
100    --           surfacique
101    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (1, 'Arenes ', 'Monument historique - contactez les monuments historiques ', 500, '01030000206A08000001000000130000005A6A80843E602941343CB55193FC57414E84C52B60602941C488F4F193FC5741DDBB5EA08B602941A35C13DF92FC5741BAA42723AC602941BC90C0EF8FFC5741B8E9F275D460294180868EA187FC5741E21C4F02E16029412231FDCA7FFC57413678479BD7602941E3EEB6D679FC5741988435C7C2602941560EE4EE74FC5741FAB12FF09E60294104285CD271FC5741A91E813971602941CB2554D770FC5741EE5CC7884760294189B42EB471FC5741B1EE0170236029413CF65D6275FC5741E43183C7076029414E5C57617AFC5741986E78BFF35F294173CFC25D80FC5741F848AB4DF45F29418545C97B87FC57413E5FEB510060294129FF2A568DFC5741CAF5AABC1E6029416A62E5D591FC5741192186954360294183CC421694FC57415A6A80843E602941343CB55193FC5741');
102    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (3, 'Zone innondable', 'A preciser dans l arrete', NULL, '01030000206A080000010000001B0000001D8BDB44D05B29410E140F4A90FC57413FABCA081D5C294119E9B02582FC57415081EE7C295C2941335907D97AFC5741EA9432E5345C2941153021E879FC5741E17FBD674A5C29411E660C6F75FC574137A521217A5C29416D0B1DFA79FC574195A9C967845C2941AF757CA67AFC5741C8FCD0A8E25C29411B815E377BFC5741383B017DEE5C2941BFE5C6F87CFC57419D172A20445D2941B1FACD4C7DFC5741743B80A24F5D294141F5D1FE80FC5741242DFAB85A5D2941F40F89FE81FC57418C9996D7E55D2941A9FC416E83FC5741188F28ECF75D29419D562F0484FC5741F52BE81BF95D2941E6EEDBD191FC5741FA99A19DFB5D29412DE5835D92FC5741DDC9B4B3195E29412BCAF6A093FC574158BB3B881E5E29414BB195149BFC5741407C762C205E2941016DAB9F9BFC5741AEB8A5723D5E2941BF5CC88F9CFC574112D6B4A3365E29415509EC5AA6FC5741B6F075011E5E29413B897AC5A8FC5741AC522FC20A5E29416789FC03AAFC5741751C5151C05D2941960F190AAAFC5741E2290EB7905D294177865006AAFC5741C0CE4B1C815C2941BEE5BB6F9EFC57411D8BDB44D05B29410E140F4A90FC5741');
103    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (2, 'DPR', 'Droit de preemption', 0, '01030000206A08000001000000170000006AB5C544D3582941C9B208923DFC574152AE3F27645A294130BB53506CFC574159D2E61FC05B2941684ECFD38BFC57417EF69CE1E15B2941FE8BDA1691FC574140F46C54895C2941439125759EFC5741D90A8AE28C5E29417E1B0A59B5FC57418638E91F905F2941CEBF58DFCCFC5741B9CA0EABF45F29415ED711F8E0FC57419E0056458A612941A57151B4DDFC57410B8F03F5C5612941F3000DAFD8FC57417B22D5A7D46129416F14018CD3FC57417A5FE3BE2862294138168898B8FC574144572587096229412C8C501D8FFC574191DD1685C9612941D38572776FFC574173E7AC39606129415CD7E54839FC574163AE2C84315F29414AAA35E640FC5741BEF5140EB95D2941C035592F3BFC5741D292003C6A5D29413AF9E53C36FC57419258827AD25B294161B2AF4E31FC5741D5D9F3D97B5A294112524D4B1BFC5741FFDA084E605A29419820615C1AFC574137247DDD475A2941A2228D971BFC57416AB5C544D3582941C9B208923DFC5741');
104    
105    -- seq
106    SELECT pg_catalog.setval('servitude_surfacique_seq', 4, true);
107    SELECT pg_catalog.setval('servitude_ligne_seq', 4, true);
108    SELECT pg_catalog.setval('servitude_point_seq', 6, true);
109    SELECT pg_catalog.setval('parcelle_lot_seq', 3, true);
Legend:
Removed from v.134  
changed lines
  Added in v.354
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26