Skip to content

Instantly share code, notes, and snippets.

View pigreco's full-sized avatar
😎

Salvatore Fiandaca pigreco

😎
76 followers · 4 following
View GitHub Profile
@pigreco
pigreco / comuni_point_invalid_istat2024.csv
Created April 5, 2024 14:36
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 4 columns, instead of 3. in line 8.
PRO_COM,COMUNE,GEOS_GetLastWarningMsg(),coord_punto
72001,Acquaviva delle Fonti,Ring Self-intersection at or near point 1158442.6376999998 4556057.8583000004,POINT(1158442.6377 4556057.8583)
87009,Bronte,Ring Self-intersection at or near point 1028304.0548 4195170.1164999995,POINT(1028304.0548 4195170.1165)
24018,Caldogno,Self-intersection at or near point 695843.26275384938 5054095.577508538,POINT(695843.262754 5054095.577509)
90035,La Maddalena,Ring Self-intersection at or near point 528108.51559999958 4571486.8072999995,POINT(528108.5156 4571486.8073)
29041,Rovigo,Self-intersection at or near point 715837.53051888163 4995712.1190747796,POINT(715837.530519 4995712.119075)
72037,Rutigliano,Ring Self-intersection at or near point 1177064.5067999996 4571209.1926000006,POINT(1177064.5068 4571209.1926)
72040,Sannicandro di Bari,Ring Self-intersection at or near point 1154968.4281000001 4561653.8167000003,POINT(1154968.4281 4561653.8167)
81019,Santa Ninfa,Ring Self-intersection at or near point 841730.11459999997
@pigreco
pigreco / qgis_sustaining_member.csv
Created March 27, 2024 18:40
https://changelog.qgis.org/en/qgis/members/world-map/
name period year Flagship annual amaunt
Felt March 1, 2024 - Feb. 28, 2025 2025 Flagship 27000 27000
QGIS user group Denmark March 1, 2024 - Feb. 28, 2025 2025 Large 9000 20000
QGIS user group Switzerland March 1, 2024 - Feb. 28, 2025 2025 Large 9000 9000
QGIS user group Sweden March 1, 2024 - Feb. 28, 2025 2025 Large 9000 9000
QGIS Gebruikersgroep Nederland Jan. 1, 2024 - Feb. 28, 2025 2025 Large 9000 9000
QGIS user group Germany March 1, 2024 - Feb. 28, 2025 2025 Large 9000 9000
OPENGIS.ch GmbH March 1, 2024 - Feb. 28, 2025 2025 Large 9000 9000
Land Vorarlberg March 1, 2024 - Feb. 28, 2025 2025 Large 9000 8000
GeoCat bv Jan. 1, 2024 - Feb. 28, 2025 2025 Medium 3000 3000
@pigreco
pigreco / changelog_qgis_200to336_data.csv
Created February 21, 2024 20:54
https://changelog.qgis.org/en/qgis/
nro DATE NAME VERSION CATEGORY DESCRIPTION ver
1 2013-09-08 Dufourt QGIS 2.0.0 User Interface New icon theme 2.x
2 2013-09-08 Dufourt QGIS 2.0.0 User Interface Side tabs, collapsable groups 2.x
3 2013-09-08 Dufourt QGIS 2.0.0 User Interface Soft notifications 2.x
4 2013-09-08 Dufourt QGIS 2.0.0 User Interface Application custom font and Qt stylesheet 2.x
5 2013-09-08 Dufourt QGIS 2.0.0 User Interface Live color chooser dialogs and buttons 2.x
6 2013-09-08 Dufourt QGIS 2.0.0 User Interface SVG Annotations 2.x
7 2013-09-08 Dufourt QGIS 2.0.0 User Interface Drag and drop form builder 2.x
8 2013-09-08 Dufourt QGIS 2.0.0 User Interface Default action tool 2.x
9 2013-09-08 Dufourt QGIS 2.0.0 Symbology Data defined properties 2.x
@pigreco
pigreco / changelog_qgis_200to334_data.csv
Created November 3, 2023 17:57
https://changelog.qgis.org/en/qgis/version/3.34/
nro DATE NAME VERSION CATEGORY DESCRIPTION ver
1 2013-09-08 Dufourt QGIS 2.0.0 User Interface New icon theme 2.x
2 2013-09-08 Dufourt QGIS 2.0.0 User Interface Side tabs, collapsable groups 2.x
3 2013-09-08 Dufourt QGIS 2.0.0 User Interface Soft notifications 2.x
4 2013-09-08 Dufourt QGIS 2.0.0 User Interface Application custom font and Qt stylesheet 2.x
5 2013-09-08 Dufourt QGIS 2.0.0 User Interface Live color chooser dialogs and buttons 2.x
6 2013-09-08 Dufourt QGIS 2.0.0 User Interface SVG Annotations 2.x
7 2013-09-08 Dufourt QGIS 2.0.0 User Interface Drag and drop form builder 2.x
8 2013-09-08 Dufourt QGIS 2.0.0 User Interface Default action tool 2.x
9 2013-09-08 Dufourt QGIS 2.0.0 Symbology Data defined properties 2.x
@pigreco
pigreco / Get_Pdf_N_Pages.py
Created September 13, 2023 16:57
Funzione personalizzate per field clac by Giulio
# Korto19 2023
from qgis.core import *
from qgis.gui import *
from PyPDF2 import PdfReader
@qgsfunction(group='HfcQGIS',referenced_columns=[])
def Get_Pdf_N_Pages(pdfpath):
"""
Restituisce il numero di pagine di un pdf dando il percorso
<h2>Example usage:</h2>
@pigreco
pigreco / notable_bug_fixed_36to332.csv
Created July 2, 2023 08:27
https://www.qgis.org/en/site/forusers/visualchangelog332/index.html#notable-fixes
data version developer nroBugsFixes funded
2019-02-22 QGIS 3.6 Alessandro Pasotti 28 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Alexander Bruy 27 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Jürgen Fischer 20 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Peter Petrik 8 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Julien Cabieces 9 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Loïc Bartoletti 5 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Victor Olaya 10 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Even Rouault 6 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Martin Dobias 8 This feature was funded byQGIS user group Germany
@pigreco
pigreco / changelog_qgis_200to332_data.csv
Created June 24, 2023 10:03
https://changelog.qgis.org/en/qgis/
nro DATE NAME VERSION CATEGORY DESCRIPTION ver
1 2013-09-08 Dufourt QGIS 2.0.0 User Interface New icon theme 2.x
2 2013-09-08 Dufourt QGIS 2.0.0 User Interface Side tabs, collapsable groups 2.x
3 2013-09-08 Dufourt QGIS 2.0.0 User Interface Soft notifications 2.x
4 2013-09-08 Dufourt QGIS 2.0.0 User Interface Application custom font and Qt stylesheet 2.x
5 2013-09-08 Dufourt QGIS 2.0.0 User Interface Live color chooser dialogs and buttons 2.x
6 2013-09-08 Dufourt QGIS 2.0.0 User Interface SVG Annotations 2.x
7 2013-09-08 Dufourt QGIS 2.0.0 User Interface Drag and drop form builder 2.x
8 2013-09-08 Dufourt QGIS 2.0.0 User Interface Default action tool 2.x
9 2013-09-08 Dufourt QGIS 2.0.0 Symbology Data defined properties 2.x
@pigreco
pigreco / compilareGDALdev.md
Last active May 7, 2023 16:42
per compilare GDAL dev in linux

il git clone, lo farei a partire da una cartella tmp, da creaere dentro la home del tuo utente su linux

sudo apt install libgeos-dev

sudo apt-get install swig
sudo apt-get install build-essential
sudo apt-get install cmake
sudo apt-get install libproj-dev proj-data proj-bin unzip -y
sudo apt install curl &amp;&amp; sudo apt-get install libcurl4-openssl-dev
@pigreco
pigreco / notable_fixes_36to328.csv
Created February 11, 2023 18:51
https://www.qgis.org/en/site/forusers/visualchangelog326/index.html#notable-fixes
data version developer nroBugsFixes funded
2019-02-22 QGIS 3.6 Alessandro Pasotti 28 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Alexander Bruy 27 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Jürgen Fischer 20 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Peter Petrik 8 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Julien Cabieces 9 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Loïc Bartoletti 5 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Victor Olaya 10 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Even Rouault 6 This feature was funded byQGIS.ORG donors and sponsors
2019-02-22 QGIS 3.6 Martin Dobias 8 This feature was funded byQGIS user group Germany
@pigreco
pigreco / dimensions_distance.qml
Created November 20, 2022 14:10
<!DOCTYPE qgis PUBLIC 'http://mrcc.com/qgis.dtd' 'SYSTEM'>
<qgis minScale="100000000" symbologyReferenceScale="-1" labelsEnabled="0" simplifyAlgorithm="0" simplifyDrawingTol="1" simplifyDrawingHints="1" hasScaleBasedVisibilityFlag="0" simplifyLocal="1" readOnly="0" maxScale="0" version="3.28.1-Firenze" simplifyMaxScale="1" styleCategories="LayerConfiguration|Symbology|Labeling|Rendering|CustomProperties|GeometryOptions">
<flags>
<Identifiable>1</Identifiable>
<Removable>1</Removable>
<Searchable>1</Searchable>
<Private>0</Private>
</flags>
<renderer-v2 type="singleSymbol" referencescale="-1" symbollevels="0" forceraster="0" enableorderby="0">
<symbols>