ponceta

CREATE TABLE IF NOT EXISTS electricite_new.candelabres
(
    id integer,
    id_obrv integer,
    id_sit integer,
    model character varying(50),
    number character varying(100),
    deployment_status character varying(50),
    maintenance_status character varying(50),
    construction_date timestamp without time zone,

ponceta

SELECT nspname AS schema_name, 
       pg_size_pretty(sum(pg_total_relation_size(pg_class.oid))) AS total_size
FROM pg_class
JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
GROUP BY nspname
ORDER BY sum(pg_total_relation_size(pg_class.oid)) DESC;

ponceta

#!/usr/bin/env python3

import argparse

from qgis.core import QgsProject, QgsLayoutExporter, QgsApplication

if __name__ == "__main__":

    parser = argparse.ArgumentParser(description='QGIS PDF generator')
    parser.add_argument('project_path', type=str,

ponceta

pg_restore: connecting to database for restore
pg_restore: creating SCHEMA "qgep_import"
pg_restore: creating SCHEMA "qgep_network"
pg_restore: creating SCHEMA "qgep_od"
pg_restore: creating SCHEMA "qgep_swmm"
pg_restore: creating SCHEMA "qgep_sys"
pg_restore: creating SCHEMA "qgep_vl"
pg_restore: creating EXTENSION "hstore"
pg_restore: creating COMMENT "EXTENSION hstore"
pg_restore: creating EXTENSION "postgis"

ponceta

C:\Program Files\pgAdmin 4\v6\runtime\pg_restore.exe --host "monserveur.pully.ch" --port "5432" --username "postgres" --no-password --role "postgres" --dbname "qwat_1.3.6_demo" --jobs "1" --verbose "pathtomybackupfile\\qwat_v1.3.6_data_and_structure_sample.backup"
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA "qwat_dr"
pg_restore: creating SCHEMA "qwat_od"
pg_restore: creating SCHEMA "qwat_sigip"
pg_restore: creating SCHEMA "qwat_sys"
pg_restore: creating SCHEMA "qwat_vl"
pg_restore: creating EXTENSION "hstore"
pg_restore: creating COMMENT "EXTENSION hstore"
pg_restore: creating EXTENSION "postgis"

ponceta

C:\Program Files\pgAdmin 4\v6\runtime\pg_restore.exe --host "monserveur.pully.ch" --port "5432" --username "postgres" --no-password --role "postgres" --dbname "qgep_1.5.5_demo" --jobs "1" --verbose "pathtomybackup\\qgep_1.5.5_structure_and_demo_data.backup"
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA "qgep_import"
pg_restore: creating SCHEMA "qgep_network"
pg_restore: creating SCHEMA "qgep_od"
pg_restore: creating SCHEMA "qgep_swmm"
pg_restore: creating SCHEMA "qgep_sys"
pg_restore: creating SCHEMA "qgep_vl"
pg_restore: creating EXTENSION "hstore"
pg_restore: creating COMMENT "EXTENSION hstore"

ponceta

ponceta

https://dev2.sigip.ch/?lang=fr&tree_group_layers_grp_cadastre=&baselayer_ref=grp_background_asitvd.fond_couleur&baselayer_opacity=21&map_x=2540926&map_y=1151535&map_zoom=11&rl_features=Fl(55sfh-frtyQf*g-w4-tAy!ObX6_wV4_~n*PE%2520100'c*%25233F5BA9'a*0'o*0.2'm*false'b*false's*10'k*2)l(eUp!3Ot-uBGnNUJc-~n*PE%2520100'c*%25233F5BA9'a*0'o*0.2'm*false'b*false's*10'k*2)l(ACId-gLVz_-p*B6-K~n*PE%252060'c*%2523009D57'a*0'o*0.2'm*false'b*false's*10'k*2)l(fCyBbMW~n*PE%252060'c*%2523009D57'a*0'o*0.2'm*false'b*false's*10'k*2)l(g*a-QJcGVKF~n*PE%2520100'c*%25233F5BA9'a*0'o*0.2'm*false'b*false's*10'k*2)l(kHeB7AAJc-~n*PE%2520100'c*%25233F5BA9'a*0'o*0.2'm*false'b*false's*10'k*2)a(JJ.c-X..d-~r*true'n*Chambre'c*%2523000000'a*0'o*0.2'm*false'b*false's*10'k*2)a(jP1D.K5-..L~r*true'n*Chambre'c*%2523000000'a*0'o*0.2'm*false'b*false's*10'k*2)a(gq!fK.u_h*..t_~r*true'n*Chambre'c*%2523000000'a*0'o*0.2'm*false'b*false's*10'k*2)l(1k!tKyHSb!OuB.sMRqJb_~n*PE%2520100'c*%25233F5BA9'a*0'o*0.2'm*false'b*false's*10'k*2)a(.B.CP..D~r*true'n*Chambre'c

ponceta

--Ajout du matériau pour le radier

ALTER TABLE qgep_od.wastewater_node
ADD COLUMN pully_bottom_material integer;

CREATE TABLE qgep_vl.pully_node_bottom_material () INHERITS (qgep_sys.value_list_base);
ALTER TABLE qgep_vl.pully_node_bottom_material ADD CONSTRAINT pkey_qgep_vl_pully_node_bottom_material_code PRIMARY KEY (code);
 INSERT INTO qgep_vl.pully_node_bottom_material (code, vsacode, value_en, value_de, value_fr, value_it, value_ro, abbr_en, abbr_de, abbr_fr, abbr_it, abbr_ro, active) VALUES (4540,4540,'other','andere','autre', 'altro', 'altul', '', '', '', '', '', 'true');
 INSERT INTO qgep_vl.pully_node_bottom_material (code, vsacode, value_en, value_de, value_fr, value_it, value_ro, abbr_en, abbr_de, abbr_fr, abbr_it, abbr_ro, active) VALUES (4541,4541,'concrete','Beton','beton', 'zzz_Beton', 'beton', '', '', '', '', '', 'true');
 INSERT INTO qgep_vl.pully_node_bottom_material (code, vsacode, value_en, value_de, value_fr, value_it, value_ro, abbr_en, abbr_de, abbr_fr, abbr_it, abbr_ro, active) VALUE

ponceta

-- View: qgep_od.vw_qgep_wastewater_structure2

-- DROP VIEW qgep_od.vw_qgep_wastewater_structure2;

CREATE OR REPLACE VIEW qgep_od.vw_qgep_wastewater_structure2 AS 
 SELECT ws.identifier,
        CASE
            WHEN ma.obj_id IS NOT NULL THEN 'manhole'::text
            WHEN ss.obj_id IS NOT NULL THEN 'special_structure'::text
            WHEN dp.obj_id IS NOT NULL THEN 'discharge_point'::text