Re: [Qgis-user] [QGIS-Developer] Announce - migrate our mailing lists to Discourse

[Sandro Santilli via QGIS-User]

On Thu, Apr 04, 2024 at 05:58:32PM +0200, Marco Bernasocchi via QGIS-Developer 
wrote:

> Seems fixed :)
> https://trac.osgeo.org/osgeo/ticket/3073#comment:19

That's actually more of a workaround than a fix.
Discourse still ruins the body of email text/plain email messages.
Even those sent for administrative purpose (links are turned into
html anchor tags)

--strk;


signature.asc
Description: PGP signature
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Nuovo Utente

[Sandro Santilli]

On Tue, Feb 28, 2017 at 10:30:06AM +0100, Leonardo Donnini wrote:
> Perché è sconsigliato l'uso del database mssql ?

Perche' l'uso continuato rende dipendenti, ed dipendere da
una tecnologia di proprieta' esclusiva di un soggetto rende
dipendenti da tale soggetto. Uscire dal tunnel poi diventa
molto difficile.

Una tecnologia libera, invece, e' anche tua.

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Nuovo Utente

[Sandro Santilli]

On Tue, Feb 28, 2017 at 09:41:56AM +0100, Lorena Doria wrote:
> uso mssql dal 2006.

Non e' mai troppo tardi per smettere.
Ed e' facile, se sai come fare !

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] My first weekend with QGIS (UI)

[Sandro Santilli]

