Re: [Qgis-user] Use of "description column" in "value relation widget"

Hi! As I know it you get the description when you hover the different options in the dropdown. It would sometimes have been nice to have the description visible to the user in the dropdown and the value (not visible) stored in the attribute. Kind regards Karl-Magnus Jönsson -Ursprungligt

Re: [Qgis-user] [EXTERNAL] Re: Geopackage slow on NAS if not read-only

Hi! If just storing and reading is the scope and not editing, maybe another file format would be suitable. Like https://flatgeobuf.org/. Not tested by me but could be a good alternative. Karl-Magnus Jönsson Från: QGIS-User För Árni Geirsson via QGIS-User Skickat: den 16 mars 2023 15:08 Till

Re: [Qgis-user] Strange digitising behavior

Hi! It's a new thing that could be a bit confusing. When you digitize you can choose between segment, stream, curve, shape in the advanced digitizing toolbar. And there is a toolbar for choosing shapes as well. [cid:image001.png@01D8A1BE.516FCFD0] Karl-Magnus Jönsson Från: Qgis-user För

Re: [Qgis-user] Identify tool and closest vertices (z-values)

I tested against: PostgreSQL 11.5 on x86_64-alpine-linux-musl, compiled by gcc (Alpine 8.3.0) 8.3.0, 64-bit Postgis: 2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 Karl-Magnus Jönsson Från: Andreas Neumann Skickat: den 24 maj 2022 12:22 Till: Karl Magnus Jönsson Kopia: QGIS User List Ämne: Re: Sv

Re: [Qgis-user] Identify tool and closest vertices (z-values)

Hi! It seems to work for me in 3.22.5 with Postgis PolygonZ. Can’t remember that I’ve done any custom settings for that. [cid:image001.png@01D86F60.2F0463B0] Karl-Magnus Jönsson Från: Qgis-user För Andreas Neumann via Qgis-user Skickat: den 24 maj 2022 10:53 Till: QGIS User List Ämne: [Qgis

[Qgis-user] (Un)force hide form in relation widget

in a fresh install or profile. But not a new project. Does someone knows where this option can be unset? Unsetting it in the UI doesn't work. QGIS 3.22.3 on Windows. But the same since 3.16 at least. Best regards Karl-Magnus Jönsson ___ Qgis-user mailing

Re: [Qgis-user] Slooooow spatial joins

Hi! How about just execute some SQL in an algorithm or model since you have the data in Postgis? And do the spatial join directly in the database. Like (not tested): UPDATE polygonlayer p SET p.field = pt.field FROM pointlayer pt WHERE st_within(pt.geom,p.geom); Karl-Magnus Jönsson Från: Qgis

Re: [Qgis-user] How to select a polygon feature underneath another in the same ArcGIS REST feature layer.

Hi! How does the new feature (3.18), right click with the select tool to get an menu, work with this data? https://www.qgis.org/en/site/forusers/visualchangelog318/index.html#feature-select-features-context-menu Karl-Magnus Jönsson Från: Qgis-user För Michael Dufty Skickat: den 14 maj 2021 09

Re: [Qgis-user] Loading filtered database table as temp layer

Hi! Wouldn't it be possible to use the "Execute SQL" algorithm under "Vector general" instead of the "PostgreSQL SQL execute and load" in the Model Designer? It outputs a (temporary) layer if you choose that. I'm not sure how to use it correctly though. Karl-Magn

Re: [Qgis-user] Shortcut letter for pan up/down/left/right

Hi! I often press space for panning while digitizing. Is that an option? Karl-Magnus -Ursprungligt meddelande- Från: Qgis-user För Richard Duivenvoorde Skickat: den 12 april 2021 08:41 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] Shortcut letter for pan up/down/left/right On

Re: [Qgis-user] First steps with 3D Scan Data?

Hi! Lots of suggestions here. But if I understand you correct it is lidar data and all about photogrammetry is not in question. Why not pdal? Open source, powerful and what QGIS is using in 3.18. https://pdal.io/ Karl-Magnus -Ursprungligt meddelande- Från: Qgis-user För Bernd

[Qgis-user] Access database via cmd

srid=3008 type=PolygonZ checkPrimaryKeyUnicity=\'1\' table=\"pri\".\"byggnad_\" (geom)' If it's possible in cmd I don't know how to format it properly. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user För Christoph Jung Skickat: den 12 mars 2021 06:5

