Skip to content

Instantly share code, notes, and snippets.

View agiudiceandrea's full-sized avatar

Andrea Giudiceandrea agiudiceandrea

View GitHub Profile
@agiudiceandrea
agiudiceandrea / geoccs_list.csv
Created May 19, 2018 17:11
GEOCCS fixed by PR #7009
COORD_REF_SYS_CODE COORD_REF_SYS_NAME
3822 TWD97
3887 IGRS
4000 MOLDREF99
4039 RGRDC 2005
4073 SREF98
4079 REGCAN95
4328 WGS 84 (geocentric)
4330 ITRF88 (geocentric)
4331 ITRF89 (geocentric)
andrea@andrea-VirtualBox:~$ apt list --installed | grep -i qgis
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
libqgis-3d3.14.1/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
libqgis-analysis3.14.1/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
libqgis-app3.14.1/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
libqgis-core3.14.1/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
libqgis-customwidgets/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
libqgis-gui3.14.1/bionic,now 1:3.14.1+28bionic amd64 [installato, automatico]
# -*- coding: utf-8 -*-
"""
***************************************************************************
RandomPointsPolygons.py
---------------------
Date : April 2014
Copyright : (C) 2014 by Alexander Bruy
Email : alexander dot bruy at gmail dot com
***************************************************************************
<location filename="../src/core/qgsunittypes.cpp" line="2527"/>
<source> rad</source>
<translation>rad</translation>
<location filename="../src/analysis/processing/qgsalgorithmcategorizeusingstyle.cpp" line="246"/>
<source>
%1 categories could not be matched:</source>
<translation>1% categorie non possono essere associate:</translation>
<location filename="../src/analysis/processing/qgsalgorithmlayouttoimage.cpp" line="94"/>
<location filename="../src/app/qgspluginregistry.cpp" line="347"/>
<source>Library name is %1
</source>
<translation>Il nome della libreria è %1</translation>
<location filename="../src/core/expression/qgsexpressionfunction.cpp" line="1841"/>
<source>Could not open sqlite database %1. Error %2. </source>
<translation>Impossibile aprire il database sqlite %1. Errore %2.</translation>
<location filename="../src/analysis/processing/qgsalgorithmpackage.cpp" line="249"/>
# -*- coding: utf-8 -*-
"""
***************************************************************************
ogrinfo.py
---------------------
Date : November 2012
Copyright : (C) 2012 by Victor Olaya
Email : volayaf at gmail dot com
***************************************************************************
<!DOCTYPE qgis_bookmarks>
<qgis_bookmarks>
<bookmark>
<id>{1064bc2c-f26c-47aa-a494-f3b89f3cbca4}</id>
<name>Finland</name>
<project></project>
<xmin>20.0655338719999996</xmin>
<ymin>59.92808378499999833</ymin>
<xmax>23.01701824699999932</xmax>
<ymax>62.20387721400000203</ymax>
QGIS 3.10.1
GEOS 3.8.0-CAPI-1.13.1
PROJ Rel. 6.2.1, November 1st, 2019
SpatiaLite 4.3.0
from processing.tools import spatialite
db = spatialite.GeoDB(QgsDataSourceUri('dbname=\'C:/Users/Andrea/test.sqlite\' table=\'test\'(geometry) sql='))
cur=db.con.cursor()
db._exec_sql(cur, sql='select spatialite_version();')
QGIS 3.17.0-Master
GEOS 3.8.1-CAPI-1.13.3
PROJ Rel. 8.0.0, March 1st, 2021
SpatiaLite 4.3.0
md = QgsProviderRegistry.instance().providerMetadata('spatialite')
db=md.createConnection(QgsDataSourceUri('dbname=\'C:/TMP/test.sqlite\' table=\'test\'(geometry) sql=').uri(),{})
db.executeSql('select spatialite_version();')
[['4.3.0']]
QGIS 3.4.5-9-Madeira
GEOS 3.7.0-CAPI-1.11.0
PROJ 5.2.0
SpatiaLite 4.3.0
from processing.tools import spatialite
db = spatialite.GeoDB(QgsDataSourceUri('dbname=\'C:/Users/Andrea/test.sqlite\' table=\'test\'(geometry) sql='))
cur=db.con.cursor()
db._exec_sql(cur, sql='select spatialite_version();')