On Wed, Jan 25, 2017 at 01:29:38AM -0500, John Hawkinson wrote:
> By the way, can anyone here send me a mantra for osgeo registration?
> (No reply following https://www.osgeo.org/cgi-bin/ldap_create_user.py)

Mantra sent in private mail.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PostGIS Topology

[Sandro Santilli]

Adding some pointers into the documentation, and as I realize
you're on the QGIS users mailing list, I'd suggest to also
consider contributing support for this procedure in the 
DBManager (core plugin) or the postgis topology editor plugin
(http://github.com/strk/qgis_pgis_topoedit).

Following, docs pointers

On Fri, Jan 20, 2017 at 11:37:02AM +0100, Sandro Santilli wrote:

> 1. Load the shapefile into a table

http://postgis.net/docs/manual-2.3/using_postgis_dbmanagement.html#shp2pgsql_usage

> 2. Create a topology

http://postgis.net/docs/manual-2.3/CreateTopology.html

> 3. Add a TopoGeometry column to the table

http://postgis.net/docs/manual-2.3/AddTopoGeometryColumn.html

> 4. Update the table setting the new column with toTopoGeom

http://postgis.net/docs/manual-2.3/toTopoGeom.html

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PostGIS Topology

[Sandro Santilli]

On Fri, Jan 20, 2017 at 02:14:38PM +0400, Irakli Ugulava wrote:

> Please give me the simple way, how to convert existing polygon Shapefile
> into PostGIS topology Layer.

1. Load the shapefile into a table
2. Create a topology
3. Add a TopoGeometry column to the table
4. Update the table setting the new column with toTopoGeom

It may be a good contribution to provide an SQL function to do
all of the steps from 2 to 4, or someone even suggested to
extend the loader (shp2pgsql) to do all the 4 steps at once.

Are you up to give any of these two ideas some legs ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Slack Channel

[Sandro Santilli]

On Fri, Oct 28, 2016 at 12:06:57PM +0200, Miguel Sevilla-Callejo wrote:
> Why not to use Riot [1]? It's possible to join/connect conversations
> through it with gitter, IRC, Telegram & Slack.
> And it's FOSS!!
> 
> In the Spanish OpenStreetMap community we have IRC+Telegram+Riot rooms
> connected and you could chatt from whatever you want.
> 
> It could be a good idea to do it for QGIS community as well.

Sounds like a great idea, how about showcasing it ?
Join #qgis on freenode from Riot and say hello !

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Qualità dei corsi e bugs

[Sandro Santilli]

On Mon, Oct 24, 2016 at 09:39:02AM +0200, G. Allegri wrote:

> Possiamo valutare (specificatamente per r.mapcalc) uno sforzo congiunto per
> la sua risoluzione? In questo momento siamo a corto di risorse da potergli
> dedicare, ma possiamo valutare varie modalità di partecipazione...

Credo che un grandissimo aiuto sarebbe scrivere test automatici
per il processing framework. Ho lavorato sulla risoluzione di acuni
bachi in quella sezione del codice e ho toccato con mano la facilita'
di rompere funzionalita' aggiustandone altre. La presenza di test
automatici impedisce che questo avvenga, riducendo la fragilita'
dell'applicazione.

Potrebbe forse la scrittura di test automatizzati essere un buon
esercizio per i corsisti ?

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Append in Import Vector into PostGIS didn't

[Sandro Santilli]

On Mon, Oct 17, 2016 at 01:34:03PM -0200, Frederico dos Santos Soares wrote:
> Hi Sandro,
> Yes I can but, where?

On http://github.com/qgis/qgis ?

--strk;
> 
> 2016-10-17 7:07 GMT-02:00 Sandro Santilli <s...@kbt.io>:
> 
> > Frederico, would you be up to turn this into a pull request ?
> >
> > There's now a test for connection string building in
> > python/plugins/processing/tests/GdalAlgorithmsTest.py
> > where you could add a test for it.
> >
> > --strk;
> >
> > On Sat, Oct 15, 2016 at 08:29:57PM -0300, Frederico dos Santos Soares
> > wrote:
> > > --Sorted out
> > >
> > > Sharing with the list the solution found.
> > >
> > > In a current work process, I need to run several models using the
> > > "processing" as "[OGR] Import into PostGIS" is the only tool that allows
> > > the output of the models do "append" on a table of Postgres / PostGIS, I
> > > had to solve the problem in the script.
> > >
> > > Recalling I am using QGIS 2.8
> > >
> > > The reference that I used to solve the problem, comes from the same tool
> > in
> > > version 2.14. Clarify that in version 2.14 Import into postgis did not
> > work
> > > if executed within a model, at least not work for me, I believe we have
> > > another bug there.
> > >
> > > Returning. The "Import into postgis" (for available connections) works in
> > > ogr2ogrtopostgislist.py file in the ... \ QGIS Wien \ apps \ qgis-ltr \
> > > python \ plugins \ processing \ algs \ gdal
> > >
> > > The file in its original version builds the command of ogr2ogr with the
> > > schema parameter "-lco" + schema outside the database configuration
> > > parameters: -> ... -append -nlt MULTILINESTRING -lco SCHEMA = teste_geo
> > ...
> > >
> > > I changed the file so that the schema parameter was written into the
> > > connection as follows "active_schema =" + schema -> PG: "host = localhost
> > > port = 5432 dbname = gis password = xxx active_schema=temp
> > >
> > > And voila it worked!
> > >
> > > Attached the file, marked with # rows that were changed.
> > >
> > > I hope that helps someone want to use this tool in their models. I'm
> > using
> > > it's pretty cool.
> > >
> > > Best regards.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Append in Import Vector into PostGIS didn't

[Sandro Santilli]

Frederico, would you be up to turn this into a pull request ?

There's now a test for connection string building in
python/plugins/processing/tests/GdalAlgorithmsTest.py
where you could add a test for it.

--strk;

On Sat, Oct 15, 2016 at 08:29:57PM -0300, Frederico dos Santos Soares wrote:
> --Sorted out
> 
> Sharing with the list the solution found.
> 
> In a current work process, I need to run several models using the
> "processing" as "[OGR] Import into PostGIS" is the only tool that allows
> the output of the models do "append" on a table of Postgres / PostGIS, I
> had to solve the problem in the script.
> 
> Recalling I am using QGIS 2.8
> 
> The reference that I used to solve the problem, comes from the same tool in
> version 2.14. Clarify that in version 2.14 Import into postgis did not work
> if executed within a model, at least not work for me, I believe we have
> another bug there.
> 
> Returning. The "Import into postgis" (for available connections) works in
> ogr2ogrtopostgislist.py file in the ... \ QGIS Wien \ apps \ qgis-ltr \
> python \ plugins \ processing \ algs \ gdal
> 
> The file in its original version builds the command of ogr2ogr with the
> schema parameter "-lco" + schema outside the database configuration
> parameters: -> ... -append -nlt MULTILINESTRING -lco SCHEMA = teste_geo ...
> 
> I changed the file so that the schema parameter was written into the
> connection as follows "active_schema =" + schema -> PG: "host = localhost
> port = 5432 dbname = gis password = xxx active_schema=temp
> 
> And voila it worked!
> 
> Attached the file, marked with # rows that were changed.
> 
> I hope that helps someone want to use this tool in their models. I'm using
> it's pretty cool.
> 
> Best regards.
> 
> -- 
> 
> Frederico dos Santos Soares
> Geógrafo
> 55 61 8416 0105
> fss...@gmail.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] plugin per trattamento grafi (era senza oggetto)

[Sandro Santilli]

On Tue, Sep 27, 2016 at 10:50:33AM +0200, Giuliano Curti wrote:

> mi sembrava di capire dallo scambio Paolo-Luigi che si ipotizzava
> qualche workshop specifico sull'argomento, magari interessante per
> tutta la platea di programmatori, non solo il sottoscritto;

E' un'ottima idea.
Spero possa aiutare i programmatori a gestire con piu' facilita'
il codice e soprattutto a condividerlo.

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] plugin per trattamento grafi (era senza oggetto)