Re: [Qgis-user] Save log to file via cmd

No, unfortunately not. I guess it is a bug that has to be reported. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Christoph Jung Skickat: den 9 mars 2021 09:33 Till: Karl Magnus Jönsson Kopia: qgis-user Ämne: Re: [Qgis-user] Save log to file via cmd Thank you for you answer

Re: [Qgis-user] Save log to file via cmd

Hi, I've experienced the same thing. Haven't found/heard of a solution yet. Would be interested in that. Regards Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user För Christoph Jung Skickat: den 8 mars 2021 15:41 Till: qgis-user Ämne: [Qgis-user] Save log to file via cmd

Re: [Qgis-user] QGIS server WMS cascade getfeatureinfo

Hi! I don't have the same setup but I do some cascading WMS. I can usually get some hints from the QGIS Server log if there are problems. Maybe also look at the requests that the client sends to the server. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user För

[Qgis-user] QGIS processing command line

e bug report/feature requests/enhancement proposals to describe and discuss if isn't just me using it the wrong way. I'm on Windows 10 with QGIS 3.16.3 Standalone installer. Karl-Magnus Jönsson ___ Qgis-user mailing list Qgis-user@lists.osgeo.

Re: [Qgis-user] Http access to json return

Hi! I’m also interested this functionality. Need to use OAuht2 authentication but that seems not to be available. Guess there is just an solution programmatically then. Karl-Magnus Från: Qgis-user För Ben Hur Pintor Skickat: den 24 juni 2020 10:23 Till: Steve Sgalowski Kopia: QGIS User

Re: [Qgis-user] Styling polygon borders: preventing double rendering between polygons

Hi! I had a similar problem. I’ve made a view ( in PostGIS) to transform the boundaries to lines and remove the duplicate lines. Should be doable in virtual layers as well. Quite complicated SQL since I have several different types of lines depending on the attributes. Karl-Magnus Jönsson

Re: [Qgis-user] Save projects to DB without creator's permissions

. Karl-Magnus Jönsson Från: Qgis-user För Cliff Patterson Skickat: den 1 juni 2020 15:36 Till: Alessandro Pasotti Kopia: qgis-user Ämne: Re: [Qgis-user] Save projects to DB without creator's permissions That's exactly the problem with the auth system. If you connect to a DB using the auth

Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment

Hi! Wouldn’t that be round($length,2) for getting two decimal places for meters? Karl-Magnus Jönsson Från: Qgis-user För Richard McDonnell Skickat: den 5 maj 2020 10:51 Till: hdiens...@aol.com; qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] QGIS 3.10: Dimensioning with on-board equipment Hi

[Qgis-user] Embedded projects and QGIS server

to be able to publish layers or projects in different master projects and not have to duplicate the cartography and settings in several projects. Does anyone know if it is intended to work with embedded projects in QGIS Server? Or have another smart solution for this? Thanks in advance. Karl-Magnus

Re: [Qgis-user] Clicking the georeferencer doesn't result in any reaction

Hi! Do you sometimes have multiple screens? I’ve experienced that when moving the georeference window to the second screen it doesn’t show up when using just one. Try to connect the second screen again and move it back to the main screen. Otherwise it is a setting somewhere. Maybe in the

Re: [Qgis-user] Applying multiple styles to the same layer

Hi, Another option is to add named styles to the layer and switch between them. And if you want, associate them with map themes for quick switching. https://docs.qgis.org/3.4/en/docs/user_manual/introduction/general_tools.html#manage-custom-style Karl Magnus Jönsson | Gis-Utvecklare Geografisk

Re: [Qgis-user] QGIS 3 - Joins

Hi! It could work editing views if you set up some triggers or rules for editing the view. Karl-Magnus -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För burghardt.scho...@stadt.wolfsburg.de Skickat: den 18 oktober 2019 12:09 Till:

Re: [Qgis-user] Forms, realtions and foreign keys

o, If you enable "evaluate default values server side" and "automatic transaction groups" and set the foreign key check in the database to initially deferred you'll get pretty much what you want :) Hope that helps Matthias On 6/4/19 11:14 AM, Karl Magnus Jönsson wrote: Hi li

