thbaumann

spaltenname = 'name'
anzahl_spaltenzeichen = 8 # wieviele zeichen soll fuer die spaltenueberschrift verwendet werden. bsp 8 
datentyp = QVariant.Double  # datentyp der zu erzeugenden Spalten

vectorLayer = iface.activeLayer()  # aktiver Layer
idx = vectorLayer.fields().indexOf(spaltenname)
values = vectorLayer.uniqueValues(idx)
#print(values)
provider = vectorLayer.dataProvider()

thbaumann

# Iterating over the input layer :
for m in municip.getFeatures():
    inh_center = m['EWZ'] 
    # 
    # central municipalites with 0 inhabitants must be excluded; the value of "center_pos" will be set to -1.
    if inh_center == 0:
        center_pos = -1
        dict = {m.fieldNameIndex('center_pos'):center_pos}
        municip.dataProvider().changeAttributeValues({m.id(): dict}) \
        # 

thbaumann

# coding: utf-8
from qgis.PyQt.QtCore import Qt
from qgis.gui import QgsMapTool
from qgis.utils import iface


class SendPointToolCoordinates(QgsMapTool):
    """ Enable to return coordinates from clic in a layer.
    """
    def __init__(self, canvas, layer):

thbaumann

--DROP TABLE testlayer_polygone;

CREATE TABLE testlayer_polygone
    (id NUMBER(20),
    name VARCHAR2(15) NOT NULL,
    geom "MDSYS"."SDO_GEOMETRY",
    CONSTRAINT testlayer_polygone_pk PRIMARY KEY (id)
  );
--select * from all_sdo_geom_metadata  WHERE table_name = upper('testlayer_polygone');
  

thbaumann

{
    "telemetry.enableTelemetry": false,
    "python.defaultInterpreterPath": "C:\\OSGeo4W64\\apps\\Python37\\python.exe",
    "window.zoomLevel": 0,
    "terminal.integrated.shell.windows": "C:\\Windows\\System32\\cmd.exe",
    "git.path": "Z:\\Programme\\Git\\bin\\git.exe",

    "launch":
    {
        // Use IntelliSense to learn about possible attributes.

thbaumann

if (
distance( 
overlay_nearest(
layer:='poligono',
expression:= $geometry )[0], $geometry) <
distance( 
overlay_nearest(
layer:='linea',
expression:= $geometry )[0], $geometry),overlay_nearest(
layer:='poligono',

thbaumann

A windows version inspired by this lovely gist: https://gist.github.com/AsgerPetersen/9ea79ae4139f4977c31dd6ede2297f90

Debugging QGIS 3.x python plugins on Windows 10 using VS Code

Plugin

In QGIS install the plugin debugvs.

Python dependencies

The debugvs plugin needs the python module ptvsd to function. This module is not installed by default.

thbaumann

1. Install ptvsd using the same Python interpreter Qgis uses. E.g. on Windows:

C:\OSGeo4W64\apps\Python37\python.exe -m pip install ptvsd==4.3.2 

2. Add a debug configuration to launch.json:

{
    "name": "Python: Remote Attach",

thbaumann

# for testing in QGIS console
style_name = 'Druckstufen'
layer=iface.activeLayer()
stylemanager = layer.styleManager()
current_style = stylemanager.currentStyle()
#print(curr_style)
# stil nur wechseln wenn nicht schon aktuell eingestellt
if style_name != current_style:
  stylemanager.setCurrentStyle(style_name)

thbaumann

Kategorisierter Stil per PyQGIS: größtenteils basierend auf: https://gis.stackexchange.com/a/382742/67477 
      
# Code für die QGIS Konsole:

styling_layer = iface.activeLayer()   # Hinweis: im Plugin self.iface.activeLayer()

spalten_name = 'DRUCKSTUFE'
rampen_name = 'Greens'

field_index = styling_layer.fields().indexFromName(spalten_name)