[Sandro Santilli]

On Mon, Sep 26, 2016 at 11:10:40AM +0200, Giuliano Curti wrote:

> http://www.slideshare.net/giulianc/graphs-plugin-20160923ita-66412707

...

> - non ho le risorse per pubblicarlo, pertanto al momento è sul mio
>   "server" privato, ma rimane comunque disponibile per chiunque lo
>   volesse provare;

Che risorse ti servono, per pubblicarlo ?
Hai considerato l'ipotesi di metterlo su un git hoster ?

Segnalo, come possibilita', https://notabug.org

(c'e' anche il server Gogs di OSGeo, se vuoi :)

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

[QGIS-it-user] salva con nome

[Sandro Santilli]

On Tue, Sep 13, 2016 at 07:49:16AM -0700, Totò wrote:
> tasto destro mouse e salva con nome

C'e' un qualche motivo, oltre all'abitudine e/o un tentativo
di emulazione, per il quale quella famosa voce di menu' non e'
tradotta con "Salva come" ?

La voce di menu' viene spesso usata per cambiare formato, o
come in questo caso altre caratteristiche del file, non soltanto
un nome (che peraltro il file aveva probabilmente anche prima).

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] Handling of PostGIS TopoGeometry layers

[Sandro Santilli]

On Wed, Jul 27, 2016 at 02:47:39AM -0400, AW wrote:
> 100% agreed, Sandro.
> 
> I did a quick search in the QGIS hub for the mentioned issue, but couldn't 
> find it for now.

I found this one, for allowing the specification of a "bbox" column
to use for filtering:
http://hub.qgis.org/issues/9516

And this, to allow keyword substitution:
http://hub.qgis.org/issues/4374

I guess the latter would deprecate the former.
Your comments on the ticket(s) would be welcome.

> Is there anybody who can comment on the complexity of such a change?
> Would such a change in the PostGIS provider - despite the positive effects on 
> the handling of topologies - be even wanted?

Well, I would want it :)

> I am not experienced with creating QGIS Plugins... could that be a feasible 
> quick option in case a change of the provider is not a thing which would be 
> quickly implemented?

I guess a plugin could effectively change the query associated with
a layer so to filter by current bbox against an arbitrary column,
but I'm not sure what would be "quicker"...

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Handling of PostGIS TopoGeometry layers

[Sandro Santilli]

On Mon, Jul 25, 2016 at 07:21:16AM -0400, AW wrote:

> I was examining the SQL-statements which QGIS uses to deal with TopoGeometry 
> layers. It essentialy looks somewhat like this:
> 
> ---
> SELECT st_asbinary("topo",'NDR'),"gid"
> FROM "public"."topo_test"
> WHERE "topo" && 
> st_makeenvelope(138.48618410228871767,-35.03610634074148322,138.71434043049001161,-34.78702094367417885,4326)
> ---
> 
> Those kind of statements run really slow because the column "topo" of type 
> TopoGeometry does not have any spatial index.
> In my case the table has a "normal" Geometry column AND a TopoGeometry 
> column, which are pretty much in sync.

[...]

> So I am asking for your opinion if a possibly small addition to a 
> TopoGeometry layer properties in form of e.g. a checkbox is 
> thinkable/reasonable which enables the alteration of the statement to 
> something like that (given the hint, that both geometry columns have to be 
> more or less in sync):
> 
> ---
> SELECT st_asbinary("topo",'NDR'),"gid"
> FROM "public"."topo_test"
> WHERE "geom" && 
> st_makeenvelope(138.48618410228871767,-35.03610634074148322,138.71434043049001161,-34.78702094367417885,4326)
> ---
> 
> Would that be a way to tackle this well known performance issue?

My feeling is that it would be very useful to be able to specify,
for the PostgreSQL provider, a custom dynamic filter, where the
pixel size and extent are available as substitutable queries.