Re: [Qgis-user] exporting layout to pdf changes output of locked maps

Hi! Have you tried to create different map themes and associate them with the appropriate layout map frame? Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Reginald Skickat: den 4 juni 2019 09:50 Till: qgis-user

Re: [Qgis-user] Print Composer Filter

Hi, Good it worked. Posting it to the list as well. /Karl-Magnus Jönsson 29 maj 2019 kl. 00:05 skrev Xan Vieiro mailto:gallaec...@gmail.com>>: Hi Karl, your recipe works fine. Many thanks for the hint! It will be great if there were a feature filter in the map element at print compos

Re: [Qgis-user] Print Composer Filter

me e.g print theme and associate the map in the layout with this map theme. Then you can change the style in main window as you wish, alter to default style for the layer and remove the rule based styling, make more named styles and map themes for different purposes. Regards Karl-Magnus Jönsson

Re: [Qgis-user] Print Composer Filter

Hi! How do you mean? You do the filtering in the layer properties in the QGIS main window. For atlas there are some more variables or functions available when doing this. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Xan Vieiro Skickat: den 27 maj 2019 22

Re: [Qgis-user] Layer panel docking problem

Hi! The Layer Panel should be dockable. Could be a little bit tricky. Try several times. Karl-Magnus Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Susan Iremonger Skickat: den 19 maj 2019 16:32 Till: qgis-user Ämne: [Qgis-user] Layer panel docking problem Hi All, Please help

Re: [Qgis-user] las files

Hi! There is a plugin called "Fusion for processing" that might work for you. Marked as experimental. http://forsys.cfr.washington.edu/FUSION/fusion_overview.html Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Tony Shepherd (FarmMaps NZ) Skickat:

Re: [Qgis-user] QGIS3 Server on Windows Server and IIS

of that? Regards Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Mats Elfström Skickat: den 9 maj 2019 09:16 Till: qgis-user Ämne: [Qgis-user] QGIS3 Server on Windows Server and IIS Hi All! I have once again made a futile attempt to establish a QGIS Server

[Qgis-user] HTML in layout

(but remains editable). QGIS 3.6.2 /Karl-Magnus Jönsson ___ 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] How calculate sequential values based on spatial pattern

Hi! One way could be to calculate the sequence and coordinates in Excel or something similar. If the points are regularly spaced of course. Then save to csv, import in QGIS and save to whatever. Cheers! Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user

Re: [Qgis-user] Opening a project from QGIS 2.14 in §.4

Hi! Try to open and save the project in 2.18 before 3.4. I think there are problems to use too old versions of project files in 3.x versions Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Maria Shinoto Skickat: den 31

Re: [Qgis-user] Geopagkage and "geom" in DBmanager

. where do I put the database logic? Could it fit in a file based database or virtual layers? Which strategy is the best? Any ideas or experiences? Regards Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Bo Victor Thomsen Skickat: den 13 september 2018 22:40

[Qgis-user] drill down default values

Hi! I'm trying out the new great "drill-down forms support" in QGIS 3.2. Is there a way to achieve the same behavior for default values? In other words: default values depends on what you choose in another form field. I think that make sense. Karl-Magn

Re: [Qgis-user] hide vector under raster?

Hi! How about using the no symbols renderer in the style tab in Layer properties? Wouldn't that do? Regards Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Tobias Wendorff Skickat: den 29 maj 2018 13:08 Till: qgis-user

Re: [Qgis-user] STORY PLUGIN

-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lukas Winiwarter Skickat: den 13 april 2018 10:19 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] STORY PLUGIN Hello Tabaré, apparently you can get it from here: https://github.com/klakar/scheherazade Regards

Re: [Qgis-user] Building models in QGIS

Hi! I'm playing around with the possibilities of 3D-building in the qgis2threejs-plug-in. You can use collada models, exportable from Sketchup, on point features in the plug-in. So I've made a point on the desired building, attached the model and a proper scaling. I've had some luck with it but

Re: [Qgis-user] Updating a field set with default global variable on edit

a bit unsecure not using the GUI. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Fernando M. Roxo da Motta Skickat: den 23 augusti 2017 02:28 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] Updating a field set

Re: [Qgis-user] Updating a field set with default global variable on edit

