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
The QGIS expression is designed to split a string (found in the "Code_ouvra" field) by underscores ('_'), and then recombine the first three elements of the resulting array into a new string, again separated by underscores. | |
```qgis | |
array_to_string(array_slice(string_to_array("Code_ouvra", '_'), 0, 2), '_') | |
``` | |
This expression does the following: | |
1. `string_to_array("Code_ouvra", '_')`: Splits the "Code_ouvra" string into an array using '_' as the separator. | |
2. `array_slice(..., 0, 2)`: Takes a slice of the array from the first element (index 0) to the third element (index 2). | |
3. `array_to_string(..., '_')`: Converts the sliced array back into a string, with elements separated by '_'. |
for %X in (*.shp) do ogr2ogr -skipfailures -clipsrc | |
c:\data\PhiladelphiaBaseLayers\clipFeature\city_limits.shp | |
c:\data\PhiladelphiaBaseLayers\clipped\%X | |
c:\data\PhiladelphiaBaseLayers\%X |
Initial Inquiry: "Hi, thank you for reaching out. I've read your requirements and I'm confident I can help with your QlikSense dashboard. Let's discuss more about your project so I can better understand your needs." | |
Discussing Details: "Thanks for sharing these details. It helps me understand your project better. Could you also provide some information about the specific KPIs you're interested in?" | |
Project Timeline: "Based on your requirements, I anticipate this project will take approximately X days to complete. I'll be able to give a more accurate estimate once we finalize the project details." | |
Data Confidentiality: "Rest assured, your data's security is my top priority. I adhere to strict data privacy protocols and will only use your data for this specific project." | |
Project Updates: "I wanted to update you on the project. The data modeling is complete and I've started working on the dashboard. I'll keep you posted with further updates." | |
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='23-0241ACA_LOT_7' AND pid <> pg_backend_pid(); | |
create database "23-0242ACA_LOT_8" template "23-0241ACA_LOT_7"; |
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 |
# 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 |
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 |
-- 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 ) |
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
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() |