Re: [QGIS-Developer] Time for db manager to become an "opt-in" plugin?

ut of the scope of this migration, but following your idea, > I wonder if the python console/editor and underlying code could be used > also to run SQL? > > A quinta, 8/09/2022, 22:13, Carlo A. Bertelli (Charta s.r.l.) < > carlo.berte...@gmail.com> escreveu: > >> This decision

Re: [QGIS-Developer] Time for db manager to become an "opt-in" plugin?

This decision makes sense to me, but I still miss an SQL interface – I mean an SQL-oriented interface for data as GDAL does even for unnecessary cases. QGIS has a python-first approach but I don't think this should be the only or the mandatory way to approach GIS data. Alexandre Neto says: > I am

Re: [QGIS-Developer] Inserting provider filter just before PostGIS layer is loaded?

I think this could find an interesting framework in the proposal of a new database interface. One of the proposals pertains to the process interface. Maybe it could become a more generic interface to data sources. More and more data infrastructures are intrinsically no-SQL and it could be interesti

Re: [QGIS-Developer] Time for db manager to become an "opt-in" plugin?

I think José has a good suggestion, maybe a fully integrated SQL console could be the other way around the browser panel. Having a "Database" Menu without any database management tool could be funny and deceiving for new users. The idea of having SQL as another language to manage geographic DBMSs (

Re: [QGIS-Developer] Problems with MAC and OneDrive

gt; can overwrite the cloud version which is risky. Is there versioning > control built into OneDrive? > > On 5/04/22 03:33, Carlo A. Bertelli (Charta s.r.l.) via QGIS-Developer > wrote: > > Could you please provide some more info about the format of the data? > > I think your

Re: [QGIS-Developer] Problems with MAC and OneDrive

Could you please provide some more info about the format of the data? I think your question does not imply using a DBMS server which I could suggest in this case. Sharing a file that can be updated on a remote file system involves some (risky) reaction, but cloud storage is different, it involves s

Re: [QGIS-Developer] WFS3 API POST PUT Methods

The GeoJSON Specification (RFC 7946) mandates the use of WGS84: The coordinate reference system for all GeoJSON coordinates is a > geographic coordinate reference system, using the World Geodetic > System 1984 (WGS 84) [WGS84 > ] datum, with

Re: [QGIS-Developer] WFS-T, postgis and triggers

I suppose we could benefit from the help of another Alessandro, the father of Spatialite. I think he is already working on WFS3. Maybe this could lead to an enhancement of libspatialite to make XML/JSON sources a more interactive part of Spatialite itself or a virtualwms data provider for Spatialit

Re: [QGIS-Developer] What about AsincPg?

l be your local configuration rather > than postgresql. You would need to share a bit more detail before someone > can help you resolve it though. > > Regards > > Tim > > > On Fri, Aug 28, 2020 at 8:33 AM Carlo A. Bertelli (Charta s.r.l.) < > carlo.berte...@gmail.co

[QGIS-Developer] What about AsincPg?

Maybe AsyncPg (https://github.com/MagicStack/asyncpg) could be the answer for the slow pace of psycopg. What do you think? Using database introspection that was introduced since version 9.2, AsincPg is not compatible with version 8.4 that is still widely used, but declared speed gains seem worth tr

Re: [QGIS-Developer] Popular plugins

What Paolo said seems a suggestion to modify the existing query. Beside popularity (downloads), the query should filter out the plugins that provide functionality already in core (by version). This means having a stronger control of the plugins and features to decide what is in and what is out for

Re: [QGIS-Developer] Dropping the extra label placement algorithms?

eally influenced by the frequent enhancements of QGIS. c On Mon, Jul 29, 2019 at 8:31 AM Nyall Dawson wrote: > On Mon, 29 Jul 2019 at 16:28, Carlo A. Bertelli (Charta s.r.l.) > wrote: > > > > Label placement took a lot of time and efforts in the past and this is > the outcome

Re: [QGIS-Developer] Dropping the extra label placement algorithms?

Label placement took a lot of time and efforts in the past and this is the outcome. It's true, there is no real need for it while on screen, but it could be very useful in Layout. The problem is similar to generalisation, you need proper data to support label placement. Losing the relationship with

Re: [QGIS-Developer] Get rid of 'Manage Layers Toolbar', or not?

This is an old debate, GIS programs usually show a very cluttered interface. It's matter of muscles: more icons, more tools, more power. Uncluttering the interface would help noviced and power users. I think that actions that are performed "per feature" (frequently) may benefit from getting an icon

Re: [QGIS-Developer] Windows only version of a QGIS 2.18x plugin

This long and fruitful exchange about usage of Windows-only executables inside QGIS suggests the availability of some "bridge" made using wine ( winehq.org). This could be an infrastructure made available to Processing that could ease accessing some valuable tool. c On Mon, Feb 11, 2019 at 8:25 AM

Re: [QGIS-Developer] Plugin [1462] Repair Lines Connections approval notification.

Hello, the page of this plugin: http://plugins.qgis.org/plugins/RepairLinesConncetions/ heads to the repository for another plugin developed by Carlos Eduardo Cagna. The right link should be: https://github.com/CarlosCagna/RepairLinesConncetions It would be event better to fix the spelling of Conne

Re: [QGIS-Developer] Find unmaintained plugins

Hi Paolo, if I understand well, your reply implicitely highlights several topics. Plugins are plug-ins, they are supposed to serve as an integration of specialised functions that are too specific to become part of the main program. This in theory; sometimes they are a temporary solution for a more

Re: [QGIS-Developer] Why is .qgz the default format?

My first reaction is "please KISS", the XML project is already complicated, so I would stick to option 1. About usability, I really don't mind it. Having a zipped file is convenient when... I make a mess, editing the project file. There is already an enhancement proposal to optionally save the proj

Re: [QGIS-Developer] Redmine stats

Hello, maybe I don't catch the right meaning of proposals, but I think we could put in better use GitHub by using its API ( https://developer.github.com/v3/repos/statistics/). Sorry for misunderstanding if it happens. c Il giorno mar 15 gen 2019, 09:03 Paolo Cavallini ha scritto: > Hi Richard,

Re: [QGIS-Developer] IFC data in QGIS?

About GDAL and IFC, there is something useful here: https://3d.bk.tudelft.nl/ken/en/thesis/implementation.html c On Wed, Dec 12, 2018 at 2:53 PM Carlo A. Bertelli (Charta s.r.l.) < carlo.berte...@gmail.com> wrote: > Is ifcopenshell.org any use in getting data into QGIS? May GDAL may us

Re: [QGIS-Developer] IFC data in QGIS?

Is ifcopenshell.org any use in getting data into QGIS? May GDAL may use it to convert to XML and than resort to the infrastructure used for GML (which is unfortunately not so similar, looking to namespaces)? Il giorno mer 12 dic 2018, 14:04 Loïc Bartoletti ha scritto: > Hi, > > IFC is the exchan

Re: [QGIS-Developer] QGIS Server WFS 2.18 unreliable?

Just my two cents: * try to understand if there are issues with charsets, sometimes you focus on geometries and don't remember to check for lesser things; * try to use ogr2ogr to try the conversion. What happens converting your datasource directly to GML3? c On Wed, Nov 14, 2018 at 2:37 PM Andreas

[QGIS-Developer] Editing topology data

QGIS is based on simple features and handles topological data (e. g. GRASS layers) as such. Recently I had to deal with a dataset made with Topobase (now Autodesk) on Oracle Spatial (topology). I proposed to migrate it to PostgreSQL/PostGIS as a topological dataset, withoud degrading it to simple f

Re: [QGIS-Developer] Appending text data to a geopackage

What about working on a geometric view with properly configured rules while on PostgresSQL or with a trigger on other DBMSs (SQLite too)? It seems the easiest way to avoid the shell. Maybe there could even be a way with a virtual file based on internal SQLite... Just a thought... c On Wed, Oct 10,

Re: [QGIS-Developer] QgsProcessing vector types combobox

May I support this request by Matteo? When processing geometries, undesired multi-geometries are a frequent outcome. It may even be useful to show the users that that the procedure has a multi-geometry output. This usually means there are uplanned outcomes and that the algorithm is not properly con

Re: [QGIS-Developer] Discussing default snapping and node editing settings

If the most frequent case is snapping to the same or to one or two other layers, is not a good idea to ask the user to resort to advanced settings. The proposed idea to put the choice of layers in the basic snapping options seems a reasonable solution IMHO. About WFS - but this is true for remote

Re: [QGIS-Developer] What to do about WFS test failures?

What about starting with/focusing on WFS 3? The new version is really cleaner and seems much more efficient. The current WFS implementation in QGIS is much better than previous versions, even if sometimes making a virtual OGR file il the only way to use some services. There are really bad server im

Re: [QGIS-Developer] epel packages gdal and spatialite

ple: https://yum.postgresql.org/10/redhat/rhel-7-x86_64/repoview/ with all the provided packages (A..W). It may be a good idea not to replicate this effort, but to supplement it with missing packages. Ciao c On Wed, Aug 29, 2018 at 11:03 AM, Carlo A. Bertelli (Charta s.r.l.) < carlo.berte...@gmail.com> wro

Re: [QGIS-Developer] epel packages gdal and spatialite

Thank you, it's a very good idea. The Enterprise Linux Gis project (ELGIS - https://wiki.osgeo.org/wiki/Enterprise_Linux_GIS) says: > > The ELGIS repository is not maintained any more, use EPEL. I don't think there is a strong need for QGIS (Desktop), Centos and RH are mainly used as servers, but

Re: [QGIS-Developer] PyQGIS: Mixed Polygon/MultiPolygon shapefile

Hello Javier, just force the multipolygon behaviour. As you say it's a GDAL refinement, just use a Layer Creation Option (-lco). As per the docs (http://www.gdal.org/drv_shapefile.html): - *SHPT=type*: Override the type of shapefile created. Can be one of NULL for a simple .dbf file with no

Re: [QGIS-Developer] QGIS 3 Print Composer - Page Properties

I suggest to provide the same interface as version 2 calling this "default page size" and explaining that every page could get a different size, right-clicking on the page. Most users make one-page maps and they would never need this otherwise vital feature. c On Mon, Apr 2, 2018 at 10:01 PM, Ales

Re: [QGIS-Developer] Microstation DGN v8

We have been members of OpenDWG then Open Design Alliance for years. Teigha is not open source, but we never paid any fee to use the converter/viewer, I don't know if there is any limitation to use the (binary) libraries included. I don't think so, but I may be wrong. Licensing the source is unfort

Re: [QGIS-Developer] Simple QGIS KML/KMZ Import

XML and JSON formats do not adhere to the simple feature model of GDAL/OGR that is reminiscent of a flat file or a relational table. And GDAL is one of the base pillars for QGIS. These are more similar to other storage models, say hierarchical or graphs, so they enable a complex data structure that

Re: [QGIS-Developer] Issues building from source on Mac - No module named PyQt5

Would you advice building Qt5 from source then, rather than using brew? > > Thanks > > On Fri, Mar 9, 2018 at 11:13 AM, Carlo A. Bertelli (Charta s.r.l.) < > carlo.berte...@gmail.com> wrote: > >> Hello, >> I suggest to remind that using Homebrew carries in anoth

Re: [QGIS-Developer] Issues building from source on Mac - No module named PyQt5

Hello, I suggest to remind that using Homebrew carries in another issue. The maintainers decided to force everyone to use Qt5 as Qt4 is deprecated by Qt developers. Everything that was called qt5-something should become qt-something, so everyone who uses Qt4 had to make formulas called qt4-somethin

Re: [QGIS-Developer] Separate namespaces for QGIS-LTR and QGIS (3)

mount of dev work to create a > better product for end users. > > - Nathan > > On Sun, Mar 4, 2018 at 6:21 PM, Carlo A. Bertelli (Charta s.r.l.) < > carlo.berte...@gmail.com> wrote: > >> No pun intended, when you announced what you were going to do, I used >> Map

Re: [QGIS-Developer] Discussing qgd files

A disruptive "moreover approach" suggests some reflection about the file database approach. I see several places where handling metadata in the database could provide a better but possibly conflicting solution. This happens for instance with styles stored on the database that may easily be overwr

Re: [QGIS-Developer] Separate namespaces for QGIS-LTR and QGIS (3)

un, Mar 4, 2018 at 12:04 AM, Tim Sutton wrote: > Hi > > On 03 Mar 2018, at 20:43, Jürgen E. Fischer wrote: > > Hi, > > On Sat, 03. Mar 2018 at 12:43:00 +0100, Carlo A. Bertelli (Charta s.r.l.) > wrote: > > but also abandoned the idea of QGIS as a simple viewer that ac

Re: [QGIS-Developer] Separate namespaces for QGIS-LTR and QGIS (3)

, Mar 3, 2018 at 1:16 PM, Richard Duivenvoorde wrote: > On 03-03-18 12:43, Carlo A. Bertelli (Charta s.r.l.) wrote: > > From a user's point of view, having a tried and dependable LTR is an > > important feature. > > The new main version has finally addressed the needed u

[QGIS-Developer] Separate namespaces for QGIS-LTR and QGIS (3)

>From a user's point of view, having a tried and dependable LTR is an important feature. The new main version has finally addressed the needed upgrade of python (2->3) and Qt (4->5) but also abandoned the idea of QGIS as a simple viewer that acquires editing abilities by plugins. Plugins are not an