and administer reading/writing/admin-privileges. Mvh. / Best regards Casper Bertelsen On 22/08/2017 13:34, Karl Magnus Jönsson wrote: Hi! I've made the same things with triggers in the database. To avoid getting same username I've chosen not to save the username and password in the project

Re: [Qgis-user] Updating a field set with default global variable on edit

Hi! I've made the same things with triggers in the database. To avoid getting same username I've chosen not to save the username and password in the project. But then the user have to enter it every time the projects opens. If you can find a solution to your suggested approach it would be nice.

Re: [Qgis-user] Strike and dip symbology and labels

Hi! I can't visualize, in my head, what you are trying to achieve and what's going wrong. Can you supply a simple sketch? Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lester Anderson Skickat: den 15 augusti 2017 15:06 Till

Re: [Qgis-user] Georeferenced work won't write to file

Hi! Did you hit the ”play”-button (green triangle)? Otherwise nothing happens. It’s just the settings. Could be a litte unclear. Karl-Magnus Jönsson | Gis-Utvecklare Geografisk information Miljö- och samhällsbyggnadsförvaltningen Kristianstads kommun Besöksadress: Västra Storgatan 12 Postadress

Re: [Qgis-user] Selecting displaced symbols

Hi! When talking about this. I’ve had a thought of improvement of the select tool. When there is several features in the same (or almost the same) location in one layer it is difficult to select one particular feature. Could we have the same functionality with select tool as with identify?

Re: [Qgis-user] Unique IDs in a PostGIS view

Good! And good to know. Karl-Magnus Från: Árni Geirsson [mailto:a...@alta.is] Skickat: den 12 april 2017 15:19 Till: Steve Toutant Kopia: Karl Magnus Jönsson; qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] Unique IDs in a PostGIS view I left the over clause empty. Based on your suggestion, I

Re: [Qgis-user] Unique IDs in a PostGIS view

Hi! I’ve used something like this to get unique Ids: SELECT row_number() OVER (ORDER BY s.omrade_id, s.kod) AS id, …. ORDER BY s.omrade_id, s.kod; If the ordering isn’t necessary I guess you can skip that. https://www.postgresql.org/docs/current/static/functions-window.html Karl-Magnus

Re: [Qgis-user] Retrieve Postgis user from connection string

Maybe you can test that in the trigger. Something like: IF current_user != 'lizmap_editor' THEN NEW.GivenUser = current_user; END IF; Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Rossin Pietro [mailto:pietro.ros...@arpa.fvg.it] Skickat: den 22 mars 2017 11:34 Till

Re: [Qgis-user] Retrieve Postgis user from connection string

w row is distinct from the old" since small changes in geometry didn't get caught as a different record. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Rossin Pietro Skickat: den 21 mars 2017 17:16 Till: qgis-user@lists.osgeo.org Ä

Re: [Qgis-user] can't editing view using rules

Integer (4 bytes). I'll have a look at the view. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Matthias Kuhn Skickat: den 18 januari 2017 09:21 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] can't editing view using rules Hi Karl-Magnus, What

Re: [Qgis-user] can't editing view using rules

, fabrikat, nr, fritext,utforare,'2017-01-18'::date,'b_resultat'::character varying,'status'::character varying,geom ; Please let me know if you find a way to solve this better or a way to turn this feature off in QGIS. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För

Re: [Qgis-user] can't editing view using rules

uot;,"i_svuotam","so_dissest","so_interra","so_scalzat","so_sifonat","data_rilev","note","utente_crea","data_crea","utente_mod","data_mod","fonte","desc_fonte","fo

Re: [Qgis-user] can't editing view using rules

OR REPLACE RULE v_prislistor_upd_nothing AS ON UPDATE TO park.v_prislistor DO INSTEAD NOTHING; CREATE OR REPLACE RULE v_prislistor_upd_upd AS ON UPDATE TO park.v_prislistor WHERE old.id IS NOT NULL DO INSTEAD UPDATE park.priser SET pris = new.pris WHERE priser.id = old.id; Karl-Magnus

Re: [Qgis-user] spatialjoin

syntax. Read the referece!): Create or replace view [viewname] as Select A.id, A.attribute1, B.attribute2, A.geom >From pointtable A, polygontable B Where st_within(A.geom,B.geom); If A.geom has to be transformed you could use st_transform inside the st_within function. /Karl-Magnus Jönsson 21