I think there's also an hub ticket for this enhancement, waiting
for a contributed patch.

That, or being able to specify different columns for *rendering*
and *filtering*.

Note that another use case is the "face" layer of the TopologyViewer,
which would benefit from filtering on the "mbr" column rather than
on the result of the expensive ST_GetFaceGeometry call.

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   https://strk.kbt.io/services.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS communication platforms

[Sandro Santilli]

On Mon, Jul 18, 2016 at 11:51:56AM +0200, Mats Elfström wrote:

> Why do you cling to old century mailing lists and bulletin board technology?

Because it's libre technology. That means: fully documented in
the open, preproducible and independent of any single company.

It's not by chances that it is centry-old, contrary to all these
toy and hyped technologies coming out because pushed by marketing
depertment and lasting not more than 10 years at most.

> How many subscribe to this list?

Quality is more important than quantity.
Or we'd be writing software for insects (much more than humans,
on this planet).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [Qgis-psc] 2nd Int. QGIS Conference: videos already available

[Sandro Santilli]

On Fri, Jun 17, 2016 at 09:54:35AM +0200, Lluís Vicens wrote:

> The videos of the 2nd International QGIS Conference held in Girona
> on May, are already available online [1].
> 
> [1] http://diobma.udg.edu/handle/10256.1/4268/browse

Thank you, Lluís!
Pity the slides aren't really visible in the video, could they
be downloaded separately ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] OSGeo Account

[Sandro Santilli]

On Wed, Jun 15, 2016 at 01:26:58PM +0100, Richard McDonnell wrote:
> Afternoon all,
> I have no issue sharing the Mantra, my only concern was, and there
> is no offence meant here, was the person legitimate.
> Are we saying that anyone who contacts the qgis-user looking for a
> mantra can be given one? If that's the case, I have no problem with
> it, Just would like it clarified that's all.

The "mantra sharing rules" are not written in stone.

Online identity checking is usually the best way, but a short
private interview could also do. Email verification is also
important.

In any case, as we made the service less fragile to spam attacks,
the rules can also be relaxed.  Shall a new spammer be found, the mantra
can be changed.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] OSGeo Account

[Sandro Santilli]

On Wed, Jun 15, 2016 at 08:20:30AM +0200, Alessandro Pasotti wrote:
> This "mantra" thing doesn't seem to be very intuitive and even less
> professional.

I think it is intuitive, there are just not enough responsive
people on IRC to give the mantra to those who come to request
one (most of them come from QGIS, which is a good sign of project
health, btw).

Professional ? Maybe not, not from a system operations point of view.

> Is there any chance that a CAPTCHA or other more common patterns can be
> used in that signup page?

The mantra thing was supposed to be a temporary measure.
Now that we have better antispam measures in place it could be
removed, but I find getting to meet new users early on IRC to
be very instructive. This time I suggested Christian to use the
list in case he wouldn't get a reponse soon. What I'm trying to do
is to make project members in charge of distributing the mantra to
users coming for their project. Richard knows how, and can share
the instructions to others in the team.

> It's supposed to be the entry point for many of QGIS related services after
> all, even if I start thinking that moving towards other simpler SSO would
> be advisable at this point.

Whatever SSO you'd use there's always an initial registration to be
performed. I think making services more "flexible" to accept different
kind of authentications would be nice (first and foremost I'd like to see
OpenID implemented), but it is not the SSO being "hard" here, just the
OSGeo registration process (intentionally so).

I plan to drop the mantra barrier within a month or so.
Please remember that before the mantra the user registration was
just CLOSED, and nobody came to ask anything because there was
no pointer to reach out to the project members or sysadmin.
At least now there's a communication channel open. I'll try to
avoid sending people to the list, but please help with sharing
the mantra (other recently registered users can further spread it).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Mappa comunità QGIS

[Sandro Santilli]

On Tue, May 31, 2016 at 04:52:34AM -0700, Totò wrote:
> nformica wrote
> > Quelli che vedo registrati fino ad ora mi sembrano un pò pochini e
> > mancano nomi storici.
> > Che diffusione ha questa mappa ?
> 
> Ciao Nino,
> ho scoperto solo stamani la mappa, non so dirti altro!!!

Pare sia online da 18 ore:
https://github.com/qgis/QGIS-Django/commit/8092224cf7a85f55e56b04b4e9ee12b7ac09b67d

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] variables in postgis filters

[Sandro Santilli]

On Tue, Apr 05, 2016 at 06:09:12PM +1000, Nyall Dawson wrote:

> What's the topology issue you're hoping to solve with this?

Topology face layers from the TopoViewer (via DBManager plugin)
use an expensive (and volatile, thus non-indexable) query to
generate the geometry to be used for display. The provider generally
applies the spatial filter to the geometry field, which in this case
is ineffective.

I could fix this by adding the possibility to specify a
"spatial-filter-field" which is different from the "spatial-display-field"
(similarly could be done for obtaining the $area from the provider,
for example).

Or there could be a way for a query to include its own
scale-and-extent-dependent filter to be applied when fetching
geometries. This would be more flexible for the user as it could
specify any arbitrary filter that could serve to modify what's
fetched depending on the viewport (which could even include
calling functions that query different tables based on different
viewport scales, for instance).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] variables in postgis filters

[Sandro Santilli]

On Mon, Apr 04, 2016 at 10:25:35AM +1000, Nyall Dawson wrote:
> On 3 April 2016 at 01:27, Sandro Santilli <s...@keybit.net> wrote:

> > Being able to use canvas-dependent variables (extent and scale,
> > mostly) would help a lot with speeding up some kind of query
> > layers (TopoGeometry ones, for example).
> 
> Be aware that this would not be possible in a vector layer filter.
> Expressions at the vector layer level will only have access to global,
> project and layer variables. Think about it this way - if the project
> has multiple maps in various composers, which extent and scale would
> be used when fetching features from the layer for something which
> isn't specific to an individual map (Eg the attribute table).

How's the current support for "simplify at the provider side" done ?
It seems to have the exact same constraints of the ones you're
mentioning (yes, I've seen the recent thread about $area parameter
changing value across zoom levels, which seems to be one of those
side-effects).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] variables in postgis filters

[Sandro Santilli]

On Sat, Apr 02, 2016 at 09:12:22AM -0700, ralfwessels wrote:

> ..but I guess (so far) it is not possible to use current extent informations
> (e.g. as variable) within the sql filter options for PostGIS data tables.

Correct, that's currently not supported.
Willing to fund development in that direction ?
I'd be happy to work on it.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] variables in postgis filters

[Sandro Santilli]

On Sat, Apr 02, 2016 at 07:39:47AM -0700, ralfwessels wrote:
> Hi,
> 
> I haven't looked at how the QuickOSM plugin deals with the issue, 
> does it update the layer definition on every pan and zoom operations ? 
> 
> No, the QuickOSm-Plugin is not updateing on every pan or zoom - it just
> loads the object for the current map extent (if this is not to big though).
> But as a first step this would be ok to load data from PostGIS tables.
> 
> So if the QuickOSM Plugin uses the current map extents, thsee must be
> accessible somehow.

Any plugin can subscribe to receive notifications about canvas
updates and can fetch information about the canvas (extent, scale).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] variables in postgis filters

[Sandro Santilli]

On Wed, Mar 30, 2016 at 02:47:55AM -0700, ralfwessels wrote:

> I would like to filter my PostGIS table by the actual extent of the map
> canvas similar to the possibility in the Quick OSM - Plugin.
> 
> Does someone know, if this is possible?

I've been thinking about a way to do this too as I'm afraid it is
currently not available as a core support.

Being able to use canvas-dependent variables (extent and scale,
mostly) would help a lot with speeding up some kind of query
layers (TopoGeometry ones, for example).

I haven't looked at how the QuickOSM plugin deals with the issue,
does it update the layer definition on every pan and zoom operations ?

--strk;


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Un gruppo Telegram QGIS User Italia - il futuro?

[Sandro Santilli]

On Thu, Mar 03, 2016 at 04:32:53AM -0800, Totò wrote:
> Salve a tutti,
> 
> per evitare che si creino lunghi e illeggibili threads, perchè non creare Un
> gruppo Telegram QGIS User Italia?
> Magari messo in evidenza nel sito qgis.it con un bottone (unisciti al Gruppo
> Telegram)
> 
> Non credete sia l'ora di utilizzare nuove tecnologie?
> 
> Telegram è un app che funziona su tutti gli smartphone e su PC
> (https://telegram.org/)

Ho sensazioni discordi in materia.

Sapresti spiegare meglio in che modo le tecnologie che raccomandi
risolvano il problema dei "lunghi e illeggibili thread" ?

Ho installato da un paio di giorni telegram su uno smartphone.
Il client e' libero (anche se non interamente, all'origine,
ne esiste una versione completamente libera) ma il server e'
esclusivamente proprietario.

La mailing list, al contrario, e' servita da un server libero,
cosi' come il canale IRC (per chiacchierate in tempo reale).

Cosa c'e' di nuovo in un gruppo telegram ? Ha a che fare con
l'interfaccia utente di uno specifico agente software oppure
con una modalita' di interazione non disponibile altrimenti ?

--strk;
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] QGIS project slow to open when too much wms layers

[Sandro Santilli]

On Sun, Dec 06, 2015 at 02:31:52PM +0100, aperi2007 wrote:

> Also I guess a the time lost is not only the request/response time, but also
> the parsing time of the response.
> A cache do not help on this.

It can ! Depending on what you cache, you may save
either (or both) download and parse time.

An URL could be mapped to a parsed content.
Or a content hash could be mapped to a parsed content.
Or both, to allow for caches of different lifetime.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS project slow to open when too much wms layers

[Sandro Santilli]

On Sat, Dec 05, 2015 at 06:06:05PM +0100, aperi2007 wrote:

> https://lists.osgeo.org/pipermail/qgis-user/2015-December/034593.html

[..]

> Insteal the problem is on the getcapabilites requests.
> They are repeated the same for every single wms layer indipendently
> if it is coming from the same wms service or not.

[..]

> A good enhancement for me could be to do one single getcapabilities
> request for every distinct wms service used in the project instead
> that one for every layer to avoid this waste redundancy of work.

Sounds worth an enhancement ticket.
A cache for capabilities request.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Qgis crash-- solved

[Sandro Santilli]

On Sun, Nov 15, 2015 at 02:53:55PM -0700, Lewis Hein wrote:
> Hi all
> 
> I thought I would post the solution to my problem in case anyone has a
> similar thing happen. It turns out that something was wrong with my
> configuration file $HOME/.config/QGIS/QGIS2.conf. I removed the file,
> started QGIS 2.12, and it works just fine.

If you still have the file around, please consider cleaning it
up of sensitive data and attaching it to a bug report on
https://hub.qgis.org -- crashes should not be tolerated !

Thanks in advance.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Who use reallythe Lwgeom-provider

[Sandro Santilli]

I think we're talking about these:
http://plugins.qgis.org/search/?q=liblwgeom

Specifically:
http://plugins.qgis.org/plugins/processinglwgeomprovider/

The website contains some stats, the first non-experimental
version (0.4.4) has had 2758 downloads since Sept 2014.

--strk;


On Fri, Oct 16, 2015 at 09:33:58AM +0200, Andrea Peri wrote:
> Hi,
> 
> We are interested to know how many users are really using the
> lwgeom-provider and the MakeValid available in it.
> 
> The need is to understand how it is really knowed and used from the qgis 
> users.
> 
> The question born yesterday when speaking with an our supplier it say
> us that don't know this availability of the makevalid in the
> liblwgeom-provider.
> 
> So we try to show it the usage but see also that is was absolutely not
> easy to activate for a qgis user..
> Infact it require the availability of the lwgeom library that is not
> installed from the osgeo4w standard installation (only in the advanced
> and with a direct action by the user.
> 
> This faxt let us to thinkthat perhaps the lwgeom-provider is a quite
> unusefl and substantially unknowed provider.
> 
> So we like to understand better this.
> To decide if it is the right solution to plan to have the liblwgeom
> function directly in the qgis environment or otherwise is better to
> leave them only in the postgis or spatialite worlds and let the qgis
> user to use them only with the sql interface.
> 
> 
> Thx.
> 
> -- 
> -
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Who use reallythe Lwgeom-provider

[Sandro Santilli]

On Fri, Oct 16, 2015 at 12:52:22PM +0200, Andrea Peri wrote:
> Il 16 ott 2015 12:38, "Sandro Santilli" <s...@keybit.net> ha scritto:
> 
> > http://plugins.qgis.org/plugins/processinglwgeomprovider/
> >
> > The website contains some stats, the first non-experimental
> > version (0.4.4) has had 2758 downloads since Sept 2014.
>
> Do you know if the counter is for inique users or for simple download ?

No idea, maybe Alessandro ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Making oblique maps in Qgis: is it possible?

[Sandro Santilli]

On Fri, Sep 11, 2015 at 11:00:24AM +0200, Jens Verwaerde | Natuurpunt CVN wrote:
> I'd like to make an oblique (bird's eye) view of some of my maps.
> Theoretically this is possible by exporting a map to an image manipulation
> program and then using a tilting function, but ... that's an extra step and
> ... everything on the map is then "obliqued" including labels etc.
> 
> But I don't want everything to become oblique; text labels, arrows etc.
> should stay "normal" and floating in the air above the map, so only the map
> should be oblique.

Map rotation is supported since version 2.8, does it do what you need ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Fri, Sep 04, 2015 at 08:31:39AM -0400, James Keener wrote:
> Sorry for the double email.  Also, I wonder how much we could extract
> from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM
> view WHERE field1 = 1;) and if we could tease information out of that.

Information can be extracted from the result set with a LIMIT 0
select, and I believe this is what qgis already does.

You can see which tables are being addressed and whether those
tables have a primary key, but it ain't easy to determine if
those primary keys will appear uniquely in the output.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Tue, Sep 01, 2015 at 01:15:59PM -0400, James Keener wrote:

> I'd also like to point out that the primary key need not be a single field. 
> For instance (state_fips, county_fips) could be a valid key for county-based 
> metrics. Going back to the previous question I posed, do we want to tell 
> users to conform to a single-field primary key or will qgis accept valid 
> schema designs. Again, it comes down to dev time vs the cost to the user 
> experience.


I'd note that supporting complex primary keys would also allow
qgis to identify rows based on an expensively computed fingerprint
of the hash of the canonical form of each and every field.


--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Wed, Sep 02, 2015 at 08:48:34AM +0200, Bernhard Ströbl wrote:
> Am 01.09.2015 um 17:49 schrieb Matthias Kuhn:


> >2. If there are tables without a PK open a second modal dialog with an
> >explanation of the problem and offer to select a pk from a combobox.
> 
> I hope you mean "relation" not table, a table should always have a
> PK.

It's not mandatory for a table to have a PK.
I guess by "tables without a PK" he means table for which no PRIMARY
KEY constraint is explicitly defined (should an UNIQUE key be
considered equally valid?).

> >3. Optional: Add a button "search suitable pk" which looks for a
> >suitable unique column.
> 
> yes, why not, although the label should read something like "analyze
> relation for use in QGIS" or similar (would include detection of
> geometry type and crs if needed) because if a user knows what a PK
> is, he will most probably know which field to use anyways :-)

+1, if a full scan has to be performed, it'd be better to gather
as much information as possible from it.

> >4. Optional: Add a selection "read-only" to the combobox and do some
> >row_number() or other black magic and warn the user with a big red
> >dialog that he's about to do something very dangerous, unreliable and
> >that his warranty is now very void.
> 
> -1 either load the thing properly and if that is not possible one
> has to change the view definition to make it compatible with QGIS if
> it is supposed to be used there. An average user would probably not
> understand what he accepts and complain about bad perfomrance or not
> being able to edit the layer later on. Warning messages are regarded
> as an annoyance to be accepted not to be read and understood :-)

Agreed, better refuse to load with a clear error message than
loading and failing later.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

I agree with Luca this should have been better not backported to 2.8.3.
Only proper bugs should be backported, and this was a (debatable)
GUI enhancement, as far as I can tell.

BTW: resolution of #11317 is set to "wontfix"

--strk;

On Mon, Aug 31, 2015 at 09:00:15PM +0200, Luca Lanteri wrote:
> Hi,
> 
> I noticed that this new behavior has been backported to 2.8.3.
> I think this behavior should be considered a regression because now it's
> very uncomfortable to load views, specially when I have to load many views.
> I also noticed that lot of users are confused, because they thinks that
> views doesn't work. I think the old behavior was better because it allowed
> both to choose a custom gid and to load view faster.
> Currently we decide to remain with 2.8.2.
> 
> What about reconsidering to return to the old behavior ?
> 
> Thanks
> Luca
> 
> 2015-08-06 20:58 GMT+02:00 Jürgen E. :
> 
> > Hi Randal,
> >
> > On Thu, 06. Aug 2015 at 13:53:08 -0400, Randal Hale wrote:
> > > In 2.8.x I can add the view and the Primary key is automatically
> > displayed.
> >
> > No, you're supposed to select the primary key.  In 2.8.x you also have to
> > choose from all columns, but first one is preselected.  If that happens to
> > be
> > the primary key, you're fine, but that's not always the case and hence
> > newer versions force you to actually select it.
> >
> > Jürgen
> >
> > --
> > Jürgen E. Fischer   norBIT GmbH Tel.
> > +49-4931-918175-31
> > Dipl.-Inf. (FH) Rheinstraße 13  Fax.
> > +49-4931-918175-50
> > Software Engineer   D-26506 Norden
> > http://www.norbit.de
> > QGIS release manager (PSC)  GermanyIRC: jef on FreeNode
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[Sandro Santilli]

On Tue, Sep 01, 2015 at 02:37:22PM +0200, Jürgen E. Fischer wrote:
> Hi Sandro,
> 
> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
> > I agree with Luca this should have been better not backported to 2.8.3.
> > Only proper bugs should be backported, and this was a (debatable)
> > GUI enhancement, as far as I can tell.
> 
> We intend to only backport fixes and not bugs. ;)
> 
> You were always supposed to select the key column - preselecting the first
> column was the bug (also debatable).  And #11317 is a ticket that demonstrates
> there were unaware users.

Reading #11317 I looks to me that the reported bug was about
"Add PostGIS Layer" not giving the user full detail of why a
layer could not be loaded: "is an invalid layer - not loaded".
In this I agree with Aren here: http://hub.qgis.org/issues/11317#note-6

> That the first column often happens to be the primary key and and the combobox
> is not lexically sorted is somewhat pure luck - and unless you avoid having 
> the
> key verified (using "use estimated metadata"), keeping a wrongly select
> column will make the layer to insert invalid.

I agree that the reported regression was based on the false expectation
that QGIS would pick a primary key automatically, but in the
(unlikely?) case a user was aware of that and properly coded the view
to ensure primary key was first (or only) numeric the change was
indeed a degradation of the experience.

> But I agree that the tooltip that you get on disabled lines (not only for the
> key selection, but also geometry type and srid) might not be visible enough
> (but that IMHO would be just a GUI enhancement).

There should maybe be another rule about LTS backports being:
debatable fixes/enhancement need to be debated more on list ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS instalation and uninstallation issues

[Sandro Santilli]

On Thu, Jul 16, 2015 at 03:08:59PM +0200, Mats Elfström wrote:
 Why does it have to be this hard to install amd maintain QGis on the most
 common os of the world?

Because the very few part of the world that develops QGIS hates to be
trapped by such a defective-by-design OS ?

--strk; 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS instalation and uninstallation issues

[Sandro Santilli]

On Thu, Jul 16, 2015 at 06:24:51PM +0200, Mats Elfström wrote:
 I am sorry Sandro, but that kind of remark does not further our common
 cause; to make qgis useful for all.

My personal cause is to make QGIS useful for me.
I'm very selfish.

It's very useful for me that QGIS is open source as many people can
help me making QGIS more useful for me.

It's very useful for me to NOT ruin others workflow as they might stop
investing time or money in QGIS, so I'm surely not intentionally working
to break any use of QGIS on non-free systems.

It is not useful for me to make QGIS work nicely on a system I
personally don't use. Unless it was a paid service, which I currently
don't offer.

Granted, it might be useful for me if QGIS had more users, in case
those users will become funders of QGIS enhancements. But users of
proprietary systems are often not even willing to pay for their
systems, let alone pay for systems that are offered them for free...

So I, as a developer, choosed not to work on making QGIS play nicely
on windows. Thanks to the free software nature of the software, others
developers have other approaches on the matter and do care more about
(or do offer support for) running QGIS on those defective by design
systems, but I finds it perfectly understandable if it's not so much
supported as it is on free systems (by the mere fact that more free
developers use free systems and more oculated investors invest in free
systems...).

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Difference

[Sandro Santilli]

On Wed, Mar 18, 2015 at 02:18:24PM +, Shetie Gatew wrote:
 Dear folks,Is there any difference between QGIS 2.6.1 and QGIS 2.8.1? I 
 haven't seen the difference.

Did you look at the NEWS file ?

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Labeling in Composer with QGIS 2.8

[Sandro Santilli]

On Thu, Mar 05, 2015 at 02:48:56PM +, Claire BERGUER wrote:
 Hello,
 
 I have a problem with the new version 2.8.
 As I rotate the map in the print composer, the labels will not appear 
 anymore.
 Is that normal? It's work fine when the map don't have any rotation.

It's _not_ normal, but you're not the first one reporting it.
Only, I'm afraid nobody filed a ticket for this yet.
IIRC, the previous reporter found that saving the project and re-opening
it worked around the bug (but I could be wrong).

In any case, I'd recommend filing a ticket with all the informations
(and please include the rotation tag).

 http://hub.qgis.org/projects/quantum-gis/issues

Thank you.

--strk;
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user