/[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 139 - (show annotations)
Sat Sep 24 09:52:03 2011 UTC (13 years, 4 months ago) by fraynaud
File size: 9279 byte(s)
correction erreur /app/js



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 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', 'saisie surfacique servitude', '', '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');
8 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 dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
9 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', 'saisie 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');
10 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 dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
11 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 dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
12 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 dossier order by geom,dossier', '', 'dossier', 'geom', '../scr/dashboard.php');
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 (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');
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 (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');
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 (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');
16
17 ALTER SEQUENCE om_etat_seq RESTART WITH 11;
18
19 -- widget
20
21 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');
22 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');
23 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''>
24 <h2 id=''h_f5089b722555454d1872b91f52beafd4''><a href=''http://www.tameteo.com/'' title=''Météo''>Météo</a></h2>
25 <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>
26 </div>', '3');
27 INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (5, 1, 'Mon horoscope', '#', '<!--DEBUT CODE ASTROO-->
28
29 <!--debut code perso-->
30
31 <iframe width=''232'' height=''302'' marginheight=''0'' marginwidth=''0'' frameborder=''0'' align=''center'' src=''http://www.astroo.com/horoscope.htm'' name=''astroo'' allowtransparency=''true''>
32
33 <!--fin code perso-->
34
35 <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>
36
37 <noscript><a href=''http://www.astroo.com/horoscope.php'' target=''_blank''>horoscope</a></noscript>
38
39 <!--FIN CODE ASTROO-->', '3');
40 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');
41 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');
42 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');
43 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''>
44 $.ajax({
45 type: ''GET'',
46 url:''../app/tab_wid.php'',
47 cache: false,
48 data: ''&obj=dossierlimite'',
49 success: function(html){
50 $(''#aff3'').replaceWith(html);
51 }
52 });
53 </script><div id=''aff3''></div>', '3');
54 INSERT INTO om_widget (om_widget, om_collectivite, libelle, lien, texte, om_profil) VALUES (3, 1, 'dossier notifié / dossiers', '#', '<script type=''text/javascript''>
55 $.ajax({
56 type: ''GET'',
57 url:''../app/jquerytest.php'',
58 cache: false,
59 data: '''',
60 success: function(html){
61 $(''#aff3'').replaceWith(html);
62 }
63 });
64 </script><div id=''aff3''></div>', '3');
65
66 ALTER SEQUENCE om_etat_seq RESTART WITH 10;

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26