Thanks for your response!
I think the most common case would be:
1. data in postgres database
2. editing done in qgis
3. viewing map and some selected graphs/tables in the web browser with
the ability to (for example) click on a feature and use that to filter
the data to only include data for
Message-
From: QGIS-Developer On Behalf Of
Janneke van Dijk via QGIS-Developer
Sent: Monday, 22 April 2024 12:34
To: qgis-develo...@lists.osgeo.org; qgis-user@lists.osgeo.org
Cc: Janneke van Dijk
Subject: [QGIS-Developer] web based spatial MIS/Dashboard
Dear QGIS developers and users,
In my
Dear QGIS developers and users,
In my work as a freelance GIS consultant I work with QGIS as much as
possible and try to convince clients that it will address all their GIS
needs despite not having to pay a license fee for it (and no, it is not
user unfriendly).
More and more, in addition
Dear all,
In Postgres, I have a parent table with geometry, and a child table
without. A relationship has been defined between the two which works for
the forms I'm using. I would like to be able to use the map to select
features in the parent table and the corresponding records in the child
> edit the ui file?
>
> HTH, Regards,
>
> Regards,
>
> Richard Duivenvoorde
>
> On 7/19/22 20:28, Janneke van Dijk via Qgis-user wrote:
> > Dear all,
> >
> > I need a date widget that can be set to a null date. From
> https://qgis.org/pyqgis/master/gui/Q
Dear all,
I need a date widget that can be set to a null date. From
https://qgis.org/pyqgis/master/gui/QgsDateEdit.html#module-QgsDateEdit I
understand that this should be possible (from 3.14 upwards). In Qt Designer
(osgeo4W/bin/qgis-designer.bat which I understand is shipped with QGIS
3.26) I
Dear all,
As a learning experience I am trying to make an application that was
developed with python 2 and qgis 2 with a postgres backend of vs 9.3
work with python 3/qgis 3/postgres 13.
As expected, there are plenty of places where it is still not working as
it should, but I have managed
Dear list,
I am following along with the (testing) QGIS server guide/manual hoping
I can get QGIS server to work on my windows laptop, using
https://docs.qgis.org/testing/en/docs/server_manual/getting_started.html
. I've installed XAMPP, and
version are
you using?
Alexandre Neto
On Thu, Sep 19, 2019 at 3:57 PM Janneke van Dijk
mailto:janneke.q...@gmail.com>> wrote:
Hi Alexandre,
Also thanks for the quick response!
What I can do with the DB manager is:
select location_point.geom, asset_point.a
Indeed
On 19/09/2019 17:56, DelazJ wrote:
You mean, it's the selected field in the primary key drop-down menu in
DB manager when you want to add the layer?
Le jeu. 19 sept. 2019 à 16:42, Janneke van Dijk
mailto:janneke.q...@gmail.com>> a écrit :
Hi Harrissou,
Thanks for the
Hi Alexandre,
Also thanks for the quick response!
What I can do with the DB manager is:
select location_point.geom, asset_point.assetid, location_point.fid
from asset_point cross join location_point on
asset_point.locationid =
location_point.fid
This should work, but why the
). You can use an ID field of your asset layer or
construct one with row_number function?
Regards,
Harrissou
Le jeu. 19 sept. 2019 à 16:10, Janneke van Dijk
mailto:janneke.q...@gmail.com>> a écrit :
Dear list,
I have a parent - child relationship set up between a table
locat
Dear list,
I have a parent - child relationship set up between a table location (1,
the parent) and a table assets (many, the child). The location table
contains geometry, the asset table does not. I would like to be able to
display each record in the asset table with the corresponding
a ticket for that?
Thanks a lot
Matthias
On 9/18/19 3:00 PM, Janneke van Dijk wrote:
Dear List,
The work around seems to be to save the style as .qml and then load
it for the other layer. I would still like to know if it is expected
that copy style does not work in this case or that this is a bug
Dear List,
The work around seems to be to save the style as .qml and then load it
for the other layer. I would still like to know if it is expected that
copy style does not work in this case or that this is a bug.
thanks,
Janneke
On 18/09/2019 15:56, Janneke van Dijk wrote:
Dear List,
I
Dear List,
I have prepared a drag and drop designer form with several containers,
and I would like to use the same form for another table with the same
structure. Both tables do not contain geometry and are layers in two
different geopackage files. I thought it should be possible to click
Dear all,
I will be getting data from the field (geopackage files) on a regular
basis and need to join them to the 'masterfile' and update a few column
values based on the joined attribute values. This works fine manually,
either by using the field calculator or the update bar with the table
Dear list,
I would like to make an existing field in a geopackage layer unique - it
does not contain any data at the moment. In the DB Manager (both QGIS
2.18 and 3.4 on Windows 10) I have tried many variations of the below:
ALTER TABLE 'RUJWASCO_follow_up' ADD CONSTRAINT 'result_account_uq'
table. Sorry for the noise. It's a great tool!
Janneke
On 11/02/2019 15:02, Janneke van Dijk wrote:
Dear list,
I just discovered that QGIS 3 has the nice option to add ellipses in
the editing toolbar. Does this just add a graphic to the map? I was
hoping I could add a polygon in the shape
Dear list,
I just discovered that QGIS 3 has the nice option to add ellipses in the
editing toolbar. Does this just add a graphic to the map? I was hoping I
could add a polygon in the shape of an ellipse to a vector layer. I have
tried both with a shape file (polygon) and with a geopackage
Hi Claas,
Indeed that worked Thank you so much. Any idea if it's already in
the documentation somewhere (in which case I clearly didn't read the
manual...)? Otherwise I'll include that on my to do list.
Again, thanks,
Janneke
On 08/02/2019 00:47, Claas Leiner wrote:
Hi Janneke
in a
Dear list,
Could anybody maybe help me understand what I'm doing wrong (or even
tell me that what I want to do can't be done)?
This is what I'm trying to do. I have a spatialite layer with columns
north and east which contain coordinates in decimal degrees. I would
like to be able to change
:58 AM Janneke van Dijk
mailto:janneke.q...@gmail.com>> wrote:
Dear list,
I have just downloaded the latest QGIS version for Windows (3.4.4
- LTR)
and it doesn't show the menu for processing. The plugin is active.
Any
idea if I need to do something to 'switch it on'?
Dear list,
I have just downloaded the latest QGIS version for Windows (3.4.4 - LTR)
and it doesn't show the menu for processing. The plugin is active. Any
idea if I need to do something to 'switch it on'?
thanks,
Janneke
___
Qgis-user mailing
w pull request"
3. Click "Compare accross forks" and select your repo in the head fork
drop down menu and then the your branch (janneke-qgis-patch-1 in this
case)
4. Press "Create pull request"
5. And you are done!
H.
Le mer. 9 janv. 2019 à 18:46, Janneke van Dijk <mai
Dear all,
I'm testing the training manual (QGIS 3) and think I ran into a bug -
unless I am misunderstanding something. I am doing the following, QGIS
3.4.3 on Windows:
1. Processing>Raster terrain analysis>Aspect: use the
exercise_data\raster\SRTM\srtm_41_19.tif DEM as an input and use the
-1 in this
case)
4. Press "Create pull request"
5. And you are done!
H.
Le mer. 9 janv. 2019 à 18:46, Janneke van Dijk <mailto:janneke.q...@gmail.com>> a écrit :
Hi Alexandre and Harrissou (and others),
I'm trying to feel my way through the contribution thing and
.
A seg, 7/01/2019, 18:17, Janneke van Dijk <mailto:janneke.q...@gmail.com>> escreveu:
Yes, I would be up for learning how to do it. I remember once upon
a time trying to get started and somehow getting stranded before I
got anywhere. Partly because I couldn't get linu
:senhor.n...@gmail.com>> escreveu:
I can do it.
A seg, 7/01/2019, 13:43, Janneke van Dijk
mailto:janneke.q...@gmail.com>> escreveu:
I've registered all that I've noticed, I just didn't
manage to tag them with trainin
that is a bug, or a possible improvement. That way we won't
forget.
Thanks!
A dom, 6/01/2019, 10:07, Janneke van Dijk <mailto:janneke.q...@gmail.com>> escreveu:
Hi Harrissou,
Getting ready to at least list my observations. Do I understand it
correctly that whatever is not
] https://github.com/qgis/QGIS-Training-Data/pull/17
Regards,
Harrissou
Le jeu. 3 janv. 2019 à 13:22, Janneke van Dijk <mailto:janneke.q...@gmail.com>> a écrit :
Dear all,
I'm currently going through the QGIS 3 training manual
(https://docs.qgis.org/testing/en/docs/traini
Dear all,
I'm currently going through the QGIS 3 training manual
(https://docs.qgis.org/testing/en/docs/training_manual/) using QGIS
3.4.3 and documenting any changes that would still need attention. I
understand that it's a work in progress and hope/plan to contribute a
bit in a later
Dear Edrouin,
I just had the same issue, trying to get qfield to work. I used the
QFieldSync plugin and copied the whole project folder in
Android\data\ch.opengis.qfield\files (on the SDcard - though it's
formatted as internal SD card) and it would not show the folder. I then
copied the
I just tested here and all I can do is to add a virtual field to the
csv, but not actually write in the file.
Cheers
Stéphane
Le lundi 29 mai 2017, Janneke van Dijk <janneke.q...@gmail.com
<mailto:janneke.q...@gmail.com>> a écrit :
Dear all,
Using Qgis 2.18.9 on Window
Dear all,
Using Qgis 2.18.9 on Windows (OSGeo4W64) I'm trying to import a .csv
file and adding a text field. This is what I do:
1. add the .csv using add vector layer
2. open attribute table then use the field calculator
3. add text field, OK
4. toggle editing, save edits when asked.
I then
Dear list,
First, I'm not sure this is a question for the user list or the
developer list so I send it to both.
In the attached project with test shapefile I have a shapefile with
three virtual fields (integers). The first two virtual fields (vTest and
vTest2) contain expressions to assign
Hi Yann,
I had this the other day. With me it was caused by a new line character
in one of the fields in the database, causing the line to be split over
two lines. As my data were in Postgres I was able to clean up my data by
using:
update mytable set myfield = regexp_replace(myfield,
Matthias
On 11/29/2015 10:03 PM, Janneke van Dijk wrote:
Hi Jürgen,
After your remarks I thought I would try the individual update
statements (7000 of them ) directly on postgres. Indeed, that gives
an out of memory error after 10 minutes. Not sure if that is entirely
up to the expensive view
:
Hi Janneke,
On Sun, 29. Nov 2015 at 20:44:54 +0300, Janneke van Dijk wrote:
Using the field calculator either from the attribute table or from main
window with the attribute table closed both takes too long to be useful. Not
the actual calculation, but the saving of the edits. To be clear: I
al factors:
How long does it take with the field calculator and the attribute
table closed?
(There have been some bottlenecks for updating the table in the past)
How long is the network latency (a simple "ping [server]" gives
already a good hint)
Best
Matthias
On 11/29/2015 04:42 PM, Ja
clause for making the selection maybe)?
greetings,
Janneke
On 28/11/2015 01:42, Nyall Dawson wrote:
On 27 Nov 2015 10:18 PM, "Janneke van Dijk" <janneke.q...@gmail.com
<mailto:janneke.q...@gmail.com>> wrote:
>
> Dear list,
>
> I have an updateable spatial view
Dear list,
I have an updateable spatial view in Postgres loaded into QGIS 2.10.
When I update 6999 records in this view in the db manager with the
following statement:
update v_prepare_assessment_id SET districtid = 8 where locationid >
13000 and locationid < 2
it takes 2.7 seconds to
TILE
Users cannot manipulate the value of the id field anymore neither when
INSERTing nor when UPDATEing.
Bernhard
Am 25.11.2015 um 20:14 schrieb Janneke van Dijk:
Dear all,
When using the split features tool in 2.10 and 2.12 on a postgres layer
(both on windows 7 and windows xp) I receive th
Dear all,
When using the split features tool in 2.10 and 2.12 on a postgres layer
(both on windows 7 and windows xp) I receive the following error after
trying to save the edits:
"
Could not commit changes to layer a_streets
Errors: ERROR: 1 feature(s) not added.
Provider errors:
PostGIS
database
in respect to constraints, default values, data types.
regards
Bernhard
[1] http://plugins.qgis.org/plugins/DataDrivenInputMask/
Am 21.12.2014 15:44, schrieb Janneke van Dijk:
Dear all,
I have set up a form in QGIS 2.6 using the attribute editor layout
'autogenerate', to edit
if the problem is still
arising.
Bernhard
Am 22.12.2014 09:09, schrieb Janneke van Dijk:
Hello Bernhard,
Thanks for the suggestion. I just installed the plugin. When selecting a
table and trying to initialise the layer I get a Database Error: syntax
error at or near (
LINE1: EXECUTE ('public
Dear all,
I have set up a form in QGIS 2.6 using the attribute editor layout
'autogenerate', to edit an editable view in a postgres database. This works
nicely. I would like to use this form to edit data in other databases that
have an identical structure. Ideally, I would set up a project file
Does anyone know of a workaround? Matt Boyd suggested saving images and
loading them for these specific zoomlevels - could anyone tell me how to
go about that (and is it allowed under the Google terms)?
Janneke
On 04/04/2013 00:07, AntonioLocandro wrote:
I confirm this on latest QGIS master
Currently WGS84 unprojected, but that doesn't seem to be related to the
issue, as the alignment is fine until you zoom in below 1:1000 roughly.
Janneke
On 04/04/2013 10:08, Jesus Munoz Serrano wrote:
what CRS are you using?
- jesus
On 4 Apr 2013, at 08:19, Janneke van Dijk wrote
49 matches
Mail list logo