CEZERT

mport datetime as dt
import json
import os
import contextily as cx
import folium
import geopandas as gp
import mapclassify
import matplotlib.pyplot as plt
import pandas as pd
import shapely.geometry as sg

CEZERT

# Connect Drive
```python
from __future__ import print_function

import os.path

from google.auth.transport.requests import Request
from google.oauth2.credentials import Credentials
from google_auth_oauthlib.flow import InstalledAppFlow
from googleapiclient.discovery import build

CEZERT

import sys
from PyQt5.QtWidgets import QApplication, QCheckBox, QTabWidget, QVBoxLayout, QWidget

class Window(QWidget):
    def __init__(self):
        super().__init__()
        self.setWindowTitle('QTabWidget exemple')
        self.resize(400, 150)

        # Create top level layout

CEZERT

-- traitement tables fusion pour éviter les doublons 
-- NON UTILISEE methode 1 : fonction trigger
-- NB : la comparaison ne fonctionne pas si les valeurs des attributs à comparer sont NULL
/*
--DROP FUNCTION terrain.verif_fusion_aff();
create or replace function terrain.verif_fusion_aff() returns opaque as $body$
begin
if NEW.geom  in ( select geom from terrain.fusion_aff ) 
AND NEW.lot  in ( select lot from terrain.fusion_aff )
AND NEW.etude  in ( select etude from terrain.fusion_aff )

CEZERT

exp(url:https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/)

CREATE 2 TABLES

CREATE TABLE employee
(emp_id int4,
employee_name varchar(25),
department_id int4,
salary numeric(7,2));

CREATE TABLE emp_salary_history

CEZERT

from qgis.core import *
from qgis.gui import *
from qgis.utils import *
from PyQt5.QtCore import *
from PyQt5.QtGui import *

app = QgsApplication([], True)
app.setPrefixPath("C:/Program Files/QGIS Brighton/apps/qgis", True)
app.initQgis()
canvas = QgsMapCanvas()

CEZERT

Code du fichier *.

profil.qrc

qrc profil.png

CEZERT

import os
from PyQt5 import uic
from PyQt5.QtWidgets import QWidget, QApplication, QProgressBar
from qgis.core import QgsProcessingAlgorithm
from PyQt5.QtCore import QTimer


os.chdir(r"S:\09-Production\CLIENTS\AIR LIQUIDE\21-0178 TOPO 3D ALFI NORD 2021\Travail\Dao\Outils de traitement\Configurations")

FORM_CLASS, _ = uic.loadUiType("alfi_nord_2022.ui")

CEZERT

# CSV to XLS python
import pandas as pd
import os
from tkinter import Tk, filedialog
import glob
from pathlib import Path

root = Tk()
root.withdraw()
root.attributes('-topmost', True)

CEZERT

-- reference_ef.ef_chantier definition

-- Drop table

-- DROP TABLE reference_ef.ef_chantier;

CREATE TABLE reference_ef.ef_chantier (
	ogc_fid serial4 NOT NULL,
	geom public.geometry(multipolygon, 2154) NULL,
	gml_parent varchar(254) NULL,