Re: [Qgis-user] web based spatial MIS/Dashboard
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 that feature in the graphs/tables/other dashboard items, or be able to select from a drop down list and use that as a filter. Which indeed corresponds to your Scenario 2. If I understand this correctly, you will always need to program the HTML frontend to communicate with the backend, and there are no tools that let you automagically configure the html front end with dragging and dropping a map widget and a graph widget with some settings for data sources? I guess what clients might be asking for is the equivalent of ArcGIS dashboards... I have not worked with it, but from the docs it seems to be the type of functionality clients have on their wish list, where no coding is required to publish a map with some corresponding indicators. (https://www.arcgis.com/apps/dashboards/7edefc1970d44b839ebbfd7b45e51e2d for example). So maybe my questions are on two levels: - what would someone need to do to create something with a similar result (any recommended tools/libraries/languages - Rosa just recommended some) - is it desirable to have an Open Source tool that allows for creating something with that functionality without the need for coding? And if so, what would be the way to go about it? Which would maybe be more of a discussion rather than a technical question. cheers! Janneke On 22/04/2024 15:30, rsantell wrote: and where selecting a feature on the map will update the graphs and charts in the dashboard Selecting a feature on which map? The QGIS map view? The HTML frontend? >From your description, I guess you're after a system with two frontends, one for editors (users that create and manage the data) and one for consumers (users who view the data, and perhaps performs very limited editing such as updating attributes). In that case, depending on your budget and available skillset, etc.: ## Scenario 1: * Editors use QGIS as normal * Consumers: - use an HTML visualisation exported via qgis2web (https://github.com/qgis2web/qgis2web), or - use a stripped down version of QGIS consisting of a map canvas plus whatever controls may be necessary (requires Python skills) ## Scenario 2: * PostGIS (or Spatialite) are used as the backend * Editors use QGIS as normal * Consumers use an OpenLayers-powered HTML frontend communicating with a backend (NodeJS, Python, Go, etc., etc.) that communicates with the RDBMS backend. If no consumer editing is required at all, qgis2web is the cheapest and quickest solution. ___ 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-Developer] web based spatial MIS/Dashboard
Hi Rosa, thanks for the quick response - I am also not sure exactly what my question is, so all answers are probably helpful. I am now having a look at streamlit and seeing if that helps me get a better picture. It's definitely interesting! cheers from Tz :-) Janneke On 22/04/2024 14:11, Aguilar Bolivar, Rosa (UT-ITC) wrote: Hi, Janneke I am, not sure whether I understood your question correctly. For a web app with dashboard you may need a data server + app server + front-end There are several libraries that you can use to create what you want. I have use D3 and openlayers for the front-end (interactive select + doing something) Porgresql as DB server and QGIS server (Geoserver is a common option) https://streamlit.io/ is gaining traction and something you may want to look at it. Hope this helps, Cheers from NL. Rosa - Dr. Rosa Aguilar University of Twente Faculty of Geoinformation Science and Earth Observation Connect with me on LinkedIn https://rosaguilar.github.io/ - The essential is invisible to the eye. Saint-Exupéry -Original 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 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 to wanting 'a GIS system', there are requests for a web based management information system which shows both maps and a dashboard with selected KPIs, and where selecting a feature on the map will update the graphs and charts in the dashboard. So far, I have not been able to find out if this is possible using Open Source software, what it would require in terms of setting it up/configuring/additional development. I assume it is technically possible to develop it. Does anyone have experience with this? How did you set it up? Any examples I could have a look at? I guess strictly speaking it is not a QGIS question, but seeing that some other proprietary GIS software vendors are offering web dashboard functionality 'out of the box' it does get associated with the GIS software procured. Is there a demand for it (from my limited view - yes)? Are there thoughts about developing such functionality more 'out of the box' within the QGIS community? What would such development require? My impression is that there is more (very tentative) willingness from donors to consider contributing to Open Source software development as part of development projects, but it may mean that it would need to be written into tender proposals with indicative figures for the required funding. I have a limited understanding of what is out there (I've just dabbled (so far unsuccesfully) with chartbrew and grafana the past few days to see how dashboard creation works) so I am not sure what are the right questions to ask. I realise my questions are still rather broad. I have some time at hand so I would be available to do more research and become more specific if there is an interest in this topic. Looking forward to your ideas! Janneke ___ QGIS-Developer mailing list qgis-develo...@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer ___ 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] web based spatial MIS/Dashboard
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 to wanting 'a GIS system', there are requests for a web based management information system which shows both maps and a dashboard with selected KPIs, and where selecting a feature on the map will update the graphs and charts in the dashboard. So far, I have not been able to find out if this is possible using Open Source software, what it would require in terms of setting it up/configuring/additional development. I assume it is technically possible to develop it. Does anyone have experience with this? How did you set it up? Any examples I could have a look at? I guess strictly speaking it is not a QGIS question, but seeing that some other proprietary GIS software vendors are offering web dashboard functionality 'out of the box' it does get associated with the GIS software procured. Is there a demand for it (from my limited view - yes)? Are there thoughts about developing such functionality more 'out of the box' within the QGIS community? What would such development require? My impression is that there is more (very tentative) willingness from donors to consider contributing to Open Source software development as part of development projects, but it may mean that it would need to be written into tender proposals with indicative figures for the required funding. I have a limited understanding of what is out there (I've just dabbled (so far unsuccesfully) with chartbrew and grafana the past few days to see how dashboard creation works) so I am not sure what are the right questions to ask. I realise my questions are still rather broad. I have some time at hand so I would be available to do more research and become more specific if there is an interest in this topic. Looking forward to your ideas! Janneke ___ 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] spatial selection in parent table to edit records in child table without geometry
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 table, in order to be able to edit the selected child records. I know I can create an updateable view in postgres that would achieve this. Is there a better/easier way to do it? A way to let the child layer inherit the geometry from the parent? I first thought to join the parent table to the child table, but that only joins the attributes, and doesn't make the child table spatially selectable. Using the db manager to create a virtual layer gives the correct query result, but the loaded layer is not editable (as to be expected, I think) and the attribute table is empty (maybe not expected). I have the suspicion that this should be straightforward and I am just overlooking the obvious. Any pointers/thoughts are appreciated. Thank you, Janneke ___ 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] qt designer does not have/show QgsDateEdit widget
Hi Richard and Andrea (and others),
thanks for clarifying/confirming - then it is not something I
misunderstood. I originally had the QDateEdit widget, which was working,
but giving a warning that it will not accept NULL values. As I would like
to be able to set it to NULL I thought of using QgsDateEdit. I have now
indeed managed to instead format the QgsDateTimeEdit widget to only show
the date, which will do for my purpose.
I am now trying to adjust the code that was working for QDateEdit to work
for the QgsDateTimeEdit with the following function that gets called
clicking a button. The first message will display the time and date
correctly, so 'now' seems to have the correct value. The second message
does not get displayed, but I also do not get an error message, and the
date does not get changed. Which makes me believe
"self.assesmentdate.setDateTime(now)" is not correct.
def assesmentdate_now(self):
if self and self.layer.isEditable():
now = QtCore.QDateTime.currentDateTime()
QgsMessageLog.logMessage(now.toString(), 'MyPlugin',
level=Qgis.Info)
self.assesmentdate.setDateTime(now)
QgsMessageLog.logMessage('test', 'MyPlugin', level=Qgis.Info)
What would be the correct syntax for setting the QgsDateTimeEdit widget to
show the current date? Or does anyone have ideas how I can find out what's
happening, seeing that I am not getting error messages? The script gets
called by the attribute form.
Thanks for any thoughts,
Janneke
On Wed, Jul 20, 2022 at 10:44 AM Richard Duivenvoorde
wrote:
> Hi Janneke,
>
> I'm on master here with designer with all qgs widgets, and I do not have
> it either.
>
> When I create a form though, with a field which has a datetime field, I
> CAN set the 'Field Format' to 'Date'-only...
>
> So maybe there is some extra sip/development work needed to make this
> widget also available in QtDesigner?
> (try to ask this question on the defv list?)
>
> Or (not tested), maybe you can create an ui iwth QgsDateTime, and manually
> 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/QgsDateEdit.html#module-QgsDateEdit <
> 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 only see the QgsDateTimeEdit widget.
> >
> > image.png
> >
> > How can I use the QgsDateEdit widget?
>
___
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] qt designer does not have/show QgsDateEdit widget
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 only see the QgsDateTimeEdit widget. [image: image.png] How can I use the QgsDateEdit widget? Thanks for your assistance, Janneke ___ 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] changed relationship behaviour between qgis 2.x and 3.x?
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 to upgrade the database, open the project file in qgis 3.16, and all the layers (based on views) have loaded correctly. The relationships that were stored in the project file also seem to be working correctly with the existing .ui files. I can open the parent layer form, and in the child form I can see the foreign key reflected properly, and changing as the selected parent feature is changed. All the relationship settings were set manually and stored in the project file. When I change the column preview on the left hand side of the form from parentid to any other column, the child form still shows the parentid correctly. For testing/learning purposed I did the whole process manually from scratch in 3.16. When I now open the parent layer form, and set the column preview on the left of the form to anything else than the parentid, in the child form, where I would have expected the parentid as before, it shows the column used in the column preview. Is this the expected behaviour? Is it possible to set this to the 'old' behavior? If so, can that also be done using python (ultimately I want to load the layers and create the relationships in python)? Below some screenshots to clarify what I described. Thanks for your help, Janneke Original situation (A), behaviour as expected: A) With locationid as column preview shows corresponding locationid in child form (the number 1) The same when changing the column preview: (now locationid in child form is number 11288) B) Manually newly created relationships, with column preview of the parent id shows it in the child form (note that there seems to be a box in front of another box, in another situation I have seen it looking like a greyed out combo box) With the newly created relationship, when selecting districtid as a column preview, it is the district id that is shown in the child form, not the locationid. ___ 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] getting started with qgis server - countries layer not showing
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 http://localhost/cgi-bin/qgis_mapserv.fcgi.exe?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities seems to be working (I get the capabilities). I then downloaded the training data (as instructed) from https://github.com/qgis/QGIS-Training-Data/archive/v2.0.zip and unzipped them into a folder and set the QGIS_PROJECT_FILE variable to point to the world.qgs file. The guide continues with: http://localhost/qgisserver? MAP=/home/qgis/projects/world.qgs& LAYERS=countries& SERVICE=WMS& REQUEST=GetMap& CRS=EPSG:4326& WIDTH=400& HEIGHT=200 In Firefox, when I adjust that to: https://localhost/cgi-bin/qgis_mapserv.fcgi.exe?LAYERS=airports&SERVICE=WMS&REQUEST=GetMap&CRS=EPSG:4326&WIDTH=400&HEIGHT=200 I get a white rectangle with some airplanes in the top left corner - I think that means success (for now at least). When I replace 'airports' with 'places' it shows the same rectangle, but with circles in the top left corner - also success, more or less. When I replace 'airports' with 'countries' I only get to see the white rectangle, and no countries. What could be the reason that I do not get to see the countries? How do I go about troubleshooting this? When I open the project file directly in QGIS I get to see all the layers and they all look as I would expect them to look. When I open a separate qgis desktop blank project, and start adding the layers as WMS I have other issues: adding each layer with epsg:3857 the layers overlay nicely with each other and a google hybrid layer. Adding them with epsg:4326 (and setting the project CRS to 4326) it seems as if the map gets squeezed from the sides, so the world map looks higher than it is wide (in the example in the tutorial it's wider than it's tall). When trying to zoom in on Europe it will 'jump' to Asia. This seems to suggest that the WMS is more or less working (it can be reached from the browser) but it needs certain settings to work properly? I am entirely new to QGIS server and any pointers to understand what it is that I'm looking for would be greatly appreciated. Does anyone else working with the same data manage to display the countries layer in a browser? Working with qgis server and desktop LTR from OSGeo4W64 on Windows 10. Thanks, Janneke ___ 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] 1 to many relationship does not allow to display the many
3.6, but will check when I have time later tonight and see if other versions show the same issue. And will create a sample project with bug report. Thanks! Janneke On 19/09/2019 18:04, Alexandre Neto wrote: It sounds like a bug... Can you provide a data sample and project. Also, what QGIS 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.assetid, location_point.fid from asset_point cross join location_point on asset_point.locationid = location_point.fid This should work, but why the CROSS JOIN? a simple join should be enough. I first had a simple join, then saw an example of a cross join and tried that in the hope that that would make a difference. this query yields 170 records, corresponding with the number of records in the assets table. When I load as a new layer, the result is a table with 170 records, but 100 filtered (the total number of locations). I chose assetid to be the unique id (which it is). Is that expected behaviour? How else can I display all the records in the assets table (instead of only the 100 that are filtered now)? I know I can do it in Postgres but for my purpose now I don't want to go there. An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location. I have a relationship, and the assets will show up in the form of the location when you click on the location (including locations with several). However, it doesn't allow me to label the location with information from the assets, or create symbology based on asset information. What puzzles me is that the query results in 170 records, I would have expected the geometry to be joined to each of the 170 attribute records and then be displayed - so where does the filter with a 100 suddenly come from? (Is this a bug?) As a work around I think I could get xy coordinates of the location, then join them to the assets, export to csv and import again as a delimited text layer for display purposes. I was hoping someone could either explain why this result makes sense, or that I just made a mistake somewhere...any more thoughts? Thanks for sharing your thoughts! Janneke Alexandre Neto ___ 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] 1 to many relationship does not allow to display the many
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 quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas... Janneke On 19/09/2019 17:31, DelazJ wrote: Hi Janneke, Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). 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 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 geometry of the location table - so if there are 3 assets at a certain location, I would like to display 3 points (each with identical geometry). 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 query yields 170 records, corresponding with the number of records in the assets table. When I load as a new layer, the result is a table with 170 records, but 100 filtered (the total number of locations). I chose assetid to be the unique id (which it is). Is that expected behaviour? How else can I display all the records in the assets table (instead of only the 100 that are filtered now)? I know I can do it in Postgres but for my purpose now I don't want to go there. Any insights deeply appreciated! Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto: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] 1 to many relationship does not allow to display the many
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 CROSS JOIN? a simple join should be enough. I first had a simple join, then saw an example of a cross join and tried that in the hope that that would make a difference. this query yields 170 records, corresponding with the number of records in the assets table. When I load as a new layer, the result is a table with 170 records, but 100 filtered (the total number of locations). I chose assetid to be the unique id (which it is). Is that expected behaviour? How else can I display all the records in the assets table (instead of only the 100 that are filtered now)? I know I can do it in Postgres but for my purpose now I don't want to go there. An alternative is to create a relation between the two tables, the assets will show in the location feature form. You can even add more assets to a certain location. I have a relationship, and the assets will show up in the form of the location when you click on the location (including locations with several). However, it doesn't allow me to label the location with information from the assets, or create symbology based on asset information. What puzzles me is that the query results in 170 records, I would have expected the geometry to be joined to each of the 170 attribute records and then be displayed - so where does the filter with a 100 suddenly come from? (Is this a bug?) As a work around I think I could get xy coordinates of the location, then join them to the assets, export to csv and import again as a delimited text layer for display purposes. I was hoping someone could either explain why this result makes sense, or that I just made a mistake somewhere...any more thoughts? Thanks for sharing your thoughts! Janneke Alexandre Neto ___ 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] 1 to many relationship does not allow to display the many
Hi Harrissou, Thanks for the quick response - indeed, I indicated the assetid which is a unique value. That did not solve the problem, alas... Janneke On 19/09/2019 17:31, DelazJ wrote: Hi Janneke, Maybe you need a field that would uniquely identify the 170 asset rows (their primary key). 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 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 geometry of the location table - so if there are 3 assets at a certain location, I would like to display 3 points (each with identical geometry). 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 query yields 170 records, corresponding with the number of records in the assets table. When I load as a new layer, the result is a table with 170 records, but 100 filtered (the total number of locations). I chose assetid to be the unique id (which it is). Is that expected behaviour? How else can I display all the records in the assets table (instead of only the 100 that are filtered now)? I know I can do it in Postgres but for my purpose now I don't want to go there. Any insights deeply appreciated! Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto: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] 1 to many relationship does not allow to display the many
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 geometry of the location table - so if there are 3 assets at a certain location, I would like to display 3 points (each with identical geometry). 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 query yields 170 records, corresponding with the number of records in the assets table. When I load as a new layer, the result is a table with 170 records, but 100 filtered (the total number of locations). I chose assetid to be the unique id (which it is). Is that expected behaviour? How else can I display all the records in the assets table (instead of only the 100 that are filtered now)? I know I can do it in Postgres but for my purpose now I don't want to go there. Any insights deeply appreciated! Janneke ___ 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 copy style form from one attribute table to another (both no geometry) does not seem to work
Thanks for confirming, Matthias (and bummer - I was hoping I had overlooked something :-) ). Will open a ticket. Janneke On 18/09/2019 16:38, Matthias Kuhn wrote: Hi Janneke, Sounds very much like a bug to me (or a very desirable feature, depending on the point of view). Can you open 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. thanks, Janneke On 18/09/2019 15:56, Janneke van Dijk wrote: 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 Style>copy>all on the layer containing the correct form, then Style>paste>all on the layer where I would like to have the drag and drop form. When I do it, nothing seems to happen - the form remains 'autogenerate' with all attributes listed. Should this work? Should I do something else? File a bug report? Is there a work around? Thanks for thinking along, Janneke ___ 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 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 copy style form from one attribute table to another (both no geometry) does not seem to work
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 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 Style>copy>all on the layer containing the correct form, then Style>paste>all on the layer where I would like to have the drag and drop form. When I do it, nothing seems to happen - the form remains 'autogenerate' with all attributes listed. Should this work? Should I do something else? File a bug report? Is there a work around? Thanks for thinking along, Janneke ___ 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 3 copy style form from one attribute table to another (both no geometry) does not seem to work
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 Style>copy>all on the layer containing the correct form, then Style>paste>all on the layer where I would like to have the drag and drop form. When I do it, nothing seems to happen - the form remains 'autogenerate' with all attributes listed. Should this work? Should I do something else? File a bug report? Is there a work around? Thanks for thinking along, Janneke ___ 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] automating the updating of records in existing layer using values from a joined layer
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 in editing mode. I would like to automate parts of this process and am getting stuck in different attempts. 1. In the model builder, I cannot figure out how to make the field calculator take only the selected records to be updated, and I cannot figure out how to make it update records in the existing layer as opposed to creating a new layer. Is this even possible? 2. In DB manager, I can select the joined masterfile (with fieldwork file) as a virtual layer (selects 174 rows, including the joined attributes) select * from masterfile where fld_date_updated > '2019-07-19' but I get a syntax error in the update statement: update masterfile set result_account = fld_result_account where fld_date_updated > '2019-07-19' "Query execution error on CREATE TEMP VIEW _tview AS update masterfile set result_account = fld_result_account where fld_date_updated > '2019-07-19': 1 - near "update": syntax error" I can not find the syntax error. Is this because it's a virtual layer and it cannot be updated? Is there a way to update records in virtual layers? 3. In DB manager, if I make a connection under geopackage with the master file, I am not able to make a join with the virtual layer with the field data, it will not recognise the field layer. I am a bit baffled, as I would think this should be something straightforward. Is what I want possible, using either the model builder or the db manager and a reusable sql script? Or is it not possible to semi-automatically update records from within QGIS without having to create a new output file? Using QGIS 3.8.1 (osgeo installer) 64 bit on windows 10 Thanks for any insights, Janneke ___ 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] add unique constraint to geopackage in QGIS DB Manager
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'
UNIQUE('result_account');
I have written it without quotes, with double quotes, some with some
without single and double quotes. I have written it with a space between
UNIQUE and the bracket. First question is: is it possible to add a
unique constraint to a geopackage layer? If yes, my second question is -
what would be the correct syntax? (And maybe: where can I find
documentation about geopackage sql syntax?).
Thanks for any insights...
Janneke
___
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.4.4 add ellipse
Ok, I have no idea what went wrong the first time - I just ended up with lots of graphics and no records in tables - but starting a new project, creating a new geopackage with regular polygon as geometry type the tool now works as I expected - geometries and records are added to the attribute 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 of an ellipse to a vector layer. I have tried both with a shape file (polygon) and with a geopackage (curved polygon). What I do: 1. activate the empty polygon layer 2. toggle editing 3. use add ellipse from extent - draw ellips 4. toggle editing - no question to save the edits, and no record added to the vector layer. Is it not supposed to add a record to the layer? Thanks for any help! Janneke ___ 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 3.4.4 add ellipse
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 (curved polygon). What I do: 1. activate the empty polygon layer 2. toggle editing 3. use add ellipse from extent - draw ellips 4. toggle editing - no question to save the edits, and no record added to the vector layer. Is it not supposed to add a record to the layer? Thanks for any help! Janneke ___ 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] spatialite with update trigger seems to result in 'unselectable' geometry
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 similar problem,
it helped to update the spatial index:
-
CREATE TRIGGER update_geom AFTER UPDATE ON watersources BEGIN
UPDATE watersources SET geom = Transform(MakePoint(east, north, 4326),
32638) WHERE id=1678;
-- I have done this in my trigger
Select recoverSpatialIndex('watersources','geom');
SELECT UpdateLayerStatistics('watersources');
END
___
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] spatialite with update trigger seems to result in 'unselectable' geometry
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 the coordinates in the attribute table and have the trigger take care of updating the geometry based on the new coordinates. The following update statement, using the DB manager: UPDATE watersources SET geom = Transform(MakePoint(east, north, 4326), 32638) WHERE id=1678; works as expected: after saving the edits, the point will appear in the new location based on the changed coordinates, and I can select the point in the map and I can use the identify button to open the form at that point. If (by way of a test) I use the same statement inside a trigger (and I realise this is not ultimately how I would want to define the trigger, but I'm trying to understand the different effects of the same update statement): CREATE TRIGGER update_geom AFTER UPDATE ON watersources BEGIN UPDATE watersources SET geom = Transform(MakePoint(east, north, 4326), 32638) WHERE id=1678; END I can change the coordinates, save the changes and stop editing, the point will indeed appear in the new location, but I can't select it in the map, or use the identify feature to open the form. I can locate it in the attribute table and select it and use 'zoom to selected' after which the map will center on the selected point (but not zoom in). After running the update statement 'stand alone' again, all works as expected again. Does anyone have an idea why this could happen? Has anyone tried doing something similar in spatialite and gotten it to work? Any tips on how I could troubleshoot this? I have a test file with only 4 points that I could share if that helps. Using QGIS 3.4.4. on Windows 10. Any help/thoughts will be appreciated! Thanks, Janneke ___ 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] can't find processing in QGIS 3.4.4 LTR
Hi Saulteau, I had looked in Panels and it didn't show up there. I ended up uninstalling 3.4.4, reinstalling 3.4.3 (because I needed to finish something using processing), and then uninstalling 3.4.3 and reinstalling 3.4.4 - intending to test your other suggestions - but this time the processing menu was back and all worked. I have no idea what happened with the first installation, but anybody running into the same issue can try reinstalling 3.4.4 first. Thanks for the help! Janneke On 29/01/2019 21:46, Saulteau Don wrote: Hey Janneke, I use linux so the menus might be a little different for you. But at the top menus, look for Settings > Panels > Processing Toolbox Panel On Windows the Panels sub-menu might be in another place like View instead of Settings. Another easy way to turn on the processing toolbox is to right click on an empty space in the user interface (on a grey spot near another toolbar for example) and there is a menu that pops up with 'Processing Toolbox Panel' to toggle on and off. Lastly, the tools can be searched at the bottom left of QGIS (hotkey CTRL+K) which is what I tend to use quite a bit. On Tue, Jan 29, 2019 at 3: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'? thanks, Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto: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] can't find processing in QGIS 3.4.4 LTR
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 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-community-team] training manual QGIS 3
Hi Harrissou and others, With your steps described below it was perfectly clear what I had to do, no confusion in my mind whatsoever. So I just tried to compare it to the documentation (link: https://docs.qgis.org/testing/en/docs/documentation_guidelines/first_contribution.html#share-your-changes-via-pull-request) <https://docs.qgis.org/testing/en/docs/documentation_guidelines/first_contribution.html#share-your-changes-via-pull-request> and will try to describe what according to me was not clear in the documentation. In the documentation, I had arrived at step 1, second bullet point, where it says "you therefore need to leave that page and follow the next step". Then, moving to the next step (2) it says "you can create a new pull request at any moment from many pages" - which "tricked" me into pressing the button "new pull request" from my own page - and I think the compare across forks option is either not there, or maybe it is not so obvious, and the "if needed" addition made it sound it might not be that important to click the compare across forks. Once you do click "compare across forks" it is more clear that what I thought was the actual "master" was just my own master, not qgis master. For me, as a complete beginner, I would prefer the method you describe below (1. 2. 3. off you go) if it is a fool-proof way of creating your pull request. I do not necessarily need to know about all the other ways. Would it be possible/make sense to maybe have a simple workflow that always works (even if it is not the most efficient one) and separately discuss alternative methods? I'll come back to the fix me button in another mail. Janneke On 09/01/2019 21:01, DelazJ wrote: Hi Janneke, I guess you are talking about https://github.com/janneke-qgis/QGIS-Documentation/pull/1 which is unfortunately a pull-request against your own branch and not the upstream one. This is a trap we all fall in at the beginning and mentioned at https://docs.qgis.org/testing/en/docs/documentation_guidelines/first_contribution.html#share-your-changes-via-pull-request What you have to do is also explained in the page I linked above (if ever not clear, let us know, we'll try to improve it) but in short: 1. Go to https://github.com/qgis/QGIS-Documentation/pulls 2. Press "New 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 <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 github by starting with some small remarks/changes I suggested myself. I think I have just made an edit and created a pull request - it tells me 'This branch has no conflicts with the base branch'. Not sure how to proceed from here. Is this enough from my side? Thanks for some guidance Janneke On 07/01/2019 23:27, Alexandre Neto wrote: Screenshots shouldn't be a blocker, you can take screenshots using windows. Then, if we have time, we can replace windows screenshots later. 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 linux to work on VM on my laptop so I couldn't do the screen shots. On 07/01/2019 17:39, Alexandre Neto wrote: Some of those changes are quite small. Would you be interested in learning how to fix it yourself? A seg, 7/01/2019, 14:37, Alexandre Neto mailto:senhor.n...@gmail.com>> escreveu: Actually, someone already did it. Thanks!! A seg, 7/01/2019, 14:37, Alexandre Neto mailto: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 training manual. Should I do that or is that someone else who adds the labels? Janneke On 07/01/2019 00:42, Alexandre Neto wrote: Better duplicated issues than missing ones . So please report whatever you feel that is a bug, or a possible improvement. That way we won't f
[Qgis-user] Different behaviour Raster Calculater under Raster menu vs Processing Toolbox
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 default settings (data from https://github.com/qgis/QGIS-Training-Data/archive/v2.0.zip) 2. Processing>Raster analysis>Raster calculator: "Aspect@1" <= 90 OR "Aspect@1">= 270 as expression, use the DEM layer for extents. 3. The resulting output gets created, but the information from provider shows "STATISTICS_VALID_PERCENT=0" and it does not have min and max values I have tried using a more simple expression like "Aspect@1" > 90 with the same result. Copying and pasting the expression in the Raster calculator under the menu Raster works as expected (values of 0 and 1). Using the Raster Calculator under Processing with another input layer and similar expression worked. So it seems that "something" when the aspect raster is created causes it "not to work" with the raster calculator under processing, while it still works with the RC under Raster. Can anyone confirm this is a bug? Thanks, Janneke ___ 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-community-team] training manual QGIS 3
Hi Harrissou, thanks for the quick intervention :-). Indeed, I did read about the trap, but wasn't sure where I was supposed to encounter it. I've done it again following your short description and that I think has worked...Let me know if I am still supposed to press more buttons...I'll have a look tomorrow at the guidelines and check why it wasn't obvious enough to me. Good night, Janneke On 09/01/2019 21:01, DelazJ wrote: Hi Janneke, I guess you are talking about https://github.com/janneke-qgis/QGIS-Documentation/pull/1 which is unfortunately a pull-request against your own branch and not the upstream one. This is a trap we all fall in at the beginning and mentioned at https://docs.qgis.org/testing/en/docs/documentation_guidelines/first_contribution.html#share-your-changes-via-pull-request What you have to do is also explained in the page I linked above (if ever not clear, let us know, we'll try to improve it) but in short: 1. Go to https://github.com/qgis/QGIS-Documentation/pulls 2. Press "New 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 <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 github by starting with some small remarks/changes I suggested myself. I think I have just made an edit and created a pull request - it tells me 'This branch has no conflicts with the base branch'. Not sure how to proceed from here. Is this enough from my side? Thanks for some guidance Janneke On 07/01/2019 23:27, Alexandre Neto wrote: Screenshots shouldn't be a blocker, you can take screenshots using windows. Then, if we have time, we can replace windows screenshots later. 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 linux to work on VM on my laptop so I couldn't do the screen shots. On 07/01/2019 17:39, Alexandre Neto wrote: Some of those changes are quite small. Would you be interested in learning how to fix it yourself? A seg, 7/01/2019, 14:37, Alexandre Neto mailto:senhor.n...@gmail.com>> escreveu: Actually, someone already did it. Thanks!! A seg, 7/01/2019, 14:37, Alexandre Neto mailto: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 training manual. Should I do that or is that someone else who adds the labels? Janneke On 07/01/2019 00:42, Alexandre Neto wrote: Better duplicated issues than missing ones . So please report whatever you feel 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 mentioned in [2] is not being addressed? Quite a few of my remarks will also related to updating screenshots, which I think has also been mentioned as a general issue somewhere - should I still list them separately? Thanks for your assistance, Janneke On 05/01/2019 13:33, DelazJ wrote: Hi Janneke, Thanks for your tests. And indeed the training manual update is a work in progress and maybe could you publish your remarks as issue reports in the doc repository [0] so that we took them into consideration as we go. You are right about the missing data, there w
Re: [Qgis-user] [Qgis-community-team] training manual QGIS 3
Hi Alexandre and Harrissou (and others),
I'm trying to feel my way through the contribution thing and github by
starting with some small remarks/changes I suggested myself. I think I
have just made an edit and created a pull request - it tells me 'This
branch has no conflicts with the base branch'. Not sure how to proceed
from here. Is this enough from my side?
Thanks for some guidance
Janneke
On 07/01/2019 23:27, Alexandre Neto wrote:
Screenshots shouldn't be a blocker, you can take screenshots using
windows. Then, if we have time, we can replace windows screenshots later.
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 linux to work on VM on
my laptop so I couldn't do the screen shots.
On 07/01/2019 17:39, Alexandre Neto wrote:
Some of those changes are quite small. Would you be interested in
learning how to fix it yourself?
A seg, 7/01/2019, 14:37, Alexandre Neto mailto:senhor.n...@gmail.com>> escreveu:
Actually, someone already did it. Thanks!!
A seg, 7/01/2019, 14:37, Alexandre Neto
mailto: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 training manual. Should I do
that or is that someone else who adds the labels?
Janneke
On 07/01/2019 00:42, Alexandre Neto wrote:
Better duplicated issues than missing ones . So
please report whatever you feel 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 mentioned in [2] is not being addressed?
Quite a few of my remarks will also related to
updating screenshots, which I think has also
been mentioned as a general issue somewhere -
should I still list them separately?
Thanks for your assistance,
Janneke
On 05/01/2019 13:33, DelazJ wrote:
Hi Janneke,
Thanks for your tests. And indeed the training
manual update is a work in progress and maybe
could you publish your remarks as issue reports
in the doc repository [0] so that we took them
into consideration as we go.
You are right about the missing data, there was
a pull request [1] to integrate these data we
forgot to merge. Done now! Download the dataset
again, please.
Note that we are reviewing initial lessons and
have some pending updates for both lessons [2]
and corresponding data [3]. Tests and feedbacks
are more than welcome. Thanks!
[0]
https://github.com/qgis/QGIS-Documentations/issues
[1]
https://github.com/qgis/QGIS-Training-Data/pull/15
[2]
https://github.com/qgis/QGIS-Documentation/pulls?q=is%3Apr+is%3Aopen+label%3A%22Training+Manual%22
[3]
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/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 stage. What is complicating
matters is that the data that
I downloaded (QGIS-Training-Data-2.0.zip)
Re: [Qgis-user] [Qgis-community-team] training manual QGIS 3
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 linux to work on VM on my laptop
so I couldn't do the screen shots.
On 07/01/2019 17:39, Alexandre Neto wrote:
Some of those changes are quite small. Would you be interested in
learning how to fix it yourself?
A seg, 7/01/2019, 14:37, Alexandre Neto <mailto:senhor.n...@gmail.com>> escreveu:
Actually, someone already did it. Thanks!!
A seg, 7/01/2019, 14:37, Alexandre Neto mailto: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 training manual. Should I do that
or is that someone else who adds the labels?
Janneke
On 07/01/2019 00:42, Alexandre Neto wrote:
Better duplicated issues than missing ones . So please
report whatever you feel 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
mentioned in [2] is not being addressed? Quite a few
of my remarks will also related to updating
screenshots, which I think has also been mentioned as
a general issue somewhere - should I still list them
separately?
Thanks for your assistance,
Janneke
On 05/01/2019 13:33, DelazJ wrote:
Hi Janneke,
Thanks for your tests. And indeed the training
manual update is a work in progress and maybe could
you publish your remarks as issue reports in the doc
repository [0] so that we took them into
consideration as we go.
You are right about the missing data, there was a
pull request [1] to integrate these data we forgot
to merge. Done now! Download the dataset again, please.
Note that we are reviewing initial lessons and have
some pending updates for both lessons [2] and
corresponding data [3]. Tests and feedbacks are more
than welcome. Thanks!
[0] https://github.com/qgis/QGIS-Documentations/issues
[1] https://github.com/qgis/QGIS-Training-Data/pull/15
[2]
https://github.com/qgis/QGIS-Documentation/pulls?q=is%3Apr+is%3Aopen+label%3A%22Training+Manual%22
[3] 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/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 stage. What is complicating
matters is that the data that
I downloaded (QGIS-Training-Data-2.0.zip) does
not contain all the
layers that are mentioned (so far schools,
restaurants, network_analysis
folder and possibly some more that I may have
skipped). Is there a
complete/up-to-date data set available? Where
can I find it?
Thanks for any suggestions,
Janneke
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
<mailto: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-community-team mailing list for organizing
community resources such as documentation,
Re: [Qgis-user] [Qgis-community-team] training manual QGIS 3
I've registered all that I've noticed, I just didn't manage to tag them with training manual. Should I do that or is that someone else who adds the labels? Janneke On 07/01/2019 00:42, Alexandre Neto wrote: Better duplicated issues than missing ones . So please report whatever you feel 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 mentioned in [2] is not being addressed? Quite a few of my remarks will also related to updating screenshots, which I think has also been mentioned as a general issue somewhere - should I still list them separately? Thanks for your assistance, Janneke On 05/01/2019 13:33, DelazJ wrote: Hi Janneke, Thanks for your tests. And indeed the training manual update is a work in progress and maybe could you publish your remarks as issue reports in the doc repository [0] so that we took them into consideration as we go. You are right about the missing data, there was a pull request [1] to integrate these data we forgot to merge. Done now! Download the dataset again, please. Note that we are reviewing initial lessons and have some pending updates for both lessons [2] and corresponding data [3]. Tests and feedbacks are more than welcome. Thanks! [0] https://github.com/qgis/QGIS-Documentations/issues [1] https://github.com/qgis/QGIS-Training-Data/pull/15 [2] https://github.com/qgis/QGIS-Documentation/pulls?q=is%3Apr+is%3Aopen+label%3A%22Training+Manual%22 [3] 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/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 stage. What is complicating matters is that the data that I downloaded (QGIS-Training-Data-2.0.zip) does not contain all the layers that are mentioned (so far schools, restaurants, network_analysis folder and possibly some more that I may have skipped). Is there a complete/up-to-date data set available? Where can I find it? Thanks for any suggestions, Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto: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-community-team mailing list for organizing community resources such as documentation, translation etc.. qgis-community-t...@lists.osgeo.org <mailto:qgis-community-t...@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/qgis-community-team -- Alexandre Neto - @AlexNetoGeo http://sigsemgrilhetas.wordpress.com http://gisunchained.wordpress.com ___ 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] training manual QGIS 3
Hi Harrissou, Getting ready to at least list my observations. Do I understand it correctly that whatever is not mentioned in [2] is not being addressed? Quite a few of my remarks will also related to updating screenshots, which I think has also been mentioned as a general issue somewhere - should I still list them separately? Thanks for your assistance, Janneke On 05/01/2019 13:33, DelazJ wrote: Hi Janneke, Thanks for your tests. And indeed the training manual update is a work in progress and maybe could you publish your remarks as issue reports in the doc repository [0] so that we took them into consideration as we go. You are right about the missing data, there was a pull request [1] to integrate these data we forgot to merge. Done now! Download the dataset again, please. Note that we are reviewing initial lessons and have some pending updates for both lessons [2] and corresponding data [3]. Tests and feedbacks are more than welcome. Thanks! [0] https://github.com/qgis/QGIS-Documentations/issues [1] https://github.com/qgis/QGIS-Training-Data/pull/15 [2] https://github.com/qgis/QGIS-Documentation/pulls?q=is%3Apr+is%3Aopen+label%3A%22Training+Manual%22 [3] 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/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 stage. What is complicating matters is that the data that I downloaded (QGIS-Training-Data-2.0.zip) does not contain all the layers that are mentioned (so far schools, restaurants, network_analysis folder and possibly some more that I may have skipped). Is there a complete/up-to-date data set available? Where can I find it? Thanks for any suggestions, Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto: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] training manual QGIS 3
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 stage. What is complicating matters is that the data that I downloaded (QGIS-Training-Data-2.0.zip) does not contain all the layers that are mentioned (so far schools, restaurants, network_analysis folder and possibly some more that I may have skipped). Is there a complete/up-to-date data set available? Where can I find it? Thanks for any suggestions, Janneke ___ 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] QField doesn't see my data
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 whole folder to the root of the SD card, where I could find it under /mnt/sdcard and it opened. Hope that helps for you too, Janneke On 18-Sep-17 23:30, edrou...@gmail.com wrote: Did you find any solution, I have the same problem. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ 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] field calculator add field to .csv layer
Thanks, Stéphane. That at least confirms it - the capabilities are then a bit misleading, if the layer is not meant to be editable. regards, Janneke On 31-May-17 12:31, Stéphane Henriod wrote: Hi Janneke If I'm not mistaking, the csv files are read-only in Qgis. So I guess it's not a bug 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 <mailto:janneke.q...@gmail.com>> a écrit : 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 get the following error messages: Could not commit changes to layer test_fieldcalculator1 Errors: ERROR: 1 new attribute(s) not added SUCCESS: 1 attribute value(s) changed. Provider errors: OGR error creating field txt: Feature 1 for attribute update not found. OGR error syncing to disk: The capabilities of this layer show: Add Features, Delete Features, Change Attribute Values, Add Attributes, Delete Attributes, Rename Attributes, Change Geometries, Curved Geometries which makes me think it should be possible to add attributes to this layer. Is this a bug or am I missing something? If a bug, is it in OGR or QGIS? Thanks for any insight, Janneke -- Stéphane Henriod CIM-Expert for GIS and Green Economy Statistics Национальный статистический комитет Кыргызской Республики Кыргыз Республикасынын Улуттук статистика комитети National Statistical Committee of the Kyrgyz Republic 374 Фрунзе ул. / Frunze str. 720033 Бишкек / Bishkek T +996 778 46 99 02 (KG) T +49 176 280 11 050 (DE) E s...@henriod.info <mailto:s...@henriod.info> W http://www.stat.kg W3W: nightfall.into.bucket <https://map.what3words.com/nightfall.into.bucket> // запас.союз.дружный <https://map.what3words.com/%D0%B7%D0%B0%D0%BF%D0%B0%D1%81.%D1%81%D0%BE%D1%8E%D0%B7.%D0%B4%D1%80%D1%83%D0%B6%D0%BD%D1%8B%D0%B9> ___ 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] field calculator add field to .csv layer
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 get the following error messages: Could not commit changes to layer test_fieldcalculator1 Errors: ERROR: 1 new attribute(s) not added SUCCESS: 1 attribute value(s) changed. Provider errors: OGR error creating field txt: Feature 1 for attribute update not found. OGR error syncing to disk: The capabilities of this layer show: Add Features, Delete Features, Change Attribute Values, Add Attributes, Delete Attributes, Rename Attributes, Change Geometries, Curved Geometries which makes me think it should be possible to add attributes to this layer. Is this a bug or am I missing something? If a bug, is it in OGR or QGIS? Thanks for any insight, Janneke ___ 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 it possible to use virtual fields that depend on other virtual fields for styling and labeling?
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 integers, the third virtual field (vTest3) multiplies the values of vTest and vTest2. I can use vTest and vTest2 in Styles and in Labels, but not vTest3. In styles it will not categorise, and the labels will just not show in the map. The values show correctly in the attribute table and with the information tool. Is it a bug? Does anyone else have this issue? I'm using today's nightly build on Windows 7. As a work around I can create a non virtual field and use the field calculator to set the values to the values in vTest3. kind regards, Janneke virtualstyle.rar Description: Binary data ___ 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] updating postgres updateable view much slower from attribute table than using db manager
Hi Matthias, I think I can follow that, and it makes sense that QGIS does the calculation independently of the provider for consistency. I will indeed look into the details of the view and see if it is one particular join that is so expensive or that it is just the total number of joins that causes it. At the same time I'll keep my eyes open for potential projects that might be able to contribute, but that's a bit more complicated. Thanks for helping me understand the background of the process, Janneke On 30/11/2015 14:46, Matthias Kuhn wrote: Hi Janneke, The reason for individual statements are mainly that expressions (field calculator) and SQL (table manager) are not completely equal. Some functions are only supported by QGIS, some only by postgres/postgis. The expressions should be supported by all data providers (different database systems, non-database systems) and therefore QGIS plays safe and just does the calculation always on its own. Some background: We have this summer started to be able to generate postgres SQL from expressions (where possible) but this has only been applied to some isolated areas (like filtering for rendering). It would theoretically be possible to use it for provider side updates as well but that's an ambitious task that will need some work by an experienced developer. I'd propose looking into what makes updating your view so expensive (probably easier) or consider to contribute towards provider side updates 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 or that there is something more going on. I also tried writing the update statement as an update on the view with the where clause being 'where id in (list of ids)', this again goes quickly (6 seconds). To sum it up: unless there is a way in QGIS to update selections using one update statement with a where clause (as opposed to individual update statements per record), it is not possible to work with larger selections on 'expensive' views in postgres. Would that be difficult to implement, or are there other reasons for issuing individual statements? Thanks again all for your thoughts, Janneke On 29/11/2015 22:36, Jürgen E. Fischer wrote: 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 originally used the update expression bar to update the selection, but all three methods take too long to save. That's because - as Matthias already said - the expression are evaluated for each record and the changed attribute value is temporary stored in QGIS. When you commit the changed records are iterated and a separate UPDATE statements is issued for each record. And that's what takes long - although an expensive view contributes to the time each UPDATE needs. The comment about the attribute table was just because for each change also the attribute table(s) UI is updated. So execution might be quicker if there are no open attribute tables. But the actual updates should perform the same from wherever you invoke the feature calculator. Jürgen ___ 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 ___ 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 -- Matthias Kuhn OPENGIS.ch -https://www.opengis.ch Spatial • (Q)GIS • PostGIS • Open Source ___ 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 ___ 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] Problems occur when copying large amounts to Excel
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, E'[\\n\\r\\u2028]+', ' ', 'g' ); Janneke On 30/11/2015 13:39, Yann Raes wrote: Hello When I copy my attributes (+6000 attributes) to Excel I get several lines that are not copied correct. The lines split in half and makes a new line; so one line turns into two split lines… Anyone a solution for this bug? Thanx. Yann ___ 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 ___ 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] updating postgres updateable view much slower from attribute table than using db manager
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 or that there is something more going on. I also tried writing the update statement as an update on the view with the where clause being 'where id in (list of ids)', this again goes quickly (6 seconds). To sum it up: unless there is a way in QGIS to update selections using one update statement with a where clause (as opposed to individual update statements per record), it is not possible to work with larger selections on 'expensive' views in postgres. Would that be difficult to implement, or are there other reasons for issuing individual statements? Thanks again all for your thoughts, Janneke On 29/11/2015 22:36, Jürgen E. Fischer wrote: 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 originally used the update expression bar to update the selection, but all three methods take too long to save. That's because - as Matthias already said - the expression are evaluated for each record and the changed attribute value is temporary stored in QGIS. When you commit the changed records are iterated and a separate UPDATE statements is issued for each record. And that's what takes long - although an expensive view contributes to the time each UPDATE needs. The comment about the attribute table was just because for each change also the attribute table(s) UI is updated. So execution might be quicker if there are no open attribute tables. But the actual updates should perform the same from wherever you invoke the feature calculator. Jürgen ___ 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 ___ 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] updating postgres updateable view much slower from attribute table than using db manager
Hi, 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 originally used the update expression bar to update the selection, but all three methods take too long to save. I'm currently experiencing the issue on localhost, so it's not the network connection. I have a workaround by reducing the number of joins (or finding the join that is causing the problem) and rewriting the definition of the view, however, it would be interesting if it could be solved in QGIS. thanks for any help/thoughts, Janneke On 29/11/2015 18:50, Matthias Kuhn wrote: Hi, Short explanation for the difference: * If you do it with the db manager you send a request to the database "please update all records with this SQL". * If you do it with the field calculator, QGIS requests all records, evaluates the expression locally and sends dozens of update statements. That said, the time is pretty long anyway. I am sure that there's potential for improvement also with local evaulation. But this can be limited by several 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, Janneke van Dijk wrote: Hi Nyall, Tested it with 12.1.1, that doesn't make a difference as far as I can tell (40 minutes now). I tested the view without the many joins for lookup values (it had about 13 joins and reduced it to 4), which made it take around 15 seconds, which would be acceptable. I haven't yet tested if it may be one specific join that causes the behaviour or that it is the number of joins. I'm still curious to understand what the difference is between the update statement in the db manager and the way the data are updated from the attribute table. Could it be that the update via db manager only needs to 'calculate' the joins once, where the update via the attribute table has to loop through all the selected features, 'calculating' the joins for every record that needs to be saved? If that is the case, would there be a way to bypass this behaviour (by using the original where 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" wrote: > > 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 complete. > > When I open the attribute table, select the same records, then use the update bar in the top to update the districtid to 8, using 'update selected' , then save edits, it takes more than 10 minutes (after which I closed the project). > > Doing the same update directly on the attribute table of the underlying postgres table works nicely (takes about 3 seconds) after save edits. > > Does anyone know why the update via the attribute table on the view takes so long as to be unusable, while the db manager works nicely with the view? Seeing that working directly on the underlying table from the attribute table works well too it's seems to be a combination of the attribute table approach with an updateable view that seems to cause the issue. > > Thanks for any thoughts on the matter, Please try with 2.12.1 or the current nightly snapshots. I made a change since 2.12 which may have improved this already. Nyall > > Janneke > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user ___ 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 -- Matthias Kuhn OPENGIS.ch -https://www.opengis.ch Spatial • (Q)GIS • PostGIS • Open Source ___ 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] updating postgres updateable view much slower from attribute table than using db manager
Hi Nyall, Tested it with 12.1.1, that doesn't make a difference as far as I can tell (40 minutes now). I tested the view without the many joins for lookup values (it had about 13 joins and reduced it to 4), which made it take around 15 seconds, which would be acceptable. I haven't yet tested if it may be one specific join that causes the behaviour or that it is the number of joins. I'm still curious to understand what the difference is between the update statement in the db manager and the way the data are updated from the attribute table. Could it be that the update via db manager only needs to 'calculate' the joins once, where the update via the attribute table has to loop through all the selected features, 'calculating' the joins for every record that needs to be saved? If that is the case, would there be a way to bypass this behaviour (by using the original where 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" <mailto:janneke.q...@gmail.com>> wrote: > > 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 complete. > > When I open the attribute table, select the same records, then use the update bar in the top to update the districtid to 8, using 'update selected' , then save edits, it takes more than 10 minutes (after which I closed the project). > > Doing the same update directly on the attribute table of the underlying postgres table works nicely (takes about 3 seconds) after save edits. > > Does anyone know why the update via the attribute table on the view takes so long as to be unusable, while the db manager works nicely with the view? Seeing that working directly on the underlying table from the attribute table works well too it's seems to be a combination of the attribute table approach with an updateable view that seems to cause the issue. > > Thanks for any thoughts on the matter, Please try with 2.12.1 or the current nightly snapshots. I made a change since 2.12 which may have improved this already. Nyall > > Janneke > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user ___ 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
[Qgis-user] updating postgres updateable view much slower from attribute table than using db manager
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 complete. When I open the attribute table, select the same records, then use the update bar in the top to update the districtid to 8, using 'update selected' , then save edits, it takes more than 10 minutes (after which I closed the project). Doing the same update directly on the attribute table of the underlying postgres table works nicely (takes about 3 seconds) after save edits. Does anyone know why the update via the attribute table on the view takes so long as to be unusable, while the db manager works nicely with the view? Seeing that working directly on the underlying table from the attribute table works well too it's seems to be a combination of the attribute table approach with an updateable view that seems to cause the issue. Thanks for any thoughts on the matter, Janneke ___ 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] SOLVED: split features tool on postgres layer causes pkey violation
Hi Bernd,
Indeed, that was the problem.
Running
SELECT setval('a_streets_streetsid_seq', COALESCE((SELECT
MAX(streetsid)+1 FROM a_streets), 1), false);
solved the issue. Still not sure what caused this in the first place,
but have added your trigger to the table for the future.
greetings,
Janneke
On 26/11/2015 18:32, Bernhard Ströbl wrote:
Hi,
I cannot confirm this behaviour neither with 2.8 on Win7 nor with 2.10
on Linux. When asking the new features with the "i" tool after
splitting, one keeps its pk value the other displays
nextval("my_sequence"). Maybe the problem is that features have
received pk values by other means then nextval("sequence"), thus the
sequence's current start value is lower than the maximum pk value. To
avoid such confusion I create a BEFORE INSERT or UPDATE trigger for my
tables. This is the trigger function:
CREATE OR REPLACE FUNCTION my_schema.my_table_ensure_sequence()
RETURNS trigger AS
$BODY$
BEGIN
IF (TG_OP = 'INSERT') THEN
NEW.id:= nextval('my_id_seq');
ELSIF (TG_OP = 'UPDATE') THEN
NEW.id := OLD.id;
END IF;
RETURN NEW;
END; $BODY$
LANGUAGE plpgsql VOLATILE
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 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 error while adding features: ERROR: duplicate key value violates
unique constraint "streets_pkey"
DETAIL: Key (streetsid)=(5) already exists.
"
The a_streets table has a serial primary key.
It seems similar to the bug described here:
https://hub.qgis.org/issues/5475
in 1.9 that was apparently fixed 3 years ago.
Is this indeed a bug? Or can the tool not be used on postgres layers?
Thanks for any insights,
Janneke
___
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
__ Information from ESET Mail Security, version of virus
signature database 12628 (20151126) __
The message was checked by ESET Mail Security.
http://www.eset.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
___
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
[Qgis-user] split features tool on postgres layer causes pkey violation
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 error while adding features: ERROR: duplicate key value violates unique constraint "streets_pkey" DETAIL: Key (streetsid)=(5) already exists. " The a_streets table has a serial primary key. It seems similar to the bug described here: https://hub.qgis.org/issues/5475 in 1.9 that was apparently fixed 3 years ago. Is this indeed a bug? Or can the tool not be used on postgres layers? Thanks for any insights, Janneke ___ 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] use autogenerated form in Qgis for same table in different postgres databases
Hi Bernhard,
with the new plugin I was able to configure a mask for a table (it
doesn't work for a postgres view, even if the view is editable? Would
that not be possible to adjust?), and initialise the layer, and open the
dataform. I did have to enter the databasename and password several
times in a row. I have not tried using it yet but it at least opens and
it looks promising!
Things that I have working in the autogenerated form but don't see here
(yet), I would like to know if it's already possible or if I would have
to modify this using Python:
- Is it possible to have the comboboxes show the descriptions of the
corresponding lookup table, in stead of the ids that will be stored in
the table? (the autogenerated form worked on the view that already
provided the descriptions)
- Do I understand it correctly that it can only be used for editing
existing data, not for adding new records?
I'll look at it in more detail tomorrow, see if this can do what I would
need it to do.
Thanks!
Janneke
On 22/12/2014 12:12, Bernhard Ströbl wrote:
Hi Janneke,
I published a new version of the plugin which includes the fix I
mentionend. Please check it out and call back 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'.'T_network_geometry') (followed by more, I can
send the screenshot).
When I click OK the python error window shows:
Traceback (most recent call last):
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\datadriveninputmask.py",
line 188, in initializeLayer
inputUi = None, searchUi = None, helpText = "") # set the
defaults here because somehow some of the values persist
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddmanager.py",
line 176, in initLayer
readConfigTables = readConfigTables)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 371, in createUi
showParents, showChildren, readConfigTables, createAction)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 200, in __createForms
n2mAttributes = self.getN2mAttributes(db, thisTable, anAtt.name,
anAtt.num, labels, showChildren, skip)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 635, in getN2mAttributes
configList = self.configureLayer(ddRelationTable, [], {}, [],
{}, {}, [], db, True, "")
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 184, in configureLayer
DbError(query)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\dderror.py",
line 54, in __init__
raise FatalError("DBError exiting")
FatalError: 'DBError exiting'
Python version:
2.7.4 (default, Apr 6 2013, 19:54:46) [MSC v.1500 32 bit (Intel)]
QGIS version:
2.6.1-Brighton Brighton, e2a51df
Should I do something else before initialising the layer?
thanks,
Janneke
On 22/12/2014 10:14, Bernhard Ströbl wrote:
Hi Janneke,
this is not answering your question... but, have you tried the
DataDrivenInputMask plugin [1]. It auto-generates input masks for
PostgreSQL layers. Only prerequisite is a properly designed 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 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 with all properties set where I could choose to load
layers
either from one or another database (with identical structures), and
when I edit a layer the correct form opens.
If I save it as a .qml file (from project1 connected to database1),
then
load it in project2 (connected to database2 with identical tables
loaded) through properties>fields>load style it appears to load it
(the
edit widgets get changed to the same as in project1), but when I
click a
value relation widget the layer, key column and value column fields
are
empty. When I open the attribute table all fields that have a value
relation that refers to a lookup table that contains different values
than the original lookup table will show their values between brackets
(at least, those values that do not appear in the original table).
It looks as if the .qml retains a link to the original database and
lookup tables (and not just to layer names as
Re: [Qgis-user] use autogenerated form in Qgis for same table in different postgres databases
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'.'T_network_geometry') (followed by more, I can
send the screenshot).
When I click OK the python error window shows:
Traceback (most recent call last):
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\datadriveninputmask.py",
line 188, in initializeLayer
inputUi = None, searchUi = None, helpText = "") # set the
defaults here because somehow some of the values persist
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddmanager.py",
line 176, in initLayer
readConfigTables = readConfigTables)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 371, in createUi
showParents, showChildren, readConfigTables, createAction)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 200, in __createForms
n2mAttributes = self.getN2mAttributes(db, thisTable, anAtt.name,
anAtt.num, labels, showChildren, skip)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 635, in getN2mAttributes
configList = self.configureLayer(ddRelationTable, [], {}, [],
{}, {}, [], db, True, "")
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\ddui.py",
line 184, in configureLayer
DbError(query)
File
"C:/Users/Janneke/.qgis2/python/plugins\DataDrivenInputMask\dderror.py",
line 54, in __init__
raise FatalError("DBError exiting")
FatalError: 'DBError exiting'
Python version:
2.7.4 (default, Apr 6 2013, 19:54:46) [MSC v.1500 32 bit (Intel)]
QGIS version:
2.6.1-Brighton Brighton, e2a51df
Should I do something else before initialising the layer?
thanks,
Janneke
On 22/12/2014 10:14, Bernhard Ströbl wrote:
Hi Janneke,
this is not answering your question... but, have you tried the
DataDrivenInputMask plugin [1]. It auto-generates input masks for
PostgreSQL layers. Only prerequisite is a properly designed 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 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 with all properties set where I could choose to load layers
either from one or another database (with identical structures), and
when I edit a layer the correct form opens.
If I save it as a .qml file (from project1 connected to database1), then
load it in project2 (connected to database2 with identical tables
loaded) through properties>fields>load style it appears to load it (the
edit widgets get changed to the same as in project1), but when I click a
value relation widget the layer, key column and value column fields are
empty. When I open the attribute table all fields that have a value
relation that refers to a lookup table that contains different values
than the original lookup table will show their values between brackets
(at least, those values that do not appear in the original table).
It looks as if the .qml retains a link to the original database and
lookup tables (and not just to layer names as they are loaded in the
project). Is there a way to configure a form based on a table structure
that can be re-used for other tables with the same structure?
Thanks,
Janneke
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
__ Information from ESET Mail Security, version of virus
signature database 10911 (20141221) __
The message was checked by ESET Mail Security.
http://www.eset.com
__ Information from ESET Mail Security, version of virus
signature database 10912 (20141221) __
The message was checked by ESET Mail Security.
http://www.eset.com
___
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
[Qgis-user] use autogenerated form in Qgis for same table in different postgres databases
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 with all properties set where I could choose to load layers either from one or another database (with identical structures), and when I edit a layer the correct form opens. If I save it as a .qml file (from project1 connected to database1), then load it in project2 (connected to database2 with identical tables loaded) through properties>fields>load style it appears to load it (the edit widgets get changed to the same as in project1), but when I click a value relation widget the layer, key column and value column fields are empty. When I open the attribute table all fields that have a value relation that refers to a lookup table that contains different values than the original lookup table will show their values between brackets (at least, those values that do not appear in the original table). It looks as if the .qml retains a link to the original database and lookup tables (and not just to layer names as they are loaded in the project). Is there a way to configure a form based on a table structure that can be re-used for other tables with the same structure? Thanks, Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [Qgis-developer] Misaligned Google OpenLayers layer
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: workaround ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [Qgis-developer] Misaligned Google OpenLayers layer
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 + windows 7, also confirm it doesn't happen with bing -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Misaligned-Google-OpenLayers-layer-tp5039475p5044414.html Sent from the Quantum GIS - Developer mailing list archive at Nabble.com. ___ Qgis-developer mailing list qgis-develo...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
