This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |
exp(url:https://www.postgresqltutorial.com/postgresql-triggers/creating-first-trigger-postgresql/)
CREATE TABLE employee
(emp_id int4,
employee_name varchar(25),
department_id int4,
salary numeric(7,2));
CREATE TABLE emp_salary_history
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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 ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |