[Qgis-user] Qfield: adding new columns to a postgis table

[Ville Koivisto]

Good morning to all, 

 

I've created a Qfield project for my colleague, who's in the field updating
a dataset as we speak. Edited layers are postgis tables that I've been able
to edit successfully from my office's PC so far. 

 

But today I hoped to create new columns for a couple of my postgis tables.
This was successful for myself, but for my colleague in the field with
Qfield, changes didn't occur. Now I'm wondering if this is something I could
fix or if Qfield isn't coded to display columns which were added after the
initial packaging. 

 

Any idea anyone? 

 

Cheers,

 

Ville Koivisto

+35840 701 4283

GIS Expert

Suomen kuntotekniikka Oy



 

___
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] QGIS utilizza LEFT JOIN come join tabellare

[Alessandro Sarretta]

Scusa Totò, disconosce nel senso letterale di "non ammette di/non vuole 
riconoscere che le unioni tabellari sono delle LEFT JOIN" o intendi dire 
che semplicemente non lo sa? :-/


Ale


On 04/07/2018 21:30, Totò wrote:

Totò wrote

Ciao a tutti,
Ho scoperto che più del 50% degli utilizzatori di QGIS disconosce che le
unioni tabellare in QGIS (il famoso JOIN) adotta la clausola LEFT JOIN,
qui [0] un mio piccolo contributo;
aggiungo che dalla 3.0 è possibile modificare le tabelle in JOIN purché
sia
editabili di suo.

[0]
https://pigrecoinfinito.wordpress.com/2018/07/04/qgis-join-unioni-tabellari/

Scusate, la fretta mi ha fatto scrivere una inesattetta:
IMHO (dovutà ad esperienza diretta)  quasi il 50 % degli utilizzatori di
QGIS disconosce che le unioni tabellari sono delle LEFT JOIN.

saluti



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


--
--

Alessandro Sarretta

skype/twitter: alesarrett
Web: ilsarrett.wordpress.com 

Research information:

 * Google scholar profile
   
 * ORCID 
 * Research Gate 
 * Impactstory 

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

Re: [QGIS-it-user] QGIS utilizza LEFT JOIN come join tabellare

[Totò]

Totò wrote
> Ciao a tutti,
> Ho scoperto che più del 50% degli utilizzatori di QGIS disconosce che le
> unioni tabellare in QGIS (il famoso JOIN) adotta la clausola LEFT JOIN,
> qui [0] un mio piccolo contributo;
> aggiungo che dalla 3.0 è possibile modificare le tabelle in JOIN purché
> sia
> editabili di suo.
> 
> [0]
> https://pigrecoinfinito.wordpress.com/2018/07/04/qgis-join-unioni-tabellari/

Scusate, la fretta mi ha fatto scrivere una inesattetta:
IMHO (dovutà ad esperienza diretta)  quasi il 50 % degli utilizzatori di
QGIS disconosce che le unioni tabellari sono delle LEFT JOIN.

saluti



-
https://pigrecoinfinito.wordpress.com/
--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[Qgis-user] Symmetric Difference for a Single Layer

[Daniel Alejandro Montecinos Rubilar]

Hello,

 

I have a question, how can I apply the geoprocessing tools "symmetric 
difference ...", but for a single layer and not two as it come in by default. I 
need to apply the function to several polygon inside the one same layer. Or if 
there is another function that make  this operation.

 

Thanks for the help.

 

Atte.,

_

Daniel

 

___
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] Move multiple layer at the same time

[Marco Antônio Ferreira Pedrosa]

Thanks a lot, Gam17!

--

Marcão


skype: marco.afp


Em qua, 4 de jul de 2018 às 04:38,  escreveu:

> Hi Marco,
>you can use qad plugin. If you are using spanish localization run
> DESPLAZA command, if you are using english version run MOVE command.
> For further info search "MOVE AUTOCAD" on the web.
> bye
> gam17
>
> Use the
> > Hi All!
> >
> > I would like to move multiple layers (point, line and polygon) at the
> > same time in QGIS. Is it possible?
> >
> > All layers are relatively georrefereced, and I want to change their
> > locations at once, using known control points from one of the layers.
> >
> > Best regards!
> > ___
> > 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
>
___
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] Converting X Y Coordinates to Latitude/Longitude

[Tudorache, Marian]

Nicholas method is about transforming coordinates from a CRS to another one.

QGIS also has the possibility of enable on the fly CRS transformation.

In both cases you should know the CRS for vectorized historic map.

QGIS will do the best to generate a custom CRS and associate to your data but 
it does not work all the time.

Do you know the CRS for vectorized historic map?

To be accurate during coordinate transformation you need to associated the 
original data with a CRS.

We had an issue with not georeferenced data. When we loaded the vectorized 
data, QGIS assigned a weird CRS. After we <> to GRS80 the area was 
shifted.
We knew the area was somewhere in Vancouver and the area was over a 
stereographic projection. I knew the point of tangency and I created a custom 
CRS which was associated to my original data.

After this tweak we were able to overlay precisely the area where it belongs.

I hope this helps.
Marian


From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Nicolas 
Cadieux
Sent: June-07-18 9:54 PM
To: David Hochfelder
Cc: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Converting X Y Coordinates to Latitude/Longitude

Hi David,

I’am an archaeologist working in Québec. If you vectorized the map in a local 
CRS, all you need to do is do a « save as » and change the CRS (coordinate 
reference system) that is in Longitude Latitude.  If your map is not 
georefenrenced (that is, you just scanned the map and did not use a CRS, that 
is more complicated but not impossible.  I usually fixe that do in a CAD but I 
am sure you can do it in QGIS.  We could talk if you want and I could help you 
out figured the next steps and steps to avoid this problem (like georefereing 
the raster map before you start) .Send me an email directly.

You could look at this also.
https://gis.stackexchange.com/questions/136817/qgis-moving-the-layer-all-features-using-vector-affine-transformation

Nicolas

Le 7 juin 2018 à 20:49, David Hochfelder 
mailto:dhochfel...@albany.edu>> a écrit :
Hi All,

I am new to QGIS, so this may be a newbie question easily answered by the more 
experienced.

I'm working on a historical GIS project to remap an area of Albany, NY 
demolished for urban renewal in 1962. I've succeeded in vectorizing a historic 
map of the area (~1960), but the coordinates are not in lat/long form. I see 
that there are plugins for converting tables of specific coordinates, but I 
want to convert the entire map continuously.

This area no longer exists--all the buildings and streets were cleared for the 
Empire State Plaza state capitol complex.

My end goal is to use the rectified map as a way to geotag historic photographs 
of particular buildings.

Is there a way to convert the coordinates in a continuous fashion for the 
entire region?

Thanks for your help.

Dave Hochfelder


David Hochfelder
Associate Professor
History Department
Social Science 060B
University at Albany, SUNY
Albany, NY 1
518-442-5348
___
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



This electronic message, as well as any transmitted files included in the 
electronic message, may contain privileged or confidential information and is 
intended solely for the use of the individual(s) or entity to which it is 
addressed. If you have received this electronic message in error please notify 
the sender immediately and delete the electronic message. Any unauthorized 
copying, disclosure or distribution of the electronic message is strictly 
forbidden. NAV CANADA accepts no liability for any damage caused by any virus 
and/or other malicious code transmitted by this electronic communication.

Le présent message électronique et tout fichier qui peut y être joint peuvent 
contenir des renseignements privilégiés ou confidentiels destinés à l’usage 
exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez 
reçu ce message électronique par erreur, veuillez en informer l’expéditeur 
immédiatement et supprimez le. Toute reproduction, divulgation ou distribution 
du présent message électronique est strictement interdite. NAV CANADA n’assume 
aucune responsabilité en cas de dommage causé par tout virus ou autre programme 
malveillant transmis par ce message électronique.
___
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] Plugin autoSaver in QGIS 2.18.21 LTR

[Massimo A.]

On 29/06/2018 11:01, Enrico Ferreguti wrote:

Con l'ultima versione(2.4) del plugin nella medesima configurazione 
non ottengo nessun errore.

Potresti dare qualche istruzione in più per riprodurre il problema?



L´errore dal pannello messaggi log di Python che ricevo è questo :

*2018-07-04T13:31:38 1 Traceback (most recent call last):***

*File "C:/Users/info/.qgis2/python/plugins\autoSaver\autosave.py", line 
370, in cronEvent*


**

*self.saveCurrentProject()*

**

*File "C:/Users/info/.qgis2/python/plugins\autoSaver\autosave.py", line 
399, in saveCurrentProject*


**

*QgsProject.instance().write()*

**

*TypeError: write() takes exactly 2 arguments (1 given)*



opero con questa versione di QGIS


Versione di QGIS



2.18.21



Revisione codice QGIS



9fba24a3f2 

Compilato con Qt



4.8.5



Esecuzione con Qt



4.8.5

Compilato con GDAL/OGR



2.2.4



Esecuzione con GDAL/OGR



2.2.4

Compilato con GEOS



3.6.1-CAPI-1.10.1



Esecuzione con GEOS



3.6.1-CAPI-1.10.1 r0

Versione client PostgreSQL



9.2.4



Versione SpatiaLite



4.3.0

Versione QWT



5.2.3



Versione PROJ.4



493

Versione QScintilla2



2.7.2






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

Re: [Qgis-user] XYZ Connection Referer

[Alessandro Pasotti]

It allows you to set an HTTP referer for the tiles requests

See: https://en.wikipedia.org/wiki/HTTP_referer

On Wed, Jul 4, 2018 at 11:14 AM, Michel Stuyts 
wrote:

> In the settings of a XYZ Tiles Connection there is a setting called
> "Referer". What is it used for?
>
>
> Michel
> ___
> 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




-- 
Alessandro Pasotti
w3:   www.itopen.it
___
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

[QGIS-it-user] Classificazione semiautomatica di foto aeree

[Giuseppe Cillis]

Salve a tutti,
mi sto applicando tra QGIS e GRASS per applicare una classificazione
semiautomatica di foto aeree.
In pratica vorrei usare la combinazione dei moduli grass nel processing di
QGIS; ovvero i.cluster e i.maxlink. Il mio problema è che con i.cluster non
riesco a creare la "spectral signature" che poi deve essere usata nel
secondo modulo. Come mai?
In pratica utilizzo due foto aree ed ho lasciato (Come prova) i parametri
preimpostati però alla fine del processo (Anche se non mi da' errori) ,
viene creato solo un report finale e nessun file della firma spettrale.
Come mai?
Grazie in anticipo
GC
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[Qgis-user] XYZ Connection Referer

[Michel Stuyts]

In the settings of a XYZ Tiles Connection there is a setting called "Referer". 
What is it used for?


Michel
___
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] QGIS 3 Processing question

[Frank Broniewski]

Hi Nyall,

this works like a charm! Here's what I needed it for: Create polygon center 
lines in QGIS [1]. My script for processing is still quite rough around the 
edges and everywhere else and needs some testing, but I am getting results, 
thanks to you!

Many thanks,
Frank


[1] GIT 
https://github.com/frankbroniewski/polygoncenterline/blob/master/PolygonCenterline.py

-Ursprüngliche Nachricht-
Von: Nyall Dawson  
Gesendet: Dienstag, 3. Juli 2018 11:55
An: Frank Broniewski 
Cc: qgis-user 
Betreff: Re: [Qgis-user] QGIS 3 Processing question

> Nyall's tip with the temporary layer store just runs through nicely, but 
> nothing gets added to the layer pane after the script finished.

Sorry - missed something here. Because you're directly using the output from 
the child algorithm as your algorithm's final output, you should also pass the 
OUTPUT parameter value direct to the child algorithm. So in

>
>  def processAlgorithm(self, parameters, context, feedback):
>  # qgis:pointsalonglines
>  params = {
>  'INPUT': parameters[self.INPUT],
>  'DISTANCE': parameters[self.DISTANCE],
>  'START_OFFSET': 0,
>  'END_OFFSET': 0,
>  'OUTPUT': 'memory:'
>  }

 'OUTPUT': 'memory:'

should be

 'OUTPUT': parameters[self.OUTPUT]

Nyall


smime.p7s
Description: S/MIME cryptographic 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-user] Move multiple layer at the same time

[gam17]

Hi Marco,
   you can use qad plugin. If you are using spanish localization run
DESPLAZA command, if you are using english version run MOVE command.
For further info search "MOVE AUTOCAD" on the web.
bye
gam17

Use the 
> Hi All!
> 
> I would like to move multiple layers (point, line and polygon) at the
> same time in QGIS. Is it possible?
> 
> All layers are relatively georrefereced, and I want to change their
> locations at once, using known control points from one of the layers.
> 
> Best regards!
> ___
> 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
___
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] QGIS under LINUX in a workflow

[Nicolas Boisteault]

Hi,

You can try OSGeoLive in a virtualbox. Have a look at [1]

[1] : https://live.osgeo.org/en/quickstart/virtualbox_quickstart.html


Le 04/07/2018 à 08:30, Falk Huettmann a écrit :

Hi there,

if possible,
I would need and appreciate some pointers on how to run, and use, QGIS 
in LINUX.

A Windows10 set-up with LINUX would be a good way to go for us.

(Sorry of that appears to be a simple question, but we need a workflow 
and also
related to database handling, inputs and outputs via QGIS and with 
online data grabs).


I would welcome any feedback and input, as you can.

Thanks in advance; very best
   Falk Huettmann

​


___
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


___
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

[Qgis-user] Is there a way to create automated tests inside my own processing models?

[Carlos Cámara]

Dear all,

I am just starting with QGIS' processing to create some complex model which
makes quite a lot of changes and I would like to know if there is a way to
test my own model while launching it, so if the tests fail, I can get a
notification and I will know that something went wrong before I realize too
late and I have to lose any changes I made after executing the model with
unexpected results.

*Example*:

I am doing several joins and spatial joins. I learnt the hard way that
after triggering several times my model, every time I was joining layers,
new fields were added with a _1 appended to them in order not to overwrite
the previously created fields by mistake when I repeated the model. It
would be great to have some test that either checked all the layer's fields
or counted its number and, if they weren't as expected, triggered an
alarm/dialog box or created a log file.
Regards


Carlos Cámara
http://carloscamara.es
___
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

[Qgis-user] QGIS under LINUX in a workflow

[Falk Huettmann]

Hi there,

if possible,
I would need and appreciate some pointers on how to run, and use, QGIS in
LINUX.
A Windows10 set-up with LINUX would be a good way to go for us.

(Sorry of that appears to be a simple question, but we need a workflow and
also
related to database handling, inputs and outputs via QGIS and with online
data grabs).

I would welcome any feedback and input, as you can.

Thanks in advance; very best
   Falk Huettmann

​
___
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] Iterating two layers in Report - QGIS 3.2

[Frank Broniewski]

Hi Carlos,

 

did you find Nyalls excellent post on Reports in QGIS 3 already? I believe it 
explains what you want do achieve. Have a look at [1]

 

[1] 
https://north-road.com/2018/01/23/exploring-reports-in-qgis-3-0-the-ultimate-guide/

 

Hth,

Frank

 

Dipl. Geogr. Frank Broniewski

Waldhölzbacher Str. 51

66679 Losheim am See

06872 509 068 4

0176 611 26 9 2 6

  www.frankbroniewski.com

 

 

 

Von: Qgis-user  Im Auftrag von Carlos Cerdán
Gesendet: Dienstag, 3. Juli 2018 16:49
An: qgis-user@lists.osgeo.org
Betreff: [Qgis-user] Iterating two layers in Report - QGIS 3.2

 

Hi list

I would like to make a report (atlas) iterating two layers where:

1. Layer of level 2 administrative boundary is iterated (with atlas feature) 
and shows it as a no filled polygon, with out label;  and else polygons as 
white filled with labels;  and

2. Layer of administrative level 3 boundary is iterated too (with atlas 
feature), and shows labels only in polygons that are intersected or are within 
the active level 2 boundary.

How can be this done in QGIS 3.2? I was succsefull in QGIS 2.18, but now it 
doesn't work. I've tryed rules as:

 intersects(@atlas_geometry,$geometry )

contains(geometry(@atlas_feature),centroid( $geometry ) ) is true

but nothing.

 

I'm tring this because of non desired labels of level 3 boundary. One solutiion 
is using white labels that are fused with white polygons of level 2 boundary... 
but it is plan B.

 

Any advice please?

 

Cheers!

 

Carlos Cerdan

 



smime.p7s
Description: S/MIME cryptographic 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-user] NZ QGIS Users group

[Paolo Cavallini]

Thanks Brent for clarifying. We would be keen on having a NZ QUG, so
please consider our recommendations.
If you need help, just let us know.
All the best.

Il 04/07/2018 02:51, Brent Wood ha scritto:
> 
> 
> Hi,
> 
> I have just received this email from Paolo, and am forwarding it with a
> bit of a shotgun approach to try & get it to as many NZ QGIS users as I
> can. Apologies to those of you who get multiple copies.
> 
> This mailing list (qgis-us...@lists.niwa.co.nz
> ) is the only one I know of for NZ
> specific QGIS stuff... and it is not an "official" one... just what I
> have got running from NIWA (where I work).
> 
> The NIWA QGIS Teamworks page (
> https://teamwork.niwa.co.nz/display/NQUG/NIWA+QGIS+Users+Group ) is the
> closest thing I know of to a NZ QGIS Users web site... and input from
> anyone other than me is pretty minimal (as is any input from me really!)
> 
> There is no formal QGIS User Group in NZ, and as far as I'm aware,
> no-one with any interest is setting up a formal group with an elected
> representative.
> 
> The last message I got from Technology One, in NZ, who use QGIS as part
> of their GIS package, suggested that they are OK to work with a NZ USer
> Group, but will not be actively helping run such a group.
> 
> 
> Is anyone interested on putting in the time to setup & run a formal NZ
> QGIS Users Group? My impression is not really... but I could be mistaken
> :-) 
> 
> I suggest any replies/discussion is carried out on
> qgis-us...@lists.niwa.co.nz .
> Details on joining the list are at:
> https://teamwork.niwa.co.nz/display/NQUG/Join+the+NIWA+QGIS+User+Group+mailing+list
> There is not much traffic!!
> 
> 
> And one other question - is anyone else from NZ going to FOSS4G 2018 in
> Dar Es Salaam?
> 
> 
> Cheers,
> 
> Brent Wood (enthusiatic QGIS user :-)
> 
> 
> From: Paolo Cavallini 
> Sent: Wednesday, July 4, 2018 07:22
> To: Brent Wood
> Subject: NZ QGIS Users Group
> 
> Hi Brent,
> we are currently improving the management of the users groups. We are
> requesting all groups to:
> * have an elected representative (who will also become that groups
> voting member)
> * purchase of the country domain or similar with a page host.
> AFAICT, there is no NZ qgis domain. Would it be possible for you to
> purchase it? Please do not hesitate asking in case you need any assistance.
> All the best, and thanks.
> --
> Paolo Cavallini - www.faunalia.eu
> QGIS & PostGIS courses: http://www.faunalia.eu/training.html
> https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
> 
> 
> 
> 
> 


-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
https://www.google.com/trends/explore?date=all=IT=qgis,arcgis
___
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