Re: [Qgis-user] Tool to copy the content of the map canvas to the clipboard

Hi! As I use Windows I usually use the Snipping tool in Windows for such needs. Isn’t that an option? Useful for other programs too. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Larry Shaffer Skickat: den 20 december 2016 21:44 Till: DelazJ Kopia: qgis-user

Re: [Qgis-user] How to edit repetitive data in QGIS

Hi! Instead of editing the lines or attributes with all that work you can do this in the styling. In the labels tab of the layer properties there are rendering options. There is a checkbox for merging connected lines to avoid duplicate labels. Hope this works. Karl-Magnus Jönsson

[Qgis-user] Checking validity

maintaining/updating/editing data. Then it gets more complicated. Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information Kristianstads kommun 291 80 Kristianstad ___ Qgis-user mailing list Qgis-user

Re: [Qgis-user] Jointure request

Hi, How do you do the spatial join? Are you using a database? Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Erwan Conseil Skickat: den 13 oktober 2016 13:02 Till: qgis-user@lists.osgeo.org Ämne: Re: [Qgis-user] Jointure

Re: [Qgis-user] Project CRS doesn't update when layer is added

member witch option that is default from installation. Karl-Magnus Jönsson -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Lee Hachadoorian Skickat: den 10 oktober 2016 05:35 Till: qgis-user@lists.osgeo.org Ämne: [Qgis-user] Project CRS doesn't

Re: [Qgis-user] [Qgis-developer] Discussion on the QGIS grant proposals

features more easily funded in other ways. Regards Karl-Magnus Jönsson Kristianstads kommun -Ursprungligt meddelande- Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] För Vincent Picavet (ml) Skickat: den 22 september 2016 10:10 Till: Neumann, Andreas; QGIS Developers List; QGIS User

[Qgis-user] Update multiple features in relation

Hi! I'd like to update all related records(children) in a sub form. Is there a way to do that? To have the Field calculator in the sub form would be a nice solution. But it isn't there (yet). Does anyone have a workaround? /Karl-Magnus Jönsson

Re: [Qgis-user] Transaction groups in 2.16

s. Column definition: anvandare character varying(20) DEFAULT "current_user"(), Then QGIS tries to insert my user name as a string without '' resulting in not finding any column with my user name. Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Ge

[Qgis-user] Transaction groups in 2.16

Hi! I can’t find the option for transaction groups in QGIS 2.16.2. I should be in Settings -> Options -> Data Sources. Is there in 2.14 anyway. I’d like to try it out. Anyone who knows about it? Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Geog

Re: [Qgis-user] Auto-fill id in attribute table when creating a feature

/qgis_configuration.html#options Karl-Magnus Jönsson Från: Simon Muirhead [mailto:si...@simsurf.com.au] Skickat: den 31 maj 2016 15:27 Till: Karl-Magnus Jönsson Ämne: Re: SV: [Qgis-user] Auto-fill id in attribute table when creating a feature Hi Karl, it won't let you create a shape file without at least one

Re: [Qgis-user] Auto-fill id in attribute table when creating a feature

Hi! Do you really need the ID field in the shapefile? If not you can drop it, hide it or ignore it and it works anyway. If you need a counter as primary key consider using another data provider suggested by Andreas. Karl-Magnus Jönsson Från: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org

Re: [Qgis-user] Project file data loss

and backups have saved us several times. Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information Kristianstads kommun 291 80 Kristianstad Besöksadress: Västra Storgatan 12 Tel 044-13 54 16 │ Mobil: 0733-13 54 16 │karl-magnus.jons

Re: [Qgis-user] Atlas: Filter Empty Pages

the order in "OVER()". o.id and s.id is just what I use to sort on in my tables. Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information Kristianstads kommun 291 80 Kristianstad Besöksadress: Västra Storgatan 12 Tel 044-13 54 16 │ Mobil:

Re: [Qgis-user] DB Manager geometry problems

Hi Chris Appears that the user can’t access the view geometry_columns in the public schema. The information is accessed from there. Grant select privileges. Karl-Magnus Jönsson │GIS-utvecklare Miljö- och samhällsbyggnadsförvaltningen, avd. Geografisk information Kristianstads kommun 291 80