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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
.
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
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
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
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
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
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:
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
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
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
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
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
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
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:
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
(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
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
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
. 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
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
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
-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
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
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
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
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.
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
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
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?
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
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
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
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
Ä
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
, 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
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
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
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
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
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
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
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
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
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
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
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
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
/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
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
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
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:
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
69 matches
Mail list logo