/[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 3 by fraynaud, Thu Feb 10 20:46:18 2011 UTC revision 268 by fraynaud, Thu Dec 8 09:14:00 2011 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 arles section cadastrale AM  -- base d'essai
4  -- executer le script en sql  -- cette base d essai est donnee a titre d exemple
5    -- base localisée sur ARLES
6    
7    -- schema
8    -- SET search_path = openfoncier, pg_catalog;
9    
10    
11    -- cartes
12    
13    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
14    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
15    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
16    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
17    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'dossier', 'geom', '../scr/tab.php?obj=PC');
18    INSERT INTO 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  &DB_PREFIXEservitude_point order by geom, servitude_point', 'Oui', 'servitude_point', 'geom', '../scr/tab.php?obj=servitude_point');
19    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
20    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'parcelle', 'geom', '../scr/tab.php?obj=parcelle');
21    INSERT INTO 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  &DB_PREFIXEservitude_ligne order by geom, servitude_ligne', 'Oui', 'servitude_ligne', 'geom', '../scr/tab.php?obj=servitude_ligne');
22    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'parcelle_lot', 'geom', '../scr/tab.php?obj=parcelle_lot');
23    INSERT INTO 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  &DB_PREFIXEdossier order by geom,dossier', 'Oui', 'pos', 'geom', '../scr/tab.php?obj=pos');
24    INSERT INTO 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  &DB_PREFIXEfrom servitude_surfacique order by geom, servitude_surfacique', 'Oui', 'servitude_surfacique', 'geom', '../scr/tab.php?obj=servitude_surfacique');
25    
26    ALTER SEQUENCE om_sig_point_seq RESTART WITH 16;
27    
28    -- widget
29    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');
30    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');
31    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''>
32            <h2 id=''h_f5089b722555454d1872b91f52beafd4''><a href=''http://www.tameteo.com/'' title=''Météo''>Météo</a></h2>
33            <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>
34    </div>', '3');
35    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (5, 1, 'Mon horoscope', '#', '<!--DEBUT CODE ASTROO-->
36    
37    <!--debut code perso-->
38    
39    <iframe width=''232'' height=''302'' marginheight=''0'' marginwidth=''0'' frameborder=''0'' align=''center'' src=''http://www.astroo.com/horoscope.htm'' name=''astroo'' allowtransparency=''true''>
40    
41    <!--fin code perso-->
42    
43    <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>
44    
45    <noscript><a href=''http://www.astroo.com/horoscope.php'' target=''_blank''>horoscope</a></noscript>
46    
47    <!--FIN CODE ASTROO-->', '3');
48    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');
49    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');
50    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');
51    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''>
52        $.ajax({
53            type: ''GET'',
54           url:''../app/tab_wid.php'',  
55           cache: false,
56           data: ''&obj=dossierlimite'',
57            success: function(html){
58                $(''#aff3'').replaceWith(html);
59            }
60        });
61    </script><div id=''aff3''></div>', '3');
62    INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (3, 1, 'dossier notifié / dossiers', '#', '<script type=''text/javascript''>
63        $.ajax({
64            type: ''GET'',
65           url:''../app/jquerytest.php'',  
66           cache: false,
67           data: '''',
68            success: function(html){
69                $(''#aff3'').replaceWith(html);
70            }
71        });
72    </script><div id=''aff3''></div>', '3');
73    
74    ALTER SEQUENCE om_widget_seq RESTART WITH 10;
75    
76    -- --------
77    -- data sig
78    -- --------
79    
80    -- parcelle
81    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0010', '', '', '', '', 250, NULL, NULL, '01030000206A0800000100000005000000ED34050CF45F2941F65D701374FC5741E0CE59AD09602941C43ABB2174FC57410B616D0608602941679EC6696EFC57419DC46A9CF05F294103D01BAD6EFC5741ED34050CF45F2941F65D701374FC5741');
82    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0011', '', '', '', '', 400, NULL, NULL, '01030000206A08000001000000060000006CEF7959B55F29415909631C71FC5741C41FC4E6D15F2941AAA53F2F71FC57411F40A276D15F2941E8A587986EFC57410E2A4807B45F29412EA4AFA06EFC5741EC69E3EDB45F2941DB22146A6EFC57416CEF7959B55F29415909631C71FC5741');
83    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0012', '', '', '', '', 800, NULL, NULL, '01030000206A080000010000000A0000009BEEE689A15F2941F2744B8570FC5741522659E9915F294172C9C6CD70FC57419F100CC7935F2941CD1FA83A75FC5741262F831A985F2941D29A833D75FC57413288512A9A5F294108AAE87A78FC574185010281BE5F2941C99FE99278FC574115D0859EEB5F294139C982EF77FC5741CFD9DB6EE95F2941EFAD3D7375FC5741209592F9A45F29419A629FEB75FC57419BEEE689A15F2941F2744B8570FC5741');
84    INSERT INTO parcelle (parcelle, debut, rivoli, proprietaire, pos, surface, section, commune, geom) VALUES ('AE0013', '', '', '', '', 700, NULL, NULL, '01030000206A0800000100000005000000E2931B9D905F2941BD58EBCC70FC574170EF274D995F2941D280749B70FC5741B233BAE8975F29410BBA1C8E6EFC57414C72A0568E5F2941363698DA6EFC5741E2931B9D905F2941BD58EBCC70FC5741');
85    -- parcelle lot
86    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (1, 'LA MAJOR', '1', 1290.000, '01030000206A08000001000000050000005A9641791F6129412AA0BD2884FC574191090F25526129413C9C96187CFC57419D9C3CD0536129417DC0F1B481FC57414603C22F2A6129414F8DDA6B87FC57415A9641791F6129412AA0BD2884FC5741');
87    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (2, 'LA MAJOR', '2', 1432.000, '01030000206A08000001000000050000003D94B1741F6129416B70544484FC5741083CEB9A0F61294151A403AB80FC5741941D620E13612941FAD372807BFC5741FA72A9C6546129414D8B20E37BFC57413D94B1741F6129416B70544484FC5741');
88    INSERT INTO parcelle_lot (parcelle_lot, lotissement, numero, surface, geom) VALUES (3, 'LA MAJOR', '3', 1231.000, '01030000206A080000010000000600000076E5EDA6FB602941479C9EF080FC5741AC2F2D980861294141BF613081FC57414B0780040D6129416A6EDA607BFC5741C19649E2FA602941B73AA81D7BFC574145AEE0AEFF6029416FDD0D807DFC574176E5EDA6FB602941479C9EF080FC5741');
89    -- pos
90    INSERT INTO pos (pos, libelle, geom) VALUES ('PSMV', 'Secteur sauvegarde centre ville', '01030000206A080000010000001A0000003A4624DCE35B2941FC6CBF958FFC57417FADC5B28E5C2941CCB9AD649DFC57413AC3A890C75D29414D3B7AB4AAFC5741B31722CBD35E29411B1509BFB5FC5741678AB8E8C25F294105818156C9FC57414D9372C3286029410AAF6D8BC0FC5741DC3317BB8A60294133623154BAFC574159C8910F40622941982D5EB2B3FC574189693A9E08622941198813278AFC57416853DCDD9B612941CDAD72F653FC574198F206F464612941D7B4AE193CFC5741C619310718612941592F49A540FC5741787D723E17612941F29C416345FC5741B01189D722602941BA45E5B151FC5741C44D9CA06B5F2941FF33A4ED4FFC57411815A2AF285F2941535866F441FC57416D5CC8D5AC5D2941599CE7CC3BFC5741803F8D3F6F5D2941B86D395437FC5741834DA553425D29412E0136C836FC57418B04177AC95C2941831EF5BE34FC5741F5123524C05C2941E2D2AF6243FC5741C09138529A5C294147D6F7D36BFC5741609BCB04495C2941750824F875FC574199245494365C29411FBA76D27CFC57414DF759D0275C29417E18FD6382FC57413A4624DCE35B2941FC6CBF958FFC5741');
91    INSERT INTO pos (pos, libelle, geom) VALUES ('UC0', 'Roquette', '01030000206A0800000100000010000000A10507B7D158294171BFFE7C3CFC5741867A684FBF5929413887CF8F59FC5741EB33D9E74D5A294170824ABF6AFC574131F5DB82F45A294134CDC6497DFC57415E8F7639B75B294150B15C508DFC574124B92881F75B2941400D626781FC5741FAC1E2C3265C294115C391B973FC5741503A9E35785C29419566ABB868FC574175C88900AE5C29418CA7A26133FC5741A65D26C3BF5B294147C887512FFC5741AA24A60B225B2941107230DB25FC5741A6308FE67D5A29419767CD5B19FC5741E839F94D4D5A29417E7BB0181AFC57411BAED841AC59294162848FE524FC574165AD3FCC6259294117F5D47329FC5741A10507B7D158294171BFFE7C3CFC5741');
92    INSERT INTO pos (pos, libelle, geom) VALUES ('NU', 'Espaces verts inconstructible', '01030000206A080000010000000D000000C376252C165F2941FBE12A5E41FC574184397471155F2941A1E85DC945FC5741720434FC515F294107DD6E554BFC574168EF6AAC535F294157493DD650FC5741D1C754797B5F29416FB885F050FC574178E74D7CEF5F29418497BFCE50FC57418A6F092217602941A4B0DF984CFC574113FC258A2B612941B3077C323BFC5741C0C4A54F02612941E029FA4139FC5741BA2D72157A5F2941385C4A253FFC5741BE5BE8EA2C5F2941A157C1EA3FFC57415A3C9930295F2941970E538641FC5741C376252C165F2941FBE12A5E41FC5741');
93    -- servitude ligne
94    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (2, 'Route Ciculation', 'Boulevard emile combe', 150, '01020000206A080000070000005E5D4B0D1B6129417B5009C9EAFC574101920D86DB6129413F3D7F58DEFC574142A83FA11F62294126C5744AD0FC574144300EBA4B622941A5334BE1C0FC5741B0F0FE3F58622941458196F9B3FC57411545A2B2236229415BE76EE38DFC5741CAC9F7CA76612941DFBF6BE938FC5741');
95    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (1, 'Route circulation', 'Boulevard des lices', 100, '01020000206A080000050000005C9CA031C35C294129C323D930FC57418446B570845D2941968ABDCB34FC57411C27C5E0C85D2941E9E359B739FC57411ABC232F295F29412437DFEF3EFC57414F2E9E55706129413C507D1736FC5741');
96    INSERT INTO servitude_ligne (servitude_ligne, libelle, observation, perimetre, geom) VALUES (3, 'Voie ferrée', 'Servitude de voie ferrée', 300, '01020000206A0800000400000068013DA385612941179A391819FD574128A62FDFF46129419EB6C788ECFC5741A74D5B766A622941627F7270C3FC5741D016D9546C64294123573E5A3DFC5741');
97    --           point
98    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (3, 'MH ', 'Primatiale Sainte Trophime ', 500, '01010000206A080000F2386B3CB95E29414E778FC462FC5741');
99    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (2, 'MH', 'Théâtre antique', 500, '01010000206A08000099418DC6C25F2941EA6E6CB55EFC5741');
100    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (1, 'MH', 'Cloitre Ste Trophime', 500, '01010000206A08000086CA96F5BD5E294165C1F81F5BFC5741');
101    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (4, 'MH', 'Eglise de la Major', 500, '01010000206A0800004D3C8EE78F61294109377C7D7FFC5741');
102    INSERT INTO servitude_point (servitude_point, libelle, observation, perimetre, geom) VALUES (5, 'MH', 'Eglise Saint Julien', 500, '01010000206A080000377E0999805F2941D47520B9AFFC5741');
103    --           surfacique
104    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (1, 'Arenes ', 'Monument historique - contactez les monuments historiques ', 500, '01030000206A08000001000000130000005A6A80843E602941343CB55193FC57414E84C52B60602941C488F4F193FC5741DDBB5EA08B602941A35C13DF92FC5741BAA42723AC602941BC90C0EF8FFC5741B8E9F275D460294180868EA187FC5741E21C4F02E16029412231FDCA7FFC57413678479BD7602941E3EEB6D679FC5741988435C7C2602941560EE4EE74FC5741FAB12FF09E60294104285CD271FC5741A91E813971602941CB2554D770FC5741EE5CC7884760294189B42EB471FC5741B1EE0170236029413CF65D6275FC5741E43183C7076029414E5C57617AFC5741986E78BFF35F294173CFC25D80FC5741F848AB4DF45F29418545C97B87FC57413E5FEB510060294129FF2A568DFC5741CAF5AABC1E6029416A62E5D591FC5741192186954360294183CC421694FC57415A6A80843E602941343CB55193FC5741');
105    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (3, 'Zone innondable', 'A preciser dans l arrete', NULL, '01030000206A080000010000001B0000001D8BDB44D05B29410E140F4A90FC57413FABCA081D5C294119E9B02582FC57415081EE7C295C2941335907D97AFC5741EA9432E5345C2941153021E879FC5741E17FBD674A5C29411E660C6F75FC574137A521217A5C29416D0B1DFA79FC574195A9C967845C2941AF757CA67AFC5741C8FCD0A8E25C29411B815E377BFC5741383B017DEE5C2941BFE5C6F87CFC57419D172A20445D2941B1FACD4C7DFC5741743B80A24F5D294141F5D1FE80FC5741242DFAB85A5D2941F40F89FE81FC57418C9996D7E55D2941A9FC416E83FC5741188F28ECF75D29419D562F0484FC5741F52BE81BF95D2941E6EEDBD191FC5741FA99A19DFB5D29412DE5835D92FC5741DDC9B4B3195E29412BCAF6A093FC574158BB3B881E5E29414BB195149BFC5741407C762C205E2941016DAB9F9BFC5741AEB8A5723D5E2941BF5CC88F9CFC574112D6B4A3365E29415509EC5AA6FC5741B6F075011E5E29413B897AC5A8FC5741AC522FC20A5E29416789FC03AAFC5741751C5151C05D2941960F190AAAFC5741E2290EB7905D294177865006AAFC5741C0CE4B1C815C2941BEE5BB6F9EFC57411D8BDB44D05B29410E140F4A90FC5741');
106    INSERT INTO servitude_surfacique (servitude_surfacique, libelle, observation, perimetre, geom) VALUES (2, 'DPR', 'Droit de preemption', 0, '01030000206A08000001000000170000006AB5C544D3582941C9B208923DFC574152AE3F27645A294130BB53506CFC574159D2E61FC05B2941684ECFD38BFC57417EF69CE1E15B2941FE8BDA1691FC574140F46C54895C2941439125759EFC5741D90A8AE28C5E29417E1B0A59B5FC57418638E91F905F2941CEBF58DFCCFC5741B9CA0EABF45F29415ED711F8E0FC57419E0056458A612941A57151B4DDFC57410B8F03F5C5612941F3000DAFD8FC57417B22D5A7D46129416F14018CD3FC57417A5FE3BE2862294138168898B8FC574144572587096229412C8C501D8FFC574191DD1685C9612941D38572776FFC574173E7AC39606129415CD7E54839FC574163AE2C84315F29414AAA35E640FC5741BEF5140EB95D2941C035592F3BFC5741D292003C6A5D29413AF9E53C36FC57419258827AD25B294161B2AF4E31FC5741D5D9F3D97B5A294112524D4B1BFC5741FFDA084E605A29419820615C1AFC574137247DDD475A2941A2228D971BFC57416AB5C544D3582941C9B208923DFC5741');
107    
108    -- seq
109    SELECT pg_catalog.setval('servitude_surfacique_seq', 4, true);
110    SELECT pg_catalog.setval('servitude_ligne_seq', 4, true);
111    SELECT pg_catalog.setval('servitude_point_seq', 6, true);
112    SELECT pg_catalog.setval('parcelle_lot_seq', 3, true);
113    
 -- insertion de section AM et AL  
 INSERT INTO section (section, commune, geom)  
 VALUES ('13004AL', '13004', '0106000020AB6B0000010000000103000000010000007D0000001E2D0B36DAF62741C0EB7EEBCD3E034132D3EF21E6F6274160F56D10CB3E0341EEC57ADCD4F627410061B77A4F3C0341CA5BB075E1F62741E0BDA4294E3C0341C2B84F6805F7274140DC47CC4E3C0341FA2690E70DF72741805372F64E3C0341746EFD9C2DF72741006EB9CB4F3C03412FE13CE431F7274100A6BCFF4F3C03414095C1D33EF7274140C52536503C03413A6C84E373F7274160FFED56513C03418C60B81D98F7274100E78E24523C0341D93A6E6DB0F72741E00F4BC3523C034163429ECFDEF72741207840F0533C0341F20A5E690BF82741205931D4403C0341B994280C31F82741E0FD7A84313C03419116789556F8274140C49BF6213C0341CEA15F577CF82741802E92C6113C03419A0CD413A2F82741E0D6A24E023C034107D5C8DFC7F8274160663F85F23B0341C80F1112EEF82741A03946D3E23B0341CA31DBB413F9274120B58883D33B03413C5DFC0220F92741A04D7B82CE3B0341BB6E807639F927418041C8E2C33B0341979358C941F9274160605572C03B03418A16EB325FF9274100F14B7FB43B034179D7203285F9274140AA698EA43B0341D8D5C9FDAAF927410029C768953B034102D4FC2AD1F9274100F827A2853B0341397DD0CBE3F9274160EC29DA7D3B0341811961DCEDF92741401CDB80793B0341AF94CA18FAF92741A0F10944583B034132A004C0E3F9274140F36B908C3A03416BDFE8651CF827414001EB77762A0341593FBAE107F8274140EC7917C6290341CEC81080F5F727414040D53CD529034126A762A359F62741A07E57288D2A0341C0249EE94DF62741C03EBC38872A03417B8008DE50F627410002B846682A0341E27D000547F62741C00CD913582A034128D0739605F62741A08550FA052A0341DC0E22A308F62741A0F3D254B22903416BBE55B1E5F52741E06857B0A429034166A6271ADFF5274160347565EE2903417F74FBA7D6F52741C0FACB1F4C2A034196649565CFF5274120FFD3D99A2A0341D9C7B028C7F5274140E5B306F42A0341F86D9ED0C2F5274160DE887C232B034122F9E511B6F5274100B176E0AD2B034140E03C18B0F527418041F6F6EE2B03412C9A63A7A7F52741002B4BD0492C0341CA8FB9FE98F52741C0ECCF57E72C0341DBDC8CFA93F5274100CCE7BD1D2D0341006A529586F5274120591B08AE2D03416CD3855E7BF52741C0DD97F3262E0341DC7D322B77F52741A0AAA56A542E0341B673385170F5274180E22BAD9E2E0341A5D85EF064F5274100EBA9FD192F034180480A075CF52741C07811D37A2F0341DB7639384DF52741401F5B631D3003410881AD1446F5274180CC66CC6B30034193C6D2E544F52741E0D8E5CC7830034185420F3735F52741003C7CBC23310341FA6F08622FF5274100E9A11163310341B8C5B0E528F5274180C2700FAA310341EC5CFDFB1FF52741203C95B10B32034140466E5D27F527410043F52E1532034161B3D6831FF52741007E31E469320341689D379F1AF52741401A50749E3203412C41A6E112F5274100A048F49432034131E6244E10F52741C0855DA1B432034134650A3105F52741A0AD32502D330341E26F772EF9F4274100F6603FAF330341C8CE8E84EBF42741E04B1F2B44340341DAD35FD3E8F42741201F169A61340341D5C90E49D7F42741008E06C2213503418CC621E4C8F427414089ECA7BC35034188CF10C0BFF427412011EFC222360341C798A411BDF42741E0FD4C50453603417E72C143B7F42741C03B517B963603416D8F31A0B0F42741C01C4E0FFB360341B50F86C9ABF4274180168CE548370341C40D4579A8F42741C0A3B48A8837034147E3CDFDA3F42741A0F3209FEE370341D968557DA3F4274100C7C4F505380341DCEEA5CBA1F42741803494E25B3803416733957AA0F4274100F884F29C38034112D185E69FF42741A065147BBD380341EF1A1A5D9FF4274140604C7CFE380341D21447EC9EF4274160AC04A741390341DCA67D6B9FF42741003E49F78539034178BDEA749FF42741800DFBB98739034171B4D83DA0F42741A065D791C7390341E9C0A06FA0F42741E03C22BBD539034106D846A1A1F4274120918B951B3A0341EF208A4DA3F4274100F92F0C6D3A0341E52C8EFBA3F427410012E94C833A0341DDEAF219A5F4274120919129A53A03413DF3A6F0A5F4274120C5C7FABB3A03410C320AAEA7F42741202FC123DD3A03414C33503FABF42741003B4B101B3B03412811F0F3ACF4274180A71006393B0341A9E7B789B3F4274140738B38A43B0341C76315ADB4F42741601D6349BB3B0341ADA4AB82A6F4274160D39BC2B53B034147C7C438A6F42741C0CE17DDD03B03410ABFABB3A8F427410071A08A3F3C03417FDE55FFB2F42741C003EA3C403C034155B9EBC9B7F42741201720EA863C03410E517323B9F4274180F42682973C0341F54C2DCFC1F42741E0D9B22AFF3C0341FD7C751ADCF42741C0C8E141DC3D0341B3B8150B04F52741C09B7253EB3E0341587D319E1FF52741A0D4328BA63F0341BD4EF18A58F5274100142317574003415C50FA6D79F5274140B59DCEBC400341F41CD3BCBAF52741209E28ACFA41034110E9524EC8F5274180FE10FD6D420341B2730E69D2F5274140D7E9BBC24203411C008777DCF5274140C5B9D3B7420341D8156A3BCDF52741E000C048E53E0341C6E6E03AD8F52741E077AD8FE43E0341FD6BADB5D8F52741C025B0A7E43E0341BAA4AC3AE1F52741402FF975E33E034112B62E0A9FF6274120FAF740D33E03411E2D0B36DAF62741C0EB7EEBCD3E0341');  
 INSERT INTO section (section, commune, geom)  
 VALUES ('13004AM', '13004', '0106000020AB6B00000100000001030000000100000055000000FD6BADB5D8F52741C025B0A7E43E0341C6E6E03AD8F52741E077AD8FE43E0341D8156A3BCDF52741E000C048E53E03411C008777DCF5274140C5B9D3B74203410F62E458E8F5274180CA4B7EAA420341D4CAD76E22F6274120EDD2EF91430341EC094ABB42F62741A0AEA3961244034102D5A079AAF6274140A0FC7DB0450341BC06ABEAA0F6274100D9AD41B1450341DB815E9FA2F627418082CBD2B845034153E8FD11F5F6274100887C370A470341F776272B0FF72741A0F165E575470341DB33E6211AF72741A086165C9E470341DEBC57D725F7274120011315CF470341A365750334F72741205714EED0470341446B9DBA20F72741C00A9A137E4603417F8C6FC41AF727414012A095FA4503410BB47CE954F72741E043EA05EE45034198DF9AE159F92741803379F7C7460341F0A73D4548FA2741E02ABEB82A4703419490DEB8D8FA2741E0A9258B6447034184828A2FD9FA2741A054615C57470341B19FFEFA3EFB2741808DF484804703412012ADEF3FFB27416097A7D28D47034166DFDC3141FB2741A0B43E6B8E4703417F5D6D9C51FB2741E03819B18D470341DD69684B65FB274100E28E99504803412D8E2BC86EFB274120522C01AF4803416EBFAB9EA5FB2741406748F1B148034158F640EB7BFC2741404C4F77C54803419324A70CBDFC2741E08B84C7CA4803418EB776BFBCFC2741C0B7EA4CAA48034138628E48A7FC27416040B4F2C646034172192129A1FC2741A00228C72D4603416AA5D7B28EFC274140DA79D35E4403415E32199685FC2741A01B7C977D430341359DCD8678FC2741203A71304842034184982F4571FC2741E0A0D182A04103414983B5C45FFC2741C0A231EE08400341E2D4A62347FC274140A1F8C0CF3D0341C83EC3AE44FC274140840EA9963D0341659FD1392AFC2741C01D35D64B3B03416614EC950DFC2741405FA9CDD63803414242963FE6FB27414064724DF238034168628BFFDAFB2741A02276E5F9380341BAF8C54ED0FB274120AA1296013903418557C20692FB274140B7656B2E3903417462FCC262FB2741000CDE724F3903419C50EAD459FB274140AA38E677390341725F31AAF2F92741809101CC813A034132A004C0E3F9274140F36B908C3A0341AF94CA18FAF92741A0F10944583B0341811961DCEDF92741401CDB80793B0341397DD0CBE3F9274160EC29DA7D3B034102D4FC2AD1F9274100F827A2853B0341D8D5C9FDAAF927410029C768953B034179D7203285F9274140AA698EA43B03418A16EB325FF9274100F14B7FB43B0341979358C941F9274160605572C03B0341BB6E807639F927418041C8E2C33B03413C5DFC0220F92741A04D7B82CE3B0341CA31DBB413F9274120B58883D33B0341C80F1112EEF82741A03946D3E23B034107D5C8DFC7F8274160663F85F23B03419A0CD413A2F82741E0D6A24E023C0341CEA15F577CF82741802E92C6113C03419116789556F8274140C49BF6213C0341B994280C31F82741E0FD7A84313C0341F20A5E690BF82741205931D4403C034163429ECFDEF72741207840F0533C0341D93A6E6DB0F72741E00F4BC3523C03418C60B81D98F7274100E78E24523C03413A6C84E373F7274160FFED56513C03414095C1D33EF7274140C52536503C03412FE13CE431F7274100A6BCFF4F3C0341746EFD9C2DF72741006EB9CB4F3C0341FA2690E70DF72741805372F64E3C0341C2B84F6805F7274140DC47CC4E3C0341CA5BB075E1F62741E0BDA4294E3C0341EEC57ADCD4F627410061B77A4F3C034132D3EF21E6F6274160F56D10CB3E03411E2D0B36DAF62741C0EB7EEBCD3E034112B62E0A9FF6274120FAF740D33E0341BAA4AC3AE1F52741402FF975E33E0341FD6BADB5D8F52741C025B0A7E43E0341');  
   
 -- insertion de parcelle AM0094, 95,96  
 INSERT INTO parcelle (commune, surface, parcelle, geom)  
 VALUES ( '13004', 652.000000000000000, 'AM0095', '0106000020AB6B00000100000001030000000100000005000000F20A5E690BF82741205931D4403C0341DFCB7EE012F82741E0C8948F523D034120CEDB5A38F8274160F01120423D0341B994280C31F82741E0FD7A84313C0341F20A5E690BF82741205931D4403C0341');  
 INSERT INTO parcelle (commune, surface, parcelle, geom)  
 VALUES ('13004', 791.000000000000000, 'AM0096','0106000020AB6B00000100000001030000000100000008000000F20A5E690BF82741205931D4403C034163429ECFDEF72741207840F0533C03411F5C1132E9F72741007E3698653D03410C8DBC02EAF7274160CC18697E3D03418247F35707F8274160BC1538723D034148FB24E406F82741802566D0573D0341DFCB7EE012F82741E0C8948F523D0341F20A5E690BF82741205931D4403C0341');  
 INSERT INTO parcelle (commune, surface, parcelle, geom)  
 VALUES ('13004', 648.000000000000000, 'AM0094', '0106000020AB6B000001000000010300000001000000050000009116789556F8274140C49BF6213C0341B994280C31F82741E0FD7A84313C034120CEDB5A38F8274160F01120423D0341B1C53F555EF8274180FF4A8B313D03419116789556F8274140C49BF6213C0341');  
   
 -- insertion de batiment sur les parcelles  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5479, '02', '13004', '13004AM', '0106000020AB6B0000010000000103000000010000000600000056A57D9B52F82741E007CD3EB13C034198C264DC43F827418025F560B73C0341508CCC1544F8274180E6401AC03C034148947FAE44F82741606F6713CD3C0341B2BF1D1B53F82741C0017436C83C034156A57D9B52F82741E007CD3EB13C0341');  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5478, '02', '13004', '13004AM','0106000020AB6B00000100000001030000000100000005000000C256AC1346F82741C0FD0A37123D034118F1A16646F82741406E8C051B3D03416D40288B4CF827410068B77A183D0341677587384CF8274100CCF4F30E3D0341C256AC1346F82741C0FD0A37123D0341');  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5185, '01', '13004', '13004AM','0106000020AB6B00000100000001030000000100000007000000AA343EF725F82741809D5090A33C03413CB5793217F8274160B969E5AA3C034161C0597F1AF827416087B63D0E3D0341444BABF22AF8274160FBF498053D0341E66B1EFD28F8274180ACE6C2C23C03413A6BF30627F82741A0DA05FCC33C0341AA343EF725F82741809D5090A33C0341');  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5482, '02', '13004', '13004AM','0106000020AB6B00000100000001030000000100000005000000095BA15DF6F72741C0064E9BF93C0341BE75B947EEF72741E095A817FE3C034106CF578FEEF72741E0270D4C093D0341BABDFDA4F6F7274100BA015F053D0341095BA15DF6F72741C0064E9BF93C0341');  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5196, '01', '13004', '13004AM',  '0106000020AB6B0000010000000103000000010000000B000000B08DB0383DF82741C0EC0858C33C0341D9785ED63FF827410053981C1E3D034118F1A16646F82741406E8C051B3D0341C256AC1346F82741C0FD0A37123D0341677587384CF8274100CCF4F30E3D03416D40288B4CF827410068B77A183D03411032D52055F82741C06A6868143D0341B2BF1D1B53F82741C0017436C83C034148947FAE44F82741606F6713CD3C0341508CCC1544F8274180E6401AC03C0341B08DB0383DF82741C0EC0858C33C0341');  
 INSERT INTO batiment (batiment, bati, commune, section, geom)  
 VALUES (5174, '01', '13004', '13004AM', '0106000020AB6B000001000000010300000001000000090000008858397EF2F7274160369ECC2D3D0341563B3856F3F72741400249D1413D03416433B5170AF8274100C0E51D353D03410A8BA7F907F827412031FD50F13C0341095BA15DF6F72741C0064E9BF93C0341BABDFDA4F6F7274100BA015F053D034106CF578FEEF72741E0270D4C093D0341BCBB97F3EFF727414041F0152F3D03418858397EF2F7274160369ECC2D3D0341');  
Legend:
Removed from v.3  
changed lines
  Added in v.268
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26